E- T Normal 11 No Spac... Heading 1 Heading 2 Tale > Select Font Paragraph Styles Editing Luke's Diner 6 Month Merchandising Plan Case: Luke's Diner has planned sales increase of 4% this year that could be attained due to the introduction and addition of a new gourmet coffee. Reductions are planned to remain the same as last year, 11.6%. Gross Margin will remain the same 50.1%. Stock is planned to end the season with $318,000 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 $85,000 $90,000 $100,000 $145,000 $175,000 $120,000 % of Season's Reductions 896 8% 18% 12% 28% 26% Your task is to prepare a merchandise budget plan for Luke's diner. a. Total Seasonal Sales Forecast (2pts) = $ b. Total LY Season's Sales (2pts) = $ c. Monthly Sales Forecast Breakdown for the Season (6pts) Month (Spring/Summer Com % of Season Sales Monthly Sales Forecast TY 127 December January $175,000 $120,000 28% 26% Your task is to prepare a merchandise budget plan for Luke's diner. a. Total Seasonal Sales Forecast (2pts) = $ b. Totally Season's Sales (2pts) = $ c. Monthly Sales Forecast Breakdown for the Season (6pts) % of Season Sales Monthly Sales Forecast TY Month (Spring/Summer Season) August September October November December January Styles EG Luke's Diner 6 Month Merchandising Plan d. Total Season Reduction Forecast TY(2pts) = $ e. Forecast Reductions Breakdown for the Season 16pts) % of Season's Reductions Monthly Reductions Month (Spring/Summer Season) August September October November December January f. Forecasted BOM (Beginning of the Month) for Season. Include any additional calculation steps for the BOM. (12pts) Forecasted Sales BOM calculation BOM Planned Sales by Month August September October November December January g. Forecasted EOM (End of the Month) for the season. Indude calculation or reasoning for January EOM. (3pts) Month FOM August September October November December January h. Forecasted Planned Purchases or Additions to Stock for the Season (13pts) Monthly Planned Purchases Month Planned Purchases Calculation August September October November December January Total Planned Purchases $ 1 Total Planned Purchases at Cost for Season (2 pts) - $ Please include any calculations used here. Transfer all the information above and fill in the merchandise plan below. Please add additional calculations as needed. (55pts) j. Transfer all the information above and fill in the merchandise plan below. Please add additional cakulations as needed. (55pts) August September October November December January Season Total Sales $ Distribution % LY Actuals TY Plan $ Reductions Distribution % LY Actual TY Plans BOMS LYS TY Plans EOM $ LY TY Plans Planned LYS Purchases $ TYS 1.YS Cost