I need the Product cost per unit Fields filled out. Please include formulas or the equations you used to find the answers!

44 B A C E D Units Produced (Total Cups) Labor Hours per Unit Total Labor Hours Required Rate per Labor Hour Direct Labor Cost F G H 1 Quarter 1 Quarter 2 Quarter 3 Quarter 4 13.950 15,300 13,500 14,400 0.06 0.06 0.06 0.06 837 918 810 864 $ 15$ 15 S 15$ 15 $ $ 12,555 $ 13,770 $ 12,150 $ 12,960 $ Total 57,150 0.06 3,429 15 51,435 3 4 5 6 7 8 09 30 31 32 33 34 35 36 37 38 39 40 41 42 43 Units Produced (Total Cups) Variable Overhead Rate per Unit Total Variable Overhead Cost Fixed Overhead Total Overhead Expense Noncash Overhead Expenses Overhead Cash Disbursements Manufacturing Overhead Budget 2022 Quarter 1 Quarter 2 Quarter 3 Quarter 4 13,950 15.300 13,500 14,400 $ 0.70 $ 0.70 $ 0.70 $ 0.70 $ $ 9,765 $ 10,710 $ 9,450 $ 10,080 $ $ 10,000 $ 10,000 $ 10,000 $10,000 $ $ 19,765 $ 20,710 $ 19,450 $ 20,080 $ $ 600 $ 600 $ 600 $ 600 $ $ 19,165 $ 20,110 $ 18,850 $ 19,480 $ Total 57,150 0.70 40,005 10,000 80,005 2,400 77,605 Product Cost Per Unit 44 45 46 47 48 49 Direct Materials Cost per Unit Direct Labor Cost per Unit Variable Overhead Cost per Unit Total Product Cost per Unit (variable costing) S&A Inputs Production Cash Beg, Balance Sheet RM, DL, & OH Income Statement Sales and Collections Enter 11 Type here to search OBE X Cor L Paste Farma Clipboard A = word AE Madee- B % 38 conditionell Formatting Table Styles Styles Foot Agment Number 744 X G A B D E 6 H 1 1 2 3 4 5 5 Individual Excel Spreadsheet Project Campanile Cafe Raw Materials, Direct Labor, and Overhead B 3 2023 Quarter 1 14,850 3 44,550 0 1 2 3 4 5 6 7 8 9 0 Raw Materials Budget 2022 Quarter 1 Quarter 2 Quarter 3 Quarter 4 Total 13,950 15,300 13,500 14,400 57,150 3 3 3 3 3 41,850 45,900 40,500 43,200 171,450 13,770 12,150 12.960 13.365 13,365 55,620 58,050 53,460 56,565 184,815 12.555 13,770 12,150 12.960 12,555 43,065 44,280 41.310 43,605 172,260 $ 0.04 $ 0.04 $ 0.04 $ 0.04 $ 0.04 $ 1,722.60 $ 1,771.20 $ 1,652.40 $ 1,744.20 $ 6,890.40 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) 2 -3 -4 5 6 7 Units Produced (Total Cups) Labor Hours per Unit Total Labor Hours Required Rate per Labor Hour Inputs Beg. Balance Sheet Direct Labor Budget 2022 Quarter 1 Quarter 2 Quarter 3 Quarter 4 Total 13,950 15,300 13,500 14,400 57,150 0.06 0.06 0.06 0.06 0.06 837 918 810 864 3,429 S 15 s 15$ 15$ 15 S 15 Sales and collections Production RM, DL, & OH S&A Cash Income Statement... Variable B D E K 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 9,000 3.00 7,200 6,300 8.100 9,450 7 650 $ Cups of Cold Brew Selling Pnce per Cup 8,100 7.200 4,950 4.50 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 Materiais 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 $ Manufacturing Overhead Variable Fixed $ $ 0.70 per cup 10.000 per quarter g Search file Home Insert Page Layout Formulas Data Review View Help Foxit PDF m x cut 12 23 Wrap Text General [b copy Anal BIURO A aste E Merge & Center Format Painter Clipboard Font 2 Alignment 5 Xf A D E G H K Quarter after Sale 15% 0% of next quarter's sales O units (total cups) Finished Goods Inventory Ending FG Inventory Requirement Ending FG Inventory Units (December 31, 2021) Raw Materials Inventory Raw Materials (coffee beans) Required per Cup Raw Materals 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 004 per ounce 30% of next quarter's production needs 12555 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 10000 per quarter 600 per quarter $ $ $ 0.85 per cup 2,000 per quarter 400 per quarter Selling & Administrative Expenses Variable Fixed Noncash Foxed (included in above) 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 Inputs Beg. Balance Sheet $ 2.800 in March (tst Quarter) $ 1800 in April (2nd Quarter Sales and Collections Production RM, DL & OH S8A Cash