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
-
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...
-
On January 1, 2010, Plywood Homes, Inc. issued 20-year, 4 percent bonds having a face value of $1 million. The interest on the bonds is payable semiannually on June 30 and December 31. The proceeds...
-
Below is a password data manager C code program : #include #include #define MAX_USERS 100 struct user { char username[20]; char password[20]; char codeword[20]; }; int num_users = 0; struct user...
-
Apex Accounting, Inc., has cash of \($2,000\), supplies costing \($800\), and stockholders equity of \($1,300\). Determine the liabilities of the business. Write the accounting equation for Apex...
-
A scale is constructed using the 10-kg mass, the 2-kg pan P, and the pulley and cord arrangement. Cord BCA is 2 m long. If s = 0.75 m, determine the mass D in the pan. Neglect the size of thepulley....
-
Plantation Green Limited is a major producer of processed coffee. On the 17 July 2018, it agreed to sell 200 kilograms of coffee to Grey-Drinks Restaurant. Both parties are located in X country in...
-
Alan and Angel Young are both 36 years old. Mr. Young recently accepted a new job making $93,000 a year and Mrs. Young is currently unemployed. The Youngs have two children (ages 4 and 2), a dog, and...
-
How can the process of strategic planning be defined, and in what ways does its effective implementation offer organizations a distinct competitive edge in the contemporary business landscape?"
-
Consider a dataset composed of 4 small shirts, 10 medium shirts, and 6 large shirts. If the dataset is represented by a bar chart, what is the height of the bar representing the small shirts?
-
Constant heat flux of 25 W/m passes through a wooden blade having a thickness of 10 cm. The temperature at the two ends of the wooden blade is 10 C and 35 C respectively. Considering a steady state...
-
Two highways diverge at 54. If two bike riders take separate routes at 15 km/h and 17 km/h, find how far apart they are after 2 hours.
-
An IPv4 packet has the following header: 0x4500 04ce 123a 4000 0401 554b 4350 1b20 7801 530f. (a) Write the source address in dot decimal format. (b) Write the destination address in dot decimal...
-
The Righter Shoe Store Company prepares monthly financial statements for its bank. The November 3 0 and December 3 1 , 2 0 2 4 , trial balances contained the following account information: November...
-
MOLLY JONES HAS AN ADJUSTED GROSS INCOME OF $56,360. SHE FILES AS HEAD OF HOUSEHOLD WITH 2 EXEMPTIONS. FIND THE TAXABLE INCOME. (4 POINTS) JOSE SANTOS HAS AN ADJUSTED GROSS INCOME OF $96,541. HE...
-
A firm offers two products for sale. The marginal cost of one product is new zero once the first unit has been produced. The marginal cost of the other product rises as output rises. What would be...
-
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.
-
The armature of a variable-speed electric motor, of mass \(200 \mathrm{~kg}\), has an unbalance due to manufacturing errors. The motor is mounted on an isolator having a stiffness of \(10 \mathrm{kN}...
-
It is found that an exhaust fan, of mass \(80 \mathrm{~kg}\) and operating speed \(1000 \mathrm{rpm}\), produces a repeating force of \(10,000 \mathrm{~N}\) on its rigid base. If the maximum force...
-
A dishwashing machine weighing \(75 \mathrm{~kg}\) operates at \(300 \mathrm{rpm}\). Find the minimum static deflection of an isolator that provides 60 percent isolation. Assume that the damping in...
Study smarter with the SolutionInn App