A newsvendor keeps careful records of the number of papers he sells each day and thevarious costs that are relevant to his decision regarding the optimal number of newspapers to purchase. For what reason might his results be inaccurate? What would heneed to do in order to accurately measure the daily demand for newspapers?

A newsvendor keeps careful records of the number of papers he sells each day and thevarious costs that are relevant to his decision regarding the optimal number of newspapers to purchase. For what reason might his results be inaccurate? What would heneed to do in order to accurately measure the daily demand for newspapers?

Practical Management Science

6th Edition

ISBN:9781337406659

Author:WINSTON, Wayne L.

Publisher:WINSTON, Wayne L.

Chapter13: Regression And Forecasting Models

Section13.6: Moving Averages Models

Problem 21P: The file P13_21.xlsx contains the weekly sales of rakes at a hardware store for a two-year period....

See similar textbooks

Similar questions

The file P13_22.xlsx contains total monthly U.S. retail sales data. While holding out the final six months of observations for validation purposes, use the method of moving averages with a carefully chosen span to forecast U.S. retail sales in the next year. Comment on the performance of your model. What makes this time series more challenging to forecast?
The file P13_21.xlsx contains the weekly sales of rakes at a hardware store for a two-year period. Use the moving averages method, with spans of your choice, to forecast sales for the next 30 weeks. Does this method appear to track sales well? If not, what might be the reason?
The Baker Company wants to develop a budget to predict how overhead costs vary with activity levels. Management is trying to decide whether direct labor hours (DLH) or units produced is the better measure of activity for the firm. Monthly data for the preceding 24 months appear in the file P13_40.xlsx. Use regression analysis to determine which measure, DLH or Units (or both), should be used for the budget. How would the regression equation be used to obtain the budget for the firms overhead costs?
The file P13_19.xlsx contains the weekly sales of a particular brand of paper towels at a supermarket for a one-year period. a. Using a span of 3, forecast the sales of this product for the next 10 weeks with the moving averages method. How well does this method with span 3 forecast the known observations in this series? b. Repeat part a with a span of 10. c. Which of these two spans appears to be more appropriate? Justify your choice.
Assume the demand for a companys drug Wozac during the current year is 50,000, and assume demand will grow at 5% a year. If the company builds a plant that can produce x units of Wozac per year, it will cost 16x. Each unit of Wozac is sold for 3. Each unit of Wozac produced incurs a variable production cost of 0.20. It costs 0.40 per year to operate a unit of capacity. Determine how large a Wozac plant the company should build to maximize its expected profit over the next 10 years.
Sometimes curvature in a scatterplot can be fit adequately (especially to the naked eye) by several trend lines. We discussed the exponential trend line, and the power trend line is discussed in the previous problem. Still another fairly simple trend line is the parabola, a polynomial of order 2 (also called a quadratic). For the demand-price data in the file P13_10.xlsx, fit all three of these types of trend lines to the data, and calculate the MAPE for each. Which provides the best fit? (Hint: Note that a polynomial of order 2 is still another of Excels Trend line options.)
The file P13_20.xlsx contains the monthly sales of iPod cases at an electronics store for a two-year period. Use the moving averages method, with spans of your choice, to forecast sales for the next six months. Does this method appear to track sales well? If not, what might be the reason?
When you use a RISKSIMTABLE function for a decision variable, such as the order quantity in the Walton model, explain how this provides a fair comparison across the different values tested.
Suppose that a regional express delivery service company wants to estimate the cost of shipping a package (Y) as a function of cargo type, where cargo type includes the following possibilities: fragile, semifragile, and durable. Costs for 15 randomly chosen packages of approximately the same weight and same distance shipped, but of different cargo types, are provided in the file P13_16.xlsx. a. Estimate a regression equation using the given sample data, and interpret the estimated regression coefficients. b. According to the estimated regression equation, which cargo type is the most costly to ship? Which cargo type is the least costly to ship? c. How well does the estimated equation fit the given sample data? How might the fit be improved? d. Given the estimated regression equation, predict the cost of shipping a package with semifragile cargo.
Forecasts must be continually adjusted in response to unforeseen changes in projected revenues and/or expenses. True False Taxes, Insurance, and storage are typical costs associated with carrying inventory, True False Cycle counting errors will be reduced if the time during which the counts are taken is also when the product being counted is not moving. True False To determine inventory "turn" - divide throughput by the average inventory. True False One reason for maintaining multiple warehouse locations is to facilitate employee communication, e.g., avoid miscommunication. True False
Struggling with answering this question A manufacturer produces three types of humidifiers. The retail price of Humidifier Regular (HR) is $60 with variable costs of $20. Humidifier Advanced (HA) sells for $200 for its advanced features. This model’s variable costs are $80. Humidifier Simple (HS) is a simplified version and only sells for $25 with variable costs of $15. The manufacturer has machines and facilities worth $320,000 annually. The sales data show that 1000 units of HR, 2000 units of HA, and 10,000 units of HS was sold last year. Calculate the break-even point of the firm. The firm has some idle capacity at these volumes and chooses to cut the selling price of HR from $60 to $45, believing that its sales volume will rise from 1000 units to 2500 units. What is the revised break-even point?
Company C sells semiconductors that are used in handheld consumer electronics. The company has been extremely successful recording an increase in earnings each of the past four quarters. At the end of the current quarter, Larry Gomez, the company’s accountant, calculated the ending inventory for the semiconductors and was surprised to find that the quantity of the Z100 model had not changed during the quarter. Larry confirmed his calculation with the inventory control manager, who indicated that sales of the Z100 had stopped when the Z200 semiconductor was released early in the quarter. Larry found out that the Z200 semiconductor has the same applications as the Z100, but has more computing power and a lower cost than the Z100. Larry notified Sheena Snyder , the chief financial officer, about the semiconductors and recommended that the company apply the lower-of-cost-or-market method to the Z100 semiconductors in inventory. Later that day, Sheena called Larry telling him not to apply…