Question: Ms. Winnie Lins company sells computers. Monthly sales for a six-month period are as follows: MONTH SALES Jan ........ 18,000 Feb ........ 22,000 Mar ........

Ms. Winnie Lin’s company sells computers. Monthly sales for a six-month period are as follows:
MONTH SALES
Jan ........ 18,000
Feb ........ 22,000
Mar ........ 16,000
Apr ........ 18,000
May ........ 20,000
Jun ........ 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 four-month moving average;
(2) A weighted three-month moving average using .50 for June, .30 for May and .20 for April;
(3) A linear trend equation
(4) Exponential smoothing with α (smoothing constant) equal to .40, assuming a February forecast of 18,000
c. Which method do you think is the least appropriate? Why?

Step by Step Solution

★★★★★

3.31 Rating (166 Votes )

There are 3 Steps involved in it

1 Expert Approved Answer

Step: 1 Unlock

a Use graph paper or Excel to plot the monthly data b 1 A fourmonth moving ave... View full answer

Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock

Step: 3 Unlock

Document Format (1 attachment)

135-B-M-L-S-C-M (100).docx

120 KBs Word File

Students Have Also Explored These Related Management Leadership Questions!

Ohio Swiss Milk Products manufactures and distributes Ice cream in Ohio, Kentucky and West Virginia. The company wants to expand operations by locating another plant in northern Ohio. The size of the...

Which method do you think is best for establishing probable cause: grand jury or preliminary hearing? Explain your reasoning.

Which of the three approaches do you think is the most procedurally just basis for selecting workers to be laid off?

Which methodology do you think is more appropriate in Problem 12.33? Endocrinology A study was conducted [15] concerning the effect of calcium supplementation on bone loss among postmenopausal women....

1. Ms. Winnie Lin's company sells computers. Monthly sales for a six-month period are as follows: Month Sales Jan 18,000 Feb Mar 22,000 16,000 18,000 Apr May 20,000 Jun 24,000 a. Plot the monthly...

Ms . Winnie Lin's company sells computers. Monthly sales for a six - month period are as follows: MONTH SALES Jan 2 1 , 0 0 0 Feb 1 9 , 0 0 0 Mar 1 4 , 0 0 0 Apr 1 5 , 0 0 0 May 1 9 , 0 0 0 Jun 2 5 ,...

Ms. Winnie Lin's company sells computers. Monthly sales for a six-month period are as follows: MONTH SALES Jan 19,000 Feb 22,000 Mar 18,000 Apr 19,000 May 21,000 Jun 24,000 Choose the correct graph...

baby benjamin sees daddy hide a block under a bucket and delights in lifting up the buckets to find the block. then, with baby benjamin watching, daddy hides the block under the blanket....

Ms . Winnie Lin's company sells computers. Monthly sales for a six - month period are as follows: MONTH SALES Jan 1 6 , 0 0 0 Feb 1 2 , 0 0 0 Mar 1 5 , 0 0 0 Apr 1 4 , 0 0 0 May 1 7 , 0 0 0 Jun 2 8 ,...

1) a) Ms. Winnie Lin's company sells computers. Monthly sales for a six-month period are as follows: MONTH SALES Jan 18,000 Feb 16,000 Mar 17,000 Apr 18,000 May 22,000 Jun 27,000 Graph b) Compute the...

Ms . Winnie Lin's company sells computers. Monthly sales for a six - month period are as follows: MONTH SALES Jan 1 8 , 0 0 0 Feb 1 6 , 0 0 0 Mar 1 5 , 0 0 0 Apr 1 7 , 0 0 0 May 2 1 , 0 0 0 Jun 2 4 ,...

Select one nationally known, positive leader from history (someone who is now deceased) who demonstrated grit, ethical behavior, and charismatic leadership. Select three leadership traits to focus on...

Varner Inc. and King Inc. have the following operating data: a. Compute the operating leverage for Varner Inc. and King Inc.b. How much would income from operations increase for each company if the...

The Present Value of an Income Stream, P V , over a term of T years, where R ( t ) is the rate of the income stream, earning interest at a rate r , compounded continuously, is P V = 0 T R ( t ) e - r...

Listed below are several terms and phrases associated with property, plant, and equipment and intangible assets. Pair each item from List A with the item from List B (by letter) that is most...

Find V0 in the network shown. 1 22 00V j1 2 162

Find an article from Quality Progress about a specific companys supply chain quality and write a brief report similar to the Along the Supply Chain about Targets supply chain in this chapter.

This chapter revisits the idea of unconscionability. Courts will sometimes refuse to enforce deals that are, as UCC 2-302 states it, shocking and fundamentally unfair. Consider the following two...

The National Ignition Facilitys 20132014 experiments achieving net fusion energy gain involved effective confinement times of about 150 ps. What corresponding density was required to meet the Lawson...

6 Preparing simple statements of financial position Kisha owns a restaurant. The following information is available about her businesss assets and liabilities on 31 January 2014. $ Restaurant...

Janice Sanders, CEO of Pine Crest Medical Clinic, is concerned over the number of times patients must wait more than 30 minutes beyond their scheduled appointments. She asked her assistant to take...

Representatives of the Franklin Insurance Company take medical information over the phone from prospective policy applicants prior to a visit to the applicant's place of residence by a registered...

The Digi-Secure Company issues policies that protect clients from downtime costs due to computer system failures. It is very important to process the policies quickly because long cycle times not...

a . Construct the current balance sheet for the firm using the projected sales figure. ( Do not round intermediate calculations and enter your answers in dollars, not millions of dollars, rounded to...

6. Estimate the value of the stock using two different models using your calculated estimates (you must provide the models used from text or used in class and show your calculations). 7. Estimate the...

During a job interview, Pam Thompson is offered a salary of $95,000. The company gives annual raises of 5 percent. What will be Pam's salary during her fifth year on the job? Use Exhibit 1-A. (Round...