Using the goal seeking feature in Ms excel demonstrate a scenario where an employee earns a...

Using the goal seeking feature in Ms excel demonstrate a scenario where an employee earns a basic salary of 50000 KSH.

The overtime payrate per hour is 2500 KSH.

The total overtime amount =hours worked x payrate per hour.

The total gross pay = basicpay+overtime overtime amount.

The Tax payable = 30% of the gross pay.

The netpay = grosspay-tax payable

i) Enter the date in a worksheet to computer the net pay if the overtime hrs are 15

ii) Using the goal seeking feature how many hours do you need for overtime to take home a net pay of 130,000

iii) Using the scenario manager the worst case and the best case scenario of not having overtime and having 80 over hours

iv) Copy the worksheet onto a ms word document for upload

Solutions

Expert Solution

ekkarill92 answered 1 year ago

Next > < Previous

Related Solutions

Jack Stewart is an employee of Dr. Sloan’s medical practice, where he earns a salary of...

Jack Stewart is an employee of Dr. Sloan’s medical practice, where he earns a salary of $100,000 in 2019. He also runs his own business on the side and earns $50,000 of net self-employment income in 2019. How much Self-Employment (SE) tax does Jack owe for 2019 related to his $50,000 self-employment income? Considering the SE tax you calculated for Jack Stewart in the previous question, and also that Jack, who files single, paid $4,000 in student loan interest and...

28) Refer to Scenario 5. Using the generalized model where MS= MB.m, then for the money supply M1, the money multiplier m1 = ______.

SCENARIO 5.Notation: C = currency; D = demand deposits; T = time deposits; & S= saving deposits. MB= monetary base. Suppose: money supply 1, M1= C + D. money supply 2, M2= C + D + T. money supply 3, M3= C + D + T + S. Suppose also that C= cD; T= tD; & S = sD. The Fed imposes the following reserve requirements: rd on demand deposits D; rt on time deposits T; and rs on saving...

Problem 3 – Capital Budgeting This is where an MS Excel model might come in handy....

Problem 3 – Capital Budgeting This is where an MS Excel model might come in handy. Remember to use a very clear title and heading including your name on the page if you submit a separate MS Excel file. Follow the format I used in the examples that I sent out in the capital budgeting teaching notes document. Mumford Company is planning an upgrade to its warehouse. The upgrade involves computerizing many of the material handling activities. The cost of...

This week we have reviewed working in MS Excel. How do you see yourself using MS...

This week we have reviewed working in MS Excel. How do you see yourself using MS Excel, both in your personal and professional daily activities? Are you currently using Excel in your career? What are some of the features offered in Excel you find most helpful? How do you specifically use Excel and these features? Give two examples.

Time Value of Money Complete the following exercise using MS Excel. Using the Present Value and...

Time Value of Money Complete the following exercise using MS Excel. Using the Present Value and Future Value Equations 4. If you invested $200 at 5%, how much would it be worth in 30 years? 5. How many years does it take to double your money if it is invested at 6%? 6. If you invest $10,000 in a 20 year annuity paying 5%, what would be the annual payment made to you? 7. If you have a student loan...

Using MS Excel and the random number generator function, generate values for 30 observations for the...

Using MS Excel and the random number generator function, generate values for 30 observations for the following columns with average daily: Body weight with random values between 100 and 250lbs Calories intake with random values between 1000 and 3000 calories Workout duration with random values between 0 and 60 minutes Sleep duration with random values between 2 and 12 hours Work duration with random values between 0 and 12 hours Assuming that the values are averages over 1 year, conduct...

Solve the following LP problem using the Solver in MS Excel. A farmer wants to customize...

Solve the following LP problem using the Solver in MS Excel. A farmer wants to customize his fertilizer for his current crop. He can buy plant food mix A and plant food mix B. Each cubic yard of food A contains 20 pounds of phosphoric acid, 30 pounds of nitrogen and 5 pounds of potash. Each cubic yard of food B contains 10 pounds of phosphoric acid, 30 pounds of nitrogen and 10 pounds of potash. He requires a minimum...

Q2: Using MS Excel Analyze a regression of Air Quality on three covariates CO2, NOx, and...

Q2: Using MS Excel Analyze a regression of Air Quality on three covariates CO2, NOx, and Sox Data Set is as following Air Quality CO2 NOx SOx 197 61 22 17 191 33 16 27 224 65 18 18 183 55 18 32 236 50 26 23 200 60 24 26 226 59 16 25 164 54 22 24 100 83 10 17 285 50 21 29 207 73 22 21 336 61 26 35 299 42 36 21 192...

Solve the following LP problem using the Solver in MS Excel. A municipality has two incinerators...

Solve the following LP problem using the Solver in MS Excel. A municipality has two incinerators for burning trash . Incinerator A costs $3 .80 per ton of trash to operate, and has a capacity of 28 tons per day . Incinerator B costs $4 .25 per ton to operate, and has a capacity of 30 tons per day . The municipality produces over 100 tons of trash per day, and all trash not burned in the incinerators must be...

A) Using the scenario described by “Each store employs one or more employees; each employee is...

A) Using the scenario described by “Each store employs one or more employees; each employee is employed by one store”, work the following problems: 1. Identify each entity. 2. Identify each relationship type. Justify your answer. 3. Create the basic Crow's Foot ERD using Visio. B) Using the scenario described by “A job assignment can be assigned to more than one employee at a time; each employee can have only one job assignment”, work the following problems: 1. Identify each...

Subjects