Textbook on spreadsheet applications for business

Assignment Help Financial Accounting

Reference no: EM131288635

Eastman Publishing Company is considering publishing an electronic textbook on spreadsheet applications for business. The fixed cost of manucript 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 access to the book for $46 each.

a. Build a spreadsheet model to calculate the profit/loss for a given demand. What profit can be anticipated with a demand of 3500 copies?

b. Use a data table to vary demand from 1000 to 6000 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 a demand of 3500 copies.

Reference no: EM131288635

Questions Cloud

Prepare journal entries to recognize bad debts : At the beginning of 2016, Miyazaki Company’s Accounts Receivable balance was $105,000, and the balance in Allowance for Doubtful Accounts was $1,950. Miyazaki’s sales in 2016 were $787,500, 80% of which were on credit. Prepare journal entries to reco..

Define stress relaxation of bolts : Define nut dilation. Why can it be a problem? Compute the approximate thermal expansion of a 1=2-13 2, SAE J429 GR 8 bolt when it is subjected to a temperature rise of 1508F (e.g., from 708F to 2208F) ? Define stress relaxation of bolts. Under wh..

How many units will this firm produce and how can you tell : How many units will this firm produce? How can you tell? What price will this firm charge? How can you tell? What is the maximum amount of profit this firm will earn? How can you tell?

Sources of information need to be provided : Submit a copy of your written project report (not more than 1500 words) and oral presentation materials (in soft and hard copy) to the lecturer before the presentation. References: A Reference List is to be supplied as appendix. Details of all sou..

Textbook on spreadsheet applications for business : Eastman Publishing Company is considering publishing an electronic textbook on spreadsheet applications for business. The fixed cost of manucript preparation, textbook design, and Web site construction is estimated to be $160,000. Build a spreadsheet..

What is the ultimate strength and yield strength of metric : What is the ultimate strength and the yield strength (in MPa) of metric Class 4.6 bolt? Does an increase in hardness increase or decrease the tensile strength of a steel bolting material?

What is gain or loss on the shares of stock he sold : On June 1 of the current year, Ben Rork sold 500 shares of Kul Corporation stock. Rork had received this stock on May 1 of the same year as a bequest from the estate of his uncle, who died on March 1 of the current year. His uncle's basis in the stoc..

Name at least three sources of bolting standards : Which of the three is most commonly used to specify bolt size (diameter) for a given application?

Discount on bonds payable has balance : Bonds Payable has a balance of 1,000,000 and discount on bonds payable has a balance of 30,000 if the issue corporation redeems the bonds at 990,000 what is the amount of gain.

User Account

All Pages