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:

Fixed Cost = $2500

Variable Cost per Unit = $1.67

Selling Price per Unit = $4.40

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 Plastics2.xls. Place the data for CD-100 in column C and copy the formulas in rows 14, 16, and 18 to column C.