Question: A company wants to develop a staffing plan for the next six periods. Each worker puts in 180 hours of regular time per period and

A company wants to develop a staffing plan for
A company wants to develop a staffing plan for the next six periods. Each worker puts in 180 hours of regular time per period and can work up to 30 hours of overtime per period. The estimated staff requirements (in hours) over the next six period are shown below. 4400, 3500, 5700, 3600, 5400, and 4100 hours The regular-time pay rate is $15 per hour and the overtime pay rate is $23 per hour. Hiring, training, and outfitting a new worker costs $4000. Layoff costs are $2800 per worker. Currently, the company has 17 workers. You must help the company to construct a staffing plan that use the level strategy with overtime and undertime. Overtime is used during the peak period, while undertime should be kept as low as possible. No delays in service or backorders are allowed. Undertime is paid at $15 per hour. Unused overtime has no cost. You must construct your own Excel spreadsheet showing the following: [1] Number of workers hired and layoff on each period. [2] Utilized regular-time hours on each period. [3] Utilized overtime hours on each period. [4] Undertime hours on each period. You must put your answers directly on the discussion forum with a brief explanation and calculation. You are not allowed to post any Excel document but you must email your Excel file to your instructor

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related General Management Questions!