Question: please help with Excel and show the formula. Thanks! Data COGS $35.00 Beginning work force 65 employees Hiring cost $350 per employee Work Hours per
please help with Excel and show the formula. Thanks!
Data
COGS $35.00
Beginning work force 65 employees Hiring cost $350 per employee
Work Hours per month 160 Firing cost $600 per worker
Carrying costs 32% per year Work Standard 2 hours per piece
Labor rate $24
) ABC Company wishes to investigate a Level strategy and reduce their current inventory of 10,000 units of finished goods in stock to 4,000 by the end of March.
Level
| Month | Forecast Sales | Production Plan | Inventory | Inventory Cost $ | # of workers | Hire or Fire | H/F cost | Payroll | Total |
| July | 5460 |
|
|
|
|
|
|
|
|
| August | 5340 |
|
|
|
|
|
|
|
|
| Sept | 5200 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
Using the same data above, what is the total cost of this plan for the 3 months?
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
