Need to be formulas used not just type in the numbers

Budgeting Info: All of this information is already placed into the INPUTS and Beginning Balance Sheet tabs from which you should work. Campanile Caf only sells two products: a 12 ounce cup of hot coffee and a 12 ounce cup of cold brew. Each cup is referred to as a finished good unit. It is important to remember that a cup of hot coffee and a cup of cold brew require different amounts of coffee grounds to yield a finished good unit. Although the company makes and sells two different types of products, each cup of hot coffee and cold brew will be treated the same excluding selling price. Each cup of hot coffee sells for $3.00. Each cup of cold brew sells for $4.50. . 2023 (Projected) Quarter 1 Quarter 2 Quarter 4 Budgeted sales in units are as follows: 2022 (Projected) Quarter 1 Quarter 2 Quarter 3 Sales Cups of Hot Coffee 9000 7200 6300 Cups of Cold Brew 4950 8100 7200 8100 6300 9450 5400 7650 9000 Campanile Caf does quite a bit of catering business for groups hosting events on campus. Therefore, they don't collect cash for all of their sales immediately. The company's collection pattern is: 85% of sales are collected in the quarter of sale 15% of sales are collected in the quarter following the sale O o Due to the company's product lines, there are no units of finished goods inventory (cups of hot coffee and cold brew) on hand at the end of each quarter. Three ounces of coffee beans are required for each cup produced. The company desires to have raw materials on hand at the end of each quarter equal to 30% of the following quarter's production needs. On December 31, 2021, the company has 12,555 ounces of coffee beans on hand. . The coffee beans used to produce the coffee costs $0.04 per ounce. The company's payment pattern for their coffee grounds is: 90% of the quarter's purchases are paid for in the quarter of purchase 10% of the quarter's purchases are paid for in the quarter following the purchase O O . Each cup of coffee requires 0.06 hours (3.6 minutes) of labor time to make and the hourly employees are paid $15.00 per hour. Wages are paid in the quarter incurred. . Variable manufacturing overhead is $0.70 per cup. . Fixed manufacturing overhead is $10,000 per quarter including $600 in depreciation that is not a current cash outflow. . All cash disbursements for manufacturing overhead are paid in the quarter incurred. Variable selling and administrative expenses are $0.85 per cup sold. Fixed selling and administrative expense is $2,000 per quarter including $400 in depreciation that is not a current cash outflow. . All cash disbursements for selling and administrative costs are paid in the quarter incurred. Campanile Caf likes to keep a minimum cash balance on hand of $10,000. . Campanile Caf had $20,000 borrowed as of December 31, 2021. The business repays the full $20,000 note plus $2,000 of interest on January 1, 2022. Campanile Caf plans to purchase a few new pieces of equipment in 2022. Once piece will be purchased in March 2022 for $2,600, and the other piece will be purchased in April 2022 for $1,800. Depreciation for these is already built into the non-cash expenses provided. . The company uses variable costing. Individual Excel Spreadsheet Project Campanile Caf Inputs Sheet 2022 (Projected) Quarter 2 Quarter 3 2023 (Projected) Quarter 1 Quarter 2 Quarter 1 Quarter 4 Sales Cups of Hot Coffee Selling Price per Cup 7,200 6,300 8,100 9,4501 7,650 9,000 3.00 $ 8,100 7,200 6,300 Cups of Cold Brew Selling Price per Cup 9,000 4,950 4.50 5,400 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 0 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 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 $ 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, Interest Payable as of December 31, 2021 $ $ $ 10,000 20,000 to be paid January 2,000 to be paid January 1, 2022 Other Store Improvement Payment Store Improvement Payment $ $ 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 $ A A A A A 180 20,000 2,000 80,000 60,622 162,802 $ Individual Excel Spreadsheet Project Campanile Caf Selling & Administrative SAT Selling & Administrative Budget 2022 Quarter 3 Quarter 1 Quarter 2 Quarter 4 Total 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 Budgeting Info: All of this information is already placed into the INPUTS and Beginning Balance Sheet tabs from which you should work. Campanile Caf only sells two products: a 12 ounce cup of hot coffee and a 12 ounce cup of cold brew. Each cup is referred to as a finished good unit. It is important to remember that a cup of hot coffee and a cup of cold brew require different amounts of coffee grounds to yield a finished good unit. Although the company makes and sells two different types of products, each cup of hot coffee and cold brew will be treated the same excluding selling price. Each cup of hot coffee sells for $3.00. Each cup of cold brew sells for $4.50. . 2023 (Projected) Quarter 1 Quarter 2 Quarter 4 Budgeted sales in units are as follows: 2022 (Projected) Quarter 1 Quarter 2 Quarter 3 Sales Cups of Hot Coffee 9000 7200 6300 Cups of Cold Brew 4950 8100 7200 8100 6300 9450 5400 7650 9000 Campanile Caf does quite a bit of catering business for groups hosting events on campus. Therefore, they don't collect cash for all of their sales immediately. The company's collection pattern is: 85% of sales are collected in the quarter of sale 15% of sales are collected in the quarter following the sale O o Due to the company's product lines, there are no units of finished goods inventory (cups of hot coffee and cold brew) on hand at the end of each quarter. Three ounces of coffee beans are required for each cup produced. The company desires to have raw materials on hand at the end of each quarter equal to 30% of the following quarter's production needs. On December 31, 2021, the company has 12,555 ounces of coffee beans on hand. . The coffee beans used to produce the coffee costs $0.04 per ounce. The company's payment pattern for their coffee grounds is: 90% of the quarter's purchases are paid for in the quarter of purchase 10% of the quarter's purchases are paid for in the quarter following the purchase O O . Each cup of coffee requires 0.06 hours (3.6 minutes) of labor time to make and the hourly employees are paid $15.00 per hour. Wages are paid in the quarter incurred. . Variable manufacturing overhead is $0.70 per cup. . Fixed manufacturing overhead is $10,000 per quarter including $600 in depreciation that is not a current cash outflow. . All cash disbursements for manufacturing overhead are paid in the quarter incurred. Variable selling and administrative expenses are $0.85 per cup sold. Fixed selling and administrative expense is $2,000 per quarter including $400 in depreciation that is not a current cash outflow. . All cash disbursements for selling and administrative costs are paid in the quarter incurred. Campanile Caf likes to keep a minimum cash balance on hand of $10,000. . Campanile Caf had $20,000 borrowed as of December 31, 2021. The business repays the full $20,000 note plus $2,000 of interest on January 1, 2022. Campanile Caf plans to purchase a few new pieces of equipment in 2022. Once piece will be purchased in March 2022 for $2,600, and the other piece will be purchased in April 2022 for $1,800. Depreciation for these is already built into the non-cash expenses provided. . The company uses variable costing. Individual Excel Spreadsheet Project Campanile Caf Inputs Sheet 2022 (Projected) Quarter 2 Quarter 3 2023 (Projected) Quarter 1 Quarter 2 Quarter 1 Quarter 4 Sales Cups of Hot Coffee Selling Price per Cup 7,200 6,300 8,100 9,4501 7,650 9,000 3.00 $ 8,100 7,200 6,300 Cups of Cold Brew Selling Price per Cup 9,000 4,950 4.50 5,400 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 0 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 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 $ 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, Interest Payable as of December 31, 2021 $ $ $ 10,000 20,000 to be paid January 2,000 to be paid January 1, 2022 Other Store Improvement Payment Store Improvement Payment $ $ 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 $ A A A A A 180 20,000 2,000 80,000 60,622 162,802 $ Individual Excel Spreadsheet Project Campanile Caf Selling & Administrative SAT Selling & Administrative Budget 2022 Quarter 3 Quarter 1 Quarter 2 Quarter 4 Total 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