Question

In: Statistics and Probability

Problem 6-11 For the Hawkins Company, the monthly percentages of all shipments received on time over...

Problem 6-11

For the Hawkins Company, the monthly percentages of all shipments received on time over the past 12 months are 80, 82, 84, 83, 83, 84, 85, 84, 82, 83, 84, and 83.

  1. Choose the correct time series plot.


    What type of pattern exists in the data?

    Horizontal Pattern
  2. Compare a three-month moving average forecast with an exponential smoothing forecast for α = 0.2. Which provides the better forecasts using MSE as the measure of model accuracy? Do not round your interim computations and round your final answers to three decimal places.
    Moving
    average
    Exponential
    smoothing
    MSE
    Exponential smoothing
  3. What is the forecast for next month? If required, round your answer to two decimal places.

Solutions

Expert Solution

a)

b)

c)


Related Solutions

For the Hawkins Company, the monthly percentages of all shipments received on time over the past...
For the Hawkins Company, the monthly percentages of all shipments received on time over the past 12 months are 80, 82, 84, 83, 83, 84, 85, 84, 82, 83, 84, and 83. (a) Choose the correct time series plot.   (i) (ii)         (iii) (iv)   - Select your answer -Plot (i)Plot (ii)Plot (iii)Plot (iv)   What type of pattern exists in the data?   - Select your answer -Horizontal Pattern OR Trend Pattern     (b)...
For the Hawkins Company, the monthly percentages of all shipments received on time over the past...
For the Hawkins Company, the monthly percentages of all shipments received on time over the past 12 months are 80, 82, 84,83,83,84,85,84,82,83,84, and 83. Using excel. A. Compute the MSE’s for two forecasts, one using a 2 month moving average and the other exponential smoothing with a value of 0.25. B. Which of these two forecasting approaches is preferred? Please be sure to explain why you have reached this conclusion.
ORDERS VS. SHIPMENTS CUSTOMERS IN PAST 6 MONTHS MONTHLY SALES ($) Size # Ordered # Received...
ORDERS VS. SHIPMENTS CUSTOMERS IN PAST 6 MONTHS MONTHLY SALES ($) Size # Ordered # Received Customer # # Visits $ Purchases Month $ Sales Extra Small 30 23 1 8 468 Jan 1375 Small 50 54 2 6 384 Feb 1319 Medium 85 92 3 8 463 Mar 1222 Large 95 91 4 2 189 Apr 1328 Extra Large 60 63 5 10 542 May 1493 2X Large 45 42 6 4 299 Jun 1492 7 6 345 Jul...
“It is essential to constrain all shipments in a transportation problem to have integer values to...
“It is essential to constrain all shipments in a transportation problem to have integer values to ensure that the optimal LP solution consists entirely of integer- valued shipments.” Is this statement true or false? Why?
The logistics company wants to know if the time it takes to receive shipments is the...
The logistics company wants to know if the time it takes to receive shipments is the same or different for two shipping companies. A random sample of delivery times is selected for each of the two shipping firms. The null and alternative hypotheses are: ?0: (?1−?2)=0 ??: (?1−?2)≠0 A 0.10 significance level is chosen for this two-tailed test. The samples are selected, and the results are: ?1 = 14.8 ????   ?1 = 4.6 ???? ?1 = 35 ?2 = 17.4...
On April 11, 2014, Cynthia received a loan of $45,000 at 5.55% compounded monthly. On May...
On April 11, 2014, Cynthia received a loan of $45,000 at 5.55% compounded monthly. On May 13, 2015, the interest rate on the loan changed to 5.75% compounded quarterly and remained constant thereafter. What will be the accumulated value of the loan on December 31, 2017?
Exercise 6-47 (Algorithmic) Recording Purchases and Shipping Terms On May 12, Digital Distributors received three shipments...
Exercise 6-47 (Algorithmic) Recording Purchases and Shipping Terms On May 12, Digital Distributors received three shipments of merchandise. The first was shipped F.O.B. shipping point, had a total invoice price of $150,000, and was delivered by a trucking company that charged an additional $12,000 for transportation charges from Digital Distributors. The second was shipped F.O.B. shipping point and had a total invoice price of $89,000, including transportation charges of $6,200 that were prepaid by the seller. The third shipment was...
Problem 11-29 Margin of safety and operating leverage LO 11-6 Vernon Company is considering the addition...
Problem 11-29 Margin of safety and operating leverage LO 11-6 Vernon Company is considering the addition of a new product to its cosmetics line. The company has three distinctly different options: a skin cream, a bath oil, or a hair coloring gel. Relevant information and budgeted annual income statements for each of the products follow. Relevant Information Skin Cream Bath Oil Color Gel Budgeted sales in units (a) 136,000 216,000 96,000 Expected sales price (b) $ 9 $ 7 $...
Impact in the accounting equation Received monthly utility bill to be paid at later time
Impact in the accounting equation Received monthly utility bill to be paid at later time
Time Remaining 2 hours 2 minutes 11 seconds 02:02:11 Item 6 Item 6 Time Remaining 2...
Time Remaining 2 hours 2 minutes 11 seconds 02:02:11 Item 6 Item 6 Time Remaining 2 hours 2 minutes 11 seconds 02:02:11 The Molson Company had budgeted production for the year as follows: Quarter 1 2 3 4 Production in units 11,700 13,700 19,600 15,700 Four pounds of raw materials are required for each unit produced. Raw materials on hand at the start of the year total 5,700 lbs. The raw materials inventory at the end of each quarter should...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT