Question: Kyle wants to develop a staffing plan (also known as S&OP) using the level strategy. Each worker on the payroll costs $2,000 in regular-time wages

Kyle wants to develop a staffing plan (also known
Kyle wants to develop a staffing plan (also known
Kyle wants to develop a staffing plan (also known as S&OP) using the level strategy. Each worker on the payroll costs $2,000 in regular-time wages per month. Each worker puts in 300 hours of regular time per period and can work as many as an additional 200 hours of overtime. The overtime pay rate is $16 per hour. Undertime is paid at the same rate as regular time. In accordance with the labor contract in force, the company does not use subcontracting, Kyle can hire and train a new employee for $3,000 and lay off one for $500. At present, 30 employees are on the payroll. Vacations, subcontracting, backorders, and stockouts are not options. He wants to use the level staffing plan that relies just on overtime and the minimum achount of undertime possible. Use the spreadsheet approach. Round to the nearest whole number. Answer the following questions. Table 1 Demand (hours) 1 15,000 2 30,000 50 60 100 60 Inputs 300 Forecasted demand 500 Workforce level Undertime Overtime Derived Utilized time 30 Hires Layoffs Calculated 2,000 Utilized time cost 2,000 Undertime cost 16 Overtime cost 3,000 Hiring cost 500 Layoff cost Total Cost What is the number of employees who do not have enough work for the regular-time workday in Period 1? 3 5 10 D Question 6 4 pts What is the total cost of hiring employee(s) in Period 1? 30,000 90,000 157,800

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!