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 Cash Budget 2020 November December October QUARTER 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 Selling & Administrative Expense Budget 2020 November December October TOTAL 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