1. Moving Averages. Use the below actual sales to calculate a three-year average which will be used...

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

Question:

1. Moving Averages. Use the below actual sales to calculate a three-year average which will be used as the forecast for next periods.

2. Exponential Smoothing. Use the same data to forecast sales for the next periods with α=.40.

3. Regression Analysis on Excel. Draw a scatter graph from Insert/Graph/Scatter graph selections in Excel.

Month	Actual Sales
1	3050
2	2980
3	3670
4	2910
5	3340
6	4060
7	4750
8	5510
9	5280
10	5504
11	5810
12	6100

Related Book For answer-question

Principles of Operations Management Sustainability and Supply Chain Management

ISBN: 978-0134181981

10th edition

Authors: Jay Heizer, Barry Render, Chuck Munson

See More Books

Posted Date: Jun 25, 2021 11:18 PM

See More Questions

A W8 will be used as a tension member with the flanges bolted as shown below. The bolts have a diameter of 3/4". The member is 25 feet long and will carry dead load of 30 kip and live load of 90 kip....
PharmaCorp will be used as the main analytical procedure tasks you will want to focus on for this assignment. The other companies, Novartell and AstraZoro, will be used as industry comparisons. The...
Make a list of assumptions that will be used as the basis for planning the wedding. And no, it is not acceptable to assume that Tony and Peggy Sue will just elope, no matter how tempting that may be!...
Ag Bio Tech (ABT) was organized on January 1, 2013, by four friends. Each organizer invested $10,000 in the company and, in turn, was issued 8,000 shares of common stock. To date, they are the only...
Why does tax law have a strong influence on German accounting?
Define line of sight. List three examples from your own career or educational experience where the principle of line of sight helped you make a better decision.
Last year there were 38,929 deaths in the United States due to motor vehicle crashes. For each statement, briefly discuss possible sources of error in the measurement. Then, considering the precision...
Fred Corp. provides the following two lines of a bond amortization schedule: Required Answer the following: a. Identify the column headings AD. b. Was the bond issued at a discount, a premium,...
A new car valued at $13,500 is to be leased for 3 years. The lease has the option to purchase the car for $7,500 at the end of the leasing period. What monthly payments, with one payment in advance,...
1. Cho, Inc. has the following items: loss on discontinued operations ($400K), loss on disposal of discontinued operations ($250K), tax rate (20%). If the above items are pre-tax dollar amounts, what...
Examine the role of professional ethics in conducting an audit. Select an ethical dilemma that may arise during an audit and discuss how you would resolve it. Discuss auditor independence in the...
1. Explain the difference between the "Zero - Growth Model" and the "Constant Growth Model". 2. What is "Terminal Value", and why do we calculate rather than forecast this terminal value? 3. What is...
Explain the physical changes that occur in sexuality in men and women during middle adulthood.
1 ) Describe the key differences between equity and debt 2 ) What is preferred stock? 3 ) Describe the concept of Market Efficiency?
3. Six months ago, Warren entered into a SHORT position in a one-year forward for 100 shares of stock of Erkis Industries at a forward price of $25 per share. Erkis Industries stock paid a dividend...
1) Fill in the blanks with either "positively" or "negatively" a) interest rates are b) the value of the dollar is c) interest rates are d) government spending is e) consumer confidence is [5]...
__________ is the process that occurs when a job applicant does research on an organization and concludes there is enough of a fit between themselves and a job opening to warrant submitting their...
Define the essential properties of the following types of operating systems: a. Batch b. Interactive c. Time sharing d. Real time e. Network f. Parallel g. Distributed h. Clustered i. Handheld
There have been complaints that the sports page of the Dubuque Register has lots of typos. The last 6 days have been examined carefully and the number of typos/page is recorded below. Is the process...
Tom Leonard, of Leonard, Spitz, and Wareham, takes 3 hours and 25 minutes to write an end of month report. Tom is rated at 95% (work pace is 95%) and the office has a personal time allowance of 8%....
Identify how changes in the external environment may affect the OM strategy for a company. For example, what impact are the following factors likely to have on OM strategy? a. The occurrence of a...
The velocity-versus-time graph in Figure P4.3 shows the motion of two different objects sliding across a horizontal surface. Could the change in the $x$ component of velocity with time be...
Consider the two velocity-versus-time graphs shown in Figure P4.4. Are the motions represented by these curves best described as similar or as different? Is the effect of friction on the motion...
Two objects collide on a low-friction track. Object 1 experiences a magnitude of change in velocity $\left|\Delta \vec{v}_{1} ight|=3 \mathrm{~m} / \mathrm{s}$, while object 2 has \(\left|\Delta...

1. Moving Averages. Use the below actual sales to calculate a three-year average which will be used...

Question:

Expert Answer:

Moving Averages Use the below actual sales to calculate a threeyear average ... View the full answer

Principles of Operations Management Sustainability and Supply Chain Management

Students also viewed these accounting questions