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 $150,000. Variable processing costs are estimated to be $4 per book. The publisher plans to sell single-user access to the book for $43. 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 demand = 4,000 - 6p, where p is the price of the e-book. (a) Construct an appropriate spreadsheet model for calculating the profit/loss at a given single-user access price taking into account the above demand function. What is the profit estimated by your model for the given costs and single user access price (in dollars). $ (b) Use Goal Seek to calculate the price (in dollars) that results in breakeven. (Round your answer to the nearest cent.) (c) Use a data table that varies price from $50 to $400 in increments of $25 to find the price (in dollars) that maximizes profit. $ Need Help? Read It

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 $150,000. Variable processing costs are estimated to be $4 per book. The publisher plans to sell single-user access to the book for $43. 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 demand = 4,000 - 6p, where p is the price of the e-book. (a) Construct an appropriate spreadsheet model for calculating the profit/loss at a given single-user access price taking into account the above demand function. What is the profit estimated by your model for the given costs and single user access price (in dollars). $ (b) Use Goal Seek to calculate the price (in dollars) that results in breakeven. (Round your answer to the nearest cent.) (c) Use a data table that varies price from $50 to $400 in increments of $25 to find the price (in dollars) that maximizes profit. $ Need Help? Read It

Practical Management Science

6th Edition

ISBN:9781337406659

Author:WINSTON, Wayne L.

Publisher:WINSTON, Wayne L.

Chapter2: Introduction To Spreadsheet Modeling

Section: Chapter Questions

Problem 20P: Julie James is opening a lemonade stand. She believes the fixed cost per week of running the stand...

See similar textbooks

Similar questions

_______ Computers are the main tool used in the development of products.
Urgent Please answer a soon as possible. Answer must be plagirism free Should Accountants be involved in systems documentation? Explain why.
Do it accurate solve. Pdf links need will download for all. Pdf link provide me. Instructions: From the references/journals given, sort the data from these based on the following: Abstract Introduction Objectives of the journals The author’s main challenges in achieving these objectives Methodology Results and Discussion Conclusion No specific layout needed. As long as the contents are complete . References: (Main article) Ultrasound effect on the aromatic nucleophilic substitution reactions on some haloarenes https://www.sciencedirect.com/science/article/abs/pii/S1350417702001578 (Supporting articles) Competitive nucleophilic aromatic substitution and haloarene reduction in the synthesis of bimetallic .pi.-arene complexes: the structural characterization of [Et4N][(.eta.6-[(CO)5W]C6H5)Cr(CO)3] https://pubs.acs.org/doi/pdf/10.1021/om00107a012 Please add 2 more supporting articles.
Label the following letter elements as specialized or standardized. 1. Sender's Address. 2. Dateline 3. Reference number. 4. Inside address 5. Mailing classification. 6. Attention line. 7. Salutation. 8. Subject line. 9. Body of the letter. 10. Complimentary close 11. Signature box 12. Enclosure notation. 13. Distribution notation. 13. Post script.
On most large construction projects, requests for payment are submitted _____________. Monthly Weekly Midway through the project and at the end of the project Prior to beginning construction, midway through the project, and at the end of the project At the end of the project
The reciprocal allocation method: a. is the most widely used because of its simplicity b. requires the ranking of support departments in the order that the allocation is to proceed c. is conceptually the most precise d. results in allocating more support costs to operating departments than actually incurred
Paragraph Styles Editing If the annual demand is reduced to 9,000 units, the set-up costs increased to $110, inventory carrying cost increased to $0.60 per unit per year and the demand during the production period is maintained at 60 units per day and 80 units can be manufactured daily, calculate: A) ) The optimum production quantity (Q*) per production run (or per production lot). B) The length of each production run. C) The number of production runs per year. ictions: On acer % &
you must compose a 1-2 sentence statement which connects all 3 terms in such a way that a TRUE statement is expressed. GROUP 51. PORTAL-to-PORTAL ACT 2. COMPENSABLE WORK 3. PRINCIPAL ACTIVITIES Group 6 GROUP 61. EXEMPT EMPLOYEE2. DUTIES TEST3. HIGHLY COMPENSATED EMPLOYEE
Which 3 options for customizing invoices can you access via the Custom Form Styles > Invoice template?(Select all that apply) A. Change invoice terms B. Change invoice color schemes C. Change invoice fonts D. Add a logo E. Print on letterhead
Which of the following sentences has the same meaning as the following: ‘The revenue earned by XYZ Corporation fluctuated throughout the last year?' * A.The revenue earned by XYZ Corporation remained unsteady throughout the last year. B.The revenue earned by XYZ Corporation remained stable throughout the last year. C.The revenue earned by XYZ Corporation throughout the last year was unsatisfactory.
Specific Task Performed WEEK 1 Problems Encountered Canvassing for a Some prices are not We searched for cheaper purchase updated. another file that was updated in price. Answering phone The voice of the calls from other employee departments is low/weak counting materials, equipment, merchandise, or supplies in stock. Solutions Applied I Assist in stocking The office is not and distributing supplies in different departments. wide, so that we encounter problem to where we can put the large number of supplies ask employee on what she is saying. the supplier. Assist in the There are supplies We checked the I learned the basics of that lack of numbers. past request of activities related and to form receiving logbook to confirm the lack of supplies. Learning Outcomes Ma'am Joy- the property specialist, said that we can put the extra supplies in our office. I learned that if you want to get the best price, you cannot simply purchase a single from Summary report: inventory management tasks.…
________ A submittal must be verified for accuracy inaccordance with contract plans and specifications.(True/False)