i have test. Need help guys!!!

ROBLEM 4 (10 pints) The sales budget of Hickory Company for the third quarter of 2018 is as follows: July August September Sales $96,000 $72,000 $108,000 Sales are 20% cash, 80% credit. Cost of goods sold is 70% of total sales. Desired ending inventory for each month is equal to 25% of cost of goods sold for the followil Collections on credit sales are as follows: 50% in the month of sale 30% in the month following sale 15% in the second month following sale 5% uncollectible July 1 inventory is $16,000. Expected sales for October are $84,000. Payments for inventory are 70% in the month following purchase and 30% two months follow Prepare the purchases budget for July, August, and September