Business, 19.11.2019 07:31 Suphat

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.

Answers: 2

Show answers

Another question on Business

Business, 21.06.2019 21:30

Ryan terlecki organized a new internet company, capuniverse, inc. the company specializes in baseball-type caps with logos printed on them. ryan, who is never without a cap, believes that his target market is college and high school students. you have been hired to record the transactions occurring in the first two weeks of operations. issued 2,900 shares of $0.01 par value common stock to investors for cash at $29 per share. borrowed $68,000 from the bank to provide additional funding to begin operations; the note is due in two years. paid $1,000 for the current month's rent of a warehouse and another $1,000 for next month's rent. paid $1,440 for a one-year fire insurance policy on the warehouse (recorded as a prepaid expense). purchased furniture and fixtures for the warehouse for $16,000, paying $3,200 cash and the rest on account. the amount is due within 30 days. purchased for $2,800 cash the university of pennsylvania, notre dame, the university of texas at austin, and michigan state university baseball caps as inventory to sell online. placed advertisements on google for a total of $340 cash. sold caps totaling $1,900, half of which was charged on account. the cost of the caps sold was $1,100. (hint: make two entries.) made full payment for the furniture and fixtures purchased on account in (e). received $280 from a customer on account.

Answers: 2

Answer

Business, 22.06.2019 08:10

The sec has historically raised questions regarding the independence of firms that derive a significant portion of their total revenues from one audit client or group of clients because the sec staff believes this situation causes cpa firms to

Answers: 3

Answer

Business, 22.06.2019 15:30

University hero is considering expanding operations beyond its healthy sandwiches. jim axelrod, vice president of marketing, would like to add a line of smoothies with a similar health emphasis. each smoothie would include two free health supplements such as vitamins, antioxidants, and protein. jim believes smoothie sales should fill the slow mid-afternoon period. adding the line of smoothies would require purchasing additional freezer space, machinery, and equipment. jim provides the following projections of net sales, net income, and average total assets in support of his proposal. sandwichesonly sandwiches and smoothies net sales $ 750,000 $ 1,350,000 net income 120,000 210,000 average total assets 350,000 750,000 return on assetschoose numerator ÷ choose denominator = return on assets÷ = return on assets÷ = profit margin÷ = profit margin÷ = asset turnover÷ = asset turnover÷ = times

Answers: 2

Answer

Business, 22.06.2019 17:20

Arecession is defined as a period in which

Answers: 1

Answer

You know the right answer?

Eastman publishing company is considering publishing an electronic textbook about spreadsheet applic...

Questions