please include formulas and calculationz

A B C E F G H 2022 (Projected) 2023 (Projected) Quarter 2 Quarter 3 Quarter 4 Quarter 1 Quarter 2 Quarter 1 Sales Cups of Hot Coffee Selling Price per Cup 7,200 6,300 9,000 3.00 8,100 9.450 7,650 $ Cups of Cold Brew Selling Price per Cup 4,950 4.50 8,100 7,200 6,300 5,400 9,000 $ 85% 15% 0% of next quarter's sales O units (total cups) $ 3 ounces 0.04 per ounce 30% of next quarter's production needs 12.555 ounces 90% 10% 30 $ 0.06 hours 15.00 rate Collections 18 Quarter of Sale 19 Quarter after Sale 0 11 Finished Goods Inventory 2 Ending FG Inventory Requirement 23 Ending FG Inventory Units (December 31, 2021) 4 25 Raw Materials inventory 26 Raw Materials (coffee beans) Required per Cup 27 Raw Materials Cost per Ounce B Ending RM Inventory Requirement 29 Ending RM Inventory Units (December 31, 2021) Paid in Quarter of Purchase 31 Paid in Following Quarter 32 33 Direct Labor 34 Labor Required per Cup 35 Labor Cost per Hour 36 37 Manufacturing Overhead 38 Variable 39 Fixed 40 Noncash Fixed included in above 41 42 Selling & Administrative Expenses 43 Variable 44 Fixed 45 Noncash Fixed (included in above) 46 47 Cash 48 Minimum Cash Balance 49 Note Payable as of December 31, 2021 50 Interest Payable as of December 31, 2021 51 52 Other 53 Store Improvement Payment 54 Store Improvement Payment 55 56 $ $ $ 0.70 per cup 10,000 per quarter 600 per quarter 3 $ $ 0.85 per cup 2.000 per quarter 400 per quarter $ $ $ 10,000 20,000 to be paid January 1, 2022 2,000 to be paid January 1, 2022 $ $ 2.600 in March (1st Quarter) 1.800 in April (2nd Quarter) Individual Excel Spreadsheet Project Campanile Caf 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 Individual Excel Spreadsheet Project Campanile Caf Balance Sheet Balance Sheet as of December 31, 2022 Assets Liabilities and Equities Cash $ 60,364.02 Accounts Payable $ 174.42 Accounts Receivable $ 21,127.50 Notes Payable $ 20,000.00 Raw Materials Inventory $ 2,286.00 Interest Payable $ 2,000.00 Finished Goods Inventory $ 24,768.00 Common Stock $ 80,000.00 Property, Plant and Equipment, net Retained Earnings Total Assets Total Liabilities and Equities $ 102,174.42 2 Individual Excel Spreadsheet Project Campanile Caf Goal Seek 3 4 5 6 7 8 9 Goal Seek Selling Price per Unit