Week 1 2 3 4 5 6 7 8 9 10 11 12 A product has...
Fantastic news! We've Found the answer you've been seeking!
Question:
Transcribed Image Text:
Week 1 2 3 4 5 6 7 8 9 10 11 12 A product has a consistent year round demand. You are the planner and have been tasked with experimenting with some time series analysis. Using this previous weekly demand, calculate the following forecasts for each period possible. A) 4 Period Simple moving average B) 3 Period O Weighted moving average using weights of .7,.2,.1, C) four period weighted moving average with weights of .4,.3,.2,.1 and D) Exponential Smoothing forecast using an Alpha of .25. and a Week 1 forecast of 1900 units. Round all forecasts to whole numbers. Demand 1850 1760 1832 1895 1906 1852 1786 1790 1809 1925 1948 1960 SMA 4 Period WMA .7,.2,.1 WMA .4, .3, .2, .1 EXP Sm .25 1900 Week 1 2 3 4 5 6 7 8 9 10 11 12 A product has a consistent year round demand. You are the planner and have been tasked with experimenting with some time series analysis. Using this previous weekly demand, calculate the following forecasts for each period possible. A) 4 Period Simple moving average B) 3 Period O Weighted moving average using weights of .7,.2,.1, C) four period weighted moving average with weights of .4,.3,.2,.1 and D) Exponential Smoothing forecast using an Alpha of .25. and a Week 1 forecast of 1900 units. Round all forecasts to whole numbers. Demand 1850 1760 1832 1895 1906 1852 1786 1790 1809 1925 1948 1960 SMA 4 Period WMA .7,.2,.1 WMA .4, .3, .2, .1 EXP Sm .25 1900
Expert Answer:
Answer rating: 100% (QA)
SOLUTION To calculate the forecasts using different methods well use the provided demand data and apply the specified forecasting techniques Here are the calculations for each period A 4Period Simple ... View the full answer
Related Book For
Income Tax Fundamentals 2013
ISBN: 9781285586618
31st Edition
Authors: Gerald E. Whittenburg, Martha Altus Buller, Steven L Gill
Posted Date:
Students also viewed these general management questions
-
Find out: (1) Break-even point (5) Sala to cann a profit of $120,000 (3) Selling price per unit, of the B.C.P brought down to 60,000 units Fixed cort $100.000 Vanable cast poo unit: $6 Selling price...
-
If the focal length of a lens is 3 centimeters and the image distance is 5 centimeters from the lens, what is the distance from the object to the lens?
-
What are 2 examples of U.S. public health laws that improve environments to make healthy choices easier for individuals. Explain how these laws help with chronic disease prevention or management.
-
Alpha Appliance Service had net income for the year of $ 35,000. In addition, the balance sheet reports the following balances: Calculate the return on assets (ROA) for Alpha Appliance Service for...
-
A parcel of land costs $500,000. For an additional $800,000 you can build a motel on the property. The land and motel should be worth $1,500,000 next year. Suppose that common stocks with the same...
-
In this problem available information is not enough to solve ratios asked so that need to prepare Trading Account to identify values which are not given in the question. Compute sales amount, average...
-
Define stress and strain.
-
One of the advantages of a Hadoop implementation is that it provides a high level of computing redundancy. Why is that particularly important in a healthcare setting? Explain how the three...
-
( a 1 ) Calculate the return on shareholders' equity for Ivanhoe in 2 0 2 4 . Note that Ivanhoe's articles of incorporation authorize only common shares. The average return for the shares listed on...
-
Aduke Zhawaki is a talented musician who runs a business teaching music and playing in gigs with a variety of other musicians. Her business is operated as a proprietorship, under the name A to Z...
-
Blossom Company reported net sales $1,020,000; cost of goods sold $663,000; operating expenses $267,750; and net income $86,700. Calculate the profit margin and gross profit rate. (Round answers to 1...
-
What is the most important reason from the choices that you keep your purchase bills information up to date in your accounting system?
-
Congratulations! You have a new client! Tom's Paint has contracted you to produce a suite of programs to serve their needs. 1. Produce a Java program that generates a proposal for an interior...
-
Kenneth, who has wages of $18,500, self-employment income of $30,125, discrimination lawsuit award of $20,500, and interest income of $670, has the following expenses for 2023: Alimony paid of...
-
t is November 1 of Year 1. Sales for Cadallia Company are as follows: September: $100,000 October: $150,000 November (forecasted): $400,000 December (forecasted): $600,000 January (forecasted):...
-
which assertion is testing for Obtain the bank reconciliations for all accounts?
-
What other Intel processor uses socket LGA 1151? O Skylake Olvy Bridge O Haswell O Broadwell
-
How many years will it take a $700 balance to grow into $900 in an account earning 5%?
-
In the 2012 tax year, Michelle paid the following amounts relating to her 2010 tax return: Tax deficiency..........................................$5,000 Negligence...
-
The following additional information is available for the Dr. Ivan and Irene Incisor family. Ivan and Irene have the following investment income, in addition to that reported in Chapter 1: Dividends...
-
The following additional information is available for the Dr. Ivan and Irene Incisor family from Chapters 1-6. On December 12, Irene purchased the building where her store is located. She paid...
-
True or False: Engineers seldom have an opportunity to influence the recovery period for expenditures.
-
A lumber company purchases and installs a wood chipper for \(\$ 200,000\). The chipper is classified as MACRS 7-year property. Its useful life is 10 years. The estimated salvage value at the end of...
-
True or False: Straight-line depreciation is the most popular depreciation method used in financial reporting.
Study smarter with the SolutionInn App