please help me fill in the blue purple and pink cells!
A B D E F G 1 2 Derby Company prepares monthly cash budgets. Relevant data from operating budgets for 2020 are: 3 4 November December January February 5 Sales $ 201,300 $ 292,375 $ 361,3615 411,411 6 Direct Material Purchases $ 101,100 $ 91,776 | $ 111,375$ 119,773 NOTE: All items, except 7 Direct Labor $ 80,000 $ 90,000 $ 85,000 $ 115,000 DM purchases, are 8 Manufacturing Overhead $ 62,000 65,000 62,000 $ 74,000 completely paid in the 9 Selling and Administrative Expenses $ 83,000 $ 85,000 S 75,000 $ 80,000 month incurred. 10 Depredation S 80,000 $ 80,000 $ 80,000 $ 80,000 11 Interest Received $ 6,200 S 6,000 S 6,300 $ 6,100 12 Sale of Investment Securities $ 5,000S 5,200 $ 3,000S 2,000 13 Purchase of land $ $ $ 8,000S 19,000 14 Required Ending Cash Balance $ 60,000 $ 60,000 $ 40,000 $ 40,000 15 16 Reference for "$0" $0 17 18 Sales Collection Percentages 19 Month of sale 55% 20 First Month Following the Sale 30% 21 Second Month Following the Sale 15% 22 23 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 Depredation 33 Direct labor 34 Dired Materials 35 Interest Received 36 Manufacturing Overhead 37 Purchase of Land 38 Repayments 39 (Required) Ending Gash Balance 40 Sale of investment Securities 41 Selling and Adminstrative Expenses 42 43 Derby Company Cash Budget For the Two Months Ending February 29, 2020 January $60,000 February $40,000 Add: Cash Receipts Interest Received Sale of investment Securities Total Receipts Total Available Cash $6300 $3.000 $9.300 $6.100 $2.000 $8,100 Less: Cash Disbursements (Payments) 16 17 18 Schedule of Expected Collections from Customers 19 Cash Collected in 20 Sales January February 21 November 22 December January 24 February 25 Total 26 27 28 Schedule of Expected Payments for DM Purchases 29 Cash Paid for DM in 30 Purchases January February 31 December 32 January 33 February 34 Total 35 36 37 NOTE: Any cash in excess of the required ending cash 3H balance should be used to pay off a $200,000 long term 39 loan. (This loan is not shown as part of the Given Info) 40 41 42 Direct Labor Manufacturing Overhead Selling and Adminstrative Expenses Purchase of Land Total Disbursements $85.000 $62,000 $75,000 $8.000 $115,000 $24,000 $80,000 $19,000 Excess (deficiency of available cash over cash disbursements (Short Term) Financing Borrowing Repayments (Required) Ending Cash Balance $40,000 $40,000
