Craftsman Wage per month
Apprentice Wage per month
Hiring Cost
Severance Pay
Labor Hours/Craftsman/Month
Starting Trained Craftsmen
Maximum Layoffs
Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov Dec
Apprentices Hired
Craftsmen Fired
<= <= <= <= <= <= <= <= <= <= <= <= Minimum
Maximum Layoffs 0 0 0 0 0 0 0 0 0 0 0 0 Craftsmen
to Start the
Total Apprentices Next Year
Total Craftsmen >=
Labor Hours Available
>= >= >= >= >= >= >= >= >= >= >= >=
Required Labor Hours
Total
Labor Cost (Trainees)
Labor Cost (Trained Workforce)
Hiring Cost
Severance Pay
Total Cost
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
A B C D
Craftsman Wage per month $3,000
Apprentice Wage per month $2,000
Hiring Cost $2,500
Severance Pay $1,500
Labor Hours/Craftsman/Month 200
Starting Trained Craftsmen 20
Maximum Layoffs 10%
Jan Feb
Apprentices Hired 0 0
Craftsmen Fired 0 0
<= <=
Maximum Layoffs 2 2
Total Apprentices 0 0
Total Craftsmen 20 20
Labor Hours Available 4000 4000
>= >=
Required Labor Hours 3400 4000
Total
Labor Cost (Trainees) $0 $0 $0
Labor Cost (Trained Workforce) $60,000 $60,000 $120,000
Hiring Cost $0 $0 $0
Severance Pay $0 $0 $0
Total Cost $60,000 $60,000 $120,000
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
A B C D E F G H I J K L M N O
Craftsman Wage per month $3,000
Apprentice Wage per month $2,000
Hiring Cost $2,500
Severance Pay $1,500
Labor Hours/Craftsman/Month 200
Starting Trained Craftsmen 20
Maximum Layoffs 10%
Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov Dec
Apprentices Hired 0 1 0 0 0 0 2 3 2 1 0 0
Craftsmen Fired 0 0 0 0 2 1 0 0 0 0 0 1
<= <= <= <= <= <= <= <= <= <= <= <= Minimum
Maximum Layoffs 2 2 2 2.1 2.1 1.9 1.8 1.8 2 2.3 2.5 2.6 Craftsmen
to Start the
Total Apprentices 0 1 0 0 0 0 2 3 2 1 0 0 Next Year
Total Craftsmen 20 20 21 21 19 18 18 20 23 25 26 25 >= 25
Labor Hours Available 4000 4000 4200 4200 3800 3600 3600 4000 4600 5000 5200 5000
>= >= >= >= >= >= >= >= >= >= >= >=
Required Labor Hours 3400 4000 4200 4200 3000 2800 3000 4000 4500 5000 5200 4800
Total
Labor Cost (Trainees) $0 $2,000 $0 $0 $0 $0 $4,000 $6,000 $4,000 $2,000 $0 $0 $18,000
Labor Cost (Trained Workforce) $60,000 $60,000 $63,000 $63,000 $57,000 $54,000 $54,000 $60,000 $69,000 $75,000 $78,000 $75,000 $768,000
Hiring Cost $0 $2,500 $0 $0 $0 $0 $5,000 $7,500 $5,000 $2,500 $0 $0 $22,500
Severance Pay $0 $0 $0 $0 $3,000 $1,500 $0 $0 $0 $0 $0 $1,500 $6,000
Total Cost $60,000 $64,500 $63,000 $63,000 $60,000 $55,500 $63,000 $73,500 $78,000 $79,500 $78,000 $76,500 $814,500
Month Covered by Lease? Total Space
Month of Lease: 1 1 1 1 1 2 2 2 2 3 3 3 4 4 5 Leased Required
Length of Lease:
1 2 3 4 5 1 2 3 4 1 2 3 1 2 1 (sq. ft.) (sq. ft.)
Month 1 >=
Month 2 >=
Month 3 >=
Month 4 >=
Month 5 >=
Cost of Lease
(per sq. ft.)
Total Cost
Lease (sq. ft.)
1
2
3
4
5
6
7
8
9
10
A B C D E F G
Month Covered by Lease? Total Space
Month of Lease: 1 1 2 Leased Required
Length of Lease:
1 2 1 (sq. ft.) (sq. ft.)
Month 1 1 1 30,000 >= 30,000
Month 2 1 1 20,000 >= 20,000
Cost of Lease $65 $100 $65
(per sq. ft.)
Total Cost
Lease (sq. ft.) 10,000 20,000 0########
1
2
3
4
5
6
7
8
9
10
11
12
13
A B C D E F G H I J K L M N O P Q R S
Month Covered by Lease? Total Space
Month of Lease: 1 1 1 1 1 2 2 2 2 3 3 3 4 4 5 Leased Required
Length of Lease:
1 2 3 4 5 1 2 3 4 1 2 3 1 2 1 (sq. ft.) (sq. ft.)
Month 1 1 1 1 1 1 30,000 >= 30,000
Month 2 1 1 1 1 1 1 1 1 30,000 >= 20,000
Month 3 1 1 1 1 1 1 1 1 1 40,000 >= 40,000
Month 4 1 1 1 1 1 1 1 1 30,000 >= 10,000
Month 5 1 1 1 1 1 50,000 >= 50,000
Cost of Lease $65 ### ### ### $190 $65 ### ### ### $65 ### $135 $65 $100 $65
(per sq. ft.)
Total Cost
Lease (sq. ft.) 0 0 0 0 30,000 0 0 0 0 10,000 0 0 0 0 20,000 $7,650,000
Full Time Full Time Full Time Part Time Part Time Part Time Part Time
8am-4pm noon-8pm
4pm-midnight
8am-noon noon-4pm 4pm-8pm 8pm-midnight
Cost per Shift
Total Total
Shift Covers Time of Day? (1=yes, 0=no) Working Needed
8am-noon >=
noon-4pm >=
4pm-8pm >=
8pm-midnight >=
Workers per Shift
Total Times Total Total
Time of Day Full Time Part Time Cost
8am-noon >=
noon-4pm >=
4pm-8pm >=
8pm-midnight >=
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
A B C D E F G H I J K
Full Time Full Time Full Time Part Time Part Time Part Time Part Time
8am-4pm noon-8pm 4pm-midnight 8am-noon noon-4pm 4pm-8pm 8pm-midnight
Cost per Shift $112 $112 $112 $48 $48 $48 $48
Total Total
Shift Covers Time of Day? (1=yes, 0=no) Working Needed
8am-noon 1 1 6 >= 6
noon-4pm 1 1 1 8 >= 8
4pm-8pm 1 1 1 12 >= 12
8pm-midnight 1 1 6 >= 6
Workers per Shift
4 2 6 2 2 4 0
2
Total Times Total Total
Time of Day Full Time Part Time Cost
8am-noon 4 >= 4 $1,728
noon-4pm 6 >= 4
4pm-8pm 8 >= 8
8pm-midnight 6 >= 0
Beginning Balance
Minimum Balance
Investment A A A A B B B C D Ending Minimum
Year 1 2 3 4 1 2 3 2 5 Balance Balance
Year 1 >=
Year 2 >=
Year 3 >=
Year 4 >=
Year 5 >=
Year 6 >=
Dollars Invested
1
2
3
4
5
6
7
8
9
10
A B C D E F G H I J K
Beginning Balance
$60,000
Minimum Balance $0
Investment A A A B B B C Ending Minimum
Year 1 2 3 1 2 3 2 Balance Balance
Year 1 -1 -1 $0 >= $0
Year 2 -1 -1 -1 $0 >= $0
Year 3 1.4 -1 -1 $84,000 >= $0
Dollars Invested $60,000 $0 $0 $0 $0 $0 $0
1
2
3
4
5
6
7
8
9
10
11
12
13
A B C D E F G H I J K L M
Beginning Balance
$60,000
Minimum Balance $0
Investment A A A A B B B C D Ending Minimum
Year 1 2 3 4 1 2 3 2 5 Balance Balance
Year 1 -1 -1 $0 >= $0
Year 2 -1 -1 -1 $0 >= $0
Year 3 1.4 -1 -1 $0 >= $0
Year 4 1.4 -1 1.7 $0 >= $0
Year 5 1.4 1.7 -1 $0 >= $0
Year 6 1.4 1.7 1.9 1.3 $152,880 >= $0
Dollars Invested $60,000 $0 $84,000 $0 $0 $0 $0 $0 $117,600