step 2-5

Step 30 of 40: Remaining Op. Budget Formulas N Total Click Auto Sum on the Home menu or press Alt 12 Operating Expenses 13 Payroll - 16000 14 Utilities 15 1 17 YOUR TURN: Copy the 18 expense amount formula 19 across the columns and down the rows as needed. 20 21 M 1 November December 2 150000 153000 150000 153000 Autofum 229 0 Delete Format C M ber December Son & Finda Cles See ting N Total pooo 153000 M November -SUM(B3:M3) Total -75900 - 76500 8 - 15000 - 15300 IO -90900 - 91800 11 59100 61200 12 13 - 16000 - 16000 14 -7000 -7000 15 -19500 -1950 27 -82500 42500 18 16600 18700 19 2013 21 Hold down the Ctrl key and 22 select the cells shown 23 24 Operating Budget 150000 153000 163800 Order of Operations B 17 Total Operating Expenses 18 Net Income 19 20 YOUR TURN: Compute 21 Total Operating Expenses 22 and Net Income, 23 24 25 26 Operating Budget 1638 5 150000 153000 Excel should sum columns B:M on each row. Use Show Formulas on the Formulas menu to review the formulas and make corrections if needed. Operating Budget Lo th CA AN 29 BE6 -VOORALI A 15000 11000 144000 TA1000 141000 100 15.00 140000 000 147000 00000 00000 00100 13500 111000 om 11.00 2000 14400 18100 500 151100 700 COLE 5500 CER OOTS CEND OD 00015 OOTS 54500 55100 56700 1200 S0100 10000 16000 16000 14000 February 2 Income May 120000 123000 120000 13000 5 Total income 120000 12000 126000 Cost of Goods Sold 129000 13000 Purchase 2400 63500 DONO Commissions 12000 12300 12000 12000 13200 10 Total cost of Goods Sold -72900 74700 70500 78.100 80500 11 Gross Profit 47100 49500 50700 12 Operating Experts 13 Payrol 10000 16000 16000 16000 10000 14 Utilities -2000 7000 2000 7000 7000 15 Other 19500 19500 19500 19500 19500 17. Total Operating Expenses 16 Net Income 19 20 21 nput Suporting Sche Older Option Operating Budget Chilludges - Type here to search 16000 7000 19500 000C 16000 -2000 19500 -7000 0002 -19500 195.00 10500 1.0 11