Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

This first question asks you to demonstrate that you can build and analyze a basic spreadsheet model Badge Press is considering publishing paperback text cad

This first question asks you to demonstrate that you can build and analyze a basic spreadsheet model

Badge Press is considering publishing paperback text cad sheet applications in the industry. The fixed cost of manuscript preparation, book design, and production setup is estimated to be $185,000. Variable production and material costs are estimated to be $15 per book. Demand over the life of the book is predicted to be 18,000 copies. Badger Press is thinking about selling the text to retailers at a price of $29 each. Assume Badger Press produces the same number of

books that they sell to retailers. Badger Press evaluates the financial attractiveness of all of its projects using a "return on investment" (ROI) metric. In the case of its new text, "investment" would include all costs (both fixed and variable), while "return" would measure total revenue minus total cost for the book. ROI is then (return)/(investment).

Build a base spreadsheet model that outputs the ROI. Then answer each part below on its own sheet, where the answer is both calculated in the sheet and also explicitly written in a text box.

a. What is the forecasted ROI under the above assumptions?

b. If Badger Press requires an ROI of at least 10%, demand needs to be at least

units.

For this part of the problem, make the additional assumption that Badger Press' market researchers estimated the following linear demand function:

Demand t = - 300Price + 21000

Under this estimated relationship, what is the optimal price for Badger Press to set in

order to maximize ROI?

Step by Step Solution

3.55 Rating (148 Votes )

There are 3 Steps involved in it

Step: 1

To publish a paperback text on spreadsheet applications in industry Fixed cost 18... blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Business Communication Process and Product

Authors: Mary Ellen Guffey

6th Edition

324578679, 9780324578683, 9780324542905, 176721258, 9780324578676, 324542909, 9780176721251, 978-0324542905

More Books

Students also viewed these Business Communication questions

Question

For long reports, why is a written work plan a wise idea?

Answered: 1 week ago