Blue Computers, a major server manufacturer in the U.S., currently…
Question Answered step-by-step Blue Computers, a major server manufacturer in the U.S., currently… Blue Computers, a major server manufacturer in the U.S., currently has plants in Kentucky and Pennsylvania. The Kentucky plant has a capacity of 1 million units a year, and the Pennsylvania plant has a capacity of 1.5 million units per year. The firm divides the U.S. into five markets: northeast, southeast, Midwest, south, and west. Each server sells for $1,000. The firm anticipates a 50% growth in demand (in each region) this year and wants to build a plant with a capacity of 1.5 million units per year to accommodate the growth. Potential sites being considered are in North Carolina and California. Variable Production and Shipping Costs for Blue Computers ($ per unit) NortheastSoutheastMidwestSouthWestAnnual Fixed Cost (million $)Kentucky185+22180175175200150Pennsylvania170190180200220200N. Carolina180180185185215150California220220195195175150Demand (in 1000 units)700400400300600 Optimize the Blue Computers production and shipping network. Where should they build their new plant? Please show me how to solve in Excel. Engineering & Technology Industrial Engineering Supply Chain Management BUSINESS OM467 Share QuestionEmailCopy link Comments (0)
