Machine Country Contemporary Total Machine time

Router 1.5 2 957 1000

Sander 3 4.5 2000 2000
Polisher 2.5 1.5 1275 1500

Furniture Price % to be made How many?

Country 350 0.2 406
Contrmporary 450 0.3 174

Total Reve 220290

 Whole Cluster Crunch Roasted
Pounds Produced 1000 500 79.9999993768461 200

Minimum Required 1000 400 0 0

Maximum Produced 0 500 150 200

Unit selling price 5 4 3.2 4.5

Unit variable cost 3.15 2.6 2.16 3.1
Unit profit margin 1.85 1.4 1.04 1.4

Total profit 2913.2

Machine use
Hulling 1 1 1 1 1780
Roasting 2 1.5 1 1.75 3180
Coating 1 0.7 0.2 0 1366
Packaging 2.5 1.6 1.25 1 3600

Direct Materials
Nuts 0.6 0.4 0.2 1 1016
Chocolate 0.4 0.6 0.8 0 764
Media and No. of New
No. of Ads Customer Reached No of Ad Max. Limit Cost/Ad

News P: 1-10 900 10 10 $1,000

News P: 11-20 700 10 10 $900
News P: 21-30 400 0 10 800
TV: 1-5 10000 5 5 12000
TV: 6-10 7500 5 5 10000
TV: 11-15 5000 2 5 8000
Total Cost 145000
New Customer 113500
Month 1 2 3 4 5
1 0 5.684E-14 5000 5.684E-14 15000
2 0 0 0 4.547E-13
3 0 0 5000
4 0 10000
5 20000
Sq. ft leased 20000 30000 40000 35000 50000
Sq. Fft needed 20000 30000 40000 35000 50000

Lease term 1 2 3 4 5
1 55 55 55 55 55
2 95 95 95 95
3 130 130 130
4 155 155
5 185

Total cost 7000000

Month 1 2 3 4 5
Sq. feet N 20000 30000 40000 35000 50000
Cost/Sq ft 55 95 130 155 185
 Hyperlink Fastlink Speedlink Microlink Etherlink
To produce 500 1000 1500 2250 500

Hyperlink Fastlink Speedlink Microlink Etherlink Production Available

Pc board 20 15 10 8 5 60500 80000
Resistors 28 24 18 12 16 100000 100000
Memory chips 8 8 4 4 6 30000 30000
Assembly labour 0.75 0.6 0.5 0.65 1 3687.5 5000

Wholesale price 189 149 129 169 139

Manufacturing Cost 136 101 96 137 101
Profit 53 48 33 32 38

Total profit 215000

 Short term High Risk Tax free
Amount Return Maturity Risk Tax free
Bond 0-No and 1-Yes 0-No and 1-Yes 0-No and 1-Yes
A 20338.98 9.50% Long 0 High 1 Yes 1
B 20338.98 8% short 1 Low 0 Yes 1
C 29661.02 9% Long 0 Low 0 No 0
D 9E-13 9% Long 0 High 1 Yes 1
E 29661.02 9% short
Total 1 High
Total 1 No
Total 0
Total
Invested 100000 Invested
Required 50000 Invested
Required 50000 Invested
Required 40678
Total
Available 100000 Atleast 50000 Atleast 50000 Atleast 30000
Total Annual
Return 8898
Tax free return 3559
Annual 40% 3559
 1 2 3
Amount to Blend 342.8571 85.71429 171.4286

Required
1 2 3 Available Minimum Maximum
Sulphur 20% 40% 10% 0.2 20%
Iron Oxide 60% 30% 40% 0.5 30%
Potassium 20% 30% 50% 0.3 30% 45%
Total Cost 5 5.25 5.5

Available Required
Demand to fulfill 600 600

Total cost 3107.143

 Grade Basket Juice Total Supply
1 0 90 90 90
2 54.3 170.7 225 225
3 14.4 285.6 300 300
4 48.3 51.7 100 100
5 75 0 75 75
Total 192 598 790
Unit profit 2.5 1.75
Total profit 1526.5

Required Grade 3.75 2.5

Min Weighted Grade 720 1495
Actual Weighted Grade 720 1495
Actual Grade 3.75 2.5
 R1 R2 R3 S1 S2 S3
Barrrels of
115345.4 110719.4 73935.23 34654.64 239280.6 176064.8
Price 21 21 21 25 25 25
Cost 17.25 15.75 17.75 17.25 15.75 17.75
Profit 3.75 5.25 3.25 7.75 9.25 7.25
Rating 100 87 110 100 87 110
Min Rating 90 90 90 97 97 97 Barrels Barrels
Required Available
Capacity-1 1 1 150000 150000
Capacity-2 1 1 350000 350000
Capacity-3 1 1 250000 300000
Demand-R 1 1 1 300000 300000
Demand-S 1 1 1 450000 450000
Octane-R 10 -3 20 2300000 0
Octane-S 3 -10 13 0 0

Total Profit 5012500

 Time 12:00 AM 4:00 AM 8:00 AM 12:00 PM 4:00 PM 8:00 PM TOTAL
No of employee 45 170 80 150 150 45 640
Min. no of
Time period
12 am to 4 am 1 0 0 0 0 1 90 Employee
90
4 am to 8 am 1 1 0 0 0 0 215 215
8 am to 12pm 0 1 1 0 0 0 250 250
12 pm to 4 pm 0 0 1 1 0 0 230 165
4 pm to 8 pm 0 0 0 1 1 0 300 300
8 pm to 12 am 0 0 0 0 1 1 195 125
 Newsprint Packagaing Print Stock
Newspaper 0.85 0.8
Mixed Paper 0.9 0.8 0.7
White office paper 0.9 0.85 0.8
Cardboard 0.8 0.7

Newsprint Packagaing Print StockTons Used Tons Ava.

Newspaper 588.2353 11.7647048 0 600 600
Mixed Paper 0 71.4285714 428.5714 500 500
White office paper -1E-06 300.000001 0 300 300
Cardboard 0 397.779112 0 397.7791 400
Pulp Avialble 500 600 300
Pulp Required 500 600 300

Newsprint Packagaing Print StockCost/ton

Newspaper 6.5 11 15
Mixed Paper 9.75 12.25 9.5 16
White office paper 4.75 7.75 8.5 19
Cardboard 7.5 8.5 17

Total cost 44067.74

Vineyard Capacity Cost/bottle
1 3500 23
2 3100 25

Resturant Max. Demanded Price

1 1800 69
2 2300 67
3 1250 70
4 1750 66

Resturant
Production
Vineyard 1 2 3 4 Cost
1 $ 7 $ 8 $ 13 $ 9 $ 23
2 $ 12 $ 6 $ 8 $ 7 $ 25
Price/bottle 69 67 70 66

Resturant Bottle Bottles

Vineyard 1 2 3 4 Shipped Available
1 1800 1491.934 0 208.0656 3500 3500
2 2.842170943E-14 808.0656 1250 1041.934 3100 3100
Received 1800 2300 1250 1250
Demand 1800 2300 1250 1750

Resturant
Vineyard 1 2 3 4
1 $ 39 $ 36 $ 34 $ 34
2 $ 32 $ 36 $ 37 $ 34

Total Profit $ 241,750

Month
Additional Space 1 2 3 4 5
needed 25 10 20 10 5

Cost/1000 sq. ft 300 525 775 850 975

Month 1 2 3 4 5
1 15000 0 10000 0 40000
2 0 0 0 0 0
3 0 0 0 0 0
4 0 0 0 0 0
5 10000 0 0 0 0
Sq. ft leased
Additional space 25000 10000 20000 10000 50000
needed 25000 10000 20000 10000 50000

Month 1 2 3 4 5
1 300 300 300 300 300
2 525 525 525 525
3 775 775 775
4 850 850
5 975

Total Min cost 29250000

Invested plan Amount 1 2 3 4 5 6 7 8 9
A1 3.378E-12 -1 1.06
B1 0 -1 1.14
C1 1.683E-11 -1 1.18
D1 30722.74 -1 1.65
A2 3.581E-12 -1 1.06
A3 3.796E-12 -1 1.06
B3 0 -1 1.14
A4 2.388E-11 -1 1.06
C4 0 -1 1.18
A5 11320.75 -1 1.06
B5 39371.77 -1 1.14
A6 0 -1 1.06
A7 15094.34 -1 1.06
B7 15789.47 -1 1.14
A8 0 -1 1.06
Total Amount -30722.74 0 0 0 0 12000 14000 16000 18000
0 0 0 0 0 12000 14000 16000 18000

Initial Investement 30722.74

 Month
Investement Plan Amount 1 2 3 4 5 6 7
A1 241237 -1 1.018
B1 0 -1 1.035
C1 500126 -1 1.058
D1 0 -1 1.11
A2 245580 -1 1.018
A3 0 -1 1.01
B3 0 -1 1.035
A4 245580 -1 1.018
C4 283554 -1 1.058
A5 0 -1 1.01
B5 0 -1 1.035
A6 0 -1 1.018
Total Amount -741363 0 250000 0 250000 0 300000
Required month 0 0 250000 0 250000 0 300000

Initial Investment 741363

Month 1 2 3 4 5
Beginning Inventory 2750 1750 -2750 -8750 -14250
Units produced
Units Demanded 1000 4500 6000 5500 3500
End Inventory 1750 -2750 -8750 -14250 -17750

Minimum Inventory 1500 1500 1500 1500 1500

Maximum inventory 6000 6000 6000 6000 6000

1 2 3 4 5
Unit production cost 240 250 265 285 280

maximum production 4000 3500 4000 4500 4000

minimum production 2000 1750 2000 2250 2000

0.015 0.015 0.015 0.015 0.015

Monthly carrying cost
3.6 3.75 3.975 4.275 4.2

Total Inventory cost 8100 -1875 -22856.25 -49162.5 -67200

Total Production cost 0 0 0 0 0
Total cost 8100 -1875 -22856.25 -49162.5 -67200
 6
-17750

4000
-21750

1500
6000

6
260

3500
1750

0.015
3.9

-77025
0
-77025 -210018.75
 Month 1 Month 2 Month 3 Total Cost Cost/unit
Beginning Inventory 0 -300 -700 30
Atlanta Production 0 0 0 0 400
Phoenix Production 0 0 0 0 360
Demand 300 400 500
Ending Inventory -300 -700 -1200
Total cost

Monthly Plan Capacity 300 300 300

Minimum Plant Production

Total production cost

Atlanta 0 0 0
Phoenix 0 0 0
Inventory -4500 -15000 -28500 -48000
Ship From To Unit Cost Nodes Net Flow Supply/Demand
120 1 Newark 2 Boston 30 1 Newark -200 -200
80 1 Newark 4 Richmond 40 2 Boston 100 100
20 2 Boston 3 Columbus 50 3 Columbus 60 60
0 3 Columbus 5 Atlanta 35 4 Richmond 80 80
40 5 Atlanta 3 Columbus 40 5 Atlanta 170 170
0 5 Atlanta 4 Richmond 30 6 Mobile 70 70
0 5 Atlanta 6 Mobile 35 7 Jacksonville -280 -300
0 6 Mobile 5 Atlanta 25
0 7 Jacksonville 4 Richmond 50
210 7 Jacksonville 5 Atlanta 45
70 7 Jacksonville 6 Mobile 50

Total transportation cost 22350