Given the following demand data for five consecutive months: January: 120 units February: 130 units March:...
Fantastic news! We've Found the answer you've been seeking!
Question:
Transcribed Image Text:
Given the following demand data for five consecutive months: January: 120 units February: 130 units March: 140 units April: 150 units May: 160 units What is the forecast for June using a 3-month moving average? Given the following demand data for three consecutive months: January (Actual): 300 units February (Actual): 310 units March (Actual): 320 units The forecasted demand was 305 units for February and 310 units for March. The smoothing constant (alpha) is 0.1. What is the forecast for April using Simple Exponential Smoothing? iven the following demand data for six consecutive months: January: 120 units February: 130 units March: 150 units April: 140 units May: 160 units June: 150 units The weights for the 3-month moving average are 0.1, 0.3, and 0.6 for the first, second, and third month respectively. What is the forecast for July using a 3-month weighted moving average? Given the following actual demand and forecasts for the last five months: Month 1 2 3 4 5 Actual Demand 257 240 251 228 228 Forecast What is the Mean Absolute Deviation? 274 258 255 209 217 Given the following demand data for five consecutive months: January: 120 units February: 130 units March: 140 units April: 150 units May: 160 units What is the forecast for June using a 3-month moving average? Given the following demand data for three consecutive months: January (Actual): 300 units February (Actual): 310 units March (Actual): 320 units The forecasted demand was 305 units for February and 310 units for March. The smoothing constant (alpha) is 0.1. What is the forecast for April using Simple Exponential Smoothing? iven the following demand data for six consecutive months: January: 120 units February: 130 units March: 150 units April: 140 units May: 160 units June: 150 units The weights for the 3-month moving average are 0.1, 0.3, and 0.6 for the first, second, and third month respectively. What is the forecast for July using a 3-month weighted moving average? Given the following actual demand and forecasts for the last five months: Month 1 2 3 4 5 Actual Demand 257 240 251 228 228 Forecast What is the Mean Absolute Deviation? 274 258 255 209 217
Expert Answer:
Answer rating: 100% (QA)
1 Calculate the forecast for June using a 3month moving average youll average the demand data for the three most recent months March April and May Add ... View the full answer
Related Book For
Cost management a strategic approach
ISBN: 978-0073526942
5th edition
Authors: Edward J. Blocher, David E. Stout, Gary Cokins
Posted Date:
Students also viewed these general management questions
-
Managing Scope Changes Case Study Scope changes on a project can occur regardless of how well the project is planned or executed. Scope changes can be the result of something that was omitted during...
-
Month Actual motor sales 3 month moving average January 20 February 24 March 26 April 32 May 38 June 46 July 52 August 60 September 56 October 36 November 32 December 28 1. Calculate 3 month moving...
-
The manager of the I-85 Carpet outlet needs to be able to forecast accurately the demand for Soft Shag carpet (its biggest seller). If the manager does not order enough carpet from the carpet mill,...
-
On the accompanying graph, draw the consumption function C = $200 + 0.75YD. (a) At what level of income do households begin to save? Designate that point on the graph with the letter A. (b) By how...
-
Highlight and discuss the main features of and processes involved in the following. Strategic Moves (Credibility in Commitments) The Prisoners Dilemma and Repeated Games Collective Action Games...
-
Find the first partial derivatives of the function. f(r, s) = r ln(r 2 + s 2 )
-
For the following problems, draw the given function and find the Laplace transform in closed form. a. \(f(t)=1+\sum_{n=1}^{\infty}(-1)^{n} H(t-n)\). b. \(f(t)=\sum_{n=0}^{\infty}[H(t-2 n+1)-H(t-2...
-
Revenue Recognition on Marina Sales with Discounts Taylor Marina has 300 available slips that rent for $800 per season. Payments must be made in full at the start of the boating season, April 1,...
-
You are auditing Martha??s Prison Clothes Inc. as of December 31,2014 which uses the FIFO inventory method. The inventory for orangejumpsuits shows 1,263 suits at $782 for a total of $987,666. When 2...
-
The Springfield School Board has made the decision to close one of its middle schools (sixth, seventh, and eighth grades) at the end of this school year and reassign all of next year's middle school...
-
Discusses some of the most strategies that have been undertaken to counteract human trafficking. Be sure to describe efforts by law enforcement, the courts, and governments.
-
If your have Php1,000,000 today which you can invest for the next 10 years, where will you put it and why?
-
The ballistic pendulum is an apparatus used to measure the speed of a fast-moving projectile such as a bullet. A projectile of mass m is fired into a large block of wood of mass m suspended from some...
-
Tesla's average return is 12% and its Beta is 1.21. You computed the standard deviation to be 2.7. The average risk-free rate is 10 %. What is the Treynor index?
-
Briefly explain the structure of the deal. Does this transaction make sense for Blackstone? Does this transaction make sense for Citigroup? Why is Citigroup seeking to sell the portfolio of leveraged...
-
Please show how to build this in Alice 3.5 with detailed instruction, especially how to create categories. I'm very confused. Thank you! Make a New Project in Alice where you will build a roadway...
-
Manaia Manufacturing had the following operating results for 2 0 2 2 : sales = $ 3 0 , 6 7 4 ; cost of goods sold = $ 2 1 , 9 2 0 ; depreciation expense = $ 3 , 5 8 2 ; interest expense = $ 5 9 4 ;...
-
Rewrite the code of Figure 7.3 in Ada, Java, or C#. Figure 7.3: template class queue { item items [max_items]; int next_free, next_full, num_items; public: queue () : next_free (0), next_full(0),...
-
Allgood, Inc., an automotive exhaust system manufacturer, has two departments in muffler production, the fabrication and the assembly departments. All materials for the fabrication department were...
-
There are several professional certificate programs that are of interest to management accountants. Each certificate is awarded based on the results of a comprehensive exam plus other education and...
-
Plantcity is a large nursery and retail store specializing in house and garden plants and supplies. Jean Raouth, the assistant manager, is in the process of budgeting monthly supplies expense for...
-
The following trial balance of X Limited, a non-listed company, has been extracted from the books after the preparation of the profit and loss account and various transfers from profit and loss for...
-
The following information has been extracted from the books of account of Billinge plc as at 30 June 2006: Additional information: 1. The company was incorporated in 2000. 2. The stock at 30 June...
-
The following trial balance has been extracted from the books of Arran plc as at 31 March 2007: Additional information: 1. Stocks at 31 March 2007 were valued at 150,000. 2. Depreciation for the year...
Study smarter with the SolutionInn App