Given the following demand data: a. Calculate the four-period weighted moving average for period 9 using weights

Question:

Given the following demand data: image text in transcribed

a. Calculate the four-period weighted moving average for period 9 using weights of 0.1, 0.2, 0.3, and 0.4 where the 0.4 is the weight for the most recent period.

b. Calculate the forecast for period 9 using a 3-month moving average forecasting method.

c. Which method would you recommend using and why?

Fantastic news! We've Found the answer you've been seeking!

Step by Step Answer:

Related Book For book-img-for-question

The Fundamentals Of Production Planning And Control

ISBN: 978-0130176158

1st Edition

Authors: Stephen Chapman

See More Books

Question Posted: Jul 11, 2024 09:04 AM

See More Questions

Sam is leading a group meeting intended to decide between three relatively similar suppliers. Sam starts the meeting by saying "I know you have all studied this issue in depth, so before we begin...
If an "inferior good" like cheap M/D 20-20 wine is measured on the horizontal axis while the more expensive " normal good " vintage is on the vertical, and your budget is $50.00, what happens if your...
If an "inferior good" like cheap M/D 20-20 wine is measured on the horizontal axis while the more expensive " normal good " vintage is on the vertical, and your budget is $50.00, what happens if your...
Fletcher Fabrication, Inc., produces three products by a joint production process. Raw materials are put into production in Department X, and at the end of processing in this department, three...
A variable of a population has a mean of = 35 and a standard deviation of = 42. a. If the variable is normally distributed, identify the sampling distribution of the sample mean for samples of size...
Use a graphing calculator or computer to estimate the x-coordinates of the points of intersection of the curves y = x 4 and y = 3x - x 2 . If D is the region bounded by these curves, estimate dA. D
2.7
Given the demand equation Q = 1,500 - 200P, calculate all the numbers necessary to fill in the following table: Elasticity Total Revenue Marginal Revenue Point $7.00 6.50 6.00 5.50 5.00 4.50 4.00...
When a loan is paid off in equal installments, this I called a loan Discounted Reverse annuity Amortizing Balloon
Given the same data for the previous problem: a. Use Excel or some other statistical computer package to calculate the regression equation for the data. b. Use the regression equation to forecast the...
Given the following data: a. Calculate the three-period moving average for period 5. b. Calculate the exponential smoothed forecast for period 5 using an alpha value of 0.4. Assume the forecast for...
Byways Production has an annual capacity of 80,000 units per year. Currently, the company is making and selling 78,000 units a year. The normal sales price is $100 per unit; variable costs are $65...
Prepare the entries to record the transaction 2 A company has three employees, each of whom has been employed since January 1 earns $2750 per month and is paid on the last day of each month On March...
Pet Emporium had a robbery on the weekend in which a large amount of inventory was taken. The loss is covered completely by insurance. A physical inventory count determined that the cost of the...
In a test taken by a class of 50 students, the average was 1500 with a standard deviation of 40. What 2 scores capture the middle 60% of the students?
For questions 1-8, let P = (-2, 5) and Q = (4,8). 1. Find the distance from the point P to the point Q. 2. Find the midpoint of the line segment joining P and Q. 3. Find the slope of the line PQ. 4....
True/False Indicate whether the statement is true or false. ____ 1. In accounting, to value means to record a transaction or event. ____ 2. The recognition issue deals with when a business...
A speech signal is sampled with a sampling rate of 16,000 samples/s (16 kHz). A window of 20-ms duration is used in time-dependent Fourier analyses of the signal, as described in section 10.3, with...
Federated Shipping, a competing overnight delivery service, informs the customer in Problem 65 that they would ship the 5-pound package for $29.95 and the 20-pound package for $59.20. (A) If...
Sweeten Company had no jobs in progress at the beginning of March and no beginning inventories. The company has two manufacturing departments --Molding and Fabrication. It started, completed, and...
Horizontal Analysis The comparative accounts payable and long-term debt balances of a company are provided below. Current Year Previous Year Accounts payable $47,286 $63,900 Long-term debt 85,492...
On January 1, Year 1, Price Company issued $140,000 of five-year, 7 percent bonds at 97. Interest is payable annually on December 31. The discount is amortized using the straight-line method. Record...

Given the following demand data: a. Calculate the four-period weighted moving average for period 9 using weights

Question:

Period 1 Demand 17 22 3 4 5 6 22 18 27 14 18 20 78 8 25

Step by Step Answer:

The Fundamentals Of Production Planning And Control

Students also viewed these Business questions