Please help with excel formulas.
A B C. D F G H L M 2 Individual Excel Spreadsheet - Budget Case Inputs Cyclone Scarves Company 2022 (projected) 1 "Qtr zatr 3 tr 4,400 4,300 4,200 5,000 7,000 4 Otr 3,800 7,200 2023 (projected) 1"atr 2 Otr 4.700 4,400 5,200 6.800 6,300 Assets Cash Accounts recnivable 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, A01 $ $ s 40 38 Total assets 80% 20% 12% of next quarters sales 0.5 yard $20.00 per vard 15% of next quarter's production needs 90% 10% 4 5 Sales in units: 6 Yellow Scart 7 Red Scarf 8 9 Selling Price: 10 Yellow Scarf 11 Red Scarf 12 13 Collections: 14 Quarler of sale 15 Quarter after sale 16 17 Finished Goods Inventory 18 Ending FG Inventory requrement 19 20 Raw Materials Inventory: 21 Yard of fabric per scarf 22 Coet 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 91 Manfacturing Overhead: 32 Variable 33 Fred 34 Noncash fixed included in abwe) 35 36 Selling & Admin Expenses! 37 Variable 98 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 49 49 0.8 hours 12.50 per hour $ IS $ $ 5.00 per direct labor hour 4,500 per quarter 200 per quanto $ $ $ 6.00 per un sold 4.000 per quarter 800 per quarter $ 50,000 19 3 $ $ 8000 Declared cvery December (Paid cuery January - 1st Quarter) 8,800 in June (2 Quarter) 6,000 in July (3 Quarter) 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 1 2 Budgeted Balance Sheet 3 4 Assets 5 Cash 6 Accounts receivable 7 Raw Material Inventory 8 Finished Goods Inventory 9 Property, Plant and equipment, net 10 11 Total Assets As of December 31, 2022 Liabilities and Equities Accounts payable Notes payable Interest payable Dividend payable Common Stock Retained earnings Total Liabilities & Equity 12 13
