Part B Using the figures provided you will calculate the following for the XYZ store. 1. Open to buy for each month 2. Average monthly sales 3. Average monthly on order 4. Mark down % for each month Planned sales + Planned reductions +Planned EOM Stock - Total monthly needs -BOM Stock -Planned purchases -Merchandise on order Open to buy (At Retati) 17 EOM BOM Planned Sales On order Employee MD$ Shortages Discount 2% 3% Feb. $300,000 Mar. $200,000 Apr. $300,000 May $200,000 June $400,000 July $200,000 $125,000 $15,000 $145,000 $35,000 $170,000 $23,000 $8,000 2% $12,000 4% $4,000 SX $3,000 7% $18,000 2% $25,000 $200,000 $160,000 $80,000 $200,000 $110,000 $80,000 $90,000 $110.000 $210,000 $90,000 $70,000 $210,000 0% 5% 7% Part C. Solve the following: 1. After careful analysis of the economie data from the U.S. Government the XYZ store sola sales plan increase for the next season (Feb-July) of 9.1%. Based on this years les plan what is the companies new projected sales plan for the next? 2. In the prior yearsame sales period the XYZ sore had actual sales of $1,740,000.00. What wa dollar increase/decrease for the sales period and get reasons for the change from one season to the next. What was the percentage increderea