Need help with Excel Budget Project for ACCT 2. Attempting to complete steps 3 and 4, but Excel is telling me the numbers need to be negative for Purchases and Commisions. What am I doing wrong? Thanks!

Step 28 of 40: Sales Through Gross Profit Sales 5 Total in Cost of 7 Purcha Com 10 Total Cost of Goods Sold 11 Gross Profe 4 2 Income 7 " YOUR TURN: Fill in the months January through December in cells B1:M1 of the Operating Budget worksheet 5 Total income 3 Operating Budget Cost of Goods Sold Purchases 10 11 Gr Cash Budget Students January Februar December Total YOUR TURN: Add formulas to cells B3:M3, B7:M7, and B8:MS respectively that carry over the accrual-basis Sales, Purchases, and Commissions from Supporting Schedules worksheet. YOUR TURN: Type the word Total in cell N1 along with your spreadsheet ID, so if your ID is 1234, enter Total 1234. YOUR TURN Add formulas to calculate Total Income, Total Cost of Goods Sold, and Gross Profit. 5 Total Income 6 Cost of Goods Sold 7 Purchases Commissions 10 Total Cost of Goods Sold 11 Gross Profie Operating Budget 40900 -12000 Cash Budget Step 28 of 40 Sales Through Gross P OUTLINE Excel Search 11 Sep 28 of 40 Sales 34. ap 29 of 40 25 Sep 30 of 40 Wemaining On Butt Forma 3p 31 of Farma Operating per Paste 40 BIU A. $ % 9 $38 98 3 Office Update To keep up-to-date with security updates, fixes, and improvements, choose Check for Updates. 7 x fx Inputs!$84 (1-Inputs!$87) Supporting Schedules'!86 B E F Wally's Widgets Budgeted Sales in Units Add: Ending Inventory Total Needs Less Beginning Inventory Required Purchases in Units Required Purchines in Dollars Budgeted Sales in Dollars Sales Commissions in Dollars 0 1 Collection Ratio 2 January February 4 March 15 April 16 May 17 June 18 July 19 August 20 September 21 October 22 November 23 December 24 25 Collections 26 January 27 February 28 March 29 April 30 May 21 June 32 July 31 August A 34 September 35 October 16 November 17 December 18 Total Collections 39 40 Fementati 4 Janisary 4T Harvary 43 March 44 April 15 M January 10,000 6,150 16,150 6,000 10,150 60,900 120,000 12,000 January 25% 30,000 January C February 30,000 10,250 6,300 16,550 6,150 10,400 62,400 123,000 12,300 GON February March 50% 25% 4 March 90,750 February February March 60,000 30.750 40% GON D 10,650 63,900 126,000 12,600 19 10,500 6,450 16,950 6,300 March 25% 50% 25% 30,000 61,500 31,500 123,000 ON 40% CON April April April 10,750 6,600 17,350 6,450 10,900 65,400 129,000 12.900 April 25% 50% 25% 30,750 3,000 32,250 . . 126,000 ON 40% SON May May May May 11,000 6,750 17,750 6,600 11,150 66,900 132,000 13,200 25% SON 25% 4 31,500 64,500 33,000 . 129,000 ON 40% June June June June G 11,250 6,900 18,150 6,750 11,400 68,400 135,000 13,500 25% 50% 25% . 32,250 66,000 33,750 . T 112,000 ON July July July July H 11,500 7,050 18,550 6,900 11,650 69,900 138,000 13,800 25% 50% 25% . 33,000 67,500 34,500 135,000 August 1 August August 11,750 7,200 18,950 7,050 11,900 71,400 141,000 14,100 Format as Table Cell Styles . . 25% 50% 25% 33,750 69,000 35,250 1 September October 12,000 7,350 19,350 7,200 12,150 72,900 144,000 14,400 September October 25% 50% 25% September October 34,500 20,500 34.000 September K 12,250 7,500 19,750 7,350 12,400 74,400 October 12,500 7,650 20,150 7,500 12,650 75,900 147,000 150,000 14,700 15,000 35,250 72,000 36,750 INH 25% SON 25N L November Delete Format 138,000 141,000 144,000 147,000 25% SON 25N November November December 36,000 73,500 37,500 November M December 153,000 15,300 12,750 7,650 20.400 7,650 12.750 76,500 December 150,000 258 30% 25% 16.750 75,000 30.290 87 a. A Office Update To keep up-to-date with security updates, fixes, and improvements, xfx 1 2 3 Sales Income 5 Total Income 6 ah 7 Purchases 8 Cost of Goods Sold Cath B Colie Commissions 10 Total Cost of Goods Sold on 11 Gross Profit Gr 12 Operating Expenses 13 14 are in 17 Total Operating Expenses 18 Net Income 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 dent 34 35 A 36 37 38 39 AD AL B January 120000 February 123000 March D 126000 14 April E GLO 129000 ill * V May F 132000 V $ % 9 *28 98 choose Check for Updates. June G 135000 July H 138000 August 1 141000 Conditional Formatting Format as Table Cell Styles 1 September 144000 October 147000 Novembr 150 Calibri (Body) B 11 V Schedules'187 A A . 87 Hli Review 19 1898 e To keep up-to-date with security updates, fixes, and improvements, choose Check for Updates. X fx 'Supporting Schedules'!87 View Acrobat Tell me General V X % Conditional Formatting Format as Table Cell Styles Incorrect Input This cells should contain a formula that returns a negative number. Yes No Insert- Delete Format Y