Save-It Company Reclamation Problem
Grade A Grade B Grade C
Unit Amalg. Cost $3.00 $2.50 $2.00
Unit Selling Price $8.50 $7.00 $5.50
Treatment Funds Available $30,000
Save-It Company Reclamation Problem
Grade A Grade B Grade C
Unit Amalg. Cost $3.00 $2.50 $2.00
Unit Selling Price $8.50 $7.00 $5.50
Treatment Funds Available
Unit
Treament Minimum
Cost to Treat
Material 1 $3 1,500
Material 2 $6 1,000
Material 3 $4 2,000
Material 4 $5 500
$30,000
Amount
Available
3,000
2,000
4,000
1,000
Save-It Company Reclamation Problem
Grade A Grade B Grade C
Unit Amalg. Cost $3.00 $2.50 $2.00
Unit Selling Price $8.50 $7.00 $5.50
Treatment Funds Available
Unit
Treament Minimum
Cost to Treat
Material 1 $3 1,500
Material 2 $6 1,000
Material 3 $4 2,000
Material 4 $5 500
Mixture Specifications
Grade A, Material 1
Grade A, Material 2
Grade A, Material 3
Grade A, Material 4
Grade B, Material 1
Grade B, Material 2
Grade B, Material 4
Grade C, Material 1
$30,000
Amount
Available
3,000
2,000
4,000
1,000
Mixture
Percents
30% of Grade A
40% of Grade A
50% of Grade A
20% of Grade A
50% of Grade B
10% of Grade B
10% of Grade B
70% of Grade C
Save-It Company Reclamation Problem
Grade A Grade B Grade C
Unit Amalg. Cost $3.00 $2.50 $2.00 Total Treatment Cost
Unit Selling Price $8.50 $7.00 $5.50
Unit Profit $5.50 $4.50 $3.50 Treatment Funds Available
Material Allocation Unit
(pounds of material used for each product grade) Treament Minimum
Grade A Grade B Grade C Cost to Treat
Material 1 0.0 0.0 0 $3 1,500
Material 2 0.0 0.0 0 $6 1,000
Material 3 0.0 0.0 0 $4 2,000
Material 4 0.0 0.0 0 $5 500
Total Products 0.0 0.0 0
Mixture Specifications
Grade A, Material 1 0.0
Grade A, Material 2 0.0
Grade A, Material 3 0.0
Grade A, Material 4 0.0
Grade B, Material 1 0.0
Grade B, Material 2 0.0
Grade B, Material 4 0.0
Grade C, Material 1 0.0
$0 Range Name Cells
AmountAvailable M12:M15
$30,000 FundsAvailable K6
GradeA C16
GradeB D16
Total GradeC E16
Material Amount MaterialAllocation C12:E15
Treated Available MaterialTreated K12:K15
0 3,000 MinimumToTreat I12:I15
0 2,000 MixturePercents L19:L28
0 4,000 TotalProducts C16:E16
0 1,000 TotalProfit D20
TreatmentCost K4
Mixture UnitAmalgCost C4:E4
Percents UnitProfit C6:E6
0.0 30% of Grade A UnitSellingPrice C5:E5
0.0 40% of Grade A UnitTreatmentCost G12:G15
0.0 50% of Grade A
0.0 20% of Grade A
0.0 50% of Grade B
0.0 10% of Grade B
0.0 10% of Grade B
0.0 70% of Grade C
Save-It Company Reclamation Problem
Grade A Grade B Grade C
Unit Amalg. Cost $3.00 $2.50 $2.00 Total Treatment Cost
Unit Selling Price $8.50 $7.00 $5.50
Unit Profit $5.50 $4.50 $3.50 Treatment Funds Available
Material Allocation Unit
(pounds of material used for each product grade) Treament Minimum
Grade A Grade B Grade C Cost to Treat
Material 1 0.0 0.0 0 $3 1,500 =
Grade A, Material 3 0.0 =
Grade B, Material 4 0.0 =
Grade C, Material 1 0.0 = 0.0 40% of Grade A UnitTreatmentCost G12:G15
21 Grade A, Material 3 0.0 = 0.0 10% of Grade B
26 Grade B, Material 4 0.0 = 0.0 10% of Grade B
27
28 Grade C, Material 1 0.0 <= 0.0 70% of Grade C