Morgan Inc. Parameters Order Cost/order: $160.00 Holding Cost / unit: $1.00 Cost / unit $15.00 Maximum Order Size 1,000 Time Period 1 2 3 4 5 6 7 8 9 10 11 12 Demand 20 20 30 40 140 360 500 540 460 80 0 20 Model 1 2 3 4 5 6 7 8 9 10 11 12 Order? 1 0 0 0 1 1 1 1 1 0 0 0 Quantity 110 0 0 0 140 360 500 540 560 0 0 0 Ending Inventory 90 70 40 0 0 0 0 0 100 20 20 0 Setup Constraints 1000 0 0 0 1000 1000 1000 1000 1000 0 0 0 Order Cost Holding Cost Purchase Cost Total Cost

Data 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 $160. The cost to hold these components in inventory is $1 per component per period. The price of the component is expected to remain stable at $15 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	5	6	7	8	9	10	11	12
Demand	20	20	30	40	140	360	500	540	460	80	0	20

Partial Excel worksheet is provided. Solve the formulated Model. How much is the ordering cost?