II- Scenario Manager 1. Create a new sheet and name the sheet as scenario manager. In the new sheet add the following:

The assumptions will serve as the increase of the amount per quarter. 2. Compute the increase of quarter 2 to 4 by adding the assumption percentage to the quarter 1 amount. This means the quarter 2 will have a 5% percent increase, quarter 3 another 5 percent based quarter 2 and quarter 4 will have another 5 percent increa

please help me as early as possible, clearly show all the formulaes and steps u followed to get to the result.

simply create the table in the excel

like this.and then follow the given instructions step by step..

Ul Umpull ule ular score for each employee. Use a function. II- Scenario Manager 1. Create a new sheet and name the sheet as scenario manager. In the new sheet add the following: Quarter 1 588235.29 Sales Forecast for 2020 Quarter 2 Quarter 3 Quarter 4 Total Sales Cost of Goods Sold Gross Profit Assumptions 5% 2% Expenses Income 25% nome/chronos/u-7028e57d4a24cde5175aaa7679ae2fe0ef2516c7/MyFiles/Downloads/New%20folder/manu.pdf Compute the increase of quarter 2 to 4 by adding the assumption percentage to the quarter 1 amount. This means the will have a 5% percent increase, quarter 3 another 5 percent based quarter 2 and quarter 4 will have another 5 percer ased on quarter 3. In getting the 5 percent you should use the cell that contains the 5% instead of just typing 5%. aple: ollowing will be the result: 1 Sales Forecast for 2020 Quarter 1 Quarter 2 Quarter 3 Quarter 4 588235.29 617647.0545 648529.4072 680955.8776 Total 2535367. 6 Assumptions 5 % Sales Cost of Goods Sold Gross Profit Expenses Income e cost of goods will be 2 percent of the quarter sales. You should use the cell with the 2% as part of the formula. Income 3. The cost of goods will be 2 percent of the quarter sales. You should use the cell with the 2% as part of the formula. Compute the sum as well. Result: Sales Forecast for 2020 Quarter 1 Quarter 2 Quarter 3 Quarter 4 Total 588235.29 617647.0545 648529.4072 680955.8776 2535367. 6 11764.7058 12352.941091 12970.588141 13619.11755 50707.353 Assumptions 5 % 2 % Sales Cost of Goods Sold Gross Profit Expenses Income 25% 9 MO 4. The gross profit is the sales minus cost of goods sold. Compute the total as well. Assumptions Sales Cost of Goods Sold Gross Profit Expurses Income Sales Forecast for 2020 Quarter 1 Quarter 2 1 Quarter 3 Quarter 4 Total 588235.29 617647.0545 648529.4072 680955.8776 2535367.6 11764.7058 12352.94109 12970.588141 13619.11755 50707.353 $576,470.58 $605,294.11 $635,558.82 $667,336.76 2484660.3 25% 5. The expenses is 25% of the sales per quarter. You should use the cell with the 25% assumption as part of the formula. 25% Income 5. The expenses is 25% of the sales per quarter. You should use the cell with the 25% assumption as part of the formula. Assumptions Sales SE Cost of Goods Sold Gross Profit Expenses Income W E ER Sales Forecast for 2020 Quarter 1 Quarter 2 Quarter 3 Quarter 4 Total 588235.29 617647.0545 648529.4072 680955.8776 2535367.6 1 1764.7058 12352.94109 12970.58814 13619.11755 50707.353 $576,470.58 $605,294.11 $635,558.82 $667,336.76 2484660.3 147058.8225 154411.7636 162132.3518 170238.9694 633841.91 6. The income is gross profit minus expenses. Compute for all the quarters including the total. 6. The income is gross profit minus expenses. Compute for all the quarters including the total. Assumptions 5% 2 % Sales Cost of Goods Sold Gross Profit Expenses Income Sales Forecast for 2020 Quarter 1 Quarter 2 Quarter 3 Quarter 4 Total 588235.29 617647.0545 648529.4072 680955.8776 2535367.6 11764.705812352.94109 12970.58814 13619.11755 50707.353 $576,470.58 $605,294.11 $635,558.82 $667,336.76 2484660.3 147058.8225154411.7636 162132.3518 170238.9694 633841.91 $429,411.76 $450,882.35 $473,426.47 $497,097.79 1850818.4 9 MBO 7. Add four scenarios. a) The first scenario is the current one with 5% sales, 2% cost of goods sold and 25% expenses. We will name this scenario as Current. b) The second scenario will have 15% sales, 8% cost of goods sold and 30% expenses. We will name this scenario as Optimistic. c) The third scenario will have 12% sales, 5% cost of goods sold and 27% expenses. We will name this scenario as Medium At the end you should have 3 scenarios: Assumptions Scenario Manager Sales Costol Goods Sold Gross Profit Sales Forecast for 2020 Quarter 1 Quarter 2 Quarter 3 Quarter 4 1 Total 588235 29 617647.0545 648529.4072 680955.8776 2535367.6 11764.7058 12352.94 109 12970.58814 13619.11755 50707 353 $576,470.58 $605,294.11 $635,558.82 $667 336.76 2484660.3 CAV2:56 t the end you should have 3 scenarios: Assumptions Scenario Manager Sales Forecast for 2020 Quarter 1 Quarter 2 Quarter 3 Quarter 4 Total 588235.29 617647.0545 648529.4072 680955.8776 2535367.6 11764.7058 12352.94 109 12970.58814 13619.11755 50707.353 $576,470.58 $605,294.11 $635,558.82 $667,336.76 2484660.3 47058.8225154411.7636 162132.3518 170238.9694 633841.91 $429,411.76 $450.882.35 $473,426.47 $497,097.79 1850818.4 Sales Cost of Goods Sold Gross Profit Expenses Income Scenarios: 1 Optimistic Medium Changing calls: 1454-3H$5,ST Created by Dr. Cesar Clemente on 11/2011 Modified by lay Sky on 2020-03-19 Comment CAV 9 - - - B. Create a summary for your scenarios. It should be like the one below. Scenario Summary 27% Current Values Current Optimistic Medum Changing Cells: Sales 5% 15% 12% Cost of Goods Sold 2% 8% 5% Expenses 25% 25% 30% Result Cells Total_Income $1.850,81837 $1.850.818 37 $1.821.113 22 $1.911.731.19 Notes Current Values column represents values of changing cells at time cenario Summary Report was created Changing cells for each scenario are highlighted in gray Format and create the following chart for your table. It should be like the one below. 9. Format and create the following chart for your table. It should be like the one below. Sales Forecast for 2020 Quarter 1 Quarter 2 Quarter 3 Quarter 4 Total 588235.29 617647.0545 648529.4072 680955.8776 2535367. 6 11764.7058 12352.94109 12970.58814 13619.11755| 50707.353 $576,470.58 $605,294.11 $635,558.82 $667,336.76 2484660.3 147058.8225154411.7636 162132.3518 170238.9694 633841.91 $429,411.76 $450,882.35 $473,426.47 $497,097.79 1850818.4 Assumptions 5 % 2 % Sales Cost of Goods Sold Gross Profit Expenses Income 2 5% Sales Forcast for 2020 $497.10 Quarter 4 680-9558776 $473.43 Quarter 3 648.5294072 $450.38 Quarter 2 617.6470545 $429.41 Quarter 588.23529 0 200 100 300 600 400 500 700 3800 Thousands income Sales 00) DUWUDUS/New%20folder/manu.pdf 9. Compute the total score for each employee. Use a function. II- Scenario Manager 1. Create a new sheet and name the sheet as scenario manager. In the new sheet add the following: Sales Forecast for 2020 Quarter 2 Quarter 3 Quarter 1 588235.29 Quarter 4 Total Assumptions 59 29 Sales Cost of Goods Sold Gross Profit Expenses Income 259 In pluginfile.php?file=/16 X t Site assessment - Has x Book 3.xlsx - Microsoft X Downloads X manu.pdf X + le /home/chronos/u-7028e57d4a24cde5175aaa7679ae2fe0ef2516c7/MyFiles/Downloads/New%20folder/manu.pdf a 2. Compute the increase of quarter 2 to 4 by adding the assumption percentage to the quarter 1 amount. This means the quarter 2 will have a 5% percent increase, quarter 3 another 5 percent based quarter 2 and quarter 4 will have another 5 percent increase based on quarter 3. In getting the 5 percent you should use the cell that contains the 5% instead of just typing 5%. Example: The following will be the result: Assumptions Sales Forecast for 2020 Quarter 1 Quarter 2 Quarter 3 Quarter 4 588235.29 617647.0545 648529.4072 680955.8776 Total 2535367.6 Sales Cost of Goods Sold Gross Profit Expenses Income 3. The cost of goods will be 2 percent of the quarter sales. You should use the cell with the 2% as part of the formula. Compute the sum as well. Cost of Goods Sold Gross Profit Expenses Income 3. The cost of goods will be 2 percent of the quarter sales. You should use the cell with the 2% as part of the formula. Compute the sum as well. Result: Assumptions Sales Forecast for 2020 Quarter 1 Quarter 2 Quarter 3 Quarter 4 Total 588235.29 617647.0545 648529.4072 680955.8776 2535367.6 1 1764.7058 12352.94109 12970.588141 13619.11755 50707.353 2 Sales Cost of Goods Sold Gross Profit 2576 Expenses Income 4. The gross profit is the sales minus cost of goods sold. Compute the total as well. Sales Forecast for 2020 Quarter 1 Quarter 2 Quarter 3 Quarter 4 Total 588235.29 617647,0545 648529.4072 680955.8776 2535367.6 11764.705812352.94 109 12970.58814 13619.11755 50707.353 $576,470.58 $605,294.11 $635,558.82 $667,336.76 2484660.3 Assumptions Sales Cost of Goods Sold Gross Profit Expenses Income 5X 3. The expenses is 25% of the sale per quarter. You should use the cell with the 25% assumption as part of the fol 5. The expenses is 25% of the sales per quarter. You should use the cell with the 25% assumption as part of the formula. Assumptions Sales Cost of Goods Sold Gross Profit Sales Forecast for 2020 Quarter 1 Quarter 2 Quarter 3 Quarter 4 Total 588235.29 617647.0545 648529.4072 680955.8776 2535367.6 11764.7058 12352.94 109 12970.58814 13619.1175550707.353 $576,470.58 $605,294.11 $635,558.82 $667,336.76 2484660.3 147058.8225154411.7636 162132.3518 170238.9694 633841.91 Expenses 2 5 income 6. The income is gross profit minus expenses. Compute for all the quarters including the total. Assumptions Sales Cost of Goods Sold Gross Profit Expenses Income Sales Forecast for 2020 Quarter 1 Quarter 2 Quarter 3 Quarter 4 Total 588235.29 617647.0545 648529.4072 680955.8776 2535367.6 11764.7058 12352.94 1091 12970.5881413619.1175550707.353 $576,470.58 $605,294.11 $635,558.82 $667,336.76 2484660.3 147058.8225 154411.7636 162132.3518 170238.9694 633841.91 $429,411.76 $450,882.35 $473,426.47 $497,097.791850818,4 9 M = O File /home/chronos/u-7028e57d4a24cde5175aaa7679ae2fe0ef2516c7/MyFiles/Downloads/New%20folder/manu.pdf Q* 7. Add four scenarios a) The first scenario is the current one with 5% sales, 2% cost of goods sold and 25% expenses. We will name this scenario as Current. b) The second scenario will have 15% sales, 8% cost of goods sold and 30% expenses. We will name this scenario as Optimistic. C) The third scenario will have 12% sales, 5% cost of goods sold and 27% expenses. We will name this scenario as Medium At the end you should have 3 scenarios: Scenario Manager Assumptions Salt forecast for 2020 Quarter1 Ouarter Quarter 3 Quarter 4 Total 588235.29 6176470545 648529.4072680955.8776 25353676 1 7 5087 136 19 11755 50707/353 Scenarios Cater At the end you should have 3 scenarios: Assumptions Scenario Manager Sales Forecast for 2020 Quarter 1 Quarter 2 Quarter 3 Quarter 4 Total 588235.29 617647.0545 648529.4072 680955.8776 2535367.6 11764.7058 12352.94109 12970.58814 13619.11755 50707.353 $576,470.58 $605,294.11 $635,558.82 $667,336.76 2484660.3 147058.8225 154411.7636 162132.3518 170238.9694 633841.91 $429,411.76 $450,882.35 $473,426.47 $497,097.79 1850818.4 Scenarios: CUET ER Optimistic Medium Expenses Income Merge Sumar Changing cells Comment SH54:5H55,551 Created by Dr. Caesar Clemente on 1/2013 Modified by Jay Siyon 2020-01-19 Show 8. Create a summary for your scenarios. It should be like the one below. Scenario Summary Current Values Current Optimistic Medium Changing Cells: Sales 5% 15% 12% Cost of Goods Sold 2% 8% 5% Expenses 25% 30% 27% Result Cells: Total Income $1.850.818.97 $1.850.818 37 $1,821.113.22 $1.911.731219 Notes Current Values column represents values of changing cells at time Scenario Summary Report was created Changing cells for each scenario are highlighted in gray 26 1 al O l e I chawla ha lile the one below Format and create the following chart for your table. It should be like the one below. Assumptions Sales Cost of Goods Sold Gross Profit Expenses Income Sales Forecast for 2020 Quarter 1 Quarter 2 Quarter 3 Quarter 4 Total 588235.29 617647.05451 648529.4072 680955.8776 2535367.6 11764.7058 12352.94109 12970.58814 13619.11755 50707.353 $576,470.58 $605,294.11 $635,558.82 $667,336.76 2484660.3 147058.8225154411.7636 162132.3518 170238.9694 633841.91 $429,411.76 $450,882.35 $473,426.47 $497,097.79 1850818.4 2 5% Sales Forcast for 2020 $497,10 Quarter 4 59029558776 $473.43 Quarter 6445294072 $450.88 617.6470549 Quarter 5429.41 2523 900 Ul Umpull ule ular score for each employee. Use a function. II- Scenario Manager 1. Create a new sheet and name the sheet as scenario manager. In the new sheet add the following: Quarter 1 588235.29 Sales Forecast for 2020 Quarter 2 Quarter 3 Quarter 4 Total Sales Cost of Goods Sold Gross Profit Assumptions 5% 2% Expenses Income 25% nome/chronos/u-7028e57d4a24cde5175aaa7679ae2fe0ef2516c7/MyFiles/Downloads/New%20folder/manu.pdf Compute the increase of quarter 2 to 4 by adding the assumption percentage to the quarter 1 amount. This means the will have a 5% percent increase, quarter 3 another 5 percent based quarter 2 and quarter 4 will have another 5 percer ased on quarter 3. In getting the 5 percent you should use the cell that contains the 5% instead of just typing 5%. aple: ollowing will be the result: 1 Sales Forecast for 2020 Quarter 1 Quarter 2 Quarter 3 Quarter 4 588235.29 617647.0545 648529.4072 680955.8776 Total 2535367. 6 Assumptions 5 % Sales Cost of Goods Sold Gross Profit Expenses Income e cost of goods will be 2 percent of the quarter sales. You should use the cell with the 2% as part of the formula. Income 3. The cost of goods will be 2 percent of the quarter sales. You should use the cell with the 2% as part of the formula. Compute the sum as well. Result: Sales Forecast for 2020 Quarter 1 Quarter 2 Quarter 3 Quarter 4 Total 588235.29 617647.0545 648529.4072 680955.8776 2535367. 6 11764.7058 12352.941091 12970.588141 13619.11755 50707.353 Assumptions 5 % 2 % Sales Cost of Goods Sold Gross Profit Expenses Income 25% 9 MO 4. The gross profit is the sales minus cost of goods sold. Compute the total as well. Assumptions Sales Cost of Goods Sold Gross Profit Expurses Income Sales Forecast for 2020 Quarter 1 Quarter 2 1 Quarter 3 Quarter 4 Total 588235.29 617647.0545 648529.4072 680955.8776 2535367.6 11764.7058 12352.94109 12970.588141 13619.11755 50707.353 $576,470.58 $605,294.11 $635,558.82 $667,336.76 2484660.3 25% 5. The expenses is 25% of the sales per quarter. You should use the cell with the 25% assumption as part of the formula. 25% Income 5. The expenses is 25% of the sales per quarter. You should use the cell with the 25% assumption as part of the formula. Assumptions Sales SE Cost of Goods Sold Gross Profit Expenses Income W E ER Sales Forecast for 2020 Quarter 1 Quarter 2 Quarter 3 Quarter 4 Total 588235.29 617647.0545 648529.4072 680955.8776 2535367.6 1 1764.7058 12352.94109 12970.58814 13619.11755 50707.353 $576,470.58 $605,294.11 $635,558.82 $667,336.76 2484660.3 147058.8225 154411.7636 162132.3518 170238.9694 633841.91 6. The income is gross profit minus expenses. Compute for all the quarters including the total. 6. The income is gross profit minus expenses. Compute for all the quarters including the total. Assumptions 5% 2 % Sales Cost of Goods Sold Gross Profit Expenses Income Sales Forecast for 2020 Quarter 1 Quarter 2 Quarter 3 Quarter 4 Total 588235.29 617647.0545 648529.4072 680955.8776 2535367.6 11764.705812352.94109 12970.58814 13619.11755 50707.353 $576,470.58 $605,294.11 $635,558.82 $667,336.76 2484660.3 147058.8225154411.7636 162132.3518 170238.9694 633841.91 $429,411.76 $450,882.35 $473,426.47 $497,097.79 1850818.4 9 MBO 7. Add four scenarios. a) The first scenario is the current one with 5% sales, 2% cost of goods sold and 25% expenses. We will name this scenario as Current. b) The second scenario will have 15% sales, 8% cost of goods sold and 30% expenses. We will name this scenario as Optimistic. c) The third scenario will have 12% sales, 5% cost of goods sold and 27% expenses. We will name this scenario as Medium At the end you should have 3 scenarios: Assumptions Scenario Manager Sales Costol Goods Sold Gross Profit Sales Forecast for 2020 Quarter 1 Quarter 2 Quarter 3 Quarter 4 1 Total 588235 29 617647.0545 648529.4072 680955.8776 2535367.6 11764.7058 12352.94 109 12970.58814 13619.11755 50707 353 $576,470.58 $605,294.11 $635,558.82 $667 336.76 2484660.3 CAV2:56 t the end you should have 3 scenarios: Assumptions Scenario Manager Sales Forecast for 2020 Quarter 1 Quarter 2 Quarter 3 Quarter 4 Total 588235.29 617647.0545 648529.4072 680955.8776 2535367.6 11764.7058 12352.94 109 12970.58814 13619.11755 50707.353 $576,470.58 $605,294.11 $635,558.82 $667,336.76 2484660.3 47058.8225154411.7636 162132.3518 170238.9694 633841.91 $429,411.76 $450.882.35 $473,426.47 $497,097.79 1850818.4 Sales Cost of Goods Sold Gross Profit Expenses Income Scenarios: 1 Optimistic Medium Changing calls: 1454-3H$5,ST Created by Dr. Cesar Clemente on 11/2011 Modified by lay Sky on 2020-03-19 Comment CAV 9 - - - B. Create a summary for your scenarios. It should be like the one below. Scenario Summary 27% Current Values Current Optimistic Medum Changing Cells: Sales 5% 15% 12% Cost of Goods Sold 2% 8% 5% Expenses 25% 25% 30% Result Cells Total_Income $1.850,81837 $1.850.818 37 $1.821.113 22 $1.911.731.19 Notes Current Values column represents values of changing cells at time cenario Summary Report was created Changing cells for each scenario are highlighted in gray Format and create the following chart for your table. It should be like the one below. 9. Format and create the following chart for your table. It should be like the one below. Sales Forecast for 2020 Quarter 1 Quarter 2 Quarter 3 Quarter 4 Total 588235.29 617647.0545 648529.4072 680955.8776 2535367. 6 11764.7058 12352.94109 12970.58814 13619.11755| 50707.353 $576,470.58 $605,294.11 $635,558.82 $667,336.76 2484660.3 147058.8225154411.7636 162132.3518 170238.9694 633841.91 $429,411.76 $450,882.35 $473,426.47 $497,097.79 1850818.4 Assumptions 5 % 2 % Sales Cost of Goods Sold Gross Profit Expenses Income 2 5% Sales Forcast for 2020 $497.10 Quarter 4 680-9558776 $473.43 Quarter 3 648.5294072 $450.38 Quarter 2 617.6470545 $429.41 Quarter 588.23529 0 200 100 300 600 400 500 700 3800 Thousands income Sales 00) DUWUDUS/New%20folder/manu.pdf 9. Compute the total score for each employee. Use a function. II- Scenario Manager 1. Create a new sheet and name the sheet as scenario manager. In the new sheet add the following: Sales Forecast for 2020 Quarter 2 Quarter 3 Quarter 1 588235.29 Quarter 4 Total Assumptions 59 29 Sales Cost of Goods Sold Gross Profit Expenses Income 259 In pluginfile.php?file=/16 X t Site assessment - Has x Book 3.xlsx - Microsoft X Downloads X manu.pdf X + le /home/chronos/u-7028e57d4a24cde5175aaa7679ae2fe0ef2516c7/MyFiles/Downloads/New%20folder/manu.pdf a 2. Compute the increase of quarter 2 to 4 by adding the assumption percentage to the quarter 1 amount. This means the quarter 2 will have a 5% percent increase, quarter 3 another 5 percent based quarter 2 and quarter 4 will have another 5 percent increase based on quarter 3. In getting the 5 percent you should use the cell that contains the 5% instead of just typing 5%. Example: The following will be the result: Assumptions Sales Forecast for 2020 Quarter 1 Quarter 2 Quarter 3 Quarter 4 588235.29 617647.0545 648529.4072 680955.8776 Total 2535367.6 Sales Cost of Goods Sold Gross Profit Expenses Income 3. The cost of goods will be 2 percent of the quarter sales. You should use the cell with the 2% as part of the formula. Compute the sum as well. Cost of Goods Sold Gross Profit Expenses Income 3. The cost of goods will be 2 percent of the quarter sales. You should use the cell with the 2% as part of the formula. Compute the sum as well. Result: Assumptions Sales Forecast for 2020 Quarter 1 Quarter 2 Quarter 3 Quarter 4 Total 588235.29 617647.0545 648529.4072 680955.8776 2535367.6 1 1764.7058 12352.94109 12970.588141 13619.11755 50707.353 2 Sales Cost of Goods Sold Gross Profit 2576 Expenses Income 4. The gross profit is the sales minus cost of goods sold. Compute the total as well. Sales Forecast for 2020 Quarter 1 Quarter 2 Quarter 3 Quarter 4 Total 588235.29 617647,0545 648529.4072 680955.8776 2535367.6 11764.705812352.94 109 12970.58814 13619.11755 50707.353 $576,470.58 $605,294.11 $635,558.82 $667,336.76 2484660.3 Assumptions Sales Cost of Goods Sold Gross Profit Expenses Income 5X 3. The expenses is 25% of the sale per quarter. You should use the cell with the 25% assumption as part of the fol 5. The expenses is 25% of the sales per quarter. You should use the cell with the 25% assumption as part of the formula. Assumptions Sales Cost of Goods Sold Gross Profit Sales Forecast for 2020 Quarter 1 Quarter 2 Quarter 3 Quarter 4 Total 588235.29 617647.0545 648529.4072 680955.8776 2535367.6 11764.7058 12352.94 109 12970.58814 13619.1175550707.353 $576,470.58 $605,294.11 $635,558.82 $667,336.76 2484660.3 147058.8225154411.7636 162132.3518 170238.9694 633841.91 Expenses 2 5 income 6. The income is gross profit minus expenses. Compute for all the quarters including the total. Assumptions Sales Cost of Goods Sold Gross Profit Expenses Income Sales Forecast for 2020 Quarter 1 Quarter 2 Quarter 3 Quarter 4 Total 588235.29 617647.0545 648529.4072 680955.8776 2535367.6 11764.7058 12352.94 1091 12970.5881413619.1175550707.353 $576,470.58 $605,294.11 $635,558.82 $667,336.76 2484660.3 147058.8225 154411.7636 162132.3518 170238.9694 633841.91 $429,411.76 $450,882.35 $473,426.47 $497,097.791850818,4 9 M = O File /home/chronos/u-7028e57d4a24cde5175aaa7679ae2fe0ef2516c7/MyFiles/Downloads/New%20folder/manu.pdf Q* 7. Add four scenarios a) The first scenario is the current one with 5% sales, 2% cost of goods sold and 25% expenses. We will name this scenario as Current. b) The second scenario will have 15% sales, 8% cost of goods sold and 30% expenses. We will name this scenario as Optimistic. C) The third scenario will have 12% sales, 5% cost of goods sold and 27% expenses. We will name this scenario as Medium At the end you should have 3 scenarios: Scenario Manager Assumptions Salt forecast for 2020 Quarter1 Ouarter Quarter 3 Quarter 4 Total 588235.29 6176470545 648529.4072680955.8776 25353676 1 7 5087 136 19 11755 50707/353 Scenarios Cater At the end you should have 3 scenarios: Assumptions Scenario Manager Sales Forecast for 2020 Quarter 1 Quarter 2 Quarter 3 Quarter 4 Total 588235.29 617647.0545 648529.4072 680955.8776 2535367.6 11764.7058 12352.94109 12970.58814 13619.11755 50707.353 $576,470.58 $605,294.11 $635,558.82 $667,336.76 2484660.3 147058.8225 154411.7636 162132.3518 170238.9694 633841.91 $429,411.76 $450,882.35 $473,426.47 $497,097.79 1850818.4 Scenarios: CUET ER Optimistic Medium Expenses Income Merge Sumar Changing cells Comment SH54:5H55,551 Created by Dr. Caesar Clemente on 1/2013 Modified by Jay Siyon 2020-01-19 Show 8. Create a summary for your scenarios. It should be like the one below. Scenario Summary Current Values Current Optimistic Medium Changing Cells: Sales 5% 15% 12% Cost of Goods Sold 2% 8% 5% Expenses 25% 30% 27% Result Cells: Total Income $1.850.818.97 $1.850.818 37 $1,821.113.22 $1.911.731219 Notes Current Values column represents values of changing cells at time Scenario Summary Report was created Changing cells for each scenario are highlighted in gray 26 1 al O l e I chawla ha lile the one below Format and create the following chart for your table. It should be like the one below. Assumptions Sales Cost of Goods Sold Gross Profit Expenses Income Sales Forecast for 2020 Quarter 1 Quarter 2 Quarter 3 Quarter 4 Total 588235.29 617647.05451 648529.4072 680955.8776 2535367.6 11764.7058 12352.94109 12970.58814 13619.11755 50707.353 $576,470.58 $605,294.11 $635,558.82 $667,336.76 2484660.3 147058.8225154411.7636 162132.3518 170238.9694 633841.91 $429,411.76 $450,882.35 $473,426.47 $497,097.79 1850818.4 2 5% Sales Forcast for 2020 $497,10 Quarter 4 59029558776 $473.43 Quarter 6445294072 $450.88 617.6470549 Quarter 5429.41 2523 900