Answer the following questions using the data from the Excel file daily customers. xlsx described in Problem
Question:
a. Forecast the number of customers who will visit Dave€™s store on Day 9 using a two period weighted moving average with the weights 5 and 2.
b. Calculate the MAD for the forecast in part a.
c. Forecast the number of customers who will visit Dave€™s store on Day 9 using exponential smoothing with trend adjustment and setting α = 0.1 and β = 0.3.
d. Calculate the MAD for the forecast in part c.
e. In which forecast do you have the most confidence?
Transcribed Image Text:
Day Customers 260 243 232 277 270 285 248 254
Fantastic news! We've Found the answer you've been seeking!
Step by Step Answer:
Answer rating: 43% (16 reviews)
a b MAD 11406 190 c d MAD 12627 1803 e The forecast using exponential smoothing with tr...View the full answer
Answered By
Felix Mucee
I am a detailed and thorough professional writer with 5 years of administrative experience- the last 2 years in academic writing and virtual office environment. I specialize in delivering quality services with respect to strict deadlines and high expectations. I am equipped with a dedicated home office complete with a computer, copier/scanner/fax and color printer.
I provide creative and detailed administrative, web search, academic writing, data entry, Personal assistant, Content writing, Translation, Academic writing, editing and proofreading services. I excel at working under tight deadlines with strict expectations. I possess the self-discipline and time management skills necessary to have served as an academic writer for the past five years. I can bring value to your business and help solve your administrative assistant issues.
4.70+
13+ Reviews
33+ Question Solved
Related Book For
Question Posted:
Students also viewed these Statistics questions
-
Answer the following questions using the data from the Excel file AOL. xlsx described in Problem 16.30: From Problem a. Forecast the advertising revenue for each quarter in 2013 using seasonal dummy...
-
Answer the following questions using the data from the Excel file chlorine. xlsx described in Problem 16.32. From Exercise a. Forecast the tons of chlorine shipped each day next week using...
-
Answer the following questions using the data from the Excel file cafeteria. xlsx described in Problem 16.34. From Exercise a. Forecast the food services sales for each day next week using seasonal...
-
Develop, debug, and document a program to determine the roots of a quadratic equation, ax2 + bx + c, in either a high-level language or a macro language of your choice. Use a subroutine procedure to...
-
Multiple Choice Questions 1. Which of the following is a criterion that must be met in order for an item to be recognized as an intangible asset? a. The item's fair value can be measured reliably. b....
-
Calculate the threshold kinetic energies of protons required to activate the reactions (p, n) and (p, d) with Li7 nuclei.
-
3. Given a continuously compounded risk-free rate of 3% annually, at what lease rate will forward prices equal the current commodity price? (Recall the copper example in Section 3.) If the lease rate...
-
Alan Industries is expanding its product line to include three new products: A, B, and C. These are to be produced on the same production equipment, and the objective is to meet the demands for the...
-
Staton-Smith Software is a new start-up company and will not pay dividends for the first five years of operation. It will then institute an annual cash dividend policy of $2.50 with a constant growth...
-
Dennis McCutcheon supervises the employees who work in the building supplies department of a large discount hardware store. One of his employees, Kelly Sims, has been late to work every Tuesday and...
-
Dave is a manager of a local AT& T Wireless retail store. He would like to forecast the number of customers walking into his retail store per day to improve his staffing decisions. The following data...
-
Using the time series shown in Problem 16.3, answer the following questions: From Problem a. Forecast the demand for Period 9 using exponential smoothing with trend adjustment and setting = 0.4 and ...
-
Imagine you are a manager tasked with supervising work groups in a context different to your home country. You are very new to the context and do not know much about it. What can help you to...
-
Companies in the tire manufacturing business use a lot of property, plant, and equipment. Tyrell Rubber and Tire Corporation and Maxwell Rubber and Tire Manufacturing are two of the leading...
-
(7%) Problem 11: A student launches a small rocket which starts from rest at ground level. At a height h = 2.09 km, the rocket reaches a speed of v = 291 m/s. At that height, the rocket runs out of...
-
2. For the following three sets of electric field lines, what charge or charges would make such lines? Indicate their locations and type of charge (e.g. positive/negative) a.
-
What is the most important take-home point that you learned from this video? https://www.youtube.com/watch?v=nUZqvsF_Wt0 2. Policy Problems. What is onepolicy that creates inequality in the labor...
-
An employee had $20,300 in gross earnings up to September 20, 2021. She has the following information for her pay for the week ending September 27, 2021. Her employer contributes 100% toward CPP and...
-
Which of the following is NOT the barrier to successful SoS modeling and analysis? a. Tendency of fragmented perspectives for practical development b.Lack of mathematical understanding of physical...
-
Suppose the government bond described in problem 1 above is held for five years and then the savings institution acquiring the bond decides to sell it at a price of $940. Can you figure out the...
-
The Rubber Group (TRG) manufactures and sells a number ol rubberbased products. Its strategic focus is channelled through profit centres which sell products transferred from production divisions that...
-
Suppose you are working with a data set that is normally distributed, with a mean of 200 and a standard deviation of 47.Determine the value of x from the following information. a. 60% of the values...
-
Suppose the annual employer 401(k) cost per participant is normally distributed with a standard deviation of $625, but the mean is unknown. a. If 73.89% of such costs are greater than $1,700, what is...
-
Based on annual driving of 15,000 miles and fuel efficiency of 20 mpg, a car in the United States uses, on average, 750 gallons of gasoline per year. If annual automobile fuel usage is normally...
-
Saly paid $52,000 a year paid on a weekly basis. last pay she had $250 withheld in Income Tax, $48.97 for CPP and $15.80 for EI. an additional $and 25.00 in tax are deducted each pay. She allowed to...
-
Required information [The following information applies to the questions displayed below.] Dain's Diamond Bit Drilling purchased the following assets this year. Asset Drill bits (5-year) Drill bits...
-
Which of the following partnership items are not included in the self-employment income calculation? Ordinary income. Section 179 expense. Guaranteed payments. Gain on the sale of partnership...
Study smarter with the SolutionInn App