Monthly Cash Budget Grove, Inc. is a wholesaler for its only product, deluxe wireless electric drills, which sel for 504 each and cost Grove 557 each On December 1, 2016, Grove's management requested a cash budget for December. The following selected account balances at November 30, 2016. were gathered by the accounting department: Cash 5138.000 Mete scurte cu 210.000 Accounts all trade 11.710.000 Inventaries 0) 856.000 Operating penses payabile 140,400 Accounts payable al merchandis S8.200 Note jable i 12/31/2016) 190.000 Actual sales for the months of October and November were 20.000 and 30,000 units, respectively. Projected unit sales for December and January are 50,000 and 40,000 respectively. Experience indicates that so% of sales should be cortected in the month of sale, 30% in the month following sale, and the balance in the second month following sale. Uncollectible accounts, returns, and allowances are negligible OUT Actual sales for the months of October and November were 20,000 and 90,000 units, respectively. Projected unt sales for December and January are 50,000 and 40,000, respectively. Experience indicates that 50% of sales should be collected in the month of sale, 30% in the month following sale, and the balance in the second month fotlowing sale, Uncollectible accounts, returns and allowances are negligible Planned purchases should provide ending wwentorlesequio 30% of next month's unit sales volume. Approximately 70% of the purchases are paid for in the month of purchase and the balance in the following month, Monthly operating expenses are budgeted at 59.10 per unit sold plus a fixed amount of 5189,000 including depreciation of 581,000. Except for depreciation, 60% of operating expenses are paid in the month incurred and the balance in the following months. Interest expense is induced in operating expenses Special anticipated year and transactions include the following 1. Declaration of a $22.500 cash dividend to be paid 2 weeks after the December 20 date of record 2. Sale of one half of the marketable securities held on November 30 a gain of 521,000 is anticipated 3. Pay off the note payable due December 31, 2016 4. Trade-in of an old computer originally costing 1675,000 and now having accumulated depreciation of $540,000 at a gain of $157,500 on a new computer costing $1,335,000. Sufficient cash will be paid at the time of trade-in so that only 50% of the total price will have to be financed, 5. Grove's treasurer has a policy of maintaining a minimum month-end cash balance of $135,000 but wants to raise this to $225.000 at December 31. She has a standing arrangement with the bank to borrow any amo up to a limit of $450,000 Prepare a cash budget for Grove, Inc. for December 2016, Collections in December from customers 5 From October sales From November sales From December 376000 540000 $1,33 uncent Cash will be pard at the time or trade-in sc 5. Grove's treasurer has a policy of maintaining a minimum mor arrangement with the bank to borrow any amount up to a limit Prepare a cash budget for Grove, Inc., for December 2016. Collections in December from customers: $ 376000 846000 From October sales From November sales From December sales Total collections $ Payments on account for merchandise purchases: November December Unit Sales 30000 50000 Ending inventories 0 0 Total units to be available 0 0 Beginning inventories 0 0 Units to be purchased 0 0 Total dollar purchases $ 0 $ 0 Portion paid in December $ 0 $ 0 Payment of operating expenses: Payment of operating expenses: November December Total variable operating expenses $ 0 $ 0 Fixed operating expenses 0 0 Total operating expenses 0 0 Monthly depreciation 0 0 Operating expenses requiring payment $ 0 $ 0 Amounts to be paid in December $ 0 $ 0 Cash required at time of computer purchase: Cost of new computer $ 0 Book value of old computer $ 0 Gain on trade-in 0 Total trade-in allowance 0 Balance owing at trade in 0 Portion to be financed 0 Cash payment required 0 0 Portion to be financed Cash payment required 0 Grove, Inc. Cash Budget For the Month Ended December 31, 2016 Beginning cash balance Cash receipts Collections from customers (calculated above) $ 0 0 0 0 Short-term borrowing Cash available Cash disbursements: Payments on accounts payable (calculated above) Payments of operating expenses payable (calculated above) Down payment on computer (calculated above) O 0 Total cash disbursements Ending cash balance $ 0