what formula in Excell would the yellow boxes be?

E38 E F G B C D 1 Problem 3: Preparation of Purchase budget and Cash payment sched 2 3 Walton Inc. is preparing its inventory purchase budget for the second quarter of 20YY, 4 and provided the following sales budget for the second quarter of 20YY. 5 June 6 7 Projected sales April May $300,000 $400,000 $500,000 8 9 The following relevant information are also provided 10 11 Budgeted monthly cost of goods sold equals 40% of budgeted monthly sales. 12 Each month's desired ending inventory should be $10,000 plus 10% of the current month's COGS 13 The ending inventory balance at March 31 20YY was $18,000 14 All purchases are made on account. 15 The company's suppliers require Walton to pay 30% of its accounts payable during the month of purcha 16 with the remaining 70% in the month after purchase. 17 The outstanding accounts payable at March 31, 20YY was $56,800 which is to be paid in April 18 19 Required: 20 Use the Table below to prepare: 21 Inventory Purchase Budget and Cash Payment Schedule for the second quarter of 20YY. 22 Value must be entered in the green cells of the table below. 28 24 Solution: 25 Siddique, Salina: 26 Inventory purchases budget for the second quarter 20YY Relevant budgeted data Income Statement and B 27 April May June Proforma statement data 28 Purchase Budget $ $ $ $ Siddique, Salina: 29 Budgeted cost of goods sold $120.000 $160,000 $200,000 $480,000 Total Budgeted COGS to | Income Statement of the 30 Desired ending inventory $22.000 $26,000 $30,000 $78,000 31 Total inventory needed $142,000 $186.000 $230,000 $558,000 Siddique, Salina: 32 Less beginning inventory $18.000 $22,000 $26,000 $66,000 Desired Ending inventory to 33 Required inventory purchases $124.000 $164,000 $204,000 $492,000 Balance Sheet as at Jume 34 Schedule of cash payments for the second quarter 20YY 35 Cash payments for: $ $ $ 36 Current month's inventory purchases $37200 $49.200 $61,200 Siddique. Salina: 37 Previous month's inventory purchases $56,800 $86,800 $ 114,800 Expected Accounts Paya 38 Total cash payments for inventory $94.000 $136.000 $176,000 Balance Sheet as at June 39 40 41 42. 43 44