Answered step by step
Verified Expert Solution
Question
...
1 Approved Answer
need help with the excel formulas for solving: total income, COGS, Total COGS, gross profit, operating expenses, Total operating expenses & net income. tep 28
need help with the excel formulas for solving: total income, COGS, Total COGS, gross profit, operating expenses, Total operating expenses & net income.
tep 28 of 40: Sales Through Gross Profit D M Incom Sales 1 YOUR TURN: Fill in the (2 Totalind months January through YOUR TURN: Type the word Total in cell Cost of December in cells B1:M1 of the N1 along with your spreadsheet ID, so if your ID is 1234, enter Total 1234 Purchase Operating Budget worksheet Commission Total Cost of Goods Sold 1 Gross Profit Operating Budget Cash Budget A B YOUR TURN:Add formulas to 1 January Februar December Total calculate Total Income, Total Cost Income of Goods Sold, and Gross Profit Sales 5 Total income Total income Cost of Goods Sold Cost of Goods Sold 7 Purchases Purchases 60900 Commissions # Commissions 12000 10 3 YOUR TURN: Add formulas to cells B3:M3, B7 M7 and 88 M8 HO Total cost of Goods Sold 11 Gro respectively that carry over the accrual basis Sales, Purchases, Gros Profit and Commissions from Supporting Schedules worksheet. ang dat Caudal tudents Excel We're here to help. Email us at supporto studentsexcel.com February Nach May August September O November De Tel 1954 1 Sales QUARE ACT WS Dan DOUCET OSALE 14100 124000 14700 150000 15 DANSK Teen 6 Cast of Good Sad ty 2400 -17200 GORDO -1000 2600 65400 -1790 1 13500 760 -71400 14100 - 12000 -72500 DO -74400 -14700 -75800 -10000 -1530 -16 10 Totales of Gooch 11. Put 11 Operator 14 11. Tal Operating en ST 10 Input Supporting Schedules Order of Opperations Operating Budget Cash Budget + Read JX January H 11.000 670 12.7 MAY 11.340 6.900 1.150 12,350 7,650 400 1 Www 2 buted Solesine 1 Argentary Total Need Leserved Reged Martinus 7 Regates in ons Ang Sales Dolors Sabes Coin Den 30 needed May February Marth 30 000 10.350 10.500 6150 6,300 5450 16,150 16.550 1. 000 6150 10,150 10,400 106 GORO 400 6400 170000 123000 126000 17300 12600 May 107 6,600 17,150 6450 300 GO 129000 13900 Ang September October November 11,300 11,750 12.10 13,250 12,500 7050 7,200 7.150 7,500 12.550 RSS 19.350 19,750 20,150 GADO 7070 7200 7350 7500 11.04 11.900 12,150 13.400 12,50 6900 71400 72900 7400 75000 138000 14400 147000 ISO 11800 14100 14400 16700 19000 11.15 GORO 132000 13200 11.400 100 135000 125 12,750 76500 157000 15100 M May ane August September October November December February Marth April 25% 50 25 25.00 50.00 NOR MOS 25. ON 50.00 25.00 25.com 50.00 25.00% 11 February 14 March 15 April 1 May 1 1 M 15 Aug 20 September 21 October 22 Fevember 23 December 25.OON SOON 25.00N 25.OON DON 25.00 25.BON 50.00 25. ON 25. ON 500 25. OON SOON SOON . NOSE NOODS Barry be Never Way October Nune O MY 0 O February March Apr 60000 30000 30750 61600 0 31500 September 0 0 D 22 Bry 28 March Art 30 MAY 0 O O sos 53000 32350 O 0 0 0 OSZE 00099 OST O 0 0 0 O 0 0 O 0 0 o 0 0 0 o 33000 7500 34500 0 0 0 O O o O O 31500 4500 33000 0 0 0 0 0 0 0 . 33750 63000 15240 O 0 O O o O O O O O O O O @ 0 0 36000 3450 70500 36000 MY August 11 September 35 One November 12. December Testalten 0 O 0 0 35250 T30 36750 O 0 O O 0 0 0 30000 37500 0 0 O 0 O O 0 36750 71.000 3250 150000 O 0 90750 2000 126000 129000 DOT 135000 13.000 1000 1000 147000 May September December hu Dober February Marth CON AN ON NOO NOVOS OOON 40 DON NOODS 0.00 40.00 0.00 0.00% 4000 D.OON 40 60OON LOON 0.00 DOO C E G 1 1 O 0 0 DUS 0 0 H 33000 57500 341 0 0 23750 0 O O O o 0 BUOLE o O O 0 0 0 0 35250 0 0 0 0 0 GO 0 0 3170 000 35250 0 0 c o . 0 O O 14400 705.00 MODO 0 O 0 0 a o 0 16750 M 73000 37500 0 o O O 0 O O 0 0 0 OORS 0 O 0 30000 90750 123000 1200 129000 132000 135000 141000 14.7000 150000 May Ane M September October December Bebe May 11 UM 33 Agust 4 September 35 October 36 November 37 December 38 Tonales 29 O P Rate 41 ry February U March 44 Awd 45 May 45 June 47 August 4 September 30 October 51 November 52 December 33 February Math April LON ON 60.00 an 60.00 OOON 40 00 SG OON DOON 40 W 60OON ON 40 W 60.00 ON 40 OON GOON 0.00 ON 40.00 50.000 WOOD WOO 09 NOOD NOD UP NOOO ON WOODS NOOD NODOV WOOD HY Ard May September December 0 August 0 0 0 55 any 56 February 57 March Apr O 0 Odaber O 0 0 0 O O O 0 o @ O 255 39240 O 0 26160 40140 O 0 @ 0 O February March 24360 0 37440 24960 0 MO 0 0 O O 0 0 0 0 0 O 0 0 0 0 0 0 O 36540 61800 1..........., I........... 26760 41040 0 0 0 0 0 0 2TM 41940 0 COM ET MY August September 14 October November BE December 67 Total Payments 0 0 O 0 0 0 .......... 27160 42840 O 26560 4740 0 O 1....tt. 2100 4640 D 0 0 O DOC 29760 0 O OOTD O 0 DOCES 0 O 0 25.300 66300 60 . 30360 70000 20 14 Road U 1 Budget Assumptions 2 First Month's Sales In Units 3 Unit Sales Growth Per Month 4 Unit Sales Price 5 10,000 250 $12.00 E LEFT/HND Functions First Month's Sales In Units Assumption Unit Sales Growth Per Month Assumption Unit Sales Price Assumption 50% 10% 60% TRIM Function Gross Margin Commission Ending Inventory $20,000 12% SUBSTITUTE Function Minimum Cash Balance Assumption Interest Rate Assumption 7 Gross Margin 8 Commission 9 Ending Inventory 10 11 12 Minimum Cash Balance 13 Interest Rate 14 15 Month 16 Month1 17 Month2 18 Month3 19 20 Operating Expenses 21 Payroll 22 Utilities 23 Other 24 25 26 27 28 29 Collections 25% 50% 25% Payments 60% 40% 0% CONCATENATE/RIGHT Function Period 1 Period 2 Period 3 UPPER Function PERIOD 1 PERIOD 2 PERIOO3 LOWER Function period 1 period 2 period 3 Per Month $192,000/12 $7,000 $19,500 MID Function 7200 Payroll 7500 Utilities 7900 - Other 31 33 34 Inputs Supporting Schedules Order of Operations Operating Budget Cash Budget + Ready MacBook Air Slep 28 of 40: Sales Through Gross Profit 2 Your tum: Type the word Total in cell N1. 2 Incom Sales Your turn: Fill in the 5 Total ind months January through 6 Cost of December in cells B1:M1 of the 7 Purchase Operating Budget worksheet. 8 Commissione 10 Total Cost of Goods Sold 11 Gross Profit Operating Budget Cash Budget B January Februar December Total Income Sales Total Income Cost of Goods Sold Purchases Commissions 3 Your turn: Add formulas to cells B3:M3, B7:M7, and B8:M8 respectively that carry over the accrual-basis Sales, Purchases, and Commissions from Supporting Schedules worksheet 4 Your tum:Add formulas to calculate Total Income, Total Cost of Goods Sold, and Gross Profit 120000 5 Total Income 6 Cost of Goods Sold 7 Purchases -60900 8 Commissions -12000 10 Total Cost of Goods Sold 11 Gross Profit Operating Budget Cash Budget mets www.studentsexcel.com Need help? Email: support@studentsexcel.com 4567 10,000 250 $12.00 LEFT/FIND Functions First Month's Sales in Units Assumption Unit Sales Growth Per Month Assumption Unit Sales Price Assumption 50% 10% 60% TRIM Function Gross Margin Commission Ending Inventory 1 Budget Assumptions 2 First Month's Sales in Units 3 Unit Sales Growth Per Month 4 Unit Sales Price 5 6 7 Gross Margin 8 Commission 9 Ending Inventory 10 11 12 Minimum Cash Balance 13 Interest Rate 14 15 Month 16 Monthi 17 Month2 18 Month3 19 20 Operating Expenses 21 Payroll 22 Utilities 23 Other $20,000 12% SUBSTITUTE Function Minimum Cash Balance Assumption Interest Rate Assumption Collections 25% 50% 25% Payments 60% 40% 0% CONCATENATE/RIGHT Function Period 1 Period 2 Period 3 UPPER Function PERIOD 1 PERIOO 2 PERIOD 3 LOWER Functie period 1 period 2 period 3 Per Month $16,000 $7,000 $19,500 MID Function 7200. Payroll 7500. Utilities 7900 - Other Muty 2 Bugated Sales in Units Add Ending inventory 4 Total Meds 5 Les egnning Inventory 6 Rare Purchasin Units 7 Required Purchases in Dollars Budgeted sales in Dollars 9 Sales Commissions in Dollars 10 11 Collection Rate 10,000 6,150 16.159 6000 10.150 G0900 120000 12000 ware April 10.250 10.500 6,300 6450 16,550 16,950 6150 6100 10,400 10,650 62400 63900 123000 126000 1230 12600 May 10,750 6,600 17350 5450 10.000 65400 129000 12900 June 11,000 6,750 17.250 6600 11,150 66900 132000 13200 11250 6.900 30,150 6750 11.400 68400 135000 13500 A. Septeer October 11,500 11,750 12.000 12,250 7,050 7200 7,350 7,500 18,550 18.950 19.250 19,750 6900 2010 2200 7350 11,650 11.900 12, 150 12.400 69100 21400 72900 74400 138000 141000 144000 347000 13800 14100 14400 14700 November December 12.300 12.750 7650 7,650 20.150 20,400 7500 2650 12,650 22,750 75900 76500 150000 153000 15000 15100 January May June 3 12 August September Odober November December February March Apra 25% 50% 25 25.00% SO DON 25.00% 25 OON SO DON 25. DON 25 OON 5000 35.00 13 February 14 March 15 April 16 May 17 June 1 W 19 August 20 September 21 October 22 November 23 December 25 CON 50.00% 25.00% 25.00% 50 OON 25.00 25.00 50.00N 25.00 25.OON 50.OON 25.OON 25.CON 50.00 2500 25. 50.DON 25 OON 25.00 30.ON 25.00 January une My One November o Collection 25 many 27 February 21 March 29 April 30 May 0 0 February March April 30000 GOOOO 30000 0 30750 51500 0 0 11500 O O 0 0 0 0 0 O 0 0 0 0 0 0 0 31500 64500 33000 0 D My 0 30750 53000 32250 0 0 0 O a August September 0 0 0 0 a 33000 0 67500 33750 140 69000 34500 o 35250 TOS 0 3000 0 0 0 0 0 o 32250 66000 33750 0 0 0 0 33 13 August September Oce 15 November OOOOOO 35250 72000 30 0 100 7350 17500 0 0 o 1750 75000 0 35 Odober 6 0 6 29ca n h 6 e 2+ e a 1th a oys/ 4100 | p) E 6 110 13) ) 1476) 34 750 an *2) 1416 14 J++ May Nne M Att4st September October November December February March April EON 4 ON ack 460 08 A 00 400 008 40 d00 0 60 GOON | 0.00N 19 17 December 3 Total Collections 40 Payment Ratio 11 42 February 4) March 44 Apr 45 May And 47MY 4 August 49 September 50 de 51 November 52 December ) 54 Payments 1 56 February 57 March 58 April 39 May 60 lune ju 62 August h1 September 64 October 65 November 66 December 67 Tot Payment 0.OON 0 COON January be 364 December February March April 34 3C0 40 2k9C0 0e0 August September c 0 U 7360 4940 P4f7 E47 318 U c c 4 10 31 ! t t U t 281/ at+7 c 29/ 6786 t 10 03) 654 1900 3cf D March 1 January February Aore May Line Mly Aug Sette Det to 12 Income Sains 120000 123000 126000 129000 132000 135000 1000 141000 144000 141000 150000 15100 3638000 60900 12000 62400 -12300 63900 12600 45400 -12900 1400 -66600 -13700 66400 13500 69900 -33300 -71400 -54100 73900 -96400 75 4500 10 Tots Income 6 Cost of Goods Sold 7 Punches Commissions 10 Total cost of Goods Sold 11 Gross Pratt 12 Operating Expenses 13 Payroll 14 Utilities 15 Other 17 Total Operating Expenses 1 Net Income 19 - 16000 -7000 tep 28 of 40: Sales Through Gross Profit D M Incom Sales 1 YOUR TURN: Fill in the (2 Totalind months January through YOUR TURN: Type the word Total in cell Cost of December in cells B1:M1 of the N1 along with your spreadsheet ID, so if your ID is 1234, enter Total 1234 Purchase Operating Budget worksheet Commission Total Cost of Goods Sold 1 Gross Profit Operating Budget Cash Budget A B YOUR TURN:Add formulas to 1 January Februar December Total calculate Total Income, Total Cost Income of Goods Sold, and Gross Profit Sales 5 Total income Total income Cost of Goods Sold Cost of Goods Sold 7 Purchases Purchases 60900 Commissions # Commissions 12000 10 3 YOUR TURN: Add formulas to cells B3:M3, B7 M7 and 88 M8 HO Total cost of Goods Sold 11 Gro respectively that carry over the accrual basis Sales, Purchases, Gros Profit and Commissions from Supporting Schedules worksheet. ang dat Caudal tudents Excel We're here to help. Email us at supporto studentsexcel.com February Nach May August September O November De Tel 1954 1 Sales QUARE ACT WS Dan DOUCET OSALE 14100 124000 14700 150000 15 DANSK Teen 6 Cast of Good Sad ty 2400 -17200 GORDO -1000 2600 65400 -1790 1 13500 760 -71400 14100 - 12000 -72500 DO -74400 -14700 -75800 -10000 -1530 -16 10 Totales of Gooch 11. Put 11 Operator 14 11. Tal Operating en ST 10 Input Supporting Schedules Order of Opperations Operating Budget Cash Budget + Read JX January H 11.000 670 12.7 MAY 11.340 6.900 1.150 12,350 7,650 400 1 Www 2 buted Solesine 1 Argentary Total Need Leserved Reged Martinus 7 Regates in ons Ang Sales Dolors Sabes Coin Den 30 needed May February Marth 30 000 10.350 10.500 6150 6,300 5450 16,150 16.550 1. 000 6150 10,150 10,400 106 GORO 400 6400 170000 123000 126000 17300 12600 May 107 6,600 17,150 6450 300 GO 129000 13900 Ang September October November 11,300 11,750 12.10 13,250 12,500 7050 7,200 7.150 7,500 12.550 RSS 19.350 19,750 20,150 GADO 7070 7200 7350 7500 11.04 11.900 12,150 13.400 12,50 6900 71400 72900 7400 75000 138000 14400 147000 ISO 11800 14100 14400 16700 19000 11.15 GORO 132000 13200 11.400 100 135000 125 12,750 76500 157000 15100 M May ane August September October November December February Marth April 25% 50 25 25.00 50.00 NOR MOS 25. ON 50.00 25.00 25.com 50.00 25.00% 11 February 14 March 15 April 1 May 1 1 M 15 Aug 20 September 21 October 22 Fevember 23 December 25.OON SOON 25.00N 25.OON DON 25.00 25.BON 50.00 25. ON 25. ON 500 25. OON SOON SOON . NOSE NOODS Barry be Never Way October Nune O MY 0 O February March Apr 60000 30000 30750 61600 0 31500 September 0 0 D 22 Bry 28 March Art 30 MAY 0 O O sos 53000 32350 O 0 0 0 OSZE 00099 OST O 0 0 0 O 0 0 O 0 0 o 0 0 0 o 33000 7500 34500 0 0 0 O O o O O 31500 4500 33000 0 0 0 0 0 0 0 . 33750 63000 15240 O 0 O O o O O O O O O O O @ 0 0 36000 3450 70500 36000 MY August 11 September 35 One November 12. December Testalten 0 O 0 0 35250 T30 36750 O 0 O O 0 0 0 30000 37500 0 0 O 0 O O 0 36750 71.000 3250 150000 O 0 90750 2000 126000 129000 DOT 135000 13.000 1000 1000 147000 May September December hu Dober February Marth CON AN ON NOO NOVOS OOON 40 DON NOODS 0.00 40.00 0.00 0.00% 4000 D.OON 40 60OON LOON 0.00 DOO C E G 1 1 O 0 0 DUS 0 0 H 33000 57500 341 0 0 23750 0 O O O o 0 BUOLE o O O 0 0 0 0 35250 0 0 0 0 0 GO 0 0 3170 000 35250 0 0 c o . 0 O O 14400 705.00 MODO 0 O 0 0 a o 0 16750 M 73000 37500 0 o O O 0 O O 0 0 0 OORS 0 O 0 30000 90750 123000 1200 129000 132000 135000 141000 14.7000 150000 May Ane M September October December Bebe May 11 UM 33 Agust 4 September 35 October 36 November 37 December 38 Tonales 29 O P Rate 41 ry February U March 44 Awd 45 May 45 June 47 August 4 September 30 October 51 November 52 December 33 February Math April LON ON 60.00 an 60.00 OOON 40 00 SG OON DOON 40 W 60OON ON 40 W 60.00 ON 40 OON GOON 0.00 ON 40.00 50.000 WOOD WOO 09 NOOD NOD UP NOOO ON WOODS NOOD NODOV WOOD HY Ard May September December 0 August 0 0 0 55 any 56 February 57 March Apr O 0 Odaber O 0 0 0 O O O 0 o @ O 255 39240 O 0 26160 40140 O 0 @ 0 O February March 24360 0 37440 24960 0 MO 0 0 O O 0 0 0 0 0 O 0 0 0 0 0 0 O 36540 61800 1..........., I........... 26760 41040 0 0 0 0 0 0 2TM 41940 0 COM ET MY August September 14 October November BE December 67 Total Payments 0 0 O 0 0 0 .......... 27160 42840 O 26560 4740 0 O 1....tt. 2100 4640 D 0 0 O DOC 29760 0 O OOTD O 0 DOCES 0 O 0 25.300 66300 60 . 30360 70000 20 14 Road U 1 Budget Assumptions 2 First Month's Sales In Units 3 Unit Sales Growth Per Month 4 Unit Sales Price 5 10,000 250 $12.00 E LEFT/HND Functions First Month's Sales In Units Assumption Unit Sales Growth Per Month Assumption Unit Sales Price Assumption 50% 10% 60% TRIM Function Gross Margin Commission Ending Inventory $20,000 12% SUBSTITUTE Function Minimum Cash Balance Assumption Interest Rate Assumption 7 Gross Margin 8 Commission 9 Ending Inventory 10 11 12 Minimum Cash Balance 13 Interest Rate 14 15 Month 16 Month1 17 Month2 18 Month3 19 20 Operating Expenses 21 Payroll 22 Utilities 23 Other 24 25 26 27 28 29 Collections 25% 50% 25% Payments 60% 40% 0% CONCATENATE/RIGHT Function Period 1 Period 2 Period 3 UPPER Function PERIOD 1 PERIOD 2 PERIOO3 LOWER Function period 1 period 2 period 3 Per Month $192,000/12 $7,000 $19,500 MID Function 7200 Payroll 7500 Utilities 7900 - Other 31 33 34 Inputs Supporting Schedules Order of Operations Operating Budget Cash Budget + Ready MacBook Air Slep 28 of 40: Sales Through Gross Profit 2 Your tum: Type the word Total in cell N1. 2 Incom Sales Your turn: Fill in the 5 Total ind months January through 6 Cost of December in cells B1:M1 of the 7 Purchase Operating Budget worksheet. 8 Commissione 10 Total Cost of Goods Sold 11 Gross Profit Operating Budget Cash Budget B January Februar December Total Income Sales Total Income Cost of Goods Sold Purchases Commissions 3 Your turn: Add formulas to cells B3:M3, B7:M7, and B8:M8 respectively that carry over the accrual-basis Sales, Purchases, and Commissions from Supporting Schedules worksheet 4 Your tum:Add formulas to calculate Total Income, Total Cost of Goods Sold, and Gross Profit 120000 5 Total Income 6 Cost of Goods Sold 7 Purchases -60900 8 Commissions -12000 10 Total Cost of Goods Sold 11 Gross Profit Operating Budget Cash Budget mets www.studentsexcel.com Need help? Email: support@studentsexcel.com 4567 10,000 250 $12.00 LEFT/FIND Functions First Month's Sales in Units Assumption Unit Sales Growth Per Month Assumption Unit Sales Price Assumption 50% 10% 60% TRIM Function Gross Margin Commission Ending Inventory 1 Budget Assumptions 2 First Month's Sales in Units 3 Unit Sales Growth Per Month 4 Unit Sales Price 5 6 7 Gross Margin 8 Commission 9 Ending Inventory 10 11 12 Minimum Cash Balance 13 Interest Rate 14 15 Month 16 Monthi 17 Month2 18 Month3 19 20 Operating Expenses 21 Payroll 22 Utilities 23 Other $20,000 12% SUBSTITUTE Function Minimum Cash Balance Assumption Interest Rate Assumption Collections 25% 50% 25% Payments 60% 40% 0% CONCATENATE/RIGHT Function Period 1 Period 2 Period 3 UPPER Function PERIOD 1 PERIOO 2 PERIOD 3 LOWER Functie period 1 period 2 period 3 Per Month $16,000 $7,000 $19,500 MID Function 7200. Payroll 7500. Utilities 7900 - Other Muty 2 Bugated Sales in Units Add Ending inventory 4 Total Meds 5 Les egnning Inventory 6 Rare Purchasin Units 7 Required Purchases in Dollars Budgeted sales in Dollars 9 Sales Commissions in Dollars 10 11 Collection Rate 10,000 6,150 16.159 6000 10.150 G0900 120000 12000 ware April 10.250 10.500 6,300 6450 16,550 16,950 6150 6100 10,400 10,650 62400 63900 123000 126000 1230 12600 May 10,750 6,600 17350 5450 10.000 65400 129000 12900 June 11,000 6,750 17.250 6600 11,150 66900 132000 13200 11250 6.900 30,150 6750 11.400 68400 135000 13500 A. Septeer October 11,500 11,750 12.000 12,250 7,050 7200 7,350 7,500 18,550 18.950 19.250 19,750 6900 2010 2200 7350 11,650 11.900 12, 150 12.400 69100 21400 72900 74400 138000 141000 144000 347000 13800 14100 14400 14700 November December 12.300 12.750 7650 7,650 20.150 20,400 7500 2650 12,650 22,750 75900 76500 150000 153000 15000 15100 January May June 3 12 August September Odober November December February March Apra 25% 50% 25 25.00% SO DON 25.00% 25 OON SO DON 25. DON 25 OON 5000 35.00 13 February 14 March 15 April 16 May 17 June 1 W 19 August 20 September 21 October 22 November 23 December 25 CON 50.00% 25.00% 25.00% 50 OON 25.00 25.00 50.00N 25.00 25.OON 50.OON 25.OON 25.CON 50.00 2500 25. 50.DON 25 OON 25.00 30.ON 25.00 January une My One November o Collection 25 many 27 February 21 March 29 April 30 May 0 0 February March April 30000 GOOOO 30000 0 30750 51500 0 0 11500 O O 0 0 0 0 0 O 0 0 0 0 0 0 0 31500 64500 33000 0 D My 0 30750 53000 32250 0 0 0 O a August September 0 0 0 0 a 33000 0 67500 33750 140 69000 34500 o 35250 TOS 0 3000 0 0 0 0 0 o 32250 66000 33750 0 0 0 0 33 13 August September Oce 15 November OOOOOO 35250 72000 30 0 100 7350 17500 0 0 o 1750 75000 0 35 Odober 6 0 6 29ca n h 6 e 2+ e a 1th a oys/ 4100 | p) E 6 110 13) ) 1476) 34 750 an *2) 1416 14 J++ May Nne M Att4st September October November December February March April EON 4 ON ack 460 08 A 00 400 008 40 d00 0 60 GOON | 0.00N 19 17 December 3 Total Collections 40 Payment Ratio 11 42 February 4) March 44 Apr 45 May And 47MY 4 August 49 September 50 de 51 November 52 December ) 54 Payments 1 56 February 57 March 58 April 39 May 60 lune ju 62 August h1 September 64 October 65 November 66 December 67 Tot Payment 0.OON 0 COON January be 364 December February March April 34 3C0 40 2k9C0 0e0 August September c 0 U 7360 4940 P4f7 E47 318 U c c 4 10 31 ! t t U t 281/ at+7 c 29/ 6786 t 10 03) 654 1900 3cf D March 1 January February Aore May Line Mly Aug Sette Det to 12 Income Sains 120000 123000 126000 129000 132000 135000 1000 141000 144000 141000 150000 15100 3638000 60900 12000 62400 -12300 63900 12600 45400 -12900 1400 -66600 -13700 66400 13500 69900 -33300 -71400 -54100 73900 -96400 75 4500 10 Tots Income 6 Cost of Goods Sold 7 Punches Commissions 10 Total cost of Goods Sold 11 Gross Pratt 12 Operating Expenses 13 Payroll 14 Utilities 15 Other 17 Total Operating Expenses 1 Net Income 19 - 16000 -7000
need help with the excel formulas for solving: total income, COGS, Total COGS, gross profit, operating expenses, Total operating expenses & net income.
![image text in transcribed](https://s3.amazonaws.com/si.experts.images/answers/2024/07/6694ca8a41aa5_2096694ca89b9b28.jpg)
![image text in transcribed](https://s3.amazonaws.com/si.experts.images/answers/2024/07/6694ca8ae536c_2106694ca8a817e3.jpg)
![image text in transcribed](https://s3.amazonaws.com/si.experts.images/answers/2024/07/6694ca8b9aae0_2116694ca8b20acf.jpg)
![image text in transcribed](https://s3.amazonaws.com/si.experts.images/answers/2024/07/6694ca8c4c41e_2116694ca8bd1276.jpg)
![image text in transcribed](https://s3.amazonaws.com/si.experts.images/answers/2024/07/6694ca8cee0ab_2126694ca8c83938.jpg)
![image text in transcribed](https://s3.amazonaws.com/si.experts.images/answers/2024/07/6694ca8d99d09_2136694ca8d2a4d6.jpg)
![image text in transcribed](https://s3.amazonaws.com/si.experts.images/answers/2024/07/6694ca8e36a69_2136694ca8dca291.jpg)
![image text in transcribed](https://s3.amazonaws.com/si.experts.images/answers/2024/07/6694ca8ec8f58_2146694ca8e6ce46.jpg)
![image text in transcribed](https://s3.amazonaws.com/si.experts.images/answers/2024/07/6694ca8f74ad8_2156694ca8f10122.jpg)
![image text in transcribed](https://s3.amazonaws.com/si.experts.images/answers/2024/07/6694ca901d808_2156694ca8faf083.jpg)
Step by Step Solution
There are 3 Steps involved in it
Step: 1
![blur-text-image](https://dsd5zvtm8ll6.cloudfront.net/includes/images/document_product_info/blur-text-image.webp)
Get Instant Access with AI-Powered Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
![blur-text-image](https://dsd5zvtm8ll6.cloudfront.net/includes/images/document_product_info/blur-subtext-image.webp)
Step: 3
![blur-text-image](https://dsd5zvtm8ll6.cloudfront.net/includes/images/document_product_info/blur-subtext-image.webp)
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started