Question: 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!!
please solve & explain!! Sina is a manager at Rumi's Publisher Company,

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

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Accounting Questions!