Question

In: Statistics and Probability

This problem has parts a) - d). a) A convenience store recently started to carry a...

This problem has parts a) - d).

a) A convenience store recently started to carry a new brand of soft drink. Management is interested in estimating future sales volume to determine whether it should continue to carry the new brand or replace it with another brand. The following table provides the number of cans sold per week. Use both the trend projection with regression and the exponential smoothing​ (let alpha α equals=0.40.4 with an initial forecast for week 1 of 617) methods to forecast demand for week13. Compare these methods by using the mean absolute deviation and mean absolute percent error performance criteria. Does your analysis suggest that sales are trending and if​ so, by how​ much?

Period

1

2

3

4

5

6

7

8

9

10

11

12

Sales 617 617 648 739 659 623 742 704 724 715 668 740

b) Obtain the trend projection with regression forecast

Specify the mean absolute deviation​ (MAD) and mean absolute percent error​ (MAPE). ​(Enter your responses rounded to two decimal​ places.)

c) Obtain the exponential smoothing forecast.

Specify the mean absolute deviation​ (MAD) and mean absolute percent error​ (MAPE). ​(Enter your responses as real numbers rounded to two decimal​ places.)

d) Based on​ MAD, the best method is

Solutions

Expert Solution

Answer: ---- Date: ----6/11/2018


Related Solutions

A convenience store recently started to carry a new brand of soft drink. Management is interested...
A convenience store recently started to carry a new brand of soft drink. Management is interested in estimating future sales volume to determine whether it should continue to carry the new brand or replace it with another brand. The following table provides the number of cans sold per week. Use both the trend projection with regression and the exponential smoothing​ (let alphaαequals=0.40.4 with an initial forecast for week 1 of 574574​) methods to forecast demand for week 1313. Compare these...
A convenience store recently started to carry a new brand of soft drink. Management is interested...
A convenience store recently started to carry a new brand of soft drink. Management is interested in estimating future sales volume to determine whether it should continue to carry the new brand or replace it with another brand. The following table provides the number of cans sold per week. Use both the trend projection with regression and the exponential smoothing​ (let alphaαequals=0.4 with an initial forecast for week 1 of 601) methods to forecast demand for week 13. Compare these...
A convenience store recently started to carry a new brand of soft drink. Management is interested...
A convenience store recently started to carry a new brand of soft drink. Management is interested in estimating future sales volume to determine whether it should continue to carry the new brand or replace it with another brand. The following table provides the number of cans sold per week. Use both the trend projection with regression and the exponential smoothing​ (let alphaαequals=0.4 with an initial forecast for week 1 of 581​) methods to forecast demand for week 13. Compare these...
A convenience store recently started to carry a new brand of soft drink. Management is interested...
A convenience store recently started to carry a new brand of soft drink. Management is interested in estimating future sales volume to determine whether it should continue to carry the new brand or replace it with another brand. The following table provides the number of cans sold per week. Use both the trend projection with regression and the exponential smoothing​ (let alphaαequals=0.40.4 with an initial forecast for week 1 of 581581​) methods to forecast demand for week 1313. Compare these...
GoGo Juice is a combination gas station and convenience store located at a busy intersection. Recently,...
GoGo Juice is a combination gas station and convenience store located at a busy intersection. Recently, a national chain opened a similar store only a block away; consequently, sales have decreased for GoGo. In an effort to reclaim lost sales, GoGo has implemented a promotional effort; for every $10 purchase at GoGo, the customer receives a $1 coupon that can be redeemed toward the purchase of gasoline. The average gasoline customer purchases 15 gallons of gasoline at $2.50 per gallon....
The U-Mart Supermarket is a convenience store company that has five store located in different location...
The U-Mart Supermarket is a convenience store company that has five store located in different location at UTM Skudai. At the end of each year, the management of the UTM wants to know the performance of the company. They have decided to use a computer program to help them in analyzing the company performance based on the total sales of each quarter in all stores. Develop a C program to perform this task using array and function based one following...
You recently started working in a large retail store as a management trainee.You are asked to...
You recently started working in a large retail store as a management trainee.You are asked to develop a series of actions to improve employee engagement. What might you consider and why?
The StamfordStamford store of Gabriel's CornerGabriel's Corner , a chain of small neighborhood convenience stores, has...
The StamfordStamford store of Gabriel's CornerGabriel's Corner , a chain of small neighborhood convenience stores, has a Kaizen (continuous improvement) approach to budgeting monthly activity costs for each month of 20152015. Gabriel's CornerGabriel's Corner has three product categories: soft drinks (35% of cost of goods sold [COGS]), fresh snacks (25% of COGS), and packaged food (40% of COGS). The following table shows the four activities that consume indirect resources at the StamfordStamford store, the cost drivers and their rates, and...
Please finish parts E and F from from this problem (parts A-D are already finished and...
Please finish parts E and F from from this problem (parts A-D are already finished and the data is there): https://www.chegg.com/homework-help/questions-and-answers/transactions-rock-medical-company-service-company-organized-corporation-month-march-record-q26222839 (e) Prepare closing entries and enter the transactions in the T-accounts (from part (b); journal entries can be handwritten or typed in Word/Excel; put on a separate page(s). (f) Prepare a post-closing trial balance in EXCEL; use formulas to total the debits and credit
Problem 2 The D-Mart department store has sampled 225 sales records on July 14. The average...
Problem 2 The D-Mart department store has sampled 225 sales records on July 14. The average sale was Yen4200, with an observed sample standard deviation of Yen3000 per customer. (a) (10 points) Construct a 90% confidence interval for the mean sale value. (b) (10 points) How many sales records would need to be sampled for the 90% confidence interval to be within Yen100 of the sample mean?
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT