Question

In: Operations Management

Question 4 A pharmacist has been monitoring sales of a certain over-the-counter pain reliever. Monthly sales...

Question 4

A pharmacist has been monitoring sales of a certain over-the-counter pain reliever. Monthly sales during the last 15 months were:

Month

Number sold

Month

Number sold

Month

Number sold

1

36

6

49

11

52

2

38

7

50

12

55

3

42

8

49

13

54

4

44

9

52

14

56

5

48

10

48

15

57

  1. Using 3-Month Weighted Moving Average using 0.2, 0.3, and 0.5 with the heaviest weights applied to the most recent months, develop forecasts for months from 11 to 16.       
  2. Using Exponential Smoothing using an α = 0.4 and the 10th Month forecast of 50, develop forecasts for months from 11 to 16.              
  3. Using Trend Projection, develop forecasts for months from 11 to 16.
  4. Justify which method you would suggest using to predict future sales.

Solutions

Expert Solution

d) based on the error measure MAD, it is better to select trend projection method of forecasting, because it provides more accurate results, as compared to other two methods.

(Please like the answer it will encourage me.)


Related Solutions

A pharmacist has been monitoring sales of a certain over-the-counter pain reliever. Monthly sales during the...
A pharmacist has been monitoring sales of a certain over-the-counter pain reliever. Monthly sales during the last 15 months were: Month Number sold Month Number sold Month Number sold 1 36 6 49 11 52 2 38 7 50 12 55 3 42 8 49 13 54 4 44 9 52 14 56 5 48 10 48 15 57 Using 3-Month Weighted Moving Average using 0.2, 0.3, and 0.5 with the heaviest weights applied to the most recent months, develop...
The manufacturer of an over-the-counter pain reliever claims that its product brings pain relief to headache...
The manufacturer of an over-the-counter pain reliever claims that its product brings pain relief to headache suffers in less than 3.5 minutes, on average. In order to be able to make this claim in its television advertisements, the manufacturer was required by a particular television network to present statistical evidence in support of the claim. The manufacturer reported that for a sample of 50 headache sufferers, the mean time to relief was 3.3 minutes and the standard deviation was 66...
A nurse is caring for a patient taking over the counter medications for pain and insomnia
A nurse is caring for a patient taking over the counter medications for pain and insomnia
1. Consider the markets for pharmaceutical-grade pain killers and over-the-counter pain relievers. Evaluated at the market...
1. Consider the markets for pharmaceutical-grade pain killers and over-the-counter pain relievers. Evaluated at the market equilibrium, the estimated price elasticities of demand are 0.2 for the former and 1.8 for the latter. Assume the price elasticity of supply is 1.0 in each market. a. Construct side-by-side diagrams in which the prices of both goods are assumed to be equal. Identify the equilibrium price and quantity in both markets. b. Suppose a fall in input prices increases the supply of...
A nurse is caring for a patient taking three over-the-counter medications for pain and insomnia. The...
A nurse is caring for a patient taking three over-the-counter medications for pain and insomnia. The primary care provider has prescribed a generic drug for the patient for asthma. The patient requests information from the nurse about over-the-counter medications and the difference between generic and brand-name drugs. Although over-the-counter drugs have been found to be safe when taken as directed, what should the nurse consider telling the patient about problems related to over-the-counter drugs?
Question How do businesses control cash receipts over the counter?
Question How do businesses control cash receipts over the counter?
QuickE Lube has been monitoring its customer service times over the past 5 days. Each day...
QuickE Lube has been monitoring its customer service times over the past 5 days. Each day they took a sample of 10 customers and recorded the actual service times for those customers. The table below shows the sample mean and sample range for each of the 5 past samples. Excel access Sample 1 2 3 4 5 Mean 22 19 19.4 22.0 21.8 Range 4.4 5.1 3.2 2.9 1.0 What is the three-sigma upper control limits (UCL Only)the company should...
The PerottiPharma Company is investigating the relationship between advertising expenditures and the sales of some over-the-counter...
The PerottiPharma Company is investigating the relationship between advertising expenditures and the sales of some over-the-counter (OTC) drugs. The following data represents a sample of 10 common OTC drugs. Note that AD = Advertising dollars in millions and S = Sales in millions $. AD S 22 64 25 74 29 82 35 90 38 98 42 118 46 125 52 130 65 158 88 230 What is the equation of the regression line? State the hypotheses to test for...
The production manager of a company that produces an over-the-counter cold remedy wants to boost sales...
The production manager of a company that produces an over-the-counter cold remedy wants to boost sales of the product. The product is considered effective by the people who have tried it, but many people decide not to buy it again because it tastes like day-old soapsuds. The manufacturer is trying to decide whether to add a lemon flavor to the product. Because the flavoring will increase production costs, the manager wants to be certain that people respond favorably to the...
Question 1.) A patient has been having pain in the back and groin, renal colic, reduced...
Question 1.) A patient has been having pain in the back and groin, renal colic, reduced urine output, and painful voiding. The physician orders a urinalysis. Crystalline substances are observed in the urine on microscopic analysis, as well as some blood cells. Based on the results of an ultrasound examination, the physician recommends lithotripsy. What do you suspect might be wrong with the patient? What further diagnostic techniques do you think might be ordered?
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT