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%3Fid%3Ddc99e1e7-3f37-4c85-ad40-e2037bd7effa%26table%3Dblock%26spaceId%3De1c5ba0e-562a-49b0-8505-ce5e38fc061b%26expirationTimestamp%3D1721880000000%26signature%3DqvrAuedw3k4di-daNbqzyHpas1nut0Qxd8noT4gxZg0?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%3Fid%3D86207347-c3a3-4050-b27e-a261f29e9c20%26table%3Dblock%26spaceId%3De1c5ba0e-562a-49b0-8505-ce5e38fc061b%26expirationTimestamp%3D1721880000000%26signature%3DUmyyX1PgywtdCNg0tvCSuuabAVmUj2XNcPF-L03_8BE?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%3Fid%3D27b92c49-9a30-41de-8880-cec6b35547d0%26table%3Dblock%26spaceId%3De1c5ba0e-562a-49b0-8505-ce5e38fc061b%26expirationTimestamp%3D1721880000000%26signature%3D583vbl-jqJCLgNdH8XtM_cSbpQa4Aly39lx7EHiix-g?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%3Fid%3Db3e12043-9c15-4fe9-b634-815dc894420d%26table%3Dblock%26spaceId%3De1c5ba0e-562a-49b0-8505-ce5e38fc061b%26expirationTimestamp%3D1721880000000%26signature%3DkzaHvBMMfEfL3GaI-MoxR1ikCo_jIguwqgasymFBRhQ?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%3Fid%3Dde9c800b-1354-4697-bf24-d3ab69ef651c%26table%3Dblock%26spaceId%3De1c5ba0e-562a-49b0-8505-ce5e38fc061b%26expirationTimestamp%3D1721880000000%26signature%3DbaftAMEAaOdIGz1jPBkHphVlEf5V_aB6ij6UUCEfJiU?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%3Fid%3D90e0408d-415c-45fa-b3c2-cf733ed4291c%26table%3Dblock%26spaceId%3De1c5ba0e-562a-49b0-8505-ce5e38fc061b%26expirationTimestamp%3D1721880000000%26signature%3DYJxbLPAgJSaN6VCNSHoi96O2rhC1I0SpS9gZyFM0Hl4?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%3Fid%3D86a97978-b506-4a82-98c0-921497b17be4%26table%3Dblock%26spaceId%3De1c5ba0e-562a-49b0-8505-ce5e38fc061b%26expirationTimestamp%3D1721880000000%26signature%3D-I7we1HoDBNjngBXKcpbEOJRg0nyAcPc3yQCdyK7GAs?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%3Fid%3Dd936b09e-07b8-4676-a10b-4f2dcfc5dcaf%26table%3Dblock%26spaceId%3De1c5ba0e-562a-49b0-8505-ce5e38fc061b%26expirationTimestamp%3D1721880000000%26signature%3Dvy6I0oIpk_Ib__7GE_1lUoY2GQv9Hdu_8W65uDsmW_g?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%3Fid%3D54cad4a6-5662-47fe-8ce5-4453942c9cc5%26table%3Dblock%26spaceId%3De1c5ba0e-562a-49b0-8505-ce5e38fc061b%26expirationTimestamp%3D1721880000000%26signature%3DXI-3iKi7rUxCa3HNYje90yrN61Kyi1nvaLVAkKZyO_I?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%3Fid%3D79717eb3-4ecc-4ce7-b545-535119db827e%26table%3Dblock%26spaceId%3De1c5ba0e-562a-49b0-8505-ce5e38fc061b%26expirationTimestamp%3D1721880000000%26signature%3DjlqXfydmro7hV4M83tOefF1Giv3n41xJptcE4W-XLbA?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%3Fid%3D946145be-ec21-42a5-ab53-944edda72723%26table%3Dblock%26spaceId%3De1c5ba0e-562a-49b0-8505-ce5e38fc061b%26expirationTimestamp%3D1721880000000%26signature%3DJBO_gsahpgvtdDrR3_Qtt_RLP2isKm1-L3cS74QNdl8?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%3Fid%3Da2abdc68-f4b5-4a96-a51b-4ae8a0d584bc%26table%3Dblock%26spaceId%3De1c5ba0e-562a-49b0-8505-ce5e38fc061b%26expirationTimestamp%3D1721880000000%26signature%3Da6UJy1cYA28FUmRz-AsmIN9CBzRusyvuUVZ-1QnS3vM?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%3Fid%3D4826e15a-722f-44c9-a597-b2400ead69e8%26table%3Dblock%26spaceId%3De1c5ba0e-562a-49b0-8505-ce5e38fc061b%26expirationTimestamp%3D1721880000000%26signature%3DbyyYcKSS6_fNw0ylsCTTWP2AjJc95KT87NyKDWu5I94?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%3Fid%3Dc96e3a9d-1d68-4035-bba0-d6b52a9466ba%26table%3Dblock%26spaceId%3De1c5ba0e-562a-49b0-8505-ce5e38fc061b%26expirationTimestamp%3D1721880000000%26signature%3DpotQnDsazCA6jvaglNjRdm4_uCDOcVcAzmn_R2ac-dI?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%3Fid%3D8124bd63-615d-468f-9ff6-9df1c2b73898%26table%3Dblock%26spaceId%3De1c5ba0e-562a-49b0-8505-ce5e38fc061b%26expirationTimestamp%3D1721880000000%26signature%3DhRB8RRwyp_e-TZyXfi7qssk-VhEZQlM9F9LVtz3U0bo?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%3Fid%3D6037de23-8b71-427a-bbae-8214639af909%26table%3Dblock%26spaceId%3De1c5ba0e-562a-49b0-8505-ce5e38fc061b%26expirationTimestamp%3D1721880000000%26signature%3DQnv4vSfK2ErK-OSzmKBt8u2U7ZOHaiYv8OEO2tty8BM?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%3Fid%3D10785a75-35aa-4324-ac68-4571638949af%26table%3Dblock%26spaceId%3De1c5ba0e-562a-49b0-8505-ce5e38fc061b%26expirationTimestamp%3D1721880000000%26signature%3D-QGn48i9BDs-yB4ACZ96fHVhOPQMyiCKSuu3bZ4nwOo?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%3Fid%3Db25abbd9-08ad-4a8c-ac65-48ae0f55223c%26table%3Dblock%26spaceId%3De1c5ba0e-562a-49b0-8505-ce5e38fc061b%26expirationTimestamp%3D1721880000000%26signature%3D5ZROV8MZxHMXPeaLhXrPAZitkmOPO8hnr4JdTVFArPA?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%3Fid%3D19fd8d78-c4c6-4369-a85e-210a72f1d4eb%26table%3Dblock%26spaceId%3De1c5ba0e-562a-49b0-8505-ce5e38fc061b%26expirationTimestamp%3D1721880000000%26signature%3DT7EpgbqjstCG4F4SzfIsickx6eZys9MbCus4sU3H2TE?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%3Fid%3Ddc85fc07-3689-43a9-a495-83dc3cbf5ef1%26table%3Dblock%26spaceId%3De1c5ba0e-562a-49b0-8505-ce5e38fc061b%26expirationTimestamp%3D1721880000000%26signature%3DgPcy7BMONCGsgd8AYe7oLmlY2S6f3Ata8j1KXXsPe4M?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%3Fid%3Ddee29705-823b-45b2-aed3-3c6f9c75f17a%26table%3Dblock%26spaceId%3De1c5ba0e-562a-49b0-8505-ce5e38fc061b%26expirationTimestamp%3D1721880000000%26signature%3D3plig46afVF2uCPd9F0x1AKHke5sdnDJBnz7p1yRXBo?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%3Fid%3Dccaef1be-6895-49ee-8ee6-c8aeceb57c20%26table%3Dblock%26spaceId%3De1c5ba0e-562a-49b0-8505-ce5e38fc061b%26expirationTimestamp%3D1721880000000%26signature%3DDH9IP57CZ8BdurtUJwfgDNFJMVk_G59uyy3tdnfvlGw?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%3Fid%3D6dbb42bd-9231-4113-b867-393a8342b5d2%26table%3Dblock%26spaceId%3De1c5ba0e-562a-49b0-8505-ce5e38fc061b%26expirationTimestamp%3D1721880000000%26signature%3DkMi7oOsIT38RGKwKF-24W-YmW8t-BmTYCFlYBpW8QTY?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%3Fid%3Dee9912f2-9149-4cb9-bc0e-c99a0c6e03ae%26table%3Dblock%26spaceId%3De1c5ba0e-562a-49b0-8505-ce5e38fc061b%26expirationTimestamp%3D1721880000000%26signature%3DsneG7Rmc2TQFUmZ8mPog0AdwtBo1LKvZ9ljz9soAfYk?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%3Fid%3D04051b18-d8ba-46c6-8c26-07a075bc9e03%26table%3Dblock%26spaceId%3De1c5ba0e-562a-49b0-8505-ce5e38fc061b%26expirationTimestamp%3D1721880000000%26signature%3DYOwm7rnZriFtdrIkLaAdm-Idw2TXx3n-I9LxauVrPaU?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%3Fid%3D7484ac1a-287e-46fd-862f-95574e57dc67%26table%3Dblock%26spaceId%3De1c5ba0e-562a-49b0-8505-ce5e38fc061b%26expirationTimestamp%3D1721880000000%26signature%3DIkqYW3_emtMeKeawmA66TxutwRYn1Fqh08qQIiiV0l4?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%3Fid%3D0df71ddb-91cb-4162-a920-269242c59f93%26table%3Dblock%26spaceId%3De1c5ba0e-562a-49b0-8505-ce5e38fc061b%26expirationTimestamp%3D1721880000000%26signature%3DLwqTVglDsScUI8vYm7XHnuKU2MNpzEaP15c2QHpt2xk?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%3Fid%3D1eddee7d-ee1a-46f4-b4d8-9183b383b284%26table%3Dblock%26spaceId%3De1c5ba0e-562a-49b0-8505-ce5e38fc061b%26expirationTimestamp%3D1721880000000%26signature%3DCzn7mICOnGNCf6EjC0riuR3Bdcx0XmDlMZbRfA9h5oo?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%3Fid%3D9cde36a9-1dc5-473c-9f61-b43c22e8c506%26table%3Dblock%26spaceId%3De1c5ba0e-562a-49b0-8505-ce5e38fc061b%26expirationTimestamp%3D1721880000000%26signature%3DcCsmbrJz-xo8tI-F3516nHFd2scT2yRVcLUdZrNdbao?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%3Fid%3D95ec8e97-fd60-41b0-95f7-a086ea7604cf%26table%3Dblock%26spaceId%3De1c5ba0e-562a-49b0-8505-ce5e38fc061b%26expirationTimestamp%3D1721880000000%26signature%3DdHzYHgSCWvgOLFJ0dRn5Nlpa6khP3gUHrCOQzQnm1wI?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%3Fid%3Dbb9b0af1-c6a9-4d46-a72a-c7bc2387b33b%26table%3Dblock%26spaceId%3De1c5ba0e-562a-49b0-8505-ce5e38fc061b%26expirationTimestamp%3D1721880000000%26signature%3DRbOexd5UfvM4g51Z6cauwJ2jg5yASHF-vEb_lcSrpzw?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%3Fid%3D92a301f9-1441-4a89-bcfc-9cccdd401b57%26table%3Dblock%26spaceId%3De1c5ba0e-562a-49b0-8505-ce5e38fc061b%26expirationTimestamp%3D1721880000000%26signature%3DqzTTg-6geX70F5xUfzObTUuzuL_-7I7BAJ64UrdQnlM?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%3Fid%3D16bc890a-3c11-4c80-bf82-bebaa898bede%26table%3Dblock%26spaceId%3De1c5ba0e-562a-49b0-8505-ce5e38fc061b%26expirationTimestamp%3D1721880000000%26signature%3DeM0YDJtB2wrU1FaL_ha7pMiYFpGQBalr0zDfKEhUQVs?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%3Fid%3Dfc567000-ab93-4bde-abbc-0c34e772d0d9%26table%3Dblock%26spaceId%3De1c5ba0e-562a-49b0-8505-ce5e38fc061b%26expirationTimestamp%3D1721880000000%26signature%3DFw4zeEf9Evii9lcZVg0y5loYYuS_KG-wATsrL18AobU?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%3Fid%3D10a3bf7c-7000-4b1d-ad38-bd26e413572e%26table%3Dblock%26spaceId%3De1c5ba0e-562a-49b0-8505-ce5e38fc061b%26expirationTimestamp%3D1721880000000%26signature%3DI8-mto-fnbvXQ3ZQ0CfCsLA5bDbQY53xuIvownmJYZM?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%3Fid%3D270dad5a-6194-4e68-906e-84b061e8cbf3%26table%3Dblock%26spaceId%3De1c5ba0e-562a-49b0-8505-ce5e38fc061b%26expirationTimestamp%3D1721880000000%26signature%3DVx1pNuie3EGipE5WIUJFNUquljc2uUUg1NAxKOsuSlc?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%3Fid%3Db2e94c3e-8995-4b3e-87e3-1c13a4ffaa1e%26table%3Dblock%26spaceId%3De1c5ba0e-562a-49b0-8505-ce5e38fc061b%26expirationTimestamp%3D1721880000000%26signature%3DuaTLo0RLLoDzzEIGpxVvK1w-pP42zFJ0-Q6QcadJjKg?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%3Fid%3D2e75b923-d90e-4113-9042-e25c768583f0%26table%3Dblock%26spaceId%3De1c5ba0e-562a-49b0-8505-ce5e38fc061b%26expirationTimestamp%3D1721880000000%26signature%3DJs9yA54dSs8PguV6HFQZZm79kXArQJ-tCIXqNZohbjs?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%3Fid%3Da8169bda-3565-474a-94c8-fae0f34d21a6%26table%3Dblock%26spaceId%3De1c5ba0e-562a-49b0-8505-ce5e38fc061b%26expirationTimestamp%3D1721880000000%26signature%3DyGlxhfM6MNL3hWTdjqD6GfDmaRP2HaaDrsza0SJZ2M4?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%3Fid%3Dcb14d1c9-385f-497f-b6c1-e0c7b5a8a6ca%26table%3Dblock%26spaceId%3De1c5ba0e-562a-49b0-8505-ce5e38fc061b%26expirationTimestamp%3D1721880000000%26signature%3DHZh7QTiJd28xhV9lhBn7sFwf5rdTQOr0TmiV8k9VVuY?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%3Fid%3D6e684772-c589-4a1c-9d0a-6bc8ff76ad86%26table%3Dblock%26spaceId%3De1c5ba0e-562a-49b0-8505-ce5e38fc061b%26expirationTimestamp%3D1721880000000%26signature%3DJZ00ETKX2K8aADCLihEa74WLCJCTohNXqFw1lQ9zXKs?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%3Fid%3D5e9f05b9-0c1b-4071-ac54-0b6e2d7cf729%26table%3Dblock%26spaceId%3De1c5ba0e-562a-49b0-8505-ce5e38fc061b%26expirationTimestamp%3D1721880000000%26signature%3D7k2ssK3LBhE-E8hRG8doipWhg3KXV8dt_duHEWcGU_4?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%3Fid%3D17062219-5b9f-4e5b-9f77-1078115ee09d%26table%3Dblock%26spaceId%3De1c5ba0e-562a-49b0-8505-ce5e38fc061b%26expirationTimestamp%3D1721880000000%26signature%3DItj3wjzcxPSqEykejYlefQi2yjxYUvb-0nEkKJyh2h4?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%3Fid%3D9cc6c59e-8f90-4598-93b8-c9e1dafc3e8c%26table%3Dblock%26spaceId%3De1c5ba0e-562a-49b0-8505-ce5e38fc061b%26expirationTimestamp%3D1721880000000%26signature%3DyLC-Wn98teZQgZXo0ogEhPUEDHuGvoBgIAK7Y1NqQe8?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%3Fid%3Ddd84d5fb-d7df-465d-ac99-28b61f16dcf4%26table%3Dblock%26spaceId%3De1c5ba0e-562a-49b0-8505-ce5e38fc061b%26expirationTimestamp%3D1721880000000%26signature%3DTwt884h7nR1K9ozR1as2bR9JhPE11VcH_p3TwtLiRnE?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%3Fid%3D0b712779-78e1-4e28-a609-d78765727dc0%26table%3Dblock%26spaceId%3De1c5ba0e-562a-49b0-8505-ce5e38fc061b%26expirationTimestamp%3D1721880000000%26signature%3DLL-BURuhoLL0GqIXLEHlZWcgzKihWaBoH-7JcjgWkTI?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%3Fid%3Dbb024315-d4de-47ef-be98-712f24a2d267%26table%3Dblock%26spaceId%3De1c5ba0e-562a-49b0-8505-ce5e38fc061b%26expirationTimestamp%3D1721880000000%26signature%3DrBuQZG27rgKD_icLosEk8d9wfsPe-kr1FQT3PdSYh1E?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%3Fid%3D9ac52818-4f5d-4365-a9c0-73ce4ff7cc43%26table%3Dblock%26spaceId%3De1c5ba0e-562a-49b0-8505-ce5e38fc061b%26expirationTimestamp%3D1721880000000%26signature%3D1pofzAKcMoHW3FXxmkSGMpyAhr3jXEe2qKBqOgu6G2s?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%3Fid%3D2935888a-6683-4322-8707-27ba2992ffdb%26table%3Dblock%26spaceId%3De1c5ba0e-562a-49b0-8505-ce5e38fc061b%26expirationTimestamp%3D1721880000000%26signature%3D5FxptWlgbQbpc2Slog_r0KdN-uddPxMmLNi7l9rc0QI?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%3Fid%3D13b61395-de11-4871-9566-40d91d845972%26table%3Dblock%26spaceId%3De1c5ba0e-562a-49b0-8505-ce5e38fc061b%26expirationTimestamp%3D1721880000000%26signature%3DubIU9Wusi9ewJjccUjSCwPnz0e7qYW1V0EroZKwemDM?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%3Fid%3D19a33486-c27b-4fd9-981c-d0d87fae04af%26table%3Dblock%26spaceId%3De1c5ba0e-562a-49b0-8505-ce5e38fc061b%26expirationTimestamp%3D1721880000000%26signature%3DGuj7D898G3nT8vF3BgCmWRJ3pjIVhMMZ5DO9Wb6hZx8?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%3Fid%3D50cc9ad6-2fc5-46f4-976b-dbd9d4ba8e78%26table%3Dblock%26spaceId%3De1c5ba0e-562a-49b0-8505-ce5e38fc061b%26expirationTimestamp%3D1721880000000%26signature%3DSCvhOn1SB93axz5lKMOhKyu4x8ebax-JZBbpXw0uQxQ?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%3Fid%3D5d97a863-66a6-4291-9cf8-67e79a079594%26table%3Dblock%26spaceId%3De1c5ba0e-562a-49b0-8505-ce5e38fc061b%26expirationTimestamp%3D1721880000000%26signature%3DXQ1AdxPsoQnq_agmUL1KMx6ieT_L7mW9JhSf8N8hT80?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%3Fid%3D0b3a7489-7413-4d29-b60f-eb04e3dc4cc9%26table%3Dblock%26spaceId%3De1c5ba0e-562a-49b0-8505-ce5e38fc061b%26expirationTimestamp%3D1721880000000%26signature%3Dd0RJmlwrnovGioVujV5u9AdVrU-hHpRV2WWEapVrMZg?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
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!
EP266 計畫趕不上變化?五招錦囊妙計助你應對風險、不再慌亂|大人的Small Talk - YouTube
Frameworks for business requirement elicitation