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 $160,000. Variable processing costs are estimated to be $6 per book. The publisher plans to sell single-user access to the book for $46. 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 demandA: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,500 copies?
For subtractive or negative numbers use a minus sign.
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?
(a) Breakeven appears in the interval of 3,600 to 3,800 copies.
(b) Breakeven appears in the interval of 4,000 to 4,200 copies.
(c) Breakeven appears in the interval of 4,200 to 4,400 copies.
(d) Breakeven appears in the interval of 4,400 to 4,600 copies.
C: Use Goal Seek to answer the following question. With a demand of 3,500 copies, what is the access price per copy that the publisher must charge to break even?
If required, round your answers to two decimal places.
Answers: 1
Other questions on the subject: Business
Business, 22.06.2019 05:50, marjae188jackson
Acompany that makes shopping carts for supermarkets and other stores recently purchased some new equipment that reduces the labor content of the jobs needed to produce the shopping carts. prior to buying the new equipment, the company used 6 workers, who produced an average of 79 carts per hour. workers receive $16 per hour, and machine coast was $49 per hour. with the new equipment, it was possible to transfer one of the workers to another department, and equipment cost increased by $11 per hour while output increased by four carts per hour. a) compute the multifactor productivity (mfp) (labor plus equipment) under the prior to buying the new equipment. the mfp (carts/$) = (round to 4 decimal places). b) compute the productivity changes between the prior to and after buying the new equipment. the productivity growth = % (round to 2 decimal places)
Answers: 3
Business, 22.06.2019 11:00, samwamooo
Specialization—the division of labor—enhances productivity and efficiency by a) allowing workers to take advantage of existing differences in their abilities and skills. b) avoiding the time loss involved in shifting from one production task to another. c) allowing workers to develop skills by working on one, or a limited number, of tasks. d)all of the means identified in the other answers.
Answers: 2
Business, 22.06.2019 21:10, kalawson2019
You own a nonunion company with 93 nonexempt employees. all of these employ- ees pack books into boxes for shipment to customers throughout the united states. because of wide differences in performance, you have decided to try performance appraisal, something never done before. until now, you have given every worker the same size increase. now you want to measure performance and reward the best performers with bigger increases. without any further information, which of the five types of appraisal formats do you think would be most appropriate? justify your answer. do you anticipate any complaints, or other comments, from employees after you implement your new system?
Answers: 1
Business, 22.06.2019 21:30, schneidersamant9242
Which is cheaper: eating out or dining in? the mean cost of a flank steak, broccoli, and rice bought at the grocery store is $13.04 (money. msn website, november 7, 2012). a sample of 100 neighborhood restaurants showed a mean price of $12.75 and a standard deviation of $2 for a comparable restaurant meal. a. develop appropriate hypotheses for a test to determine whether the sample data support the conclusion that the mean cost of a restaurant meal is less than fixing a comparable meal at home. b. using the sample from the 100 restaurants, what is the p-value? c. at a = .05, what is your conclusion? d. repeat the preceding hypothesis test using the critical value approach
Answers: 3
Do you know the correct answer?
Eastman Publishing Company is considering publishing an electronic textbook about spreadsheet applic...
Questions in other subjects:
Chemistry, 16.12.2020 18:50
English, 16.12.2020 18:50
Mathematics, 16.12.2020 18:50
