Answered step by step
Verified Expert Solution
Question
1 Approved Answer
hello i know this post befor but i wanted by excel solve it's totaly difrrent Linear Optimization Models 6. Morgan Inc. is planning the purchase
hello i know this post befor but i wanted by excel solve it's totaly difrrent
6. Morgan Inc. is planning the purchase of one of the component parts it needs for its finished product. The anticipated demands for the component for the next 12 periods are shown in the following table. The cost to order the component (labor, shipping, and paperwork) is $150. The cost to hold these components in inventory is si per compo- nent per period. The price of the component is expected to remain stable at $12 per unit for the next 12 periods, and no quantity discounts are available. The maximum order size is 1.000 units. Period Demand 1 2 3 4 5 20 20 30 40 140 7 500 8 9 10 11 12 540 460 800 20 360 a. Formulate a model to minimize the total cost of satisfying Morgan Inc.'s demand for this component. b. Solve the model formulated in part a. What is the optimal cost? How many orders are placed? ... in nancidering the relocation of several police substations to obtain better wichsha Linear Optimization Models 6. Morgan Inc. is planning the purchase of one of the component parts it needs for its finished product. The anticipated demands for the component for the next 12 periods are shown in the following table. The cost to order the component (labor, shipping, and paperwork) is $150. The cost to hold these components in inventory is $1 per compo- nent per period. The price of the component is expected to remain stable at $12 per unit for the next 12 periods, and no quantity discounts are available. The maximum order size is 1,000 units. Period 1 2. 3. 4. 6. 7. 8. 9. 10 11 12 Demand 20 20 30 40 140 360 500 540 460 80 0 20 a. Formulate a model to minimize the total cost of satisfying Morgan Inc.'s demand for this component. b. Solve the model formulated in part a. What is the optimal cost? How many orders are placed? Ci in considering the relocation of several police substations to obtain better L ith the
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started