[Solved] 7. Switch to the Corporate Programs workc

Answered step by step

Verified Expert Solution

Link Copied!

Question

1 Approved Answer

Posted on Sep 18, 2024

7. Switch to the Corporate Programs workcheet Grete a Seatter wah stralght Lines Analysils. 8. Modfy the new chart as follows: 3. Reske and repoetion

7. Switch to the Corporate Programs workcheet Grete a Seatter wah stralght Lines Analysils. 8. Modfy the new chart as follows: 3. Reske and repoetion the chart se that is coven the range E15 330. b. Remove the chart tide from the ohert c. Repesition the chart legend to the righe of the chart. d. Add Wet Income as the vertiol axis tibe and Hours as the horlaontal avils tide. e. Change the colors of the chart to Menochrematic Palette 2 (2nd row in the Menochrematic paletre). 9. Change the Rounds Axis Optoons for the new chart ab follows: a. Crange the Minimum Bounds of the vertical axis to 20,000 and lesve the Maximum beunds at 40,009 . b. Set the hertrontal axis to cros at the aris velue - 20,900 . c. Change the Number format of the verteal ans to Currencr with o decimal places and 15 as the symbel. d. Change the Minimum Bounds of the hortaseal auls to soo and the Maximum Bounds to 1700. 10. Fidit the chart series names as follows: a. For Series 1, use cell FS as the meries name. b. For Serles 2 , use cell GS as the series name. c. For Serles 3, uet cell M5 as the serles nome. d. For Series 4, uge cell IS as the series name. e. For Series 5 , use cell 25 as the series name. 11. Bruce wants to determine whether partieding with another fitnes compeny nould reduce the cocts of fitress troining sentees Simht bo the Training Freviders werksheet, and then nun solver to solve this protelem as follows: a. Set the objectve as minimining the value in otl flo (total costs). b. Use the range CA:E4 as the dhanging varinale cella. c. F4 600 , the total hours of fitress seviaes srovided d. F10 is less than or equal to 130,000 , the maximum fees paid to another fitness company e. C4:E4 is less than or equal to 220 , the maximum hours provided by a single fitness company f. C4:E4 should be an Integer 9. Run Solver, keep the solution, and then return to the Solver Parameters dialog box. Save the model to the range B14:B21, and then close the Solver Parameters dialog box. 12. Switch to the A III Services worksheet. Use the Scenario Manager to create a Scenario Summary report that summarizes the effect of the Current, Increase Hourly, and Contractors scenarios. Use the range C17:E17 as the result cells. 13. Switch back to the AI/ Services worksheet. Use the Scenario Manager as follows to compare the profit per hour in each scenario: a. Create a Scenario PivotTable report for result cells C17:E17. b. Remove the Filter field from the PivotTable. c. Change the number format of the Profit_Per_Hour__Training, Profit_Per_Hour_ Consulting, and Profit_Per_Hour_Corporate fields (located in the Values box of the PivotTable Field List) to Currency with 2 decimal places and $ as the symbol. d. Use Personal Training as the row label value in cell B3, Consulting as the value in cell C3, and Corporate Programs as the value in cell D3. e. In cell A1, use Profit Per Hour as the report title. f. Format the report title just created in cell A1 using the Title cell style. g. Resize columns A-D to 17.00. 4. Add a PivotChart to the Scenario PivotTable worksheet as follows: a. Create a Clustered Column PivotChart based on the PivotTable. b. Resize and reposition the chart so that it covers the range A8:D21. c. Hide the field buttons in the chart. [Mac Hint: The Fleld Buttons option is not available on Excel 2019 for the Mac, so Mac users can ignore this instruction.] 7. Switch to the Corporate Programs workcheet Grete a Seatter wah stralght Lines Analysils. 8. Modfy the new chart as follows: 3. Reske and repoetion the chart se that is coven the range E15 330. b. Remove the chart tide from the ohert c. Repesition the chart legend to the righe of the chart. d. Add Wet Income as the vertiol axis tibe and Hours as the horlaontal avils tide. e. Change the colors of the chart to Menochrematic Palette 2 (2nd row in the Menochrematic paletre). 9. Change the Rounds Axis Optoons for the new chart ab follows: a. Crange the Minimum Bounds of the vertical axis to 20,000 and lesve the Maximum beunds at 40,009 . b. Set the hertrontal axis to cros at the aris velue - 20,900 . c. Change the Number format of the verteal ans to Currencr with o decimal places and 15 as the symbel. d. Change the Minimum Bounds of the hortaseal auls to soo and the Maximum Bounds to 1700. 10. Fidit the chart series names as follows: a. For Series 1, use cell FS as the meries name. b. For Serles 2 , use cell GS as the series name. c. For Serles 3, uet cell M5 as the serles nome. d. For Series 4, uge cell IS as the series name. e. For Series 5 , use cell 25 as the series name. 11. Bruce wants to determine whether partieding with another fitnes compeny nould reduce the cocts of fitress troining sentees Simht bo the Training Freviders werksheet, and then nun solver to solve this protelem as follows: a. Set the objectve as minimining the value in otl flo (total costs). b. Use the range CA:E4 as the dhanging varinale cella. c. F4 600 , the total hours of fitress seviaes srovided d. F10 is less than or equal to 130,000 , the maximum fees paid to another fitness company e. C4:E4 is less than or equal to 220 , the maximum hours provided by a single fitness company f. C4:E4 should be an Integer 9. Run Solver, keep the solution, and then return to the Solver Parameters dialog box. Save the model to the range B14:B21, and then close the Solver Parameters dialog box. 12. Switch to the A III Services worksheet. Use the Scenario Manager to create a Scenario Summary report that summarizes the effect of the Current, Increase Hourly, and Contractors scenarios. Use the range C17:E17 as the result cells. 13. Switch back to the AI/ Services worksheet. Use the Scenario Manager as follows to compare the profit per hour in each scenario: a. Create a Scenario PivotTable report for result cells C17:E17. b. Remove the Filter field from the PivotTable. c. Change the number format of the Profit_Per_Hour__Training, Profit_Per_Hour_ Consulting, and Profit_Per_Hour_Corporate fields (located in the Values box of the PivotTable Field List) to Currency with 2 decimal places and $ as the symbol. d. Use Personal Training as the row label value in cell B3, Consulting as the value in cell C3, and Corporate Programs as the value in cell D3. e. In cell A1, use Profit Per Hour as the report title. f. Format the report title just created in cell A1 using the Title cell style. g. Resize columns A-D to 17.00. 4. Add a PivotChart to the Scenario PivotTable worksheet as follows: a. Create a Clustered Column PivotChart based on the PivotTable. b. Resize and reposition the chart so that it covers the range A8:D21. c. Hide the field buttons in the chart. [Mac Hint: The Fleld Buttons option is not available on Excel 2019 for the Mac, so Mac users can ignore this instruction.]