the HW 30 minute
Use the data given in the table below for solving the questions. Enter, the assumed number of working days for each month in the table below). Jan Feb Mar April May June Month Days/month Demand 440 530 750 960 820 680 Material cost Holding cost Marginal cost of stock out Hiring and training cost Layoff cost Labor hours required/unit Straight time labor cost Beginning inventory Productive hours/worker/day Paid straight hours/day $ 6/unit $ 2/unit/month $1.5/unit/month $ 300/worker $ 400/worker 0.30 hours/unit $ 10/hour 70 units 7.5 hours 8 hours 1. Calculate the total cost using Chase demand strategy. Assume number of workers at the start of the January (Use Format 1 given below for MS Excel sheet calculations). 13 Total cost for 6 months: $ 2. Calculate the total cost using Level workforce strategy. Decide the minimum number of workers to meet the demand. (Use Format 2 given below for MS Excel sheet calculations). 13 Total cost for 6 months: $ No. of workers: 14 3. Suggest the suitable strategy. Justify your decision. Format 2: Level Workforce Strategy (Copy your final calculations in the table below from the MS Excel sheet) Month Jan Feb Mar April May June Days/month Hrs/worker/month Units/worker S/ worker Demand Beginning Inventory Net requirement Workers Production Ending Inventory Surplus Shortage Total cost Labor cost Material cost Storage cost Stock-out cost Total cost Use the data given in the table below for solving the questions. Enter, the assumed number of working days for each month in the table below). Jan Feb Mar April May June Month Days/month Demand 440 530 750 960 820 680 Material cost Holding cost Marginal cost of stock out Hiring and training cost Layoff cost Labor hours required/unit Straight time labor cost Beginning inventory Productive hours/worker/day Paid straight hours/day $ 6/unit $ 2/unit/month $1.5/unit/month $ 300/worker $ 400/worker 0.30 hours/unit $ 10/hour 70 units 7.5 hours 8 hours 1. Calculate the total cost using Chase demand strategy. Assume number of workers at the start of the January (Use Format 1 given below for MS Excel sheet calculations). 13 Total cost for 6 months: $ 2. Calculate the total cost using Level workforce strategy. Decide the minimum number of workers to meet the demand. (Use Format 2 given below for MS Excel sheet calculations). 13 Total cost for 6 months: $ No. of workers: 14 3. Suggest the suitable strategy. Justify your decision. Format 2: Level Workforce Strategy (Copy your final calculations in the table below from the MS Excel sheet) Month Jan Feb Mar April May June Days/month Hrs/worker/month Units/worker S/ worker Demand Beginning Inventory Net requirement Workers Production Ending Inventory Surplus Shortage Total cost Labor cost Material cost Storage cost Stock-out cost Total cost
