Question: 2 4 . Clean - Sheet Manufacturing Location. In this problem, we revisit the Martin - Beck plant location problem described in Problem 1 0
CleanSheet Manufacturing Location. In this problem, we revisit the MartinBeck plant location problem described in Problem The management of MartinBeck has decided to do a cleansheet analysis. Rather than assume that the St Louis plant is fixed as open, management wants to run a model that allows for any plant or set of plants to be open so that total cost is minimized. The annual fixed cost and the capacities of the proposed plants have been estimated see Problem The variable costs for the proposed plant locations are estimated to be the following: Detroit $ Toledo $ Denver $ and Kansas City $
We need an estimate of the fixed cost and variable cost at the current St Louis plant. The file StLouisMB contains observations from previous years that will allow us to estimate these.
a Use simple linear regression, with total cost as the dependent variable y and volume as the independent variable x The model y b bx will give you estimates of b the per unit variable cost and b annual fixed cost. Round the variable cost estimate to the nearest cent.
b Using the data from Problem the values of variable cost given above for the proposed locations and the fixed and variable costs for St Louis estimated in part a build an optimization model to minimize total cost to meet demand. Which plants are open and what is the total cost to meet demand?
Step by Step Solution
There are 3 Steps involved in it
1 Expert Approved Answer
Step: 1 Unlock
Question Has Been Solved by an Expert!
Get step-by-step solutions from verified subject matter experts
Step: 2 Unlock
Step: 3 Unlock
