企业安全生产相关表格-5SPC2

Input Parameters
SPC - Input Parameter
Cost's
Raw mateial cost per 1000 lbs
10.00
$
Extruder fixed cost per quarter
80,000.00
$
Hiring and training cost/person
2,000.00
$
Layoff cost/worker
1,500.00
$
Regular wage cost/hour
15.00
$
Over time wage cost/hour
22.50
$
Transportation cost to and from warehouse per 1000 lbs
2.00
$
Public warehouse: Material handling chages per 1000 lbs
5.00
$
(between $4.00 and $ 6.00)
Public warehouse: Storage charges at public warehouse per 1000 lbs
10.00
$
Privat warehouse: Lease rates per square foot and year
4.00
$
Privat warehouse: Variable operating cost per 1000 lbs
3.00
$
Subcontracting cost per 1000 lbs
100.00
$
Constraints
Operating days per quarter
63
Regular working hours
8
Maximum ovetime per worker and quarter (in hours)
60
Extruders: Effective processing capacity by extruder (lbs per hour)
2280
Extruders : Staffing equirements per extruder (workers)
6
Thermoforing pesses: Effective capacity by thermoforing pess (lbs per hour)
2000
Thermoforing pesses: Staffing Equirements per thermoforming press (workers)
1
Minimum lease period for private warehousing (quarters)
12
Floor space required to store 1000 lbs in square feet
1
http://www.aliqq.cn
Note: The LPs can be too large for Solver
to handle in which case you might receive
the following message: "The conditions for
Assume Linear Model are not satisfied". In
this case, just run Solver again.
Page 1
Aggregate Plan Decision Variables
Sales Forecast
Hiring/Firing
Extruder
Warehouse
Thermoforming
Ht
Lt
Wt
Ot
PEt
Ct
It
PTt
Constraints
Period
Demand
Black Plastic
('000lbs)
Demand Clear
Plastic
('000lbs)
Total
# Hired
# Laid off
# Workforce
Overtime
Production
('000lbs)
Subcontract
('000lbs)
Inventory
Production
('000lbs)
Workforce
Total
Inventory
Demand
Satisfacion
Production
Overtine
0
109
0
=0
=0
=0
>=0
>=0
1999/1
6,650

7,462

14,112

6
0
115
0
19,297
0
5,185
14,112
0
0
0
0
6885
1999/2
4,576

18,250

22,826

0
0
115
0
17,641
0
0
22,826
0
0
0
0
6885
1999/3
6,293

8,894

15,187

0
12
103
0
16,766
0
1,579
15,187
0
0
0
0
6157
1999/4
13,777

4,064

17,841

0
0
103
0
16,262
0
0
17,841
0
0
0
0
6157
2000/1
7,509

8,349

15,858

26
0
129
0
21,597
0
5,739
15,858
0
0
0
0
7710
2000/2
5,149

20,355

25,504

0
0
129
0
19,765
0
0
25,504
0
0
0
0
7710
2000/3
7,056

9,891

16,947

0
14
114
0
18,708
0
1,761
16,947
0
0
0
0
6870
2000/4
15,399

4,507

19,906

0
0
114
0
18,145
0
0
19,906
0
0
0
0
6870
2001/1
8,367

9,135

17,502

27
0
142
0
23,857
0
6,355
17,502
0
0
0
0
8516
2001/2
5,721

22,461

28,182

0
0
142
0
21,827
0
0
28,182
0
0
0
0
8516
2001/3
7,819

10,889

18,708

0
16
126
0
20,649
0
1,941
18,708
0
0
0
0
7583
2001/4
17,021

4,950

21,971

0
0
126
0
20,030
0
0
21,971
0
0
0
0
7583
MAD
608

786

59
42
0
234,544
0
234,544
Aggregate Plan Costs
Period
Hiring
Lay off
Regular time
Over time
Material
Subcontract
Inventory
1999/1
$ 11,512
-
$
$ 867,557
-
$
$ 192,968
-
$
77,772
$
1999/2
-
$
-
$
$ 867,557
-
$
$ 176,412
-
$
-
$
1999/3
-
$
$ 18,221
$ 775,723
-
$
$ 167,661
-
$
23,687
$
1999/4
-
$
-
$
$ 775,723
-
$
$ 162,619
-
$
-
$
2000/1
$ 51,783
-
$
$ 971,463
-
$
$ 215,974
-
$
86,091
$
2000/2
-
$
-
$
$ 971,463
-
$
$ 197,646
-
$
-
$
2000/3
-
$
$ 21,012
$ 865,561
-
$
$ 187,076
-
$
26,409
$
2000/4
-
$
-
$
$ 865,561
-
$
$ 181,454
-
$
-
$
2001/1
$ 54,871
-
$
$ 1,072,973
-
$
$ 238,566
-
$
95,319
$
2001/2
-
$
-
$
$ 1,072,973
-
$
$ 218,274
-
$
-
$
2001/3
-
$
$ 23,324
$ 955,421
-
$
$ 206,495
-
$
29,122
$
2001/4
-
$
-
$
$ 955,421
-
$
$ 200,295
-
$
-
$
Total Cost =
$ 13,881,959
100%
Raw Material
$ 2,345,440
17%
Subcontracting
-
$
0%
Labor
Hiring & Layoff
$ 180,723
1%
Regular Wage
$ 11,017,396
79%
Overtime
-
$
0%
Inventory Holding
$ 338,400
2%
0
5,000
10,000
15,000
20,000
25,000
30,000
1
2
3
4
5
6
7
8
9
10
11
12
13
Production
('000lbs)
Subcontract
('000lbs)
Inventory
Production
('000lbs)
CR - 2026-3-16 20:18
Page 2
5SPC2.xls - Base Model