Login
Order Now

Our Services

Get 15% Discount on your First Order

Order Now

INSTRUCTIONS: 1. Add a sheet to the worksheet and rename

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

Share This Post

Email
WhatsApp
Facebook
Twitter
LinkedIn
Pinterest
Reddit

Order a Similar Paper and get 15% Discount on your First Order

Order Now

Related Questions

Discuss this week’s content (or other concerns/things) with your partner

Discuss this week’s content (or other concerns/things) with your partner and post a breakdown of what you discussed. Please post an update. Enjoying hearing what you are bouncing around.  Note: slight increase in the point value starting this week. Also, if you wish, feel free to combine groups. The more

Answer following questions: How do you perceive politics? What would

  Answer following questions: How do you perceive politics? What would be the best description of politics in your own words?    2. If you changed your perception of politics, describe that change. Explain and provide examples how you think politics influence your personal life and on the other side,

Complete the following tasks: 1) In Unit VI, you will

Complete the following tasks: 1) In Unit VI, you will be turning in a design blueprint as you begin to outline your plans for the online course you will partially build throughout this course. Briefly tell your fellow classmates about the online course you are planning to design in this

TITLE Article Summary Introduction This is an article review. The

TITLE  Article Summary Introduction  This is an article review. The Assignment Read the article The Power of Planning and Preparation. (above) Answer the following questions. Please be sure to read the statement on plagarism. 1. Choose 3 of the 6 ways proper preparation and planning will pay off. Discuss why each

Required: You have been asked to write a report to

Required:  You have been asked to write a report to the board of directors of one of the selected companies below as  part of the interview process for your first appointment as a Finance Director of a company listed on AIM  (which is the Alternative Investment Market for small companies)

Delta Corporation has been very impressed with the progress it

Delta Corporation has been very impressed with the progress it has made with its new product line and the new marketing approach that you recommended and instigated. As a result, it is now considering expanding this approach for its other product lines, providing them with the ability to market and

Need to present a research reports on 1. Machine learning

   Need to present a research reports on  1. Machine learning method 2. User Behavior Analytics (UBA)  Both reports should be written with a word count of 70-105 words(not more than the count provided) and should provide a URL reference link too .  Note : NO PLAGIARISM  Should have minimum

Would you please help me formulate a response to the

Would you please help me formulate a response to the following:  Besides the two major internal control classifications, (IT general controls and IT application controls), auditors sometimes refer to internal controls as either preventive or detective controls. Preventive controls such as the segregation of duties, are designed to prevent errors,

ASSIGNMENT DETAILS Implementing Strategy The following Course Outcome is assessed

ASSIGNMENT DETAILS Implementing Strategy The following Course Outcome is assessed in this assignment: GB580-3: Develop an implementation action plan using strategy tools. In this assignment, you will develop a narrated PowerPoint® presentation to deliver a strategy implementation plan with an embedded action plan to direct the staff of the Turul Winery

Utilizing Chapter 6 of the book attaced, develop a compensation

 Utilizing Chapter 6 of the book attaced, develop a compensation and benefits package that you would like to be offered by your organization. There should be different plans for each group member. Use your five slides for your preferred benefits package. Demonstrate how this package will impact whether or not

In this project, you will be expected to do a

In this project, you will be expected to do a comprehensive literature search and survey, select and study a specific topic in one subject area of data mining and its applications in business intelligence and analytics (BIA), and write a research paper on the selected topic by yourself. The research

Cost, quality, and access to care have been Americans’ main

  Cost, quality, and access to care have been Americans’ main concerns when it comes to health care. Disruptions (i.e., staffing shortages, operations, managed care contracts, and technology) to the conventional way of operating in health care may create an opportunity for simultaneous improvements in cost, quality, and access.  Propose

There have been several areas throughout the country that have

There have been several areas throughout the country that have enacted taxes and regulations on food products.  Some examples are regulations on the size of sodas sold in New York City, and taxes on soda in areas of California and Colorado.  After reading the articles for and against “sin” taxes,

Select a large, publicly traded company that has a clearly

Select a large, publicly traded company that has a clearly stated diversity policy, documented diversity programs and initiatives, and diversity data. You will evaluate this company throughout the course related to diversity issues. To begin the evaluating the company Company Information Give a brief description of the company that you

· Use the information presented in the module folder along

   · Use the information presented in the module folder along with your readings from the textbook to answer the following questions.  Explain and differentiate      between sterilization and commercial sterilization. What organism does commercial      sterilization aim to destroy? Describe three (3)      different physical methods of controlling microbial growth: Describe three

All of papers you get at speedyresearchpapers.com are meant for research purposes only. The papers are not supposed to be submitted for academic credit.

Sitemap

Terms & Conditions
Privacy Policy

Use Our 6 Free Tools

  1. Thesis statement generator
  2. Words to pages converter
  3. Words to Minutes Converter for Speech
  4. Free college GPA calculator
  5. Bibliography Generator
  6. Free Plagiarism Checker
Follow us:
Facebook
Twitter
Email
© 2023. SpeedyResearchPapers.com. All Rights Reserved.
We accept:
  • support@speedyresearchpapers.com