Macros Excel

Savina230
Client4.xlsm
Home>Computer Science homework help>Macros Excel

Customer

CUST ID REGION NUM HOUSEHOLD ANNUAL INCOME TOTAL PURCHASES NUM PURCHASES Expense Ratio
25 East 7 100 165 5 23.57
199 East 7 100 149 8 21.29
76 East 4 100 145 5 36.25
278 East 1 100 145 1 145.00
119 East 1 100 95 6 95.00
133 East 7 100 95 6 13.57
301 East 4 100 95 2 23.75
486 East 6 50 76 9 12.67
263 East 2 100 59 2 29.50
305 East 1 100 50 5 50.00
176 East 2 100 35 10 17.50
343 East 4 100 30 3 7.50
48 East 3 100 29 8 9.67
58 East 5 100 25 1 5.00
372 East 3 100 18 9 6.00
222 North 3 100 159 11 53.00
104 North 4 100 119 7 29.75
353 North 2 100 99 5 49.50
243 North 6 100 98 8 16.33
90 North 3 100 84 9 28.00
257 North 1 100 60 6 60.00
262 North 3 100 59 3 19.67
145 North 5 100 56 7 11.20
300 North 3 100 45 3 15.00
376 North 4 100 40 6 10.00
181 North 3 100 28 1 9.33
57 North 4 100 22 9 5.50
68 North 6 100 19 2 3.17
285 North 3 100 19 3 6.33
211 South 4 100 185 9 46.25
299 South 2 100 86 10 43.00
277 South 7 100 68 7 9.71
118 South 2 100 45 2 22.50
344 South 6 100 29 2 4.83
283 South 5 100 26 8 5.20
324 South 2 100 25 6 12.50
70 South 7 100 19 8 2.71
197 South 6 100 19 4 3.17
294 West 4 100 179 3 44.75
203 West 3 100 99 7 33.00
487 West 4 50 98 2 24.50
239 West 5 100 97 5 19.40
120 West 3 100 86 8 28.67
160 West 2 100 76 11 38.00
275 West 6 100 44 6 7.33
333 West 4 100 39 6 9.75
183 West 2 100 30 5 15.00
96 West 4 100 29 11 7.25
36 West 4 100 28 4 7.00

Accounts

Jan Feb Mar
Accounts Receivable 200 300 400
Accounts Payable 100 50 500
Utilities 300 400 600
Totals 600 750 1500

Balance

2017 2018 2019
Dave Subshop 1000 1500 2000
Jay Deli 2000 3000 4000
Mario Pizza 6000 7000 7500
Totals 9000 11500 13500