A pharmacist has been monitoring sales of a certain over-the-counter pain reliever. Daily sales during the last 15 days were Day: Number sold: 2 8. 37 40 45 44 48 49 47 46 50 10 11 12 13 14 15 Day: Number sold: 54 52 53 57 49 53 a. Assume the data refer to demand rather than sales. Using trend-adjusted exponential smoothing with an initial forecast of 42 for Day 8, an initial trend estimate of 2, and a = ß = .3, develop demand forecasts for Days 9 through 16. Then compute the resultant MSE using the error values from Days 8 through 15. (Round your intermediate period-by-period forecast and error values to 3 decimal places. Round your final MSE answer to 3 decimal places.)

A pharmacist has been monitoring sales of a certain over-the-counter pain reliever. Daily sales during the last 15 days were Day: Number sold: 2 8. 37 40 45 44 48 49 47 46 50 10 11 12 13 14 15 Day: Number sold: 54 52 53 57 49 53 a. Assume the data refer to demand rather than sales. Using trend-adjusted exponential smoothing with an initial forecast of 42 for Day 8, an initial trend estimate of 2, and a = ß = .3, develop demand forecasts for Days 9 through 16. Then compute the resultant MSE using the error values from Days 8 through 15. (Round your intermediate period-by-period forecast and error values to 3 decimal places. Round your final MSE answer to 3 decimal places.)

MATLAB: An Introduction with Applications

6th Edition

ISBN:9781119256830

Author:Amos Gilat

Publisher:Amos Gilat

Chapter1: Starting With Matlab

Section: Chapter Questions

Problem 1P

See similar textbooks

Similar questions

Please show all working.
Given the data below: Month Laptops Sold January 35 February 47 March 31 April 39 Predict the sales for May using a. weighted three-month moving average with weights 5, 3, and 2, where 5 is the weight for last month’s sale, 3 is the weight for the sales two months ago, and 2 is the weight for sales three months ago. b. exponential smoothing with α = 0.4. Assume the forecast for January was 25 laptops.
Consider the following data: Monthly Profit of a Gym Feb-12 Mar-12 Apr-12 May-12 Jun-12 Jul-12 Aug-12 Sep-12 6,090 Month Jan-12 Profit ($) 6,500 6.253 5,514 5,357 5,425 6,278 8,119 6,390 Step 3 of 5: Determine the exponentially smoothed forecast for the next time period using a smoothing constant, a, of 0.35. If necessary, round your answer to one decimal place.
Please see the attached picture. Thank you.
Below are given the annual production figures (in thousand tonnes) of a fertiliser factory : Year 2011 2012 2013 2014 2015 2016 2017 Production : 70 75 90 91 95 98 100 (1) Fit a straight line trend by the method of least squares and tabulate the trend values. (i) Convert your annual trend equation into a monthly trend equation.
The table lists the cost in millions of dollars for a 30-second commercial for selected years. Year 1994 1998 2004 2008 2011 Cost 33.7 34.2 35.0 35.5 35.9 a. Find a linear function f that models the data. b. Estimate the cost in 2010 and compare the estimate to the actual value of $36.6 million. Did your estimate involve interpolation or extrapolation? a. Use linear regression to determine the equation of the line that best fits the data. The linear function is f(x) = (Type an expression using x as the variable. Use integers or decimals for any numbers in the expression. Round to three decimal places as needed.)
8
The following are the annual profit in thousands in a.certain business. 2004 2005 2002 72 2006 2001 60 2003 75 2007 -97 Year Profit (000 OF it a straight line trend by the method of least square and tabulate the trend values and short term fluctuation. e What is the monthly incrèase in profit? O Estimate profit for 2014. 65 80 85
A small detergent company in Karachi is confident that their sales are growing significantly week by week. Treating sales for the previous eight weeks as a typical example of this increasing trend, they recorded them in PKR 1000's and examined the results. Week 1 2 3 4 5 6 Sales (in PKR) 2.59 2.55 2.63 2.68 2.74 2.83 2.86 2.99 a) Plot a scatter diagram between week and sales. b) Find the equation of regression line. c) Find the expected sales for 12 week d) Find the correlation coefficient between the two variables.
Consider the following data: Month Jan-14 Feb-14 Profit ($) 16,113 16,263 Monthly Profit of an Auto Repair Shop Mar-14 Apr-14 May-14 Jun-14 Jul-14 Aug-14 Sep-14 15,055 17,117 18,763 17,210 19,141 18,468 20,254 Step 3 of 4: Determine the exponential smoothing forecast for the next time period using a smoothing constant of 0.35. If necessary, round your answer to one decimal place.
Describe the patterns in quantity sold and own and rival prices during this time period using basic descriptive statistics. Graphs are welcome as well. Take the logs of the variables, and estimate the demand function. Interpret the R-square. Interpret the coefficients for logP and logPsub Interpret the p-values associated with each independent variable Are consumers price sensitive? Why or why not? (be as precise as you can – you have estimates!). Does this price sensitivity make sense given the good we are examining? How sensitive are our consumers to changes in the rival good’s price? Explain in detail. Suppose we decide to charge a per ounce price of $2, while at the same time our rival charges a price of $2.15. All else equal, what would you expect sales to be? How confident are you in your forecast? Suppose we are charging a price of $2 and our current marginal cost is $1.50 Are we maximizing profits at this price? If not, should we raise or lower price? Why?
A soda company is monitoring the number of cases of soda it produces as a function of time. A manager checked the line several times a day for a week. She then graphed the combined data. Assume that we should see a linear (best straight line) relationship between time and production. What is the best estimate of the number of cases that will be produced in 1 hr on a typical day? 8. 7 1 0.5 1.5 2 2.5 Time in hours Select one: а. 1 b. 2 C. 2.5 d. 4.5 е. 7 Cases of soda produced