Case: Luke's Diner has planned sales increase of 7% this year that could be attained due...
Fantastic news! We've Found the answer you've been seeking!
Question:
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
Expert Answer:
Answer rating: 100% (QA)
Answer Given below Lupe Dine 6 6 month meechondising pl... View the full answer
Related Book For
Posted Date:
Students also viewed these accounting questions
-
The introduction of a lump-sum tax might make a maximizing consumer increase their purchases of Good X if, O A. good x is inferior B. the IE dominates the SE C. good x is normal D. the SE dominates...
-
Please show your work and write out your solutions in detail by giving formulas and a short summary at the end. Please do not just post about financial calc or excel without explaining how you got...
-
Select any Company and get a copy of its annual report. Just write an outline of the company's annual report. The outline must contain the following: 1. Introduction 2. Background 3. Liquidity Ratios...
-
Show that 1. Every differentiable concave function is pseudoconcave. 2. Every pseudoconcave function is quasiconcave
-
A processor accesses main memory with an average access time of T2. A smaller cache memory is interposed between the processor and main memory. The cache has a significantly faster access time of T1...
-
Suppose your production opportunity set in a world of perfect certainty consists of the following possibilities'. (a) Graph the production opportunity set in a C0, Q framework. (b) If the market rate...
-
What are the uses and benefits of workforce management systems/HRP systems? Check one of the websites mentioned in this chapter to obtain this information.
-
Hannon Corporation produces high-performance rotors. It expects to produce 50,000 rotors in the coming year. It has invested $10,000,000 to produce rotors. The company has a required return on...
-
As a trainee in the loans department at HSOB plc, your line manager has asked you to assess the financial strength of six corporate clients using the Altman Z score model for bankruptcy prediction....
-
Choice Designs Ltd operates a wholesale/retail carpet store. The statement of financial position of the business as at 31 May Year 8 is as follows: As a result of falling profits the directors of the...
-
Assignment: Due March 27, 11:59 p.m. 25 points Angle Co. presents you with the following trial balance (small company, and it's simple). $ 20, 00 25, 00 180, 00 5,00 500, 00 Cash Accounts receivable...
-
Using linear approximation for demand learning, (1) why the algorithm converges given that it uses a linear function to estimate a nonlinear function? (2) If for stage i, the length of half stage is...
-
Some argue that schedule estimates should not be treated as deadlines. Explain whether you agree. Evaluate whether this applies to budget estimates. Assess why most of projects end up taking more...
-
A project has aggregated costs of $1,750,000 with a contingency reserve of $130,000 and a management reserve of $70,000.How much should the customer (who is also the sponsor of this project) be asked...
-
A company culture that supports stress reduction is key to the success of any program within the company. What are some obstacles that can arise when handling stress within a workplace? What are some...
-
Evaluating strategies for cost reduction in SCM relating to exports and imports. Methods of Implementation Describe the method or design, tasks and procedures of implementation. Provide examples of...
-
Prepare journal entries to record the following transactions. a. Purchased $490 of supplies on credit. b. Completed $690 of work for a client on credit. c. Paid $490 cash towards the amount owed from...
-
How do network effects help Facebook fend off smaller social-networking rivals? Could an online retailer doing half as much business compete on an equal footing with Amazon in terms of costs? Explain.
-
(a) Prove that if A is invertible and BA = CA, then B = C. (b) Give a counterexample to show that the result in part a may fail if A is not invertible.
-
In Exercises 23 and 24, show that the least squares solution of Ax = b is not unique and solve the normal equations to find all the least squares solutions 1. 2.
-
f1 acting with a magnitude of 8N and f2 acting at an angle of 60 to f1 with a magnitude of 8N.
-
In a recent study of how mice negotiate turns, the mice ran around a circular 90 turn on a track with a radius of 0.15 m. The maximum speed measured for a mouse (mass = 18.5 g) running around this...
-
It is well known that runners run more slowly around a curved track than a straight one. One hypothesis to explain this is that the total force from the track on a runners feet the magnitude of the...
-
You are driving your car through a roundabout that has a radius of 9.0 m. Your physics textbook is lying on the seat next to you. What is the fastest speed at which you can go around the curve...
Study smarter with the SolutionInn App