Answered step by step
Verified Expert Solution
Question
1 Approved Answer
office 2016 Excel Project EX16_XL_CH06_GRADER_CAP_HW - Delta Paint 1.4 Project Description: You are the production manager for Delta Paint, a regional manufacturing company that specializes
office 2016 Excel Project EX16_XL_CH06_GRADER_CAP_HW - Delta Paint 1.4 Project Description: You are the production manager for Delta Paint, a regional manufacturing company that specializes in customized paints. Your company sells paint by the galon, and you have the task of forecasting the best production blends to maximize proft and most effectively utilize resources. For the purpose of grading the project you are required to perform the following tasks Step Open the download file exploning e06 grader Capstone Startxisx. 0.000 Create approprlate range names for Total Production Cost (cell B18) and Gross Profit (cell B21) by selection, using the values In the left column 3.000 Edit the existing name range Employee Hourly_Wage to Hourly_Wages2018. Note, Mac users, In the Define Name dialog box, add the new named range, and delete the original one. 3.000 Use the newly created range names to create a formula to calculate Net Profit (in cell B22). 4.000 Create a new worksheet labeled Range Names, paste the newly created range name Information In cell Al, and reslze the columns as needed for proper display. 5.000 On the Forecast sheet, start In cell E3. Complete the serles of substitution values ranging from 2.000 10 to 200 at Increments of 10 gallons vertically down column E Enter references to the Total _Production_Cost, Gross Profit, and Net Profit cels in the correct locations (F2, G2, and H2 respectively) for a one-varlable data table. Use range names where Indicated. 3.000 Complete the one-varlable data table In the range E2:H22 using cell B4 as the column Input cell, and then format the results with Accounting Number Format with two declmal places. 5.000 Apply custom number formats to make the formula references appear as descriptive column headings. In F2, Total Costs; In G2, Gross Profit, In H2, Net Profit. Bold and center the headings and substitution values. 3.000 Copy the number of gallons produced substitution values from the one-varlable data table, and then paste the values starting in cell E26. 10 4.000 Updated: 10/22/2017
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started