The following table shows the rate of commission that will be paid to the salesman according to the total sales performance of the month:Total Sales Performance (RM) CommissionLess than 10000 No commission10000 – 20000 1% of the total sales20001 – 30000 2% of the total sales30001 – 40000 3% of the total salesMore than 40000 4% of the total sales The program will determine the total commission that will be receivedaccording total sales performance of the month.

The following table shows the rate of commission that will be paid to the salesman according to the total sales performance of the month:Total Sales Performance (RM) CommissionLess than 10000 No commission10000 – 20000 1% of the total sales20001 – 30000 2% of the total sales30001 – 40000 3% of the total salesMore than 40000 4% of the total sales The program will determine the total commission that will be receivedaccording total sales performance of the month.

Np Ms Office 365/Excel 2016 I Ntermed

1st Edition

ISBN:9781337508841

Author:Carey

Publisher:Carey

Chapter6: Managing Multiple Worksheets And Workbooks

Section: Chapter Questions

Problem 4.4CP

See similar textbooks

Similar questions

The following table shows the rate of commission that will be paid to the salesman according to the total sales performance of the month:Total Sales Performance (RM) CommissionLess than 10000 No commission10000 – 20000 1% of the total sales20001 – 30000 2% of the total sales30001 – 40000 3% of the total salesMore than 40000 4% of the total sales Lastly, display the salesmanName, totalSalesPerformance,totalCommission and totalSalary.
Problem Statement: A famous product photographer Xavier is in high demand and is being approached by various companies to get their products photographed. Xavier does all of this product shoots at his studio and wants to make sure that he maximizes his returns by covering as many photoshoots in a day as possible. For a product shoot to be conducted, the product first has to be staged and then photographed. He has a team who stages the products and he does the photoshoots. Depending on the product, it takes different amounts of time to stage and varied time to complete the shoot. His team can stage another product in another part of the studio while Xavier is busy with a photoshoot of a previously staged product. Assuming that his team can work on only one product at a time before they move to staging another and Xavier also finishes one product photoshoot before moving to the next, you are expected to help Xavier make best use of his team and his time by deciding the order in which the…
A real estate agency pays a sales representative monthly minimum income of 1000, 54 TL, additional allowance according to his/her title, plus 200 TL for each property sold by the sales representative in that month and a certain amount of the sales amount. Additional allowance amounts by title and bonus rates are given in the tables below: Title Additional Allowance (TL) Trainee (1) 250 Beginner (2) 350 Expert (3) Senior (4) 500 750 Sales Amount (TL) Bonus Rate (%) 0- 499.999,99 0.25 500.000- 999.999,99 0.5 1.000.000- 1.999.999,99 0.75 2.000.000-.. 1 By adhering the rules stated above, find the total salary amount of a sales representative for a particular month, by obtaining the title of a sales representative from the user (1 for the trainee, 2 for the novice, 3 for the specialist, 4 for the senior), the number of real estate sold this month and the total sales amount made by the sales representative. Write a C code that prints the total salary on the screen using the switch-case…
What is the minimum number of students required in a discrete mathematics class to be sure that at least 8 will receive the same grade, if there are five possible grades, A, B, C, D, and F? (Discrete Mathematics)
A real estate agency pays a sales representative monthly minimum income of 1000, 54 TL, additional allowance according to his/her title, plus 200 TL for each property sold by the sales representative in that month and a certain amount of the sales amount. Additional allowance amounts by title and bonus rates are given in the tables below: Title Additional Allowance (TL) Trainee (1) Beginner (2) 250 350 Expert (3) 500 Senior (4) 750 Sales Amount (TL) Bonus Rate (%) 0- 499.999,99 0.25 500.000- 999.999,99 0.5 1.000.000- 1.999.999,99 0.75 2.000.000-... 1 By adhering the rules stated above, find the total salary amount of a sales representative for a particular month, by obtaining the title of a sales representative from the user (1 for the trainee, 2 for the novice, 3 for the specialist, 4 for the senior), the number of real estate sold this month and the total sales amount made by the sales representative. Write a MATLAB code that prints the total salary on the screen using the…
OVERVIEW Body mass index (BMI) is a value derived from the mass (weight) and height of a person. The BMI is defined as the body mass divided by the square of the body height, and is expressed in units of kg/m2, resulting from mass in kilograms and height in meters. The BMI may be determined using a table or chart which displays BMI as a function of mass and height using contour lines or colors for different BMI categories, and which may use other units of measurement (converted to metric units for the calculation). The BMI is a convenient way for classifying persons in to 4 categories based the BMI value as shown the following table: BMI value Category Underweight Normal Overweight Less than 18.5 18.5 to less than 25 25 to less than 30 30 or higher Obese A national study in some country to analyze the BMI of the people in the country is considered. In this study, a set of cities is selected in the study and randomly specific number of persons are selected to check the BMI category of…
The table shows monthly test requests and the average days to complete one request. On average, how many test requests are being processed? Note that a typical month is 20 days.
In repair facility problem, costs of every day repair is $300. What will be the annual repair bill? mark) 0.05 0.95 Working Broken 0.6 0.4
You are the manager of a Best Buy and you would like to see how much profit you made from your store over the past three months. Below is a worksheet which shows the 'Total Sales' in October 2019, November 2019, and December 2019. A 1 2 3 4 5 October 2019 November 2019 December 2019 2019 TOTAL SALES B DVD Sales 516 439 400 C CD Sales 355 750 751 1355 1856 D Record Sales 50 60 70 180 E TOTAL SALES Write a formula for cell E2 using the SUM function to calculate the TOTAL (DVD Sales, CD Sales, and Record Sales) for October 2019. When creating the formula, keep in mind that it will be copied to cells E3, E4, and E5 without modification. Now that you have written à formula for E2, write the formulas for E3, E4, and E5. 4
Use the table below to answer the questions in Group B. Lawn Service Comparisons (unless otherwise noted, dollars are yearly) Mowing, Trimming, Bagging (if necessary) May 1st through Oct. 31st Lawn Lawn Service Service A $1040 $125/cut $2.50/linear foot Trimming Bushes, Hedges included Lawn Fertilizations, and Aeration $170 $225 Weed and Seeding Control Fall and Spring Raking and Clean-Up $20/application included $205 $475
Suppose an iteration in Elaboration is 2 weeks and you are the leader of the team. Also assume that Elaboration has 20 iterations and you are now in the 5th iteration of Elaboration. (a) What are the activities that would typically happen in this iteration? (b) What is the order of these activities? (c) Roughly how much time and on which day(s) should you spend on each of the activities?
Please answer 8 and show work do NOT answer 36 use the chart to answer 37 and 38 show work and explanation how you got the answer! Not an graded assignment!