Wednesday, November 6, 2013

POST TRIP MUSINGS: THE FINANCIALS

People have been asking how much everything ended up costing....where did my donations go??? I decided to include this for anyone to see. These costs are ONLY for the room itself...I ended up spending MUCH more than that on other projects for the kids....ALL I can say is that when I heard that still small voice telling me I was to build the "best" for the "least" , I would NOT have to spend a dime of my own money. Well...I can tell you, that at the time I thought I was only sleep deprived and possibly hallucinating when I was asked to build this clinic, but I went with it...what did I have to lose?

Funny thing is God never lies....I chuckled to myself when I saw that the donations matched the costs nearly perfectly...if this is not a sign to live in trust and faith...I don't know what is....


BETHLEHEM HOME REHAB RENOVATION COSTS
(Un-foreseen costs marked in italics)
AS OF Jan 13, 2013

MASON WORK: (Robert)
Estimate of 425,000

·      (29/10/12) for estimate #1 including; 170,000 given for cement (estimate for 168,000 but no change available) PIF to Robert
·      (3/11/12) 29,000: for cement blade + Boda PIF to Robert
·      (3/11/12) 40,000 for metal cutting blade + Boda PIF to Robert
·      (6/11/12) 105,000 for estimate #2 PIF to Robert
·      (7/11/12) 30,000 advance on labor PIF to Robert
·      (8/11/12) 40,000 extra tiles and supplies PIF to Robert
·      (15/11/12) 120,000 for the remaining labor costs PIF to Robert
·      (17/11/12) 65,000 for Boda and towel racks PIF to Robert
·      (21/11/12) 25,000 for towel rack PIF to supplier
·      (27/11/12) 30,000 for wire housing and boda PIF to Robert
·      (8,11,14/12/12): 60,000 to fix roof leak and broken tile cement, grout, tile and boda PIF to Robert
·      (18/12/12): 200,000 Drill/drill bits and power cord extension to finish small project plus Boda: PIF to supplier
·      (3/1/13): 25,000 (screws/files for doorstop and to drop urinals) and boda: PIF to Robert
·      (5/1/13): 10,000 for screws for Phillip’s walker and boda: PIF to Robert
·      (8/1/13): 136,000 for 4 grab bars for urinals and boda: PIF to Michael and supplier
SUBTOTAL 13/1/13: $1,085,000.00 UGX
(Still need to pay Mason recent labor costs)

PAINTER: (Alfred)

·      (26/11/12) 32,000: Supplies to paint: brushes, tarp, tape, filler; PIF to supplier
·      (26/11/12) 10,000: for paint stick, thinner: PIF to supplier
·      (26/11/12) 9,500: Kerosene (thinner) and can to hold it in; PIF to supplier
·      (26/11/12) 331,125:Paint from Sandolin including 2 tins of ceiling matte paint; 7 ½ liter cans of trial samples; 2 rollers; 4 tins of undercoat; sandpaper PIF to supplier
·      (26/11/12) 150,000: private hire; PIF to Alex the driver
·      (27/11/12) 20,000: for filler and boda; PIF to Alfred
·      (28/11/12) 114,500: for paint and Boda transport: PIF to suppliers
·      (30/11/12) 307,472: base color paint 5 tins of 4 L for bathroom and main room as well as 5 tins of ½ L primary colors for the artists: PIF to supplier
·      (30/11/12) 50,00 for supplies used 41,000 PIF to Alfred
·      (1/12/12) 100,000 for thinner: PIF to Alfred
·      (3/12/12) 17,000 transport to and from store and Busega; PIF to Michael
·      (4/12/12) 5,000: masking tape; PIF to Alfred
·      (19/12/12) 60,000: Labor cost for 3 days work; PIF to Alfred
·      (19/12/12) 23,000: touch up paint for metal doors and bathroom and ceiling: PIF to Alfred
·      (19/12/12) 20,000: supplies (thinner, roller, paint for metal) PIF to Alfred
·      (19/12/12) 40,000: 2 days boda transport for errands; PIF to Michael
SUBTOTAL 13/1/13: $1,289,597.00 UGX






MISCELLANEOUS (cleaning fees/wood touch ups and re-varnish/roof repair):
·      (5/12/12) 10,000 for clear varnish and boda; PIF to Alfred
·      (5/12/12) 40,500 for miscellaneous supplies for the door/doors stops/glue/waterproofing for the cement/etc; PIF to supplier
·      (6/12/12) 34,000 Boda transport to and from Bai hospital, downtown electrical shop; to get passport photos for Special Permit
·      (10/12/12) 50,000 Boda to and from 2 tile shops and then to Busega then to Katalemwa and back: PIF to Michael
·       (19/12/12) 10,000: Labor to boy who chipped roof crack to prep for waterproofing
·      (19/12/12) 13,500 for fabric for Rogers school trousers: PIF to supplier

MISCELLANEOUS: Katalemwa
·      (10/12/12) 710,000 for 50% down payment on PT equipment at Katalemwa; PIF Katalemwa


MISCELLANEOUS: Office supplies
·      (11/1/13) 101,000: for hole punch, file folders and boda (x 2 days): PIF to supplier and Michael
SUBTOTAL 13/1/13: $969,000.00 UGX

(Still need to pay second ½ of equipment purchase from Katalemwa; still need locking cabinet for PT equipment and legal sized file cabinet drawer; still need to have some equipment made)


WELDER: (Godfrey)
Estimate of 578,500
·      (17/11/12) 80,000: down payment on door and railings; PIF to Godfrey
·      (20/11/12) 200,000: for rest of down payment on door and railings; PIF to Godfrey
·      (22/11/12) 150,000: for the remaining supplies; PIF to Godfrey
·      (27/11/12) 150,000: remaining balance on work done; PIF to Godfrey
·      (4/12/12) 25,000: for repair work on the railings; PIF to Godfrey
SUBTOTAL 13/1/13: $605,000.00 UGX


CARPENTER: (through Godfrey)
Estimate of 65,000/actual cost of 65,000
·      (20/11/12) 40,000 down payment on PT door attachment; PIF to carpenter
·      (27/11/12) 25,000 for work completed; PIF to carpenter
SUBTOTAL 13/1/13: $65,000.00 UGX

ARTISTS: (Dan and Nicholas)
Estimate of 800,000.00 for labor & Carol provides supplies
·      (28/11/12) 15,000 Transport for coming to Busega 2 x: PIF to Nic and Dan
·      (29/12/12) 47,000: for brushes and boda transport; PIF to Nicholas
·      (5/12/12) 7,000: for thinner and boda; PIF to Dan
·      (22/12/12) 50,000 for transport: PIF to Dan
·      (4/1/13) 20,000 for transport: PIF to Dan
·      (5/1/13) 400,000 for labor advance Nicholas’s labor: PIF to Nicholas
·      (11/1/13) 39,000 for paint and boda: PIF to Michael and supplier
·      (11/1/13) 200,00 for labor advance for Nicholas: PIF Nicholas
SUBTOTAL 13/1/13: $778,000.00 UGX
(Still need to pay remainder of labor and transport costs)


Rehab department visits: (Katalemwa; Mulago; Corsu)
·      (30/11/12) 85,000: private hire transport for nurse Christine and I (picked up 5 tins of paint for rehab room on the way home): PIF to driver
SUBTOTAL 13/1/12: $85,000.00 UGX
(Still need to visit Corsu)


MISCELLANEOUS Electrical: (Edison and Joseph)
·      (3/12/12) 273,000: light fixtures (29,000 each and bulbs 10,000 each); PIF to supplier
·      (3/12/12) 27,000: shopping/time to consult (includes boda); PIF to Edison
·      (3/12/12) 17,000: Boda to and from downtown; PIF to Michael
·      (5/12/12) 25,000 to install the light fixtures; PIF to Joseph
·      (6/12/12) 29,000 to replace a light fixture broken by the children
SUBTOTAL 13/1/13: $371,000.00 UGX
(Still need to install one more outlet in gym)






·     $1,085,000.00 (Mason)
·     $1,289,597.00 (Painter)
·     $969,000.00    (Miscellaneous)
·     $605,000.00    (Metal worker)
·     $65,000.00       (Carpenter)
·     $778,000.00    (Artists)
·     $85,000.00      (Rehab visits)
·     $371,000.00    (Electrician)

RENOVATION COSTS: $5,247,597.00 UGX
OR: $2,012.89 USD
(At exchange rate of $2,607.00 shillings per dollar)


Subtotal Costs 2012:
·     Equipment purchased for MOP: $3,035.27 USD
·     Cost of renovations: $2,012.89 USD

TOTAL COSTS 2012: $5,048.16 USD

Subtotal Donations 2012:
·     Sept/Oct 2012: $2,750.00
·     Dec 2012: $1,449.17

TOTAL DONATIONS FOR 2012: $4,199.17 USD

FINAL AMOUNT NOT COVERED BY DONATIONS: $848.99

(NOTE: This FINAL amount is what Carol Paid on her own)









ADDITONAL PROJECTS/REMAINDER COSTS (FROM 2012) FOR YEAR 2013

MIRRORS (Jamile):
·      (31/5/13) 350,000: Original bid for 2 mirrors/supplies PIF Jamile
·      (2/7/13) 720,000: Replacement of 2 broken mirrors/transport/labor and parts PIF to Jamile
·      (6/8/13) 204,000: Replacement of 3rd broken mirror PIF Jamile
·      (12/6/13) 317,300: Mat behind the mirrors for cushion PIF Game
·      (13/6/13) 50,900: Supplies for mounting mirrors
·      (17/6/13) 25,000: Supplies to mount padding behind mirrors
·      (22/6/13) 21,600: Larger plugs and screws for remounting mirrors

SUB-TOTAL FOR YEAR 2013: 1,688,000.00 UGX
*** PROJECT GRAND TOTAL 1,688,000.00 UGX***


ARTISTS: (Dan and Nicholas)
·      (28/1/13) 200,000: remainder of labor costs to Dan;
·      (28/1/13) 500,000: Renegotiated labor addition since mural took 2 months

Estimate for new project for 2 mirrors and 1 sculpture (including supplies and transport): 1,285,000.00 UGX
·      (27/6/13) 150,000: Down payment PIF to Dan and Nicholas
·      (9/7/13)  600,000: Balance paid to Dan and Nicholas
·      (9/7/13) 150,000: Down payment for sculpture PIF to Dan
·      (26/7/13) 350,000: Balance PIF to Dan

SUB-TOTAL FOR YEAR 2012: 778,000.00 UGX
SUB-TOTAL FOR YEAR 2013:  1,985,000.00 UGX
*** PROJECT GRAND TOTAL 2,763,000.00 UGX***



CARPENTER: (Sunday from the deaf school) swings/mirror project/stools Estimate of 641,000.00 + 180,000.00 = 821,000.00 UGX
·      (11/7/13) 400,000: Down payment to Sunday
·      (29/7/13) 240,000: Partial balance for equipment 
·      (2/8/13) 100,000: Remaining balance for mirror frame install + tip + transport
·      (14/8/13) 90,000: Down payment for remainder project
·      (22/8/13) 100,000: Balance + tip
PROJECT SUB-TOTAL:  930,000.00 UGX

CARPENTER: (Alex)
·      (11/6/13) 190,000: Replacements locks for PT room doors
·      (13/6/13) 30,000: Wood for swivel table top
·      (13/6/13) 20,000: Wood/hardware for door flap (no receipt)
·      (2/8/13) 70,000: Labor for table top/door flap on bottom of PT room door/installing locks/cutting down doors to meet the new floor height.
PROJECT SUB-TOTAL:  310,000.00 UGX

SUB-TOTAL FOR YEAR 2012: 65,000.00 UGX
SUB-TOTAL FOR YEAR 2013:  1,240,000.00 UGX
*** PROJECT GRAND TOTAL 1,305,000.00 UGX***

FLOOR: (Mujibu)
·      (14/5/13) 4,785,000: Tile from Youma
·      (14/5/13) 101,300.00: Supplies to install
·      (15/5/13) 100,000: Labor down payment
·      (20/5/13) 450,000: Labor balance
·      (4/8/2013) 30,000: Labor to repair broken tile

SUB-TOTAL FOR YEAR 2013:  5,436,300.00 UGX
*** PROJECT GRAND TOTAL 5,436,300.00 UGX***





WELDER: (Godfrey)
·      (1/7/13) 590,000: Bed, swivel desk; drill holes in plate and II bars
·      (5/7/13) 360,000: Rolling trolley cart
·      (24/7/13) 80,000: Repair of rolling trolley cart
·      (26/7/2013) 20,000: Weld mirror holder onto sculpture for artists
·      (16/9/13) 80,000: Scooter chair for Fred Karterega

SUB-TOTAL FOR YEAR 2012: 605,000.00 UGX
SUB-TOTAL FOR YEAR 2013:  1,130,000.00 UGX
*** PROJECT GRAND TOTAL 1,735,000.00 UGX***


MISCELLANEOUS: Katalemwa
·      (10/6/13) 310,000: Rolling mirror
·      (29/6/13) 600,200: Balance for equipment picked up
·      (6/8/13) 216,000: Remaining balance for equipment dropped off
·      (28/8/13) 46,800: Pay for Pius’s school shoe/caliper repair
·      (7/9/13) 100,000: Consult fee for 2 orthotists to come to Busega
·      (6/10/13) 20,000: Consult fee for 1 orthotist to assess Nicholas

SUB-TOTAL FOR YEAR 2012: 710,000.00 UGX
SUB-TOTAL FOR YEAR 2013:  1,293,000.00 UGX
*** PROJECT GRAND TOTAL 2,003,000.00 UGX***


MISCELLANEOUS: Curtains
·      (29/5/13) 334,000: Material and Labor
·      (31/5/13) 30,000: Labor for 2cnd set curtains
·      (2/8/13) 45,000: Curtain rods

SUB-TOTAL FOR YEAR 2013:  409,000.00 UGX
*** PROJECT GRAND TOTAL 409,000.00 UGX***

  
MISCELLANEOUS: Mat for mat table; bolster swing and positioning foam/supplies
·      (7/4/13) 60,000: Foam for positioning Paul (sacral decub) Phillip and Nicholas WC cushions.
·      (8/4/13) 50,000: Foam cutting knife
·      (05/06/13) 80,000: PT treatment mattress
·      (10/7/13) 61,000: Material for mat cover; zipper and labor to sew
·      (14/7/13) 75,000: Bed for Phillip
·      (14/7/13) 150,000: 2 beds; one for Nicholas and one for Rogers
·      (7/8/13) 62,500: Material and labor for bolster swing
·      (7/8/13) 1,000: zipper for bolster swing
·      (7/8/13) 30,000: Foam for bolster

SUB-TOTAL FOR YEAR 2013:  569,500.00 UGX
*** PROJECT GRAND TOTAL 569,500.00 UGX***


MISCELLANEOUS: Electrical
·      (18/1/13) 19,000: Labor install double outlet PIF to Joseph
·      (2/8/13) 44,000: Replacement of 2 broken light fixtures

SUB-TOTAL FOR YEAR 2012: 371,000.00 UGX
SUB-TOTAL FOR YEAR 2013:  63,000.00 UGX
*** PROJECT GRAND TOTAL 434,000.00 UGX***


MISCELLANEOUS: Cleaning/Storage supplies for rehab room
·      (11/7/13) 450,000: Locking storage cabinet
·      (5/8/13) 136,650: Storage/cleaning supplies
·      (5/8/13) 9,800: Latex gloves
·      (6/8/13) 5,000: Soap dishes
·      (7/8/13) 20,000: Mop/tubing and bucket
·      (23/8/13) 155,550: Storage/cleaning supplies
·      (28/8/13) 36,000: Cleaning supplies
·      (28/8/13) 29,300: Storage containers
·      (19/10/13) 88,150: Storage containers/office supplies

SUB-TOTAL FOR YEAR 2013:  930,450.00 UGX
*** PROJECT GRAND TOTAL 930,450.00 UGX***


MISCELLANEOUS: Office supplies
·      (29/1/13) 10,000: for key to be made + Boda; PIF to Julius
·      (7/2/13) 5,000: cleaning fee for bathroom; PIF to kids

SUB-TOTAL FOR YEAR 2012: 101,000.00 UGX
SUB-TOTAL FOR YEAR 2013:  15,000.00 UGX
*** PROJECT GRAND TOTAL 116,000.00 UGX***
 MISCELLANEOUS: Meds/Hospital bills for kids and books

·      (1/8/13) 14,500: Books for library
·      (15/8/13) 15,000: Meds for Brian at Busega
·      (23/8/13) 181,000: Medical tests for Noah
·      (23/8/13) 52,000: Medication for Noah
·      (5/8/13 week of) 40,000: Transport for brothers to visit Jorkim
·      (23/9/13) 217,000: Sibabi’s assessment at The Surgery
·      (6/10/13) 38,000: Muze Alex’s inhalers
·      (9/10/13) 44,300: Popcorn and oil for Independence Day 
·      (10/10/13) 50,000: Brian’s dermatology apt/labs
·      (16/10/13) 70,000: Transport/medical fees for ER visit for a boy given to Bro Gabriel last minute
·      (19/10/13) 17,000: Library addition “Imitation of Christ”

SUB-TOTAL FOR YEAR 2013:  738,800.00 UGX
*** PROJECT GRAND TOTAL 738,800.00 UGX***

MISCELLANEOUS: For the volunteers
·      (6/9/13) 122,400: Kettle and hair dryer
·      (13/9/13) 191,900: Doormat, lantern, batteries, kitchen, iron
·      (14/9/13) 101,600: batteries; power guard
·      (6/10/13) 83,400: Mini stabilizer

SUB-TOTAL FOR YEAR 2013:  499,300.00 UGX
*** PROJECT GRAND TOTAL 499,300.00 UGX***



MISCELLANEOUS: Secretarial work for Julius at Busega
·      (1/7/13) 35,000: Put Brother’s poems from English class on Word
·      (1/8/13) 45,000: Accurate list of all children’s names by dorm; put Nicholas’ poems on Word

SUB-TOTAL FOR YEAR 2013:  80,000.00 UGX
*** PROJECT GRAND TOTAL 80,000.00 UGX***



MASON: Robert
·       (10/6/13) 50,000: Remainder of Labor cost from 2012
·      (10/6/13) 40,000: 1 Grab bar
·      (14/6/13) 38,000: Cement/red oxide for the ramps
·      (18/6/13) 70,000: Metal plates and I bolt for sensory swing
·      (22/6/13) 90,000: Labor + 20,000 transport for days of project for mirror/grab bars/sensory swing/shopping for supplies
·      (27/6/12) 8,000: Filler for patching ceiling for swing bolt
·      (13/7/13) 18,000: Drill bits for hanging wall ladder
·      (13/7/13) 56,400: Anchors for wall ladder
·      (13/7/13) 10,000: Anchor bolts for mirrors
·      (13/7/13) 20,000: Wood for mounting wall ladder
·      (2/8/13) 13,000: Supplies for fixing leak in ceiling
·      (2/8/13) 80,000: Labor for mounting mirrors/wall ladder/shopping for supplies + 20,000 transport
·      (26/8/13) 18,000: Replacement glass for broken one over PTdoor

SUB-TOTAL FOR YEAR 2012: 1,085,000.00 UGX
SUB-TOTAL FOR YEAR 2013:  511,400.00 UGX
*** PROJECT GRAND TOTAL 1,596,400.00 UGX***


TRANSPORT: Robine
·      Monthly rate of 500,000 Starting in June/2013 paid through November/2013: 3,000,000
·      Musa: Pay calculated only from Oct 2013: 675,000

SUB-TOTAL FOR YEAR 2013:  3,675,000.00 UGX
**TRANSPORT GRAND TOTAL 3,675,000.00 UGX***


PAINTER: Alfred
·      (11/1/13) 85,000: (4 receipts) Paint from Framera; Filler; brushes and tape
·      (18/1/13) 48,000: tape/brushes/thinner: PIF to supplier
·       (25/1/13) 36,000: art brushes to paint the grills + Boda; PIF to supplier
·      (28/1/13) 112,000: Paint supplies and boda: PIF to supplier
·      (28/1/13) 46,000: labor for 2 days and 2 days travel; PIF to Alfred
·      (2/2/13) 60,000: Labor for 3 days; PIF Alfred
·      (29/5/13) 10,000: Paint supplies
·      (29/5/13) 43,000: Paint from Framera
·      (31/5/13) 50,000: Paint from Framera
·      (31/5/13) 60,000: Labor for 2 days of work
·      (11/6/13) 7,000: Thinner
·      (17/7/13) 10,000: Patch work supplies for ceiling leak
·      (3/8/13) 100,000: Labor x 5 days week 29/7/13

SUB-TOTAL FOR YEAR 2012: 1,289,597.00 UGX
SUB-TOTAL FOR YEAR 2013:  631,000.00 UGX
*** PROJECT GRAND TOTAL 1,920,597.00 UGX***


Total Renovation Costs 2013:       $20,894,750 UGX
                                    or                            $8,061.25 USD
(RATE: on 2/9/13 of 2,592 UGX per USD)

TOTAL Amazon purchases 2013: $401.97
TOTAL COST FOR 2013:                    $8,463.22

TOTAL DONATIONS FOR 2013:      $9,155.00






COSTS FOR YEAR 2012:                               $5,048.16
COSTS FOR YEAR 2013:                               $8,463.22
TOTAL PROJECT COST:                                $13,511.38


DONATIONS FOR YEAR 2012:                   $4,199.17
DONATIONS FOR YEAR 2013:                   $9,155.00
TOTAL PROJECT DONATIONS:                  $13,354.17


TOTAL COST:                                                    $13,511.38
MINUS TOTAL DONATION:                         $13,354.17
TOTAL COST CAROL COVERED:                $157.21


By the way.....I did this calculation days before receiving a final donation....you guessed it.....160.00 USD...OK that is freaky beyond freaky! 

God never lies...I never paid a penny of my own money towards the room...I spent it all on other things but the room was covered just as Mary told me in the chapel the morning I was told to do this clinic. WOW...it sort of gives me goosebumps even now....I would never in a million years believed it was possible....

ALL we have to do is be open vessels and trust...there is so much that can be worked through us for the greater good of humanity this way. 

GIVE IT A TRY...I DARE YOU!!!!!