I just need help finishing the cash budget and balance sheet - only the darker shaded portions need to be filled in.

All the information from beginning to end is posted.

Please explain, thank you

Big Batch Crisp Company Projected Budgeting Data 2020 October November 2021 January February December Sales: Sales in Units (jars) Selling Price Per Unit (jar) 50,000 $4.75 72,000 $4.75 68,000 $4.75 51,000 $4.75 58,000 $4.75 Collections: Collected in Month of Sale Collected in Month following Sale Assets Cash Accounts Recelvable Raw Materials Inventory Finished Goods Inventory PP&E, net Big Batch Crisp Co. Balance Sheet As of September 30th, 2020 Liabilities & Equities 225,200 Accounts Payable 87,000 Notes Payable 3,986 Interest Payable 6,925 Total Liabilities 96,000 Retained Earnings Total Equities Total Liabilities & 419,111 Equities 13,840 150.000 0 163,840 60% 40% 255,271 255,271 5% of next month's unit sales Total Assets 419,111 2.500 units Finished Goods Inventory: Ending FG Inventory Requirement Beginning FG Inventory, October 1, 2020 Raw Materials Inventory: Beginning RM Inventory, October 1, 2020 Raw Materials Required per Unit of FG Raw Materials Cost per Pound Ending RM Inventory Requirement Pald In Month of Purchase Paid in Following Month 500 0.20 $2.60 15% 50% 50% pounds pounds per pound of next month's production needs Direct Labor: Labor Required per Unit of FG Labor Cost per Hour 0.05 $17.00 hours per hour Manufacturing Overhead: Variable OH Fixed OH Noncash Fixed OH (Included in above) $1.40 $9,000 $6,000 per unit per month per month Selling & Administrative Expenses: Variable S&A Fixed S&A Noncash Fixed S&A (included in above) $0.80 $8,000 $4,500 per unit sold per month per month Cash Borrowing: Interest Payment Note S625 $150.000 per month repayment mede Dec 31, 2020 Other: Equipment Purchase $12,000 purchased Oct 1, 2020 Finished Goods Inventory Cost per Unit Per Unit $ $ Direct Material Direct Labor Variable Overhead TOTAL FG INVENTORY COST PER UNIT 0.52 0.85 $1.40 2.77 $ Sales Budget Unit Sales Selling Price per Unit TOTAL SALES 2020 October November December 50,000 72,000 68,000 $4.75 $4.75 $4.75 $ 237,500 $ 342,000 $ 323,000 $ TOTAL 190,000 $14.25 902,500 Schedule of Expected Cash Collections Cash from Current Month Cash from Prior Month TOTAL CASH COLLECTIONS 2020 October November December $ 142,500 $ 205,200 $ 193,800 $ $ 87,000 $ 95,000 $ 136,800 $ $ 229,500 $ 300,200 $ 330,600 $ TOTAL 541,500 318,800 860,300 Production Budget 2020 2021 Sales in Units Plus: Desired Units of Ending Inventory Total Unit Requirements Less: Units in Beginning Inventory PRODUCTION IN UNITS October November December 50,000 72,000 68,000 3,600 3,400 2,550 53,600 75,400 70,550 2,500 3,600 3,400 51,100 71,800 67,150 Total 190,000 9,550 199,550 9,500 190,050 January February 51,000 58,000 2,900 53,900 2,550 51,350 Raw Materials Purchases Budget 2020 2021 January 51,350 0.20 10,270 Units Produced Pounds of RM Required Per Unit of FG Total Pounds Used in Production Plus: Desired Pounds in Ending Inventory Total Pounds Required Less: Pounds in Beginning Inventory RAW MATERIALS PURCHASES (POUNDS) Cost per Pound RAW MATERIALS PURCHASES (COST) October November December TOTAL 51,100 71,800 67,150 190,050 0.20 0.20 0.20 0.60 10,220 14,360 13,430 38,010 2154 2015 1541 5709 12,374 16,375 14,971 43,719 500 2,154 2,015 4,669 11,874 14,221 12,956 39,051 $2.60 $2.60 $2.60 $7.80 $ 30,872 $ 36,973 $ 33,686 $ 101,531 Direct Labor Budget Units Produced Labor Hours per Unit TOTAL LABOR HOURS REQUIRED Rate per Labor Hour TOTAL DIRECT LABOR COST 2020 October November December TOTAL 51,100 71,800 67,150 190,050 0.05 0.05 0.05 0.15 2,555 3,590 3,358 9,503 $17.00 $17.00 $17.00 $51.00 $ 43,435 $ 61,030 $ 57,078 $ 161,543 Manufacturing Overhead Budget Units Produced Variable Overhead Rate per Unit Total Variable Overhead Cost Fixed Overhead TOTAL OVERHEAD COST Noncash Overhead Expenses TOTAL OVERHEAD DISBURSEMENTS 2020 October November December 51,100 71,800 67,150 $1.40 $1.40 $1.40 $71,540 $100,520 $94,010 $9,000 $9,000 $9,000 $80,540 $109,520 $103,010 $6,000 $6,000 $6,000 $74,540 $103,520 $97,010 TOTAL 190,050 4 266,070 27,000 293,070 18,000 $275,070 Selling & Administrative Expense Budget Unit Sales Variable S&A per Unit Total Variable S&A Fixed S&A TOTAL S&A EXPENSE Noncash S&A Expenses TOTAL S&A DISBURSEMENTS 2020 October November December 50,000 72,000 68,000 $0.80 $0.80 $0.80 $ 40,000 $ 57,600 $ 54,400 $ 8,000 $ 8,000 $ 8,000 $ 48,000 $ 65,600 $ 62,400 $ 4,500 $ 4,500 $ 4,500 $ 43,500 $ 61,100 $ 57,900 TOTAL 190,000 2. 152,000 24,000 176,000 13,500 162,500 Cash Budget 2020 October November December QUARTER $ 225,200 $ 229,500 $ 300,200 $ 330,600 $ 860,300 Beginning Cash Balance Cash Collections Available Cash Balance Cash Disbursements: Direct Material Prior Direct Material Current Direct Labor Overhead S&A Equipment Purchase Note Payment Interest Total Cash Disbursements ENDING CASH BALANCE $ $ $ $ 43,435 $ 74,540 $ 43,500 $ 12,000 61,030 $ 103,520 $ 61,100 $ 57,078 97,010 57,900 $ 625 $ 150,000 625 625 $ Freddie's Fresh Fruit Company Budgeted Income Statement For the Quarter Ending December 31, 2020 Sales $ 902,500 Variable Expenses: Variable Manufacturing Expense $ 526,300 Variable S&A Expense $ 152,000 $ 678,300 Contribution margin $ 224,200 Fixed Expenses: Fixed Manufacturing Expense 27,000 Fixed S&A Expense $ 24,000 $ 51,000 Net Operating Income $ 173,200 Interest Expense $ 1,875 Net Income 171,325 s ASSETS Cash Accounts Receivable Raw Materials Inventory Finished Goods Inventory PP&E, net Freddie's Fresh Fruit Co. Budgeted Balance Sheet As of December 31, 2020 LIABILITIES & EQUITIES Accounts Payable Notes Payable Interest Payable TOTAL LIABILITIES Retained Earnings TOTAL EQUITIES TOTAL LIABILITIES & EQUITIES TOTAL ASSETS