AaBbcc AaBbcc AaBbc AaBbCclHD 1 Normal TNo Spac... Heading 1 Heading 2 Title Paragraph Styles suke's Diner 6 Month Merchandising Plan Case: Luke's Diner has planned sales increase of 7% this year that could be attained due to the introduction and addition of a new dessert snack line. Seasonal reductions are planned to remain the same as last year, 12.1%. Gross Margin will remain the same 45.5%. Stock is planned to end the season with $313, 300 with monthly stock-to-sales ratios for August 3.3, September 3.1, October 2.9, November 2.5, December 2.2, and January 2.6. Please show your work. Total 100pts. Month (Fall/Winter Season) August September October November December January LY Monthly Sales $80,000 $90,000 $100,000 $140,000 $175,000 $120,000 % of Season's Reductions 796 99 1296 1896 2696 28% Your task is to prepare a merchandise budget plan for Luke's Diner Total Seasonal Sales Forecast (2pts) = $ b. Total LY Season's Sales (2pts) - 5 c. Monthly Sales Forecast Breakdown for the Season (6pts) % of Season Sales Monthly Sales Forecast TY Month (Spring/Summer Season August 16 0 0 AaBbcc AaBbcc AaBbc AaBbCclHD 1 Normal TNo Spac... Heading 1 Heading 2 Title Paragraph Styles suke's Diner 6 Month Merchandising Plan Case: Luke's Diner has planned sales increase of 7% this year that could be attained due to the introduction and addition of a new dessert snack line. Seasonal reductions are planned to remain the same as last year, 12.1%. Gross Margin will remain the same 45.5%. Stock is planned to end the season with $313, 300 with monthly stock-to-sales ratios for August 3.3, September 3.1, October 2.9, November 2.5, December 2.2, and January 2.6. Please show your work. Total 100pts. Month (Fall/Winter Season) August September October November December January LY Monthly Sales $80,000 $90,000 $100,000 $140,000 $175,000 $120,000 % of Season's Reductions 796 99 1296 1896 2696 28% Your task is to prepare a merchandise budget plan for Luke's Diner Total Seasonal Sales Forecast (2pts) = $ b. Total LY Season's Sales (2pts) - 5 c. Monthly Sales Forecast Breakdown for the Season (6pts) % of Season Sales Monthly Sales Forecast TY Month (Spring/Summer Season August 16 0 0