Spreadsheet Grocery Shopping Project - Quia



Apartment Shopping Project

Stay within a budget: __________

Procedure:

You are just about to move into your first apartment…For this project, you will be furnishing the apartment based on your taste and needs. Before you begin, write out a plan for what you need and GO SHOPPING!!:

Items/Categories

1. Bedroom Set (bed, dresser, mattress)

2. Living Room Set (couch, chair)

3. Coffee and side tables

4. Desk

5. Desk chair

Requirements: The shopping template you submit will be an automated spreadsheet, with formulas

1. Download the document from web

2. Enter your budget amount in cell B15. The current amount there is $8000.00

3. Insert as many rows to list and describe the items you are buying for your apartment

4. You must buy at least one item from each category above. The more complete your apartment is without going over budget, the better your grade will be.

5. REQUIRED COLUMNS:

1. Item Description

2. Quantity

3. Unit Price

4. Total Price (quantity x unit price) formula

5. Sales Tax (6.35%) (=.0635 * price) formula

6. Total Cost (= unit price + sales tax) formula

7. % of budget used on this item formula

8. Money left after purchase (budget – total cost) formula

9. Small Picture of item, if not purchased at IKEA

10. Shopping Website you bought the item, if not purchased from IKEA

6. Label worksheet “First Name - Furniture Budget” Example: John-Furniture Budget

-----------------------

6. Kitchen table and chairs

7. Television

8. Kitchen items (pots, pans, plates, cups, glasses)

9. Lamps, rugs

10. Other necessary items – sheets, towels

................
................

In order to avoid copyright disputes, this page is only a partial summary.

Google Online Preview   Download