Kelley_2020 annotated EOC Chapter 2_final
xlsx
keyboard_arrow_up
School
Paradise Valley Community College *
*We aren’t endorsed by this school
Course
ACC222
Subject
Mathematics
Date
Feb 20, 2024
Type
xlsx
Pages
13
Uploaded by JudgePelicanPerson503
Excel Instructions:
1. Enter the appropriate numbers/formulas in the shaded (gray) cells. An asterisk (*) will appear to the right of an incor
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.
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 func
EXCEPTION: Continuing Payroll Problems A & B: When calculating over-time rate for weekly salary, round regular rate to TWO decimals BEFORE calc
Rounding can be accomplished by using Number function (using arrows) on Excel Home menu or by e
=(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
You can save the file to the current name, or you may want to keep multiple versions of your work by saving each succes
To save to the current name, you can select File, Save from the menu bar or click on the disk icon in the standard toolba
It is recommended that you save the file to a new name that identifies the file as yours, such as Excel_End_of_Chapter_Pr
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.
4. Rounding
: These templates have been formatted to round numbers to either the nearest whole number or the neare
rrect answer.
ction.
culating overtime rate.
entering the formula
n save your work at any time. ssive version under a different name.
ar. roblems_Your_Name.xlsx
est cent. For example,
Name:
Enter the appropriate numbers/formulas in the shaded (gray) cells. An asterisk (*) will appear to the
right of an incorrect answer.
Student Work Area
2-3A
Kagan Company
Employee
Darley, R.
38
$ 11.70 $ 444.60 Waxman, B
40
12.35 494.00 Isaac, J.
37
13.00 481.00 Bruner, H.
40
10.75 430.00 Kellogg, P.
32 1/2
12.40 403.00 (b) Total gross earnings………………
$ 2,252.60 Instructor Comment/Grade Area
Hours Worked
Regular Hourly Wage Rate
(a) Gross Earnings
Your preview ends here
Eager to read complete document? Join bartleby learn and gain access to the full version
- Access to all documents
- Unlimited textbook solutions
- 24/7 expert homework help
Name:
4
Enter the appropriate numbers/formulas in the shaded (gray) cells. An asterisk (*) will appear to the
right of an incorrect answer.
Student Work Area
2-3B
Koogel Company
Employee
Duffy, M.
35
$ 11.90 $ 416.50 Hazelton, G.
28
14.15 396.20 Inman, T.
39 1/2
10.90 430.55 Palmer, C.
24 1/2
16.40 401.80 Diaz, O.
31 12.90 399.90 (b) Total gross earnings………………
$ 2,044.95 Instructor Comment/Grade Area
Hours Worked
Regular Hourly Wage Rate
(a) Gross Earnings
Your preview ends here
Eager to read complete document? Join bartleby learn and gain access to the full version
- Access to all documents
- Unlimited textbook solutions
- 24/7 expert homework help
Name:
Enter the appropriate numbers/formulas in the shaded (gray) cells. An asterisk (*) will appear to the
right of an incorrect answer.
2-4A
McNeese Enterprises
Employee
Carman, T.
47
$ 12.45 $ 498.00 $ 18.68 $ 130.76 $ 628.76 Galasso, A.
42
11.90 476.00 $ 17.85 $ 35.70 $ 511.70 Jones, B.
48
10.85 434.00 $ 16.28 $ 130.24 $ 564.24 Rodna, G.
44
11.25 450.00 $ 16.88 $ 67.52 $ 517.52 Wilmon, W.
45 1/2
13.40 536.00 $ 20.10 $ 110.55 $ 646.55 (b) Total gross earnings…………………….….
$ 2,868.77 Student Work Area
Instructor Comment/Grade Area
Hours Worked
Regular Hourly Wage Rate
Regular Earnings
Overtime Rate
Overtime Earnings
Total Gross Earnings
Name:
Enter the appropriate numbers/formulas in the shaded (gray) cells. An asterisk (*) will appear to the
right of an incorrect answer.
2-4B
Somja Enterprises
Employee
Wilson, H.
43
$ 11.90 $ 476.00 $ 17.85 $ 53.55 $ 529.55 Aha, C.
42
14.20 568.00 $ 21.30 $ 42.60 $ 610.60 Shoup, K.
47
13.90 556.00 $ 20.85 $ 145.95 $ 701.95 Carlyn, D.
41 1/2
10.70 428.00 $ 16.05 $ 24.08 $ 452.08 McMurray, J.
45
17.10 684.00 $ 25.65 $ 128.25 $ 812.25 (b) Total gross earnings…………………….….
$ 3,106.43 Student Work Area
Instructor Comment/Grade Area
Hours Worked
Regular Hourly Wage Rate
Regular Earnings
Overtime Rate
Overtime Earnings
Total Gross Earnings
Name:
Enter the appropriate numbers/formulas in the shaded (gray) cells. An asterisk (*) will appear to the
right of an incorrect answer.
Student Work Area
2-17A
(a) Piecework earnings …………………………………………
$ 573.75 (b) Regular hourly rate……………………… $ 12.61 Overtime hourly rate…………………… $ 6.31 (c) Overtime earnings………………………………………..
34.71 (d) Total earnings………………
$ 608.46 Instructor Comment/Grade Area
Your preview ends here
Eager to read complete document? Join bartleby learn and gain access to the full version
- Access to all documents
- Unlimited textbook solutions
- 24/7 expert homework help
Name:
Enter the appropriate numbers/formulas in the shaded (gray) cells. An asterisk (*) will appear to the
right of an incorrect answer.
Student Work Area
2-17B
(a) Piecework earnings …………………………………………
$ 551.00 (b) Regular hourly rate……………………… $ 11.98 Overtime hourly rate…………………… $ 5.99 (c) Overtime earnings………………………………………..
35.94 (d) Total earnings………………
$ 586.94 Instructor Comment/Grade Area
Name:
Enter the appropriate numbers/formulas in the shaded (gray) cells. An asterisk (*) will appear to the
right of an incorrect answer.
Student Work Area
2-19A
(a) Regular annual Salary…...……………………………….
$ 29,500.00 (b) Commission on sales up to $50,000 above quota…………………………….
$ 4,250.00 Commission on sales beyond
$200,000…………………………………
$ 9,500.00 Total commission………………………………………….
13,750.00 (c) Total annual earnings…………….
$ 43,250.00 Instructor Comment/Grade Area
Your preview ends here
Eager to read complete document? Join bartleby learn and gain access to the full version
- Access to all documents
- Unlimited textbook solutions
- 24/7 expert homework help
Name:
Enter the appropriate numbers/formulas in the shaded (gray) cells. An asterisk (*) will appear to the
right of an incorrect answer.
Student Work Area
2-19B
(a) Regular annual Salary…...……………………………….
$ 34,500.00 (b) Commission on sales up to $50,000 above quota…………………………….
$ 4,750.00 Commission on sales beyond
$200,000…………………………………
$ 13,800.00 Total commission………………………………………….
18,550.00 (c) Total annual earnings…………….
$ 53,050.00 Instructor Comment/Grade Area