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 $30,000 3% $12,000 4% $80,000 $40,000

Apr. $300,000 $150,000 4% $4,000 5% $110,000 $90,000

May $200,000 $100,000 0% $3,000 7% $90,000 $60,000

June $400,000 $150,000 5% $18,000 2% $210,000 $150,000

July $200,000 $30,000 7% $25,000 3% $70,000 $30,000

Part C. Solve the following:

1. 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 8.2%. Based on this year's sales plan what is the companies new projected sales plan for the next season?

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