Management Chapter 9 Homework Charge Name Zip Freezer Door Stuck

subject Type Homework Help
subject Pages 12
subject Words 1668
subject Authors Kenneth C. Laudon

Unlock document.

This document is partially blurred.
Unlock all pages and 1 million more documents.
Get Access
ACCT_ID
NAME
ADDR
CITY
STATE
ZIP
DOLLAR_SIZE
CONTACT_FIRST
PHONE
FAX
1
Able Association
123 Axion Street
Albertown
NY
11444-4444
$50,000.00
Alison
Ableson
(209) 111-1111
(219) 111-2222
2
Briggs Bakery
123 Boggs Street
Brimstone
CT
11200-1234
$94,000.00
Barry
Berryman
(210) 111-1212
(210) 111-1213
3
Constant Carriers
31 Carmine Le
Carver
NJ
20111-1212
Carl
Compress
(202) 123-1222
(202) 123-1234
5
Eagle Engineers
Eagle Park
Edmonton
CT
11222-2313
$45,000.00
Eddie
Exeter
(210) 212-2233
(210) 143-2122
tblREQUEST
Page 1
REQUEST_NUM
ACCT_ID
REQ_DATE
EQUIP_TYPE
1
1
4/4/2012
furnace
2
1
4/5/2012
plumbing
3
1
4/1/2012
air conditioner
4
2
4/4/2012
roofing
7
2
4/4/2012
furnace
8
3
4/4/2012
9
4
4/1/2012
roofing
5
4/3/2012
freezer
1
4/2/2012
plumbing
2
4/5/2012
window
3
4/2/2012
furnace
tblREQUEST
Page 2
PROBLEM
PRICE
no heat
$0.00
can’t turn water off in 3rd floor kitchen
$0.00
air conditioner filter missing
$0.00
lead over store sign
$0.00
store too cold
$0.00
need to check for spring
$0.00
wind broke off shingles
$0.00
leaking a blue fluid
$0.00
faucet in storage room is leaking
$0.00
rock went thru plate glass
$0.00
pilot light is off
$0.00
NAME BIGCONTACT CITYSTATE ADDR CITY STATE ZIP CONTACT_FIRST CONTACT_LAST DOLLAR_SIZE PHONE
Able Association Alison Ableson Albertown, NY 123 Axion Street Albertown NY 11444-4444 Alison Ableson $50,000.00 (209) 111-1111
qryEQUIPMENT_FREQUENCY
Page 1
EQUIP_TYPE
EQUIPMENT TYPE FREQUENCY
roofing
4
plumbing
3
oven
3
2
windows
1
ACCT_ID
NAME
ADDR
CITY
STATE
ZIP
BIG_CITY
DOLLAR_SIZE
REQ_DATE
EQUIP_TYPE
CONTACT_FIRST
CONTACT_LAST
BIG_CONTACT
PROBLEM
1
Able Association
123 Axion Street
Albertown
NY
11444-4444
Albertown, NY 114444444
$50,000.00
4/1/2012
air conditioner
Alison
Ableson
Alison Ableson
air conditioner filter missing
1
Able Association
123 Axion Street
Albertown
NY
11444-4444
Albertown, NY 114444444
$50,000.00
4/2/2012
plumbing
Alison
Ableson
Alison Ableson
faucet in storage room is leaking
1
Able Association
123 Axion Street
Albertown
NY
11444-4444
Albertown, NY 114444444
$50,000.00
4/4/2012
furnace
Alison
Ableson
Alison Ableson
no heat
1
Able Association
123 Axion Street
Albertown
NY
11444-4444
Albertown, NY 114444444
$50,000.00
4/5/2012
plumbing
Alison
Ableson
Alison Ableson
can’t turn water off in 3rd floor kitchen
2
Briggs Bakery
123 Boggs Street
Brimstone
CT
11200-1234
Brimstone, CT 112001234
$94,000.00
4/3/2012
freezer
Barry
Berryman
Barry Berryman
freezer door stuck
2
Briggs Bakery
123 Boggs Street
Brimstone
CT
11200-1234
Brimstone, CT 112001234
$94,000.00
4/3/2012
oven
Barry
Berryman
Barry Berryman
oven overheating
2
Briggs Bakery
123 Boggs Street
Brimstone
CT
11200-1234
Brimstone, CT 112001234
$94,000.00
4/4/2012
furnace
Barry
Berryman
Barry Berryman
store too cold
ACCT_ID
1
NAME
Able Association
ADDRESS
123 Axion Street
ZIP
11444-444
DOLLAR_SIZE
$50,000
FIRST
Alison
LAST
Ableson
PHONE
(209) 111-111
FAX
(219) 111-2222
REQUEST
CITY:
Albertown
STATE
1
DATE
4/4/2012
EQUIPMENT TY
furnace
PROBLEM
no heat
EQUIPMENT TY
air conditioner
PROBLEM
air conditioner filter missing
CHARGE
$0.00
REP_ID
RESOLUTION
#Name?
14
DATE
4/2/2012
ACCT_ID
NAME
Briggs Bakery
ADDRESS
123 Boggs Street
ZIP
11200-123
DOLLAR_SIZE
$94,000
Barry
Berryman
PHONE
(210) 111-121
FAX
(210) 111-1213
CITY:
Brimstone
STATE
NY
REQUEST
4
DATE
4/4/2012
EQUIPMENT TY
roofing
PROBLEM
lead over store sign
CHARGE
$0.00
REP_ID
RESOLUTION
#Name?
5
DATE
4/3/2012
oven
PROBLEM
oven overheating
REP_ID
RESOLUTION
#Name?
6
DATE
EQUIPMENT TY
freezer
PROBLEM
freezer door stuck
$0.00
REP_ID
RESOLUTION
#Name?
7
DATE
EQUIPMENT TY
PROBLEM
store too cold
ACCT_ID
3
NAME
Constant Carriers
DOLLAR_SIZE
FIRST
Carl
LAST
REQUEST
CHARGE
REP_ID
RESOLUTION
#Name?
2
DATE
EQUIPMENT TY
plumbing
PROBLEM
can’t turn water off in 3rd floor kitchen
REP_ID
RESOLUTION
#Name?
3
DATE
8
DATE
4/4/2012
EQUIPMENT TY
air conditioner
PROBLEM
need to check for spring
CHARGE
$0.00
REP_ID
RESOLUTION
#Name?
16
DATE
4/5/2012
REQUEST
9
DATE
4/1/2012
EQUIPMENT TY
roofing
PROBLEM
wind broke off shingles
CHARGE
$0.00
REP_ID
RESOLUTION
#Name?
10
DATE
4/5/2012
EQUIPMENT TY
PROBLEM
sash is loose
CHARGE
$0.00
REP_ID
RESOLUTION
#Name?
DATE
PROBLEM
REP_ID
RESOLUTION
5
Eagle Engineers
Eagle Park
11222-231
Eddie
Exeter
(210) 212-223
(210) 143-2122
REQUEST
CITY:
STATE
DATE
EQUIPMENT TY
REP_ID
RESOLUTION
DATE
furnace
PROBLEM
pilot light is off
4
Darning Drapers
1234 Dante Ave
12345-684
(209) 123-432
(201) 123-4322
CITY:
STATE
11
DATE
4/2/2012
EQUIPMENT TY
oven
PROBLEM
temperature fluctuating
DATE
EQUIPMENT TY
REP_ID
RESOLUTION
1
DATE
4/4/2012
EQUIPMENT TY
furnace
PROBLEM
no heat
CHARGE
$0.00
REP_ID
RESOLUTION
#Name?
2
DATE
4/5/2012
EQUIPMENT TY
roofing
PROBLEM
lead over store sign
CHARGE
$0.00
REP_ID
RESOLUTION
#Name?
5
DATE
4/3/2012
EQUIPMENT TY
oven
PROBLEM
oven overheating
CHARGE
$0.00
REP_ID
RESOLUTION
#Name?
6
DATE
4/3/2012
EQUIPMENT TY
freezer
PROBLEM
freezer door stuck
CHARGE
$0.00
REP_ID
RESOLUTION
#Name?
7
DATE
4/4/2012
EQUIPMENT TY
furnace
PROBLEM
store too cold
RESOLUTION
8
DATE
EQUIPMENT TY
air conditioner
PROBLEM
need to check for spring
CHARGE
$0.00
REP_ID
RESOLUTION
#Name?
EQUIPMENT TY
roofing
PROBLEM
wind broke off shingles
CHARGE
$0.00
REP_ID
RESOLUTION
#Name?
10
DATE
4/5/2012
EQUIPMENT TY
window
PROBLEM
sash is loose
CHARGE
$0.00
REP_ID
RESOLUTION
#Name?
11
DATE
4/2/2012
EQUIPMENT TY
oven
PROBLEM
temperature fluctuating
CHARGE
$0.00
REP_ID
RESOLUTION
#Name?
12
DATE
4/3/2012
EQUIPMENT TY
freezer
PROBLEM
RESOLUTION
EQUIPMENT TY
PROBLEM
can’t turn water off in 3rd floor kitchen
CHARGE
$0.00
REP_ID
RESOLUTION
#Name?
3
DATE
EQUIPMENT TY
PROBLEM
CHARGE
$0.00
REP_ID
RESOLUTION
#Name?
14
DATE
4/2/2012
EQUIPMENT TY
plumbing
PROBLEM
faucet in storage room is leaking
CHARGE
$0.00
REP_ID
RESOLUTION
#Name?
15
DATE
4/5/2012
EQUIPMENT TY
window
PROBLEM
rock went thru plate glass
EQUIPMENT TY
oven
PROBLEM
smoke in room
CHARGE
$0.00
REP_ID
RESOLUTION
#Name?
19
DATE
4/5/2012
EQUIPMENT TY
PROBLEM
CHARGE
REP_ID
20
DATE
4/2/2012
EQUIPMENT TY
furnace
PROBLEM
pilot light is off
CHARGE
REP_ID
RESOLUTION
CHARGE
$0.00
REP_ID
RESOLUTION
#Name?
DATE
4/5/2012
roofing
check gutters
CHARGE
$0.00
REP_ID
RESOLUTION
#Name?
18
DATE
ACCOUNTS by VALUE
DOLLAR_SIZE
NAME
CONTACT
PHONE
ADDRESS
CITY STATE
ZIP
$200,000
Constant Carriers
Carl Compress
(202) 123
31 Carmine Le
Carver, NJ
20111-1212
Page 1 of 1
Eagle Engineers
Eddie Exeter
(210) 212
Eagle Park
Edmonton, CT
11222-2313
EQUIPMENT REPAIR FREQUENC
EQUIPMENT TYPE
FREQUENCY OF
REPAIR REQUESTS
roofing
4
plumbing
3
Page 1 of 1
3
2
REQUEST DATE
Sunday, April 1, 2012
Account Priority
$200,000
Constant Carriers
31 Carmine Le
20111-1212
Carver, NJ
plumbing
drains are clogged
Page 1 of 5
Able Association
123 Axion Street
11444-4444
air conditioner
air conditioner filter missing
REQUEST DATE
Monday, April 2, 2012
Account Priority
$200,000
Constant Carriers
31 Carmine Le
20111-1212
Carver, NJ
Page 2 of 5
Eagle Engineers
Eagle Park
11222-2313
REQUEST DATE
Tuesday, April 3, 2012
Account Priority
$94,000
Briggs Bakery
123 Boggs Street
11200-1234
Brimstone, CT
Page 3 of 5
Account Priority
$60,000
12345-6849
REQUEST DATE
Wednesday, April 4, 2012
Account Priority
$200,000
Constant Carriers
31 Carmine Le
20111-1212
Carver, NJ
Page 4 of 5
REQUEST DATE
Thursday, April 5, 2012
Account Priority
$200,000
Constant Carriers
31 Carmine Le
20111-1212
Carver, NJ
Page 5 of 5
Darning Drapers
1234 Dante Ave
12345-6849
Account Priority
$45,000
Eagle Engineers
Eagle Park
11222-2313

Trusted by Thousands of
Students

Here are what students say about us.

Copyright ©2025 All rights reserved. | CoursePaper is not sponsored or endorsed by any college or university.