Accounting information system excel homework

profilelm10
datas2_2017_inventory_statistics.xlsx
Home>Business & Finance homework help>Accounting homework help>Accounting information system excel homework

Qty inventory on hand

Name Type Unit cost (Jan-Jul 2017) Jan-17 Feb-17 Mar-17 Apr-17 May-17 Jun-17 Jul-17
Square D WL 500 VAC Limit switch 3850 73 71 24 147 120 10 210
Square D WLM 115 VAC Limit switch 1575 123 33 36 14 25 29 15
Square D D4V 250 VAC Limit switch 2800 82 110 5 135 153 65 5
Square D D4A-2N 480 VAC Limit switch 2100 161 284 40 68 19 56 188
Square D HL-5000 250 VAC Limit switch 700 64 9 45 174 45 203 51
Square D D4A-4N 125VAC Limit switch 3150 49 11 4 81 11 87 2
Omron WL 500 VAC Limit switch 3855 350 585 676 803 706 833 963
Omron WLM 115 VAC Limit switch 1581 333 285 500 595 402 463 607
Omron D4V 250 VAC Limit switch 2796 196 182 333 381 399 415 513
Omron D4A-2N 480 VAC Limit switch 2105 180 300 447 370 343 336 350
Omron HL-5000 250 VAC Limit switch 709 89 9 89 12 8 34 113
Omron D4A-4N 125VAC Limit switch 3148 93 9 68 2 2 44 320
230/115 kV 1-3 Phase, 420 MVA Circuit breaker 10000 291 140 13 49 147 144 7
70kV 4-1 Phase (4X 60 MVA) Circuit breaker 13000 12 153 8 16 71 114 49
70kV 1-3 Phase (200 MVA) Circuit breaker 9000 23 41 95 19 12 61 3
115/60V 4-1 Phase (4X 30) Circuit breaker 10000 8 7 53 36 3 30 26
115/60V 1-3 Phase (200 MVA) Circuit breaker 8000 35 102 152 733 564 576 586
Double Circuit, Strung on both sides, Lattice Tower 1km Transmission line 2330 5 10 12 154 53 137 127
Double Circuit, Strung on one side, Lattice Tower 1km Transmission line 1830 140 41 22 264 3 53 45
Single Circuit, Lattice Tower 1km Transmission line 1450 50 19 64 46 113 38 104
Double Circuit, Strung on both sides, Tubular Steel Pole 1km Transmission line 2620 18 8 18 3 47 11 13
Double Circuit, Strung on one side, Tubular Steel Pole 1km Transmission line 2160 4 13 93 63 84 2 194
Single Circuit, Tubular Steel Pole 1km Transmission line 1610 40 32 85 117 31 26 185
http://www.windservers.com/domains.php?domain=brefk http://www.windservers.com/domains.php?domain=brefo http://www.windservers.com/domains.php?domain=brekk http://www.windservers.com/domains.php?domain=brelk

Purchase qty

Name Type Unit cost (Jan-Jul 2017) Jan-17 Feb-17 Mar-17 Apr-17 May-17 Jun-17 Jul-17
Square D WL 500 VAC Limit switch 3850 70 0 37 203 152 82 339
Square D WLM 115 VAC Limit switch 1575 120 14 73 137 138 101 56
Square D D4V 250 VAC Limit switch 2800 80 186 114 198 211 12 0
Square D D4A-2N 480 VAC Limit switch 2100 160 301 48 79 185 212 323
Square D HL-5000 250 VAC Limit switch 700 60 0 93 315 22 300 0
Square D D4A-4N 125VAC Limit switch 3150 50 92 89 253 205 258 0
Omron WL 500 VAC Limit switch 3855 300 290 280 270 280 290 300
Omron WLM 115 VAC Limit switch 1581 330 310 290 270 250 230 210
Omron D4V 250 VAC Limit switch 2796 200 180 180 170 160 150 140
Omron D4A-2N 480 VAC Limit switch 2105 200 190 175 180 165 150 135
Omron HL-5000 250 VAC Limit switch 709 90 216 234 109 143 83 191
Omron D4A-4N 125VAC Limit switch 3148 90 107 117 3 3 111 452
230/115 kV 1-3 Phase, 420 MVA Circuit breaker 10000 290 169 169 202 191 170 0
70kV 4-1 Phase (4X 60 MVA) Circuit breaker 13000 10 226 8 32 227 175 40
70kV 1-3 Phase (200 MVA) Circuit breaker 9000 20 172 155 28 59 174 8
115/60V 4-1 Phase (4X 30) Circuit breaker 10000 10 14 163 20 61 121 62
115/60V 1-3 Phase (200 MVA) Circuit breaker 8000 40 170 170 710 170 170 170
Double Circuit, Strung on both sides, Lattice Tower 1km Transmission line 2330 10 167 72 308 204 233 142
Double Circuit, Strung on one side, Lattice Tower 1km Transmission line 1830 140 408 408 424 190 231 91
Single Circuit, Lattice Tower 1km Transmission line 1450 50 15 202 132 170 16 175
Double Circuit, Strung on both sides, Tubular Steel Pole 1km Transmission line 2620 20 1 60 105 109 175 194
Double Circuit, Strung on one side, Tubular Steel Pole 1km Transmission line 2160 0 92 239 151 207 230 306
Single Circuit, Tubular Steel Pole 1km Transmission line 1610 40 70 167 99 65 142 254
http://www.windservers.com/domains.php?domain=brefk http://www.windservers.com/domains.php?domain=brefo http://www.windservers.com/domains.php?domain=brekk http://www.windservers.com/domains.php?domain=brelk

Sales value

Name Type Unit cost (Jan-Jul 2017) Jan-17 Feb-17 Mar-17 Apr-17 May-17 Jun-17 Jul-17
Square D WL 500 VAC Limit switch 3850 633497 7681 329913 314771 754750 744526 539282
Square D WLM 115 VAC Limit switch 1575 315955 174164 118285 257623 207065 158782 120577
Square D D4V 250 VAC Limit switch 2800 196996 472173 623163 205082 578694 285238 175093
Square D D4A-2N 480 VAC Limit switch 2100 360745 375619 653331 111627 539076 389970 433576
Square D HL-5000 250 VAC Limit switch 700 61947 41648 43271 142041 111564 100628 114650
Square D D4A-4N 125VAC Limit switch 3150 199144 418828 305091 588809 864375 626643 266079
Omron WL 500 VAC Limit switch 3855 508982 223277 742198 596637 1446936 661860 651980
Omron WLM 115 VAC Limit switch 1581 339645 583593 118172 275677 763208 293488 113466
Omron D4V 250 VAC Limit switch 2796 610603 538256 83710 359253 431284 375614 119954
Omron D4A-2N 480 VAC Limit switch 2105 383077 161609 63793 574399 417536 354115 255175
Omron HL-5000 250 VAC Limit switch 709 127168 220156 120023 141911 109110 40552 87244
Omron D4A-4N 125VAC Limit switch 3148 202830 616538 189617 218950 9537 231007 606858
230/115 kV 1-3 Phase, 420 MVA Circuit breaker 10000 1824221 3368302 3107851 1680461 956122 1773520 1451999
70kV 4-1 Phase (4X 60 MVA) Circuit breaker 13000 224296 1214587 2143629 328983 2432957 1826939 1383481
70kV 1-3 Phase (200 MVA) Circuit breaker 9000 557174 1396613 927493 951629 652735 1161886 618682
115/60V 4-1 Phase (4X 30) Circuit breaker 10000 1782756 157394 1282864 386400 960949 981588 669109
115/60V 1-3 Phase (200 MVA) Circuit breaker 8000 1462992 852466 380535 1107680 2892974 1353930 1393891
Double Circuit, Strung on both sides, Lattice Tower 1km Transmission line 2330 199817 407853 164699 402845 722770 367679 388268
Double Circuit, Strung on one side, Lattice Tower 1km Transmission line 1830 294973 1004174 824802 350083 880483 332772 193272
Single Circuit, Lattice Tower 1km Transmission line 1450 204239 69940 228962 226620 160949 131399 156743
Double Circuit, Strung on both sides, Tubular Steel Pole 1km Transmission line 2620 405221 28936 137642 315896 183833 563750 530178
Double Circuit, Strung on one side, Tubular Steel Pole 1km Transmission line 2160 248681 184955 351419 414515 433981 710652 244872
Single Circuit, Tubular Steel Pole 1km Transmission line 1610 130857 130206 185853 115677 262609 245332 152200
http://www.windservers.com/domains.php?domain=brefk http://www.windservers.com/domains.php?domain=brefo http://www.windservers.com/domains.php?domain=brekk http://www.windservers.com/domains.php?domain=brelk

Sales qty (amount shipped)

Name Type Unit cost (Jan-Jul 2017) Jan-17 Feb-17 Mar-17 Apr-17 May-17 Jun-17 Jul-17
Square D WL 500 VAC Limit switch 3850 159 2 84 80 179 192 139
Square D WLM 115 VAC Limit switch 1575 183 104 70 159 127 97 70
Square D D4V 250 VAC Limit switch 2800 65 158 219 68 193 100 60
Square D D4A-2N 480 VAC Limit switch 2100 164 178 292 51 234 175 191
Square D HL-5000 250 VAC Limit switch 700 89 55 57 186 151 142 152
Square D D4A-4N 125VAC Limit switch 3150 62 130 96 176 275 182 85
Omron WL 500 VAC Limit switch 3855 128 55 189 143 377 163 170
Omron WLM 115 VAC Limit switch 1581 199 358 75 175 443 169 66
Omron D4V 250 VAC Limit switch 2796 199 194 29 122 142 134 42
Omron D4A-2N 480 VAC Limit switch 2105 171 70 28 257 192 157 121
Omron HL-5000 250 VAC Limit switch 709 165 296 154 186 147 57 112
Omron D4A-4N 125VAC Limit switch 3148 59 191 58 69 3 69 176
230/115 kV 1-3 Phase, 420 MVA Circuit breaker 10000 181 320 296 166 93 173 137
70kV 4-1 Phase (4X 60 MVA) Circuit breaker 13000 16 85 153 24 172 132 105
70kV 1-3 Phase (200 MVA) Circuit breaker 9000 58 154 101 104 66 125 66
115/60V 4-1 Phase (4X 30) Circuit breaker 10000 175 15 117 37 94 94 66
115/60V 1-3 Phase (200 MVA) Circuit breaker 8000 180 103 120 129 339 158 160
Double Circuit, Strung on both sides, Lattice Tower 1km Transmission line 2330 81 162 70 166 305 149 152
Double Circuit, Strung on one side, Lattice Tower 1km Transmission line 1830 161 507 427 182 451 181 99
Single Circuit, Lattice Tower 1km Transmission line 1450 134 46 157 150 103 91 109
Double Circuit, Strung on both sides, Tubular Steel Pole 1km Transmission line 2620 149 11 50 120 65 211 192
Double Circuit, Strung on one side, Tubular Steel Pole 1km Transmission line 2160 107 83 159 181 186 312 114
Single Circuit, Tubular Steel Pole 1km Transmission line 1610 81 78 114 67 151 147 95
http://www.windservers.com/domains.php?domain=brefk http://www.windservers.com/domains.php?domain=brefo http://www.windservers.com/domains.php?domain=brekk http://www.windservers.com/domains.php?domain=brelk