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

Another question on Business

Business, 21.06.2019 20:40

Maria am corporation uses the weighted-average method in its process costing system. the baking department is one of the processing departments in its strudel manufacturing facility. in june in the baking department, the cost of beginning work in process inventory was $4,880, the cost of ending work in process inventory was $1,150, and the cost added to production was $25,200. required: prepare a cost reconciliation report for the baking department for june.

Answers: 2

Answer

Business, 22.06.2019 04:30

How does your household gain from specialization and comparative advantage? (what is produced, what is not produced yet paid to a specialist to produce? )

Answers: 3

Answer

Business, 22.06.2019 08:10

Exercise 15-7 crawford corporation incurred the following transactions. 1. purchased raw materials on account $53,000. 2. raw materials of $45,200 were requisitioned to the factory. an analysis of the materials requisition slips indicated that $9,400 was classified as indirect materials. 3. factory labor costs incurred were $65,400, of which $50,200 pertained to factory wages payable and $15,200 pertained to employer payroll taxes payable. 4. time tickets indicated that $55,000 was direct labor and $10,400 was indirect labor. 5. manufacturing overhead costs incurred on account were $81,700. 6. depreciation on the company’s office building was $8,100. 7. manufacturing overhead was applied at the rate of 160% of direct labor cost. 8. goods costing $89,400 were completed and transferred to finished goods. 9. finished goods costing $76,000 to manufacture were sold on account for $105,100. journalize the transactions. (credit account titles are automatically indented when amount is entered. do not indent manually.) no. account titles and explanation debit credit (1) (2) (3) (4) (5) (6) (7) (8) (9) (to record the sale) (to record the cost of the sale) click if you would like to show work for this question: open show work

Answers: 1

Answer

Business, 22.06.2019 15:30

Careers in designing, planning, managing, building and maintaining the built environment can be found in the following career cluster: a. agriculture, food & natural resources b. architecture & construction c. arts, audio-video technology & communications d. business, management & administration

Answers: 2

Answer

You know the right answer?

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

Questions