MIS 388

Invoice Homework

1. Create an Excel spreadsheet that replicates the invoice template shown on the next page. Do not copy and paste the template into the Excel workbook.

2. Note that the headings and return address information should be merged and centered across the entire form.

2. The “AMOUNT” column should be computed as “PRICE” times “QUANTITY”.

3. The cell to the right of “TOTAL” is the sum of the “AMOUNT” column above.

4. “TAX” is computed as 8.25% of “TOTAL”.

5. “AMT DUE” is “TOTAL” plus “TAX”.

6. Conditionally format the “AMOUNT” column so that it does not show zeroes in it if the user has not entered any data under “PRICE” or “QUANTITY”. This column should also be formatted for currency.

7. Attach the .xls/.xlsx file to an e-mail and send it to me with the subject “John Doe (9:99 class) – Invoice homework” or you may give me a CD or flash memory stick labeled with your name and class information.

DAVE’S WHOLESALE MEAT DELIVERY

“We Will Meat Your Expectations”

CUSTOMER INVOICE

Invoice Date:

Customer Name:

PRODUCT	QUANTITY	UNIT	PRICE	AMOUNT
			TOTAL
			TAX (8.25%)
			AMT DUE

Please remit to:

Dave’s Wholesale Meat Delivery

200 Main Street

Huntsville, Texas 77341

936-555-1234