Question: A supply chain analyst is analyzing past sales data. He obtained the following numbers: Week Demand 1 1045 2 1077 3 2346 4 2264

A supply chain analyst is analyzing past sales data. He obtained the following numbers: He thinks that two methods could be u

A supply chain analyst is analyzing past sales data. He obtained the following numbers: Week Demand 1 1045 2 1077 3 2346 4 2264 5 2109 6 2115 63 1953 2232 2356 2426 2378 2333 8 9 BEHE 10 11 12 13 14 15 2129 2196 He thinks that two methods could be used to forecast future sales: linear regression and weighted moving average. (1 mark) 3.1 Using Excel, please run linear regression on this data. Based on the results you obtain; do you think that linear regression is appropriate in this case? Why? 3.2 For the weighted moving average, the analyst wants to calculate a three-period weighted moving average with weights 0.6, 0.3 and 0.1. Please apply the weighted moving average methods to calculate the sales forecast in weeks 5-15.

Step by Step Solution

★★★★★

3.35 Rating (155 Votes )

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 Accounting Questions!

A registered dealer, based in Chandigarh, makes a supply to another registered dealer located in Chandigarh, valuing rupees 1,20,000. The applicable rate of GST is 12%. Calculate the amount of tax...

For the Dupit Corp. case study introduced in Section 11.4, the management science team was able to apply a variety of queueing models by making the following simplifying approximation. Except for the...

In the following normal form game: A B C a 12; -7 10:2 0,9 B 10:1 2:4 8:5 8 4:5 8:14 16: -3 (a) (3 points) Find the pure strategy best responses. You may mark the game table but you will loose a...

Question 1 A high-tech company wants to forecast the demand for their Kindle e-readers (in 000), based on the data below. (2 marks) Month Demand (000s) 1 1144 2 1182 3 1235 4 1184 5 1223 6 1218 7...

A company reports the following information: Month Units Sold Total Cost January 940 $ 5,490 February 1,840 $ 6,980 March 2,480 $ 8,100 April 640 $ 3,900 Using the high-low method, the estimated...

Question 2 A supply chain analyst is analyzing past sales data. He obtained the following numbers: Week Demand 1 2200 2 2100 3 2050 4 2120 5 2550 6 2340 7 2400 8 2370 9 2290 10 2020 11 2120 12 2170...

Question 2 Use the data provided in Question 1, the Analyst would like to establish a Linear regression model for the demand, Using Excel, please run linear regression on this data (1 mark) 2.1 2.2...

4 Question 3 A supply chain analyst is analyzing past sales data. He obtained the following numbers: Week Demand 1 3825 2 3800 3 3780 3880 5 3850 6 3820 7 3876 8 3825 9 3780 10 3780 11 3770 12 3800...

Question 3 A supply chain analyst is analyzing past sales data. He obtained the following numbers: Week Demand 1 3825 2 3800 3 3780 4 3880 5 3850 6 3820 7 3876 8 3825 9 3780 10 3780 11 3770 12 3800...

Assume that the company is preparing a second 5-year plan to reduce quality costs to 2.5% of sales. Prepare a long-range quality cost performance report that compares the costs for 20X5 with those...

Find and describe two sites targeting children under six. What is your evaluation of these sites?

Question 2 6 ( 1 point ) Evaluate the limit: lim x 1 x x - 1 . a ) 1 b ) c ) - d ) 0

Clark issued $50,000 of 10-year, 9% bonds payable on January 1, 2014. Clark pays interest each January 1 and July 1 and amortizes discount or premium by the straight-line amortization method. The...

Assemble a program menu.exe in MASM6.15 by making use of assembly language programming to be mounted in command window with the following specifications: A menu screen consisting of a bounded box...

The residual interest in a corporation belongs to the a. management. b. creditors. c. common stockholders. d. preferred stockholders.

Discuss intangible assets and describe how it is accounted for. (Include what its nature is, when to recognize costs as intangible assets, how is it measured, what are the different classes, what...

ii) Give the output of the following program. int main () { int a, b, c; a=2; b=3; c=43; c = my function (a,b, c); cout

Gradient Inc. is a U.S.-based cellphone manufacturer. It plans to launch a new range of smart phones. What should the company communicate in its new advertising campaign for the smart phones?Multiple...

Create a process flowchart for an activity that you do daily-for example, getting ready for school each day.

Breeze Toothpaste Company makes tubes of toothpaste. The product is produced and then pumped into tubes and capped. The production manager is concerned whether the filling process for the tubes of...

If the company wants to complete the project in 40 weeks, which activities should be crashed? Calculate the additional cost incurred to complete the project in 40 weeks.

Specification for the diameter of a metal shaft is much wider than the machine used to make tire shafts is capable of. Consequently, the decision has been made to allow the cutting tool to wear a...

What are the steps for designing a control chart?

Visit http://www.statease.com/pubs/breaddoe.pdf and summarize the design of experiment to determine the ingredients for bread.