Question: please do NOT use Excel and do it manually to show work. 12.2. The manager of the I- 85 Carpet Outlet needs to be able

please do NOT use Excel and do it manually to show work.

12.2. The manager of the I- 85 Carpet Outlet needs to be able to forecast accurately the demand for Soft Shag carpet (its biggest seller). If the manager does not order enough carpet from the carpet mill, customers will buy their carpets from one of the outlet's many competitors. The manager has collected the following demand data for the past eight months: a. Compute a three-month moving average forecast for months 4 through 9. b. Compute a weighted three-month moving average forecast for months 4 through 9. Assign weights of .55,.33, and .12 to the months in sequence, starting with the most recent month. c. Compare the two forecasts using MAD. Which forecast appears to be more accurate

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!

PRACTICE QUESTIONS: Please show actual calculations (not excel functions WHEN FILLING IN TABLE)! Using the exponential smoothing forecasting techniques with = .40. a). Compute the exponentially...

Chapter 12: problem 2: for all Excel problems, submit the input (showing formulas, if any are required) and output. 2a - using Excel - also calculate MAD using Excel arithmetic mean using Excel -...

Question carried onto different pages, all 3 screenshots are different parts of the same question. please show work The manager of the Trans-Canada Carpet outlet needs to be able to forecast...

PRACTICE QUESTIONS: Please answer a-d. Please show all actual calculations (not excel functions)!!!!!!!!!!!!!!!!!!!!!!!!! Please show all actual calculations (not excel...

Question 1 of 6 > 10/15 E View Policies Show Attempt History Current Attempt in Progress The manager of the Trans-Canada Carpet outlet needs to be able to forecast accurately the demand for Soft...

PRACTICE QUESTIONS: Please answer a-d. Please show all actual calculations (not excel functions)!!!!!!!!!!!!!!!!!!!!!!!!! Table 2. The manager of Carpet City outlet store needs to be able to forecast...

Hi, I was wondering if you can help me with some financial accounting work? I need help in computing the numbers for Forecast Values for 2024 for Humana using the information below. I have a sample...

I have to do an accounting assignment. I have attached the instructions, the questions, and pdf's containing the information requested for the questions. Company Estimates & Opinions Sanmina Corp...

Please Answer Asap Thank you! A30. SUPPLEMENT A SPREADSHEET MODELING: AN INTRODUCTION Problems 1. Kaizer Plastic produces a variety of plastic items for pack Soek can work only with a single "Set...

Looking for assistance for the attached assignment it is a two part assignment one is a word document the second a financial chart. (read the attachment that says Final Project Guidelines and read...

In many financial transactions, interest is computed and charged more than once a year. Interest on corporate bonds, for example, is usually payable every six months. Consider a loan transaction in...

Write a paper in which you address the following: What challenges might present them when taking an online test? List four challenges and four strategies for working through them? Address the...

In the high-level programming language that your school has chosen to use, write expressions that would store user inputs as the data types represented by the following: >>12 >>12.00 >> X >>> X marks...

As the manager of Smith Construction, you need to make a decision on the number of homes to build in a new residential area where you are the only builder. Unfortunately, you must build the homes...