Chapter 8 - 8.1 a. Salary $21,811 Address 678 Fig Ave...

Info iconThis preview shows pages 1–6. Sign up to view the full content.

View Full Document Right Arrow Icon

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full DocumentRight Arrow Icon

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full DocumentRight Arrow Icon

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full DocumentRight Arrow Icon
This is the end of the preview. Sign up to access the rest of the document.

Unformatted text preview: 8.1 a. Salary $21,811 Address 678 Fig Ave Schiller Park, IL 98272 Check Number 6/1/17 11083 Check Amount 6/1/17 $653.76 Federal Withholding 11/1/17 $49.94 b. Carol is using 1 exemption c. 2017 $418,660.23 2018 $438,710.58 d. 28 employees on the historical list 29 employees on the employee list The difference may be that an employee just started and has not been paid yet. 8.3 a. Chicago is the highest with $77090, and Lake Forest is second with $55638 b. 8.4 c. d. 2 states, IL and IN 8.5 a. Account 10400, Inventory b. Account 30400, COGS c. $48 per unit d. Item BB-319, Basteball Nets, $9 The number of employees from each city is also a main factor as well as the location of higher level employees who get paid more. The pivot table with state as columns and city as rows is much more functional and easier to read. The data is organized in a way that it shows the multiple cities in each state rather than all scattered. It also fits on one page. Fabrikam Employees with a September birthday Last Name First Name Address 1 Address 2 City Zip Code Birth Month Philips Carol 678 16th Street Chicago 60600 9 Young Rob 654 22nd Street Chicago 60600 9 Sum - UPR TRX Amount City State Bloomington Bolingbrook Carmel Chicago Des Moines Detroit Elmwood Park Evanston Excelsior Fort Wayne Glenview Highland Park Lake Forest Lee's Summit McHenry Mundelein Omaha Schiller Park Springfield Wauwatosa Winnetka Total Result IA $20,247.28 $20,247.28 IL $16,569.03 $12,966.01 $77,090.99 $10,782.80 $9,097.95 $11,713.81 $13,488.07 $55,638.65 $9,365.62 $11,186.31 $13,052.16 $17,605.24 $14,592.75 $273,149.39 IN $24,193.72 $20,562.13 $44,755.85 MI $21,243.51 $21,243.51 MN $25,731.58 $25,731.58 MO $18,426.80 $18,426.80 NE $47,095.94 $47,095.94 WI $21,200.71 $21,200.71 Total Result $16,569.03 $12,966.01 ### ### $20,247.28 ### $10,782.80 $9,097.95 ### $20,562.13 $11,713.81 $13,488.07 $55,638.65 $18,426.80 $9,365.62 $11,186.31 ### $13,052.16 $17,605.24 $21,200.71 $14,592.75 $471,851.06 Sum - UPR TRX Amount State City IA IL IN MI MN MO NE WI Total Result Bloomington $16,569.03 $16,569.03 Bolingbrook $12,966.01 $12,966.01 Carmel $24,193.72 $24,193.72 Chicago $77,090.99 $77,090.99 Des Moines $20,247.28 $20,247.28 Detroit $21,243.51 $21,243.51 Elmwood Park $10,782.80 $10,782.80 Evanston $9,097.95 $9,097.95 Excelsior $25,731.58 $25,731.58 Fort Wayne $20,562.13 $20,562.13 Glenview $11,713.81 $11,713.81 Highland Park $13,488.07 $13,488.07 Lake Forest $55,638.65 $55,638.65 Lee's Summit $18,426.80 $18,426.80 McHenry $9,365.62 $9,365.62 Mundelein $11,186.31 $11,186.31 Omaha $47,095.94 $47,095.94 Schiller Park $13,052.16 $13,052.16 Springfield $17,605.24 $17,605.24 Wauwatosa ### $21,200.71 Winnetka $14,592.75 $14,592.75 Total Result $20,247.28 $273,149.39 ### ### ### ### ### ### $471,851.06 UPR TRX Amount City State Check Date $0.0 EvanstonIL 1/1/2017 $0.0 Glenview IL 1/1/2017 $0.0 Bolingbro IL 1/1/2017 $0.0 Schiler P IL 1/1/2017 $0.0 Blo mingt IL 1/1/2017 $0.0 SpringfieldIL 2/1/2017 $0.0 Highland PIL$0....
View Full Document

This note was uploaded on 02/19/2012 for the course ACCOUNTING 321 taught by Professor Rich during the Spring '12 term at Columbia College.

Page1 / 12

Chapter 8 - 8.1 a. Salary $21,811 Address 678 Fig Ave...

This preview shows document pages 1 - 6. Sign up to view the full document.

View Full Document Right Arrow Icon
Ask a homework question - tutors are online