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...
-
Dearman Clinics provides medical care in three departments: internal medicine (IM), pediatrics (PD), and obstetrics gynecology (OB). The estimated costs to run each department follow: Dearman expects...
-
An office car park has 12 parking spaces in a row. There are 9 cars to be parked. a. How many different arrangements are there for parking the 9 cars and leaving 3 empty spaces? b. How many different...
-
Fill in the Blank. The joint behavior of several random variables is described by the ____________ probability distribution function.
-
Houston Infonautics, Inc., produces handheld Windows CE -compatible organizers. Houston Infonautics markets three different handheld models: PalmPro is a souped-up version for the executive on the...
-
Suppose the function f and its derivative f' have values as given in the following table. 1 f(z) f(z) 8 10 221 3 4 7 19 52 6 7 8 9 4 6 20 3 17 8 15 14 8 13 14 Compute L* f(=)f (s) da Enter the exact...
-
The following table summarizes the operating results for Bene Petits first year of operations: Bene Petit First year operating data: Single (1 serving) Dual (2 servings) Family (4 servings) Total...
-
Let's define the following quantity, f(x + h) f(x - h) Dr 2h
-
You have 200 pigs to market at 250 lbs each. Overhead costs total $18,000. Feed costs are $10 per pig and other costs are $2 per pig. What price per pound is needed to breakeven?
-
You had a net farm income last year of $40,000. The opportunity cost for unpaid family labor and management on your farm was $30,000. Equity in the business was $200,000. What was your percent return...
-
Several years ago, Timmins Inc. issued $250,000 of 10-year bonds at a discount. The company decides to redeem the bonds at 98 when the amortized cost is $248,000. Would there be a gain or a loss on...
-
Mary From, single, owned rental real estate which generated a tax loss of $60,000. Mary materially participated in the rental activity. Mary's adjusted gross income before considering the $60,000...
-
Assume Theo Chocolate, a company that sells chocolate bars, has the following sales budget for quarter 1: January February March Sales Budget 12,500 16,000 21,000 Assume Theo Chocolate wants to have...
-
Write double entry for the given information. Creg works as an agent for a number of smaller contractors, earning commission of 10%. Creg's revenue includes $6,000 received from clients under these...
-
Banner Company acquires an 80% interest in Roller Company for $640,000 cash on January 1, 2013. The NCI has a fair value of $160,000. Any excess of cost over book value is attributed to goodwill. To...
-
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
-
What is a computer service center? Are the auditors of a client that uses a service center concerned about the controls applied at the organization? Explain.
-
What is a dual-purpose test?
-
If you were preparing a credit sales system flowchart, what document would you show as: a. The source for posting debits to a customers account in the accounts receivable ledger? b. Authorization to...
Study smarter with the SolutionInn App