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.
20 Points: Must be complete: Every name, every item, with a price, tax (8.75%) and total.
3 pointName and title in header
3 pointOn one page
3 pointBorders on cells
1 pointShading in a least one row of cells
¨ 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,
Mad Men Season 1 DVD
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
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.