Answered step by step
Verified Expert Solution
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!!
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
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started