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 Direct Labor Budget 2020 November December October TOTAL Units Produced Labor Hours per Unit TOTAL LABOR HOURS REQUIRED Rate per Labor Hour TOTAL DIRECT LABOR COST Manufacturing Overhead Budget 2020 November December October TOTAL Units Produced Variable Overhead Rate per Unit Total Variable Overhead Cost Fixed Overhead TOTAL OVERHEAD COST Noncash Overhead Expenses TOTAL OVERHEAD DISBURSEMENTS