Question
Download Level Q1 Download Level Q1 and perform the necessary calculations for a Level Production Strategy. Then enter selected values below. 1. What is the
Download Level Q1 Download Level Q1 and perform the necessary calculations for a Level Production Strategy. Then enter selected values below.
1. What is the Number of Employees in August?
2. What is the Production amount for September?
3. What is the Production Quantity for October?
4. What is the Inventory quantity for March?
5. What is the Inventory quantity for October?
6. What is the Days Supply value for November? (Keep one decimal place)
7. What is the Cost of Inventory for January? (Round to whole dollars)
8. What is the number of Employee Hires for February?
9. What is the number of Employee Layoffs for January?
10. What is the Selected Cost of this plan in January? (Round to whole dollars)
PLEASE ANSWER ALL QUESTIONS OR DON'T ANSWER AT ALL
S\&O Plan: Level Production \begin{tabular}{|c|c|c|c|c|c|c|c|c|c|c|c|c|c|c|c|c|} \hline & & & & & & & & Pl & & & & & & & & Plan \\ \hline & & Dec & Jan & Feb & Mar & Apr & May & Jun & Jul & Aug & Sep & Oct & Nov & Dec & Jan & Totals \\ \hline Sales & & & & & & & & & & & & & & & & \\ \hline Forecast & revenue & & & & & & & & & & & & & & & \\ \hline & units & 530 & 545 & 546 & 543 & 505 & 593 & 584 & 598 & 712 & 587 & 564 & 520 & 490 & 525 & \\ \hline Backlog & & & & & & & & & & & & & & & & \\ \hline Operations & & & & & & & & & & & & & & & & \\ \hline Production & units & 530 & & & & & & & & & & & & & & \\ \hline & employees & 7 & & & & & & & & & & & & & & \\ \hline Work Days & / month & 20 & 20 & 21 & 23 & 20 & 18 & 20 & 21 & 23 & 20 & 22 & 13 & 20 & 20 & \\ \hline Inventory & & & & & & & & & & & & & & & & \\ \hline Plan & units & 2,223 & & & & & & & & & & & & & & \\ \hline & cost & & & & & & & & & & & & & & & \\ \hline Days Suppl & & & & & & & & & & & & & & & & \\ \hline & & & & & & & & & & & & & & & & \\ \hline Employees & & & & & & & & & & & & & & & & \\ \hline Hires & & & & & & & & & & & & & & & & \\ \hline Layoffs & & & & & & & & & & & & & & & & \\ \hline & & & & & & & & & & & & & & & & \\ \hline Selected C & osts & & & & & & & & & & & & & & & \\ \hline Hiring & $480.00 & & & & & & & & & & & & & & & \\ \hline Layoffs & $280.00 & & & & & & & & & & & & & & & \\ \hline Holding & 3.50% & & & & & & & & & & & & & & & \\ \hline Backlog & $9.50 & & & & & & & & & & & & & & & \\ \hline & Totals & & & & & & & & & & & & & & & \\ \hline & & & & & & & & & & & & & & & & \\ \hline Data & & & & & & & & & & & & & & & & \\ \hline \$ Rev each & each & 29.98 & & & & & & & & & & & & & & \\ \hline$ Cost eact & r each & 20.74 & & & & & & & & & & & & & & \\ \hline Empl & units / day & 3.9 & & & & & & & & & & & & & & \\ \hline Days Supply & & 5.0 & & & & & & & & & & & & & & \\ \hline Min Dec En & ding Inventory & 22.0 & & & & & & & & & & & & & & \\ \hline & & & & & & & & & & & & & & & & \\ \hline \end{tabular}Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started