Business, 15.04.2020 19:12 tamera62

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. 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 demandA: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?

(a) Breakeven appears in the interval of 3,600 to 3,800 copies.
(b) Breakeven appears in the interval of 4,000 to 4,200 copies.
(c) Breakeven appears in the interval of 4,200 to 4,400 copies.
(d) 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.

Answers: 1

Show answers

Other questions on the subject: Business

Business, 21.06.2019 18:30, tfhdg

Following is stanley black & decker’s income statement for 2016 (in millions): stanley black & decker, inc. income statement for the year ended december 31, 2016 ($ millions) sales $11,406.9 cost of goods sold 7,139.7 gross profit $ 4,267.2 selling, general and administrative expenses 2,602.0 other operating expenses 268.2 operating income 1,397.0 interest and other nonoperating expenses 171.3 income before income tax 1,225.7 income tax expense 261.2 net income $ 964.5 compute stanley black & decker’s gross profit margin.

Answers: 1

continue

Business, 22.06.2019 01:50, Kana81

You are an employee of an u. s. firm that produces personal computers in thailand and then exports them to the united states and other countries for sale. the personal computers were originally produced in thailand to take advantage of relatively low labor costs and a skilled workforce. other possible locations considered at that time were malaysia and hong kong. the u. s. government decides to impose punitive 100% ad valorem tariffs on imports of computers from thailand to punish the country for administrative trade barriers that restrict u. s. exports to thailand. how do you think your firm should respond? what does this tell you about the use of targeted trade barriers?

Answers: 3

continue

Business, 22.06.2019 03:20, limelight11

Yael decides that she no longer enjoys her job, and she quits to open a gluten-free, dairy-free kosher bakery. she pays a monthly rent for her store of $2,000. her labor costs for one month are $4,500, and she spends $6,000 a month on nut flours, sugar, and other supplies. yael was earning $2,500 a month working as a bank teller. these are her only costs. her monthly revenue is $14,000. which of the following statements about yael’s costs and profit are correct? correct answer(s) an accountant would say she is earning a monthly profit of $1,500. her implicit costs are $2,500 a month. an economist would tell her that she is experiencing a loss. her total costs are $12,500 a month. her explicit costs include the labor, rent, and supplies for her store. her economic profit is $1,500 a month.

Answers: 3

continue

Business, 22.06.2019 12:50, sunshine0613

Explain whether each of the following events increases or decreases the money supply. a. the fed buys bonds in open-market operations. b. the fed reduces the reserve requirement. c. the fed increases the interest rate it pays on reserves. d. citibank repays a loan it had previously taken from the fed. e. after a rash of pickpocketing, people decide to hold less currency. f. fearful of bank runs, bankers decide to hold more excess reserves. g. the fomc increases its target for the federal funds rate.

Answers: 3

continue

You know the right answer?

Eastman Publishing Company is considering publishing an electronic textbook about spreadsheet applic...