Reference no: EM131295572
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 $160,000. Variable processing costs are estimated to be $6 per book. The publisher plans to sell single-user access to the book for $46.
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,500 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,600 to 3,800 copies.
(ii) Breakeven appears in the interval of 4,000 to 4,200 copies.
(iii) Breakeven appears in the interval of 4,200 to 4,400 copies.
(iv) Breakeven appears in the interval of 4,400 to 4,600 copies.
C: Use Goal Seek to answer the following question. With a demand of 3,500 copies, what is the access price per copy that the publisher must charge to break even?
If required, round your answers to two decimal places.
|
Federal controlled substances act
: The Supreme Court ruled that the Commerce Clause allowed for enforcement of the federal Controlled Substances Act in states that had legalized “medical marijuana” in Gonzales v. Raich (2005). How will this play out now that the Obama administration h..
|
|
What was the total cost of the rental for the five days
: A car rental expense is $25.00 per day and $0.25 for each mile driven over 100 miles per day. The renter operated the car as follows: What was the total cost of the rental for the five days?
|
|
The labor rate and efficiency variances
: Dawson Toys, Ltd., produces a toy called the Maze. The company has recently established a standard cost system to help control costs and has established the following standards for the Maze toy: Compute the following variances for July: The materials..
|
|
Which is operated as a sole proprietorship
: On May1, 2012, Iris purchased a truck costing $16,000 and used it for personal activities. On January 1, 2013, the truck has a fair market value of $10,100 and Iris transfers the truck to her business, which is operated as a sole proprietorship. 1. D..
|
|
In which interval of demand does breakeven occur
: Eastman Publishing Company is considering publishing an electronic textbook about spreadsheet applications for business. Breakeven occurs where profit goes from a negative to a positive value, that is, breakeven is where total revenue = total cost yi..
|
|
Project in dynamical system and chaos
: Project in Dynamical system and chaos - Choose a topic that you can explain by these materials - You can NOT copy the examples and proof you need to just take the idea of the examples and proof and then rewrite it by your way.
|
|
Discuss issues many women have in criminal justice
: Discuss issues many women have in Criminal Justice as employees, victims, suspects, and citizens. We will also cover gender equality history, concerns, and struggles as well as explore challenges law enforcement agencies have in recruiting highly ..
|
|
Annotated bibliography at least four academic sources
: A paragraph or two defining and discussing the significance of each specific topic and how it applies to the new employee entering your healthcare organization.
|
|
Create a list of ten activities that might be surveyed
: Create a list of at least 10 activities that might be surveyed by an organization to evaluate the effectiveness of an existing or upgraded virtual collaboration network.
|