Loading...

Messages

Proposals

Stuck in your homework and missing deadline? Get urgent help in $10/Page with 24 hours deadline

Get Urgent Writing Help In Your Essays, Assignments, Homeworks, Dissertation, Thesis Or Coursework & Achieve A+ Grades.

Privacy Guaranteed - 100% Plagiarism Free Writing - Free Turnitin Report - Professional And Experienced Writers - 24/7 Online Support

How to calculate royalty rate excel

26/11/2021 Client: muhammad11 Deadline: 2 Day

Royalty Statement

Project Description: You manage a small publishing company in Austin, Texas. You publish and sell hardback and paperback novels to regional bookstores. At the end of every six-month period, you prepare royalty statements for the authors based on the net sales and a standard royalty rate. Your assistant prepared a standard royalty statement for one author. You need to insert formulas to calculate missing values and format the worksheets. In addition, you need to insert worksheets to prepare a royalty statement for other authors.

Instructions: For the purpose of grading the project you are required to perform the following tasks: Step Instructions Points Possible 1 Start Excel. Download and open the workbook named Exploring_e01_Grader_EOC.xlsx. 0 2 Enter the text Royalty Statement in cell A1. Merge and center the title over the range A1:C1. Change the font size of the title to 16, and apply bold formatting. Change the font color to Purple (under Standard Colors). 9 3 Insert a new row between rows 13 and 14. Enter Standard Discount Rate in cell A14, 0.55 in cell B14, and 0.5 in cell C14. Format the two values in B14 and C14 as Percent Style. 10 4 In cell B15, enter the formula to calculate the price to the bookstore. The price to the bookstore is calculated by subtracting the standard discount from the retail price. The discount is calculated by multiplying the retail price (B13) by the standard discount rate (B14). 4 5 In cell B16, enter the formula to calculate the net retail sales. The net retail sales number is found by multiplying the net units sold by the retail price (B13). The net units sold is calculated by subtracting the returned units (B9) from the gross units sold (B8). 4 6 In cell B20, enter the formula to calculate the royalties to the author. Royalties are calculated by multiplying the net retail sales (B16) by the applicable royalty rate (B19). 4 7 In cell B21, enter the formula to calculate the royalty per book. This amount is calculated by multiplying the retail price of the book (B13) by the royalty rate (B19). 4 8 Copy the formulas from the B15:B16 to C15:C16 and from B20:B21 to C20:C21. 3 9 Apply the Accounting Number Format to the monetary values in the ranges B13:C13, B15:C16, and B20:C21. 7.5 10 Apply bold formatting and the Purple, Accent 4, Lighter 40% fill color to the Units Sold heading in cell A7. 4 11 Indent the text in cells A13:A16 two times. 4 12 Apply an Outside Border (default settings) to the range A7:C10. Apply the same border style to the ranges A12:C16 and A18:C21. 6 13 Insert a new worksheet on the right side of the Jacobs worksheet. Rename the new worksheet Lopez. Change the Lopez sheet tab color to Dark Blue (under Standard Colors). 9 14 Copy the data from the range A1:C21 in the Jacobs worksheet, and paste it into the same cells in the Lopez worksheet. 3 15 Change the following values on the Lopez worksheet: Cell: New value: B4 Lopez B8 5000 C8 15000 B9 400 C9 175 B13 19.95 C13 7.95 7 16 Select both worksheets and center the data horizontally on the page when printed. Insert a custom header with the name Cecil Kramer in the left section, the Sheet Name code in the center, and the File Name code in the right section. 10 17 With both sheets selected, select the options to display the gridlines and row and column headings when printed. 4 18 On the Lopez worksheet only, display the cell formulas. 3 19 In Normal view, on the Lopez worksheet, adjust the width of column A to 11.00 (165 pixels). Adjust the widths of columns B and C of the Lopez worksheet to 7.00 (108 pixels). 4.5 20 Ensure that the worksheets are correctly named and placed in the following order in the workbook: Jacobs, Lopez. Save the workbook. Close the workbook and then exit Excel.

Homework is Completed By:

Writer Writer Name Amount Client Comments & Rating
Instant Homework Helper

ONLINE

Instant Homework Helper

$36

She helped me in last minute in a very reasonable price. She is a lifesaver, I got A+ grade in my homework, I will surely hire her again for my next assignments, Thumbs Up!

Order & Get This Solution Within 3 Hours in $25/Page

Custom Original Solution And Get A+ Grades

  • 100% Plagiarism Free
  • Proper APA/MLA/Harvard Referencing
  • Delivery in 3 Hours After Placing Order
  • Free Turnitin Report
  • Unlimited Revisions
  • Privacy Guaranteed

Order & Get This Solution Within 6 Hours in $20/Page

Custom Original Solution And Get A+ Grades

  • 100% Plagiarism Free
  • Proper APA/MLA/Harvard Referencing
  • Delivery in 6 Hours After Placing Order
  • Free Turnitin Report
  • Unlimited Revisions
  • Privacy Guaranteed

Order & Get This Solution Within 12 Hours in $15/Page

Custom Original Solution And Get A+ Grades

  • 100% Plagiarism Free
  • Proper APA/MLA/Harvard Referencing
  • Delivery in 12 Hours After Placing Order
  • Free Turnitin Report
  • Unlimited Revisions
  • Privacy Guaranteed

6 writers have sent their proposals to do this homework:

Solution Provider
Top Academic Tutor
University Coursework Help
Financial Solutions Provider
Helping Hand
Engineering Help
Writer Writer Name Offer Chat
Solution Provider

ONLINE

Solution Provider

I am a professional and experienced writer and I have written research reports, proposals, essays, thesis and dissertations on a variety of topics.

$24 Chat With Writer
Top Academic Tutor

ONLINE

Top Academic Tutor

After reading your project details, I feel myself as the best option for you to fulfill this project with 100 percent perfection.

$44 Chat With Writer
University Coursework Help

ONLINE

University Coursework Help

I have read your project details and I can provide you QUALITY WORK within your given timeline and budget.

$24 Chat With Writer
Financial Solutions Provider

ONLINE

Financial Solutions Provider

As per my knowledge I can assist you in writing a perfect Planning, Marketing Research, Business Pitches, Business Proposals, Business Feasibility Reports and Content within your given deadline and budget.

$31 Chat With Writer
Helping Hand

ONLINE

Helping Hand

I have assisted scholars, business persons, startups, entrepreneurs, marketers, managers etc in their, pitches, presentations, market research, business plans etc.

$48 Chat With Writer
Engineering Help

ONLINE

Engineering Help

This project is my strength and I can fulfill your requirements properly within your given deadline. I always give plagiarism-free work to my clients at very competitive prices.

$20 Chat With Writer

Let our expert academic writers to help you in achieving a+ grades in your homework, assignment, quiz or exam.

Similar Homework Questions

Walter cunningham sr quotes - Ammonium biurate crystals dog - Wireless sensor network communication architecture - John r evans leaders fund - Final warning letter for late coming - MIPS assignment 1 - Rmit easycite - Compare refracting and reflecting telescopes - Psychology: Informed Consent Form - Six signature traits of inclusive leadership - Fully turbulent flow reynolds number - How much is a family pass to the easter show - Homeostasis negative feedback worksheet - Paper writing - Case outline reflection - Bsbmkg609a assessment answers - Write a five paragraph essay analyzing the influence frankenstein - The pillowman full script - Morin actuator b series - Alinta price fact sheet - The blair reader ninth edition - Ps2 movie games list - Abas 3 composite score ranges - Chapter 5 cost volume profit solutions - Kabihasnang minoan at mycenaean - Erd sample problems with solutions - LEADERSHIP & MANAGEMENT - LEADERSHIP CONSULTANT ANALYSIS - Yearly Reports - Raypak australia pty ltd - Keirsey temperament sorter questionnaire - The spiderwick chronicles theme - Managerial Accounting - Question 1 - Macroeconomics - Practical Connection Assignment - Rutgers newark visitor parking - Self determined learning heutagogy in action - Managerial Epidemiology Week 4 Discussion - Paper due tomorrow - 16 item tuckman procrastination scale - What is a special occasion speech - Northeast health wangaratta abn - System call parameter passing - Jimmy barnes take a load off annie - 70 768 dumps pdf - Raptors a field guide for surveys and monitoring - The cone gatherers summary of chapters https://studylib.net/doc/9791288/the-cone-gatherers-notes - Evolution of management thinking - Essentials of human anatomy and physiology 12th edition pearson - Afue vs thermal efficiency - Order 2465000: Reviving School Culture - Healthcare Ethics - Golden valley nature reserve - X 2 2x 10 0 quadratic formula - Analytic - Health Finance wk 3 - Leadership - Experimental Validity - Kpi planning template - EBP - An indian father's plea argumentative essay - Daily mining gazette snow totals - Rmit literature review structure - The leadership gap lolly daskal pdf - Mcdonald's core competencies - 2419 santiago dr newport beach ca 92660 - Multi-threading computer science assignment - 3 phase half wave diode rectifier - Plan Summary - Cloud computing architecture ppt - 30 60 90 triangle questions - Business HELP - Ucl ma ethnographic and documentary film - Strategy report on the Starbucks. - Levels of structural organization in the human body - Dot rotten petrol bomb - Homophones write right worksheets - Krispy kreme doughnuts inc case study solution - American nails shepparton safeway plaza - Does iago kill emilia - Sexual innuendo in disney movies - Ontario french immersion curriculum - Case study - The wright group sunshine books guided reading level - The sum of three consecutive even integers is - Marketing simulation managing segments and customers - Market segmentation targeting and positioning pdf - Kitchen renovation project management plan - Pigs on the wing strumming pattern - The 3 wishes story - Need 2 Page document with proper APA formatting and citations, references and No plagiarism - Nurses as knowledge workers definition - Mech Design - Acct case study - Plastic snap hook design - Cruise craft ranger v18 - Team Management Discussion 4 - Police assistance line tuggerah - Advantages and disadvantages of rubrics - Clinical reasoning cycle case study examples - Foundation of Mathematics