*** This is required to be created in Solver and the excel constraints are what is creating trouble for me as it won't solve.

Help would be appreciated!

The Armor Corporations manufactures heavy-duty air compressors for light industries markets. Armor is trying to plan its production and inventory level for the next six months. Because of seasonal fluctuations in utility and raw material cost, the per unit cost of producing air compressors varies from month to month- as does the demand for air compressors. Production capacity also varies from month to month due to differences in the number of working days, vacations and scheduled maintenance and training. The following table summarizes the monthly production costs, demands, and production capacity Armor's management expects to face over the next six months. 1 $240 2 $250 Month 3 $265 4 $285 5 $280 6 $260 1000 4500 6000 5500 3500 4000 Unit production Cost Units Demanded Max. Production 4000 3500 4000 4500 4000 3500 The following additional data are available: . . Given the size of Armor's warehouse, a maximum of 6,000 units can be held in inventory at the end of any month. The owner of the company likes to keep at least 1,500 units in inventory as safety stock at the end of each month to meet unexpected demand contingencies. To maintain a stable workforce, the company wants to produce no less than half of its maximum production capacity each month. Armor's accountant estimates that the cost of carrying a unit in any given month is approximately equal to 1.5% of the unit production cost in the same month. Armor estimates the number of units carries in inventory each month by averaging the beginning and end inventory for each month. Armors wants to identify the production and inventory plan for the next six months that will meet the expected demand each month while minimizing production and inventory cost