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 $156,000. Variable processing costs are estimated to be $9 per book. The publisher plans to sell single-user access to the book for $44. 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.

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 $156,000. Variable processing costs are estimated to be $9 per book. The publisher plans to sell single-user access to the book for $44. 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.

FINANCIAL ACCOUNTING

10th Edition

ISBN:9781259964947

Author:Libby

Publisher:Libby

Chapter1: Financial Statements And Business Decisions

Section: Chapter Questions

Problem 1Q

See similar textbooks

Similar questions

Syntech makes digital cameras for drones. Their basic digital camera uses $80 in variable costs and requires $1,500 per month in fixed costs. Syntech sells 100 cameras per month. If they process the camera further to enhance its functionality, it will require an additional $50 per unit of variable costs, plus an increase in fixed costs of $1,000 per month. The current price of the camera is $170. The marketing manager is positive that they can sell more and charge a higher price for the improved version. At what price level would the upgraded camera begin to improve operational earnings? Price to be charged $ 277.37 X
Vista Company manufactures electronic equipment. It currently purchases the special switches used in each of its products from an outside supplier. The supplier charges Vista $5.50 per switch. Vista's CEO is considering purchasing either machine A or machine B so the company can manufacture its own switches. The projected data are as follows: Annual fixed costs Variable cost per switch Machine A $632,400 1.78 Required: 1. For each machine, what is the minimum number of switches that Vista must make annually for total costs to equal outside purchase cost? 2. What volume level would produce the same total costs regardless of the machine purchased? 3. What is the most profitable alternative for producing 235,000 switches per year and what is the total cost of that alternative? Required 1 Required 2 Required 3 Complete this question by entering your answers in the tabs below. Machine B $ 860,100 0.80 Minimum number of switches For each machine, what is the minimum number of switches that…
Disk City, Inc., is a retailer for digital video disks. The projected net income for the current year is $200,000 based on a sales volume of 200,000 video disks. Disk City has been selling the disks for $16 each. The variable costs consist of the $10 unit purchase price of the disks and a handling cost of $2 per disk. Disk City's annual fixed costs are S600,000. Management is planning for the coming year, when it expects that the unit purchase price of the video disks will increase 30 percent. (Ignore income taxes.) Required: 1. Calculate Disk City's break-even point for the current year in number of video disks.
A particular university was considering whether to offer a seminar for executives. The tuition would be USD 650 per person. Variable costs, including meals, parking, and materials, would be USD 80 per person. Certain costs of offering the seminar, including advertising, instructors' fees, room rent, and audiovisual equipment rent, would not be affected by the number of people attending. Such costs, which could be thought of as fixed costs, amounted to USD 8,000 for the seminar. Given this information, if the school wanted at least to break even on this program? how many students should they expect to attend? 20 15 14 none of these
Premium Corporation believes that there is a market for a portable electronic toothbrush that can be easily carried by business travelers. Premium's market research department has surveyed the features and prices of electronic brushes currently on the market. Based on this research, Premium believes that $75 would be about the right price. At this price, marketing believes that about 78,000 new portable brushes can be sold over the product's life cycle. It will cost about $1,170,000 to design and develop the portable brush. Premium has a target profit of 25% of sales. Requirement 1. Determine the total and unit target cost to manufacture, sell, distribute, and service the portable brushes. Requirement 1. Determine the total and unit target cost to manufacture, sell, distribute, and service the portable brushes. Begin by computing the total target cost to manufacture, sell, distribute, and service the portable brushes, then compute the unit target cost to manufacture, sell, distribute,…
Mesa Cheese Company has developed a new cheese slicer called Slim Slicer. The company plans to sell this slicer through its online website. Given market research, Mesa believes that it can charge $20 for the Slim Slicer. Prototypes of the Slim Slicer, however, are costing $22. By using cheaper materials and gaining efficiencies in mass production, Mesa believes it can reduce Slim Slicer's cost substantially. Mesa wishes to earn a return of 40% of the selling price. (b) When is target costing particularly helpful in deciding whether to produce a given product?
Syntech makes digital cameras for drones. Their basic digital camera uses $80 in variable costs and requires $1,400 per month in fixed costs. Syntech sells 100 cameras per month. If they process the camera further to enhance its functionality, it will require an additional $45 per unit of variable costs, plus an increase in fixed costs of $900 per month. The current price of the camera is $170. The marketing manager is positive that they can sell more and charge a higher price for the improved version. At what price level would the upgraded camera begin to improve operational earnings? Price to be charged Feedback
McGilla Golf has decided to sell a new line of golf clubs and would like to know the sensitivity of NPV to changes in the price of the new clubs and the quantity of new clubs sold. The clubs will sell for $810 per set and have a variable cost of $410 per set. The company has spent $151,000 for a marketing study that determined the company will sell 55,000 sets per year for seven years. The marketing study also determined that the company will lose sales of 9,600 sets of its high-priced clubs. The high-priced clubs sell at $1,110 and have variable costs of $710. The company will also increase sales of its cheap clubs by 11,100 sets. The cheap clubs sell for $450 and have variable costs of $235 per set. The fixed costs each year will be $9,110,000. The company has also spent $1,120,000 on research and development for the new clubs. The plant and equipment required will cost $28,770,000 and will be depreciated on a straight-line basis. The new clubs will also require an increase in net…
Under pressure from its board of directors, management at Roadside is planning to enter the conventional battery-powered flashlight market. Roadside expects to sell this boring product to wholesalers for $18.12 per unit. Relevant fixed costs will total $334,573, and variable costs to make this product will be $14.57 per unit. Background research estimates the size of the market for conventional flashlights at 1.8 million units per year. If sales of this unit reach breakeven, what market share will Roadside have? Report your answer as a percent. Report 27.5%, for example, as "27.5". Rounding: tenth of a percent.
Two alternative locations are under consideration for a new plant: Jackson, Mississippi, and Dayton, Ohio. The Jackson location is superior in terms of costs. However, management believes that sales volume would decline if this location were chosen because it is farther from the market, and the firm's customers prefer local suppliers. The selling price of the product is $375 per unit in either case. Use the following information to determine which location yields the higher total profit per year: Location Jackson Dayton Annual Fixed Cost $2,100,000 $3,000,000 Variable Cost per Unit $45 $80 Forecasted Demand per Year 40,000 units 39,000 units The annual profit from Jackson is $8575000. (Enter your response as an integer.)