Question: how do i do this without excel. thanks! 03.(Ref:10.3.16, p102 of the text book): A pharmacist has been monitoring sales of a certain over-the-counter (l.eno

how do i do this without excel. thanks!

03.(Ref:10.3.16, p102 of the text book): A pharmacist has been monitoring sales of a certain over-the-counter (l.eno prescription is needed) pain reliever. Daily sales during the last 15 days were: Day: 1 2 3 4 5 6 7 8 9 Number sold: 36 38 42 44 48 49 50 49 52 Day: 10 11 12 13 14 15 Number sold: 48 52 55 54 56 57 (a) If you learn that on some days the store ran out of this pain reliever, would that knowledge cause you any concern regarding the use of sales data for forecasting demand? Explain. (b) Assume that there was no stock-outs. Plot the data. Is the linear trend model appropriate for this item? Explain. (c) Using trend-adjusted exponential smoothing with initial smoothed series and trend determined from days 1 to 8 and a = BH 3, develop forecasts for days 9 through 16

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!

The following network shows the major roads that would be part of the hurricane evacuation routes for Charleston, South Carolina: The destination is the interchange of Interstate 26 and Interstate...

Q3 ( Ref. Q# 3.16, page 107 of the Text Book.) A pharmacist has been monitoring sales of a certain over-the-counter (i.e., no prescription is needed) pain reliever. Daily sales during the last 15...

the possible reasons for this failure? (c) Estimate the duration of the activity? Your team is estimating duration of an activity, a group of team members is saying it will take "X+2" to complete the...

Emerging from the shutdown, many of KTRs customers had long work backlogs and were ordering custom-built products that they were not able to store. So many sales in 2020 were done on a bill-and-hold...

The ordered array below represents the number of cargo manifests approved by customs inspectors of the Port of New York in a sample of 35 days: 16, 17, 18, 18, 19, 20, 20, 21, 21, 21, 22, 22, 22, 22,...

What nominal retum was recelved by an investor when inflation averaged 3 . 4 6 3 and the real rate of return was 2 5 4 6 ? Mancle Oroice 0 9 6 % 5 9 0 6 6 0 5 % 5 4 . 7 %

Match each of the following phrases with the term (a-e) that it most closely describes it.Each term will be used only once. Question 11 options: the process by which factory overhead is assigned to a...