# Homework 4.xlsx - Blue Computers Problem Kentucky Fixed...

• Homework Help
• 12

This preview shows page 1 - 4 out of 12 pages.

Blue Computers ProblemKentucky Fixed Cost150000000Pennsylvania Fixed Cost200000000North Carolina Fixed Cost150000000California Fixed Cost175000000Variable Prpduction and Shipping Cost (\$/unit)NortheastSoutheastMidwestSouthWestKentucky200185180175175Pennsylvania220170190180200North Carolina 215180180185185California175220220195195Plant to build (1 if built, 0 if not)Capacities of new plantsNorth Carolina11200000California01200000Units ShippedToNortheastSoutheastMidwestSouthWestKentucky800000000700000FromPennsylvania050000004000000N. Carolina 0040000000California00000Total800000500000400000400000700000=====Demand800000500000400000400000700000COSTSShipping costs \$ 511,500,000 Fixed Costs\$ 500,000,000 Total Cost\$ 1,011,500,000
TotalCapacity1500000 <=1500000900000 <=1000000400000 <=12000000 <=0
Microsoft Excel Answer ReportWorksheet: Problem 2aReport Created:Tue Feb 19 2019 23:32:35 GMT-0600 (Central Standard Time)Result: Integer solution found within tolerance.Engine: Standard LP/QuadraticSolution Time: 57 millisecondsIterations: 10Subproblems: 2Incumbent Solutions: 2Objective Cell (Min)CellOriginal VaFinal Value\$C\$321.012E+09 1.012E+09Decision Variable CellsCellOriginal VaFinal Value\$C\$21800000800000\$D\$2100\$E\$2100\$F\$2100\$G\$21700000700000\$C\$2200\$D\$22500000500000\$E\$2200\$F\$22400000400000\$G\$2200\$C\$2300\$D\$2300\$E\$23