I need help with part 2 item 1 please. I have screen shotted the documents required.

The attached spreadsheet (CrookEd Salary Expenses 2011-2014) contains the data you discovered. The first tab is a Summary of data from 2004 2007. Payroll is broken into four categories: Management; Office; Sales; Pipeline.

The second tab is titled Detail. It is unclear to you if the Summary Data equates to the Detail. Likewise, at first glance, there are some questions you have related to the Summary data. Consequently, you and your team must to do the following:

Part 1:

1. Scan the Summary data, make some observations and perform any relevant analysis on the data. For this portion of the assignment consider Fraud Examination, 5th Edition Chapters 6 Data-Driven Fraud Detection
2. From the Detail tab data, create a Pivot Table and manipulate the data to determine if this data is the same as the data in the Summary tab. Create any additional inferences and make any other observations. For this portion of the assignment consider Fraud Examination, 5th Edition Chapters 6 Data-Driven Fraud Detection

Part 2:

1. From your work in 1 and 2 above, create a set of questions you would like to ask the CFO of CrookEd (your instructor) specifically pertaining to the payroll data you have reviewed. For this portion of the assignment consider Fraud Examination, 5th Edition Chapters 10 Inquiry Methods and Fraud Reports.
2. Based on your data analysis and interview write a two page memo describing your techniques, observations and conclusions. Include any questions you still have and information you would still like to obtain.

Data Driven Summary Saved to this PC AutoSave Ajia Gaspard AG File Mailings Design Layout References Review View Help pSearch Share Comments Home Insert Draw OFind Cat 12 A A Aa Ap EE AaBbCcl AaBbCcl AaBbC AaBb AaBbCcD Arial AaBbCcD AaBbCc AaBbCc b Replace Paste Copy Tormat Painler 1 Normal 1 No Spac Dictate IUab , * Subtle Em.. Emphasis A Heading ading 2 Heading 3 itle Subtitle Select . Fsgraph dipbcard Styles Edi ing Voice Font 7 S 2 6. Data-Driven Fraud Detection Create any additional inferences and make any other observations Part 1, Item 2 A pivot table was created to determine is the Summary tab and Data tab was the same. Unfortunately, the data is different. In years 2004 2006 the percentages were the same but the departments were different. On the Summary tab listed Pipeline but the newly created pivot table Warehouse. There are several red flags. I am not sure of the department difference as additional information has not been provided at this time. Related to the percentage based an the annual expenses, the Summary tab and pivot table are the same for 2004 2006. In 2007, there are percentage differences Department 6725 Salary Management 6740 Salary Pipeline Summary 4% 7% Pivot 10% 0% Additional data must be collected to analyze the difference for the above information and confirmation of the departments. Once the data is analyzed, the results will be provided. If it is discovered that anomalies and/or frauds have been identified, an investigation will be conducted. Page 1 of 1172 words HE 100% Focus 12:48 PM O Type here to search 99. 9/2/2019 AutoSave H Salary Expenses 2004 2007 Excel Ajia Gaspard AG File Formulas Review View Help Search Share Home Insert Draw Page Layout Data Comments Cut AutoSum 11 bWrap Text A A Calibri Pcrcentage Fill Clear Copy Faste Conditional Format as FormattingTable Insert Delete Format A Cell Sort & Find & Ideas B IU Merge & Center E $% Format Painter Filter Select Aligmen dipbd Number Styles Cels Edting Idess Fonl 01 A B C D F F G K L N O C O CrookEd Salary Expense from General Ledger 2004 2007 1 Monthly Summaries 2 3 Total 4 2004 1 4 6 7 9 10 11 12 Summary PVT 100% 264,704 194,467 145,970 140,494 337,359 2,324,892 23 138,749 141,256 327,489 209,730 137,299 143,623 143,750 100% 24 Total 25 2007 1 2 3 4 5 6 7 8 9 10 11 12 157,170 98,905 26 6720 Salary - Commissions 143,535 1,105 205 200 154,584 27,121 582.825 21% 21% 276/25 5alary- Manapement 7,385 11,077 7,547 7,385 7,385 12,960 101,792 11,077 7,385 7,385 7,385 7,439 7,385 4% 10% 23,417 21,699 21,069 20,107 19,242 31,476 276,977 28 6730 Salary- Office 20,859 20,686 22,295 22,668 33,163 20,298 10% 10% 119,286 125,550 26,858 185,078 127,811 128,148 29 6/35 Salary- Sales 173,813 119,255 118,513 (0) 119,070 124,474 126,528 196,281 23,032 1,663,807 59% 59% 26,976 (27,804) 30 6740 5alary-Pipeline (0) 273,022 26,982 22,624 23,184 189,231 7% C 40,383 26,995 148,339 146,756 426,871 183,422 178,463 176,339 240,034 100% 31 351,842 176,929 182,842 329.773 2,814,631 32 33 34 35 36 37 38 39 40 41 Summary PVT Detail 120% 12:49 PM O Type here to search 9/2/2019 AutoSave H Salary Expensas 2004 2007 Excel Ajia Gaspard AG PivatTable Analyze File Formulas Review View Help Design Search Share Comments Home Insert Draw Page Layout Data Cut AutoSum 11 gbWrap Text A A Calibri General Copy Fill Conditional Tormat as Formatting Table Styles Insert Delete Format Faste Cell Sort & Find & Ideas E 2E Merge & Center B IU A Clear Format Painter Filter Select Aligrmen dipbod Number Styles Cels Edting Idess Fonl 6740 Salary Warehouse A32 A C D F G H K M N O Q 1 CrookEd Salary Expense from General Ledger 2004 2007 2 Monthly Summaries 3 4 DATF 2004 5 6 Sum of AMOUNT MONTH 7G/L ACCOUNT 86725 Salary - Management 9 6/30 Salary - Office 10 6735 Salary Sales 11 6740 Salary Warehouse 1 12 Grand Total 2 3 4 5 6 8 10 11 5.538.48 2,769.24 15.377.09 22.146.12 2,769.24 11.692.30 5,538.45 102,014.52 1,205.40 78,007.24 4,153.86 62,816.32 23,615.80 3,692.30 303,813.15 13% 26,618.54 29,940.48 26,887.03 11,952.77 19,856.27 10,134.23 17,536.93 19,050.02 72,713.11 41,498.38 313,710.97 13% 143,686.69 51,086.89 76,966.14 100,177.77 88,258.89 47,025.94 115,445.61 12,401.42 83,649.41 172,684.37 79,791.99 25,668.82 54,777.89 917,051.95 39% 55,443,90 77,311.89 66,674.53 49,775.48 71,791.36 62,822.34 104,704.99 70,739.56 57,478.60 57,644.79 808,957.32 35% 100 % 12 Grand Total 318,308.94 119,008.70 175,057.48 252,434.97 225,389.39 117,191.85 229,657.24 91,706.55 186,516.78 371,060.80 134,050.20 123,150.49 2,343,533.39 13 14 15 DATE 2005 16 17 Sum of AMOUNT Column La 18 Row Labels 1 2 3 4 5 6 7 8 9 10 11 12 Grand Total 19 6725 Salary Management 71,628.32 22,880.00 7,692.30 7,692.30 44,474.84 3,692.30 45,455.65 3,692.30 11,384.60 63,234.82 7,692.30 5,538.45 3,692.90 275,871.08 12 % 9% 20 6730 Salary - Office 21 G735 Salary- Sales 22 6740 Salary - Warehouse 23 Grand Total 11,495.02 16,948.06 24,577.37 11,410.57 11,493.21 28,370.74 20,163.36 11,792.77 29,895.62 34,984.96 104,885.89 12,695.25 13,196.29 214,918.26 56,616,69 52,081.79 36,573.88 109,081.84 79,850.45 122,201.68 65,830.13 54,955.88 56,522.45 103,319.79 32,848.42 843,923.72 37% 75,808.17 11,269.72 51,831.1M 81,931.55 55,732.13 57,895.29 129,310.19 115,015.61 57,028.24 114,747.93 77,937.91 957,368.64 12% 244,859.88 130,635.45 190,114.66 275,844.00 129,790.88 133,603.25 305,475.86 192,829.24 107,498.27 324,985.09 130,899.94 125,545.18 2,292,081.70 100% 24 25 DATE 2006 26 . EARAAI AIT Detail Summary PVT + 110% 12:49 PM O Type here to search x 9/2/2019 AutoSaveOH Salary Expensas 2004 2007 Excel Ajia Gaspard AG PivatTable Analyze File Formulas Review View Help Design Search Share Home Insert Draw Page Layout Data Comments Cut AutoSum 11 bWrap Text A A Calibri General Fill Clear Copy Conditional format as Faste Cell Insert Delete Format Sort & Find & Ideas $% 48 B IU R Merge & Center A E Format Painter Formatting Table Styles Filter Select Aligrmen Number dipbod Styles Cels Eding dess Fonl 6740 Salary Warehnuse A32 L A C D F F G H K M N Q 23 Grand Total 244,859.88 130,635.45 190,114.66 275,844.00 129,790.88 133,603.25 305,475.86 192,829.24 107,498.27 324,985.09 130,899.94 125,545.18 2,292,081.70 100% 24 25 DATE 2006 T 26 Column Li 27 Sum of AMOUNT 28 Row Labels 29 6/25 Salary - Management 30 6730 Salary - Office 31 6735 Salary Sales 32 6740 Salary- Warehouse 12 Grand Total 1 2 3 4 5 6 7 8 10 11 281,296.16 258,418.89 1,692.30 ,692.30 1,692.30 ,692.30 17,497.24 11,2/6,90 19,305.32 3,416.92 5/,340.80 6,433.82 ,584.60 7,584.60 7,584.60 12% 18,095.43 19,105.48 16,250.12 33,669.85 34,761.95 23,531.06 34,452.03 14,772.19 15,424.68 16,825.87 14,032.99 11% 85,415.26 87,539.81 59,438.76 57,863.34 105,399.00 58,688.55 68,294.46 56,487.02 63,489.17 158,540.07 66,881.39 57,743,36 59,378.18 152,678.02 93,925.61 67,794.99 1,028,547.15 756,628.84 44% 56,688.46 59,733.59 63,614.93 80,996.12 52,192.68 65,062.02 54,385.26 5,945.94 33% 194,467.42 145,970.13 140,494.31 264,704.11 138,748.55 141,256.18 327,488.72 209,729.69 137,299.44 337,359.44 143,623.44 143,750.21 2,324,891.64 33 Grand Total 100% 34 35 DATE 2007 36 Column L 37 Sum of AMOUNT 1 8 38 Row Labels 39 6715 Salary - AG Service 40 6720 Salary Commissions 143,535.41 41 6725 Salary - Management 11,076.90 42 6730 Salary- Office 43 6735 Salary- Sales 44 6/40 Salary - Warehouse 45 Grand Total 2 3 4 5 6 7 9 10 11 12 Grand Total 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0% 1,105.03 7,384.G0 204.63 157,169.72 200.00 154,583.74 27,120.59 12,959.90 0.00 0.00 98,905.43 0.00 0.00 582,824.55 21% 7,384.G0 7,384.60 7,384.60 7,384.60 7,438.74 11,076.90 7,547.04 21.068.79 7,384.G0 7,384.60 101,791.68 10% 23,416.72 19,241.59 21,699.49 20,858.67 20,685.69 22,295.11 22,667.62 33,162.92 20,106.82 20,297.78 31,476.06 276,977.26 10% 173,813.15 119,255.18 118,512.72 119,070.12 119,286.01 125,549.54 185,077.71 127,811.20 128,147.57 124,474.15 126,528.01 196,281.37 1,663,806.73 59% (0.00) 23.032.24 (0.00) 26,9/6.28 23,184.30 (2/,803.98) 189,230.60 0.00 26,858.14 26,981./4 40,383.33 26,994.61 22,623.94 /% 106% 351,842.18 148,339.27 146,755.99 273,022.12 176,928.89 182,842.27 426,870.58 183,421.64 178,462.93 329,772.51 176,338.50 240,033.94 2,814,630.82 46 47 48 49 Summary PVT Detail (+ 110% 12:49 PM Type here to search 9/2/2019 AutoSave - ac556 r9_caooled salary expenses,2004 2007 team_w5 Fxcel Compatibility Moda Ajia Gaspard AG File Page Layout Formulas Review View Help Search Share Comments Home Insert Draw Data 4 Cut AutoSum 11 A A Wrap Text Calibri Gencral Copy Faste Fill Clear Conditional format as Formatting lable Insert Delete Format = E E Merge & Center Cell Sort & Find & Ideas B IU A $% Format Painter Filter Select Aligrmen dipbod Number Styles Cels Edting Ideas Fonl Q11 E N A G K L M v w AA CrockEd Salary Expense from General Ledger 2004 2007 1 7 Monthly Summarics 3 11 3,690 4 60,816 Total 30313 2004 7 3 7 10 12 78,007 11.692 5.53% 5 0725 aiy- Manaremes 6 G730 5aiyOfice 6735 Saisy 5ales 6740 Salary Pipeline 2,76 4,154 5,538 2,76 23,616 102,015 1,205 13% 41490 2,900 15,377 22.146 26,612 25,887 11,953 19,856 10,13 17,537 19,050 72,213 313,711 13% 1,08 49,775 4/,02 100.1/ 83.649 395% 143,0 b,075 318,309 b,90 259 11544b 12,401 1/2,04 25,be 1/002 BUSS57 341 533 10o% 71,791 62,822 104,705 35,444 70,740 57,479 79,792 77,312 57,045 54,778 91,707 9 119.009 175.037 252,435 225,389 117,192 229,007 186.517 371,061 134,00 123,130 2,343,333 10 1 f 12 775 5aly Managemer 13 7305yOfice 14 6735 Salary-5ales 15 6740 Salary Pipeline 9 10 11 12 Total 3,69 4 63.235 2003 1 2 8 7.692 $,538 71,628 22,800 7,692 11,493 12 % 45,456 7,692 11,35 44475 3,690 3.692 27,871 16.18 11,425 24,577 28,371 20,163 11,723 2,896 12,65 13,196 214,918 11411 50,01 10,0U2 9,850 122,202 54,556 s0,522 57.U5 103,320 52,02 34,9 104,8b 30,54 32,54 4324 144, 748 425% 41,270 34,831 81,932 5,830 55,732 129,310 115,045 57,028 T1938 75,08 957,309 133,00 192,829 100% 16 244,860 130.032 190,115 275,844 129,791 305.470 10749 324,985 130,900 125,545 2,292,082 17 18 19 775 5alry- Managemer 20 730 5aly ofice 4 10 11 12 2 3 Total 281-297 200b 9 7.692 3,417 7,692 11,277 7,35 7,692 7,0 57,341 75434 7,585 7,585 7,5A5 12 % 16.250 19,105 33,670 15826 17,497 4,762 23,531 14,033 M,452 14,772. 15425 258419 11% 18,095 z 6735 Salary-5ales 22 6740 Salary Pipeline S,92 445% ,415 59,439 57,863 105,399 5,/43 9,35 152/ 034 158,540 co,851 695 1,025,34 9.734 3% 87,340 58,b c8,294 55,487 30,085 03,015 s0,995 52,193 b,002 34,353 52,940 755,029 2,324,892 100% 23 194,467 145,970 140,494 204,704 135,749 141,255 327489 209,730 137,299 337,359 143,623 143,730 24 2 11 12 Total S82A5 2007 7 10 26 05alary- Coumiseion 27 G725 5Iy- Manspemer 157,170 143,535 ,905 1,105 205 00 154,S04 27,121 21% 11,077 7,385 7,385 7,385 7,385 7,43 11,077 7,547 7,35 7,385 12260 101,2 4% 7,385 26730 Salsry-Omice 29 6735 Salary-Sales 306740 alary Pipeline 2/9 20,89 20,10 10% Z3,41 21,09 20,085 22,295 22,005 33103 21,069 20,298 19,242 314/ 125.550 120.528 173,813 119,25 (0 351,842 148,339 140,75G 118,513 119,070 119,286 185,078 127,811 128,148 124,474 196,281 1,003,807 (27,804 (0) 20,970 25,858 26,982 40.283 20,995 22,624 23,032 23,154 189,231 182,842 183,422 273,022 175,929 100% 31. 420,871 178,403 329,773 17G,339 240,034 2,814,031 32 33 34 9,5,138 20- Summary Detail 1247 PM Type here to search 99. 9/2/2019 Data Driven Summary Saved to this PC AutoSave Ajia Gaspard AG File Mailings Design Layout References Review View Help pSearch Share Comments Home Insert Draw OFind Cat 12 A A Aa Ap EE AaBbCcl AaBbCcl AaBbC AaBb AaBbCcD Arial AaBbCcD AaBbCc AaBbCc b Replace Paste Copy Tormat Painler 1 Normal 1 No Spac Dictate IUab , * Subtle Em.. Emphasis A Heading ading 2 Heading 3 itle Subtitle Select . Fsgraph dipbcard Styles Edi ing Voice Font 7 S 2 6. Data-Driven Fraud Detection Create any additional inferences and make any other observations Part 1, Item 2 A pivot table was created to determine is the Summary tab and Data tab was the same. Unfortunately, the data is different. In years 2004 2006 the percentages were the same but the departments were different. On the Summary tab listed Pipeline but the newly created pivot table Warehouse. There are several red flags. I am not sure of the department difference as additional information has not been provided at this time. Related to the percentage based an the annual expenses, the Summary tab and pivot table are the same for 2004 2006. In 2007, there are percentage differences Department 6725 Salary Management 6740 Salary Pipeline Summary 4% 7% Pivot 10% 0% Additional data must be collected to analyze the difference for the above information and confirmation of the departments. Once the data is analyzed, the results will be provided. If it is discovered that anomalies and/or frauds have been identified, an investigation will be conducted. Page 1 of 1172 words HE 100% Focus 12:48 PM O Type here to search 99. 9/2/2019 AutoSave H Salary Expenses 2004 2007 Excel Ajia Gaspard AG File Formulas Review View Help Search Share Home Insert Draw Page Layout Data Comments Cut AutoSum 11 bWrap Text A A Calibri Pcrcentage Fill Clear Copy Faste Conditional Format as FormattingTable Insert Delete Format A Cell Sort & Find & Ideas B IU Merge & Center E $% Format Painter Filter Select Aligmen dipbd Number Styles Cels Edting Idess Fonl 01 A B C D F F G K L N O C O CrookEd Salary Expense from General Ledger 2004 2007 1 Monthly Summaries 2 3 Total 4 2004 1 4 6 7 9 10 11 12 Summary PVT 100% 264,704 194,467 145,970 140,494 337,359 2,324,892 23 138,749 141,256 327,489 209,730 137,299 143,623 143,750 100% 24 Total 25 2007 1 2 3 4 5 6 7 8 9 10 11 12 157,170 98,905 26 6720 Salary - Commissions 143,535 1,105 205 200 154,584 27,121 582.825 21% 21% 276/25 5alary- Manapement 7,385 11,077 7,547 7,385 7,385 12,960 101,792 11,077 7,385 7,385 7,385 7,439 7,385 4% 10% 23,417 21,699 21,069 20,107 19,242 31,476 276,977 28 6730 Salary- Office 20,859 20,686 22,295 22,668 33,163 20,298 10% 10% 119,286 125,550 26,858 185,078 127,811 128,148 29 6/35 Salary- Sales 173,813 119,255 118,513 (0) 119,070 124,474 126,528 196,281 23,032 1,663,807 59% 59% 26,976 (27,804) 30 6740 5alary-Pipeline (0) 273,022 26,982 22,624 23,184 189,231 7% C 40,383 26,995 148,339 146,756 426,871 183,422 178,463 176,339 240,034 100% 31 351,842 176,929 182,842 329.773 2,814,631 32 33 34 35 36 37 38 39 40 41 Summary PVT Detail 120% 12:49 PM O Type here to search 9/2/2019 AutoSave H Salary Expensas 2004 2007 Excel Ajia Gaspard AG PivatTable Analyze File Formulas Review View Help Design Search Share Comments Home Insert Draw Page Layout Data Cut AutoSum 11 gbWrap Text A A Calibri General Copy Fill Conditional Tormat as Formatting Table Styles Insert Delete Format Faste Cell Sort & Find & Ideas E 2E Merge & Center B IU A Clear Format Painter Filter Select Aligrmen dipbod Number Styles Cels Edting Idess Fonl 6740 Salary Warehouse A32 A C D F G H K M N O Q 1 CrookEd Salary Expense from General Ledger 2004 2007 2 Monthly Summaries 3 4 DATF 2004 5 6 Sum of AMOUNT MONTH 7G/L ACCOUNT 86725 Salary - Management 9 6/30 Salary - Office 10 6735 Salary Sales 11 6740 Salary Warehouse 1 12 Grand Total 2 3 4 5 6 8 10 11 5.538.48 2,769.24 15.377.09 22.146.12 2,769.24 11.692.30 5,538.45 102,014.52 1,205.40 78,007.24 4,153.86 62,816.32 23,615.80 3,692.30 303,813.15 13% 26,618.54 29,940.48 26,887.03 11,952.77 19,856.27 10,134.23 17,536.93 19,050.02 72,713.11 41,498.38 313,710.97 13% 143,686.69 51,086.89 76,966.14 100,177.77 88,258.89 47,025.94 115,445.61 12,401.42 83,649.41 172,684.37 79,791.99 25,668.82 54,777.89 917,051.95 39% 55,443,90 77,311.89 66,674.53 49,775.48 71,791.36 62,822.34 104,704.99 70,739.56 57,478.60 57,644.79 808,957.32 35% 100 % 12 Grand Total 318,308.94 119,008.70 175,057.48 252,434.97 225,389.39 117,191.85 229,657.24 91,706.55 186,516.78 371,060.80 134,050.20 123,150.49 2,343,533.39 13 14 15 DATE 2005 16 17 Sum of AMOUNT Column La 18 Row Labels 1 2 3 4 5 6 7 8 9 10 11 12 Grand Total 19 6725 Salary Management 71,628.32 22,880.00 7,692.30 7,692.30 44,474.84 3,692.30 45,455.65 3,692.30 11,384.60 63,234.82 7,692.30 5,538.45 3,692.90 275,871.08 12 % 9% 20 6730 Salary - Office 21 G735 Salary- Sales 22 6740 Salary - Warehouse 23 Grand Total 11,495.02 16,948.06 24,577.37 11,410.57 11,493.21 28,370.74 20,163.36 11,792.77 29,895.62 34,984.96 104,885.89 12,695.25 13,196.29 214,918.26 56,616,69 52,081.79 36,573.88 109,081.84 79,850.45 122,201.68 65,830.13 54,955.88 56,522.45 103,319.79 32,848.42 843,923.72 37% 75,808.17 11,269.72 51,831.1M 81,931.55 55,732.13 57,895.29 129,310.19 115,015.61 57,028.24 114,747.93 77,937.91 957,368.64 12% 244,859.88 130,635.45 190,114.66 275,844.00 129,790.88 133,603.25 305,475.86 192,829.24 107,498.27 324,985.09 130,899.94 125,545.18 2,292,081.70 100% 24 25 DATE 2006 26 . EARAAI AIT Detail Summary PVT + 110% 12:49 PM O Type here to search x 9/2/2019 AutoSaveOH Salary Expensas 2004 2007 Excel Ajia Gaspard AG PivatTable Analyze File Formulas Review View Help Design Search Share Home Insert Draw Page Layout Data Comments Cut AutoSum 11 bWrap Text A A Calibri General Fill Clear Copy Conditional format as Faste Cell Insert Delete Format Sort & Find & Ideas $% 48 B IU R Merge & Center A E Format Painter Formatting Table Styles Filter Select Aligrmen Number dipbod Styles Cels Eding dess Fonl 6740 Salary Warehnuse A32 L A C D F F G H K M N Q 23 Grand Total 244,859.88 130,635.45 190,114.66 275,844.00 129,790.88 133,603.25 305,475.86 192,829.24 107,498.27 324,985.09 130,899.94 125,545.18 2,292,081.70 100% 24 25 DATE 2006 T 26 Column Li 27 Sum of AMOUNT 28 Row Labels 29 6/25 Salary - Management 30 6730 Salary - Office 31 6735 Salary Sales 32 6740 Salary- Warehouse 12 Grand Total 1 2 3 4 5 6 7 8 10 11 281,296.16 258,418.89 1,692.30 ,692.30 1,692.30 ,692.30 17,497.24 11,2/6,90 19,305.32 3,416.92 5/,340.80 6,433.82 ,584.60 7,584.60 7,584.60 12% 18,095.43 19,105.48 16,250.12 33,669.85 34,761.95 23,531.06 34,452.03 14,772.19 15,424.68 16,825.87 14,032.99 11% 85,415.26 87,539.81 59,438.76 57,863.34 105,399.00 58,688.55 68,294.46 56,487.02 63,489.17 158,540.07 66,881.39 57,743,36 59,378.18 152,678.02 93,925.61 67,794.99 1,028,547.15 756,628.84 44% 56,688.46 59,733.59 63,614.93 80,996.12 52,192.68 65,062.02 54,385.26 5,945.94 33% 194,467.42 145,970.13 140,494.31 264,704.11 138,748.55 141,256.18 327,488.72 209,729.69 137,299.44 337,359.44 143,623.44 143,750.21 2,324,891.64 33 Grand Total 100% 34 35 DATE 2007 36 Column L 37 Sum of AMOUNT 1 8 38 Row Labels 39 6715 Salary - AG Service 40 6720 Salary Commissions 143,535.41 41 6725 Salary - Management 11,076.90 42 6730 Salary- Office 43 6735 Salary- Sales 44 6/40 Salary - Warehouse 45 Grand Total 2 3 4 5 6 7 9 10 11 12 Grand Total 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0% 1,105.03 7,384.G0 204.63 157,169.72 200.00 154,583.74 27,120.59 12,959.90 0.00 0.00 98,905.43 0.00 0.00 582,824.55 21% 7,384.G0 7,384.60 7,384.60 7,384.60 7,438.74 11,076.90 7,547.04 21.068.79 7,384.G0 7,384.60 101,791.68 10% 23,416.72 19,241.59 21,699.49 20,858.67 20,685.69 22,295.11 22,667.62 33,162.92 20,106.82 20,297.78 31,476.06 276,977.26 10% 173,813.15 119,255.18 118,512.72 119,070.12 119,286.01 125,549.54 185,077.71 127,811.20 128,147.57 124,474.15 126,528.01 196,281.37 1,663,806.73 59% (0.00) 23.032.24 (0.00) 26,9/6.28 23,184.30 (2/,803.98) 189,230.60 0.00 26,858.14 26,981./4 40,383.33 26,994.61 22,623.94 /% 106% 351,842.18 148,339.27 146,755.99 273,022.12 176,928.89 182,842.27 426,870.58 183,421.64 178,462.93 329,772.51 176,338.50 240,033.94 2,814,630.82 46 47 48 49 Summary PVT Detail (+ 110% 12:49 PM Type here to search 9/2/2019 AutoSave - ac556 r9_caooled salary expenses,2004 2007 team_w5 Fxcel Compatibility Moda Ajia Gaspard AG File Page Layout Formulas Review View Help Search Share Comments Home Insert Draw Data 4 Cut AutoSum 11 A A Wrap Text Calibri Gencral Copy Faste Fill Clear Conditional format as Formatting lable Insert Delete Format = E E Merge & Center Cell Sort & Find & Ideas B IU A $% Format Painter Filter Select Aligrmen dipbod Number Styles Cels Edting Ideas Fonl Q11 E N A G K L M v w AA CrockEd Salary Expense from General Ledger 2004 2007 1 7 Monthly Summarics 3 11 3,690 4 60,816 Total 30313 2004 7 3 7 10 12 78,007 11.692 5.53% 5 0725 aiy- Manaremes 6 G730 5aiyOfice 6735 Saisy 5ales 6740 Salary Pipeline 2,76 4,154 5,538 2,76 23,616 102,015 1,205 13% 41490 2,900 15,377 22.146 26,612 25,887 11,953 19,856 10,13 17,537 19,050 72,213 313,711 13% 1,08 49,775 4/,02 100.1/ 83.649 395% 143,0 b,075 318,309 b,90 259 11544b 12,401 1/2,04 25,be 1/002 BUSS57 341 533 10o% 71,791 62,822 104,705 35,444 70,740 57,479 79,792 77,312 57,045 54,778 91,707 9 119.009 175.037 252,435 225,389 117,192 229,007 186.517 371,061 134,00 123,130 2,343,333 10 1 f 12 775 5aly Managemer 13 7305yOfice 14 6735 Salary-5ales 15 6740 Salary Pipeline 9 10 11 12 Total 3,69 4 63.235 2003 1 2 8 7.692 $,538 71,628 22,800 7,692 11,493 12 % 45,456 7,692 11,35 44475 3,690 3.692 27,871 16.18 11,425 24,577 28,371 20,163 11,723 2,896 12,65 13,196 214,918 11411 50,01 10,0U2 9,850 122,202 54,556 s0,522 57.U5 103,320 52,02 34,9 104,8b 30,54 32,54 4324 144, 748 425% 41,270 34,831 81,932 5,830 55,732 129,310 115,045 57,028 T1938 75,08 957,309 133,00 192,829 100% 16 244,860 130.032 190,115 275,844 129,791 305.470 10749 324,985 130,900 125,545 2,292,082 17 18 19 775 5alry- Managemer 20 730 5aly ofice 4 10 11 12 2 3 Total 281-297 200b 9 7.692 3,417 7,692 11,277 7,35 7,692 7,0 57,341 75434 7,585 7,585 7,5A5 12 % 16.250 19,105 33,670 15826 17,497 4,762 23,531 14,033 M,452 14,772. 15425 258419 11% 18,095 z 6735 Salary-5ales 22 6740 Salary Pipeline S,92 445% ,415 59,439 57,863 105,399 5,/43 9,35 152/ 034 158,540 co,851 695 1,025,34 9.734 3% 87,340 58,b c8,294 55,487 30,085 03,015 s0,995 52,193 b,002 34,353 52,940 755,029 2,324,892 100% 23 194,467 145,970 140,494 204,704 135,749 141,255 327489 209,730 137,299 337,359 143,623 143,730 24 2 11 12 Total S82A5 2007 7 10 26 05alary- Coumiseion 27 G725 5Iy- Manspemer 157,170 143,535 ,905 1,105 205 00 154,S04 27,121 21% 11,077 7,385 7,385 7,385 7,385 7,43 11,077 7,547 7,35 7,385 12260 101,2 4% 7,385 26730 Salsry-Omice 29 6735 Salary-Sales 306740 alary Pipeline 2/9 20,89 20,10 10% Z3,41 21,09 20,085 22,295 22,005 33103 21,069 20,298 19,242 314/ 125.550 120.528 173,813 119,25 (0 351,842 148,339 140,75G 118,513 119,070 119,286 185,078 127,811 128,148 124,474 196,281 1,003,807 (27,804 (0) 20,970 25,858 26,982 40.283 20,995 22,624 23,032 23,154 189,231 182,842 183,422 273,022 175,929 100% 31. 420,871 178,403 329,773 17G,339 240,034 2,814,031 32 33 34 9,5,138 20- Summary Detail 1247 PM Type here to search 99. 9/2/2019