Use goal seek to compute price that results in break even

Assignment Help Financial Accounting

Reference no: EM131247521

Eastman Publishing Company is considering publishing an electronic textbook on spreadsheet applications for business. The fixed cost of 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 access to the book for $46 each. Eastman has created a predictive model that estimates demand as a function of price. The predictive model is demand = 4000-6*p where p is the price of the e-book.

Build a spreadsheet model to calculate the profit/loss for a given price.

Use goal seek to compute the price that results in break even

Use a data table that varies price from $50 to $400 increment of $25 to find the price that maximizes profit.

Reference no: EM131247521

Questions Cloud

Time value of money have an effect on role of an accountant : How does the time value of money have an effect on the role of an accountant? What are the key items that an accountant must understand around present and future value concepts, annuities, and compound interest?

Transactions-adjustments on appropriate balance sheet : A company incurred the following transactions: Wages of $2,200 accrued at the end of the prior fiscal period were paid this fiscal period. Real estate taxes of $5,800 applicable to the current period have not been accrued. Show the effect, if any, of..

What is revealed about the company by these sources : Choose a publicly traded company, and identify the sources that you would use, other than the financial statements, to analyze the financial position of this corporation. Find at least two resources, other than the financial statements, that provide ..

Use the horizontal model to show the effect of issuing bonds : Alexi Co. issued $3.40 million face amount of 6%, 10-year bonds on June 1, 2016. The bonds pay interest on an annual basis on May 31 each year. Independent of your answer to part a, assume that the proceeds were $3,044,000. Use the horizontal model t..

Use goal seek to compute price that results in break even : Eastman Publishing Company is considering publishing an electronic textbook on spreadsheet applications for business. The fixed cost of preparation, textbook design, and Web site construction is estimated to be $160,000. Build a spreadsheet model to ..

Determine equivalent unit of production for direct materials : The following information concerns production in the Baking Department for August. All direct materials are placed in process at the beginning of production. ACCOUNT Work in Process—Baking Department ACCOUNT NO. Determine the number of units in work ..

Revenue accounts at the end of the fiscal year : Write a one to two page memorandum on the following ethics issue: The owner of Sorena Company has asked your firm not to close the revenue accounts at the end of the fiscal year. "Our year-end income statement will look a lot better if we can fatten ..

Units of production with respect to conversion costs : Maykes Company uses a weighted-average process costing system and started 26,000 units during this month. Maykes had 12,000 units that were 20% complete as to conversion costs in beginning work in process inventory and 3,900 units that were 40% compl..

Prepaid insurance-accounts payable and property tax expense : The following trial balance of Waterway Landowska Company does not balance. Your review of the ledger reveals the following. (a) Each account had a normal balance. (b) The debit footings in Prepaid Insurance, Accounts Payable, and Property Tax Expens..

User Account

All Pages