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.
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,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?
(i) breakeven appears in the interval of 3,600 to 3,800 copies.
(ii) breakeven appears in the interval of 4,000 to 4,200 copies.
(iii) breakeven appears in the interval of 4,200 to 4,400 copies.
(iv) 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: 3
Other questions on the subject: Business
Business, 22.06.2019 19:40, madisynk78
Adistinguishing feature of ecological economics is the concept of cost-benefit analysis steady-state economies that, like natural systems, neither grow nor shrink environmental damage and also environmental benefits are external greenwashing to increase public acceptance of products the only healthy economy is one that is growing
Answers: 1
Business, 22.06.2019 19:50, Amholloway13
The interaction of individual choices because a type of fish is on the verge of extinction, the government imposes rules that prohibit fishing in the publicly owned spawning grounds. at first owners of fshing bouts complain about this restriction on where they can fish, but soon they notice that the number of adult fish swimming outside the protected area is much higher than it was before. with the restriction, each fishing boat ends up catching more fish than it did before the r which of the following principles of economic interaction best describes this scenario? o there is a tradeoff between equality and efficiency o markets usually lead to efficiency. o when markets do not achieve efficiency, government intervention can improve overall welfare o markets allocate goodseffectively
Answers: 1
Business, 22.06.2019 20:20, saurav76
Faldo corp sells on terms that allow customers 45 days to pay for merchandise. its sales last year were $325,000, and its year-end receivables were $60,000. if its dso is less than the 45-day credit period, then customers are paying on time. otherwise, they are paying late. by how much are customers paying early or late? base your answer on this equation: dso - credit period = days early or late, and use a 365-day year when calculating the dso. a positive answer indicates late payments, while a negative answer indicates early payments. a. 21.27b. 22.38c. 23.50d. 24.68e. 25.91b
Answers: 2
Business, 23.06.2019 02:30, hgghukghj1814
When the price of pencils increases from $1.50 to $2.50, there is an increase in quantity demanded of pens from 100 to 150. the cross-price elasticity of demand between pencils and pens is: ?
Answers: 3
Do you know the correct answer?
Eastman publishing company is considering publishing an electronic textbook about spreadsheet applic...
Questions in other subjects:
French, 30.10.2021 01:40
Mathematics, 30.10.2021 01:40
Chemistry, 30.10.2021 01:40
Mathematics, 30.10.2021 01:50
