PROVER S.A., one of the companies that supplies PRECISIÓN S.A. with raw materials. has asked you to formulate an aggregate plan for them. The forecast demand of your customers for each period of the next planning horizon is Month 1 2 3 4 Demand 10000 13500 11200 12000 It is considered that each worker can produce 500 units/month in normal hours and 100 units/month in overtime. The company has 20 employees and due to the high level of training required, it cannot hire anyone and cannot subcontract part of the production to another company. There is no beginning inventory. The cost for salaries and benefits in regular time is $1,000 per worker, per month. Overtime is paid 50% more than regular time. The cost of firing someone is $2,000. It costs 6 cents per month to hold a unit in inventory. 8. Define, in the Excel provided, a feasible aggregate plan for this company. Define a plan Feasible, it does not have to be the best or the least cost. It simply has to be a "feasible" plan. Evidence in Excel all the levels that you determined to make the plan: Manpower, Production in regular hours, Production in overtime (if necessary) and the level of inventory that must be accumulated each month (in case of that was necessary). 9. What is the total cost of the proposed plan? Answer
PROVER S.A., one of the companies that supplies PRECISIÓN S.A. with raw materials. has asked you to formulate an aggregate plan for them. The
Month 1 2 3 4
Demand 10000 13500 11200 12000
It is considered that each worker can produce 500 units/month in normal hours and 100 units/month in overtime. The company has 20 employees and due to the high level of training required, it cannot hire anyone and cannot subcontract part of the production to another company. There is no beginning inventory.
The cost for salaries and benefits in regular time is $1,000 per worker, per month. Overtime is paid 50% more than regular time. The cost of firing someone is $2,000. It costs 6 cents per month to hold a unit in inventory.
8. Define, in the Excel provided, a feasible aggregate plan for this company. Define a plan Feasible, it does not have to be the best or the least cost. It simply has to be a "feasible" plan. Evidence in Excel all the levels that you determined to make the plan: Manpower, Production in regular hours, Production in overtime (if necessary) and the level of inventory that must be accumulated each month (in case of that was necessary).
9. What is the total cost of the proposed plan? Answer
Step by step
Solved in 2 steps with 5 images
