i need budgeted inventory purchases, budgeted payments for purchases, and cash budget for the month of october, november, and December.

After Class Practice 5-4 (2 HW) The following information is for the Heart's Delight Gift Store: Sales: Each unit sells for $5. Sales are 75% cash and 25% credit. 50% of the credit sales are collected in the are: month of sale and the remainder in the following month. The gross profit % is 30%. Recent and budgeted sales September October $30,000 November 40,000 December 48,000 January 64,000 80,000 Operating expenses for the quarter are given below: October Salaries November December $ 10,000 Rent $ 10,200 $ 12,000 3,000 3,000 3,000 Depreciation 1,000 1,000 1,150 Other 1,600 1,920 2,400 Total $15,600 $16,120 $18,550 Purchases: Heart's Delight desires an ending inventory of 40% of the next month's cost of goods sold but the ending inventory should never be less than $20,000. 60% of the month's purchases are paid for in the month of purchase and the remainder in the following month. . Heart's Delight is planning on purchasing additional store fixtures in November at a cost of $7,000 cash. This is a purchase of equipment, not inventory. Financing: Heart's Delight must maintain a minimum cash balance of $8,000. All borrowing is to be done at the beginning of the month and all repayments are made at the end of the month in $1,000 increments. Loans are repaid when sufficient cash is available. Interest is paid only at the time of repaying principal. The interest rate is 18% per year. Management does not want to borrow any more cash than is necessary and wants to repay as soon as cash is available. Oldest loans are repaid first