For the standard deductions, there are specified contribution tables to be followed as discussed in the...
Fantastic news! We've Found the answer you've been seeking!
Question:
Transcribed Image Text:
➤ For the standard deductions, there are specified contribution tables to be followed as discussed in the previous modules. More examples: 1. Compute for Tita Pau's monthly, semi-monthly, weekly and bi-weekly salary using Hint: It is easier to solve this problem if you have the annual salary. Enter the formula starting with B2 up to F2 (as shown below). spreadsheet. B с Name Annual Salary Monthly Salary 2 Paula U. Lobo =C2*12 P45,269.00 A A Name 1 2 Magpayo, Lyn 3 Quiambao, Jhaz 4 Cruz, Russel 5 Garcia, Geth 6 Nicdao, Maine 7 Mendoza, Rhoda 8 Mallari, Tes 9 Santos, Paula 10 Urbano, Janeen 2. In EY EL PI Company, employees are paid 125% of their hourly regular payment in excess of 8- hour work. Compute for the employees' total income for the week. See the table below. Monthly salary B 10 9 Hourly Rate 8 P40.00 9 P45.00 150.00 8 8 P55.00 8 9 P60.00 P55.00 P50.00 9 10 12 P45.00 8 10 11 P40.00 8 10 For Overtime hours: D F G E C Mon Tue Wed Thu Fri 12 8 8 12 9 8 10 8 8 A Name 0006 2 Magpayo, Lyn 3 Quiambao, Jhaz 4 Cruz, Russel 5 Garcia, Geth 8 Mallari, Tes 9 Santos, Paula 10 Urbano, Janeen 9 10 12 8 9 8 10 9 10 12 C2220 B Hourly Rate 6 Nicdao, Maine P60.00 Mendoza, Rhoda P55.00 150.00 P45.00 P40.00 For the Total Hours: In H2, type "=sum(", then click on C2 to G2 or type "=sum(C2:G2)" For Regular Hours: Since there should be 8 hours in 5 days, type =8*5, then enter 18 L P40.00 8 P45.00 P50.00| P55.00 11 12 9 12 ∞∞00.00 Subtract regular hours from the total hours. Thus, in J2, type =H2-12, enter. For the Regular Pay (in a week) Multiply the hourly rate by the regular hours. Thus, in K2, type =B2*12,enter. For the Overtime Pay: Multiply the hourly rate by the overtime hours by 125%. Thus, in L2, type=B2*12*1.25,then enter. For the Total Income: Add the regular pay and overtime pay. Thus, in M2, type =K2+L2, then enter, or =sum(K2:L2) then enter. 10. DO NOT forget to drag down to compute the rest of employees' data and get this: 000000000006 9 8 12 9 11 8 C D E F G Mon Tue Wed Thu Fri 10 9 10 98989999 Summ Y olololole 10 10 10 10 D Semi- Monthly =B2/24 8980 H K Total Regular Overtime Regular Overtime Pay hours Hours pay Hours 17 8 8 9 10 10 12 8 48 12 8 12 51 12 9 11 51 11 49 12 51 BO 12 + Annual Salary 22889 lolo E F Weekly Bi- Salary weekly =B2/52 =B2/26 TTT 2112 9 11 9 M Total Income L H Total Regular Overtime Regular Overtime Hours hours Hours Pay 40 46 47 40 41 40 45 40 40 40 40 40 40 mical M Total Income pay 6 P1,600.00 P300.00 P1,900.00 7 P1,800.00 P393.75 P2,193.75 1 P2,000.00 P62.50 P2,062.50 5 8 11 11 P2,200.00 P343.75 P2,543.75 P2,400.00 P600.00 P3,000.00 P2,200.00 P756.25 P2,956.25 P2,000.00 P687.50 P2,687.50 P1,800.00 P506.25 P2,306.25 P1,600.00 P550.00 2,150.00 1 php 60. 9 11 WRITTEN WORK # 15 1 Name Activity 1. Spread my Salary Direction: The data below shows the partial salary of employees. Complete the table to showtheir annual, monthly, semi/weekly and bi-weekly salary. Use excel. (Show the formula) Marites Janice Lyn Leo Flor Name 2 3 4 Magpayo, Lyn 5 Quiambao, Jhaz 6 Cruz, Russel 7 Garcia, Geth 8 Nicdao, Maine 9 Mendoza, Rhoda Annual Salary 10 Mallari, Tes 11 Santos, Paula 2 Urbano, Janeen P96,000 Monthly Salary B INCOME P40,000 Basic Monthly Salary P20,000.00 P25,000.00 nitial P30,000.00 P40,000.00 P45,000.00 150,000.00 P55,000.00 P60,000.00 P65,000.00 Activity 2. Spread my Salary Direction: Using the spreadsheet, compute for the corresponding contributions of the followingemployees. Compute also their total deduction. (Show the formula) 27 A E F SSS 4% Semi- Monthly P5,000 Weekly Salary P20,000 G DEDUCTIONS Bi- weekly P11,538 PHILHEALTH PAGIBIG 1.50% 2% ich enth TAX 12% itulaz Total Deductions #ed1 14 ➤ For the standard deductions, there are specified contribution tables to be followed as discussed in the previous modules. More examples: 1. Compute for Tita Pau's monthly, semi-monthly, weekly and bi-weekly salary using Hint: It is easier to solve this problem if you have the annual salary. Enter the formula starting with B2 up to F2 (as shown below). spreadsheet. B с Name Annual Salary Monthly Salary 2 Paula U. Lobo =C2*12 P45,269.00 A A Name 1 2 Magpayo, Lyn 3 Quiambao, Jhaz 4 Cruz, Russel 5 Garcia, Geth 6 Nicdao, Maine 7 Mendoza, Rhoda 8 Mallari, Tes 9 Santos, Paula 10 Urbano, Janeen 2. In EY EL PI Company, employees are paid 125% of their hourly regular payment in excess of 8- hour work. Compute for the employees' total income for the week. See the table below. Monthly salary B 10 9 Hourly Rate 8 P40.00 9 P45.00 150.00 8 8 P55.00 8 9 P60.00 P55.00 P50.00 9 10 12 P45.00 8 10 11 P40.00 8 10 For Overtime hours: D F G E C Mon Tue Wed Thu Fri 12 8 8 12 9 8 10 8 8 A Name 0006 2 Magpayo, Lyn 3 Quiambao, Jhaz 4 Cruz, Russel 5 Garcia, Geth 8 Mallari, Tes 9 Santos, Paula 10 Urbano, Janeen 9 10 12 8 9 8 10 9 10 12 C2220 B Hourly Rate 6 Nicdao, Maine P60.00 Mendoza, Rhoda P55.00 150.00 P45.00 P40.00 For the Total Hours: In H2, type "=sum(", then click on C2 to G2 or type "=sum(C2:G2)" For Regular Hours: Since there should be 8 hours in 5 days, type =8*5, then enter 18 L P40.00 8 P45.00 P50.00| P55.00 11 12 9 12 ∞∞00.00 Subtract regular hours from the total hours. Thus, in J2, type =H2-12, enter. For the Regular Pay (in a week) Multiply the hourly rate by the regular hours. Thus, in K2, type =B2*12,enter. For the Overtime Pay: Multiply the hourly rate by the overtime hours by 125%. Thus, in L2, type=B2*12*1.25,then enter. For the Total Income: Add the regular pay and overtime pay. Thus, in M2, type =K2+L2, then enter, or =sum(K2:L2) then enter. 10. DO NOT forget to drag down to compute the rest of employees' data and get this: 000000000006 9 8 12 9 11 8 C D E F G Mon Tue Wed Thu Fri 10 9 10 98989999 Summ Y olololole 10 10 10 10 D Semi- Monthly =B2/24 8980 H K Total Regular Overtime Regular Overtime Pay hours Hours pay Hours 17 8 8 9 10 10 12 8 48 12 8 12 51 12 9 11 51 11 49 12 51 BO 12 + Annual Salary 22889 lolo E F Weekly Bi- Salary weekly =B2/52 =B2/26 TTT 2112 9 11 9 M Total Income L H Total Regular Overtime Regular Overtime Hours hours Hours Pay 40 46 47 40 41 40 45 40 40 40 40 40 40 mical M Total Income pay 6 P1,600.00 P300.00 P1,900.00 7 P1,800.00 P393.75 P2,193.75 1 P2,000.00 P62.50 P2,062.50 5 8 11 11 P2,200.00 P343.75 P2,543.75 P2,400.00 P600.00 P3,000.00 P2,200.00 P756.25 P2,956.25 P2,000.00 P687.50 P2,687.50 P1,800.00 P506.25 P2,306.25 P1,600.00 P550.00 2,150.00 1 php 60. 9 11 WRITTEN WORK # 15 1 Name Activity 1. Spread my Salary Direction: The data below shows the partial salary of employees. Complete the table to showtheir annual, monthly, semi/weekly and bi-weekly salary. Use excel. (Show the formula) Marites Janice Lyn Leo Flor Name 2 3 4 Magpayo, Lyn 5 Quiambao, Jhaz 6 Cruz, Russel 7 Garcia, Geth 8 Nicdao, Maine 9 Mendoza, Rhoda Annual Salary 10 Mallari, Tes 11 Santos, Paula 2 Urbano, Janeen P96,000 Monthly Salary B INCOME P40,000 Basic Monthly Salary P20,000.00 P25,000.00 nitial P30,000.00 P40,000.00 P45,000.00 150,000.00 P55,000.00 P60,000.00 P65,000.00 Activity 2. Spread my Salary Direction: Using the spreadsheet, compute for the corresponding contributions of the followingemployees. Compute also their total deduction. (Show the formula) 27 A E F SSS 4% Semi- Monthly P5,000 Weekly Salary P20,000 G DEDUCTIONS Bi- weekly P11,538 PHILHEALTH PAGIBIG 1.50% 2% ich enth TAX 12% itulaz Total Deductions #ed1 14
Expert Answer:
Related Book For
Income Tax Fundamentals 2013
ISBN: 9781285586618
31st Edition
Authors: Gerald E. Whittenburg, Martha Altus Buller, Steven L Gill
Posted Date:
Students also viewed these accounting questions
-
As discussed in the previous question, Lewis Wolff and his investment group bought the Oakland As baseball team for $180 million in 2005. Reportedly, Hall-of-Famer Reggie Jackson offered $25 million...
-
If you have the annual worth of an alternative with a 5-year life, you can calculate its perpetual annual worth by: (a) No calculation needed. The perpetual annual worth is equal to the annual worth...
-
Paula Shoemaker produces a weekly stock market report for an exclusive readership. She normally sells 3,000 reports per week, and 70% of the time her sales range from 2,900 to 3,100. The report costs...
-
Swish Designs specialises in designing commercial office space in Auckland. The CEO, Ralph Polo has reviewed the financial results and has noticed that operating profits were below budget. He also...
-
What is the current yield on each of the bonds in the previous problem?
-
A waste heat recovery heat exchanger ( also called a recuperator ) is to be installed in a boiler system of a geothermal cogeneration plant. The initial cost of the recuperator is $ 1 4 , 0 0 0 . It...
-
Use the closeness ratings given after the activity (CloseAfter) to estimate the difference in mean rating of closeness between those who have just done a synchronized activity and those who do a...
-
Plum Corporation will begin operations on January 1. Earnings for the next five years are projected to be relatively stable at about $80,000 per year. The shareholders of Plum are in the 33% tax...
-
You will deposit $2,000 at the end of each of next 3 years. If the interest rate is 10% (annual compounding), how much will you have accumulated in 26 years?
-
Golden Corporation's current year income statement, comparative balance sheets, and additional information follow. For the year, (1) all sales are credit sales, (2) all credits to Accounts Receivable...
-
Michael invested $4,000 in a certificate of deposit that paid annual interest. After 3 years, the money has accumulated to $4,480. What was the annual interest rate? Group of answer choices 4% 1% 2%...
-
a) Why is inventory management important? How does mismanaged inventory leads to costs to any organisation? (10 marks) Give examples to justify your answers. (Please answer in 200-300 words). b) Reem...
-
A person is spinning an object around on a circular path on the end of a string of length, 0 . 8 3 m . The object has a mass of 0 . 2 1 kg and is moving at a speed of 3 . 0 m / s . Calculate the...
-
A table has sold for $670 (15% VAT inclusive). Calculate the new setting price of this table if the VAT was raised to 17.5%
-
A Ferris wheel starts spinning at t=0 s and stops at t = 12 s. If the Ferris wheel made 5 loops during that time, what is its period, k?
-
A constant tangential force of magnitude 50 N is applied to the edge of a merry-go-round. What is the work done by the torque due to the force, in J, by the time the merry-go-round makes two...
-
Central Company has gathered the following information. Production and Manufacturing Costs Equivalent Units and Cost Information Units in beginning work in process Units started into production Units...
-
Accounting policies and practices that are most important to the portrayal of the companys financial condition and results, and require managements most difficult, subjective, or complex judgments...
-
Frederick (Freddy) Freeweights (age 42) owns and operates a health club called ''Treadmills West.'' The business is located at 4321 Arnold Street, Alpine, CA 91901. Freddy had the following income...
-
During 2012, William purchases the following capital assets for use in his catering business: New passenger automobile (September 30)........................$21,500 Baking equipment (June 30)...
-
Deborah purchases a new $30,000 car in 2012 to use exclusively in her business. If Deborah does not elect to expense or take bonus depreciation in 2012 and holds the car until it is fully...
-
Wallace and Hussain type estimators for the variance components of a one-way unbalanced panel data model. (a) Verify the \(E\left(\widehat{q}_{1} ight)\) and \(E\left(\widehat{q}_{2} ight)\)...
-
Using the Monte Carlo setup for the unbalanced one-way error component model considered by Baltagi and Chang (1994), compare the various estimators of the variance components and the regression...
-
Using the Harrison and Rubinfeld (1978) data published in Belsley, Kuh and Welsch (1980) and provided on the Springer website as Hedonic.xls, reproduce Table 9.1. Perform the Hausman test based on...
Study smarter with the SolutionInn App