Excel File Edit Window Help View Insert Format Tools Data Excel Assignment 1d (1 page) Q 100% Tue 4 AutoSave REUS Home Excel Assignment 1 Template Data Review Tell me Draw Page Layout Formulas Insert X A % Conditional Formatting Formats Table Paste Font Alignment Number Celle Editing F12 . C D E 1 Projected Profits Worksheet > Assumptions Table 5 Gross Sales increase 6 Wages increase Cost of Goods Sold & Advertising increase 10 ON SON SON 20N 2020 2001 2002 2003 2014 10 11 Income 12 Gross Sales 1 Sales Incentives 200.000,00 5.000.00 5,000.00 1,000.00 5,000.00 5.000.00 Excelent 1 Create a projected profit worksheet using the temple wat in 2 under the contabile cel Assignment 1 Template 2 Bold altiscos Under the Assumption table aster BON forre Sales increase SN for wages increase x. for Cost of Goods IN for Advertising increase incomes to each category and format pent with 1 decimal place 4 This projected grafts worksheet cover a year period online the year 2021. Then 010 and Cocos I, and respectively. Und what you leared in the case you end up with the years 2020-004 come headings in 10. 5 cals, cater total income use the motion Format currency within 6 In cel Malate Tutele there formats with dem 7 In cells in profit which is uncome is Total per formats currency with dem aces . Gros e re predicted to increase by 10 per year for the next years. In cel 12 alte pred Grom Sams. Un bredte cell referencing and the percentage Gros Sales increase from the Antion Table to calculate the procede Sales for 2022. Do not use the percent in the formulated use the cell address where the Gross Sales increase Mered in the table. Then copy the formulate remaining year columns Adjust column widery to properly playfuta Sales Incentives are not expected to increase sunt copy the 5.000 in cel B13 to the remaining wear column 30 Similar to what you did in love, calculate projected War, Cost of Goods Sold and Advertising for the years 2021 2022 2023 and 2004. Formatas number with commes and decimal points. Une bolte cel referencing and percent increase from the Assumption Table 11 Rent and Supplies are not expected to increase just copy to 2020 numbers to the remaining year columns 12 Copy the formulas for Total income, Total Expenses and Net Profit to the colors for the years 2001, 2002, 2003, and 2004. Format as currency with decimal places 15 Create a line chart the graph Totalco. Totals, and Net Profit for the year 2000 - 2024. Place the chart just below the Net Prof. Anda charttle Projected Profits and make sure the legend correctly Identifies the chart lines as Total income Totales and Net Profit 14 Put your name at the top of the spreadsheet 15 Save the file with your last name and first name as the flame. Using the same John Smith as an emple, the Excel file name would be the upload your Excell to the Dropbox forces by the due date sted in your calendar and the dropbox $205,000.00 Is Total income 16 17 Expenses 18 Wages 19 Coat of Goods Bold 20 Rent 21 Supplies 22 Advertising 65,000.00 8,500.00 12,000.00 12.000.00 12.000.00 12.000,00 12,000.00 21,000.00 21.000.00 21.000.00 21.000,00 21,000.00 2.750.00 24 Total expenses $109.650.00 $95.350.00 26 Net profit 27 28 29 30 31 32 13 14 35 36 37 Sheet Shot Shoot + Ready Excel File Edit Window Help View Insert Format Tools Data Excel Assignment 1d (1 page) Q 100% Tue 4 AutoSave REUS Home Excel Assignment 1 Template Data Review Tell me Draw Page Layout Formulas Insert X A % Conditional Formatting Formats Table Paste Font Alignment Number Celle Editing F12 . C D E 1 Projected Profits Worksheet > Assumptions Table 5 Gross Sales increase 6 Wages increase Cost of Goods Sold & Advertising increase 10 ON SON SON 20N 2020 2001 2002 2003 2014 10 11 Income 12 Gross Sales 1 Sales Incentives 200.000,00 5.000.00 5,000.00 1,000.00 5,000.00 5.000.00 Excelent 1 Create a projected profit worksheet using the temple wat in 2 under the contabile cel Assignment 1 Template 2 Bold altiscos Under the Assumption table aster BON forre Sales increase SN for wages increase x. for Cost of Goods IN for Advertising increase incomes to each category and format pent with 1 decimal place 4 This projected grafts worksheet cover a year period online the year 2021. Then 010 and Cocos I, and respectively. Und what you leared in the case you end up with the years 2020-004 come headings in 10. 5 cals, cater total income use the motion Format currency within 6 In cel Malate Tutele there formats with dem 7 In cells in profit which is uncome is Total per formats currency with dem aces . Gros e re predicted to increase by 10 per year for the next years. In cel 12 alte pred Grom Sams. Un bredte cell referencing and the percentage Gros Sales increase from the Antion Table to calculate the procede Sales for 2022. Do not use the percent in the formulated use the cell address where the Gross Sales increase Mered in the table. Then copy the formulate remaining year columns Adjust column widery to properly playfuta Sales Incentives are not expected to increase sunt copy the 5.000 in cel B13 to the remaining wear column 30 Similar to what you did in love, calculate projected War, Cost of Goods Sold and Advertising for the years 2021 2022 2023 and 2004. Formatas number with commes and decimal points. Une bolte cel referencing and percent increase from the Assumption Table 11 Rent and Supplies are not expected to increase just copy to 2020 numbers to the remaining year columns 12 Copy the formulas for Total income, Total Expenses and Net Profit to the colors for the years 2001, 2002, 2003, and 2004. Format as currency with decimal places 15 Create a line chart the graph Totalco. Totals, and Net Profit for the year 2000 - 2024. Place the chart just below the Net Prof. Anda charttle Projected Profits and make sure the legend correctly Identifies the chart lines as Total income Totales and Net Profit 14 Put your name at the top of the spreadsheet 15 Save the file with your last name and first name as the flame. Using the same John Smith as an emple, the Excel file name would be the upload your Excell to the Dropbox forces by the due date sted in your calendar and the dropbox $205,000.00 Is Total income 16 17 Expenses 18 Wages 19 Coat of Goods Bold 20 Rent 21 Supplies 22 Advertising 65,000.00 8,500.00 12,000.00 12.000.00 12.000.00 12.000,00 12,000.00 21,000.00 21.000.00 21.000.00 21.000,00 21,000.00 2.750.00 24 Total expenses $109.650.00 $95.350.00 26 Net profit 27 28 29 30 31 32 13 14 35 36 37 Sheet Shot Shoot + Ready