Calculate Gross Salary (Rate/Hour Total Hours Worked), Tax Deduction of 25 % (Gross Salary 25%) and...
Fantastic news! We've Found the answer you've been seeking!
Question:
Transcribed Image Text:
Calculate Gross Salary (Rate/Hour Total Hours Worked), Tax Deduction of 25 % (Gross Salary 25%) and find the NET SALARY (Gross Salary-Tax Deduction) 2- What is the Total Net Salary? 3- What is the Minimum Salary? 4- What is the Maximum Salary? 5- What is the Average Salary? 6 How many employees inside the company? 7- How many employees received Net Salary more than 3500 TL? 8- Calculate the total salary which are <3500? 9-insert today date on top of the table. 10-Draw Bar chart according to the Name & Surname and Net Salary?(Create the chart on the same working sheet?) Emp 55 No. Name & Surname Status M/W 12350 S Adali 12351T ALTINTIS 12352 N ODOHAMA 12353 F KING 12354 M.PEACOCK 12356 A E VIDAL MMMWWW 10: Rate/Hour Total Hours WORKED Gross Salary(TL) Tax Deduction Net Salary (TL) 100 80 89 60 60 90 50 34 45 23 36 57 Calculate Gross Salary (Rate/Hour Total Hours Worked), Tax Deduction of 25 % (Gross Salary 25%) and find the NET SALARY (Gross Salary-Tax Deduction) 2- What is the Total Net Salary? 3- What is the Minimum Salary? 4- What is the Maximum Salary? 5- What is the Average Salary? 6 How many employees inside the company? 7- How many employees received Net Salary more than 3500 TL? 8- Calculate the total salary which are <3500? 9-insert today date on top of the table. 10-Draw Bar chart according to the Name & Surname and Net Salary?(Create the chart on the same working sheet?) Emp 55 No. Name & Surname Status M/W 12350 S Adali 12351T ALTINTIS 12352 N ODOHAMA 12353 F KING 12354 M.PEACOCK 12356 A E VIDAL MMMWWW 10: Rate/Hour Total Hours WORKED Gross Salary(TL) Tax Deduction Net Salary (TL) 100 80 89 60 60 90 50 34 45 23 36 57
Expert Answer:
Answer rating: 100% (QA)
SOLUTION 1 Todays Date 21st October 2023 Emp SS No Name Surname Status MW RateHour Total Hours Worke... View the full answer
Related Book For
Calculus And Its Applications
ISBN: 9780134437774
14th Edition
Authors: Larry Goldstein, David Lay, David Schneider, Nakhle Asmar
Posted Date:
Students also viewed these accounting questions
-
A firm has take a loan of $8000000 at an interest rate of 9% p.a. The term for repayment is 15 years. The loan payment is done using the amortization model. Present Cash flow table indicating the...
-
Managing Scope Changes Case Study Scope changes on a project can occur regardless of how well the project is planned or executed. Scope changes can be the result of something that was omitted during...
-
The following additional information is available for the Dr. Ivan and Irene Incisor family from Chapters 1-5. Ivan's grandfather died and left a portfolio of municipal bonds. In 2012, they pay Ivan...
-
To anticipate subsequent chapters where more complicated renewable resource models are introduced, consider a slight modification of the two-period depletable resource model. Suppose a biological...
-
Assuming a random effects model, show that E (SST r) = (r 1) (2 + r2r) for the Latin square design.
-
Which of the following statements about Jupiters motivations for the strategic real estate plan is incorrect? A. The transactions will enable Jupiter to sell a non-core business. B. The transactions...
-
a. Sketch possible arrangements for the piping and valves for Figure 14-6. Note that every tank needs to be able to receive fresh washwater or overflow from the next higher letter tank, except for...
-
Dayton Company is considering investing in an annuity contract that will return $45,000 annually at the end of each year for 15 years. What amount should Dayton Company pay for this investment if it...
-
Retirement Savings You believe you will spend $235,000 a year for 27 years once you retire in 22 years. If the interest rate is 3.70% per year. (Do not round intermediate calculations. Round your...
-
Required - Please submit the following two documents: 1. Using Excel, submit the following: i. ii. Calculate Rashmika's minimum net income for tax purposes in accordance with the ordering provisions...
-
Write a Java program that uses two classes (a Date class and a DateDriver class) to display a date to the screen. You must write two classes using two separate files for full credit.
-
Explain the principles underlying the design of catalytic reactors for heterogeneous reactions, considering mass transfer limitations and reaction kinetics.
-
Attached are the two copies of the statement. Your assignment is to read the statement (it is not too long) very carefully, and in one-page maximum, write an assessment of the stakeholder vs...
-
Calculate the Electric potential (V) due to an electron at distance 7.5 mm from any source: (Given K=8.99x10 Nm2C-2 and charge of electron is q = 1.6x10-19 C.)
-
The average trailing PE ratio of publicly traded auto parts companies in the US is 20.0. You own a regional auto parts firm in the Northwest that is privately held and has no debt. In the last year,...
-
You need to calculate the completed and removed from WIP Inventory - Mixing. Costs in beginning WIP inventory $1,700 Additional costs to finish units in beginning WIP inventory $400 Costs of units...
-
The escalator steps move with a constant speed of v = 0.6 m/s. (Figure 1) Part A If the steps are 125 mm high and 250 mm in length, determine the power of a motor needed to lift an average mass of...
-
According to a New York Times columnist, The estate tax affects a surprisingly small number of people. In 2003, . . . just 1.25 percent of all deaths resulted in taxable estates, with most of them...
-
For what values of p is convergent? 1 k k=1p
-
Set-up the definite integral that gives the area of the shaded region. Do not evaluate the integral. y y = x + // 1 3 y = x - X
-
Compute the numbers. (.01) 3
-
The price elasticity of demand is defined as the percentage change in _________ divided by the percentage change in _________.
-
The price elasticity of demand measures the responsiveness of quantity _________ to a change in price.
-
Describe and explain how demand and supply determine prices and the quantities that are bought and sold.
Study smarter with the SolutionInn App