accounting case Realizing the Dream: Decision Making in Action
Yuanye
RealizingtheDreamDataTables.xlsxIntro
| Realizing the Dream: Decision-Making in Action |
| Case 1 Data Tables |
| ** Two things to note: |
| Table 2: Tissue is only used in Scans, not in Both as indicated in the Case reading. |
| Table 5: The price for special order testing is $3.00 US, not the $2.00 stated in the Case. |
| Both of these adjustments have been made in the tables to follow. |
Table 1
| Table 1: Wallas’ Initial Investment | ||||
| Item | Cost | Cost/US$ | Depreciation Rate | Useful Life |
| Computer and Printer | GHS$ 2,160 (US$ 540) | $540 | 33.33% | 3 years |
| Furniture and Fittings | GHS$ 5,040 (US$ 1,260) | $1,260 | 20.00% | 5 years |
| Laboratory Equipment | GHS$ 56,800 (US$ 14,200) | $14,200 | 20.00% | 5 years |
| Scan Equipment | GHS$ 36,000 (US$ 9,000) | $9,000 | 20.00% | 5 years |
| Total Investment | GHS$ 100,000 (US$ 25,000) | $25,000 | – | – |
Table 2
| Table 2: Consumables Used By GEO Medical Laboratory | ||||
| Item | Cost | Service That Uses Item | Cost / Month | Cost / Patient |
| A4 paper | GHS$ 20.00 (US$ 5.00) per month | Both | $ 5.00 | |
| Alcohol | GHS$ 10.00 (US$ 2.50) per month | Lab | $ 2.50 | |
| Bandages | GHS$ 30.00 (US$ 7.50) per month | Lab | $ 7.50 | |
| Cotton | GHS$ 10.00 (US$ 2.50) per month | Lab | $ 2.50 | |
| Envelopes | GHS$ 24.00 (US$ 6.00) per month | Both | $ 6.00 | |
| Gel | GHS$ 5.00 (US$ 1.25) per patient | Scan | $ 1.25 | |
| Gloves | GHS$ 120.00 (US$ 30.00) per month | Both | $ 30.00 | |
| Reagents | GHS$ 5.00 (US$ 1.25) per patient | Lab | $ 1.25 | |
| Syringes | GHS$ 0.50 (US$ 0.125) per patient | Lab | $ 0.13 | |
| Test kits | GHS$ 5.00 (US$ 1.25) per patient | Lab | $ 1.25 | |
| Test tubes | GHS$ 1.25 (US$ 0.31) per patient | Lab | $ 0.31 | |
| Thermal print paper | GHS$ 10.00 (US$ 2.50) per patient | Scan | $ 2.50 | |
| Tissues | GHS$ 20.00 (US$ 5.00) per month | Scan | $ 5.00 | |
| Toners | GHS$ 200.00 (US$ 50.00) per quarter | Both | $ 16.67 | |
| The monthly totals figures in this table are based on a sales mix of 180 patients for scan services and 120 patients for laboratory services. The variable cost reflects the total volume of 300 patients. |
Table 3
| Table 3: Compensation Paid By GEO Medical Laboratory | ||||||
| Employee (# in category) | # in Category | Type of Compensation | Average Monthly Compensation | Per Employee | Per Month | Total |
| Administrative assistant | 1 | Salary | GHS$ 500.00 (US$ 125.00) per employee | $125.00 | ||
| Lab technicians | 2 | Salary | GHS$ 800.00 (US$ 200.00) per employee | $200.00 | ||
| Ultrasonographers | 2 | Commission | GHS$ 388.80 (US$ 97.20) per month | $97.20 | ||
| Total Compensation Payments | GHS$ 2,488.80 (US$ 622.20) per month | $622.20 |
Table 4
| Table 4: Services Offered By GEO Medical Laboratory | ||
| Scans | Price per scan | US $ |
| Abdominal, breast, or urological | GHS$ 50.00 (US$ 12.50) | $12.50 |
| Obstetrics or pelvic | GHS$ 30.00 (US$ 7.50) | $7.50 |
| Testicular | GHS$ 60.00 (US$ 15.00) | $15.00 |
| Thrombosis | GHS$ 80.00 (US$ 20.00) | $20.00 |
| Laboratory services | Price per lab | |
| Antenatal profile | GHS$ 160.00 (US$ 40.00) | $40.00 |
| Blood sugar, malaria, or typhoid tests | GHS$ 20.00 (US$ 5.00) | $5.00 |
| Chlamydia or gonorrhea tests | GHS$ 40.00 (US$ 10.00) | $10.00 |
| Cultures | GHS$ 50.00 (US$ 12.50) | $12.50 |
| Cytomegalovirus, rubella, or toxoplasma test | GHS$ 30.00 (US$ 7.50) | $7.50 |
| Full blood count | GHS$ 20.00 (US$ 5.00) | $5.00 |
| Hemoglobin level, urine routine exam, or stool routine exam | GHS$ 10.00 (US$ 2.50) | $2.50 |
| Hepatitis B or C, HIV, or syphilis tests | GHS$ 20.00 (US$ 5.00) | $5.00 |
| Hepatitis B viral load or HIVV viral load | GHS$ 450.00 (US$ 112.50) | $112.50 |
| Herpes test | GHS$ 60.00 (US$ 15.00) | $15.00 |
| Kidney function or lipid tests | GHS$ 60.00 (US$ 15.00) | $15.00 |
| Liver function or cardiac function tests | GHS$ 70.00 (US$ 17.50) | $17.50 |
| Male or female reproductive hormone test | GHS$ 360.00 (US$ 90.00) | $90.00 |
| Pap smear | GHS$ 120.00 (US$ 30.00) | $30.00 |
| Sexually transmitted infections profile | GHS$ 300.00 (US$ 75.00) | $75.00 |
| Stool occult blood test or stool test for Helicobactor pylori | GHS$ 40.00 (US$ 10.00) | $10.00 |
| We estimate that the average price for scans is GHS$36.00 (US$9.00) and the average for lab services is GHS$45.00 (US$11.25) using past information. | ||
Table 5
| Table 5: Breakdown of Cost per Male and Female Students | |||
| Special order testing for 122 male and 150 female students at GHS$ 8.00 (US$ 3.00) each | |||
| Item | Cost for Male Students | Cost for Female Students | Total cost |
| Blood grouping reagents and sickle cell | GHS$ 610.0 | GHS$ 750.00 | GHS$ 1,360.00 |
| (US$ 152.50) | (US$ 187.50) | (US$ 340.00) | |
| Gloves | GHS$ 48.80 | GHS$ 60.00 | GHS$ 108.80 |
| (US$ 12.20) | (US$ 15.00) | (US$ 27.20) | |
| Optician | GHS$ 224.26 | GHS$ 275.74 | GHS$ 500.00 |
| (US$ 56.07) | (US$ 68.94) | (US$ 125.00) | |
| Other consumables | GHS$ 263.52 | GHS$ 324.00 | GHS$ 587.52 |
| (US$ 65.88) | (US$ 81.00) | (US$ 146.88) | |
| Pregnancy test kits | – | GHS$ 750.00 | GHS$ 750.00 |
| (US$ 187.50) | (US$ 187.50) | ||
| Transportation and logistics | GHS$ 179.41 | GHS$ 220.59 | GHS$ 400.00 |
| (US$ 44.85) | (US$ 55.15) | (US$ 100.00) | |
| Total costs | GHS$ 1,326.00 | GHS$ 2,380.32 | GHS$ 3,706.32 |
| (US$ 331.50) | (US$ 595.08) | (US$ 926.58 | |
