Chase Plan

Level Utilization

Mixed Plan

I need help writing an executive summary given the information above that includes quantitative factors (i.e., total cost) and qualitative factors (i.e., effects on morale and productivity) that drive my mixed plan.

A1 fx A B D E F G H J K L M N 1 Material Cost: 49 N Materials Backorder 3 Regular Time Production (Units) Forecast Demand Total Shipments Overtime Production (Units) Staff (Headcount) 21 Hire On-Hand Inventory Fire (Units Made) Total Cost 4 3000 0 Dec-19 | 5 5689 5689 4689 19 0 N 2 JAN 2000 0 0 4689 268161 6 6094 6094 6094 25 6 0 FEB 2000 0 0 6094 360606 7 12592 12592 12592 51 26 0 2000 0 0 12592 MAR 780608 8 6458 6458 6458 26 0 APR 25 2000 0 0 6458 412042 9 10246 10246 10246 41 15 0 MAY 2000 0 0 10246 616654 10 15003 15003 15003 61 20 0 2000 0 0 JUN 15003 896747 11 16489 16489 16489 66 5 0 2000 0 JUL 0 16489 932561 12 14135 14135 14135 57 0 9 2000 0 AUG 0 14135 805815 13 12092 12092 12092 49 0 8 2000 0 0 12092 690908 SEP 14 9875 9875 9875 40 0 9 OCT 2000 0 0 9875 569875 15 6082 6082 6082 25 0 15 2000 0 0 NOV 6082 372018 16 6500 6500 6500 26 0 2000 0 DEC 0 6500 367100 17 0 5 Year End Adj 10000 18 21 2000 0 Jan-21 19 121255 121255 120255 486 73 73 24000 Total Qty 0 0 120255 7083095 20 777600 219000 146000 48000 0 0 5892495 $7,083,095.00 Total Cost 21 Total Plan Cost $7,083,095.00 22 Cost per unit shipped 58.41 100 - Y $ % .0 .00 123 Defaul... - 11 B I A BIS ,4,,, O na? A1 - fx A B D E F G H 1 J K L L M N 0 P P 1 Material Cost: 49 2 Materials Regular Time Production (Units) Forecast Demand Backorder 3 Staff (Headcount) On-Hand Inventory Overtime Production (Units) Total Shipments Hire Fire (Units Made) Total Cost 4 21 3000 0 Dec-19 5 JAN 5689 5689 10186 41 20 7497 0 0 10186 639708 6 6094 6094 10186 41 0 11589 0 0 10186 FEB 587892 7 12592 12592 10186 41 0 9183 0 0 MAR 0 10186 583080 8 6458 6458 10186 41 0 12911 0 10186 590536 APR 9 10246 10246 10186 41 0 12851 0 10186 590416 MAY 10 15003 15003 10186 41 0 8034 JUN 0 10186 580782 11 16489 16489 10186 41 0 1731 0 10186 JUL 568176 12 11937 14135 1900... 10186 41 0 0 2198 0 10186 575704 AUG 13 SEP 12092 10186 10186 41 0 0 0 4104 0 10186 585234 14 OCT 9875 10186 10186 41 0 0 0 3793 0 0 10186 583679 15 6082 9875 10186 41 0 0 311 0 10186 NOV 565336 16 6500 6500 10186 41 0 0 0 4000 3 10189 DEC 572897 17 0 20 40000 Year End Adi 18 21 4000 0 Jan-21 19 121255 Total Qty 121255 122232 492 20 20 68107 10095 3 122235 7063440 20 787200 60000 40000 136214 50475 36 5989515 $7,063,440.00 Total Cost 21 Total Plan Cost $7,063.440.00 22 Cost per unit shipped 58.25 23 24 25 100 - $ % ... .00 123- | Defaul... - 11 - B I . A . BES - ID na? A1 fx B A B D E F G G H 1 J K L M N N o 0 1 Material Cost: 49 2 Materials Regular Time Production (Units) Forecast Demand Staff (Headcount) 3 On-Hand Inventory Backorder Overtime Production (Units) Total Shipments Hire Fire (Units Made) Total Cost 4 21 3,000 0 Dec-19 5 5689 5,689 5250 21 0 0 2561 0 0 JAN 5250 295972 6 6074 6074 6000 24 3 0 2487 0 0 6000 FEB 346374 7 12592 12592 48 12105 24 0 MAR 105 2000 0 12105 746470 8 6458 6458 11895 48 0 0 7437 0 APR 0 11895 674529 9 10246 10246 12000 48 0 0 9191 0 0 12000 683182 MAY 10 15003 JUN 15003 12000 48 0 0 6188 0 0 0 12000 677176 11 16489 16489 12301 48 0 0 2000 0 301 12602 701910 JUL 12 14135 14135 14135 48 AUG 0 0 2000 0 2135 16270 903650 13 12092 12092 12092 SEP 48 0 0 2000 43 49 12141 676512 14 OCT 9875 9875 9957 40 0 8 8 2082 0 0 9957 572057 15 6082 6082 7250 0 0 29 NOV 11 3250 0 0 7250 430150 16 6500 DEC 6500 7250 0 29 0 0 4000 0 0 7250 409650 17 0 0 8 8 Year End Adj 16000 18 21 4000 0 Jan-21 19 121235 121,235 122235 Total Qty 479 27 27 45196 148 2485 124720 7133632 20 766400 81000 54000 90392 740 29820 6111280 Total Cost $ $7,133,632.00 21 Total Plan Cost $7,133,632.00 22 Cost per unit shipped 58.84 23 24 A1 fx A B D E F G H J K L M N 1 Material Cost: 49 N Materials Backorder 3 Regular Time Production (Units) Forecast Demand Total Shipments Overtime Production (Units) Staff (Headcount) 21 Hire On-Hand Inventory Fire (Units Made) Total Cost 4 3000 0 Dec-19 | 5 5689 5689 4689 19 0 N 2 JAN 2000 0 0 4689 268161 6 6094 6094 6094 25 6 0 FEB 2000 0 0 6094 360606 7 12592 12592 12592 51 26 0 2000 0 0 12592 MAR 780608 8 6458 6458 6458 26 0 APR 25 2000 0 0 6458 412042 9 10246 10246 10246 41 15 0 MAY 2000 0 0 10246 616654 10 15003 15003 15003 61 20 0 2000 0 0 JUN 15003 896747 11 16489 16489 16489 66 5 0 2000 0 JUL 0 16489 932561 12 14135 14135 14135 57 0 9 2000 0 AUG 0 14135 805815 13 12092 12092 12092 49 0 8 2000 0 0 12092 690908 SEP 14 9875 9875 9875 40 0 9 OCT 2000 0 0 9875 569875 15 6082 6082 6082 25 0 15 2000 0 0 NOV 6082 372018 16 6500 6500 6500 26 0 2000 0 DEC 0 6500 367100 17 0 5 Year End Adj 10000 18 21 2000 0 Jan-21 19 121255 121255 120255 486 73 73 24000 Total Qty 0 0 120255 7083095 20 777600 219000 146000 48000 0 0 5892495 $7,083,095.00 Total Cost 21 Total Plan Cost $7,083,095.00 22 Cost per unit shipped 58.41 100 - Y $ % .0 .00 123 Defaul... - 11 B I A BIS ,4,,, O na? A1 - fx A B D E F G H 1 J K L L M N 0 P P 1 Material Cost: 49 2 Materials Regular Time Production (Units) Forecast Demand Backorder 3 Staff (Headcount) On-Hand Inventory Overtime Production (Units) Total Shipments Hire Fire (Units Made) Total Cost 4 21 3000 0 Dec-19 5 JAN 5689 5689 10186 41 20 7497 0 0 10186 639708 6 6094 6094 10186 41 0 11589 0 0 10186 FEB 587892 7 12592 12592 10186 41 0 9183 0 0 MAR 0 10186 583080 8 6458 6458 10186 41 0 12911 0 10186 590536 APR 9 10246 10246 10186 41 0 12851 0 10186 590416 MAY 10 15003 15003 10186 41 0 8034 JUN 0 10186 580782 11 16489 16489 10186 41 0 1731 0 10186 JUL 568176 12 11937 14135 1900... 10186 41 0 0 2198 0 10186 575704 AUG 13 SEP 12092 10186 10186 41 0 0 0 4104 0 10186 585234 14 OCT 9875 10186 10186 41 0 0 0 3793 0 0 10186 583679 15 6082 9875 10186 41 0 0 311 0 10186 NOV 565336 16 6500 6500 10186 41 0 0 0 4000 3 10189 DEC 572897 17 0 20 40000 Year End Adi 18 21 4000 0 Jan-21 19 121255 Total Qty 121255 122232 492 20 20 68107 10095 3 122235 7063440 20 787200 60000 40000 136214 50475 36 5989515 $7,063,440.00 Total Cost 21 Total Plan Cost $7,063.440.00 22 Cost per unit shipped 58.25 23 24 25 100 - $ % ... .00 123- | Defaul... - 11 - B I . A . BES - ID na? A1 fx B A B D E F G G H 1 J K L M N N o 0 1 Material Cost: 49 2 Materials Regular Time Production (Units) Forecast Demand Staff (Headcount) 3 On-Hand Inventory Backorder Overtime Production (Units) Total Shipments Hire Fire (Units Made) Total Cost 4 21 3,000 0 Dec-19 5 5689 5,689 5250 21 0 0 2561 0 0 JAN 5250 295972 6 6074 6074 6000 24 3 0 2487 0 0 6000 FEB 346374 7 12592 12592 48 12105 24 0 MAR 105 2000 0 12105 746470 8 6458 6458 11895 48 0 0 7437 0 APR 0 11895 674529 9 10246 10246 12000 48 0 0 9191 0 0 12000 683182 MAY 10 15003 JUN 15003 12000 48 0 0 6188 0 0 0 12000 677176 11 16489 16489 12301 48 0 0 2000 0 301 12602 701910 JUL 12 14135 14135 14135 48 AUG 0 0 2000 0 2135 16270 903650 13 12092 12092 12092 SEP 48 0 0 2000 43 49 12141 676512 14 OCT 9875 9875 9957 40 0 8 8 2082 0 0 9957 572057 15 6082 6082 7250 0 0 29 NOV 11 3250 0 0 7250 430150 16 6500 DEC 6500 7250 0 29 0 0 4000 0 0 7250 409650 17 0 0 8 8 Year End Adj 16000 18 21 4000 0 Jan-21 19 121235 121,235 122235 Total Qty 479 27 27 45196 148 2485 124720 7133632 20 766400 81000 54000 90392 740 29820 6111280 Total Cost $ $7,133,632.00 21 Total Plan Cost $7,133,632.00 22 Cost per unit shipped 58.84 23 24