2020 October December 2021 January February 68,000 51,000 58.000 Sales in Units (jars) Selling Price Per Unit (jar) 50.000 $4.75 Collections: Collected in Month of Sale Collected in Month following Sale Assets Cash Accounts Receivable Raw Materials Inventory 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 Total Liabilities 96,000 Retained Eamings Total Equities 419.111 Equities 13,840 150,000 0 163,840 60% 40% 6,925 Finished Goods Inventory: Ending FG Inventory Requirement Beginning FG Inventory, October 1, 2020 255.271 255,271 419.111 Total Assets 5% 2,500 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 Paid in Month of Purchase Paid in Following Month 500 0.20 $2.60 15% 50% 50% Direct Labor: Labor Required per Unit of FG Labor Cost per Hour 0.05 $17.00 $1.40 S9,000 $6,000 Manufacturing Overhead: Variable OH Fixed OH Noncash Fixed OH (included in above) Selling & Administrative Expenses: Variable S&A Fixed S&A Noncash Fixed S&A (included in above) $0.80 $8,000 $4,500 Cash Borrowing: Interest Payment Note $625 $150,000 Other: Equipment Purchase $12 Sales Budget 2020 November December October TOTAL Unit Sales Selling Price per Unit TOTAL SALES 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 2020 October December 2021 January February 68,000 51,000 58.000 Sales in Units (jars) Selling Price Per Unit (jar) 50.000 $4.75 Collections: Collected in Month of Sale Collected in Month following Sale Assets Cash Accounts Receivable Raw Materials Inventory 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 Total Liabilities 96,000 Retained Eamings Total Equities 419.111 Equities 13,840 150,000 0 163,840 60% 40% 6,925 Finished Goods Inventory: Ending FG Inventory Requirement Beginning FG Inventory, October 1, 2020 255.271 255,271 419.111 Total Assets 5% 2,500 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 Paid in Month of Purchase Paid in Following Month 500 0.20 $2.60 15% 50% 50% Direct Labor: Labor Required per Unit of FG Labor Cost per Hour 0.05 $17.00 $1.40 S9,000 $6,000 Manufacturing Overhead: Variable OH Fixed OH Noncash Fixed OH (included in above) Selling & Administrative Expenses: Variable S&A Fixed S&A Noncash Fixed S&A (included in above) $0.80 $8,000 $4,500 Cash Borrowing: Interest Payment Note $625 $150,000 Other: Equipment Purchase $12 Sales Budget 2020 November December October TOTAL Unit Sales Selling Price per Unit TOTAL SALES 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
