I need the answer as soon as possible The employee gets a 5% bonus if his sales exceed the The employee receives a commisnion of 8% of the basicplanned sales. Only 5% of the increase in salessalary if his sales exceed the specified plan5% salaryEmployeeNamebasicPlanned Actualsales salestotal salaryincreasesalary900ommissienAli Majel 25000 3000030000 50000 500000Laith Hussein 350000 40000 60000025000 30000 4000030000 40000 500000Ahmed mogmmedForgiveness AliAli Mahdi 200000 250000 30000030000 40000Walid Khawam50000Using the attached table,choose the correct answerItis *: the salary increase for the employee "Ahmed Muhammad"O 1000O 120000O 580000None of the above 0O 250004200O 700002400

Given employee name is Ahmed Muhammad So we start with that particular row in excel which is row7

The employee gets a 5% bonus if his sales exceed the The employe planned sales. Only 5% of the increase in sales salary 5% Employee basic salary misioe 900 Name Planned Actual in ales sales Ali Majel 25000 30000 Ahmed mogmmed 30000 50000 500000 Laith Hussein 350000 40000 600000 Forgiveness Ali 25000 30000 40000 Taman Salah 30000 40000 500000 Ali Mahdi 200000 250000 300000

The employee gets a 5% bonus if his sales exceed the The employe planned sales. Only 5% of the increase in sales salary 5% Employee basic salary misioe 900 Name Planned Actual in ales sales Ali Majel 25000 30000 Ahmed mogmmed 30000 50000 500000 Laith Hussein 350000 40000 600000 Forgiveness Ali 25000 30000 40000 Taman Salah 30000 40000 500000 Ali Mahdi 200000 250000 300000

Operations Research : Applications and Algorithms

4th Edition

ISBN:9780534380588

Author:Wayne L. Winston

Publisher:Wayne L. Winston

Chapter17: Markov Chains

Section17.5: Steady-state Probabilities And Mean First Passage Times

Problem 10P

See similar textbooks

Similar questions

Store bonuses: If store sales are $80,000 or more, store bonus is $3000 If store sales are $90,000 or more, store bonus is $4000 If store sales are $100,000 or more, store bonus is $5000 If store sales are $110,000 or more, store bonus is $6000 Employee bonuses: If percent of increase is 3% or more, employee bonus is $40 If percent of increase is 4% or more, employee bonus is $50 If percent of increase is 5% or more, employee bonus is $75 Step 3: Modify Module 5 by adding an if statement that will print a message if both the store bonus and the employee bonus are the highest amounts possible. (Reference: Logical Operators, page 147). //MODULE 5 //this module will display store and employee bonus info. Module printBonus(Real storeAmount, Real empAmount) Display “The store bonus is $”, storeAmount Display “The employee bonus is $”, empAmount If storeAmount == _____ AND empAmount == _____ Then Display “Congrats! You have reached the highest bonus amounts possible!”…
Store bonuses: If store sales are $80,000 or more, store bonus is $3000 If store sales are $90,000 or more, store bonus is $4000 If store sales are $100,000 or more, store bonus is $5000 If store sales are $110,000 or more, store bonus is $6000 Employee bonuses: If percent of increase is 3% or more, employee bonus is $40 If percent of increase is 4% or more, employee bonus is $50 If percent of increase is 5% or more, employee bonus is $75 Step 1: Modify the storeBonus module to write a nested if else statement to set the new bonus levels. Complete the missing lines. (Reference: The if-then-else Statement, page 140). //MODULE 2 //this module will determine what the bonus levels are Module storeBonus (Real monthlySales, Real Ref storeAmount) If monthlySales >= 110000 Then Set storeAmount = 6000 Else If monthlySales >= ______________ Then Set storeAmount = ___________________ Else if monthlySales >= ______________ Then Set storeAmount =…
Use the given data to classify the record below using the k-NN algorithm for k = 1 to 5. Loan Purpose Checking Repairs Savings Months Customer Employed Months 0 900 25 4 Click the icon to view the table of classified records. D Complete the table below for the nearest neighbors and for the classification of the new record for each value of k. k Distance Classification 1 2 3 4 5 (Round to four decimal places as needed.)
AITAM Public Library is the biggest library in Koforidua. Currently, it has about 300 members. A person who is 18 or above can become a member. There is a membership fee of GHC400 for a year. There is a form to be filled in which person fills personal details. These forms are kept in store for maintaining members’ records and knowing the membership period. A member can issue a maximum of three books. He/she has three cards to issue books. Against each card a member can issue one book from library. Whenever a member wishes to issue a book and there are spare cards, then the book is issued. Otherwise that request is not entertained. Each book is to be returned on the specified due date. If a member fails to return a book on the specified date, a fine of GHC 2 per day after the due return date is charged. In case a card gets lost, then a duplicate card is issued. Accounts are maintained for the membership fees and money collected from the fines. There are two librarians for books return…
AITAM Public Library is the biggest library in Koforidua. Currently, it has about 300 members. A person who is 18 or above can become a member. There is a membership fee of GHC400 for a year. There is a form to be filled in which person fills personal details. These forms are kept in store for maintaining members’ records and knowing the membership period. A member can issue a maximum of three books. He/she has three cards to issue books. Against each card a member can issue one book from library. Whenever a member wishes to issue a book and there are spare cards, then the book is issued. Otherwise that request is not entertained. Each book is to be returned on the specified due date. If a member fails to return a book on the specified date, a fine of GHC 2 per day after the due return date is charged. In case a card gets lost, then a duplicate card is issued. Accounts are maintained for the membership fees and money collected from the fines. There are two librarians for books return…
AITAM Public Library is the biggest library in Koforidua. Currently, it has about 300 members. A person who is 18 or above can become a member. There is a membership fee of GHC400 for a year. There is a form to be filled in which person fills personal details. These forms are kept in store for maintaining members’ records and knowing the membership period. A member can issue a maximum of three books. He/she has three cards to issue books. Against each card a member can issue one book from library. Whenever a member wishes to issue a book and there are spare cards, then the book is issued. Otherwise that request is not entertained. Each book is to be returned on the specified due date. If a member fails to return a book on the specified date, a fine of GHC 2 per day after the due return date is charged. In case a card gets lost, then a duplicate card is issued. Accounts are maintained for the membership fees and money collected from the fines. There are two librarians for books return…
Future Value Calculator Years must be less than 31. Investment Amount: 1000000 Yearly Interest Rate: 1.5 Number of Years: 34 Calculate
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 A B Minimum Sales Made $ $ $ 5,000.00 10,000.00 Name Ryan Andy Stanley Phyllis Jim Dwight Michael Pam Karen Creed $ $ $ $ $ $ $ $ $ $ C Reward Level Bronze Silver Gold Total Sales Made 3,800.00 5,000.00 6,000.00 7,500.00 12,000.00 14,500.00 10,000.00 300.00 8,500.00 200.00 $ $ $ D Average (AVERAGEIF) 1,433.33 6,750.00 12,166.67 Reward Level (IF/AND) Bronze Silver Silver Silver Gold Gold Gold Bronze Silver Bronze E Count (COUNTIF) 3 4 3 Reward Level (VLOOKUP) Bronze Silver Silver Silver Gold Gold Gold Bronze Silver Bronze Use the above spreadsheet for the following questions a, b, c, and d. a) Create a formula in cell D8 that uses the IF and AND functions. The formula will determine each Reward Level based on the possible Rewards and accompanying minimum sales made. You should be able to autofill down through cells D8:D17. b) Create a formula in cell E8 that uses the VLOOKUP function with the table array $B$3:$C$5. The formula will determine…
An agency called Resourcecover supplies part-time/temporary staff to hotels throughout Mauritius. The table shown in Figure 1 lists the time spent by agency staff working at two hotels. The National Insurance Number (NIN) is unique for each employee. NIN contractNo HrsPerWeek empName HotelNo HotelLocation 125WD C1024 16 Samuel Н25 Grandbay Fody 142XA C1024 24 Dev Samy Н25 Grandbay 169YD C1025 28 Sara Ally H4 Tamarin 125WD C1025 16 Samuel Н4 Tamarin Fody Figure 1: Resourcecover i. The table shown in Figure 1 is susceptible to update anomalies. Provide examples of insertion, deletion, and update anomalies. i. Describe and illustrate the process of normalising the table shown in Figure 1 to 3NF. State any assumptions you make about the data shown in this table.
AITAM LIBRARY MANAGEMENT SYSTEM AITAM Public Library is the biggest library in Koforidua. Currently, it has about 300 members. A person who is 18 or above can become a member. There is a membership fee of GHC400 for a year. There is a form to be filled in which person fills personal details. These forms are kept in store for maintaining members’ records and knowing the membership period. A member can issue a maximum of three books. He/she has three cards to issue books. Against each card a member can issue one book from library. Whenever a member wishes to issue a book and there are spare cards, then the book is issued. Otherwise that request is not entertained. Each book is to be returned on the specified due date. If a member fails to return a book on the specified date, a fine of GHC 2 per day after the due return date is charged. In case a card gets lost, then a duplicate card is issued. Accounts are maintained for the membership fees and money collected from the fines. There are…
AITAM LIBRARY MANAGEMENT SYSTEM AITAM Public Library is the biggest library in Koforidua. Currently, it has about 300 members. A person who is 18 or above can become a member. There is a membership fee of GHC400 for a year. There is a form to be filled in which person fills personal details. These forms are kept in store for maintaining members’ records and knowing the membership period. A member can issue a maximum of three books. He/she has three cards to issue books. Against each card a member can issue one book from library. Whenever a member wishes to issue a book and there are spare cards, then the book is issued. Otherwise that request is not entertained. Each book is to be returned on the specified due date. If a member fails to return a book on the specified date, a fine of GHC 2 per day after the due return date is charged. In case a card gets lost, then a duplicate card is issued. Accounts are maintained for the membership fees and money collected from the fines. There are…
dont waste my question strict report if not sure