MIS 388

Guest Check Homework

Create an Excel workbook that will make the necessary computations and look like the example on the next pages.

The following computations must be made:

1. One sheet in the workbook should be named “Price List” and contain the table shown on the following page (page 2).

2. A second sheet in the workbook should be renamed “Guest Check” and contain the data shown on page 3 following.

1. The column labeled “Item” should be pre-entered on the worksheet
2. The columns labeled “Description” and “Price” should be retrieved from the price list worksheet using the VLOOKUP function.
3. The column labeled “Quantity” would be entered by the user
4. The column labeled “Amount” is computed by multiplying “Quantity” times “Price”.
5. The “TOTAL” line is the summation of the Amounts above.
6. Tax is computed at a rate of 8.25% of “TOTAL”.
7. “Amount Due” is the sum of “TOTAL” and Tax.

3. Attach the .xls file to an e-mail and send it to me with the subject “John Doe (9:99 class)– Guest Check homework”. Or you may turn it in on a CD or flash memory stick labeled with your name and class information.

Price List
Item Number	Description	Regular Price
10	Hamburger	0.69
15	Double Burger	1.5
20	Cheeseburger	0.79
25	Double Cheese	1.6
60	French Fries	0.65
90	Coke	0.45

Guest Check

DAVE'S DANDY DELIGHTS
Burgers for the Strong at Heart
Item	Description	Quantity	Price	Amount
90	Coke	5	0.45	2.25
10	Hamburger	3	0.69	2.07
60	French Fries	3	0.65	1.95
20	Cheeseburger	2	0.79	1.58
			TOTAL	7.85
			Tax (8.25%)	0.65
			Amt Due	8.50