Please provide 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 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 C D E F G Raw Materials Budget WN 2022 2023 1st Qtr 154 Qtr 2nd Qtr 3rd Qtr 4th Qtr Total 5 Units Produced 6 Required yard of fabric per scarf 7 Total fabric used in production (yards) 8 Desired ending inventory 9 Total requirements 10 Less: beginning inventory 11 Raw material purchases - yards 12 Cost per yard 13 Raw material purchases - cost 14 15 16 Direct Labor Budget 2022 3rd Qtr 19 Qtr 2nd Qtr 4th Qtr Total Manufacturing Overhead Budget 2022 1st Qtr 2nd Qtr 3rd Qtr 4h Qtr Total 17 18 Units produced 19 Labor hours per unit 20 Total labor hours required 21 Rate per labor hour 22 Direct labor cost 23 24 25 26 27 Total labor hours required 28 Variable overhead rate per direct labor hour 29 Total variable overhead cost 30 Fixed overhead 31 Total overhead cost 32 Noncash overhead expenses 33 Overhead cash disbursements 34 35 Product Cost Per Unit 36 Direct materials cost per unit 37 Direct labor cost per unit 38 Variable overhead cost per unit 39 Total product cost per unit (using variable costing) 40 41
