A supply chain analyst is analyzing past sales data. He obtained the following numbers: Week Demand...
Fantastic news! We've Found the answer you've been seeking!
Question:
Transcribed Image Text:
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. 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.
Expert Answer:
Related Book For
Posted Date:
Students also viewed these 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...
-
Golden Food Products produces special-formula pet food. The company carries no inventories. The master budget calls for the company to manufacture and sell 120,000 cases at a budgeted price of $60...
-
A cheese enchilada is 4.00 cm in front of a converging lens. The magnification of the enchilada is -2.00. What is the focal length of the lens?
-
You are purchasing a new car. The possible manufacturers, car sizes, and colors are listed in the table. How many different ways can you select one manufacturer, one car size, and one color? Use a...
-
Part One: Backflush Costing Urban Fit Inc. uses backflush costing to account for production costs of its clothing. During June, the company produced 45,000 units and sold 40,000 units. The standard...
-
Golden Printing Company is considering replacing a machine that has been used in its factory for four years. Relevant data associated with the operations of the old machine and the new machine,...
-
Provide Proof: P Q ( Q R ) ( P R )
-
Suppose that fixed costs for a firm in the automobile industry (start-up costs of factories, capital equipment, and so on) are $5 billion and that variable costs are equal to $17,000 per finished...
-
You want to quit your job and go to graduate school, 6 years from now. You have begun saving $15,600 per year, starting right now. How much money will you have by the time you are ready to start your...
-
On August 31, 2016 the following data were accumulated to assist the accountant in preparing the adjusting entries for Potter Reality: a. Fees accrued but unbilled at August 31, 2016 were 1,700. b....
-
Harris Fabrics computes its plantwide predetermined overhead rate annually on the basis of direct labor-hours. At the beginning of the year, it estimated that 37,000 direct labor-hours would be...
-
Dolson Appliances makes coffee machines for offices and homes. For next year, the production budget is 141,000 units. Beginning inventories will be 18,000 units and the desired ending inventory will...
-
Gross charges for hospital services, all charged to accounts and notes receivable, were as follows: Patient service revenue $1,668,700 The hospital cafeteria and gift shop had cash sales of $297,200....
-
If the seat is not available or DOES NOT EXIST, display a warning message. Instruction: Using Java programming language, create a program that will create a simple Reservation system using classes,...
-
On November 10, 2020, Singh Electronics began to buy and resell scanners for $52 each. Singh uses the perpetual system to account for inventories. The scanners are covered under a warranty that...
-
A regular deposit of $100 is made at the beginning of each year for 20 years. Simple interest is calculated at i% per year for the 20 years. At the end of the 20-year period, the total interest in...
-
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.
-
All Canadian corporations must comply with international accounting standards.
-
Most Canadian corporations are listed on the Toronto Stock Exchange.
-
IFRS must be used for the financial statements of every Canadian public corporation.
Study smarter with the SolutionInn App