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.)

Respuesta :

Answer:

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 brainly.com

Ver imagen biodunomotoso