Use the following problem statement to answer questions $12-15.$

John wants to develop a staffing plan $($also known as an S&OP$)$ using the level strategy. Each worker on the payroll costs $$4,000$ in regular$-$time wages per month. Each worker puts in $200$ hours of regular time per period and can work as many as an additional $100$ hours of overtime. The overtime pay rate is $$30$ 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 $$5,000$ and lay off one for $$1,000.$ At present, $16$ 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$]$

Question $12$

$7$ pts

What is the total cost, including the cost of utilized time, undertime, overtime, hiring, and layoffs, in Period $1?$ Round to the nearest whole number.

Question $13$

What is the overtime cost in Period $2?$ Round to the mearest whole mumber

$54,000$

$72,000$

$3,000$

$6,000$

$0$

$30$

Question $14$

$7$ pts

What is the total cost, including the cost of utilized time, undertime, overtime, hiring, and layoffs, in Period $2?$ Round to the nearest whole number.

Question $15$

pts

What is the cost of hirirng employee$($s$)$ in Period $12$ Round to the nearest whole number:

$0$

$10,000$

$40,000$

$15,000$

$5,000$

$20,000$

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$]$

$\backslash$table$[[,1,2],[$Demand $($hours$),2,800,5,400]]$

$\backslash$table$[[,$Inputs,,$],[200,$Forecasted demand,$14,27],[300,$Workforce level,$18,18],[$Undertime$,,],[$Overtime$,,],[$Derived$,,],[$Utilized time,,$],[16,$Hires,,$],[$Layoffs$,,],[$Calculated$,,],[4,000,$Utilized time cost,,$],[4,000,$Undertime cost,,$],[30,$Overtime cost,,$],[5,000,$Hiring cost,,$],[1,000,$Layoff cost,,$],[,$Total Cost,,$]]$