FREE Trial

Given the following demand data for five consecutive months: January: 120 units February: 130 units March: 140 units April:...

This problem has been solved!
Do you need an answer to a question different from the above? Ask your question!

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

Expert Answer:

Answer rating: 100% (QA)

1 Calculate the forecast for June using a 3 month moving average you ll average the demand data for the three most recent months March April and May A View the full answer


answer-question
Related Book For  answer-question
Cost management a strategic approach

Cost management a strategic approach

ISBN: 978-0073526942

5th edition

Authors: Edward J. Blocher, David E. Stout, Gary Cokins

See More Books
View Solution
Create a free account to access the answer
Cannot find your solution?
Post a FREE question now and get an answer within minutes. * Average response time.
Posted Date: August 19, 2023 07:40:47
See More Questions

Students also viewed these general management questions

Q:
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...
A:
Answer 12 A A bond s coupon rate sometimes abbreviated simply to coupon isn t affected by its price B However the coupon rate influences the bond s price by influencing the bond s competitiveness and......
Q:
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...
A:
1 Calculate 3 month moving average starting from April Month Actual Sales 3 Month Moving Average Apr......
Q:
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,...
A:
a b Weighted 3 Month 3 Month Moving Moving Month Sales Aver......
Q:
An operations manager wants to examine the effect of air-jet pressure (in pounds per square inch [psi]) on the breaking strength of yam. Three different levels of air-jet pressure are to be...
A:
a To test the homogeneity of variance you perform a Levenes Test H 0 H 1 Not all are the same Excel......
Q:
Coras Music manufactures harmonicas. Cora uses standard costs to judge performance. Recently, a clerk mistakenly threw away some of the records, and only partial data for September exist. Cora knows...
A:
Req 1 Standard direct labor rate per hour Favorable labor rate variance Actual direct labor rate pe......
Q:
Why is a microprocessor/DSP system called a software solution for a design?
A:
A microprocessor or DSP Digital Signal Processor system is often referred to as a software solution......
Q:
In Problems 6172, find and simplify the expression if f(x) = x 2 - 4. f(-3+h)-f(-3)
A:
Click to View...
Q:
Globals special order also requires 1,000 kilograms of genatope, a solid chemical regularly used in the companys products. The current stock of genatope is 8,000 kilograms at a book value of 12.15 p...
A:
1 The relevant cost of genatope is calculated as follows Cost of replacing the 1 000 kilograms to......
Q:
Look at the profit values for the two companies you are familiar with. Does it make sense to compare these values? If not, why, and what alternative could you pursue instead?
A:
Comparing profit values between two companies may make sense if they operate in the same industry have similar business models and are of comparable s......
Q:
For the VOC stripping task of Exercise 6.26, the expert has suggested that we use a tower diameter of 0.80 m for which we can expect a pressure drop of 500 N/m2-m of packed height (0.612 in. H2O/ft)....
A:
a Using data from Exercise 6 26 and Fig LM L 600 8 33 5 000 lb min VM V 1 000 379 29 76 5 lb min Fro......
Q:
The following table illustrates the operation of an FHSS system for one complete period of the PN sequence. Time Input data Frequency PN sequence 0 1 0 1 f 2 1 001 Time Input data Frequency PN...
A:
The given table represents the operation of a Frequency Hopping Spread Spectrum FHSS system for one complete period of a Pseudo Noise PN sequence Let......
Q:
A GST/HST registered business disposed of a passenger vehicle for $8,000 that had an original cost of $35,000 and UCC of $10,000. A new passenger gas powered vehicle was acquired for $45,000 plus...
A:
The capital cost allowance CCA for a passenger vehicle in Canada is subject to certain limitations A......
Q:
Explain all three parts of the semantic triangle: Symbol thought or reference, and referent. Give your own example of each part. What are some pros and cons of profanity in the workplace? (Refer to...
A:
Part 1 Explain all three parts of the semantic triangle Symbol thought or reference and referent Give your own example of each part Symbol thought or......
Q:
Thelma and Thomas want to retire with $2,000,000 in their portfolio. They plan on putting away $20,000 per year into five different accounts each year ($4,000 per account). They have set up the...
A:
To calculate the amount accumulated under each fund and the total accumulation after 15 years we can......
Q:
You are the marketing manager for a renowned worldwide clothing line. With the economic recession after COVID, the company is investing in new markets with alternatives to supplement the reduced...
A:
Memo AI Implementation Plan for E commerce Platform Enhancement To Management Team From Your Name Marketing Manager Date Date Subject AI Project Imple......
Q:
Imagine you are a cashier in a department store. Your customer is finished shopping and is ready to check out. She purchased one blouse priced at $19, one pair of jeans priced at $39, two pairs of...
A:
Item I Blouse I Jeans I 2 x Shoes I......
Q:
The NACA 64-412 is a cambered aerofoil with lift coefficient given by Cl = 0.11a + 0.3 when a is in degree units. What is the value of the constant pitching moment coefficient about the aerodynamic...
A:
Click to View...
Q:
The polar coordinates of a point are given. Find the rectangular coordinates of the point. (-1, - /3)
A:
x rcos 1 cos y rsin......
Q:
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...
A:
1 54 000 51 600 2 2 4537 6 4118 8 8655 3 50 000 x 8 8655 443 276 27 4 20 074 5 60 000 57 000 6 8 921......
Q:
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...
A:
Below is listed the summarized content of the two exams taken from the web sites The CPA Exam has fo......
Q:
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...
A:
1 The spreadsheet regression output for Plantcity is shown in Exhibits 8 58A B and C Exhibit 8 58A shows the regression which includes both predictors sales dollars and sales units while Exhibit 8 58B......
The Highway Capacity Manual A Conceptual And Research History Signalized And Unsignalized Intersections Volume 2 1st Edition - ISBN: 3030344789 - Free Book