Any help is appreciated. Thank you. To examine the effectiveness of its four annual advertising promotions, a mail order company has sent a questionnaire to each of its customers, asking how many of the previous year's promotions promptedorders that would not have otherwise been made. The accompanying table lists the probabilities that were derived from the questionnaire, where X is the random variable representing the number ofpromotions that prompted orders. If we assume that overall customer behavior next year will be the same as last year, what is the expected number of promotions that each customer will take advantage ofnext year by ordering goods that otherwise would not be purchased?12 34P(X)0.10.247 0.304 0.155 0.194Expected value =A previous analysis of historical records found that the mean value of orders for promotional goods is 39 dollars, with the company earning a gross profit of. 28% on each order. Calculate the expected valueof the profit contribution next year.Expected value =The fixed cost of conducting the four promotions is estimated to be 15000 dollars with a variable cost of 5 dollars per cùstomer for mailing and handling costs. What is the minimum number of customersrequired by the company in order to cover the cost of promotions? (Round your answer to the next highest integer.)Breakeven point =

A Small Introduction about Product Management The fundamental target of product management is the…

Answered: P(X)U.T0.24/0.304 U.155 0.194 Expected…

Practical Management Science

6th Edition

ISBN:9781337406659

Author:WINSTON, Wayne L.

Publisher:WINSTON, Wayne L.

Chapter13: Regression And Forecasting Models

Section: Chapter Questions

Problem 44P

See similar textbooks

Similar questions

Management of a home appliance store wants to understand the growth pattern of the monthly sales of a new technology device over the past two years. The managers have recorded the relevant data in the file P13_05.xlsx. Have the sales of this device been growing linearly over the past 24 months? By examining the results of a linear trend line, explain why or why not.
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?
Do the sales prices of houses in a given community vary systematically with their sizes (as measured in square feet)? Answer this question by estimating a simple regression equation where the sales price of the house is the dependent variable, and the size of the house is the explanatory variable. Use the sample data given in P13_06.xlsx. Interpret your estimated equation, the associated R-square value, and the associated standard error of estimate.
The management of a technology company is trying to determine the variable that best explains the variation of employee salaries using a sample of 52 full-time employees; see the file P13_08.xlsx. Estimate simple linear regression equations to identify which of the following has the strongest linear relationship with annual salary: the employees gender, age, number of years of relevant work experience prior to employment at the company, number of years of employment at the company, or number of years of post secondary education. Provide support for your conclusion.
The file P13_02.xlsx contains five years of monthly data on sales (number of units sold) for a particular company. The company suspects that except for random noise, its sales are growing by a constant percentage each month and will continue to do so for at least the near future. a. Explain briefly whether the plot of the series visually supports the companys suspicion. b. By what percentage are sales increasing each month? c. What is the MAPE for the forecast model in part b? In words, what does it measure? Considering its magnitude, does the model seem to be doing a good job? d. In words, how does the model make forecasts for future months? Specifically, given the forecast value for the last month in the data set, what simple arithmetic could you use to obtain forecasts for the next few months?
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?
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.
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.
Dilberts Department Store is trying to determine how many Hanson T-shirts to order. Currently the shirts are sold for 21, but at later dates the shirts will be offered at a 10% discount, then a 20% discount, then a 40% discount, then a 50% discount, and finally a 60% discount. Demand at the full price of 21 is believed to be normally distributed with mean 1800 and standard deviation 360. Demand at various discounts is assumed to be a multiple of full-price demand. These multiples, for discounts of 10%, 20%, 40%, 50%, and 60% are, respectively, 0.4, 0.7, 1.1, 2, and 50. For example, if full-price demand is 2500, then at a 10% discount customers would be willing to buy 1000 T-shirts. The unit cost of purchasing T-shirts depends on the number of T-shirts ordered, as shown in the file P10_36.xlsx. Use simulation to determine how many T-shirts the company should order. Model the problem so that the company first orders some quantity of T-shirts, then discounts deeper and deeper, as necessary, to sell all of the shirts.
The owner of a restaurant in Bloomington, Indiana, has recorded sales data for the past 19 years. He has also recorded data on potentially relevant variables. The data are listed in the file P13_17.xlsx. a. Estimate a simple regression equation involving annual sales (the dependent variable) and the size of the population residing within 10 miles of the restaurant (the explanatory variable). Interpret R-square for this regression. b. Add another explanatory variableannual advertising expendituresto the regression equation in part a. Estimate and interpret this expanded equation. How does the R-square value for this multiple regression equation compare to that of the simple regression equation estimated in part a? Explain any difference between the two R-square values. How can you use the adjusted R-squares for a comparison of the two equations? c. Add one more explanatory variable to the multiple regression equation estimated in part b. In particular, estimate and interpret the coefficients of a multiple regression equation that includes the previous years advertising expenditure. How does the inclusion of this third explanatory variable affect the R-square, compared to the corresponding values for the equation of part b? Explain any changes in this value. What does the adjusted R-square for the new equation tell you?
An antique collector believes that the price received for a particular item increases with its age and with the number of bidders. The file P13_14.xlsx contains data on these three variables for 32 recently auctioned comparable items. Estimate a multiple regression equation using the given data. Interpret each of the estimated regression coefficients. Is the antique collector correct in believing that the price received for the item increases with its age and with the number of bidders? Interpret the standard error of estimate and the R-square value for these data.
A trucking company wants to predict the yearly maintenance expense (Y) for a truck using the number of miles driven during the year (X1) and the age of the truck (X2, in years) at the beginning of the year. The company has gathered the data given in the file P13_13.xlsx. Note that each observation corresponds to a particular truck. Estimate a multiple regression equation using the given data. Interpret each of the estimated regression coefficients. Also, interpret the standard error of estimate and the R-square value for these data.

SEE MORE QUESTIONS

Recommended textbooks for you

Practical Management Science

Operations Management

ISBN:

9781337406659

Author:

WINSTON, Wayne L.

Publisher:

Cengage,

Practical Management Science

Operations Management

ISBN:

9781337406659

Author:

WINSTON, Wayne L.

Publisher:

Cengage,

SEE MORE TEXTBOOKS