Microsoft Excel Assignment 2

Microsoft Excel Assignment 2

Documentation

Shelly Cashman Excel 2019 | Module 2: SAM Project 1b
Edgerton-Norris
FORMAT WORKSHEETS
Author:Todd Washington
Note: Do not edit this sheet. If your name does not appear in cell B6, please download a new copy of the file from the SAM website.

Invoice

Edgerton-Norris
Bill to:Northpoint ClinicPhone:(612) 555-3422Invoice number:2-876-0
Address:344 Stevens St. Minneapolis, MN 55404Email:info@npclinic.cengage.comInvoice date:3-Apr-21
Invoice for:March pharmaceutical order
Item #DescriptionQuantityUnit PriceDiscountPrice
A-3675Topical anesthetic20$ 4.00$ – 0$ 80.00
A-2466Oral antibiotic30$ 15.00$ 5.00$ 445.00
D-5570Antihistamine, oral route25$ 1.20$ – 0$ 30.00
P-1134Children’s analgesic50$ 2.50$ 7.00$ 118.00
S-2559Sedative, oral route20$ 10.00$ 3.00$ 197.00
K-1288Topical ointment10$ 90.00$ 10.00$ 890.00
K-1503Topical steroid cream30$ 7.00$ – 0$ 210.00
Invoice subtotal$ 1,970.00
Tax rate8.03%
Sales tax$ 158.09
Total$ 2,128.09

Invoice Tracker

Invoices
Total from invoices:Number of invoices:Date:
$ 39,782.0934/12/21
Invoice #ClientInvoice DateInvoice AmountInvoice Due DatePaid?Days DueService ChargeAmount Due
2-876-0Northpoint Clinic4/3/212128.095/3/21N211.5%$ 2,128.09
2-901-4Hennepin Hospital4/3/214506.225/3/21N211.7%$ 4,506.22
1-993-7Park Central Health3/2/212547.244/2/21N-101.5%$ 2,585.45
1-976-3GHA Healthcare3/2/213987.044/2/21Y01.5%$ 3,987.04
1-635-6Minnesota Medical2/1/212674.483/1/21N-421.5%$ 2,714.60
1-735-0Northpoint Clinic3/2/212207.374/2/21Y01.5%$ 2,207.37
1-720-8Hennepin Hospital3/2/214055.894/2/21N-101.7%$ 4,124.84
1-687-3GHA Healthcare2/1/214128.163/1/21Y01.5%$ 4,128.16
1-635-6Minnesota Medical2/1/212674.483/1/21N-421.5%$ 2,714.60
1-547-2Park Central Health2/1/212840.383/1/21Y01.5%$ 2,840.38
1-480-7MHC Urgent Care1/4/213994.872/4/21Y01.5%$ 3,994.87
1-408-9GHA Heathcare1/4/213850.482/4/21Y01.5%$ 3,850.48
Total$ 39,782.09
Avg. Invoice Amount:
Max. Invoice Amount:
Min. Invoice Amount:
0 replies

Leave a Reply

Want to join the discussion?
Feel free to contribute!

Leave a Reply