Personal Shopper Assignment

 

You've opened up a business to be a personal shopper for busy people who don't want to deal with the crowds. Little do they know you won’t have to deal with the crowds either.  You’re going to shop for everything online. 

Your first client is Mr. Burns.  He's very wealthy and doesn't worry about the best deal in town so lowest price should not be your priority. However, he does want everything by the end of the week so you'll have to find everything fast.

Also, since this is a rush job, you get to charge him 15% on top of the total cost instead of your usuall 10%

 

Search for each item below and keep track of it on Google Docs Spread sheet. Go to your "Drive", Create, Spread Sheet

Make a column for each name, each item, vendor (the company you bought it from), each item’s price, and tax. 

 

Remember to format your cells for currency where needed. 

 

HINT: The best way to do this is to copy the exact name of the item and paste into Google and do a search. 

 

¨   Dad--  1750 PSI 1.3 GPM Electric Pressure Washer

¨   Uncle Rick--SanDisk Extreme Pro 256GB SDXC UHS-I Card

¨   Cousin Dani- Keurig® K-Select ™ Single-Serve K-Cup Pod® Coffee Maker

¨   Mom--Cuisinart 14-Piece Deluxe Stainless Steel Grill Tool Set - CGS-5014

¨   The Rosario family (next door neighbors) -- Men Who Built America DVD box set

In Cell A1 write Name

In Cell B1 write item

In Cell C1 write Price

In Cell d1 write tax

In Cell E1 write Total

In Cell F1 Write "Vendor"

in cell D2 type =c2*8.75%

In cell E2 type =SUM(C2:D2)

Find items and prices. Use auto sum for filling in the tax and the total.

Underneath all the prices in column E, find the total of all the items by using Auto Sum.

Underneath the total add your service charge of 15% the way you calculated the tax.

Underneath the service charge, find the total of the prices and the service charge.

This is your Grand Total.

Follow these guidelines for full credit.

20 Points: Must be complete: Every name, every item, with a price, tax (8.75%) and total.

3 point Name and title in header

3 point On one page

3 point Borders on cells

1 point Shading in a least one row of cells