Respuesta :
Answer:
This question is not incomplete from all indications. I expect that tables like below be provided so that one can populate the missing numbers as appropriate:
Forecast 940 1,530 1,200
Safety stock
Beginning inventory
Net production required
Workers required
Hired
Laid off
Actual production
Ending inventory
January February March
Labor $ $ $
Inventory
Hiring
Layoff
Total $ $ $
Find the attached excel file for detailed answers
Explanation:
The below are the formulas used in solving the questions:
FORMULAS:
Safety stock Forecast/2
Opening inventory equals closing inventory of last month
Net Production Desired equals forecast+safety stock-opening inventory
Workers required Net Production Desired/(8*number of days*0.1)
Hires workers required -workers available
layoff workers available -workers required
actual production workers required*8*number of days*0.1
Closing inventory actual production+safety stock-forecast
labour cost workers required*8*6
inventory (opening inventory+closing inventory )/2*6
Hire hires*170
layoff layoff*270
Total cost labour cost+inventory+hire+layoff