Business, 10.04.2020 20:13 arwasoliman363

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?

(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: 3

Show answers

Another question on Business

Business, 22.06.2019 05:10

The total value of your portfolio is $10,000: $3,000 of it is invested in stock a and the remainder invested in stock b. stock a has a beta of 0.8; stock b has a beta of 1.2. the risk premium on the market portfolio is 8%; the risk-free rate is 2%. additional information on stocks a and b is provided below. return in each state state probability of state stock a stock b excellent 15% 15% 5% normal 50% 9% 7% poor 35% -15% 10% what are each stock’s expected return and the standard deviation? what are the expected return and the standard deviation of your portfolio? what is the beta of your portfolio? using capm, what is the expected return on the portfolio? given your answer above, would you buy, sell, or hold the portfolio?

Answers: 1

Answer

Business, 22.06.2019 05:50

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

Answer

Business, 22.06.2019 08:30

Which actions can you improve your credit score? (multiple can be selected)having a good credit score should be your prime objective as credit companies analyze your creditworthiness before giving you a loan. there are certain guidelines you can follow to ensure you have a good credit score. always pay your mortgage interest on time. if you are a student, make student loan inquiries before taking any loan. if you have multiple credit cards, manage them judiciously. maintain a healthy balance in your bank account.1. always pay your mortgage interest on time.2. if you are a student, make student loan inquiries before taking any loan.3. if you have multiple credit cards, manage them judiciously.4. maintain a healthy balance in your bank account.

Answers: 1

Answer

Business, 22.06.2019 12:30

Consider a treasury bill with a rate of return of 5% and the following risky securities: security a: e(r) = .15; variance = .0400 security b: e(r) = .10; variance = .0225 security c: e(r) = .12; variance = .1000 security d: e(r) = .13; variance = .0625 the investor must develop a complete portfolio by combining the risk-free asset with one of the securities mentioned above. the security the investor should choose as part of her complete portfolio to achieve the best cal would be a. security a b. security b c. security c d. security d

Answers: 3

Answer

You know the right answer?

Eastman Publishing Company is considering publishing an electronic textbook about spreadsheet applic...

Questions