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

Exercise 1

Open the file Nowlin Plastics. Recall that we have modeled total profit for the product CD-50 in this spreadsheet. Suppose we have a second product called a CD-100, with the following characteristics:
Extend the model so that the profit is calculated for each product and then totaled to give an overall profit generated for the two products. Use a CD-100 production volume of 1200. Save this file as Nowlin Plastics 2. Hint: Place the data for CD-100 in column C and copy the formulas in rows 14, 16. and 18 to column C.