Case: Luke's Diner has planned sales increase of 7% this year that could be attained due...

  

  

Transcribed Image Text:

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) LY Monthly Sales % of Season's Reductions S80, 000 $90, 000 August September October 7% S100, 000 S140, 000 S175, 000 12% November 18% December 26% January $120, 000 28% 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 % of Season Sales Monthly Sales Forecast TY Season) February March 16 15 April 16 Мay 17 June 19 July 17 d. Total Season Reduction Forecast TY(2pts) = e. Forecast Reductions Breakdown for the Season (6pts) Month (Spring/Summer % of Season's Reductions Monthly Reductions Season) February March 15 18 April May I5 20 June 16 July 16 f. Forecasted BOM (Beginning of the Month) for Season. Include any additional calculation steps for the BOM. (12pts) Planned Sales by Forecasted BOM calculation BOM Month Sales February March April May June July g. Forecasted EOM (End of the Month) for the Season. Include calculation or reasoning for July EOM. (3pts) Manth EOM February March April May June July h. Forecasted Planned Purchases or Additions to Stock for the Season (13pts) Month Planned Purchases Calculation Monthly Planned Purchases February March Аpril Мay June July Total Planned Purchases i. Total Planned Purchases at Cost for Season (2pts) = $ Please include any calculations used here. j. Transfer all the information above and fill in the merchandise plan below. Please add additional calculations as needed. (55pts) February March April May June July Season Total Sales S Distribution % LY Actual S TY Plan S Reductions Distribution % LY Actual S TY Plans BOM S LYS ТY Plan S EOM S LY TY Plan S Planned LYS Purchases S T.YS T.YS@ Cost HMayo/ S20/Test2hm 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) LY Monthly Sales % of Season's Reductions S80, 000 $90, 000 August September October 7% S100, 000 S140, 000 S175, 000 12% November 18% December 26% January $120, 000 28% 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 % of Season Sales Monthly Sales Forecast TY Season) February March 16 15 April 16 Мay 17 June 19 July 17 d. Total Season Reduction Forecast TY(2pts) = e. Forecast Reductions Breakdown for the Season (6pts) Month (Spring/Summer % of Season's Reductions Monthly Reductions Season) February March 15 18 April May I5 20 June 16 July 16 f. Forecasted BOM (Beginning of the Month) for Season. Include any additional calculation steps for the BOM. (12pts) Planned Sales by Forecasted BOM calculation BOM Month Sales February March April May June July g. Forecasted EOM (End of the Month) for the Season. Include calculation or reasoning for July EOM. (3pts) Manth EOM February March April May June July h. Forecasted Planned Purchases or Additions to Stock for the Season (13pts) Month Planned Purchases Calculation Monthly Planned Purchases February March Аpril Мay June July Total Planned Purchases i. Total Planned Purchases at Cost for Season (2pts) = $ Please include any calculations used here. j. Transfer all the information above and fill in the merchandise plan below. Please add additional calculations as needed. (55pts) February March April May June July Season Total Sales S Distribution % LY Actual S TY Plan S Reductions Distribution % LY Actual S TY Plans BOM S LYS ТY Plan S EOM S LY TY Plan S Planned LYS Purchases S T.YS T.YS@ Cost HMayo/ S20/Test2hm 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) LY Monthly Sales % of Season's Reductions S80, 000 $90, 000 August September October 7% S100, 000 S140, 000 S175, 000 12% November 18% December 26% January $120, 000 28% 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 % of Season Sales Monthly Sales Forecast TY Season) February March 16 15 April 16 Мay 17 June 19 July 17 d. Total Season Reduction Forecast TY(2pts) = e. Forecast Reductions Breakdown for the Season (6pts) Month (Spring/Summer % of Season's Reductions Monthly Reductions Season) February March 15 18 April May I5 20 June 16 July 16 f. Forecasted BOM (Beginning of the Month) for Season. Include any additional calculation steps for the BOM. (12pts) Planned Sales by Forecasted BOM calculation BOM Month Sales February March April May June July g. Forecasted EOM (End of the Month) for the Season. Include calculation or reasoning for July EOM. (3pts) Manth EOM February March April May June July h. Forecasted Planned Purchases or Additions to Stock for the Season (13pts) Month Planned Purchases Calculation Monthly Planned Purchases February March Аpril Мay June July Total Planned Purchases i. Total Planned Purchases at Cost for Season (2pts) = $ Please include any calculations used here. j. Transfer all the information above and fill in the merchandise plan below. Please add additional calculations as needed. (55pts) February March April May June July Season Total Sales S Distribution % LY Actual S TY Plan S Reductions Distribution % LY Actual S TY Plans BOM S LYS ТY Plan S EOM S LY TY Plan S Planned LYS Purchases S T.YS T.YS@ Cost HMayo/ S20/Test2hm 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) LY Monthly Sales % of Season's Reductions S80, 000 $90, 000 August September October 7% S100, 000 S140, 000 S175, 000 12% November 18% December 26% January $120, 000 28% 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 % of Season Sales Monthly Sales Forecast TY Season) February March 16 15 April 16 Мay 17 June 19 July 17 d. Total Season Reduction Forecast TY(2pts) = e. Forecast Reductions Breakdown for the Season (6pts) Month (Spring/Summer % of Season's Reductions Monthly Reductions Season) February March 15 18 April May I5 20 June 16 July 16 f. Forecasted BOM (Beginning of the Month) for Season. Include any additional calculation steps for the BOM. (12pts) Planned Sales by Forecasted BOM calculation BOM Month Sales February March April May June July g. Forecasted EOM (End of the Month) for the Season. Include calculation or reasoning for July EOM. (3pts) Manth EOM February March April May June July h. Forecasted Planned Purchases or Additions to Stock for the Season (13pts) Month Planned Purchases Calculation Monthly Planned Purchases February March Аpril Мay June July Total Planned Purchases i. Total Planned Purchases at Cost for Season (2pts) = $ Please include any calculations used here. j. Transfer all the information above and fill in the merchandise plan below. Please add additional calculations as needed. (55pts) February March April May June July Season Total Sales S Distribution % LY Actual S TY Plan S Reductions Distribution % LY Actual S TY Plans BOM S LYS ТY Plan S EOM S LY TY Plan S Planned LYS Purchases S T.YS T.YS@ Cost HMayo/ S20/Test2hm 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) LY Monthly Sales % of Season's Reductions S80, 000 $90, 000 August September October 7% S100, 000 S140, 000 S175, 000 12% November 18% December 26% January $120, 000 28% 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 % of Season Sales Monthly Sales Forecast TY Season) February March 16 15 April 16 Мay 17 June 19 July 17 d. Total Season Reduction Forecast TY(2pts) = e. Forecast Reductions Breakdown for the Season (6pts) Month (Spring/Summer % of Season's Reductions Monthly Reductions Season) February March 15 18 April May I5 20 June 16 July 16 f. Forecasted BOM (Beginning of the Month) for Season. Include any additional calculation steps for the BOM. (12pts) Planned Sales by Forecasted BOM calculation BOM Month Sales February March April May June July g. Forecasted EOM (End of the Month) for the Season. Include calculation or reasoning for July EOM. (3pts) Manth EOM February March April May June July h. Forecasted Planned Purchases or Additions to Stock for the Season (13pts) Month Planned Purchases Calculation Monthly Planned Purchases February March Аpril Мay June July Total Planned Purchases i. Total Planned Purchases at Cost for Season (2pts) = $ Please include any calculations used here. j. Transfer all the information above and fill in the merchandise plan below. Please add additional calculations as needed. (55pts) February March April May June July Season Total Sales S Distribution % LY Actual S TY Plan S Reductions Distribution % LY Actual S TY Plans BOM S LYS ТY Plan S EOM S LY TY Plan S Planned LYS Purchases S T.YS T.YS@ Cost HMayo/ S20/Test2hm 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) LY Monthly Sales % of Season's Reductions S80, 000 $90, 000 August September October 7% S100, 000 S140, 000 S175, 000 12% November 18% December 26% January $120, 000 28% 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 % of Season Sales Monthly Sales Forecast TY Season) February March 16 15 April 16 Мay 17 June 19 July 17 d. Total Season Reduction Forecast TY(2pts) = e. Forecast Reductions Breakdown for the Season (6pts) Month (Spring/Summer % of Season's Reductions Monthly Reductions Season) February March 15 18 April May I5 20 June 16 July 16 f. Forecasted BOM (Beginning of the Month) for Season. Include any additional calculation steps for the BOM. (12pts) Planned Sales by Forecasted BOM calculation BOM Month Sales February March April May June July g. Forecasted EOM (End of the Month) for the Season. Include calculation or reasoning for July EOM. (3pts) Manth EOM February March April May June July h. Forecasted Planned Purchases or Additions to Stock for the Season (13pts) Month Planned Purchases Calculation Monthly Planned Purchases February March Аpril Мay June July Total Planned Purchases i. Total Planned Purchases at Cost for Season (2pts) = $ Please include any calculations used here. j. Transfer all the information above and fill in the merchandise plan below. Please add additional calculations as needed. (55pts) February March April May June July Season Total Sales S Distribution % LY Actual S TY Plan S Reductions Distribution % LY Actual S TY Plans BOM S LYS ТY Plan S EOM S LY TY Plan S Planned LYS Purchases S T.YS T.YS@ Cost HMayo/ S20/Test2hm

Answer rating: 100% (QA)

Answer Given below Lupe Dine 6 6 month meechondising pl... View the full answer