MN.52. Eastman Publishing Company is considering publishing an electronic textbook about spreadsheet applications for business. The fixed cost of manuscript preparation, textbook design, and web siteconstruction is estimated to be $156,000. Variable processing costs are estimated to be $9 per book. The publisher plans to sell single-user access to the book for $41.Through a series of web-based experiments, Eastman has created a predictive model that estimates demand as a function of price. The predictive model is demand 4,000 -6p, where p is the priceof the e-book.(a) Construct an appropriate spreadsheet model for calculating the profit/loss at a given single-user access price taking into account the above demand function. What is the profit estimated by yourmodel for the given costs and single user access price (in dollars).(b) Use Goal Seek to calculate the price (in dollars) that results in breakeven. (Round your answer to the nearest cent.)(c) Use a data table that varies price from $50 to $400 in increments of $25 to find the price (in dollars) that maximizes profit.

Total cost is Fixed cost + Total variable cost To find the profit or loss we need to check the total…

(a) Construct an appropriate spreadsheet model for calculating the profit/loss at a given single-user access price taking into account the above demand function. What is the profit estimated by your model for the given costs and single user access price (in dollars). (b) Use Goal Seek to calculate the price (in dollars) that results in breakeven. (Round your answer to the nearest cent.) (c) Use a data table that varies price from $50 to $400 in increments of $25 to find the price (in dollars) that maximizes profit.

(a) Construct an appropriate spreadsheet model for calculating the profit/loss at a given single-user access price taking into account the above demand function. What is the profit estimated by your model for the given costs and single user access price (in dollars). (b) Use Goal Seek to calculate the price (in dollars) that results in breakeven. (Round your answer to the nearest cent.) (c) Use a data table that varies price from $50 to $400 in increments of $25 to find the price (in dollars) that maximizes profit.

Managerial Economics: Applications, Strategies and Tactics (MindTap Course List)

14th Edition

ISBN:9781305506381

Author:James R. McGuigan, R. Charles Moyer, Frederick H.deB. Harris

Publisher:James R. McGuigan, R. Charles Moyer, Frederick H.deB. Harris

Chapter4: Estimating Demand

Section: Chapter Questions

Problem 2E

See similar textbooks

Similar questions

Eastman Publishing Company is considering publishing an electronic textbook about spreadsheet applications for business. The fixed cost of manuscript preparation, textbook design, and web site construction is estimated to be $172,000. Variable processing costs are estimated to be $5 per book. The publisher plans to sell single-user access to the book for $42. Through a series of web-based experiments, Eastman has created a predictive model that estimates demand as a function of price. The predictive model is demand = 4,000 − 6p, where p is the price of the e-book. (a) Construct an appropriate spreadsheet model for calculating the profit/loss at a given single-user access price taking into account the above demand function. What is the profit estimated by your model for the given costs and single user access price (in dollars). $ (b) Use Goal Seek to calculate the price (in dollars) that results in breakeven. (Round your answer to the nearest cent.) $ (c) Use a data table that varies…
Ted Cordaro is an analytics consultant who has been brought into a large distribution company to perform data mining tasks on some of the data from their data warehouse. Ted has been specifically tasked with assisting the Human Resources, Sales and Marketing departments with building predictive models. Two datasets have been provided to Ted for analysis. The first dataset includes past and present employee information and the HR department would like Ted to build a predictive model to predict employee retention. The second dataset includes marketing campaign information and the Marketing department would like Ted to build a predictive model to predict monthly sales. Finally, the Sales department would like Ted to use the second dataset, using past sales data to predict future sales. Use the information provided to answer the questions that follow. The Human Resources department has their own departmental Data Warehouse, created from the main Enterprise Data Warehouse, that stores…
An independent variable in a model is also called:a. explained variable.b. unexplained variable.c. explanatory variable.d. dependent variable.
Suppose that an economist has been able to gather data on the relationship between demand and price for a particular product. After analyzing scatterplots and using economic theory, the economist decides to estimate an equation of the form Q= aPb, where Q is quantity demanded and P is price. An appropriate regression analysis is then performed, and the estimated parameters turn out to be a = 1000 and b = - 1.3. Now consider two scenarios: (1) the price increases from $10 to $12.50; (2) the price increases from $20 to $25. a. Do you predict the percentage decrease in demand to be the same in scenario 1 as in scenario 2? Why or why not? b. What is the predicted percentage decrease in demand in scenario 1? What about scenario 2? Be as exact as possible.
A local college is deciding whether to conduct a campus beautification initiative that would involve various projects, such as planting trees and remodeling buildings, to make the campus more aesthetically pleasing. For the students of the college, the visual appearance of the campus is and . Thus, the visual appearance would be classified as a public good. Suppose the college administrators estimate that the beautification initiative will cost $66,120. To decide whether the initiative should be undertaken, administrators conduct a survey of the college's 1,820 students, asking each of them their willingness to pay for the beautification project. The average willingness to pay, as revealed by the survey, is $28. The benefit of the beautification initiative, as suggested by the survey, is . Because the estimated benefit is than the cost, the college administrators undertake the beautification initiative. The calculation of the benefit of the beautification…
The Pilot Pen Company has decided to use 15 test markets to examine the sensitivity of demand for its new product to various prices, as shown in the following table. Advertising effort was identical in each market. Each market had approximately the same level of business activity and population. Complete the following worksheet and then estimate the demand function for Pilot's new pen using a linear regression model. Test Market Price Charged Quantity Sold (cents) (Thousands of Pens) ii xixi yiyi xixiyiyi xi2xi2 yi2yi2 1 50 20 1,000 2,500 400 2 50 21 1,050 2,500 441 3 55 19 1,045 3,025 361 4 55 19.5 1,072.5 3,025 380.25 5 60 20.5 1,230 3,600 420.25 6 60 19 1,140 3,600 361 7 65 15.5 1,007.5 4,225 240.25 8 65 15 975 4,225 225 9 70 14.5 1,015 4,900 210.25 10 70 15.5 1,085 4,900 240.25 11 80 13 1,040 6,400 169 12 80 14 1,120 6,400 196 13 90 11.5 1,035 8,100 132.25 14 90 11 990 8,100 121 15 40 17 680 1,600 289 Total 980 246 ?…
A local college is deciding whether to conduct a campus beautification initiative that would involve various projects, such as planting trees and remodeling buildings, to make the campus more aesthetically pleasing. For the students of the college, the visual appearance of the campus is and . Thus, the visual appearance would be classified as a public good. Suppose the college administrators estimate that the beautification initiative will cost $3,900. To decide whether the initiative should be undertaken, administrators conduct a survey of the college's 370 students, asking each of them their willingness to pay for the beautification project. The average willingness to pay, as revealed by the survey, is $13. The benefit of the beautification initiative, as suggested by the survey, is . Because the estimated benefit is than the cost, the college administrators undertake the beautification initiative. The calculation of the benefit of the beautification…
True or False? WLS is preferred to OLS when an important variable has been omitted from the model.
Q. Wilpen Company, a price-setting firm, produces nearly 80 percent of all tennis balls purchased in the United States. Wilpen estimates the U.S. demand for its tennis balls by using the following linear specification: Q = a + bP + cM + dPR. Where Q is the number of cans of tennis balls sold quarterly, P is the wholesale price Wilpen charges for a can of tennis balls, M is the consumers’ average household income, and PR is the average price of tennis rackets. The regression results are as follows: a- Discuss the statistical significance of the parameter estimates a^, b^, c^, and d^ using the p-values. Are the signs of b^, c^, and d^ consistent with the theory of demand? Wilpen plans to charge a wholesale price of $1.65 per can. The average price of a tennis racket is $110, and consumers’ average household income is $24,600. b. What is the estimated number of cans of tennis balls demanded? c) At the values of P, M, and Pr given, what are the estimated values of the price (E^), income…
Q. Wilpen Company, a price-setting firm, produces nearly 80 percent of all tennis balls purchased in the United States. Wilpen estimates the U.S. demand for its tennis balls by using the following linear specification: Q = a + bP + cM + dPR. Where Q is the number of cans of tennis balls sold quarterly, P is the wholesale price Wilpen charges for a can of tennis balls, M is the consumers’ average household income, and PR is the average price of tennis rackets. The regression results are as follows: a. Discuss the statistical significance of the parameter estimates a^, b^, c^, and d^ using the p-values. Are the signs of b^, c^, and d^ consistent with the theory of demand? Wilpen plans to charge a wholesale price of $1.65 per can. The average price of a tennis racket is $110, and consumers’ average household income is $24,600. b. What is the estimated number of cans of tennis balls demanded? c) At the values of P, M, and Pr given, what are the estimated values of the price (E^), income…
TRUE OR FALSE. A model with heterosdasticity problem most likely has insignificant parameter estimates.
The following ACF plots were produced for raw data of monthly sales of two different variables, A and B. a) Explain which variable is likely to be easier to forecast. b) Explain how your answer to part a) would change if these were residuals of an ARIMA model instead of “raw data of monthly sales”.