Complete the series of substitution values from $15 to $40 at $5 increments

  

Complete the series of substitution values from $15 to $40 at $5 increments. 4 12 Enter the reference to the net profit formula in the correct location for a two-variable data table. 4 13 Complete the two-variable data table in the range E25:K45. Use cell B6 as the Row input cell and B4 as the Column input cell. Format the results with Accounting Number Format with two decimal places. 10 14 Apply a custom number format to make the formula reference appear as a descriptive column heading Wages. Bold and center the headings and substitution values where necessary. 3 15 Create a scenario named Best Case, using Units Sold, Unit Selling Price, and Employee Hourly Wage (use cell references). Enter these values for the scenario: 200, 30, and 15. 4 16 Create a second scenario named Worst Case, using the same changing cells. Enter these values for the scenario: 100, 25, and 20. 4 17 Create a third scenario named Most Likely, using the same changing cells. Enter these values for the scenario: 150, 25, and 15. 4 18 Generate a scenario summary report using the cell references for Total Production Cost and Net Profit. 5 19 Load the Solver add-in if it is not already loaded. Set the objective to calculate the highest Net Profit possible. 5 20 Use the units sold as changing variable cells. 4 21 Use the Limitations section of the spreadsheet model to set a constraint for raw materials. Use cell references to set constraints. 4 22 Set a constraint for labor hours. Use cell references to set constraints. 4 23 Set a constraint for maximum production capability. Use cell references to set constraints. 4 24 Solve the problem. Generate the Answer Report and Keep Solver Solution. 5 25 Create a footer on all four worksheets with your name on the left side, the sheet name code in the center, and the file name code on the right side. 4