Explore BrainMass

Prepare a merchandise purchases budget for the first quarter.

See attached file for proper format.

3. This window shows what is correct and incorrect for the work you have completed so far.

Even if all of the work you have done so far is correct, you may not have completed everything.
Westile Company buys plain ceramic tiles and prints different designs on them for souvenir and gift stores.
It buys the tiles from a small company in Europe, so at all times it keeps on hand a stock equal to the tiles
needed for three months' sales. The tiles cost $2 each and must be paid for in cash. The company has
56,000 tiles in stock. Sales estimates, based on contracts received, are as follows for the next six

January 24,800
February 35,600
March 26,400
April 28,400
May 19,200
June 14,400


Estimate purchases (in units) and cash required to make purchases in January, February, and March.
(Omit the "$" sign in your response.)

Westile Company
Merchandise Purchases Budget
For the Period Ended March 31
(in units)
January February March
Units to be purchased 34400 6000
Estimated cost
$ 68800

Check Your Work


Solution Preview

See attached Excel file for format and formulas.

jan feb march april may june
opening ...

Solution Summary

The expert prepares a merchandise purchases budget for the first quarter is examined.