Question: If we use this equation for weight average forecast and actual data for 12 months or whole year. Weight Average = [(Actual x 0.7)+(Forecast x

If we use this equation for weight average forecast and actual data for 12 months or whole year.

Weight Average = [(Actual x 0.7)+(Forecast x 0.3)]

And If we want to weight average for only 3 months what should I do or develop this equation?

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
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 General Management Questions!

Q:

XYZ is an unlevered firm and is currently valued at $820,000. It has 15,000 shares outstanding. As part of a Management Buyout (MBO), XYX is planning to borrow $400,000 from a bank at an annual...

Q:

Question 4. (Process Design) (6) Briefly explain the service process structures. Question 5 (Forecasting) (16) Use the actual data for six months as provided below to: i) Determine the average demand...

Q:

Garciaparra Sports Equipment Garciaparra Sports Equipment (GSE) is an international distributor of equipment for all types of sports. The firm distributes equipment in many different countries,...

Q:

The management of GSE only wants to consider the use of simple forecasting tech- niques for each product, since they carry thousands of different lines of sporting goods. As a result, attention will...

Q:

Please show the step-by-steps on how to get this answer/these numbers (including the original formulas) and the functions on the calculator that would need to be used. A company is reviewing its...

Q:

Chapter 8 - Forecasting Month January February March April May June July August September October November December Actual ($Thousands) 42 58 58 77 91 82 74 68 71 65 50 45 1. Use a three-month moving...

Q:

Chapter 7:7.2 #2 (p. 168) Chapter 8:8.2 #3 (p. 205) Chapter 9:9.2 #1 (p. 225) a., b., and c. (for c., only answer the adjustable rate mortgage part Chapter 7 from Personal Finance was adapted by The...

Q:

i need some one toanswering these three questions. make sure to include apa format for the information pretty straight forward. Attached below are the chapters. Chapter 7: 7.2 #2 (p. 168) Chapter 8:...

Q:

Drone Camera Sales Forecast You have 50 months of drone camera sales data (data are at the end of this document). After a few months of stagnant sales, the manufacturer offers an upgrade to the...

Q:

1. Lehigh University wants to design a control chart to monitor whether course registration forms are being completed correctly. The university intends to use the chart to see if improvements in the...

Q:

Southern Home and Gardens sells roses each year and they want to predict how many they will need each quarter. Use the data given below and determine the forecasts for next year. Quarter Number of...

Q:

What products would you expect from the reaction of 1 mol of 1,3-butadiene and each of the following reagents? (If no reaction would occur, you should indicate that as well.) (a) 1 mol of Cl2 (b) 2...

Q:

A robust DCF requires three reorganized financial statements: NOPLAT and its reconciliation to net income, invested capital and its reconciliation to total funds invested, and the statement of...

Q:

Form 9 9 0 , Return of Organization Exempt From Income Tax, requires all of the following except: Group of answer choices Statement of Program Accomplishments. Governance, Management and Disclosures....

Q:

atch the compensation objectives with their meanings. Efficiency Efficiency drop zone empty. Fairness Fairness drop zone empty. Compliance Compliance drop zone empty. Improving performance and...