Solve the following linear programming problems using the solver tool in Excel
Electro-Poly Corporation Number to Make Buy Model 1 0 0 Slip Ring Model 2 0 0 Model 3 0 0 Cost to Make Buy $50 $61 $83 $97 $130 $145 Total Cost $0 # Available #Needed 0 3,000 0 2,000 0 900 Hours Required Wiring Harnessing 2 1 1.5 2 3 1 Used 0 0 Available 10,000 5,000 Blue Ridge Hot Tubs Number to Make Unit Profits Aqua-Spas Hydro-Luxes 0 0 $350 $300 Total Profit $0 Constraints Pumps Req'd Labor Req'd Tubing Req'd 1 9 1 6 Used 0 0 0 Available 200 1566 2880 12 16 Retirement Planning Services, Inc. Amount Maximum Years to 10+ years? Bond Invested 25.0% Return Maturity (1-yes, 0-no) Rating ACME Chemical $0 $187,500 8.65% 11 1 1-Excellent Dyna Star $0 $187,500 9.50% 10 1 3-Good Eagle Vision $0 $187,500 10.00% 6 0 4-Fair Micro Modeling $0 $187,500 8.75% 10 1 1-Excellent OptiPro $0 $187,500 9.25% 7 0 3-Good Sabre Systems $0 $187,500 9.00% 13 1 2-Very Good Total Invested: $0 Total: $0 Total: $0 Total: Total Available: $750,000 Required: $375,000 Allowed: Good or worse? (1-yes, 0-no) 0 1 1 0 1 0 $0 $262,500 Tropicsun Grove Mt. Dora Eustis Clermont Distances From Groves to Plant at Ocala Orlando Leesburg 21 50 40 35 30 22 55 25 20 Grove Mt. Dora Eustis Clermont Received Capacity Bushels Shipped From Groves to Plant at Bushels Bushels Ocala Orlando Leesburg Shipped Available 0 0 0 0 275,000 0 0 0 0 400,000 0 0 0 0 300,000 0 0 0 200,000 600,000 225,000 Total Distance in bushel-miles) 0 Electro-Poly Corporation Number to Make Buy Model 1 0 0 Slip Ring Model 2 0 0 Model 3 0 0 Cost to Make Buy $50 $61 $83 $97 $130 $145 Total Cost $0 # Available #Needed 0 3,000 0 2,000 0 900 Hours Required Wiring Harnessing 2 1 1.5 2 3 1 Used 0 0 Available 10,000 5,000 Blue Ridge Hot Tubs Number to Make Unit Profits Aqua-Spas Hydro-Luxes 0 0 $350 $300 Total Profit $0 Constraints Pumps Req'd Labor Req'd Tubing Req'd 1 9 1 6 Used 0 0 0 Available 200 1566 2880 12 16 Retirement Planning Services, Inc. Amount Maximum Years to 10+ years? Bond Invested 25.0% Return Maturity (1-yes, 0-no) Rating ACME Chemical $0 $187,500 8.65% 11 1 1-Excellent Dyna Star $0 $187,500 9.50% 10 1 3-Good Eagle Vision $0 $187,500 10.00% 6 0 4-Fair Micro Modeling $0 $187,500 8.75% 10 1 1-Excellent OptiPro $0 $187,500 9.25% 7 0 3-Good Sabre Systems $0 $187,500 9.00% 13 1 2-Very Good Total Invested: $0 Total: $0 Total: $0 Total: Total Available: $750,000 Required: $375,000 Allowed: Good or worse? (1-yes, 0-no) 0 1 1 0 1 0 $0 $262,500 Tropicsun Grove Mt. Dora Eustis Clermont Distances From Groves to Plant at Ocala Orlando Leesburg 21 50 40 35 30 22 55 25 20 Grove Mt. Dora Eustis Clermont Received Capacity Bushels Shipped From Groves to Plant at Bushels Bushels Ocala Orlando Leesburg Shipped Available 0 0 0 0 275,000 0 0 0 0 400,000 0 0 0 0 300,000 0 0 0 200,000 600,000 225,000 Total Distance in bushel-miles) 0
