Sales & Operations Planning
November 19, 2022
Essayheroes
| Period |
|
I |
II |
III |
IV |
Total |
| Forecast |
|
22000 |
23000 |
36000 |
13000 |
94000 |
| Output Total |
|
23000 |
23000 |
23000 |
23000 |
92000 |
| Inventory: |
|
|
|
|
|
|
| Beginnning |
|
4000 |
5000 |
5000 |
0 |
|
| Ending |
|
5000 |
5000 |
0 |
2000 |
|
| Average |
|
4500 |
5000 |
2500 |
1000 |
|
| Backorders: |
|
0 |
0 |
8000 |
0 |
|
| Plan for types of outputs |
|
|
|
| FT hires/layoffs at start of quarter |
1 |
|
|
|
|
| FT staffing starting |
45 |
46 |
46 |
46 |
46 |
|
| Regular output/person/qtr |
500 |
23000 |
23000 |
23000 |
23000 |
|
| Overtime output/person/qtr |
200 |
|
|
|
|
|
| Temp hires/layoffs at start of quarter |
|
|
0 |
0 |
|
| Temporary staff starting |
|
0 |
0 |
0 |
0 |
|
| Temp output/person/qtr |
400 |
0 |
0 |
0 |
0 |
|
| Sub-contr (5200/qtr max) |
|
|
|
|
|
|
| Check total output |
|
23000 |
23000 |
23000 |
23000 |
|
|
|
|
|
|
|
|
| Costs |
|
|
|
|
|
|
| Output costs for FT staff |
|
|
|
| Regular ($/unit) |
5.00 |
115000 |
115000 |
115000 |
115000 |
$ 460,000 |
| Overtime ($/unit) |
7.50 |
0 |
0 |
0 |
0 |
$ – |
| Temp ($/unit) |
12.00 |
0 |
0 |
0 |
0 |
$ – |
| Sub-Contr ($/unit) |
10.00 |
0 |
0 |
0 |
0 |
$ – |
| Hiring costs ($/person) |
100 |
100 |
0 |
0 |
0 |
$ 100 |
| Layoff costs ($/FT person) |
500 |
0 |
0 |
0 |
0 |
$ – |
| Inventory costs $/qtr-avg inv |
4.00 |
18000 |
20000 |
10000 |
4000 |
$ 52,000 |
| Backorder costs $/qtr |
8.00 |
0 |
0 |
64000 |
0 |
$ 64,000 |
| Totals |
|
$ 133,100 |
$ 135,000 |
$ 189,000 |
$ 119,000 |
$ 576,100 |
