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

B2. Average monthly sales

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