i need this accounting problem done correct. in a doc all steps shown. only 2 hrs

only experts only

Question #4 See Power point Problem given along with the above questions. XYZ Company is a retailer of upscale widget products. The sales forecast for the coming months is: Revenues April May June July August $ $ $ $ $ 250,000 275,000 300,000 350,000 375,000 XYZ Company's sales are 60% cash and 40% store credit. The credit sales are remainder is collected in the following month. Accounts receivable on April 1 are 70% in the month of sale, and the $50,000 XYZ Company's cost of sales are averages 60% of revenues. The inventory policy is to carry 25% needs. April 1 inventory will be as expected under the policy. XYZ Company pays for purchases of next month's sales 56% in the month of purchase and the remaining amount in the following month. Accounts Payable on April 1 are $90,000 a. b. c. Prepare a purchases budget for as many months as is possible. Prepare a cash payments budget for April through June. Prepare a cash receipts budget for April through June