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

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

  • Left Quote Icon

    Student Picture

  • Left Quote Icon

    Student Picture

  • Left Quote Icon

    Student Picture