5 Sales 6 Direct Material Purchases 7 Direct Labor 8 Manufacturing Overhead 9 Selling and Administrative Expenses 10 Depreciation 11 Interest Received 12 Sale of Investment Securities 13 Purchase of Land 14 Required Ending Cash Balance November December $ 201,300 $ 292,375 $ $ 101,100 $ 91,776 $ $ 80,000 $ 90,000 $ $ 62,000 $ 65,000 $ $ 83,000 $ 85,000 $ $ 80,000 $ 80,000 $ $ 6,200 $ 6,000 $ $ 5,000 $ 5,200 $ 15 $ 60,000 $ 60,000 $ January February 351,240 $ 401,213 111,375 $ 119,773 85,000 $ 115,000 60,000 $ 75,000 75,000 $ 80,000 80,000 $ 80,000 6,300 $ 6,100 3,000 $ 2,000 10,000 15,000 40,000 $ 40,000 15 16 Reference for "$0" $0 17 18 Sales Collection Percentages 19 Month of sale 20 First Month Following the Sale 60% 25% Gintado 19 Month of sale 20 First Month Following the Sale 21 Second Month Following the Sale 60% 25% 15% DM Payment Percentages 24 Month of purchase 30% 25 Month following the purchase 70% 26 27 The following was used to complete the Cash Budget 28 29 Beginning Cash Balance 30 Borrowings 31 Collections from Customers 32 Depreciation 33 Direct Labor 34 Direct Materials 35 Interest Received 36 Manufacturing Overhead 37 Purchase of Land 38 Repayments Given Info Schedules & Budget Cash Budget For the Two Months Ending February 29, 2020 February $40,000 $60,000 Add: Cash Receipts Schedule of Expected Collections from Customers Cash Collected in Sales January February November December January February Total Interest Received Sale of Investment Securities Total Receipts Total Available Cash $6,300 $3,000 $9,300 $6,100 $2,000 $8,100 Less: Cash Disbursements (Payments) Schedule of Expected Payments for DM Purchases Cash Paid for DM in: Purchases January February December January February Direct Labor Manufacturing Overhead Selling and Adminstrative Expenses Purchase of land Total Disbursements $85,000 $60,000 $75,000 $10,000 $115,000 $75,000 $80,000 $15,000 Excess (deficiency) of available cash over cash disbursements (Short Term) Financing Borrowings NOTE: Any cash in excess of the required ending cash F G H Less: Cash Disbursements (Payments) Schedule of Expected Payments for DM Purchases Cash Paid for DM in: Purchases January February December January February Direct Labor Manufacturing Overhead Selling and Adminstrative Expenses Purchase of land Total Disbursements $85,000 $60,000 $75,000 $10,000 $115,000 $75,000 $80,000 $15,000 Excess (deficiency) of available cash over cash disbursements NOTE: Any cash in excess of the required ending cash balance should be used to pay off a $200,000 long term loan. This loan is not shown as part of the Given Info) (Short Term) Financing Horrowings Repayments (Required) Ending Cash Balance S4000 $40,000