3300

Deseasona
Period At Same quarter avg SI Ft Deseasonalised
lised sales

1 4500 3500 1.06060606061 4242.8571 3247.6190476191

2 2000 2000 0.60606060606 3300 3262.5850340136
3 1500 3500 1.06060606061 1414.2857 3277.5510204082
4 5200 4200 1.27272727273 4085.7143 3292.5170068027
5 2500 1.06060606061 2357.1429 3307.4829931973
6 2000 0.60606060606 3300 3322.4489795918

7 5500 1.06060606061 5185.7143 3337.4149659864

8 3200 1.27272727273 2514.2857 3352.380952381

9 2900 1.06060606061 3367.3469387755

10 6000 0.60606060606 3382.3129251701

11 3550 1.06060606061 3397.2789115646
12 3150 1.27272727273 3412.2448979592
 Seasonalised
sales

3444.444444444
1977.324263039
3476.19047619
4190.476190476
3507.936507937
2013.605442177
Ordering Cost per
3539.682539683 1000
order
4266.666666667 icc% annual 36%

3572 P

2050 A B C D E
3604 Price 100 250 500 300 50
4343 Composition 2 1 0.5 4 6
13569 7144 3572 1786 14288 21432
4100 2050 1025 8200 12300
7208 3604 1802 14416 21624
8686 4343 2172 17372 26058
Total Demand 27138 13569 6785 54276 81414
EOQ 1228 550 275 1003 3008
 MRP A

Period Demand Opening Stock Order Receive Closing Stock

F 0
75 9 7144 0 7368 7368 224
1.5 10 4100 224 4912 4912 1036
5358 11 7208 1036 7368 7368 1196
3075 12 8686 1196 8596 8596 1106
5406
6515
20354
1228
 Inventory
Ordering Cost Material Cost Total cost
cost

6000 736800 2016 744816

4000 491200 9324 504524
6000 736800 10764 753564
7000 859600 9954 876554
Total Cost 2879458
 3500

Deseasona
Period At Same quarter avg SI Ft Deseasonalised
lised sales

1 4500 3300 0.94285714286 4772.7273 3087.7418000641

2 2000 3333.33333333333 0.95238095238 2100 3162.6978364161
3 1500 3516.66666666667 1.00476190476 1492.891 3237.6538727681
4 5200 3850 1.1 4727.2727 3312.60990912
5 2500 0.94285714286 2651.5152 3387.565945472
6 2000 0.95238095238 2100 3462.521981824

7 5500 1.00476190476 5473.9336 3537.478018176

8 3200 1.1 2909.0909 3612.434054528

9 2900 0.94285714286 3075.7576 3687.39009088
10 6000 0.95238095238 6300 3762.346127232
11 3550 1.00476190476 3533.1754 3837.3021635839
12 3150 1.1 2863.6364 3912.2581999359
13 0.94285714286 3987.2142362879
14 0.95238095238 4062.1702726399
15 1.00476190476 4137.1263089919
16 1.1 4212.0823453439
Total Demand

Aggregate Planning hours/day 8

Level Strategy hours/unit 2

Working Opening Opening
Month Demand Units NT
days Worker Stock
31
13 25 3760 42 0 4200
14 25 3869 42 440 4200
15 25 4157 42 771 4200
16 25 4634 42 814 4200
Annual
16420
demand
Required
Workers 42

Aggregate Planning hours/day 8

Chase Strategy hours/unit 2

Month Working Demand Opening Opening Units NT

days Worker Stock
31
13 25 3760 38 0 3800
 14 25 3869 39 40 3900
15 25 4157 41 71 4100
16 25 4634 47 14 4700
Annual 16420
demand

Aggregate Planning hours/day 8

Modified Level Strategy hours/unit 2

Working Cumulative Avg Cumulative
Month Cumulative days Demand
days days Demand

13 25 25 25 3760 3760
14 25 50 25 3869 7629
15 25 75 25 4157 11786
16 25 100 25 4634 16420

Days/month 25
Demand/month 4105
 Seasonalised
sales

2911.299411489
3012.093177539
3253.071272162
3643.870900032
3193.9907485879
3297.63998269
Ordering Cost per
3554.323151596 1000
order
3973.677459981 icc% annual 36%
3476.682085687
3583.18678784
3855.57503103
4303.48401993
3760
3869
4157
4634
16420

Per
Per Worker Per Month Per Month Per Unit
Worker
6000 9000 10000 15000 10
Layoff Normal Overtime Inventory
Units OT Closing Stock Hiring cost
Cost Wages Wages Cost
0
0 440 66000 0 1260000 0 4400
0 771 0 0 1260000 0 7710
0 814 0 0 1260000 0 8140
0 380 0 0 1260000 0 3800

Total Cost

Per
Per Worker Per Month Per Month Per Unit
Worker
6000 9000 10000 15000 10

Units OT Closing Stock Hiring cost Layoff Normal Overtime Inventory

Cost Wages Wages Cost
0
0 40 42000 0 1140000 0 400
 0 71 6000 0 1170000 0 710
0 14 12000 0 1230000 0 140
0 80 36000 0 1410000 0 800

Total Cost

Cumulative Avg New Days per New Demand Opening Opening

Units NT Units OT
Demand month per month Worker Stock
31
3760 25 4105 42 0 4200 0
3815 25 4105 42 95 4200 0
3929 25 4105 42 190 4200 0
4105 25 4105 42 285 4200 0
Total 100 16420
Reqd Workers 42
Total Cost

1330400
1267710
1268140
1263800

5130050

Total Cost

1182400
1176710
1242140
1446800

5048050

Per Per
Per Month Per Month Per Unit
Worker Worker
6000 9000 10000 15000 10
Closing Layoff Normal Inventory
Hiring cost Overtime Wages Total Cost
Stock Cost Wages Cost
0
95 66000 0 1260000 0 950 1326950
190 0 0 1260000 0 1900 1261900
285 0 0 1260000 0 2850 1262850
380 0 0 1260000 0 3800 1263800
Total Cost 5115500
QP4 Area Seasonal Non-Seasonal
500 357770 1056380
750 438180 1217455
1000 505965 1346420
1250 565685 1455795
1500 619680 1551720
b0 236926 833946
b1 260.53 491.608
Area* 0 2000 400 1599.9999908
Profit 236926 1817162 341138 1620518.7955
Total Area 2000 1999.999991
Total Profit 2054088 1961656.795

QP3 Seats 146 Mean 92

Agent Cost 7400 SD 30
LM Cost 11400
Seats to agent 95
Remaining seats 51

P (Demand>
0.9141350947
Remaining seats)

Actual Rem seats 46.620889832

Revenue from rem 531478.14408

seats
Revenue from 703000
agent
Total Revenue 1234478.1441
QP5
calls (X) 100 250 400 650 750
LN (X) 4.605170186 5.52146091786 5.991464547 6.4769723629 6.6200732
Sales Drug 1 500 791 1000 1275 1369
LN(Sales Drug 1) 6.2146080984 6.67329796777 6.907755279 7.1507014576 7.2218358
Sales Drug 2 316 629 894 1287 1433
LN(Sales Drug 2) 5.7557422136 6.4441312567 6.795705775 7.1600692076 7.2675254
Sales Drug 3 238 412 546 731 796
LN(Sales Drug 3) 5.4722706737 6.02102334935 6.302618976 6.5944134597 6.6795992
Sales Drug 4 80 105 121 140 146
LN(Sales Drug 4) 4.3820266347 4.65396035016 4.795790546 4.9416424226 4.9836066

Sales = a*X^n X Sales

LN(Sales) = LN(a) + n*LN(X) Sales Drug 1 419 1023.5644

Sales Drug 2 1424 2318.133
Sales Drug 3 147 299.65809
 Sales Drug 4 10 40.193707
Total Calls 2000

X Sales Cost 1.2 per call Profit

Sales Drug 1 434 1041.72309841 520.8 520.92309841
Sales Drug 2 1527 2442.81176514 1832.4 610.41176514
Sales Drug 3 154 308.13793861 184.8 123.33793861
Sales Drug 4 10 40.1937073016 12 28.193707302
Total Calls 2125 Total Profit 1282.8665095
 LN(a) a
900 1200 1600 2000 2500 3000 3600
6.8023947633 7.0900768358 7.3777589 7.6009025 7.824046 8.0063676 8.1886891
1500 1732 2000 2236 2500 2739 3000
7.3132203871 7.4570320891 7.6009025 7.7124438 7.824046 7.9153482 8.0063676 3.9123984 50.018771
1643 2039 2530 2991 3536 4054 4648
7.404279118 7.6202147706 7.8359746 8.0033631 8.1707514 8.3074593 8.4441923 2.3014332 9.9884877
888 1056 1255 1435 1640 1830 2041
6.788971743 6.9622434643 7.1348909 7.2689201 7.4024515 7.5120712 7.6211952 2.7090894 15.015596
154 168 183 196 209 221 233
5.0369526024 5.1239639794 5.2094862 5.2781147 5.3423343 5.3981627 5.4510385 3.0058833 20.204055

Cost 1.2 per

call Profit

502.8 520.76438959
1708.8 609.33300055
176.4 123.25808702
 12 28.193707302
Total Profit 1281.5491845

X Sales Cost 1.2 per call Profit

Sales Drug 1 419 1023.5644 502.8 520.76439
Sales Drug 2 1424 2318.133 1708.8 609.333
Sales Drug 3 147 299.65809 176.4 123.25809
Sales Drug 4 10 40.193707 12 28.193707
Total Calls 2000 Total Profit 1281.5492
 n

0.4999524

0.7501605

0.5998584

0.2987195