please include formulas and calculations. thank you!

Quarter 1 Quarter 2 Quarter 3 Quarter 4 Quarter 1 Quarter 2 Sales Cups of Hot Coffee Selling Price per Cup 9,000 3.00 7,200 6,300 8,100 9,450 7,650 $ Cups of Cold Brew Selling Price per Cup 8,100 4,950 4.50 7,200 6,300 5,400 9,000 $ 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 O 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 Pald in Following Quarter Direct Labor Labor Required per Cup Labor Cost per Hour 3 ounces 0.04 per ounce 30% of next quarter's production needs 12,555 ounces 9 10 11 12 13 14 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 40 45 46 42 48 49 50 51 52 53 54 55 56 57 90% 10% 0.06 hours 15.00 rate $ Manufacturing Overhead Variable Fixed Noncash Fixed included in above) $ $ $ 0.70 per cup 10,000 per quarter 600 per quarter Selling & Administrative Expenses Variable Fixed Noncash Fixed included in above) $ $ 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.500 in March (1st Quarter) 1,800 in April (2nd Quarter) 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 $ 000 Www WA 180 20,000 2,000 80,000 60,622 162,802 8 0 1 3 4 5 6 7 8 9 0 1 2 3 4 5 6 7 Cash Budget 2022 Quarter 1 Quarter 2 Quarter 3 Quarter 4 Total Beginning Cash Balance $ 60,000.00 Cash Collections $ 56,183.75 $ 56,733.75 $ 52,312.50 $ 52.447.50 $ 217,677.50 Available Cash Balance $ 116,183.75 Cash Disbursements: Direct Material Purchased in Prior Quarter Direct Material Purchased in Current Quarter Direct Labor Overhead Selling & Administrative Equipment Purchases $ 2.600.00 $ 1,800.00 $ 4,400.00 Total Cash Disbursements Balance Before Financing Note Payment $ 20,000.00 $ 20,000.00 Interest Payment $ 2,000.00 $ 2,000.00 Balance After Financing Minimum Cash Balance $ 10,000.00 $ 10,000.00 $ 10.000.00 $ 10,000.00 $ 10,000.00 Excess deficiency) Ending Cash Balance