Open the file Nowlin Plastics Recall that we have modeled total Open the file Nowlin Plastics….

Open the file Nowlin Plastics Recall that we have modeled total
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. Enter demand and capacity into the data section of the model. Then use an IF statement to calculate production volume.

Open the file Nowlin Plastics Recall that we have modeled total

 

Looking for a Similar Assignment? Hire our Top Uk Tutors while you enjoy your free time! All papers are written from scratch and are 100% Original. Try us today! Active Discount Code FREE15