The last four weekly values of sales were 80, 100, 105, and 90 units, respectively. The...
- The last four weekly values of sales were 80, 100, 105, and 90 units, respectively. The last four forecasts (for the same four weeks) were 60, 80, 95, and 75 units, respectively. Calculate the MAD, MSE, and MAPE for these four weeks.
|
Sales |
Forecast |
∣ Error ∣ |
Error squared |
Pct (%). error |
|
80 |
60 |
|||
|
100 |
80 |
|||
|
105 |
95 |
|||
|
90 |
75 |
|||
MAD
MSE
MAPE
Homework Answers
MAD(Mean Absolute Deviation) = Sum of absolute deviations/Number of periods
= {|80-60| + |100-80| + |105-95| + |90-75|}/4
= (20+20+10+15)/4
= 16.25
MSE(Mean Square Error) = (202+202+102+152)/4
= (400+400+100+225)/4
= 281.25
MAPE(Mean Absolute Percentage Error) = Sum of absolute percentage errors/Number of periods
= [{(80-60)/80}*100 + {(100-80)/100}*100 + {(105-95)/105}*100 + {(90-75)/90}*100]/4
= (25 + 20 + 9.52 + 16.67)/4
= 17.8%
Add Answer to:
The last four weekly values of sales were 80, 100, 105, and 90
units, respectively. The...
Two different forecasting techniques (F1 and F2) were used to forecast demand for cases of bottle...
Two different forecasting techniques (F1 and F2) were used to forecast demand for cases of bottled water. Actual demand and the two sets of forecasts are as follows: PREDICTED DEMAND Period Demand 68 75 70 74 69 72 80 78 F1 67 F2 60 62 70 72 75 75 76 85 73 74 70 71 75 a. Compute MAD for each set of forecasts. Given your results, which forecast appears to be more accurate? (Round your answers to 2 decimal...
Two different forecasting techniques (F1 and F2) were used to forecast demand for cases of bottled...
Two different forecasting techniques (F1 and F2) were used to forecast demand for cases of bottled water. Note: It doesn't matter what forecasting method was used. This problem is simply to practice with MAD and MAPE! Actual demand and the two sets of forecasts are as follows: Period PREDICTED DEMAND F2 67 60 Demand 68 F1 75 67 67 71 70 69 70 74 69 72 72 77 71 77 80 78 70 72 75 75 83 a. Compute MAD...
pls interpret and analyze both IR Spectrum . thanks philip/johnson 105 100 95 90- 85 80 75 70 65 60 55 50- 45- 50...
pls interpret and analyze both IR Spectrum . thanks
philip/johnson 105 100 95 90- 85 80 75 70 65 60 55 50- 45- 500 1000 1500 2000 2500 3500 3000 4000 Wavenumbers (om-1) %Transmittance 100 philipljphnson 95- 85 80 75 70- 65- 60 55 50 4000 3500 1000 500 3000 1500 2500 2000 %Transmittance 90
philip/johnson 105 100 95 90- 85 80 75 70 65 60 55 50- 45- 500 1000 1500 2000 2500 3500 3000 4000 Wavenumbers (om-1) %Transmittance...
The following table lists your company’s sales during the last four years. Year 1: 100 Sales...
The following table lists your company’s sales during the last four years. Year 1: 100 Sales Year 2: 110 Sales Year 3: 105 Sales Year 4: 120 Sales a. A fellow manager points to the 15-unit increase between year 3 and year 4. Extrapolating this trend, he predicts 135 units will be sold in the coming year (year 5). Do you agree? Explain. b. A second manager notes that annual sales increases have averaged (120 − 100)/3 = 6.67 units...
1) if your first four test grades in Math 1110 are: 60, 85, 90, and 80....
1) if your first four test grades in Math 1110 are: 60, 85, 90, and 80. What must you make on the 5thtest to have an average of 80? 2) If two house were on a rectangular graph one was locate at the point (-1, 5) and the other at the point (-1, 5). Find the distance between the two houses.6 units 3) If you wanted your test final grade average to be 85. If all tests were counted and...
The Actual demands in the last 4 periods are given. Which of the following statement is...
The Actual demands in the last 4 periods are given. Which of the following statement is not true? Period Ai Weight 1 10 2 20 0.3 3 30 0.3 4 20 0.4 A. F5=23.33 using Moving Average and n=3 B. F5=20 using Naive Approach C. When the business environment is more dynamic, we tend to choose smaller smoothing constant value. D. F5=23 using Weighted Moving Average when n=3 and the weight is 0.4, 0.3, and 0.3 for period 4, 3,...
Average daily sales of a product are 10 units. The actual number of units each day...
Average daily sales of a product are 10 units. The actual number of units each day is 9, 10, or 11 with frequencies of 75, 90 and 85 respectively during the last 250 days. The lead time for delivery of this product averages 4 days, although the time may be 3, 4, or 5 days with frequencies of 25, 60 and 20 respectively as observed in 105 recent orders. The company plans to place an order when the inventory level...
A) A firm has a daily demand of 450 units. The lead time of receiving supplies...
A) A firm has a daily demand of 450 units. The lead time of receiving supplies is 3 days. If demand has a standard deviation of 100 units per day, what should be their safety stock? The firm plans for a 95% service level. What should be their reorder point? Note: ?0.95 = 1.64. A) This firm decides to increase their service level to 98%. What should be their safety stock? What should be their reorder point? Note: ?0.98 =...
g Opeai o ppy Chtheett 303 CASE Rachel's Breakfast Cafe Rachel Kirkptrick thought to berselif, "What a was...
g Opeai o ppy Chtheett 303 CASE Rachel's Breakfast Cafe Rachel Kirkptrick thought to berselif, "What a waste" an she threw away theee begs full ingredientsi have so gt beter at estimating how mach food to order and prepare. Rachel owned and operated a small cafe that special- ized in fresh baked quiches, beeakfast casseroles, andi breads, as well as ready-made country style beeakfasts The cale was open six days a wock and closed on Sundays. Rachel had run ber...
DO NOT ANSWER AT ALL IF YOU ARE ONLY ANSWERING 5 QUESTIONS THANK YOU True or...
DO NOT ANSWER AT ALL IF YOU ARE ONLY ANSWERING 5 QUESTIONS THANK YOU True or false Process design includes selecting the appropriate technology, sizing the process over time, determining the role of inventory in the process, and locating the process. Operations and supply chain strategy is concerned with setting broad policies and plans for using the resources of a firm and must be integrated with corporate strategy. "Social" pertains to fair and beneficial business practices toward labour, the community,...
Two different forecasting techniques (F1 and F2) were used to forecast demand for cases of bottled water. Actual demand and the two sets of forecasts are as follows: PREDICTED DEMAND Period Demand 68 75 70 74 69 72 80 78 F1 67 F2 60 62 70 72 75 75 76 85 73 74 70 71 75 a. Compute MAD for each set of forecasts. Given your results, which forecast appears to be more accurate? (Round your answers to 2 decimal...
Two different forecasting techniques (F1 and F2) were used to forecast demand for cases of bottled water. Note: It doesn't matter what forecasting method was used. This problem is simply to practice with MAD and MAPE! Actual demand and the two sets of forecasts are as follows: Period PREDICTED DEMAND F2 67 60 Demand 68 F1 75 67 67 71 70 69 70 74 69 72 72 77 71 77 80 78 70 72 75 75 83 a. Compute MAD...
pls interpret and analyze both IR Spectrum . thanks
philip/johnson 105 100 95 90- 85 80 75 70 65 60 55 50- 45- 500 1000 1500 2000 2500 3500 3000 4000 Wavenumbers (om-1) %Transmittance 100 philipljphnson 95- 85 80 75 70- 65- 60 55 50 4000 3500 1000 500 3000 1500 2500 2000 %Transmittance 90
philip/johnson 105 100 95 90- 85 80 75 70 65 60 55 50- 45- 500 1000 1500 2000 2500 3500 3000 4000 Wavenumbers (om-1) %Transmittance...
g Opeai o ppy Chtheett 303 CASE Rachel's Breakfast Cafe Rachel Kirkptrick thought to berselif, "What a waste" an she threw away theee begs full ingredientsi have so gt beter at estimating how mach food to order and prepare. Rachel owned and operated a small cafe that special- ized in fresh baked quiches, beeakfast casseroles, andi breads, as well as ready-made country style beeakfasts The cale was open six days a wock and closed on Sundays. Rachel had run ber...
Most questions answered within 3 hours.
-
Where is the error in this code sequence?
String s1 = "Hello";
String s2 = "ello";...
asked 11 months ago -
Financial data for Joel de Paris, Inc., for last year
follow:
Joel de Paris, Inc.
Balance...
asked 11 months ago -
Consider this reaction:
Al2(SO4)3 (aq)+ BaCl3
(aq) Al2Cl6 (aq)- +
3BaSO4(s) . What is the...
asked 11 months ago -
Suppose that Savneet is considering increasing her
recent random sample from 20 car rentals to 40...
asked 11 months ago -
Trucks arrive at an unloading terminal at an average rate of 120
per hour.
Trucks arrive...
asked 11 months ago -
Why are methanol and ethanol completely soluble in water while
octanol is not very little soluble....
asked 11 months ago -
A facilities manager at a university reads in a research report
that the mean amount of...
asked 11 months ago -
When the CuSO4 is rehydrated by adding water to the anhydrous
compound, is this an endothermic...
asked 11 months ago -
A ray of sunlight is passing from diamond into crown glass; the
angle of incidence is...
asked 11 months ago -
A block of mass 0.249 kg is placed on top of a light, vertical
spring of...
asked 11 months ago -
how do the kidneys compensate in the presences of acidosis
a) trigger hyperventilate
b) reserve acid...
asked 11 months ago -
Question 501 pts
The rental rate of capital to the firm increases. Which of the
following...
asked 11 months ago