calculate cash budget

ChocoLasting Chocolate Company Balance Sheet As of September 30, 2019 2019 2020 October November December January February Sales: Sales in Units Selling Price per Unit ASSETS LIABILITIES&EQUITIES Cash Accounts Receivable Raw Materials Inventory Finished Goods Inventory PP&E, net Accounts Payable Notes Payable Interest Payable TOTAL LIABILITIES S28 $100 Collections: Collected in the Month of Sale Collected in Following Month $21,600 $17,550 190,000 Common Stock 128 Retained Earnings TOTAL EQUITIES TOTAL LIABILITIES&EQUITIES $80 5182,55 $262,55 $390,75 Finished Goods Inventory: Ending FG Inventory Requirement Beginning FG Inventory, October 1, 2019 of next month's unit sales TOTAL ASSETS $390,750 units Raw Materials Inventory: Beginning RM Inventory, October 1, 2019 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 pounds pounds 0.75 per pound 209% of next month's production needs Direct Labor Labor Required per Unit of FG Labor Cost per Hour hours per hour Manfacturing Overhead: Variable OH Fixed OH Noncash Fixed OH (included in above) per labor hour 28,000 per month per month Selling & Administrative Expenses: Variable S&A Fixed S&A Noncash Fixed S&A (included in above) per unit sold 25,000 per month per month Cash Borrowings: Interest Payment per month Other: Equipment Purchase rchased on December 31, 2019 Cash Budget 2019 October November December QUARTER Beginning Cash Balance Cash Collections Available Cash Balance Cash Disbursements Direct Material Prior Direct Material Current Direct Labor Overhead S&A Equipment Purchase Interest Total Cash Disbursements ENDING CASH BALANCE