Create appropriate range names for Total Production Cost cell B18 and Gross Profit cell B21 by selection, using the values in the left column. Leave a Reply Cancel reply Your email address will not be published.Īll rights reserved. Enter these values for the scenario:30and Enter these values for the scenario:25and Set the objective to calculate the highest Net Profit possible. Bold and center the headings and substitution values where necessary. Format the results with Accounting Number Format with two decimal places. Use cell B6 as the Row input cell and B4 as the Column input cell. Bold and center the headings and substitution values.
Complete the series of substitution values ranging from 10 to at increments of 10 gallons vertically down column E. Your email address will not be published. For any more assistance, please write to us at info libraay. Our team is writing How-To-Solve Guide for this project case currently and the same shall be made available soon. I got the completed copy of what this project would look like once finished.ĭear Barbara Bice, Your webpage clearly indicates the type of file one shall receive post purchase. I thought I was purchasing the information to complete the activity. Your company sells paint by the gallon, and you have the task of forecasting the best production blends to maximize profit and most effectively utilize resources.
You are the production manager for Delta Paint, a regional manufacturing company that specializes in customized paints.