INSTRUCTIONS:
1. Add a sheet to the worksheet and rename sheet Pivot table 1. On sheet which is now called Pivot table 1, go to
cell A1 then “insert” “pivot table” using the data range provided on the data sheet (including the heading lines).
Drag “account” to the row labels and “amount” to the ∑Values. You should now see the dollar amounts for sales
revenue, cost of goods sold, commission expense, insurance expense, salary expense, depreciation expense, and
Grand Total (contribution margin). If you don’t see the dollar amounts click the arrow next to amounts in the
∑Values box and choose “Sum of amount”. Next, answer the following:
How much are total sales revenues?
How much is cost of goods sold?
How much is commission expense?
How much is insurance expense?
How much is salary expense?
How much is depreciation expense?
How much is total net income?
2. Add a sheet and rename “Pivot table 2”. On the Pivot table 2 sheet, insert a pivot table in cell A1 using the data
range provided on the data sheet (including the heading lines). Drag “account” to the Row Labels box, drag
“location” to the Column Labels box, and drag “amount” to the ∑Values box.
Answer the following:
Highest sales revenues were generated in which state?
Lowest sales revenues were generated in which state?
Highest net income was generated in which state?
Lowest net income was generated in which state?
3. Add a sheet and rename “Pivot table 3”. On the Pivot table 3 sheet, insert a pivot table in cell A1 using the data
range provided on the data sheet (including the heading lines). Drag “sales person” to the Row Labels box, drag
“account” to the Column Labels box, and drag “amount” to the ∑Values box. Next sort the data by sales revenue by
clicking on any amount in the “sales revenue” column, click “data”, then “sort”, then choose “smallest to largest”
and “top to bottom”.
Answer the following:
Which sales person generated the highest sales revenue?
Which sales person generated the lowest sales revenue?
Now sort the data in the “grand total” net income column:
Which sales person generated the highest net income?
Which sales person generated the lowest net income?
4. Add a sheet and rename “Pivot table 4”. On the Pivot table 4 sheet, insert a pivot table in cell A1 using the data
range provided on the data sheet (including the heading lines). Drag “date” to the Row Labels box, and drag
“amount” to the ∑Values box. Sort the amounts from lowest to highest.
Answer the following:
Lowest net income was earned on which date?
Highest net income was earned on which date?
DATA:
DATE SALES PERSON LOCATION ACCOUNT AMOUNT
1/1/2021 Mary New Jersey 4000 Sales Revenue 8000
1/1/2021 Mary New Jersey 5000 Cost of Goods Sold -1600
1/1/2021 Mary New Jersey 6010 Commission Expense -400
1/1/2021 Mary New Jersey 6020 Insurance Expense -160
1/1/2021 Mary New Jersey 6030 Salary Expense -240
1/1/2021 Mary New Jersey 6040 Depreciation Expense -80
1/4/2021 Chester Florida 4000 Sales Revenue 22000
1/4/2021 Chester Florida 5000 Cost of Goods Sold -5500
1/4/2021 Chester Florida 6010 Commission Expense -880
1/4/2021 Chester Florida 6020 Insurance Expense -660
1/4/2021 Chester Florida 6030 Salary Expense -220
1/4/2021 Chester Florida 6040 Depreciation Expense -440
1/6/2021 Mayer Ohio 4000 Sales Revenue 8700
1/6/2021 Mayer Ohio 5000 Cost of Goods Sold -2175
1/6/2021 Mayer Ohio 6010 Commission Expense -348
1/6/2021 Mayer Ohio 6020 Insurance Expense -261
1/6/2021 Mayer Ohio 6030 Salary Expense -87
1/6/2021 Mayer Ohio 6040 Depreciation Expense -174
1/10/2021 Mary New Jersey 4000 Sales Revenue 72000
1/10/2021 Mary New Jersey 5000 Cost of Goods Sold -14400
1/10/2021 Mary New Jersey 6010 Commission Expense -3600
1/10/2021 Mary New Jersey 6020 Insurance Expense -1440
1/10/2021 Mary New Jersey 6030 Salary Expense -2160
1/10/2021 Mary New Jersey 6040 Depreciation Expense -720
1/11/2021 Williams Ohio 4000 Sales Revenue 12000
1/11/2021 Williams Ohio 5000 Cost of Goods Sold -2160
1/11/2021 Williams Ohio 6010 Commission Expense -360
1/11/2021 Williams Ohio 6020 Insurance Expense -420
1/11/2021 Williams Ohio 6030 Salary Expense -480
1/11/2021 Williams Ohio 6040 Depreciation Expense -180
1/20/2021 Louis New York 4000 Sales Revenue 7100
1/20/2021 Louis New York 5000 Cost of Goods Sold -1349
1/20/2021 Louis New York 6010 Commission Expense -248.5
1/20/2021 Louis New York 6020 Insurance Expense -177.5
1/20/2021 Louis New York 6030 Salary Expense -142
1/20/2021 Louis New York 6040 Depreciation Expense -106.5
1/21/2021 Porzl New York 4000 Sales Revenue 270000
1/21/2021 Porzl New York 5000 Cost of Goods Sold -27000
1/21/2021 Porzl New York 6010 Commission Expense -8100
1/21/2021 Porzl New York 6020 Insurance Expense -5400
1/21/2021 Porzl New York 6030 Salary Expense -6750
1/21/2021 Porzl New York 6040 Depreciation Expense -2700
1/25/2021 Lago New Jersey 4000 Sales Revenue 5400
1/25/2021 Lago New Jersey 5000 Cost of Goods Sold -594
1/25/2021 Lago New Jersey 6010 Commission Expense -216
1/25/2021 Lago New Jersey 6020 Insurance Expense -64.8
1/25/2021 Lago New Jersey 6030 Salary Expense -108
1/25/2021 Lago New Jersey 6040 Depreciation Expense -67.5
2/1/2021 Mary New Jersey 4000 Sales Revenue 16000
2/1/2021 Mary New Jersey 5000 Cost of Goods Sold -3200
2/1/2021 Mary New Jersey 6010 Commission Expense -800
2/1/2021 Mary New Jersey 6020 Insurance Expense -320
2/1/2021 Mary New Jersey 6030 Salary Expense -480
2/1/2021 Mary New Jersey 6040 Depreciation Expense -160
2/4/2021 Chester Florida 4000 Sales Revenue 28000
2/4/2021 Chester Florida 5000 Cost of Goods Sold -7000
2/4/2021 Chester Florida 6010 Commission Expense -1120
2/4/2021 Chester Florida 6020 Insurance Expense -840
2/4/2021 Chester Florida 6030 Salary Expense -280
2/4/2021 Chester Florida 6040 Depreciation Expense -560
2/6/2021 Mayer Ohio 4000 Sales Revenue 8000
2/6/2021 Mayer Ohio 5000 Cost of Goods Sold -2000
2/6/2021 Mayer Ohio 6010 Commission Expense -320
2/6/2021 Mayer Ohio 6020 Insurance Expense -240
2/6/2021 Mayer Ohio 6030 Salary Expense -80
2/6/2021 Mayer Ohio 6040 Depreciation Expense -160
2/11/2021 Mary New Jersey 4000 Sales Revenue 19000
2/11/2021 Mary New Jersey 5000 Cost of Goods Sold -3800
2/11/2021 Mary New Jersey 6010 Commission Expense -950
2/11/2021 Mary New Jersey 6020 Insurance Expense -380
2/11/2021 Mary New Jersey 6030 Salary Expense -570
2/11/2021 Mary New Jersey 6040 Depreciation Expense -190
2/11/2021 Williams Ohio 4000 Sales Revenue 12000
2/11/2021 Williams Ohio 5000 Cost of Goods Sold -2160
2/11/2021 Williams Ohio 6010 Commission Expense -360
2/11/2021 Williams Ohio 6020 Insurance Expense -420
2/11/2021 Williams Ohio 6030 Salary Expense -480
2/11/2021 Williams Ohio 6040 Depreciation Expense -180
2/20/2021 Louis New York 4000 Sales Revenue 8400
2/20/2021 Louis New York 5000 Cost of Goods Sold -1596
2/20/2021 Louis New York 6010 Commission Expense -294
2/20/2021 Louis New York 6020 Insurance Expense -210
2/20/2021 Louis New York 6030 Salary Expense -168
2/20/2021 Louis New York 6040 Depreciation Expense -126
2/21/2021 Porzl New York 4000 Sales Revenue 2700
2/21/2021 Porzl New York 5000 Cost of Goods Sold -270
2/21/2021 Porzl New York 6010 Commission Expense -81
2/21/2021 Porzl New York 6020 Insurance Expense -54
2/21/2021 Porzl New York 6030 Salary Expense -67.5
2/21/2021 Porzl New York 6040 Depreciation Expense -27
2/25/2021 Lago New Jersey 4000 Sales Revenue 54000
2/25/2021 Lago New Jersey 5000 Cost of Goods Sold -5940
2/25/2021 Lago New Jersey 6010 Commission Expense -2160
2/25/2021 Lago New Jersey 6020 Insurance Expense -648
2/25/2021 Lago New Jersey 6030 Salary Expense -1080
2/25/2021 Lago New Jersey 6040 Depreciation Expense -675
3/1/2021 Mary New Jersey 4000 Sales Revenue 28000
3/1/2021 Mary New Jersey 5000 Cost of Goods Sold -5600
3/1/2021 Mary New Jersey 6010 Commission Expense -1400
3/1/2021 Mary New Jersey 6020 Insurance Expense -560
3/1/2021 Mary New Jersey 6030 Salary Expense -840
3/1/2021 Mary New Jersey 6040 Depreciation Expense -280
3/4/2021 Chester Florida 4000 Sales Revenue 48000
3/4/2021 Chester Florida 5000 Cost of Goods Sold -12000
3/4/2021 Chester Florida 6010 Commission Expense -1920
3/4/2021 Chester Florida 6020 Insurance Expense -1440
3/4/2021 Chester Florida 6030 Salary Expense -480
3/4/2021 Chester Florida 6040 Depreciation Expense -960
3/6/2021 Mayer Ohio 4000 Sales Revenue 7000
3/6/2021 Mayer Ohio 5000 Cost of Goods Sold -1750
3/6/2021 Mayer Ohio 6010 Commission Expense -280
3/6/2021 Mayer Ohio 6020 Insurance Expense -210
3/6/2021 Mayer Ohio 6030 Salary Expense -70
3/6/2021 Mayer Ohio 6040 Depreciation Expense -140
3/11/2021 Williams Ohio 4000 Sales Revenue 12000
3/11/2021 Williams Ohio 5000 Cost of Goods Sold -2160
3/11/2021 Williams Ohio 6010 Commission Expense -360
3/11/2021 Williams Ohio 6020 Insurance Expense -420
3/11/2021 Williams Ohio 6030 Salary Expense -480
3/11/2021 Williams Ohio 6040 Depreciation Expense -180
3/20/2021 Louis New York 4000 Sales Revenue 7100
3/20/2021 Louis New York 5000 Cost of Goods Sold -1349
3/20/2021 Louis New York 6010 Commission Expense -248.5
3/20/2021 Louis New York 6020 Insurance Expense -177.5
3/20/2021 Louis New York 6030 Salary Expense -142
3/20/2021 Louis New York 6040 Depreciation Expense -106.5
3/21/2021 Porzl New York 4000 Sales Revenue 1200
3/21/2021 Porzl New York 5000 Cost of Goods Sold -120
3/21/2021 Porzl New York 6010 Commission Expense -36
3/21/2021 Porzl New York 6020 Insurance Expense -24
3/21/2021 Porzl New York 6030 Salary Expense -30
3/21/2021 Porzl New York 6040 Depreciation Expense -12
3/25/2021 Lago New Jersey 4000 Sales Revenue 98000
3/25/2021 Lago New Jersey 5000 Cost of Goods Sold -10780
3/25/2021 Lago New Jersey 6010 Commission Expense -3920
3/25/2021 Lago New Jersey 6020 Insurance Expense -1176
3/25/2021 Lago New Jersey 6030 Salary Expense -1960
3/25/2021 Lago New Jersey 6040 Depreciation Expense -1225
4/1/2021 Mary New Jersey 4000 Sales Revenue 4000
4/1/2021 Mary New Jersey 5000 Cost of Goods Sold -800
4/1/2021 Mary New Jersey 6010 Commission Expense -200
4/1/2021 Mary New Jersey 6020 Insurance Expense -80
4/1/2021 Mary New Jersey 6030 Salary Expense -120
4/1/2021 Mary New Jersey 6040 Depreciation Expense -40
4/4/2021 Chester Florida 4000 Sales Revenue 32000
4/4/2021 Chester Florida 5000 Cost of Goods Sold -8000
4/4/2021 Chester Florida 6010 Commission Expense -1280
4/4/2021 Chester Florida 6020 Insurance Expense -960
4/4/2021 Chester Florida 6030 Salary Expense -320
4/4/2021 Chester Florida 6040 Depreciation Expense -640
4/6/2021 Mayer Ohio 4000 Sales Revenue 4000
4/6/2021 Mayer Ohio 5000 Cost of Goods Sold -1000
4/6/2021 Mayer Ohio 6010 Commission Expense -160
4/6/2021 Mayer Ohio 6020 Insurance Expense -120
4/6/2021 Mayer Ohio 6030 Salary Expense -40
4/6/2021 Mayer Ohio 6040 Depreciation Expense -80
4/11/2021 Mary New Jersey 4000 Sales Revenue 80000
4/11/2021 Mary New Jersey 5000 Cost of Goods Sold -16000
4/11/2021 Mary New Jersey 6010 Commission Expense -4000
4/11/2021 Mary New Jersey 6020 Insurance Expense -1600
4/11/2021 Mary New Jersey 6030 Salary Expense -2400
4/11/2021 Mary New Jersey 6040 Depreciation Expense -800
4/11/2021 Williams Ohio 4000 Sales Revenue 12000
4/11/2021 Williams Ohio 5000 Cost of Goods Sold -2160
4/11/2021 Williams Ohio 6010 Commission Expense -360
4/11/2021 Williams Ohio 6020 Insurance Expense -420
4/11/2021 Williams Ohio 6030 Salary Expense -480
4/11/2021 Williams Ohio 6040 Depreciation Expense -180
4/20/2021 Louis New York 4000 Sales Revenue 5500
4/20/2021 Louis New York 5000 Cost of Goods Sold -1045
4/20/2021 Louis New York 6010 Commission Expense -192.5
4/20/2021 Louis New York 6020 Insurance Expense -137.5
4/20/2021 Louis New York 6030 Salary Expense -110
4/20/2021 Louis New York 6040 Depreciation Expense -82.5
4/21/2021 Porzl New York 4000 Sales Revenue 17000
4/21/2021 Porzl New York 5000 Cost of Goods Sold -1700
4/21/2021 Porzl New York 6010 Commission Expense -510
4/21/2021 Porzl New York 6020 Insurance Expense -340
4/21/2021 Porzl New York 6030 Salary Expense -425
4/21/2021 Porzl New York 6040 Depreciation Expense -170
4/25/2021 Lago New Jersey 4000 Sales Revenue 9800
4/25/2021 Lago New Jersey 5000 Cost of Goods Sold -1078
4/25/2021 Lago New Jersey 6010 Commission Expense -392
4/25/2021 Lago New Jersey 6020 Insurance Expense -117.6
4/25/2021 Lago New Jersey 6030 Salary Expense -196
4/25/2021 Lago New Jersey 6040 Depreciation Expense -122.5
5/1/2021 Mary New Jersey 4000 Sales Revenue 17000
5/1/2021 Mary New Jersey 5000 Cost of Goods Sold -3400
5/1/2021 Mary New Jersey 6010 Commission Expense -850
5/1/2021 Mary New Jersey 6020 Insurance Expense -340
5/1/2021 Mary New Jersey 6030 Salary Expense -510
5/1/2021 Mary New Jersey 6040 Depreciation Expense -170
5/4/2021 Chester Florida 4000 Sales Revenue 92000
5/4/2021 Chester Florida 5000 Cost of Goods Sold -23000
5/4/2021 Chester Florida 6010 Commission Expense -3680
5/4/2021 Chester Florida 6020 Insurance Expense -2760
5/4/2021 Chester Florida 6030 Salary Expense -920
5/4/2021 Chester Florida 6040 Depreciation Expense -1840
5/6/2021 Mayer Ohio 4000 Sales Revenue 12000
5/6/2021 Mayer Ohio 5000 Cost of Goods Sold -3000
5/6/2021 Mayer Ohio 6010 Commission Expense -480
5/6/2021 Mayer Ohio 6020 Insurance Expense -360
5/6/2021 Mayer Ohio 6030 Salary Expense -120
5/6/2021 Mayer Ohio 6040 Depreciation Expense -240
5/11/2021 Williams Ohio 4000 Sales Revenue 12000
5/11/2021 Williams Ohio 5000 Cost of Goods Sold -2160
5/11/2021 Williams Ohio 6010 Commission Expense -360
5/11/2021 Williams Ohio 6020 Insurance Expense -420
5/11/2021 Williams Ohio 6030 Salary Expense -480
5/11/2021 Williams Ohio 6040 Depreciation Expense -180
5/20/2021 Louis New York 4000 Sales Revenue 4720
5/20/2021 Louis New York 5000 Cost of Goods Sold -896.8
5/20/2021 Louis New York 6010 Commission Expense -165.2
5/20/2021 Louis New York 6020 Insurance Expense -118
5/20/2021 Louis New York 6030 Salary Expense -94.4
5/20/2021 Louis New York 6040 Depreciation Expense -70.8
5/21/2021 Porzl New York 4000 Sales Revenue 14500
5/21/2021 Porzl New York 5000 Cost of Goods Sold -1450
5/21/2021 Porzl New York 6010 Commission Expense -435
5/21/2021 Porzl New York 6020 Insurance Expense -290
5/21/2021 Porzl New York 6030 Salary Expense -362.5
5/21/2021 Porzl New York 6040 Depreciation Expense -145
5/25/2021 Lago New Jersey 4000 Sales Revenue 32000
5/25/2021 Lago New Jersey 5000 Cost of Goods Sold -3520
5/25/2021 Lago New Jersey 6010 Commission Expense -1280
5/25/2021 Lago New Jersey 6020 Insurance Expense -384
5/25/2021 Lago New Jersey 6030 Salary Expense -640
5/25/2021 Lago New Jersey 6040 Depreciation Expense -400
6/1/2021 Mary New Jersey 4000 Sales Revenue 20000
6/1/2021 Mary New Jersey 5000 Cost of Goods Sold -4000
6/1/2021 Mary New Jersey 6010 Commission Expense -1000
6/1/2021 Mary New Jersey 6020 Insurance Expense -400
6/1/2021 Mary New Jersey 6030 Salary Expense -600
6/1/2021 Mary New Jersey 6040 Depreciation Expense -200
6/4/2021 Chester Florida 4000 Sales Revenue 87000
6/4/2021 Chester Florida 5000 Cost of Goods Sold -21750
6/4/2021 Chester Florida 6010 Commission Expense -3480
6/4/2021 Chester Florida 6020 Insurance Expense -2610
6/4/2021 Chester Florida 6030 Salary Expense -870
6/4/2021 Chester Florida 6040 Depreciation Expense -1740
6/6/2021 Mayer Ohio 4000 Sales Revenue 4700
6/6/2021 Mayer Ohio 5000 Cost of Goods Sold -1175
6/6/2021 Mayer Ohio 6010 Commission Expense -188
6/6/2021 Mayer Ohio 6020 Insurance Expense -141
6/6/2021 Mayer Ohio 6030 Salary Expense -47
6/6/2021 Mayer Ohio 6040 Depreciation Expense -94
6/11/2021 Williams Ohio 4000 Sales Revenue 12000
6/11/2021 Williams Ohio 5000 Cost of Goods Sold -2160
6/11/2021 Williams Ohio 6010 Commission Expense -360
6/11/2021 Williams Ohio 6020 Insurance Expense -420
6/11/2021 Williams Ohio 6030 Salary Expense -480
6/11/2021 Williams Ohio 6040 Depreciation Expense -180
6/20/2021 Louis New York 4000 Sales Revenue 1875
6/20/2021 Louis New York 5000 Cost of Goods Sold -356.25
6/20/2021 Louis New York 6010 Commission Expense -65.625
6/20/2021 Louis New York 6020 Insurance Expense -46.875
6/20/2021 Louis New York 6030 Salary Expense -37.5
6/20/2021 Louis New York 6040 Depreciation Expense -28.125
6/21/2021 Porzl New York 4000 Sales Revenue 65000
6/21/2021 Porzl New York 5000 Cost of Goods Sold -6500
6/21/2021 Porzl New York 6010 Commission Expense -1950
6/21/2021 Porzl New York 6020 Insurance Expense -1300
6/21/2021 Porzl New York 6030 Salary Expense -1625
6/21/2021 Porzl New York 6040 Depreciation Expense -650
6/25/2021 Lago New Jersey 4000 Sales Revenue 3200
6/25/2021 Lago New Jersey 5000 Cost of Goods Sold -352
6/25/2021 Lago New Jersey 6010 Commission Expense -128
6/25/2021 Lago New Jersey 6020 Insurance Expense -38.4
6/25/2021 Lago New Jersey 6030 Salary Expense -64
6/25/2021 Lago New Jersey 6040 Depreciation Expense -40
7/1/2021 Mary New Jersey 4000 Sales Revenue 2000
7/1/2021 Mary New Jersey 5000 Cost of Goods Sold -400
7/1/2021 Mary New Jersey 6010 Commission Expense -100
7/1/2021 Mary New Jersey 6020 Insurance Expense -40
7/1/2021 Mary New Jersey 6030 Salary Expense -60
7/1/2021 Mary New Jersey 6040 Depreciation Expense -20
7/4/2021 Chester Florida 4000 Sales Revenue 50000
7/4/2021 Chester Florida 5000 Cost of Goods Sold -12500
7/4/2021 Chester Florida 6010 Commission Expense -2000
7/4/2021 Chester Florida 6020 Insurance Expense -1500
7/4/2021 Chester Florida 6030 Salary Expense -500
7/4/2021 Chester Florida 6040 Depreciation Expense -1000
7/6/2021 Mayer Ohio 4000 Sales Revenue 47000
7/6/2021 Mayer Ohio 5000 Cost of Goods Sold -11750
7/6/2021 Mayer Ohio 6010 Commission Expense -1880
7/6/2021 Mayer Ohio 6020 Insurance Expense -1410
7/6/2021 Mayer Ohio 6030 Salary Expense -470
7/6/2021 Mayer Ohio 6040 Depreciation Expense -940
7/11/2021 Williams Ohio 4000 Sales Revenue 12000
7/11/2021 Williams Ohio 5000 Cost of Goods Sold -2160
7/11/2021 Williams Ohio 6010 Commission Expense -360
7/11/2021 Williams Ohio 6020 Insurance Expense -420
7/11/2021 Williams Ohio 6030 Salary Expense -480
7/11/2021 Williams Ohio 6040 Depreciation Expense -180
7/20/2021 Louis New York 4000 Sales Revenue 81150
7/20/2021 Louis New York 5000 Cost of Goods Sold -15418.5
7/20/2021 Louis New York 6010 Commission Expense -2840.25
7/20/2021 Louis New York 6020 Insurance Expense -2028.75
7/20/2021 Louis New York 6030 Salary Expense -1623
7/20/2021 Louis New York 6040 Depreciation Expense -1217.25
7/21/2021 Porzl New York 4000 Sales Revenue 16200
7/21/2021 Porzl New York 5000 Cost of Goods Sold -1620
7/21/2021 Porzl New York 6010 Commission Expense -486
7/21/2021 Porzl New York 6020 Insurance Expense -324
7/21/2021 Porzl New York 6030 Salary Expense -405
7/21/2021 Porzl New York 6040 Depreciation Expense -162
7/25/2021 Lago New Jersey 4000 Sales Revenue 64000
7/25/2021 Lago New Jersey 5000 Cost of Goods Sold -7040
7/25/2021 Lago New Jersey 6010 Commission Expense -2560
7/25/2021 Lago New Jersey 6020 Insurance Expense -768
7/25/2021 Lago New Jersey 6030 Salary Expense -1280
7/25/2021 Lago New Jersey 6040 Depreciation Expense -800
8/1/2021 Mary New Jersey 4000 Sales Revenue 47000
8/1/2021 Mary New Jersey 5000 Cost of Goods Sold -9400
8/1/2021 Mary New Jersey 6010 Commission Expense -2350
8/1/2021 Mary New Jersey 6020 Insurance Expense -940
8/1/2021 Mary New Jersey 6030 Salary Expense -1410
8/1/2021 Mary New Jersey 6040 Depreciation Expense -470
8/4/2021 Chester Florida 4000 Sales Revenue 25000
8/4/2021 Chester Florida 5000 Cost of Goods Sold -6250
8/4/2021 Chester Florida 6010 Commission Expense -1000
8/4/2021 Chester Florida 6020 Insurance Expense -750
8/4/2021 Chester Florida 6030 Salary Expense -250
8/4/2021 Chester Florida 6040 Depreciation Expense -500
8/6/2021 Mayer Ohio 4000 Sales Revenue 72000
8/6/2021 Mayer Ohio 5000 Cost of Goods Sold -18000
8/6/2021 Mayer Ohio 6010 Commission Expense -2880
8/6/2021 Mayer Ohio 6020 Insurance Expense -2160
8/6/2021 Mayer Ohio 6030 Salary Expense -720
8/6/2021 Mayer Ohio 6040 Depreciation Expense -1440
8/11/2021 Williams Ohio 4000 Sales Revenue 12000
8/11/2021 Williams Ohio 5000 Cost of Goods Sold -2160
8/11/2021 Williams Ohio 6010 Commission Expense -360
8/11/2021 Williams Ohio 6020 Insurance Expense -420
8/11/2021 Williams Ohio 6030 Salary Expense -480
8/11/2021 Williams Ohio 6040 Depreciation Expense -180
8/20/2021 Louis New York 4000 Sales Revenue 50000
8/20/2021 Louis New York 5000 Cost of Goods Sold -9500
8/20/2021 Louis New York 6010 Commission Expense -1750
8/20/2021 Louis New York 6020 Insurance Expense -1250
8/20/2021 Louis New York 6030 Salary Expense -1000
8/20/2021 Louis New York 6040 Depreciation Expense -750
8/21/2021 Porzl New York 4000 Sales Revenue 9800
8/21/2021 Porzl New York 5000 Cost of Goods Sold -980
8/21/2021 Porzl New York 6010 Commission Expense -294
8/21/2021 Porzl New York 6020 Insurance Expense -196
8/21/2021 Porzl New York 6030 Salary Expense -245
8/21/2021 Porzl New York 6040 Depreciation Expense -98
8/25/2021 Lago New Jersey 4000 Sales Revenue 6400
8/25/2021 Lago New Jersey 5000 Cost of Goods Sold -704
8/25/2021 Lago New Jersey 6010 Commission Expense -256
8/25/2021 Lago New Jersey 6020 Insurance Expense -76.8
8/25/2021 Lago New Jersey 6030 Salary Expense -128
8/25/2021 Lago New Jersey 6040 Depreciation Expense -80
9/1/2021 Mary New Jersey 4000 Sales Revenue 12000
9/1/2021 Mary New Jersey 5000 Cost of Goods Sold -2400
9/1/2021 Mary New Jersey 6010 Commission Expense -600
9/1/2021 Mary New Jersey 6020 Insurance Expense -240
9/1/2021 Mary New Jersey 6030 Salary Expense -360
9/1/2021 Mary New Jersey 6040 Depreciation Expense -120
9/4/2021 Chester Florida 4000 Sales Revenue 6000
9/4/2021 Chester Florida 5000 Cost of Goods Sold -1500
9/4/2021 Chester Florida 6010 Commission Expense -240
9/4/2021 Chester Florida 6020 Insurance Expense -180
9/4/2021 Chester Florida 6030 Salary Expense -60
9/4/2021 Chester Florida 6040 Depreciation Expense -120
9/6/2021 Mayer Ohio 4000 Sales Revenue 12000
9/6/2021 Mayer Ohio 5000 Cost of Goods Sold -3000
9/6/2021 Mayer Ohio 6010 Commission Expense -480
9/6/2021 Mayer Ohio 6020 Insurance Expense -360
9/6/2021 Mayer Ohio 6030 Salary Expense -120
9/6/2021 Mayer Ohio 6040 Depreciation Expense -240
9/11/2021 Williams Ohio 4000 Sales Revenue 12000
9/11/2021 Williams Ohio 5000 Cost of Goods Sold -2160
9/11/2021 Williams Ohio 6010 Commission Expense -360
9/11/2021 Williams Ohio 6020 Insurance Expense -420
9/11/2021 Williams Ohio 6030 Salary Expense -480
9/11/2021 Williams Ohio 6040 Depreciation Expense -180
9/20/2021 Louis New York 4000 Sales Revenue 12000
9/20/2021 Louis New York 5000 Cost of Goods Sold -2280
9/20/2021 Louis New York 6010 Commission Expense -420
9/20/2021 Louis New York 6020 Insurance Expense -300
9/20/2021 Louis New York 6030 Salary Expense -240
9/20/2021 Louis New York 6040 Depreciation Expense -180
9/21/2021 Porzl New York 4000 Sales Revenue 76000
9/21/2021 Porzl New York 5000 Cost of Goods Sold -7600
9/21/2021 Porzl New York 6010 Commission Expense -2280
9/21/2021 Porzl New York 6020 Insurance Expense -1520
9/21/2021 Porzl New York 6030 Salary Expense -1900
9/21/2021 Porzl New York 6040 Depreciation Expense -760
9/25/2021 Lago New Jersey 4000 Sales Revenue 26000
9/25/2021 Lago New Jersey 5000 Cost of Goods Sold -2860
9/25/2021 Lago New Jersey 6010 Commission Expense -1040
9/25/2021 Lago New Jersey 6020 Insurance Expense -312
9/25/2021 Lago New Jersey 6030 Salary Expense -520
9/25/2021 Lago New Jersey 6040 Depreciation Expense -325
10/1/2021 Mary New Jersey 4000 Sales Revenue 18000
10/1/2021 Mary New Jersey 5000 Cost of Goods Sold -3600
10/1/2021 Mary New Jersey 6010 Commission Expense -900
10/1/2021 Mary New Jersey 6020 Insurance Expense -360
10/1/2021 Mary New Jersey 6030 Salary Expense -540
10/1/2021 Mary New Jersey 6040 Depreciation Expense -180
10/4/2021 Chester Florida 4000 Sales Revenue 29000
10/4/2021 Chester Florida 5000 Cost of Goods Sold -7250
10/4/2021 Chester Florida 6010 Commission Expense -1160
10/4/2021 Chester Florida 6020 Insurance Expense -870
10/4/2021 Chester Florida 6030 Salary Expense -290
10/4/2021 Chester Florida 6040 Depreciation Expense -580
10/6/2021 Mayer Ohio 4000 Sales Revenue 19000
10/6/2021 Mayer Ohio 5000 Cost of Goods Sold -4750
10/6/2021 Mayer Ohio 6010 Commission Expense -760
10/6/2021 Mayer Ohio 6020 Insurance Expense -570
10/6/2021 Mayer Ohio 6030 Salary Expense -190
10/6/2021 Mayer Ohio 6040 Depreciation Expense -380
10/11/2021 Williams Ohio 4000 Sales Revenue 12000
10/11/2021 Williams Ohio 5000 Cost of Goods Sold -2160
10/11/2021 Williams Ohio 6010 Commission Expense -360
10/11/2021 Williams Ohio 6020 Insurance Expense -420
10/11/2021 Williams Ohio 6030 Salary Expense -480
10/11/2021 Williams Ohio 6040 Depreciation Expense -180
10/20/2021 Louis New York 4000 Sales Revenue 19000
10/20/2021 Louis New York 5000 Cost of Goods Sold -3610
10/20/2021 Louis New York 6010 Commission Expense -665
10/20/2021 Louis New York 6020 Insurance Expense -475
10/20/2021 Louis New York 6030 Salary Expense -380
10/20/2021 Louis New York 6040 Depreciation Expense -285
10/21/2021 Porzl New York 4000 Sales Revenue 5400
10/21/2021 Porzl New York 5000 Cost of Goods Sold -540
10/21/2021 Porzl New York 6010 Commission Expense -162
10/21/2021 Porzl New York 6020 Insurance Expense -108
10/21/2021 Porzl New York 6030 Salary Expense -135
10/21/2021 Porzl New York 6040 Depreciation Expense -54
10/25/2021 Lago New Jersey 4000 Sales Revenue 45000
10/25/2021 Lago New Jersey 5000 Cost of Goods Sold -4950
10/25/2021 Lago New Jersey 6010 Commission Expense -1800
10/25/2021 Lago New Jersey 6020 Insurance Expense -540
10/25/2021 Lago New Jersey 6030 Salary Expense -900
10/25/2021 Lago New Jersey 6040 Depreciation Expense -562.5
11/1/2021 Mary New Jersey 4000 Sales Revenue 10000
11/1/2021 Mary New Jersey 5000 Cost of Goods Sold -2000
11/1/2021 Mary New Jersey 6010 Commission Expense -500
11/1/2021 Mary New Jersey 6020 Insurance Expense -200
11/1/2021 Mary New Jersey 6030 Salary Expense -300
11/1/2021 Mary New Jersey 6040 Depreciation Expense -100
11/4/2021 Chester Florida 4000 Sales Revenue 16000
11/4/2021 Chester Florida 5000 Cost of Goods Sold -4000
11/4/2021 Chester Florida 6010 Commission Expense -640
11/4/2021 Chester Florida 6020 Insurance Expense -480
11/4/2021 Chester Florida 6030 Salary Expense -160
11/4/2021 Chester Florida 6040 Depreciation Expense -320
11/6/2021 Mayer Ohio 4000 Sales Revenue 84000
11/6/2021 Mayer Ohio 5000 Cost of Goods Sold -21000
11/6/2021 Mayer Ohio 6010 Commission Expense -3360
11/6/2021 Mayer Ohio 6020 Insurance Expense -2520
11/6/2021 Mayer Ohio 6030 Salary Expense -840
11/6/2021 Mayer Ohio 6040 Depreciation Expense -1680
11/11/2021 Mary New Jersey 4000 Sales Revenue 22000
11/11/2021 Mary New Jersey 5000 Cost of Goods Sold -4400
11/11/2021 Mary New Jersey 6010 Commission Expense -1100
11/11/2021 Mary New Jersey 6020 Insurance Expense -440
11/11/2021 Mary New Jersey 6030 Salary Expense -660
11/11/2021 Mary New Jersey 6040 Depreciation Expense -220
11/11/2021 Williams Ohio 4000 Sales Revenue 12000
11/11/2021 Williams Ohio 5000 Cost of Goods Sold -2160
11/11/2021 Williams Ohio 6010 Commission Expense -360
11/11/2021 Williams Ohio 6020 Insurance Expense -420
11/11/2021 Williams Ohio 6030 Salary Expense -480
11/11/2021 Williams Ohio 6040 Depreciation Expense -180
11/20/2021 Louis New York 4000 Sales Revenue 12500
11/20/2021 Louis New York 5000 Cost of Goods Sold -2375
11/20/2021 Louis New York 6010 Commission Expense -437.5
11/20/2021 Louis New York 6020 Insurance Expense -312.5
11/20/2021 Louis New York 6030 Salary Expense -250
11/20/2021 Louis New York 6040 Depreciation Expense -187.5
11/21/2021 Porzl New York 4000 Sales Revenue 3200
11/21/2021 Porzl New York 5000 Cost of Goods Sold -320
11/21/2021 Porzl New York 6010 Commission Expense -96
11/21/2021 Porzl New York 6020 Insurance Expense -64
11/21/2021 Porzl New York 6030 Salary Expense -80
11/21/2021 Porzl New York 6040 Depreciation Expense -32
11/25/2021 Lago New Jersey 4000 Sales Revenue 2600
11/25/2021 Lago New Jersey 5000 Cost of Goods Sold -286
11/25/2021 Lago New Jersey 6010 Commission Expense -104
11/25/2021 Lago New Jersey 6020 Insurance Expense -31.2
11/25/2021 Lago New Jersey 6030 Salary Expense -52
11/25/2021 Lago New Jersey 6040 Depreciation Expense -32.5
12/1/2021 Mary New Jersey 4000 Sales Revenue 30000
12/1/2021 Mary New Jersey 5000 Cost of Goods Sold -6000
12/1/2021 Mary New Jersey 6010 Commission Expense -1500
12/1/2021 Mary New Jersey 6020 Insurance Expense -600
12/1/2021 Mary New Jersey 6030 Salary Expense -900
12/1/2021 Mary New Jersey 6040 Depreciation Expense -300
12/4/2021 Chester Florida 4000 Sales Revenue 87000
12/4/2021 Chester Florida 5000 Cost of Goods Sold -21750
12/4/2021 Chester Florida 6010 Commission Expense -3480
12/4/2021 Chester Florida 6020 Insurance Expense -2610
12/4/2021 Chester Florida 6030 Salary Expense -870
12/4/2021 Chester Florida 6040 Depreciation Expense -1740
12/6/2021 Mayer Ohio 4000 Sales Revenue 86000
12/6/2021 Mayer Ohio 5000 Cost of Goods Sold -21500
12/6/2021 Mayer Ohio 6010 Commission Expense -3440
12/6/2021 Mayer Ohio 6020 Insurance Expense -2580
12/6/2021 Mayer Ohio 6030 Salary Expense -860
12/6/2021 Mayer Ohio 6040 Depreciation Expense -1720
12/11/2021 Williams Ohio 4000 Sales Revenue 12000
12/11/2021 Williams Ohio 5000 Cost of Goods Sold -2160
12/11/2021 Williams Ohio 6010 Commission Expense -360
12/11/2021 Williams Ohio 6020 Insurance Expense -420
12/11/2021 Williams Ohio 6030 Salary Expense -480
12/11/2021 Williams Ohio 6040 Depreciation Expense -180
12/20/2021 Louis New York 4000 Sales Revenue 32125
12/20/2021 Louis New York 5000 Cost of Goods Sold -6103.75
12/20/2021 Louis New York 6010 Commission Expense -1124.38
12/20/2021 Louis New York 6020 Insurance Expense -803.125
12/20/2021 Louis New York 6030 Salary Expense -642.5
12/20/2021 Louis New York 6040 Depreciation Expense -481.875
12/21/2021 Porzl New York 4000 Sales Revenue 12000
12/21/2021 Porzl New York 5000 Cost of Goods Sold -1200
12/21/2021 Porzl New York 6010 Commission Expense -360
12/21/2021 Porzl New York 6020 Insurance Expense -240
12/21/2021 Porzl New York 6030 Salary Expense -300
12/21/2021 Porzl New York 6040 Depreciation Expense -120
12/25/2021 Lago New Jersey 4000 Sales Revenue 4400
12/25/2021 Lago New Jersey 5000 Cost of Goods Sold -484
12/25/2021 Lago New Jersey 6010 Commission Expense -176
12/25/2021 Lago New Jersey 6020 Insurance Expense -52.8
12/25/2021 Lago New Jersey 6030 Salary Expense -88
12/25/2021 Lago New Jersey 6040 Depreciation Expense -55
