(Demand Forecasting) The actual demand of a particular product over the past four years are given...
Fantastic news! We've Found the answer you've been seeking!
Question:
Transcribed Image Text:
(Demand Forecasting) The actual demand of a particular product over the past four years are given in Table Q5. Table Q5 Quarter Q1 a. Year 2018 C. 2019 2020 2021 88 2288 2288 2288 Q2 Q3 Q4 Q1 Q2 Q3 Q4 Q1 Q2 Q3 Q4 Q1 Q2 Q3 Demand 1,100 1,100 1,300 1,600 2,200 2,600 2,800 2,900 3,400 3,500 3,900 4,300 4,500 4,500 5,100 Using exponential smoothing technique, calculate the demand of the product for the fourth quarter (Q4) of the year 2021, using smoothing parameter (a = 0.2) (7 Marks) b. Using exponential smoothing technique, calculate the demand of the product for the fourth quarter (Q4) of the year 2021, using smoothing parameter (a = 0.3). (7 Marks) Determine the accuracy of the above two forecast models using the following measures of forecast accuracy: (1) Mean Absolute Deviation (MAD) (ii) Mean Squared Error (MSE), and (ii) Standard Error (SE). (2 Marks x 3 = 6 Marks) (Note: Take the average of the first two quarters as the forecast of the first quarter) [Total Marks: 20] (Demand Forecasting) The actual demand of a particular product over the past four years are given in Table Q5. Table Q5 Quarter Q1 a. Year 2018 C. 2019 2020 2021 88 2288 2288 2288 Q2 Q3 Q4 Q1 Q2 Q3 Q4 Q1 Q2 Q3 Q4 Q1 Q2 Q3 Demand 1,100 1,100 1,300 1,600 2,200 2,600 2,800 2,900 3,400 3,500 3,900 4,300 4,500 4,500 5,100 Using exponential smoothing technique, calculate the demand of the product for the fourth quarter (Q4) of the year 2021, using smoothing parameter (a = 0.2) (7 Marks) b. Using exponential smoothing technique, calculate the demand of the product for the fourth quarter (Q4) of the year 2021, using smoothing parameter (a = 0.3). (7 Marks) Determine the accuracy of the above two forecast models using the following measures of forecast accuracy: (1) Mean Absolute Deviation (MAD) (ii) Mean Squared Error (MSE), and (ii) Standard Error (SE). (2 Marks x 3 = 6 Marks) (Note: Take the average of the first two quarters as the forecast of the first quarter) [Total Marks: 20]
Expert Answer:
Answer rating: 100% (QA)
a Using exponential smoothing technique calculate the demand of the product for t... View the full answer
Related Book For
Managerial Accounting Decision Making and Performance Management
ISBN: 978-0273764489
4th edition
Authors: Ray Proctor
Posted Date:
Students also viewed these accounting questions
-
The actual choice of a damage measure often depends on practical problems, not theory. Give some examples of breached contracts in which opportunity-cost damages are easier to implement than...
-
A firms long-run total costs are given in Table 12P-5. a. Fill in the long-run average total cost column. b. Over what production range does this firm experience economies of scale? c. Over what...
-
Over the past four years the gross profit rate for Simard Company was 26%. Last week a fire destroyed all of Simards inventory. Luckily, all the records for Simard were in a fireproof safe and...
-
According to the Mortgage Bankers Association, 10% of all home mortgage loans in California were in foreclosure in the fourth quarter of 2011. Assuming this rate holds, if you randomly pick 30...
-
David E. Ross, his two brothers, and their families operated and owned the entire stock of five businesses. Ross had three children: Rod, David II, and Betsy. David II and Betsy were not involved in...
-
It is common in many countries that governments subsidize the production of goods in certain large oligopolistic industries. Common examples include aircraft industries and car industries. A: Suppose...
-
The production manager at Ace Manufacturing is contemplating whether he should upgrade some old production equipment. He is considering the following factors: Required: For each item listed, indicate...
-
Lisa Kohl (age 44) is an unmarried high school principal. Lisa received the following tax documents: During the year, Lisa paid the following amounts (all of which can be substantiated): Home...
-
Consolidation. Comparative consolidated balance sheet data for BIG Co and its 65% owned subsidiary LITTLE co are as follow: Item 2020 2019 Cash 12,000 25,000 Notes receivables (net) 60,000 43 000...
-
Why are global value chains so important to emerging markets and their development? Select two GVCs, and discuss to what extent emerging market firms and governments can respond to the opportunities...
-
The Changing Workforce The composition of the modern labor force is changing rapidly. Increasing diversity in race, ethnicity, and gender, a shift in age distribution, and a shift in the skill levels...
-
Regarding Charles Schwab case Q4, Would you advise Velez to pursue the idea of providing different levels of service to customers in the same segment, depending on their profitability? More...
-
1.In September, Cottons Company produced 1,000 units of product. 2,080 units of raw materials were used at a total cost of P303,680. The actual direct labor hours used were equivalent to 97.60% of...
-
Think about a large company you know such as GE, BMW, Procter & Gamble (NOT APPLE). 1.Identify opportunities for creative and effective diversification. 2.Are there examples of UNRELATED...
-
NANA NOODLES Co. is a multinasional company engaged in the Food & Beverage Industry and produces a wide range of instant and dry noodles and various beverages. As a company with headquarters in...
-
Fraser Industrial Manufacturing (FIM) manufactures a single product that sells for $200. The company is not satisfied with its performance and is looking for ways to improve results. Mary Fraser, the...
-
You will consider puts and calls on a share with spot price of $30. Strike price is $34. Furthermore, assume that over each of the next two four-month periods, the share price is expected to go up by...
-
The percentage of completion and completed contract methods are described in the FASB ASC. Search the codification to find the paragraphs covering these topics, cite them, and copy the results.
-
Welco Ltd manufactures one type of hydraulic jack. The labour force, who are all paid at the same rate, assemble and finish two bought-in components. Each jack uses two metal castings and one rubber...
-
Chonky Ltd is a private company manufacturing and supplying spares to the motor trade. The following is a summary of the results of the business for the last four years together with year-end balance...
-
MOV plc produces custom-built sensors. Each sensor has a standard circuit board (SCB) in it. The current average contribution from a sensor is 400. MOV plcs business is steadily expanding and in the...
-
\(-\frac{3}{7}\) Identify each number as a natural number, an integer, a rational number, or a real number.
-
\(\sqrt{19}\) Identify each number as a natural number, an integer, a rational number, or a real number.
-
13 Identify each number as a natural number, an integer, a rational number, or a real number.
Study smarter with the SolutionInn App