An Introduction to Management Science 13th Edition by David Anderson,Dennis Sweeney ,Thomas Williams ,Jeffrey Camm, Kipp Martin

Exercise 4

Open the file Nowlin Plastics. Recall that we have modeled total profit for the product CD-50 in this spreadsheet. Modify the spreadsheet to take into account production capacity and forecasted demand. If forecasted demand is less than or equal to capacity. Nowlin will produce only the forecasted demand; otherwise, they will produce the full capacity. For this example, use forecasted demand of 1200 and capacity of 1500. Hint: Enter demand and capacity into the data section of the model. Then use an IF statement to calculate production volume.