Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

please solve & explain!! Sina is a manager at Rumi's Publisher Company, a producer and seller of historical literature books. Sina is interested in publishing

please solve & explain!!
image text in transcribed
Sina is a manager at Rumi's Publisher Company, a producer and seller of historical literature books. Sina is interested in publishing a new translation of "The Book of Kings," a long Persian epic poem written in 977 - 1010. He previously determined that the cost of translation and editing add up to $180,000, and the book's design costs about $70,000. In addition, the translation of the book has about 1000 pages, and printing costs 2.5 cents per page. Sina estimates that the book can be sold at a premium price of $75 per copy. Question 1) In Excel, create a model of Rumi's Publisher Company that explicitly shows important quantities' values in this problem and how they combine to give the annual profit. These cells should include fixed cost, variable cost, selling price, selling amount, total cost, total revenue, and net profit. Consider the following points in your worksheet: a. Each number appearing above should have its own cell in the parameters section of your spreadsheet. Use formatting that makes it clear that the user may change the values in these cells. b. Format all dollar amounts as Currency. c. Name this sheet "Model." d. In a cell, write "Break-even Point." Then, on the right of this cell, write a formula to calculate the break-even point of this problem on your spreadsheet. e. Use goal-seek to find the exact break-even point in the "Number of sold copies" cell and compare the result of your formula with 1.d. f. Organization, formatting, clarity, and correctness all count

Step by Step Solution

There are 3 Steps involved in it

Step: 1

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

Edp Auditing A Functional Approach

Authors: Albert J. Harnois

1st Edition

0132246848, 978-0132246842

More Books

Students also viewed these Accounting questions