Please Help with excel formulas

B D E F G 1 2 3 4 Individual Excel Spreadsheet - Budget Case Inputs Cyclone Scarves Company 2022 (projected) 2nd Qtr 3rd Qtr 4,400 4,300 4,200 5,000 6,300 7,000 15Qtr 4th Qtr 3,800 2023 (projected) 1st Qtr 2nd Qtr 4,700 4,400 5,200 6,600 7,200 $ $ 40 36 80% 20% 12% of next quarter's sales 0.5 yard $20.00 per yard 15% of next quarter's production needs 90% 10% 5 Sales in units: 6 Yellow Scarf 7 Red Scarf 8 9 Selling Price: 10 Yellow Scarf 11 Red Scarf 12 13 Collections: 14 Quarter of sale 15 Quarter after sale 16 17 Finished Goods Inventory: 18 Ending FG inventory requirement 19 20 Raw Materials Inventory: 21 Yard of fabric per scarf 22 Cost per yard of fabric 23 Ending RM inventory requirement 24 Paid in quarter of purchase 25 Paid in following quarter 26 27 Direct labor: 28 Required per scarf 29 Hourly pay rate per hour 30 31 Manfacturing Overhead: 32 Variable 33 Fixed 34 Noncash fixed (included in above) 35 36 Selling & Admin Expenses: 37 Variable 38 Fixed 39 Noncash fixed included in above) 40 41 Cash: 42 Minimum cash balance 43 44 Other: 45 Dividends payment 46 Equipment purchase 47 Kitchen equipment purchase 48 0.8 hours 12.50 per hour $ $ $ $ 5.00 per direct labor hour 4,500 per quarter 800 per quarter $ $ $ 6.00 per unit sold 4,000 per quarter 800 per quarter $ 50,000 $ $ $ 8,000 Declared every December (Paid every January - 1st Quarter) 8,800 in June (2nd Quarter) 6,000 in July (3rd Quarter) H J L Assets Cash Accounts receivable Raw materials inventory Finished goods inventory Property, plant and equipment, net Cyclone Scarves Company Balance Sheet As of December 31, 2021 Liabilities and Equities $ 63,000 Accounts payable $ 7,800 $ 12,800 Notes payable $ 14,316 Interest payable $ 27,072 Dividend payable $ 8,000 $ 88,613 Common stock $ 105,100 Retained earnings $ 84,901 $ 205,801 Total Liabilities and equities _$ 205,801 Total assets A B C D E F G 2022 1st Qtr 2nd Qtr 3rd Qtr 4" Qtr th Total 000 u WNP 1 2 Cash Budget: 3 Beginning balance 5 Collections 6 Available balance Disbursements: 8 Direct material purchased in prior quarter 9 Direct material purchased in current quarter 10 Direct labor 11 Manufacturing Overhead 12 S&A 13 Dividends 14 Equipment purchases 15 Total disbursements 16 Balance before financing 17 Minimum balance 18 Excess (deficiency) 19 Ending balance 20 21