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.

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.

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

Each salesperson at IdzaaraAisya Inc. receives a commission based on the amount of his or her sales. The commission rates and additional payment amounts are shown below. Sales ($) Commission 1–5,999.99 10% of sales 6,000–29,999.99 $600 plus 13% of the sales over 6,000 30,000 and over $3,720 plus 14% of the sales over 30,000 Additional $500 if the salesperson has worked at the company for over 10 years and the sales amount is at least $10,000. $700 if the salesperson travels. Draw a flow chart. Calculate the commission, any additional amount, and the total due only when the sales amount is greater than 0; otherwise, display $0.00 as the commission, additional amount, and total due
The following list shows the items and prices for a restaurant order. Calculate the total amount if there is 7.5% tax and the customer leaves a 15% gratuity. 1 appetizer: $8.99 2 entrees: $14.99 each 1 entree: $12.99 3 drinks: $1.99 each a. $70.96 b. $71.62 c. $75.31 d. $75.97 Please select the best answer from the choices provided A Mark this and retum No hand written and fast answer with explanation
SeriResort has four type of room packages, The rate for each package is shown in the following table: Type of Package Code Rate Per Day (RM) Premium 1 300 Family 2 200 Deluxe 3 150 Standard 4 100 Each guest has to pay 10% SST. The information needed to make a reservation at the resort are the guest’s name, type of package, number of days and type of booking (o – online, M – Manual). A discount of 10% will be given for online booking For each reservation, a receipt must be printed as shown below: SERI RESORT Guest Name xxxxxxxxxxxxxxx Type of Package xxxxxxxxxxxxx Number of Days xx Total Charges (RM) : xxx.xx SST 10% (RM) : xxx.xx Total Payment : xxxxx.xx Draw a flowchart to solve the given.
P1 - Loan Payment Schedule Main Street Bank is offering an annual interest rate discount based on the client’s credit score. The discount for each credit score level is provided in the table below. The lowest credit score is 300 while the highest credit score is 850. For example, the new interest rate for a client with a credit score of 755 and a current interest rate of 4.25% would be 4.25 – 0.75 = 3.50% interest rate Credit Score Rating Interest Rate Discount 300 - 579 Very Poor 0.00 580 – 669 Fair 0.25 670 - 739 Good 0.50 740 - 799 Very Good 0.75 800 - 850 Exceptional 1.00 Use modular programming concepts Create a program that includes a WHILE loop to generate a payment schedule for loans that are paid in equal monthly payments Input the loan number and retrieve required loan account from MS_LOANS table Output is shown below Monthly interest is calculated by dividing the yearly interest rate by 12 to get a monthly interest…
# Begin constantsCOLUMN_ID = 0COLUMN_NAME = 1COLUMN_HIGHWAY = 2COLUMN_LAT = 3COLUMN_LON = 4COLUMN_YEAR_BUILT = 5COLUMN_LAST_MAJOR_REHAB = 6COLUMN_LAST_MINOR_REHAB = 7COLUMN_NUM_SPANS = 8COLUMN_SPAN_DETAILS = 9COLUMN_DECK_LENGTH = 10COLUMN_LAST_INSPECTED = 11COLUMN_BCI = 12 INDEX_BCI_YEARS = 0INDEX_BCI_SCORES = 1MISSING_BCI = -1.0 EARTH_RADIUS = 6371 # Sample data for docstring examplesdef create_example_bridge_1() -> list:"""Return a bridge in our list-format to use for doctest examples. This bridge is the same as the bridge from row 3 of the dataset.""" return [1, 'Highway 24 Underpass at Highway 403','403', 43.167233, -80.275567, '1965', '2014', '2009', 4,[12.0, 19.0, 21.0, 12.0], 65.0, '04/13/2012',[['2013', '2012', '2011', '2010', '2009', '2008', '2007','2006', '2005', '2004', '2003', '2002', '2001', '2000'],[MISSING_BCI, 72.3, MISSING_BCI, 69.5, MISSING_BCI, 70.0, MISSING_BCI,70.3, MISSING_BCI, 70.5, MISSING_BCI, 70.7, 72.9, MISSING_BCI]]] def create_example_bridge_2() ->…
You changed the years for the loan so that the extra monthly payment changed. Explain what happens to the extra monthly payment if the years for the loan is decreased. Briefly explain why you adjusted the years for the loan. (Excel)
Saira owns a small business and she frequently makes transactions. Sometimes she makes payments and other times payments are credited in her account. One of her customer Tania purchased a product and credited payment while another payment by Saira was in progress. Now the sequence of transaction is as follows:1. Tania’s account read amount in saira’s account2. Saira’s account read amount in saira’s account3. Tania added Rs. 500/- in original amount (that was lets suppose Rs. 60,000/ 4. Saira’s account subtracted Rs. 2000/- that she debited in someone else’s account form the original amount (that was Rs. 60,000) 5. Tania’s account committed the transaction 6. Saira’s account committed the transaction Draw the above-mentioned sequence in form of a table and see if there is a problem. What this problem is called and how can we avoid such kind of problem? Propose some solutions (at least two) and then explain which one is better and why?
The following shows a training company’s workshops, the number of days of each, and their registration fees. Workshop # of Days Registration FeeHandling Stress 3 $ 1,000Time Management 2 $ 800Supervision Skills 3 $ 1,200Negotiation 6 $ 1,500Interview Skills 1 $ 300The training company conducts its workplace in the six locations shown in the following table. The table also shows the lodging fees per day at each location. Location Lodging Fees per DayAustin $ 151Chicago $ 225Dallas $ 179Orlando $ 322Phoenix $ 175Raleigh $ 165When a customer registers for a workshop, he or she must pay the registration fee plus the lodging fees for the selected location. For example, here are the charges to attend the Supervision Skills workshop in Orlando. Registration: $1,200Lodging: $322 * 3 days = $966Total: $2,166Create an application that lets the user input a workshop and location from the lists. The application should display the workshop and lodging prices, calculate and display the registration…
The following is a sample report from a child clinic. It shows the days and treatments for visits to doctors at the clinic. A mother takes her child, sees a doctor and the doctor administers some treatment. There are couple of things you should assume: The mother’s name is unique. a mother won't have more than one child with the same name the doctor's surname is unique a treatment code is unique treatments are specific to doctors, eg 101 is only ever given by Johnson Surname First Name Town Age Child Doctor Date Treatment Smith Jane Coventry 30 Rebecca Johnson 27.3.04 101 Brian Clarence 30.5.04 209 Robert Johnson 10.1.88 101 Brown Beryl Rugby 28 Alan Clarence 30.4.04 214 Sarah Johnson 29.5.04 101 Sarah Clarence 12.1.04 321 Jones Fiona Kenilworth 34 James Clarence 30.4.04 322 Jenny…
Please use python3 to solve this question PLEASE BEGIN WITH def getUnalottedUsers(bids, total shares)
Correct answer will be upvoted else downvoted. Focuses got by hopefuls in various stages are utilized for shaping generally challenge results. Assume that k phases of the challenge are finished. For every challenger, k−⌊k4⌋ stages with the most noteworthy scores are chosen, and these scores are added up. This total is the general aftereffect of the competitor. (Here ⌊t⌋ indicates adjusting t down.) For instance, assume 9 phases are finished, and your scores are 50,30,50,50,100,10,30,100,50. Initial, 7 phases with the most elevated scores are picked — for instance, all stages aside from the 2-nd and the 6-th can be picked. Then, at that point, your general outcome is equivalent to 50+50+50+100+30+100+50=430. At this point, n stages are finished, and you know the focuses you and Ilya got for these stages. Be that as it may, it is obscure the number of more stages will be held. You can't help thinking about what the most modest number of extra stages is, after which your outcome…
Suppose it is 4:00 p.m., September 29, 2008. Fitter Snacker’s CEO sends this e-mail message to the accounting manager: “I need to meet with the Board of Directors tomorrow morning. The Board members are concerned about the current sales of our energy bars. They would like to see sales data for today, 9/29, as a typical day. Please complete the attached report and have it on my desk by 9:00 a.m. tomorrow, September 30.” The blank table shown in Figure 1 is attached to the memo. Given the company’s sales order data-processing practices, why won’t the accountants be able to easily accomplish this task? Cite the practices that cause difficulty, and explain. If FS had an ERP system, why would this task be easy to complete?