# Question: Modify the original Grand Prix example by increasing the demand

Modify the original Grand Prix example by increasing the demand at each region by 200, so that total demand is well above total plant capacity. This means that some demands cannot be supplied. Suppose there is a unit “penalty” cost at each region for not supplying an automobile. Let these unit penalty costs be $600, $750, $625, and $550 for the four regions. Develop a model to minimize the sum of shipping costs and penalty costs for unsatisfied demands.

## Answer to relevant Questions

How difficult is it to expand the original Red Brand model? Answer this by adding a new plant, two new warehouses, and three new customers, and modify the spreadsheet model appropriately. You can make up the required input ...The current solution to Sure Step’s no-backlogging aggregate planning model does quite a lot of firing. Run a one-way SolverTable with the firing cost as the input variable and the numbers fired as the outputs. Let the ...In the Barney-Jones investment problem, increase the maximum amount allowed in any investment to $150,000. Then run a one-way sensitivity analysis to the money market rate on cash. Capture one output variable: the maximum ...In the pension fund problem, you know that if the amount of money allocated initially is less than the amount found by Solver, James will not be able to meet all of the pension fund payments. Use the current model to ...Suppose in the capital budgeting model in Figure 14.40 that each investment requires $2000 during year 2 and only $5000 is available for investment during year 2.a. Assuming that available money un-invested at the end of ...Post your question