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 $153,000. Variable processing costs are estimated to be $7 per book. The publisher plans to sell single-user access to the book for $45. 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). $ -11260 (b) Use Goal Seek to calculate the price (in dollars) that results in breakeven. (Round your answer to the nearest cent.) $ 48.23 (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. $ 498,900 x Need Help? Read It

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 $153,000. Variable processing costs are estimated to be $7 per book. The publisher plans to sell single-user access to the book for $45. 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). $ -11260 (b) Use Goal Seek to calculate the price (in dollars) that results in breakeven. (Round your answer to the nearest cent.) $ 48.23 (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. $ 498,900 x Need Help? Read It

Essentials of Business Analytics (MindTap Course List)

2nd Edition

ISBN:9781305627734

Author:Jeffrey D. Camm, James J. Cochran, Michael J. Fry, Jeffrey W. Ohlmann, David R. Anderson

Publisher:Jeffrey D. Camm, James J. Cochran, Michael J. Fry, Jeffrey W. Ohlmann, David R. Anderson

Chapter15: Decision Analysis

Section: Chapter Questions

Problem 5P: Hudson Corporation is considering three options for managing its data warehouse: continuing with its...

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 $171,000. Variable processing costs are estimated to be $8 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 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
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 $156,000. Variable processing costs are estimated to be $9 per book. The publisher plans to sell single-user access to the book for $44. 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 price…
Eastman Publishing Company is considering publishing an electronic textbook about spreadsheet applications for business. The fixed cost of manuscript preparation, textbook design, and website construction is estimated to be $160,000. Variable processing costs are estimated to be $6.00 per book. The publisher plans to sell single-user access to the book for $46. a. Build a spreadsheet model to calculate the profit/loss for a given demand. For example, what profit can be anticipated with a demand of 3500 copies? b. Use a data table to very demand from 1000 to 6000 in increments of 200 to assess the sensitivity of profit to demand. c. Use Goal Seek to determine the access price per copy that the publisher must charge to break even with the demand of 3500 copies. Before you move on to Problem 2, make sure you save your workbook with this value displayed or else you will not receive credit.
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 $175,000. Variable processing costs are estimated to be $8 per book. The publisher plans to sell single-user access to the book for $54. (a) Build a spreadsheet model in Excel to calculate the profit/loss for a given demand. What profit can be anticipated with a demand of 3,300 copies? For subtractive or negative numbers use a minus sign. -23,200 (b) Use a data table to vary demand from 1,000 to 6,000 in increments of 200 to test the sensitivity of profit to demand. Breakeven occurs where profit goes from a negative to a positive value, that is, breakeven is where total revenue = total cost yielding a profit of zero. In which interval of demand does breakeven occur? (i) Breakeven appears in the interval of 3,400 to 3,600 copies. (ii) Breakeven appears in the…
Eastman Publishing Company is considering publishing an electronic textbook about spreadsheet applications for business. The fixed cast of manuscript preparation, textbook design, and web-site construction is estimated to be $155,000. Variable processing costs are estimated to be $6 per book. The publisher plans to sell single-user access to the book for $47. (a) Build a spreadsheet model in Excel to calculate the profit/loss for a given demand. What profit can be anticipated with a demand of 3,200 copies? For subtractive or negative numbers use a minus sign. -23800 (b) Use a data table to vary demand from 1,000 to 6,000 in increments of 200 to test the sensitivity of profit to demand. Breakeven occurs where profit goes from a negative to a positive value, that is, breakeven is where total revenue - total cost yielding a profit of zero. In which interval of demand does breakeven occur? (1) Breakeven appears in the interval of 3,200 to 3,400 copies. (1) Breakeven appears in the interval…
Ortega Company manufactures computer hard drives. The market for hard drives is very competitive. The current market price for a computer hard drive is $54. Ortega would like a profit of $14 per drive. What target cost Ortega should set to accomplish this objective? Target cost $ per hard drive
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 $162,000. Variable processing costs are estimated to be $6.89 per book. Use Goal Seek to determine the access price per copy (in dollars) that the publisher must charge to earn a profit of $100,000 with a demand of 31,000 copies.
Suppose that you have been given a summer job as an Intern at Issac Alrcams, a company that manufactures sophisticated spy cameras for remote-controlled millitary reconnalssance alrcraft. The company, which is privately owned, has approached a bank for a loan to help finance its growth. The bank requires financlal statements before approving the loan. Requlred: Classify each cost listed below as elther a product cost or a perlod cost for the purpose of preparing financial statements for the bank. Costs Product Cost or Period Cost 1. Depreciation on salespersons' cars. 2. Rent on equipment used in the factory. 3. Lubricants used for machine maintenance. 4. Salaries of personnel who work in the finished goods warehouse. 5. Soap and paper towels used by factory workers at the end of a shift. 6. Factory supervisors' salaries. 7. Heat, water, and power consumed in the factory. 8. Materials used for boxing products for shipment overseas. (Units are not normally boxed.) 9. Advertising costs.…
A property title search firm is contemplating using online software to increase its search productivity. Currently an average of 40 minutes is needed to do a title search. The researcher cost is $2 per minute. Clients are charged a fee of $400. Company A's software would reduce the average search time by 10 minutes, at a cost of $3.50 per search. Company B's software would reduce the average search time by 12 minutes at a cost of $3.60 per search. a. Calculate the productivity in terms of revenue per dollar of input. (Round your intermediate calculations and final answers to 2 decimal places. Omit the "$" sign in your response.) Productivity (Revenue per Dollar Input) $ Approach Current Company A Company B $ b. Which option would have the highest productivity in terms of revenue per dollar of input? Company A Company B Current
Hudson Corporation is considering three options for managing its data warehouse: continuing with its own staff, hiring an outside vendor to do the managing, or using a combination of its own staff and an outside vendor. The cost of the operation depends on future demand. The annual cost of each option (in thousands of dollars) depends on demand as follows: If the demand probabilities are 0.2, 0.5, and 0.3, which decision alternative will minimize the expected cost of the data warehouse? What is the expected annual cost associated with that recommendation? Construct a risk profile for the optimal decision in part (a). What is the probability of the cost exceeding $700,000?
Premo Pens, Inc., is in the process of developing a newpen to replace its existing top-of-the-line Executive Model.Market research has identified the critical features the pen must have, and it is estimated that customers would be will-ing to pay $30 for a pen with these features. Premo’s produc-tion manager estimates that with existing equipment it will cost $26 to produce the proposed model. The current Execu-tive Model sells for $24 and has a total production cost of $20. A competitor sells a pen similar to the proposed model,but without Premo’s patented easy retract feature, for $28. Itis estimated to cost the competitor $25 to produce. If Premoseeks to earn a 20 percent return on sales on the new model,which of the following represents the target cost for the newpen?a. $26.00.b. $22.40.c. $24.00.d. $19.80.
Hint(s) Check My Work (All answers were generated using 1,000 trials and native Excel functionality.) The management of Madeira Computing is considering the introduction of a wearable electronic device with the functionality of a laptop computer and phone. The fixed cost to launch this new product is $300,000. The variable cost for the product is expected to be between $192 and $288, with a most likely value of $240 per unit. The product will sell for $360 per unit. Demand for the product is expected to range from 0 to approximately 20,000 units, with 4,000 units the most likely. (a) Develop a what if spreadsheet model computing profit for this product in the base case, worst case, and best case scenarios If your answer is negative, use minus sign Best-case profit Worst case profit Base-case profit S (b) Model the variable cost as a uniform random vanable with a minimum of $192 and a maximum of $288. Model the product demand as 1,000 times the value of a gamma random variable with an…