Question: 2. Use the data provided to answer the following questions. Data for Last Week: Values LY POS Sales TY POS Sales LY POS Qty TY

2. Use the data provided to answer the following questions. Data

2. Use the data provided to answer the following questions. Data for Last Week: Values LY POS Sales TY POS Sales LY POS Qty TY POS Qty LY Next Week Sales LY Next Week QTY LY Next 13 QTY $60,000 $56,250 11,625 10,901 $58,824 11,400 140,500 a. What is the average price for last year (LY), this year (TY)? b. What are the percent changes year-over-year (YOY) in sales and quantity? C. What would you suggest should be an expected forecast for next week? d. What would the forecast be for the next 13 weeks? Now what if you plan on having a in store promotion (just a display so the price isn't changing) in the next 13 weeks, note you had previously calculated and promotion give an expected 7% lift. e. Are these forecasts reliable? Would you rather trust these responses or those in question 1 and Why

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 Finance Questions!

Assume a parent company acquired its subsidiary on January 1, 2015, at a purchase price that was $222,000 in excess of the book value of the subsidiarys Stockholders Equity on the acquisition date....

1. Use the data provided to answer the following questions. Data for last 13 Weeks: LY POS Sales TY POS Sales LY POS Qty TY POS Qty LY Next 13 Sales LY Next 13 QTY Values $350,000 $400,000 70,000...

Excel Use the Excel Megamart Case File to complete the following work. Treat this as a report you will be giving your boss. Create 4 new copies of the POS 1 sheet since you will be performing...

can i get a solution to this question please. Value: Document (include your file name) 15% of final grade How to complete: 1. Read the following Anniversary Party scheduling problem: As the project...

i just need help answering the questions in the word document Major Assignment This assignment is related to the following CLRS: 1, 7, 9, 10, 11 Skinny Joe's Caf This assignment is out of 100 points...

answer the following questions: What are your moral obligations as professionals to prevent such things from happening? What guidance do the professional codes provide (cite specific code sections in...

Use the Spreadsheet Part 1 in the attached "Group Evaluation and Sales Mix Proposal worksheet to determine the profitability of this potential group. The group would like to confirm 165 guest rooms...

Please do NOT submit Excel files showing your computations. You need to type this project on MS word. Any other format will NOT be marked. Please follow closely the following guidelines in submitting...

Among 21- to 25-year-olds, 29% say they have driven while under the inuence of alcohol. Suppose that three 21- to 25-year-olds are selected at random. (a) What is the probability that all three have...

1. Why values determine how society influences technology and how technology influences society using the example of autonomous vehicles. Who decides what problems are addressed and solved? Who...

On January 1, 2025, BCS raised additional financing by issuing 10,000 preferred shares for $20. The preferred shares have a cumulative dividend of $1 per share and are redeemable by BCS at any time...

10) For a bond that pays cash interest (i.e., not a zero coupon bond), YTM is (a) always equal to the coupon rate (b) always equal to the current yield (c) is always less than the coupon rate (d) can...

3 How does celebrity culture relate to public speaking? Is a movie star more capable of drawing support for a cause than an ordinary citizen?

2 How does the clicker change the nature of the lecture? Does it change the relationship between speaker and audience? Or does it simply change the interaction between them?

6-14 Explain why distributed architectures are flexible. The Lego Group, which is headquartered in Billund, Denmark, is one of the largest toy manufacturers in the world. Legos main products have...