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

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 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.…
Which of the following is not correct about inside address? a. Inside address is the name and address of the signatory b. Inside address is the name and address of the receiver O c. Inside address is the address that is visible through the panel in a window envelope O d. Inside address and address on the envelope are same
Write a one-page response, double-spaced, 12-point font. Describe the difference between Just-in-time (JIT) and just-in-case (JIC), discussing at least two advantages and two disadvantages of either. Furthermore, apply the concepts of JIT and JIC to a current organization using supporting details from at least two peer-reviewed sources. Include a properly formatted APA reference page.
Economics Explain how technology features such as functions or applications can help create text, format text, check the accuracy of text
750 words Weekly tasks or assignments (Individual or Group Projects) will be due by Monday, and late submissions will be assigned a late penalty in accordance with the late penalty policy found in the syllabus. NOTE: All submission posting times are based on midnight Central Time. Key Assignment First Draft Content from Week 2 should be edited to take into account any instructor feedback Transformational Change Management Plan You will create an entire Transformational Change Management Plan for a medium-sized public company that has lost business to a competitor that has chosen to outsource much of its production operations. The company has been based in a small Midwestern town, it is one of the largest employers, and it has an excellent reputation for employee welfare. It is now planning to do the very same offshoring, which will involve large layoffs of long-term employees. The project deliverables are as follows: Week 2: Introduction Week 2: What is driving the need for this…
Please do not give solution in image format thanku
INSTRUCTIONS TO STUDENTS•This assessment contains one (1) question.•The response should be typed using font style Times New Roman, Arial or Calibri, double spaced, size 12.•Please ensure that the response containsdiscussions on applicable statutes and cases.•Sources must be acknowledged using the OSCOLA Referencing Standard.•This assessment is due on or before March 27, 2024@ 11:00pm.•All Assignmentsshould be uploaded tothe platform once completed.“Equity recognized that the nature of the attorney-client relationship imposed an obligation on the attorney to keep confidential all dealings with and information about the client, derived from the discharge by the attorney of the retainer by the client.”Lord Briggs and Lord HamblenThe Attorney General v The Jamaican Bar Association [2023] UKPC 6With reference to the statement above and recent common law developments, discuss the extent to which the Proceeds of Crime Act impacts the confidential nature of the attorney-client relationship in…
Note:- Do not provide handwritten solution. Maintain accuracy and quality in your answer. Take care of plagiarism. Answer completely. You will get up vote for sure.
Rubrics : ·Addressing all questions above - ·Demonstrating a clear understanding of the course material and ability to relate the course mater ial to the assignment questions – ·Clarity of expression, good use of language – ·Logical planning, structure and sequence in presenting your findings – ·Overall presentation, including correct grammar, spelling and punctuation – Explain the relationship between total revenue and the price elasticity of demand.