Question: Excel format please: 1. Ms. Winnie Lin's company sells computers. The monthly sales for a six-month period are as follows: MONTH Jar Feb Mar Apr

Excel format please:

Excel format please: 1. Ms. Winnie Lin's company

1. Ms. Winnie Lin's company sells computers. The monthly sales for a six-month period are as follows: MONTH Jar Feb Mar Apr May Jun SALES 18.000 22.000 16.000 18.000 20.000 24,000 a. Plot the monthly data on a sheet of graph paper. b. Compute the sales forecast for July using the following approaches: (1) a three-month moving average: (2) a weighted three-month moving average using 0.50 for June, 0.30 for May, and 0.20 for April; (3) a linear trend equation; and (4) exponential smoothing with a smoothing constant) equal to 0.40, assuming a February forecast of 18,000. c. Which method do you think is the least appropriate? Why? d. Calculate the MAD for each of the four techniques in part b. Which is the best? Why

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!

please help as soon as possible XYZ tech company sells computers. The monthly sales for a six-month period are as follows: 10 marks MONTH SALES 3-month WMA Jan Feb. Mar. Apr. May Jun. July 180 220...

National Scan, Inc., sells radio frequency inventory tags. Monthly sales for a seven-month period were as follows: Month Feb. Mar. Apr. . Jun. Jul. Aug Sales (000) Units 20 23 7 25 18 28 30 Click...

Using the data from the previous question, you ve decided to calculate July's forecast using the weighted three month moving average with 50 for June 30 for May, and 20 for April. Which of the...

2. XYZ tech company sells computer. The monthly sales for a six-month period are as follows: & marks MONTH SALES 3-month Weighted Error moving Avg. 2-month Weighted Error moving avg Jan Feb. Mar....

can someone explain and help me do this please? thank you so much National Scan, Inc., sells radio frequency Inventory tags. Monthly sales for a seven-month period were as follows: Month Feb. Mar....

This assignment provides you with the opportunity to synthesize and apply what you have learned in chapters 3 through 5. It consists of 3 questions and multiple sub-questions for a total of 100...

please post steps of work. USE EXCEL! Assignment 2 Q1. National Scan, Inc., sells radio frequency inventory tags. Monthly sales for a seven-month period were as follows: Month Feb. Mar. Apr. May....

National Scan, Inc., sells radio frequency inventory tags. Monthly sales for a seven-month period were as follows: Month Feb. Mar Apr nay . Jun. Jul. Aug Sales 1000) Units 16 19 13 21 22 22 24 29...

National Scan, Inc., sells radio frequency inventory tags. Monthly sales for a seven-month period were as follows: Month Feb. Mar. Apr. May. Sales (200) Units 15 19 12 21 23 24 27 Jun. Jul. Aug....

National Scan, Inc., sells radio frequency inventory tags. Monthly sales for a seven-month period were as follows: Month Feb. Mar. Apr. May Jun. Jul. Aug Sales (000) Units 20 23 7 25 18 28 30 Click...

As of December 31, 2012, Nilsen Industries had $2,000 of raw materials inventory. At the beginning of 2012, there was $1,600 of materials on hand. During the year, the company purchased $324,000 of...

A pump supplies oil at 25 gpm to a 1.5 inch diameter double-acting hydraulic cylinder. If the load is 1200 lb (extending and retracting) and the rod diameter is 3.25 inch, find the following: i....

Loomis Inc. received $90,000 on March 1, Year 2, for work to be performed over the next six months. The company, which has a fiscal year-end of June 30, records revenue evenly over the period of work...

What is an example of constructive feedback? provide reference