Holiday Shopping List 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. 

 

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

 

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-- Crescent CTK170CMP2 Mechanics Tool Set, 170-Piece

¨   Uncle Rick--any mp3 player from Best Buy

¨   Cousin Dave--Hampton Bay Devron 52 in. LED Indoor Brushed Nickel Ceiling Fan with Light Kit

¨ Cousin Dani- Mr. Coffee Cafe Barista Espresso Maker, Black/Silver

¨   Cousin Jackie--The Book, Hey Ho Let's Go: The Story of the Ramones (Hardcover)

¨   Mom-- Ronco 5500 Series Rotisserie Oven, Black,

¨   Aunt Amy-- Mad Men Season 1 DVD

¨   The Rosario family (next door neighbors) --Sony - UBP-X700 - Streaming 4K Ultra HD Hi-Res Audio Wi-Fi Built-In Blu-Ray Player - Black

¨   Mr. Cancel, the computer technician -- Sony Professional XQD G Series 64GB Memory Card

¨   Tierra the cat--PetHoliday™ Assorted 18-Piece Cat Toy Value Pack

¨   Kari the dog--Milk-Bone® Large Dog Biscuits, 10 lb. Box for Dogs of All Sizes

 

 

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.