PLEASE HELP ME SOLVE THIS FROM 1-6

demand. Utilized time = workforce level - undertime] What is the number of employees who do not have enough work for the regular-time workday in Period 1? 29 5 Use the following problem statement to answer questions 1-6. Kyle wants to develop a staffing plan (also known as an 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. He 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 amount of undertime possible. The customer demands in Period 1 and Period 2 are shown in the table below. Use the spreadsheet approach. Round to the nearest whole number. [Note: Undertime = workforce level - forecasted demand. Utilized time = workforce level - undertime ] What is the total overtime cost in Period 1 ? 24,000 0 Question 3 4 pts What is the number of employees that the company should hire in Period 1? 30 2 Question 4 4 pts What is the utilized time in Period 1? 3 25 What is the utilized time in Period 1 ? 3 25 \begin{tabular}{|l|} \hline Question 5 \\ What is the number of employees who work overtime in Period 1 ? \\ \hline 0 \\ \hline 5 \\ \hline \end{tabular} Question 6 4pts What is the total cost of hiring employee(s) in Period 1? 90.000 6,000