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 Freddie's Fresh Fruit Company Budgeted Income Statement For the Quarter Ending December 31, 2020 Sales Variable Expenses: Variable Manufacturing Expense Variable S&A Expense Contribution margin Fixed Expenses: Fixed Manufacturing Expense Fixed S&A Expense Net Operating Income Interest Expense Net Income 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