type
Post
Created date
Oct 8, 2022 03:44 AM
category
Business
tags
Decision Making
status
Published
Language
English
From
School
summary
slug
password
Author
Priority
Featured
Featured
Cover
Origin
Type
URL
Youtube
Youtube
icon
Lecture example 1: Finding optimal order & Annual cost (Ordering Paper For MetroBank)
![notion image](https://www.notion.so/image/https%3A%2F%2Ffile.notion.so%2Ff%2Ff%2Fe1c5ba0e-562a-49b0-8505-ce5e38fc061b%2Fa05bd940-f5a6-47be-837c-3bb690ba62c8%2FUntitled.png%3Ftable%3Dblock%26id%3Ddc99e1e7-3f37-4c85-ad40-e2037bd7effa%26spaceId%3De1c5ba0e-562a-49b0-8505-ce5e38fc061b%26expirationTimestamp%3D1725652800000%26signature%3DnZZGTft4Vd7Si5Blaa8jprzlQEZoaKRjQwCKVsCBiUE?table=block&id=dc99e1e7-3f37-4c85-ad40-e2037bd7effa&cache=v2)
- What is the Q*?
- What is the Total annual cost?
- What is # of orders per year?
- What is time between set-up (Cycle time)?
- If we know the cycle time and Q*, what does the solution tell us?
Solution
![notion image](https://www.notion.so/image/https%3A%2F%2Ffile.notion.so%2Ff%2Ff%2Fe1c5ba0e-562a-49b0-8505-ce5e38fc061b%2F85b8c1e0-599d-44b5-87a5-f9c0d1dc65bd%2FUntitled.png%3Ftable%3Dblock%26id%3D86207347-c3a3-4050-b27e-a261f29e9c20%26spaceId%3De1c5ba0e-562a-49b0-8505-ce5e38fc061b%26expirationTimestamp%3D1725652800000%26signature%3DGiIL5fo4R8_kJK_zmpc7VZXhiKMY_txw86zPoWalKUI?table=block&id=86207347-c3a3-4050-b27e-a261f29e9c20&cache=v2)
![notion image](https://www.notion.so/image/https%3A%2F%2Ffile.notion.so%2Ff%2Ff%2Fe1c5ba0e-562a-49b0-8505-ce5e38fc061b%2Fcfae456f-4276-40cc-b60f-4798132987ed%2FUntitled.png%3Ftable%3Dblock%26id%3D27b92c49-9a30-41de-8880-cec6b35547d0%26spaceId%3De1c5ba0e-562a-49b0-8505-ce5e38fc061b%26expirationTimestamp%3D1725652800000%26signature%3DRBeOpJBMzVfdEYCHyKHFZU_mZtkUh93yqqMnru1GXus?table=block&id=27b92c49-9a30-41de-8880-cec6b35547d0&cache=v2)
![notion image](https://www.notion.so/image/https%3A%2F%2Ffile.notion.so%2Ff%2Ff%2Fe1c5ba0e-562a-49b0-8505-ce5e38fc061b%2F9fc5fb5e-6b64-4c8a-9fbf-59cceb15ce65%2FUntitled.png%3Ftable%3Dblock%26id%3Db3e12043-9c15-4fe9-b634-815dc894420d%26spaceId%3De1c5ba0e-562a-49b0-8505-ce5e38fc061b%26expirationTimestamp%3D1725652800000%26signature%3D3Gv0dD6Xqb7dJTpW-x62nSIIni3FTC1si7PlA8bmmXY?table=block&id=b3e12043-9c15-4fe9-b634-815dc894420d&cache=v2)
What happens if we change the order quantity to 600?
Very little change in Total Costs, but perhaps more convenient
Lecture example 2: Finding optimal order & Annual cost(Bart’s Barometer Business)
![notion image](https://www.notion.so/image/https%3A%2F%2Ffile.notion.so%2Ff%2Ff%2Fe1c5ba0e-562a-49b0-8505-ce5e38fc061b%2Ffeff51c7-0553-4261-baa4-60958ab94277%2FUntitled.png%3Ftable%3Dblock%26id%3Dde9c800b-1354-4697-bf24-d3ab69ef651c%26spaceId%3De1c5ba0e-562a-49b0-8505-ce5e38fc061b%26expirationTimestamp%3D1725652800000%26signature%3DZ7MYWt9wY3YhGMBrgMkBiROkUIlZWQNWekmTAmW_kgs?table=block&id=de9c800b-1354-4697-bf24-d3ab69ef651c&cache=v2)
- What is the Q*?
- What is the Total annual cost?
- What is # of orders per year?
- What is time between set-up (Cycle time)?
- If we know the cycle time and Q*, what does the solution tell us?
Solution
![notion image](https://www.notion.so/image/https%3A%2F%2Ffile.notion.so%2Ff%2Ff%2Fe1c5ba0e-562a-49b0-8505-ce5e38fc061b%2F61a42eef-cb8c-4557-a6a8-2bac5fdd2af9%2FUntitled.png%3Ftable%3Dblock%26id%3D90e0408d-415c-45fa-b3c2-cf733ed4291c%26spaceId%3De1c5ba0e-562a-49b0-8505-ce5e38fc061b%26expirationTimestamp%3D1725652800000%26signature%3DJjENjmqooFB0nw0sIUAqcJXr909pKl7xoO97OfmMbSE?table=block&id=90e0408d-415c-45fa-b3c2-cf733ed4291c&cache=v2)
![per year](https://www.notion.so/image/https%3A%2F%2Ffile.notion.so%2Ff%2Ff%2Fe1c5ba0e-562a-49b0-8505-ce5e38fc061b%2Fb46582d3-1816-4798-b56c-2b473aa0bf2c%2FUntitled.png%3Ftable%3Dblock%26id%3D86a97978-b506-4a82-98c0-921497b17be4%26spaceId%3De1c5ba0e-562a-49b0-8505-ce5e38fc061b%26expirationTimestamp%3D1725652800000%26signature%3DXn6bicpzXBK-sfTYvP-6LOtx4RL1DEU1EnRAgfqnpvE?table=block&id=86a97978-b506-4a82-98c0-921497b17be4&cache=v2)
![for working days](https://www.notion.so/image/https%3A%2F%2Ffile.notion.so%2Ff%2Ff%2Fe1c5ba0e-562a-49b0-8505-ce5e38fc061b%2F039d8fb6-958f-4943-b7f8-119725abb6f0%2FUntitled.png%3Ftable%3Dblock%26id%3Dd936b09e-07b8-4676-a10b-4f2dcfc5dcaf%26spaceId%3De1c5ba0e-562a-49b0-8505-ce5e38fc061b%26expirationTimestamp%3D1725652800000%26signature%3DTv_7_P6wDc6b_9t7cOoeKWQeMVm2qUP_h2ReM5vHFes?table=block&id=d936b09e-07b8-4676-a10b-4f2dcfc5dcaf&cache=v2)
Lecture example 2: Lead time change variation (Bart’s Barometer Business)
![notion image](https://www.notion.so/image/https%3A%2F%2Ffile.notion.so%2Ff%2Ff%2Fe1c5ba0e-562a-49b0-8505-ce5e38fc061b%2Fb223d92b-9d7d-4511-8f35-3c66665bec8d%2FUntitled.png%3Ftable%3Dblock%26id%3D54cad4a6-5662-47fe-8ce5-4453942c9cc5%26spaceId%3De1c5ba0e-562a-49b0-8505-ce5e38fc061b%26expirationTimestamp%3D1725652800000%26signature%3DMxJwTOyDIdMFuhwz1OpusCBuP2mm3o01VN387iaOW6s?table=block&id=54cad4a6-5662-47fe-8ce5-4453942c9cc5&cache=v2)
Solution
![notion image](https://www.notion.so/image/https%3A%2F%2Ffile.notion.so%2Ff%2Ff%2Fe1c5ba0e-562a-49b0-8505-ce5e38fc061b%2Fe08ea2e8-e288-4b0f-8818-d25e88c2c914%2FUntitled.png%3Ftable%3Dblock%26id%3D79717eb3-4ecc-4ce7-b545-535119db827e%26spaceId%3De1c5ba0e-562a-49b0-8505-ce5e38fc061b%26expirationTimestamp%3D1725652800000%26signature%3DZLj9LWMZNgKPMD82nVe8AMvwq2tuOWXNtUKPxjmq6xg?table=block&id=79717eb3-4ecc-4ce7-b545-535119db827e&cache=v2)
Lecture example 3: EOQ with Planned Shortages With backorder!(Hervis Rent-a-Car)
![notion image](https://www.notion.so/image/https%3A%2F%2Ffile.notion.so%2Ff%2Ff%2Fe1c5ba0e-562a-49b0-8505-ce5e38fc061b%2Fabeee92c-a423-4fdb-9c5a-352f8fdf3148%2FUntitled.png%3Ftable%3Dblock%26id%3D946145be-ec21-42a5-ab53-944edda72723%26spaceId%3De1c5ba0e-562a-49b0-8505-ce5e38fc061b%26expirationTimestamp%3D1725652800000%26signature%3DwqG34mRDqQFdsKweZqRJRl_NEfYVV6KuWvP-5wEEu8k?table=block&id=946145be-ec21-42a5-ab53-944edda72723&cache=v2)
Solution
![notion image](https://www.notion.so/image/https%3A%2F%2Ffile.notion.so%2Ff%2Ff%2Fe1c5ba0e-562a-49b0-8505-ce5e38fc061b%2F84a9a44b-871d-43a3-b310-329cace607dd%2FUntitled.png%3Ftable%3Dblock%26id%3Da2abdc68-f4b5-4a96-a51b-4ae8a0d584bc%26spaceId%3De1c5ba0e-562a-49b0-8505-ce5e38fc061b%26expirationTimestamp%3D1725652800000%26signature%3D-bSu_uAfR0eX9aDwnS0pqGvDcrhKxhZNpK48vtOh1L8?table=block&id=a2abdc68-f4b5-4a96-a51b-4ae8a0d584bc&cache=v2)
![notion image](https://www.notion.so/image/https%3A%2F%2Ffile.notion.so%2Ff%2Ff%2Fe1c5ba0e-562a-49b0-8505-ce5e38fc061b%2F2ff5e8b9-9d52-4aa5-9793-1f41a81e2b81%2FUntitled.png%3Ftable%3Dblock%26id%3D4826e15a-722f-44c9-a597-b2400ead69e8%26spaceId%3De1c5ba0e-562a-49b0-8505-ce5e38fc061b%26expirationTimestamp%3D1725652800000%26signature%3DNqFrofuNHFoTH_bhjPjouymRlitmVA1bgp9fJdcFyvM?table=block&id=4826e15a-722f-44c9-a597-b2400ead69e8&cache=v2)
How many days after receiving an order does Hervis run out of engines? How long is Hervis without any engines per cycle?
![notion image](https://www.notion.so/image/https%3A%2F%2Ffile.notion.so%2Ff%2Ff%2Fe1c5ba0e-562a-49b0-8505-ce5e38fc061b%2F00069e3c-c87b-4743-8295-be6bbfb4c18b%2FUntitled.png%3Ftable%3Dblock%26id%3Dc96e3a9d-1d68-4035-bba0-d6b52a9466ba%26spaceId%3De1c5ba0e-562a-49b0-8505-ce5e38fc061b%26expirationTimestamp%3D1725652800000%26signature%3Dik65P2GrrITC953A4oRt40BzuESrmsa2t2BoJ1Jlmnw?table=block&id=c96e3a9d-1d68-4035-bba0-d6b52a9466ba&cache=v2)
![notion image](https://www.notion.so/image/https%3A%2F%2Ffile.notion.so%2Ff%2Ff%2Fe1c5ba0e-562a-49b0-8505-ce5e38fc061b%2Ff1ee4b2a-ac79-401f-82ba-6a3f08c30463%2FUntitled.png%3Ftable%3Dblock%26id%3D8124bd63-615d-468f-9ff6-9df1c2b73898%26spaceId%3De1c5ba0e-562a-49b0-8505-ce5e38fc061b%26expirationTimestamp%3D1725652800000%26signature%3Dwd6zeIvvpc05A0sgxtPGf-f5H95shhCCiEQCyRUwHXs?table=block&id=8124bd63-615d-468f-9ff6-9df1c2b73898&cache=v2)
Lecture example 4: EOQ with Quantity Discounts (Nick’s Camera Shop)
![notion image](https://www.notion.so/image/https%3A%2F%2Ffile.notion.so%2Ff%2Ff%2Fe1c5ba0e-562a-49b0-8505-ce5e38fc061b%2F6dd364ad-4c9e-42f6-a4f7-ac0afe741c0a%2FUntitled.png%3Ftable%3Dblock%26id%3D6037de23-8b71-427a-bbae-8214639af909%26spaceId%3De1c5ba0e-562a-49b0-8505-ce5e38fc061b%26expirationTimestamp%3D1725652800000%26signature%3DCU9LrDgfzTODIRymlkDf4nTKF7ZsNeYVRwOV4lZtS9s?table=block&id=6037de23-8b71-427a-bbae-8214639af909&cache=v2)
Compared to the total cost of all three models, which one should Nick choose?
Solution
![notion image](https://www.notion.so/image/https%3A%2F%2Ffile.notion.so%2Ff%2Ff%2Fe1c5ba0e-562a-49b0-8505-ce5e38fc061b%2F788dc859-7a58-43d2-9266-9e62028009d3%2FUntitled.png%3Ftable%3Dblock%26id%3D10785a75-35aa-4324-ac68-4571638949af%26spaceId%3De1c5ba0e-562a-49b0-8505-ce5e38fc061b%26expirationTimestamp%3D1725652800000%26signature%3DLNu6su6yiC-qAiw5fEC4_Bix-9_tEMrHcvJqooreabo?table=block&id=10785a75-35aa-4324-ac68-4571638949af&cache=v2)
![notion image](https://www.notion.so/image/https%3A%2F%2Ffile.notion.so%2Ff%2Ff%2Fe1c5ba0e-562a-49b0-8505-ce5e38fc061b%2Fde15bbbe-d51c-40af-b4fe-bc32ada7cf7d%2FUntitled.png%3Ftable%3Dblock%26id%3Db25abbd9-08ad-4a8c-ac65-48ae0f55223c%26spaceId%3De1c5ba0e-562a-49b0-8505-ce5e38fc061b%26expirationTimestamp%3D1725652800000%26signature%3DuKkC5jZZmdSZ5iyECc8jpTZPVgtrvqoYh5oWM1iqI_U?table=block&id=b25abbd9-08ad-4a8c-ac65-48ae0f55223c&cache=v2)
![notion image](https://www.notion.so/image/https%3A%2F%2Ffile.notion.so%2Ff%2Ff%2Fe1c5ba0e-562a-49b0-8505-ce5e38fc061b%2F1e9bc9ab-3bbc-4c6b-beae-5320886aba2c%2FUntitled.png%3Ftable%3Dblock%26id%3D19fd8d78-c4c6-4369-a85e-210a72f1d4eb%26spaceId%3De1c5ba0e-562a-49b0-8505-ce5e38fc061b%26expirationTimestamp%3D1725652800000%26signature%3DCKPmomv54hvFEZFqrqJTRcQrDFLRidjFiL5Ra_tRdt4?table=block&id=19fd8d78-c4c6-4369-a85e-210a72f1d4eb&cache=v2)
![notion image](https://www.notion.so/image/https%3A%2F%2Ffile.notion.so%2Ff%2Ff%2Fe1c5ba0e-562a-49b0-8505-ce5e38fc061b%2F52cb1129-5199-4dad-a91c-b844eb24d442%2FUntitled.png%3Ftable%3Dblock%26id%3Ddc85fc07-3689-43a9-a495-83dc3cbf5ef1%26spaceId%3De1c5ba0e-562a-49b0-8505-ce5e38fc061b%26expirationTimestamp%3D1725652800000%26signature%3DJbeER7MiPtfxsy2lmJTRSiIrPO_NAgDfwi9jJSl7MiA?table=block&id=dc85fc07-3689-43a9-a495-83dc3cbf5ef1&cache=v2)
![notion image](https://www.notion.so/image/https%3A%2F%2Ffile.notion.so%2Ff%2Ff%2Fe1c5ba0e-562a-49b0-8505-ce5e38fc061b%2F7cc2114a-83cb-408e-92cd-0e07622504f2%2FUntitled.png%3Ftable%3Dblock%26id%3Ddee29705-823b-45b2-aed3-3c6f9c75f17a%26spaceId%3De1c5ba0e-562a-49b0-8505-ce5e38fc061b%26expirationTimestamp%3D1725652800000%26signature%3Dy3fJKqiEa6mpYF3q4bHUgbw37IxNOOZyMaO0UGIT2Hs?table=block&id=dee29705-823b-45b2-aed3-3c6f9c75f17a&cache=v2)
![notion image](https://www.notion.so/image/https%3A%2F%2Ffile.notion.so%2Ff%2Ff%2Fe1c5ba0e-562a-49b0-8505-ce5e38fc061b%2F90e61092-2e38-41b3-a99b-be72565f3d0c%2FUntitled.png%3Ftable%3Dblock%26id%3Dccaef1be-6895-49ee-8ee6-c8aeceb57c20%26spaceId%3De1c5ba0e-562a-49b0-8505-ce5e38fc061b%26expirationTimestamp%3D1725652800000%26signature%3DiGdCZ9GKI9kwKMnCD7R0Dz6GZvETnm65Lfs_ud5R9zA?table=block&id=ccaef1be-6895-49ee-8ee6-c8aeceb57c20&cache=v2)
Lecture example 5: Economic Production Lot Size
![notion image](https://www.notion.so/image/https%3A%2F%2Ffile.notion.so%2Ff%2Ff%2Fe1c5ba0e-562a-49b0-8505-ce5e38fc061b%2F6034f17d-be20-469b-ac6d-b4232f951a90%2FUntitled.png%3Ftable%3Dblock%26id%3D6dbb42bd-9231-4113-b867-393a8342b5d2%26spaceId%3De1c5ba0e-562a-49b0-8505-ce5e38fc061b%26expirationTimestamp%3D1725652800000%26signature%3DIGOxsxYq7SBbxnwz9Egv2tZ0eV5l_oP3CtxrRc5xvys?table=block&id=6dbb42bd-9231-4113-b867-393a8342b5d2&cache=v2)
What are the Q*, Total annual cost, # of production run per year?
![notion image](https://www.notion.so/image/https%3A%2F%2Ffile.notion.so%2Ff%2Ff%2Fe1c5ba0e-562a-49b0-8505-ce5e38fc061b%2F031917fd-8124-4334-9b80-d8febf3fb3d1%2FUntitled.png%3Ftable%3Dblock%26id%3Dee9912f2-9149-4cb9-bc0e-c99a0c6e03ae%26spaceId%3De1c5ba0e-562a-49b0-8505-ce5e38fc061b%26expirationTimestamp%3D1725652800000%26signature%3DPJmY_Qko-ERKny_Z0QdHt42rLyLRq6548a2xyXfkCS8?table=block&id=ee9912f2-9149-4cb9-bc0e-c99a0c6e03ae&cache=v2)
What are the total annual variable cost?
![notion image](https://www.notion.so/image/https%3A%2F%2Ffile.notion.so%2Ff%2Ff%2Fe1c5ba0e-562a-49b0-8505-ce5e38fc061b%2F3bcfeb41-25c9-4b3e-9300-497ef922ba49%2FUntitled.png%3Ftable%3Dblock%26id%3D04051b18-d8ba-46c6-8c26-07a075bc9e03%26spaceId%3De1c5ba0e-562a-49b0-8505-ce5e38fc061b%26expirationTimestamp%3D1725652800000%26signature%3DK6QcBOMYelimxpSO7C1IE-SyjdMPVcU03LVgwYKbOBw?table=block&id=04051b18-d8ba-46c6-8c26-07a075bc9e03&cache=v2)
Q1: Finding optimal order & Annual cost
![notion image](https://www.notion.so/image/https%3A%2F%2Ffile.notion.so%2Ff%2Ff%2Fe1c5ba0e-562a-49b0-8505-ce5e38fc061b%2F23e8cbb6-d9ae-48c0-bcec-7455896da8c5%2FUntitled.png%3Ftable%3Dblock%26id%3D7484ac1a-287e-46fd-862f-95574e57dc67%26spaceId%3De1c5ba0e-562a-49b0-8505-ce5e38fc061b%26expirationTimestamp%3D1725652800000%26signature%3DuqQmPMmKkEN9T29j4RdfZGcQ6YttMIwHoR2EnA6hepk?table=block&id=7484ac1a-287e-46fd-862f-95574e57dc67&cache=v2)
Solution
![notion image](https://www.notion.so/image/https%3A%2F%2Ffile.notion.so%2Ff%2Ff%2Fe1c5ba0e-562a-49b0-8505-ce5e38fc061b%2Fbd93d213-c1da-49e6-b2de-921c07ed3546%2FUntitled.png%3Ftable%3Dblock%26id%3D0df71ddb-91cb-4162-a920-269242c59f93%26spaceId%3De1c5ba0e-562a-49b0-8505-ce5e38fc061b%26expirationTimestamp%3D1725652800000%26signature%3DuF5fVYlgGi5v--wtCftB50M5LKssAl8t3xkibCn8W-Y?table=block&id=0df71ddb-91cb-4162-a920-269242c59f93&cache=v2)
Solution for excel
![notion image](https://www.notion.so/image/https%3A%2F%2Ffile.notion.so%2Ff%2Ff%2Fe1c5ba0e-562a-49b0-8505-ce5e38fc061b%2F03746cb3-6f42-4245-bb22-a45c89ac708c%2FUntitled.png%3Ftable%3Dblock%26id%3D1eddee7d-ee1a-46f4-b4d8-9183b383b284%26spaceId%3De1c5ba0e-562a-49b0-8505-ce5e38fc061b%26expirationTimestamp%3D1725652800000%26signature%3DbGev493siqblsUfh1cof-HwAFrc8B9pFeobHNWWYP1M?table=block&id=1eddee7d-ee1a-46f4-b4d8-9183b383b284&cache=v2)
Q2: EOQ with Quantity Discounts (題型:Range)
![notion image](https://www.notion.so/image/https%3A%2F%2Ffile.notion.so%2Ff%2Ff%2Fe1c5ba0e-562a-49b0-8505-ce5e38fc061b%2Fbe860b67-65ae-433a-845a-c53993c457dc%2FUntitled.png%3Ftable%3Dblock%26id%3D9cde36a9-1dc5-473c-9f61-b43c22e8c506%26spaceId%3De1c5ba0e-562a-49b0-8505-ce5e38fc061b%26expirationTimestamp%3D1725652800000%26signature%3Dkxv0UYoLLG8Ixe7Fm-ST4oFo6Cu999wIvmThb0-s01I?table=block&id=9cde36a9-1dc5-473c-9f61-b43c22e8c506&cache=v2)
Solution
![notion image](https://www.notion.so/image/https%3A%2F%2Ffile.notion.so%2Ff%2Ff%2Fe1c5ba0e-562a-49b0-8505-ce5e38fc061b%2F52231b39-5611-483d-946d-2514d1d09a70%2FUntitled.png%3Ftable%3Dblock%26id%3D95ec8e97-fd60-41b0-95f7-a086ea7604cf%26spaceId%3De1c5ba0e-562a-49b0-8505-ce5e38fc061b%26expirationTimestamp%3D1725652800000%26signature%3DIyyanuku5KhaKWIvbYYWQRzGmX9TUhoxuLicqf6-RIQ?table=block&id=95ec8e97-fd60-41b0-95f7-a086ea7604cf&cache=v2)
Solution (2a) for excel
![notion image](https://www.notion.so/image/https%3A%2F%2Ffile.notion.so%2Ff%2Ff%2Fe1c5ba0e-562a-49b0-8505-ce5e38fc061b%2F4fbf6b5c-8b37-4e58-bb3a-03ca9aad84c0%2FUntitled.png%3Ftable%3Dblock%26id%3Dbb9b0af1-c6a9-4d46-a72a-c7bc2387b33b%26spaceId%3De1c5ba0e-562a-49b0-8505-ce5e38fc061b%26expirationTimestamp%3D1725652800000%26signature%3DQgWtQmGt5sIvW7gFT7QBXbI9e8KacLZfoU36oh00_i8?table=block&id=bb9b0af1-c6a9-4d46-a72a-c7bc2387b33b&cache=v2)
Solution (2b) for excel
![notion image](https://www.notion.so/image/https%3A%2F%2Ffile.notion.so%2Ff%2Ff%2Fe1c5ba0e-562a-49b0-8505-ce5e38fc061b%2F4c36676e-1466-4c11-a837-8d90277a7613%2FUntitled.png%3Ftable%3Dblock%26id%3D92a301f9-1441-4a89-bcfc-9cccdd401b57%26spaceId%3De1c5ba0e-562a-49b0-8505-ce5e38fc061b%26expirationTimestamp%3D1725652800000%26signature%3DLFnhau3VyeWxGgmkrgLQKhLaSf4VyW9LGzSjx1ihjjs?table=block&id=92a301f9-1441-4a89-bcfc-9cccdd401b57&cache=v2)
Q3: Finding optimal order & Annual cost
![notion image](https://www.notion.so/image/https%3A%2F%2Ffile.notion.so%2Ff%2Ff%2Fe1c5ba0e-562a-49b0-8505-ce5e38fc061b%2Fe1089e9b-8830-4950-a61f-a7a766e14ffe%2FUntitled.png%3Ftable%3Dblock%26id%3D16bc890a-3c11-4c80-bf82-bebaa898bede%26spaceId%3De1c5ba0e-562a-49b0-8505-ce5e38fc061b%26expirationTimestamp%3D1725652800000%26signature%3DU0TieeWlX8XklghQHQfpbE0CM-I9aQo8tQQP0VysHwc?table=block&id=16bc890a-3c11-4c80-bf82-bebaa898bede&cache=v2)
Solution
![notion image](https://www.notion.so/image/https%3A%2F%2Ffile.notion.so%2Ff%2Ff%2Fe1c5ba0e-562a-49b0-8505-ce5e38fc061b%2F72d3f1d4-6558-4929-baf1-9f492e3a440a%2FUntitled.png%3Ftable%3Dblock%26id%3Dfc567000-ab93-4bde-abbc-0c34e772d0d9%26spaceId%3De1c5ba0e-562a-49b0-8505-ce5e38fc061b%26expirationTimestamp%3D1725652800000%26signature%3Dw-gjFftEfrjOOmSfmUsT2ZBxWX4GxojA8GxZVO5SGsc?table=block&id=fc567000-ab93-4bde-abbc-0c34e772d0d9&cache=v2)
Solution for excel
![notion image](https://www.notion.so/image/https%3A%2F%2Ffile.notion.so%2Ff%2Ff%2Fe1c5ba0e-562a-49b0-8505-ce5e38fc061b%2Fd3ad694a-a9cc-4812-89fd-1d4aac96b14d%2FUntitled.png%3Ftable%3Dblock%26id%3D10a3bf7c-7000-4b1d-ad38-bd26e413572e%26spaceId%3De1c5ba0e-562a-49b0-8505-ce5e38fc061b%26expirationTimestamp%3D1725652800000%26signature%3DqWacTZ01P-ixhBGO6X0Wqp6H0moCgxIXDtmOA0VO_V0?table=block&id=10a3bf7c-7000-4b1d-ad38-bd26e413572e&cache=v2)
Q4: EOQ with Planned Shortages With backorder
![notion image](https://www.notion.so/image/https%3A%2F%2Ffile.notion.so%2Ff%2Ff%2Fe1c5ba0e-562a-49b0-8505-ce5e38fc061b%2Fa68d57e6-42e4-4c20-92ac-558187e28fab%2FUntitled.png%3Ftable%3Dblock%26id%3D270dad5a-6194-4e68-906e-84b061e8cbf3%26spaceId%3De1c5ba0e-562a-49b0-8505-ce5e38fc061b%26expirationTimestamp%3D1725652800000%26signature%3DrAIK4-nda8y9clW0qgSQ_eN3_opT80s91j7b0r3unzc?table=block&id=270dad5a-6194-4e68-906e-84b061e8cbf3&cache=v2)
Solution
![notion image](https://www.notion.so/image/https%3A%2F%2Ffile.notion.so%2Ff%2Ff%2Fe1c5ba0e-562a-49b0-8505-ce5e38fc061b%2F72f97f4d-c8f4-49ee-96f3-441f9fcab734%2FUntitled.png%3Ftable%3Dblock%26id%3Db2e94c3e-8995-4b3e-87e3-1c13a4ffaa1e%26spaceId%3De1c5ba0e-562a-49b0-8505-ce5e38fc061b%26expirationTimestamp%3D1725652800000%26signature%3DIyuGFCIs7_a4bx7TPHvVf1GvcNtZFWT_q24T7tVADQY?table=block&id=b2e94c3e-8995-4b3e-87e3-1c13a4ffaa1e&cache=v2)
Solution for excel
![notion image](https://www.notion.so/image/https%3A%2F%2Ffile.notion.so%2Ff%2Ff%2Fe1c5ba0e-562a-49b0-8505-ce5e38fc061b%2F0f60f30e-1182-4f4d-a5cf-1eb1949078b1%2FUntitled.png%3Ftable%3Dblock%26id%3D2e75b923-d90e-4113-9042-e25c768583f0%26spaceId%3De1c5ba0e-562a-49b0-8505-ce5e38fc061b%26expirationTimestamp%3D1725652800000%26signature%3D8puIItDMxHF3O2YZD0-cuDthEJUGJzlj4f6mWygqVDg?table=block&id=2e75b923-d90e-4113-9042-e25c768583f0&cache=v2)
Q5: Economic Production Lot Size
![notion image](https://www.notion.so/image/https%3A%2F%2Ffile.notion.so%2Ff%2Ff%2Fe1c5ba0e-562a-49b0-8505-ce5e38fc061b%2Fb3c3973f-e7d7-4bc1-b0c0-c424fe585b5e%2FUntitled.png%3Ftable%3Dblock%26id%3Da8169bda-3565-474a-94c8-fae0f34d21a6%26spaceId%3De1c5ba0e-562a-49b0-8505-ce5e38fc061b%26expirationTimestamp%3D1725652800000%26signature%3D7Lq0lcMsWLFkD4zng1OckRc9wpuBK-bVWHavvtgpawQ?table=block&id=a8169bda-3565-474a-94c8-fae0f34d21a6&cache=v2)
Solution
![notion image](https://www.notion.so/image/https%3A%2F%2Ffile.notion.so%2Ff%2Ff%2Fe1c5ba0e-562a-49b0-8505-ce5e38fc061b%2Fdf4d1540-a143-415b-b70b-a86f37022dce%2FUntitled.png%3Ftable%3Dblock%26id%3Dcb14d1c9-385f-497f-b6c1-e0c7b5a8a6ca%26spaceId%3De1c5ba0e-562a-49b0-8505-ce5e38fc061b%26expirationTimestamp%3D1725652800000%26signature%3DglOAi5DW3O4dQc-WJoDVjM0FdNnmuiFUYVxYtC3ZMYQ?table=block&id=cb14d1c9-385f-497f-b6c1-e0c7b5a8a6ca&cache=v2)
Textbook: Quantity Discounts for the EOQ Model (題型:Range)
![notion image](https://www.notion.so/image/https%3A%2F%2Ffile.notion.so%2Ff%2Ff%2Fe1c5ba0e-562a-49b0-8505-ce5e38fc061b%2F3dd7925b-f2bb-4827-8972-bad9ed951873%2FUntitled.png%3Ftable%3Dblock%26id%3D6e684772-c589-4a1c-9d0a-6bc8ff76ad86%26spaceId%3De1c5ba0e-562a-49b0-8505-ce5e38fc061b%26expirationTimestamp%3D1725652800000%26signature%3Dn-N6GpIN5Bu4q5UusIaFzIiNnVHs2WstGP4Zt0Ds7kk?table=block&id=6e684772-c589-4a1c-9d0a-6bc8ff76ad86&cache=v2)
Solution
![notion image](https://www.notion.so/image/https%3A%2F%2Ffile.notion.so%2Ff%2Ff%2Fe1c5ba0e-562a-49b0-8505-ce5e38fc061b%2F0b18f4dc-3e9a-4806-b218-39668d57ac5a%2FUntitled.png%3Ftable%3Dblock%26id%3D5e9f05b9-0c1b-4071-ac54-0b6e2d7cf729%26spaceId%3De1c5ba0e-562a-49b0-8505-ce5e38fc061b%26expirationTimestamp%3D1725652800000%26signature%3D7cf_1IfH6UUWTugR5ILgmxjb3tcuwUerZj03qmPlj60?table=block&id=5e9f05b9-0c1b-4071-ac54-0b6e2d7cf729&cache=v2)
![notion image](https://www.notion.so/image/https%3A%2F%2Ffile.notion.so%2Ff%2Ff%2Fe1c5ba0e-562a-49b0-8505-ce5e38fc061b%2Ffefdeace-48d9-4b7d-ac7e-3280b993ad40%2FUntitled.png%3Ftable%3Dblock%26id%3D17062219-5b9f-4e5b-9f77-1078115ee09d%26spaceId%3De1c5ba0e-562a-49b0-8505-ce5e38fc061b%26expirationTimestamp%3D1725652800000%26signature%3DsHVCeL-CqJH9dePZEtuJF4UMCzd_6NTO1JSvLY2QECQ?table=block&id=17062219-5b9f-4e5b-9f77-1078115ee09d&cache=v2)
![notion image](https://www.notion.so/image/https%3A%2F%2Ffile.notion.so%2Ff%2Ff%2Fe1c5ba0e-562a-49b0-8505-ce5e38fc061b%2F3e2a2108-ca9a-4eb2-b825-adbc07c10635%2FUntitled.png%3Ftable%3Dblock%26id%3D9cc6c59e-8f90-4598-93b8-c9e1dafc3e8c%26spaceId%3De1c5ba0e-562a-49b0-8505-ce5e38fc061b%26expirationTimestamp%3D1725652800000%26signature%3D3qUMiT1hNk01jU235Bls6jQRmUwaE-I78vhO3AyXfkI?table=block&id=9cc6c59e-8f90-4598-93b8-c9e1dafc3e8c&cache=v2)
![notion image](https://www.notion.so/image/https%3A%2F%2Ffile.notion.so%2Ff%2Ff%2Fe1c5ba0e-562a-49b0-8505-ce5e38fc061b%2Fcea9ef9e-c748-4a42-bb72-17745d1150ee%2FUntitled.png%3Ftable%3Dblock%26id%3Ddd84d5fb-d7df-465d-ac99-28b61f16dcf4%26spaceId%3De1c5ba0e-562a-49b0-8505-ce5e38fc061b%26expirationTimestamp%3D1725652800000%26signature%3DyEJknUl6VFynL3nUgY5CDE_lr_TjYc7o8JLxjx1r_II?table=block&id=dd84d5fb-d7df-465d-ac99-28b61f16dcf4&cache=v2)
Textbook: Economic Production Lot Size (題型:Range)
![notion image](https://www.notion.so/image/https%3A%2F%2Ffile.notion.so%2Ff%2Ff%2Fe1c5ba0e-562a-49b0-8505-ce5e38fc061b%2Fca7e8f79-8bb8-42d1-9a85-404e9950ff79%2FUntitled.png%3Ftable%3Dblock%26id%3D0b712779-78e1-4e28-a609-d78765727dc0%26spaceId%3De1c5ba0e-562a-49b0-8505-ce5e38fc061b%26expirationTimestamp%3D1725652800000%26signature%3DT1Nr-jfqZ9seScPZg-jNR3yXAFQa38oO-lmW8NQ_mDc?table=block&id=0b712779-78e1-4e28-a609-d78765727dc0&cache=v2)
Solution (formula might be diff from slides)
![notion image](https://www.notion.so/image/https%3A%2F%2Ffile.notion.so%2Ff%2Ff%2Fe1c5ba0e-562a-49b0-8505-ce5e38fc061b%2F4eb64f5c-c3fa-4c42-aeae-3a50d20a035b%2FUntitled.png%3Ftable%3Dblock%26id%3Dbb024315-d4de-47ef-be98-712f24a2d267%26spaceId%3De1c5ba0e-562a-49b0-8505-ce5e38fc061b%26expirationTimestamp%3D1725652800000%26signature%3DeFysgmFx6DI7iX3MA0DGIHPs6kV04GOJ9pPBF0ytWvY?table=block&id=bb024315-d4de-47ef-be98-712f24a2d267&cache=v2)
What does the lots size and cycle time tell us?
![notion image](https://www.notion.so/image/https%3A%2F%2Ffile.notion.so%2Ff%2Ff%2Fe1c5ba0e-562a-49b0-8505-ce5e38fc061b%2F992443e0-fbf7-449b-8c4b-baeffa176b09%2FUntitled.png%3Ftable%3Dblock%26id%3D9ac52818-4f5d-4365-a9c0-73ce4ff7cc43%26spaceId%3De1c5ba0e-562a-49b0-8505-ce5e38fc061b%26expirationTimestamp%3D1725652800000%26signature%3DypiSuC84pTcxTDZxofk34oGHk1g28ooltuKUGSNmZcA?table=block&id=9ac52818-4f5d-4365-a9c0-73ce4ff7cc43&cache=v2)
Textbook: EOQ with Planned Shortages With backorder (formula might be diff from slides)
![notion image](https://www.notion.so/image/https%3A%2F%2Ffile.notion.so%2Ff%2Ff%2Fe1c5ba0e-562a-49b0-8505-ce5e38fc061b%2F0838193a-1226-4a8c-8ee4-f562549451a0%2FUntitled.png%3Ftable%3Dblock%26id%3D2935888a-6683-4322-8707-27ba2992ffdb%26spaceId%3De1c5ba0e-562a-49b0-8505-ce5e38fc061b%26expirationTimestamp%3D1725652800000%26signature%3DoHfchmsvOPz81IQUkniPRn_oo-bC-hkussgI7FLv3sk?table=block&id=2935888a-6683-4322-8707-27ba2992ffdb&cache=v2)
![notion image](https://www.notion.so/image/https%3A%2F%2Ffile.notion.so%2Ff%2Ff%2Fe1c5ba0e-562a-49b0-8505-ce5e38fc061b%2F9d0ac8a0-5f51-4e3b-b732-96c609270aa2%2FUntitled.png%3Ftable%3Dblock%26id%3D13b61395-de11-4871-9566-40d91d845972%26spaceId%3De1c5ba0e-562a-49b0-8505-ce5e38fc061b%26expirationTimestamp%3D1725652800000%26signature%3D1RIsdo17Q_DhJLCVuqMqsdxZsRunAb1Q41CnPSzvW-w?table=block&id=13b61395-de11-4871-9566-40d91d845972&cache=v2)
What is the maximum number of backorders?
What is the total annual cost?
What is the cycle time?
Solution (formula might be diff from slides)
![notion image](https://www.notion.so/image/https%3A%2F%2Ffile.notion.so%2Ff%2Ff%2Fe1c5ba0e-562a-49b0-8505-ce5e38fc061b%2F908581c6-0f01-4dc7-80db-ce22e827081b%2FUntitled.png%3Ftable%3Dblock%26id%3D19a33486-c27b-4fd9-981c-d0d87fae04af%26spaceId%3De1c5ba0e-562a-49b0-8505-ce5e38fc061b%26expirationTimestamp%3D1725652800000%26signature%3D4lhD6gxC1X_RRVz1aRAydPaFm5htB6PIEZNnDmWkkaU?table=block&id=19a33486-c27b-4fd9-981c-d0d87fae04af&cache=v2)
![notion image](https://www.notion.so/image/https%3A%2F%2Ffile.notion.so%2Ff%2Ff%2Fe1c5ba0e-562a-49b0-8505-ce5e38fc061b%2Feec8425b-17a5-499d-8832-c02c4b5f7494%2FUntitled.png%3Ftable%3Dblock%26id%3D50cc9ad6-2fc5-46f4-976b-dbd9d4ba8e78%26spaceId%3De1c5ba0e-562a-49b0-8505-ce5e38fc061b%26expirationTimestamp%3D1725652800000%26signature%3DsFiWoQfGeeICcGRPojKQd1OwbazvJNEaFCQhUiBu2yU?table=block&id=50cc9ad6-2fc5-46f4-976b-dbd9d4ba8e78&cache=v2)
![notion image](https://www.notion.so/image/https%3A%2F%2Ffile.notion.so%2Ff%2Ff%2Fe1c5ba0e-562a-49b0-8505-ce5e38fc061b%2F5062b2e7-fd84-48b5-833f-22b7ddc5cfd8%2FUntitled.png%3Ftable%3Dblock%26id%3D5d97a863-66a6-4291-9cf8-67e79a079594%26spaceId%3De1c5ba0e-562a-49b0-8505-ce5e38fc061b%26expirationTimestamp%3D1725652800000%26signature%3DEgneDKY8C6PAdB84QRhirvDlvSDNfolu9zdOPAvl5gM?table=block&id=5d97a863-66a6-4291-9cf8-67e79a079594&cache=v2)
![notion image](https://www.notion.so/image/https%3A%2F%2Ffile.notion.so%2Ff%2Ff%2Fe1c5ba0e-562a-49b0-8505-ce5e38fc061b%2F892fd620-4223-4986-bb4b-b1bf948b83b7%2FUntitled.png%3Ftable%3Dblock%26id%3D0b3a7489-7413-4d29-b60f-eb04e3dc4cc9%26spaceId%3De1c5ba0e-562a-49b0-8505-ce5e38fc061b%26expirationTimestamp%3D1725652800000%26signature%3D9xjy2uK5W8JFqaNP7lSP_ZJrHsdbjST3vv0jBwk6HKU?table=block&id=0b3a7489-7413-4d29-b60f-eb04e3dc4cc9&cache=v2)
- Author:Jason Siu
- URL:https://jason-siu.com/article%2Fdde719c0-aee7-441a-998f-8d042be95676
- Copyright:All articles in this blog, except for special statements, adopt BY-NC-SA agreement. Please indicate the source!
Relate Posts
Values alignment - Ray Dalio & Naval Ravikant
The AAA Framework - Ali Abdaal
Bouncing Back with Gain Recovery Calculator: The Art of Recouping Financial Losses in Leveraged Investments
Zero to One Extract: Questions that every business must answer
Life - Principles
I'm a master of analysis, coding is just a bonus!