Question: 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

 AaBbcc AaBbcc AaBbc AaBbCclHD 1 Normal TNo Spac... Heading 1 Heading

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

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Accounting Questions!