Over a two-year period, the Topper Company sold the following numbers of lawnmowers:Month: 1 2 3 4 5 6 7 8 9 10 11 12Sales: 238 220 195 245 345 380 270 220 280 120 110 85Month: 13 14 15 16 17 18 19 20 21 22 23 24Sales: 135 145 185 219 240 420 520 410 380 320 290 240a. In column A input the numbers 1 to 24 representing the months and incolumn B the observed monthly sales. Compute the three-month moving-averageforecast and place this in the third column. Be sure to align your forecast with theperiod for which you are forecasting (the average of sales for months 1, 2, and 3should be placed in row 4; the average of sales for months 2, 3, and 4 in row 5; andso on.) In the fourth column, compute the forecast error for each month in whichyou have obtained a forecast.

Over a two-year period, the Topper Company sold the following numbers of lawnmowers:Month: 1 2 3 4 5 6 7 8 9 10 11 12Sales: 238 220 195 245 345 380 270 220 280 120 110 85Month: 13 14 15 16 17 18 19 20 21 22 23 24Sales: 135 145 185 219 240 420 520 410 380 320 290 240a. In column A input the numbers 1 to 24 representing the months and incolumn B the observed monthly sales. Compute the three-month moving-averageforecast and place this in the third column. Be sure to align your forecast with theperiod for which you are forecasting (the average of sales for months 1, 2, and 3should be placed in row 4; the average of sales for months 2, 3, and 4 in row 5; andso on.) In the fourth column, compute the forecast error for each month in whichyou have obtained a forecast.

Practical Management Science

6th Edition

ISBN:9781337406659

Author:WINSTON, Wayne L.

Publisher:WINSTON, Wayne L.

Chapter7: Nonlinear Optimization Models

Section: Chapter Questions

Problem 63P

See similar textbooks

Similar questions

You want to take out a 450,000 loan on a 20-year mortgage with end-of-month payments. The annual rate of interest is 3%. Twenty years from now, you will need to make a 50,000 ending balloon payment. Because you expect your income to increase, you want to structure the loan so at the beginning of each year, your monthly payments increase by 2%. a. Determine the amount of each years monthly payment. You should use a lookup table to look up each years monthly payment and to look up the year based on the month (e.g., month 13 is year 2, etc.). b. Suppose payment each month is to be the same, and there is no balloon payment. Show that the monthly payment you can calculate from your spreadsheet matches the value given by the Excel PMT function PMT(0.03/12,240, 450000,0,0).
A small manufacturing firm collected the following data on advertising expenditures A (in thousands of dollars) and total revenue R (in thousands of dollars). (a) Draw a scatter diagram of the data. Comment on the type of relation that may exist between the two variables.(b) The quadratic function of best fit to these data isR(A) = - 7.76A2 + 411.88A + 942.72Use this function to determine the optimal level of advertising.(c) Use the function to predict the total revenue when the optimal level of advertising is spent.(d) Use a graphing utility to verify that the function given in part (b) is the quadratic function of best fit.(e) Use a graphing utility to draw a scatter diagram of the data and then graph the quadratic function of best fit on the scatter diagram.
2 Vidhya Balan is planning to liquidate her investments inmutual funds and invest in real estate. Before makingthe change to her investment strategy, Vidhya wants toforecast the price of mutual funds for the next 2 months.She has collected the following data on the average fundprices for the past 10 months.Month Average Fund Price1 55.12 53.83 53.44 52.955 52.156 52.757 52.658 51.59 52.2510 51.7a Using a five-period moving average, forecast theaverage fund price for Period 11.b. Using exponential smoothing with α = 0.3 forecastthe average fund price for Period 11. Assume an initialforecast for Month 2 (F2) as 55.10
Financial planner Minnie Margin has a substantial number of clients who wish to own a mutual fund portfolio that matches, as a whole, the performance of the Russell 2000 index. Her task is to determine what proportion of the portfolio should be invested in each of the five mutual funds listed below so that the portfolio most closely mimics the performance of the Russell 2000 index. Annual Returns Year 1 Year 2 Year 3 Year 4 International Stock 22.37 26.73 4.86 2.17 Large-Cap Value 15.48 19.64 11.50 -5.25 Mid-Cap Value 17.42 20.07 -4.97 -1.69 Small-Cap Growth 23.18 12.36 3.25 3.81 Short-Term Bond 9.26 8.81 6.15 4.04 Russell 2000 Index 20 22 8 2 Write out the (non-linear) program that would produce a portfolio that most closely mimics the performance of the Russell 2000 Index. Use Excel's Solver with "GRG Non-Linear" as the solution algorithm: what is the optimal solution, i.e., what…
solve a and b The following table shows the rank attained by male and female officers in the NewYork City Police Department (NYPD).a) Do these data indicate that men and women are equitably represented at all levelsof the department? Test using a p-value approach. Male FemaleOfficer 21,900 4281Detective 4058 806Sergeant 3898 415Lieutenant 1333 89Captain 359 12Higher ranks 218 10 b) There are far more men than women in the police force in general. However, the NYCPolice Commission has set itself certain goals with respect to the positions of the femalesamong its ranks. Across the females they aim to target the same proportion by rank asthey do among the males. The target proportions by category are:(1) Officer – 70% (2) Detectives – 15% (3) Sargent – 10%(4) Lieutenant – 3% (5) Captain – 1% (6) Higher – 1%Conduct a test to determine whether the proportions,…
The LP relationships that follow were formulated by Richard Martin at the Long Beach Chemical Company. Maximize 4X1+12X1X2+5X3 Subject to: 2X1X2+2X3≤70 (C1) 10.9X1−4X2≥15.6 (C2) 10X1+3X2+3X3≥21 (C3) 16X2−13X3=17 (C4) −4X1−X2+4X3=5 (C5) 7X1+2X2+3X3≤80 (C6) For an LP, the objective function developed by Richard is (valid or onvalid) . Constraint C1 is a(n) (valid or onvalid) LP constraint. Constraint C2 is a(n) (valid or onvalid) LP constraint. Constraint C3 is a(n) (valid or onvalid) LP constraint. Constraint C4 is a(n) (valid or onvalid) LP constraint. Constraint C5 is a(n) (valid or onvalid) LP constraint. Constraint C6 is a(n) (valid or onvalid) LP constraint.
This problem does not require the use of data mining software and focuses on knowledge of concepts and basic calculations. Jay Gatsby categorizes wines into one of three clusters. The centroids of these clusters (in standardized units), describing the average characteristics of a wine in each cluster, are listed in the following table. Characteristic Cluster 1 Cluster 2 Cluster 3 Alcohol 0.819 0.164 −0.937 Malic Acid −0.329 0.869 −0.368 Ash 0.248 0.186 −0.393 Alkalinity −0.677 0.523 0.249 Magnesium 0.643 −0.075 −0.573 Phenols 0.825 0.977 −0.034 Flavonoids 0.896 −1.212 0.083 Nonflavonoids −0.595 0.724 0.009 Proanthocyanidins 0.619 −0.778 0.010 Color Intensity 0.135 0.939 −0.881 Hue 0.497 −1.162 0.437 Dilution 0.744 −1.289 0.295 Proline 1.117 −0.406 −0.776 Jay has recently discovered a new wine from the Piedmont region of Italy with the following characteristics. In which cluster of wines should Jay place this new wine? Justify your choice with appropriate…
The table below shows the sales figures for a brand of shoe over the last 12 months.Months SalesJanuary 69February 75March 86April 92May 95June 100July 108August 115September 125October 131November 140December 150a. Using the following, forecast the sales for the months up to January the following year:-i. A simple three month moving average. ii. A three period weighted moving average using weights of 1, 2 and 3. Assign the highest weight to the most recent data. iii. Exponential Smoothing when α= .6 and the forecast for March is 350.iv. Determine which of the three forecasting technique is the most accurate using MAD.
A national truck rental services has a surplus of one truck in each of the cities, 1, 2, 3, 4, 5, and 6 and a deficit of one truck in each of the cities 7,8,9,10,11 and 12.The distance (in kilometers) between the cities with a surplus and cities with deficit are displayed below:a) b) How should the trucks be displayed so as to maximize the total distance travelled? 1 2 3 4 5 6 7 41 72 39 52 25 51 8 22 29 49 65 81 50 9 27 39 60 51 32 32 10 45 50 48 52 37 43 11 82 40 40 60 51 30
In research, it is very important to identify the different types of variable. Variables may assume categorical or numerical values. Make a report regarding the different types of variables, their uses and if possible, examples.
A portfolio manager summarizes the input from the macro and micro forecasters in the following table: Micro Forecasts AssetExpected Return (%)BetaResidual Standard Deviation (%) Stock A 22 1.4 53 Stock B 21 1.8 61 Stock C 19 0.7 58 Stock D 16 1.1 46 Macro Forecasts AssetExpected Return (%)Standard Deviation (%) T-bills 7 0 Passive equity portfolio 16 20 Calculate the following for a portfolio manager who is not allowed to short sell securities. If allowed to short sell securities, the manager's Sharpe ratio is 0.4647. a. What is the cost of the restriction in terms of Sharpe’s measure? (Do not round intermediate calculations. Enter your answer as decimals rounded to 4 places.) cost of restriction= b. What is the utility loss to the investor (A = 1.9) given his new complete portfolio? (Do not round intermediate calculations. Round your answers to 2 decimal places.)
Confederate Express Service is attempting to determinehow its shipping costs for a month depend on the numberof units shipped during a month. For the last 15 months, thenumber of units shipped and total shipping cost are given inTable 24 (file Ship.xls). Units TotalMonth Shipped Shipping Cost1 300 $1,0602 400 $1,3803 500 $1,6404 200 $7405 300 $1,0606 350 $1,1907 460 $1,5208 480 $1,5809 120 $54010 760 $2,42011 580 $2,20012 340 $1,47013 120 $79014 100 $72015 500 $1,960