A new author is in the process of negotiating a contract for a new romance novel. The publisher is offering three options. In the first option, the author is paid $5,000 upon delivery of the final manuscript and $20,000 when the novel is published. In the second option, the author is paid 12.5% of the net price of the novel for each copy of the novel sold. In the third option, the author is paid 10% of the net price for the first 4,000 copies sold, and 14% of the net price for the copies sold over 4,000. The author has some idea about the number of copies that will be sold and would like to have an estimate of the royalties generated under each option. Instructions Write a program that prompts the author to enter: The estimated number of copies that will be sold. The net price of each copy of the novel The program then outputs: The royalties under each option The best option the author could choose. Ex. If option 1 is the best, output Option 1 is the best (Use appropriate named constants to store the special values such as royalty rates and fixed royalties.)

The attached excel workbook should be applied

Explanation:

The first worksheet (Input sheet) has an Input column for Units sold (yellow cells), this should be inputed with the quantity of Books sold per batch of sales recorded

The Input column for Net price (Green cells) should be for the Net Sales Price per Unit of Book sold for the batch being recorded

The document will work out the Royalty due per option and makes a decision in the second worksheet (Royalty due by options) for the Author

The Cells have been protected to avoid contamination of entries, the passcode is

you can lose ranking 2 ways.

1) you don't have enough points due to you expending them by asking questions/your answers are deleted.

2) your brainliest's expired. this means that brainliests, once they exceed the 30 day limit, expires. this is to ensure that you continue to contribute into the community at a constant rank if you want to continue to have/exceed the rank you have right now.

if you go to profile, and click "show more information" located on the bottom left of the box with your information (on top of the questions answered, questions asked, and friends), you will be given the following information (example):

member since : 02/13/2017, 18: 11

questions answered: 9741

questions asked: 162

no. of brainliest answers: 1575

brainliest answers in last 30 days: 10

warnings: 0 view

questions/answers reported: 2637

questions/answers incorrectly reported: 64

look at the "brainliest answers in the last 30 days". this is the one that will affect your rank other than your points. again, once your brainliest expires (was earned 31+ days ago), it will not be counted.

~

i would say iii (3) because in order to compare a price you have to use as a reference other near stores because it's its

hope i explained myself