Using the figures provided you will calculate the following for the XYZ store.

B1. Open to buy for each month

B2. Average monthly sales

B3. Average monthly on order

B4. Markdown % for each month

Planned sales

+ Planned reductions

+Planned EOM Stock

= Total monthly needs

-BOM Stock

=Planned purchases

-Merchandise on order

=Open to buy (At Retail)

Planned sales On order Employee MD$ Shortages EOM BOM

Discount

Feb. $300,000 $125,000 2% $8,000 2% $200,000 $160,000

Mar. $200,000 $15,000 3% $12,000 4% $80,000 $200,000

Apr. $300,000 $145,000 4% $4,000 5% $110,000 $80,000

May $200,000 $35,000 0% $3,000 7% $90,000 $110,000

June $400,000 $170,000 5% $18,000 2% $210,000 $90,000

July $250,000 $24,000 7% $25,000 3% $70,000 $210,000

Part C. Solve the following:

C1. After careful analysis of the economic data from the U. S. Government the XYZ store set a sales plan increase for the next season (Feb.- July) of 6.2%. Based on this year's sales plan what is the company's new projected sales plan for the next season?

C2. In the prior year same sales period the XYZ store had actual sales of $1,820,000.00. What was the increase/decrease for the sales period and suggest reasons for the change from one season to the next.