Following tables are created in order to generate forecasts using weighted moving average and simple moving...
Fantastic news! We've Found the answer you've been seeking!
Question:
Transcribed Image Text:
Following tables are created in order to generate forecasts using weighted moving average and simple moving average for the sales amount of a certain product group at an electronics company. a) Show the expression to calculate the missing forecasts from each forecasting technique. (Weighted moving average parameters are n-3 and w1:0.4, Wa=0.3; wa=0.3; smoothing factor(alfa) for exponential smoothing is 0.3) 1 Exponential Smaating Table Period 1 2 3 4 Actual 335 246 279 263 Forecast 193,0 205,3 229,2 Error 141,9 40,6 49,75 ? 2 Weighted Average Forecasts Period 1 2 3 4 MAD = Actual 335 246 279 263 Actual-Forecast 22 Forecast 293,2 304,7 272,1 b) Show the expression to calculate mean absolute deviation (MAD) for the forecasting results of these two techniques separately. ? Error 41,8 -58,7 6,9 7 Following tables are created in order to generate forecasts using weighted moving average and simple moving average for the sales amount of a certain product group at an electronics company. a) Show the expression to calculate the missing forecasts from each forecasting technique. (Weighted moving average parameters are n-3 and w1:0.4, Wa=0.3; wa=0.3; smoothing factor(alfa) for exponential smoothing is 0.3) 1 Exponential Smaating Table Period 1 2 3 4 Actual 335 246 279 263 Forecast 193,0 205,3 229,2 Error 141,9 40,6 49,75 ? 2 Weighted Average Forecasts Period 1 2 3 4 MAD = Actual 335 246 279 263 Actual-Forecast 22 Forecast 293,2 304,7 272,1 b) Show the expression to calculate mean absolute deviation (MAD) for the forecasting results of these two techniques separately. ? Error 41,8 -58,7 6,9 7
Expert Answer:
Answer rating: 100% (QA)
The image shows two tables that are related to the sales amount forecasts using weighted moving average and exponential smoothing for a certain product at an electronics company The first table titled ... View the full answer
Related Book For
Financial Reporting Financial Statement Analysis and Valuation a strategic perspective
ISBN: 978-1337614689
9th edition
Authors: James M. Wahlen, Stephen P. Baginski, Mark Bradshaw
Posted Date:
Students also viewed these general management questions
-
The gure on the following page shows an Excel spreadsheet that calculates a two- period weighted moving average and exponential smoothing model for a set of demand numbers, as well as the resulting...
-
We have discussed many concepts in SCM 301 related to planning, sourcing, making and delivering products and services. The purpose of this case analysis is to integrate the different elements of the...
-
Find the average value of f ( x , y , z )= x + z 2 on the truncated cone z 2 = x 2 + y 2 , with 1 ? z ? 9.
-
A company has the following data: net sales, $405,000; cost of goods sold, $220,000; selling expenses, $90,000; general and administrative expenses, $60,000; interest expense, $4,000; and interest...
-
Bank Reconciliation and Adjusting Entries Presented below is information related to Haselhof Inc. Balance per books at October 31, $41,847.85; receipts $173,523.91; disbursements $164,893.54. Balance...
-
What are gross ups in determining tenant reimbursements for operating expenses? Why are they used?
-
Why should the receiving department be segregated from inventory control and, if possible, from shipping?
-
Kitchen Appliances, Inc., is a multi-division company with each major product line managed by a separate division. Divisional managers have complete autonomy with respect to operating and investment...
-
Identify and discuss at least 3 different types of nongovernmental police or security forces. You may also choose to profile 3 real-life private detectives or bounty hunters by presenting a biography...
-
KEW Enterprises began operations in January 20X1 to manufacture a hand sanitizer that promised to be more effective and gentler on the skin than existing products. Family members, one of whom was...
-
You are a system administrator tasked with setting up a new Windows Server 2019 machine as a domain controller and installing Active Directory Domain Services (AD DS) for a new organization. Explain...
-
create lesson plan in art history. Learning activity to be used in a class with a mix of visual, auditory and kinaesthetic learners. The subject of the lesson plan is great painters in art history....
-
Make a folio of 5 different paper sizes, types, colors and their associated use. Also 5 different envelopes sizes, types and colors.
-
Question 17: Task 17: Role play See detailed handout on the exemplar report and its background Read and discuss the report in small groups Discussion in full group: Audience Structure Data and...
-
Each student will be expected to write, perform, film & upload an original speech discussing an interpersonal conflict within their lives. You must include any necessary background and important...
-
When talking about the differences between 'for profit businesses and 'not for profit' enterprises, often the term 'profit motive' is introduced for discussion. In what context can this term apply to...
-
f(a+h)-f(a) h to find f'(3) for the function f(x)=2x-7x+5 Use f'(a)-lim- Show all the necessary algebraic work. f(a+h)-f(a) h to find f'(2) for the function f(x)=x+2 Use f'(a)=lim: Show all the...
-
g(x) = x 5 5x 6 a. Show that g(x) = 0 has a root, , between x = 1 and x = 2. b. Show that the equation g(x) = 0 can be written as x = (px + q) 1/r , where p, q and r are integers to be found. The...
-
Effective financial statement analysis requires an understanding of a firms economic characteristics. The relations between various financial statement items provide evidence of many of these...
-
Sunbeam Corporation manufactures and sells a variety of small household appliances, including toasters, food processors, and waffle grills. Exhibit 3.26 presents a statement of cash flows for Sunbeam...
-
Disclosures related to income taxes for The Coca-Cola Company (Coke) for 20062008 appear in Exhibit 8.11. Required a. Why are Cokes average tax rates so low? b. Is it likely that Coke has recognized...
-
The MINITAB commands will create a normal scores plot from observations that were set in C1. (MINITAB uses a variant of the normal scores, \(m_{i}\), that we defined.) Construct a normal scores plot...
-
Use the computing formula for \(\sigma^{2}\) to rework part (b) of the preceding exercise. Data From Preceding Exercise Determining a joint cumulative distribution function Find the joint cumulative...
-
With reference to the preceding exercise, find the corresponding distribution function and use it to determine the probabilities that a random variable having this distribution function will take on...
Study smarter with the SolutionInn App