Barrett Furniture Rentals
Author Elise Williams
Date 7/1/2017
Purpose To track furniture rentals
Field Description Data Type Notes
Renter Renter’s name Text
Furniture Type of furniture Text
Rental Date Date rental begins Date Enter dates using mm/dd/yyyy
Rental Period Number of months Number 6 or 12
Data Definition Table
Insurance Furniture insured Text Yes or No
code
Rental Fee Rental fee Number Accounting format with two decimal places
Insurance Charge Insurance charge Text Accounting format with two decimal places
Total Cost Total Cost Number Accounting format with two decimal places
# of Renters Total Rental $
Jul 14 2,262$
Renter Furniture Rental Date
Rental
Period
Insurance
Group
Code
Rental Fee
Insurance
Charge
Shipping
Charge
Total Cost
Mogan LR-3pc 8/15/2017 6 Yes Pickup C 200$ 120$ –$ 320$
Novarre LR-3pc + 8/28/2017 6 Yes Pickup D 250$ 150$ –$ 400$
Chico GR-Electronic 7/13/2017 12 Yes Truck E 750$ 480$ 50$ 1,280$
Roman BR-King 7/17/2017 6 Yes Truck D 250$ 150$ 50$ 450$
Dill GR-Pool/Darts 7/17/2017 6 Yes Pickup B 150$ 90$ –$ 240$
Udinotti LR-3pc + 9/11/2017 6 No Truck D 250$ –$ 50$ 300$
Aserty DR-Table/8 7/30/2017 6 Yes Pickup D 250$ 150$ –$ 400$
McGraw BR-Twin 9/30/2017 6 Yes Pickup A 100$ 60$ –$ 160$
McIver DR-Table/8 8/24/2017 6 Yes Pickup D 250$ 150$ –$ 400$
Schenck LR-3pc 9/5/2017 6 Yes Pickup C 200$ 120$ –$ 320$
Bindner LR-3pc 9/8/2017 6 No Pickup C 200$ –$ –$ 200$
Blum LR-3pc + 8/2/2017 6 Yes Pickup D 250$ 150$ –$ 400$
Reed LR-3pc 8/9/2017 6 Yes Truck C 200$ 120$ 50$ 370$
Turrell LR-3pc + 8/12/2017 6 Yes Truck D 250$ 150$ 50$ 450$
Aserty LR-3pc + 7/24/2017 6 Yes Pickup D 250$ 150$ –$ 400$
Meglech BR-Twin 9/5/2017 6 Yes Truck A 100$ 60$ 50$ 210$
Metz BR-King 8/16/2017 6 No Truck D 250$ –$ 50$ 300$
Scherzel LR-3pc 8/8/2017 6 Yes Pickup C 200$ 120$ –$ 320$
Meglech BR-Queen 9/30/2017 6 Yes Pickup C 200$ 120$ –$ 320$
Guys GR-Electronic 7/17/2017 6 Yes Truck E 400$ 240$ 50$ 690$
Ingraham LR-3pc 8/30/2017 6 No Pickup C 200$ –$ –$ 200$
Lundquist LR-3pc + 8/14/2017 12 Yes Pickup D 475$ 300$ –$ 775$
Werner LR-3pc + 7/6/2017 6 Yes Pickup D 250$ 150$ –$ 400$
Aserty BR-Queen 7/7/2017 6 No Pickup C 200$ –$ –$ 200$
Meglech LR-3pc 9/14/2017 6 Yes Pickup C 200$ 120$ –$ 320$
Battenberg
BR-Queen 9/30/2017 6 Yes Pickup C 200$ 120$ –$ 320$
Fleming DR-Table/8 7/12/2017 6 No Truck D 250$ –$ 50$ 300$
Acconci LR-3pc 7/9/2017 6 Yes Truck C 200$ 120$ 50$ 370$
Cox GR-Electronic 9/29/2017 12 Yes Pickup E 750$ 480$ –$ 1,230$
Meglech BR-Twin 8/4/2017 6 Yes Pickup A 100$ 60$ –$ 160$
DiGrigoro LR-3pc 7/2/2017 6 Yes Pickup C 200$ 120$ –$ 320$
Ibe BR-Queen 8/31/2017 6 Yes Truck C 200$ 120$ 50$ 370$
Zischke DR-Table/8 8/30/2017 6 Yes Pickup D 250$ 150$ –$ 400$
Gilhooly LR-3pc 8/22/2017 6 No Truck C 200$ –$ 50$ 250$
Guys LR-3pc 7/15/2017 6 No Truck C 200$ –$ 50$ 250$
Swartz DR-Table/8 7/3/2017 6 Yes Pickup D 250$ 150$ –$ 400$
Group
Rental for
6-months
Rental for 9-
months
Monthly
Insurance
Furniture
BR-King BR-Queen BR-Twin DR-Table/4 DR-Table/8 GR-Pool/Darts GR-Electronic LR-3pc LR-3pc +
A100$ 175$ 10$ Group Code D C A A D B E C D
B150$ 250$ 15$
BR-King Bedroom with King Bed
BR-Queen Bedroom with Queen Bed
BR-Twin Bedroom with Twin Bed
DR-Table/4 Dining Room – Table for 4
DR-Table/8 Dining Room – Table for 8
GR-Pool/Darts Game Room – Pool Table & Darts
GR-Electonic Game Room – Electronic Games
LR-3pc Living Room – 3 piece
LR-3pc + Living Room – 3 piece with tables
Furniture Rental Charges
Furniture Group
Key to Furniture Codes
Rentals # Rentals Total Rental $
6-months 33 7,100$
Rental Summary