The ABC Company is making a production plan for the next year, given the sales forecast for the next year as: Quarter 1 2 3 4 Total Sales Forecast (units) 9,000 12,000 16,000 12,000 49,000 Currently, the firm has 12 employees, each producing up to 1,000 units per quarter and earning $2,000 per quarter. The firm estimates its inventory carrying cost to be $2 per unit of ending inventory per quarter and its hiring or layoff costs to be $1,600 per employee. The company currently has an inventory of 2,000 units and wishes to have an ending inventory of at least 1,000 units at the end of each quarter. The company does not plan to incur inventory shortages. Find the optimal production plan that minimizes the total cost by Excel solver
The ABC Company is making a production plan for the next year, given the sales
Trending now
This is a popular solution!
Step by step
Solved in 2 steps with 3 images
