excel
Jellyyyyyy
CourtyardMedical-02.xlsxLookup_Data
| Product ID | Description | Cost | Retail | Margin | Company | Service Charge | ||
| CMP-006 | Acetaminophen | $2.50 | $3.99 | Green Cross | 2% | |||
| CMP-001 | Tongue depressor | $0.55 | $1.99 | IrisMed | 2.15% | |||
| CMP-002 | Cough drops | $0.85 | $1.29 | Medeye | 1.75% | |||
| CMP-003 | Nasal spray | $3.45 | $5.99 | Westville | 2% | |||
| CMP-004 | Antiseptic wash | $2.75 | $4.99 | |||||
| CMP-005 | Disinfectant wipes | $1.25 | $3.99 | |||||
| CMP-007 | Bandage, 1 inch strips | $1.25 | $3.99 | |||||
| CMP-008 | Bandage, 2 inch strips | $1.25 | $3.99 | |||||
| CMP-009 | Bandage, assorted | $1.75 | $4.99 | |||||
| CMP-010 | Ibuprofen | $2.50 | $3.99 | |||||
| CMP-011 | Cough syrup | $2.25 | $4.99 | |||||
| CMP-012 | Antibiotic ointment | $2.25 | $5.99 | |||||
| CMP-013 | Moisture lotion | $1.55 | $4.99 | |||||
| CMP-014 | Dandruff shampoo | $2.75 | $5.99 | |||||
| CMP-015 | Insect bite gel | $3.55 | $6.99 |
Pharmacy
| Courtyard Medical Plaza | |||||
| Pharmacy Inventory | |||||
| Product ID | Description | Cost | Retail | Margin | Quantity |
| CMP-006 | Acetaminophen | 12 | |||
| CMP-012 | Antibiotic ointment | 8 | |||
| CMP-004 | Antiseptic wash | 7 | |||
| CMP-007 | Bandage, 1 inch strips | 10 | |||
| CMP-008 | Bandage, 2 inch strips | 5 | |||
| CMP-009 | Bandage, assorted | 8 | |||
| CMP-002 | Cough drops | 12 | |||
| CMP-011 | Cough syrup | 9 | |||
| CMP-014 | Dandruff shampoo | 5 | |||
| CMP-005 | Disinfectant wipes | 15 | |||
| CMP-010 | Ibuprofen | 8 | |||
| CMP-015 | Insect bite gel | 15 | |||
| CMP-013 | Moisture lotion | 7 | |||
| CMP-003 | Nasal spray | 4 | |||
| CMP-001 | Tongue depressor | 6 | |||
| Total Value at Cost | |||||
| Total Value at Retail | |||||
Optometry
| Courtyard Medical Optometry | ||||||
| Patient ID | Initial Visit | Insurance | Prescription | Billable | Deductible | Patient Responsibility |
| OP0001 | 3/3/14 | Medeye | Gas Permeable | $125.00 | $50.00 | |
| OP0002 | 5/6/13 | IrisMed | Soft | $185.00 | $50.00 | |
| OP0003 | 8/12/14 | Medeye | Glasses | $235.00 | $75.00 | |
| OP0004 | 4/4/14 | Westville | Glasses | $135.00 | $75.00 | |
| OP0005 | 7/8/14 | Medeye | Soft | $245.00 | $50.00 | |
| OP0006 | 2/1/15 | IrisMed | Soft | $275.00 | $100.00 | |
| OP0007 | 3/7/15 | IrisMed | Soft | $325.00 | $100.00 | |
| OP0008 | 12/3/14 | Westville | Gas Permeable | $175.00 | $75.00 | |
| OP0009 | 9/7/13 | Green Cross | Gas Permeable | $195.00 | $50.00 | |
| OP0010 | 8/15/15 | Green Cross | Soft | $200.00 | $75.00 | |
| OP0011 | 11/14/14 | Green Cross | Soft | $225.00 | $100.00 | |
| OP0012 | 6/8/15 | IrisMed | Soft | $200.00 | $100.00 | |
| OP0013 | 5/3/14 | Medeye | Glasses | $475.00 | $100.00 | |
| OP0014 | 4/18/14 | IrisMed | Soft | $235.00 | $75.00 | |
| OP0015 | 3/17/14 | IrisMed | Soft | $235.00 | $75.00 | |
| OP0016 | 2/3/15 | Green Cross | Soft | $225.00 | $75.00 | |
| OP0017 | 4/12/15 | Green Cross | Gas Permeable | $185.00 | $50.00 | |
| OP0018 | 3/21/14 | Westville | Gas Permeable | $195.00 | $50.00 | |
| OP0019 | 2/18/15 | Westville | Soft | $225.00 | $75.00 | |
| OP0020 | 10/5/14 | Medeye | Glasses | $375.00 | $100.00 | |
| Average Billable | ||||||
| Maximum Billable | ||||||
| Minimum Billable | ||||||
| Green Cross | ||||||
| IrisMed | ||||||
| Medeye | ||||||
| Westville |
Insurance
| Courtyard Medical Optometry | |||
| Bill Date | Insurance | Amount | Total with Service Charge |
| 9/7/13 | Green Cross | $195.00 | |
| 8/15/15 | Green Cross | $200.00 | |
| 11/14/14 | Green Cross | $225.00 | |
| 2/3/15 | Green Cross | $225.00 | |
| 4/12/15 | Green Cross | $185.00 | |
| 5/6/13 | IrisMed | $185.00 | |
| 2/1/15 | IrisMed | $275.00 | |
| 3/7/15 | IrisMed | $325.00 | |
| 6/8/15 | IrisMed | $200.00 | |
| 4/18/14 | IrisMed | $235.00 | |
| 3/17/14 | IrisMed | $235.00 | |
| 3/3/14 | Medeye | $125.00 | |
| 8/12/14 | Medeye | $235.00 | |
| 7/8/14 | Medeye | $245.00 | |
| 5/3/14 | Medeye | $475.00 | |
| 10/5/14 | Medeye | $375.00 | |
| 4/4/14 | Westville | $135.00 | |
| 12/3/14 | Westville | $175.00 | |
| 3/21/14 | Westville | $195.00 | |
| 2/18/15 | Westville | $225.00 | |
Payments
| Courtyard Medical Optometry | ||
| Patient Payment Amounts | ||
| Two-Year Financing | ||
| Amount Financed | Payment @ 2.75% | Payment @ 3.25% |
| $500.00 | ||
| $600.00 | ||
| $700.00 | ||
| $800.00 | ||
| $900.00 | ||
| $1,000.00 | ||
1
2
3
4
5
6
7
8
9
A
B
C
Product ID
Description
Cost
CMP-006
Acetaminophen
$2.50
CMP-001
Tongue depressor
$0.55
CMP-002
Cough drops
$0.85
CMP-003
Nasal spray
$3.45
CMP-004
Antiseptic wash
$2.75
CMP-005
Disinfectant wipes
$1.25
CMP-007
Bandage, 1 inch strips
$1.25
CMP-008
Bandage, 2 inch strips
$1.25
