subject
Business, 24.12.2019 01:31 eborkins

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 $170,000. variable processing costs are estimated to be $6 per book. the publisher plans to sell single-user access to the book for $52.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,600 copies? 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,200 to 3,400 copies.(ii) breakeven appears in the interval of 3,600 to 3,800 copies.(iii) breakeven appears in the interval of 3,800 to 4,000 copies.(iv) breakeven appears in the interval of 4,000 to 4,200 copies. c. use goal seek to answer the following question. with a demand of 3,600 copies, what is the access price per copy that the publisher must charge to break even?

ansver
Answers: 2

Another question on Business

question
Business, 22.06.2019 07:30
When the national economy goes from bad to better, market research shows changes in the sales at various types of restaurants. projected 2011 sales at quick-service restaurants are $164.8 billion, which was 3% better than in 2010. projected 2011 sales at full-service restaurants are $184.2 billion, which was 1.2% better than in 2010. how will the dollar growth in quick-service restaurants sales compared to the dollar growth for full-service places?
Answers: 2
question
Business, 22.06.2019 11:10
Sam and diane are completing their federal income taxes for the year and have identified the amounts listed here. how much can they rightfully deduct? • agi: $80,000 • medical and dental expenses: $9,000 • state income taxes: $3,500 • mortgage interest: $9,500 • charitable contributions: $1,000.
Answers: 1
question
Business, 22.06.2019 11:10
Suppose that the firm cherryblossom has an orchard they are willing to sell today. the net annual returns to the orchard are expected to be $50,000 per year for the next 20 years. at the end of 20 years, it is expected the land will sell for $30,000. calculate the market value of the orchard if the market rate of return on comparable investments is 16%.
Answers: 1
question
Business, 22.06.2019 11:30
(select all that apply) examples of email use that could be considered unethical include denying receiving an e-mail requesting that you work late forwarding a chain letter asking for donations to a good cause sending a quick message to your friend about last weekend sending your boss the monthly sales figures in an attachment setting up a meeting with your co-worker sharing a funny joke with other employees
Answers: 2
You know the right answer?
Eastman publishing company is considering publishing an electronic textbook about spreadsheet applic...
Questions
question
Mathematics, 03.12.2021 01:00
question
Computers and Technology, 03.12.2021 01:00
question
Mathematics, 03.12.2021 01:00
question
Mathematics, 03.12.2021 01:00
Questions on the website: 13722363