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