Question: Find the forecast for April using Weighted Moving Average method given the below the actual sales in January is 100 units ( Its weight

Find the forecast for April using Weighted Moving Average method given the below the actual sales in January is 100 units ( Its weight is 1) the actual sales in February is 130 uits ( Its weight is 2) the actual sales in March is 150 units ( Its weight is 3)

Step by Step Solution

★★★★★

3.46 Rating (159 Votes )

There are 3 Steps involved in it

1 Expert Approved Answer

Step: 1 Unlock

Step 1 Weighted moving average is a forecasting method which helps to identify the forecasting using ... View full answer

Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock

Step: 3 Unlock

Students Have Also Explored These Related Accounting Questions!

The King of Pancakes uses a weighted moving average method to forecast pancake sales. It assigns a weight of 3 to the previous months demand, 2 to demand two months ago, and 1 to demand three months...

Christie's Pretzels uses a weighted moving average method to forecast pretzel sales. It assigns a weight of 7 to the previous month's demand, 5 to demand 2 months ago, and 2 to demand 3 months ago....

If actual sales in January were 140, February 141, March 143, and April 142, what is the approximate forecast for June using a three-month moving average? Select one: a. 144.33 b. Can not be found c....

Using the dress data above, calculate the following 1. Using the above data forecast year 3 using a simple 3 period moving average 2. Using years 1 and 2 data forecast year 3, using weighted moving...

Using the data in Solved Problem 10-3, develop a spreadsheet for a two-period weighted moving average forecast with weights of 0.6 1w12 for the most recent period and 0.4 1w22 for the other period....

The actual demand for the patients at Omaha Emer- gency Medical Clinic for the first six weeks of this year follows: Week Actual No. of Patients 123456 65 62 70 48 63 52 Clinic administrator Marc...

Using the data in Solved Problem 10-3, develop a spreadsheet for a 2-period weighted moving average forecast with weights of 0.6 (w1) for the most recent period and 0.4 (w2) for the other period....

The Polish General%u2019s Pizza Parlor is a small restaurant catering to patrons with a taste for European pizza. One of its specialties is Polish Prize pizza. The manager must forecast weekly demand...

=10-34 Using the data in Solved Problem 10-3, develop a spreadsheet for a 2-period weighted moving average forecast with weights of 0.6 (w1)for the most recent period and 0.4 (w2) for the other...

Suppose you are given the following customer arrival history at your hospital: Month Customer arrival (Dt) Forecast 800 740 WN 810 790 780 1. Use a three-month moving average to forecast customer...

If the risk-free rate increases by 1% and the default risk premium decrease by 2% what is likely to happen to the calculated cost of capital, keeping everything else constant?

How do available-for-sale securities differ from trading securities?

Scenario: At a small marketing company with 28 people, a former employee who was fired a few weeks ago came back and attacked a current employee. The attacker pushed the employee into a door, causing...

Your superior, the general manager of Plastics Manufacturers Limited, has recently been talking to the chief buyer of Plastic Toys Limited, which manufactures a wide range of toys for young children....

Kolmog Hotels is a large, listed chain of branded hotels in Ostland. Its stated mission is: ?To become the No. 1 hotel chain in Ostland, building the strength of the Kolmog brand by consistently...

Redo Problem 12.3 using Coyle and Castellos methods for estimating both Q p and Q s . Problem 12.3 A 500 mm diameter and 20 m long concrete pile is driven into a sand where = 18.5 kN/m 3 and ' = 32....

An article published in the annual Journal of Industrial Engineering (2013) studied preventive maintenance operations for fuel dispensers in a chain of gas stations. The time between failures of fuel...

Jerrys Ice Cream Parlor is considering a marketing plan to increase sales of ice cream cones. The plan will give customers a free ice cream cone if they buy 10 ice cream cones at regular prices....

how to do this steps please explain in simple words We wn e Hang one band from a fixed location on a board or wall. Hang another band from the first band. You might need to use a clip. Measure the...

Market Demand Forecast Method Selection and Application: A Case Study in Hero MotoCorp Ltd. D K Choudhury Abstract: In this dynamic era, the market is very competitive and the demand for a product...

Plan production for a four-month period: February through May. For February and March, you should produce to exact demand forecast. For April and May, you should use overtime and inventory with a...

A A ? CG ... wa week 10 Forecasting in class Tutorial Questions Home Insert Design Layout References Mailings Review View Table Design Layout LE Share A" A Aa Ap ab A A AaBbCcDdEe AaBbCcDdEe AaBbCcDc...

Your seasonally adjusted monthly sales forecast is $382,190 + $4,011(Month number), where the month number is 1 for January 2006 and increases by 1 each month. The seasonal index for February sales...

Tarrows, Pearson, Foster, and Zuligar (TPF&Z) is one of the largest actuarial consulting firms in the United States. In addition to providing its clients with expert advice on executive...

Delray Manufacturing needs to better budget and analyze costs. While Delray has experienced high sales growth, it has struggled to effectively manage costs and inventories. Delray aims to end each...