Need formulas for excel. Thank you!

2022 Projected] Quarter 2 Quarter 2023 (Projected) Quarter Quarter Quarter 2 Quarter1 9 10 11 12 13 Sales Cups of Hot Coffee Selling Price per Cup 7,200 6,300 8,100 9,450 7,650 9,000 3.00 $ 8,100 7,200 6,300 5,400 9.000 4.950 4.50 $ Cups of Cold Brew Selling Price per Cup Collections Quarter of Sale Quarter after Sale 85% 15% Finished Goods Inventory Ending FG Inventory Requirement Ending FG Inventory Units (December 31, 2021) 0% of next quarter's sales units total cups) $ Raw Materials Inventory Raw Materials (coffee beans) Required per Cup Raw Materials Cost per Ounce Ending RM Inventory Requirement Ending RM Inventory Units (December 31, 2021) Paid in Quarter of Purchase Paid in Following Quarter 3 ounces 0.04 per ounce 30% of next quarter's production needs 12,555 ounces 90% 10% Direct Labor Labor Required per Cup Labor Cost per Hour $ 0.06 hours 15.00 per hour 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 14 45 66 17 58 $9 50 51 b2 63 14 05 $ $ $ 0.70 per cup 10,000 per quarter fung Manufacturing Overhead Variable Fixed Noncash Fixed (Included in above) Selling & Administrative Expenses Variable Fixed Noncash Fixed included in above) per quarter $ $ 0.85 per cup 2.000 per quarter 400 per quarter Cash Minimum Cash Balance Note Payable as of December 31, 2021 Interest Payable as of December 31, 2021 $ $ $ 10,000 20,000 to be paid January 1, 2022 2,000 to be paid January 1, 2022 Other Store Improvement Payment Store Improvement Payment $ $ 2.800 In March (1st Quarter) 1,800 in April (2nd Quarter) pannie Care Balance Sheet Balance Sheet as of December 31, 2021 Assets Liabilities and Equities Cash $ 60,000 Accounts Payable $ Accounts Receivable $ 14,300 Notes Payable $ Raw Materials Inventory $ 502 Interest Payable $ Finished Goods Inventory $ Common Stock $ Property, Plant and Equipment, net $ 88,000 Retained Earnings $ Total Assets $ 162,802 Total Liabilities and Equities $ 180 20,000 2,000 80,000 60,622 162,802 3 4 Campanile Cafe Sales and Collections S 6 7 8 9 10 1 Projected Sales Budget 2022 Quarter 1 Quarter 2 Quarter 3 Quarter 4 Total 9,000 7,200 6,300 8,100 30,600 $ 3.00 $ 3.00 S 3.00 $ 3.00 4,950 8,100 7,200 6,300 26,550 $ 4.50 $ 4.50$ 4.50 $ 4.50 $ 49,275.00 $ 58,050.00. $51,300.00 $ 52,650.00 $ 211,275.00 Total Cups of Hot Coffee Sold Unit Price per Cup Total Cups of Cold Brew Sold Unit Price per Cup Total Sales 2 3 4 Current Quarter Prior Quarter Total Cash Collections Expected Cash Collections Budget 2022 Quarter 1 Quarter 2 Quarter 3 Quarter 4 Total $ 7,650.00 $ 6,120.00 $ 5,355.00 $ 6,885.00 $ 26,010.00 $ $ 1,350.00 $ 1,080.00 $ 945.00$ 3,375.00 $ 7,650.00 $ 7,470.00 $ 6,435.00 $ 7,830.00 $ 29,385.00 Campanile Caf Production Unit Sales Plus: Desired FG Ending Inventory Total Units Required Less: FG Beginning Inventory Units Produced Quarter 1 13,950 0 13,950 0 13,950 Production Budget 2022 Quarter 2 Quarter 3 15,300 13,500 0 0 15,300 13,500 0 0 15,300 13,500 Quarter 4 14,400 0 14,400 0 14,400 Total 57,150 0 57,150 0 57,150 2023 Quarter 1 Quarter 2 14,850 16,650 0 14,850 0 14,850 Individual Excel Spreadsheet Project Campanile Caf Raw Materials, Direct Labor and Overhead Raw Materials Budget 2022 Quarter 3 Quarter 1 Quarter 2 2023 Quarter 1 Quarter 4 Total Units Produced Total Cups) RM Ounces Required per Unit Total RM Ounces Used for Production Plus: Desired RM Ending Inventory Total Ounces Required Less: RM Beginning Inventory Raw Material Purchases (Ounces) Cost per Ounce Raw Material Purchases (Cost) Direct Labor Budget Quarter 1 2022 Quarter 3 Quarter 2 Quarter 4 Total Units Produced (Total Cups) Labor Hours per Unit Total Labor Hours Required Rate per Labor Hour Direct Labor Cost Manufacturing Overhead Budget 2022 Quarter 1 Quarter 2 Quarter 3 Quarter 4 Total Units Produced Total Cups) Variable Overhead Rate per Unit Total Variable Overhead Cost Fixed Overhead Total Overhead Expense Noncash Overhead Expenses Overhead Cash Disbursements Product Cost Por Unit Direct Materials Cost per Unit Direct Labor Cost per Unit Variable Overhead Cost per Unit Total Product Cost per Unit Ivariable costinn Individual Excel Spreadsheet Project Campanile Caf Selling & Administrative Quarter 4 Total Selling & Administrative Budget 2022 Quarter 1 Quarter 2 Quarter 3 Unit Sales Variable Selling & Administrative Cost per Unit Total Variable S&A Fixed S&A Total S&A Expense Noncash S&A Expenses S&A Disbursements Campanile Caf Cash Budget Cash Budget 2022 Quarter 3 Quarter 1 Quarter 2 Quarter 4 Total Beginning Cash Balance Cash Collections Available Cash Balance Cash Disbursements: Direct Material Purchased in Prior Quarter Direct Material Purchased in Current Quartet Direct Labor Overhead Selling & Administrative Equipment Purchases Total Cash Disbursements Balance Before Financing Note Payment Interest Payment Balance After Financing Minimum Cash Balance Excess deficiency) Ending Cash Balance Individual Excel Spreadsheet Project Campanile Caf Income Statement 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 Income Statement as of December 31, 2022 Sales Variable Expenses Variable COGS Selling & Administrative Cotribution Margin Fixed Expenses Manufacturing Overhead Selling & Administrative Net Income Individual Excel Spreadsheet Project Campanile Caf Balance Sheet Balance Sheet as of December 31, 2022 Assots Llabilities and Equities Cash Accounts Payable Accounts Receivable Notes Payable Raw Materials Inventory Interest Payable Finished Goods Inventory Common Stock Property, plant and Equipment, net Retained Earnings Total Assets Total Liabilities and Equities 3 4 15 16 Individual Excel Spreadsheet Project Campanile Caf Goal Seek Goal Seek Selling Price per Unit