The Young Company manufactures parts for MRI machines. The company would like to determine the Jan- Apr production plan that minimize the total cost. The estimated demand and production capacity for the Jan-Apr period is as follows:

Month	January	February	March	April
Demand	2,800	3,000	3,500	3,000
Production Capacity	3,000	3,200	3,200	3,300

The cost of production for each unit of part is $500 per unit. The company can utilize inventories to reduce fluctuations in production, but carrying one unit of inventory costs the company $40 per unit per month. . The accountant estimates the number of units carries in inventory each month by averaging the beginning and end inventory for each month. Currently there are 50 unit of inventories. However the company wants to maintain a minimum safety stock of 100 units of inventory at the end of each month.

1. State only the decision variables for this problem in the space provided below. [4 marks]
2. Use Excel to formulate and solve this problem. (label the tab in Excel spreadsheet as Q2)[18]