Question
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
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 rm has 12 employees, each producing up to 1,000 units per quarter and earning $2,000 per quarter. The rm 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 1,000 units and wishes to have an ending inventory of 1,000 units at the end of the next year. The company does not plan to incur inventory shortages. a) Using a chase strategy, determine a workforce level in each quarter and the total cost of the next year (labor cost, hiring cost, layoff costs, and inventory carrying cost). b) Using a level strategy, determine a constant workforce level and the total cost of the next year. c) Using Excel Solver, determine the optimal plan and the total cost of the next year. please, answer each part
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