PRAU8A1P1

profilejfmysjvfes691981
prau6_template.xlsx
Home>Business & Finance homework help>Accounting homework help>PRAU8A1P1

Excel Instructions

Excel Instructions using Excel 2010:
1. Enter the appropriate numbers/formulas in the shaded (gray) cells. An asterisk (*) will appear to the right of an incorrect answer.
2. A formula begins with an equals sign (=) and can consist of any of the following elements:
Operators such as + (for addition), - (for subtraction), * (for multiplication), and / (for division).
Cell references, including cell addresses such as B52, as well as named cells and ranges
Values and text
Worksheet functions (such as SUM)
3. You can enter a formula into a cell manually (typing it in) or by pointing to the cells.
To enter a formula manually, follow these steps:
Move the cell pointer to the cell that you want to hold the formula.
Type an equals sign (=) to signal the fact that the cell contains a formula.
Type the formula, then press Enter.
4. Rounding: These templates have been formatted to round numbers to either the nearest whole number or the nearest cent. For example,
17.65 x 1.5=26.475. The template will display and hold 26.48, not 26.475. There is no need to use Excel's rounding function.
EXCEPTION: Continuing Payroll Problems A & B: CHAPTER 2
When calculating over-time rate for weekly salary, round regular rate to TWO decimals BEFORE calculating overtime rate.
Rounding can be accomplished by using Number function (using arrows) on Excel Home menu or by entering the formula
=(Round(Weekly/40,2))*1.5 (where "Weekly" entered as either the weekly pay or cell reference.)
Failure to use the ROUND function will cause the OT rate to be incorrect.
5. Remember to save your work. When saving your workbook, Excel overwrites the previous copy of your file. You can save your work at any time.
You can save the file to the current name, or you may want to keep multiple versions of your work by saving each successive version under a different name.
To save to the current name, you can select File, Save from the menu bar or click on the disk icon in the standard toolbar.
It is recommended that you save the file to a new name that identifies the file as yours, such as Excel_End_of_Chapter_Problems_Your_Name.xlsx
To save under a different name, follow these steps:
Select File, Save As to display the Save As Type drop-box, chose Excel Workbook (*.xlsx)
Select the folder in which to store the workbook.
Enter the new filename in the File name box.
Click Save.

5-2A

Name:
Enter the appropriate numbers/formulas in the shaded (gray) cells.
An asterisk (*) will appear to the right of an incorrect answer.
5-2A
Total payroll 737910
Less: Wages paid in excess of $7,000 472120
Earnings subject to FUTA and SUTA $ 265,790
Taxable Tax
Earnings x Rate = Tax
Net FUTA tax $ 265,790 0.006 1594.74
Net SUTA tax 265,790 0.029 7707.91
Total unemployment taxes $ 9,302.65
Student Work Area Instructor Comment/Grade Area

5-4A

Name:
Enter the appropriate numbers/formulas in the shaded (gray) cells.
An asterisk (*) will appear to the right of an incorrect answer.
5-4A
Taxable Tax
Earnings x Rate = Tax
(a) SUTA taxes paid to Massachusetts
Ros Hill: Enter as a formula: taxable Earnings times tax rate. 		$ 18,000 0.04 720.00
(b) SUTA taxes paid to New Hampshire $ 24,000 0.0265 636.00
(c) SUTA taxes paid to Maine $ 79,000 0.029 2291.00
(d) FUTA taxes paid $ 103,500 0.006 621.00
Student Work Area Instructor Comment/Grade Area

5-14A

Name:
Enter the appropriate numbers/formulas in the shaded (gray) cells, or select from the drop-down list.
An asterisk (*) will appear to the right of an incorrect answer. Student Work Area
5-14A OASDI HI
EE 0.062 0.0145
(a) Taxable OASDI HI ER 0.062 0.0145
Earnings (6.2%) (1.45%)
M. Grady
Mark Sears: For this column, insert answers as a formula of taxable earnings x tax rate
P. Monroe
V. Hoffman
Mark Sears: Insert as a formula converting monthly salary to a yearly salary and dividing by number of weeks in year 		392.31
Mark Sears: Insert as a formula converting monthly salary to a yearly salary and dividing by number of weeks in year 		24.32 5.69
A. Drugan
Mark Sears: Insert as a formula dividing yearly salary by number of weeks in year
Mark Sears: For this column, insert answers as a formula of taxable earnings x tax rate 		288.46
Mark Sears: Insert as a formula dividing yearly salary by number of weeks in year 		17.88 4.18
G. Beiter 180.00 11.16 2.61
S. Egan 220.00 13.64 3.19
B. Lin 160.00 9.92 2.32
(b) Taxable Tax Instructor Comment/Grade Area
Earnings x Rate = Tax
Employer's OASDI tax $ 1,240.77 0.0620 76.93
Employer's HI tax $ 1,240.77 0.0145 $ 17.99
(c) Taxable Tax
Taxable earnings: Earnings x Rate = SUTA Tax
G. Beiter $ 180.00
B. Lin 160.00
Total $ 340.00 0.0310 $ 10.54
(d) Taxable Tax
Taxable earnings: Earnings x Rate = FUTA Tax

Mark Sears: Only one employee has not exceeded wages in excess of $7,000
Mark Sears: Insert as a formula converting monthly salary to a yearly salary and dividing by number of weeks in year
Mark Sears: Insert as a formula dividing yearly salary by number of weeks in year
Mark Sears: Only two employees have not exceeded wages in excess of $8,100 		B. Lin $ 160.00 0.0060 0.96
(e) Total employer payroll taxes:
FICA 94.92
SUTA 10.54
FUTA 0.96
Total payroll taxes $ 106.42