Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

XYZ Company is a retailer of upscale widget products. The sales forecast for the coming months is: Revenues April $ 250,000 May $ 275,000 June

XYZ Company is a retailer of upscale widget products. The sales forecast for the coming months is:

Revenues

April $ 250,000

May $ 275,000

June $ 300,000

July $ 350,000

August $ 375,000

XYZ Company's sales are 60% cash and 40% store credit. The credit sales are 70% in the month of sale, and the remainder is collected in the following month. Accounts receivable on April 1 are $50,000

XYZ Company's cost of sales are averages 60% of revenues. The inventory policy is to carry 25% of next month's sales needs. April 1 inventory will be as expected under the policy. XYZ Company pays for purchases

56% in the month of purchase and the remaining amount in the following month. Accounts Payable on April 1 are $90,000

a. Prepare a purchases budget for as many months as is possible.

b. Prepare a cash payments budget for April through June.

c. Prepare a cash receipts budget for April through June.

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Computer Accounting

Authors: Donna Kay

14th Edition

007762453X, 9780077624538

More Books

Students also viewed these Accounting questions