Eastman Publishing Company is considering publishing an electronic textbook about spreadsheet applications for business. The fixed...
Fantastic news! We've Found the answer you've been seeking!
Question:
Transcribed Image Text:
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 $170,000. Variable processing costs are estimated to be $5 per book. The publisher plans to sell single-user access to the book for $45. (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,700 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,800 to 4,000 copies. (ii) Breakeven appears in the interval of 4,200 to 4,400 copies. (iii) Breakeven appears in the interval of 4,400 to 4,600 copies. (iv) Breakeven appears in the interval of 4,600 to 4,800 copies. Option (ii) (c) Use Goal Seek to determine the access price per copy that the publisher must charge to break even with a demand of 3,700 copies. If required, round your answer to two decimal places. $ (d) Consider the following scenarios: Variable Cost/Book Access Price Demand Scenario 1 $5 $45 2,700 Scenario 2 $7 $50 1,000 Scenario 3 $11 $42 6,000 Scenario 4 $9 $52 5,200 Scenario 5 $10 $65 2,400 For each of these scenarios, the fixed cost remains $170,000. Use Scenario Manager to generate a summary report that gives the profit for each of these scenarios. Which scenario yields the highest profit? Which scenario yields the lowest profit? For subtractive or negative numbers use a minus sign. - Select your answer - yields the highest profit of $ - Select your answer yields the lowest profit of $ 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 $170,000. Variable processing costs are estimated to be $5 per book. The publisher plans to sell single-user access to the book for $45. (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,700 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,800 to 4,000 copies. (ii) Breakeven appears in the interval of 4,200 to 4,400 copies. (iii) Breakeven appears in the interval of 4,400 to 4,600 copies. (iv) Breakeven appears in the interval of 4,600 to 4,800 copies. Option (ii) (c) Use Goal Seek to determine the access price per copy that the publisher must charge to break even with a demand of 3,700 copies. If required, round your answer to two decimal places. $ (d) Consider the following scenarios: Variable Cost/Book Access Price Demand Scenario 1 $5 $45 2,700 Scenario 2 $7 $50 1,000 Scenario 3 $11 $42 6,000 Scenario 4 $9 $52 5,200 Scenario 5 $10 $65 2,400 For each of these scenarios, the fixed cost remains $170,000. Use Scenario Manager to generate a summary report that gives the profit for each of these scenarios. Which scenario yields the highest profit? Which scenario yields the lowest profit? For subtractive or negative numbers use a minus sign. - Select your answer - yields the highest profit of $ - Select your answer yields the lowest profit of $
Expert Answer:
Answer rating: 100% (QA)
To calculate the profitloss for a given demand and determine the profit anticipated with a demand of 3700 copies we can use the following spreadsheet model 1 Create an Excel spreadsheet with the follo... View the full answer
Related Book For
Accounting Principles
ISBN: 978-0470533475
9th Edition
Authors: Jerry J. Weygandt, Paul D. Kimmel, Donald E. Kieso
Posted Date:
Students also viewed these accounting questions
-
1. Many managers assume that if an employee is not performing well, the reason must be a lack of motivation. Do you think this reasoning is accurate? What is the problem with the assumption? 2....
-
Mark noticed that the probability that a certain player hits a home run in a single game is 0.175. Mark is interested in the variability of the number of home runs if this player plays 200 games. If...
-
Planning is one of the most important management functions in any business. A front office managers first step in planning should involve determine the departments goals. Planning also includes...
-
What is the relationship between the frequency of data points and the data retention period in CloudWatch? Choose the correct option - Inversely Proportional - Directly proportional - Depends on the...
-
Sketch potential-energy/reaction-coordinate diagrams for the two propagation steps of the mono-bromination of methane (Problem 22).
-
In Excel, give a business example in which an IF function would be useful. How would using the AND or OR functions in the logical_test argument change the way the IF function works?
-
Use the August information from the Work Together above. An income statement for Cheries Pizza is included in the Working Papers. Work independently to complete this problem. 1. Calculate the...
-
An Iowa state savings bond can be converted to $100 at maturity 6 years from purchase. If the state bonds are to be competitive with U.S. savings bonds, which pay 8% annual interest (compounded...
-
The Ski department reports sales of $600,000 and cost of goods sold of $420,000. Its expenses follow. Direct expenses Indirect expenses Service department expenses Salaries Depreciation $ 117,000...
-
For the base case in this section, as a percentage of sales, COGS = 70 percent, SGA = 14 percent, R&D = 2.8 percent. Depreciation, Interest expense are fixed as stated. Tax Rate is 21 percent. 1.a...
-
An open aluminum pop can with a small amount of water inside is placed on a stove and heated, until the water starts to boil. When you pick up the can with a tong, place it in ice-cold water upside...
-
Which of the following should organizations do when selecting a standard? (Select three.) A. Select a standard that can be followed. B. Employ the selected standard. C. Select a flexible standard. D....
-
Which of the following provides a framework for assessing the adequacy of implemented controls? A. NIST 800-53 B. NIST 800 C. NIST \(800-53 \mathrm{~A}\) D. NIST 800A
-
Which of the following does COBIT stand for? A. Control Objectives Beyond Information Technology B. Control Objectives for Information and Related Technology C. Compliance Organized By Information...
-
Write a brief memo describing the sales pattern that you would expect Kandy to experience during the year. In which months will sales likely be high? In which months will sales likely be low? Explain...
-
If the pinch point occurs at the feed point, mass balances can be used to find the minimum flows. Derive these equations. A pinch point at the feed can occur but is unusual in multicomponent...
-
How do additional distinguishing attributes contribute to the intricacies of Organizational Behavior (OB)?
-
Design a circuit which negative the content of any register and store it in the same register.
-
At the end of 2010, Delong Co. has accounts receivable of $700,000 and an allowance for doubtful accounts of $54,000. On January 24, 2011, the company learns that its receivable from Ristau Inc. is...
-
What is the formula for determining required merchandise purchases for a merchandiser?
-
For Briggs Company actual sales are $1,200,000 and break-even sales are $900,000. Compute (a) The margin of safety in dollars and (b) The margin of safety ratio.
-
At a price greater than the equilibrium price, a(n) _________, or excess quantity supplied, would exist. Sellers would be willing to sell _________ than demanders would be willing to buy. Frustrated...
-
If the price of zucchini increases, causing the demand for yellow squash to rise, what do we call the relationship between zucchini and yellow squash?
-
The price elasticity of demand is defined as the percentage change in _________ divided by the percentage change in _________.
Study smarter with the SolutionInn App