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

The production department is proposing the purchase of an automatic insertion machine. It has identified three machines and has asked the accountant to analyze them to determine which one has the best average rate of return. Line Item Description Machine A Machine B Machine C Estimated average income $47,060.44 $72,961.50 $73,785.60 Average investment 336,146.00 243,205.00 491,904.00 a. Machine C b. Machine A c. Machines B and C have the same preferred average rate of return. d. Machine B
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…
Easy Solutions limited manufactures electronic calculators. One of its top-selling calculators has a price of $50. Recently, a competitor entered the market and started offering a similar calculator at a price that is 20% below the $50 price of Easy Solutions. Company policy requires Easy Solutions to have a profit margin equal to 30% on sales of each of its products. 1.What target cost would have to be set for the Easy Solutions calculator to remain competitive and still meet the target profit margin of the company? 2.
Based on the above assumptions, indicate whether the offer should be accepted or rejected?The offer_________ Please don't give handwritten answer ....thanku
Need Help
Gamin Inc. produces various GPS devices with a wide assortment of different models for its customers. One item, RC1 is very popular. Keen of keeping its stock under control, a decision is taken to order only the optimum economic quantity, for this item, each time. You have the following information. Annual demand (units) 115,200 Purchase price per unit $ 300 Carrying/Holding costs per unit $ 8 Cost per order $ 200 Required: Determine the EOQ using the equation method. Fill the blanks in the following table using the above data. No. of orders 1 10 20 30 90 120 Order size Average stock Carrying (Holding) costs Order costs Total costs Calculate the holding, ordering cost & their total cost at the EOQ level. Plot the graph at the EOQ level showing the…