Changes between Version 37 and Version 38 of TransitionMaintenance


Ignore:
Timestamp:
12/16/13 17:24:34 (3 years ago)
Author:
ed
Comment:

--

Legend:

Unmodified
Added
Removed
Modified
  • TransitionMaintenance

    v37 v38  
    55== Monthly maintenance budget == 
    66 
    7 NB: Ed realised his maths is up the spout on 3/12 and that the monthly amount approved from the board meet was £6,000 + £3,250 = £9,250 = £770 per month. Ed has to edit the page and the timesheets for techs spreadsheet to reflet this. Ed thinks it boils back to his miscalculation for the board report in July but needs to assess...  
    8 NB: 16/12: we have some extra budget to cover the maintenance up to £1,000 per month for December 2013 - March 2104 - Hurray!  
     7* We have a target of 22 hours per month for ongoing site maintenance (equivalent to £770 per month) 
     8* We have an absolute maximum of 28 hours per month (equivalent to £1,000 per month) 
     9* We seem to be cruising at 24 hours per month (roughly £850) at 16/12) 
    910 
    10 £1,000 = approx 28 hours at an average (rounded down by not particularly scientifically so be careful) of £35p/h 
     11The assumed average hourly rate on which this is based is £35 p/h to take into account different tech's hourly rates. However, if a more expensive tech uses up more time, this can bend the money, while staying the time allowance - Beware.  
    1112 
    12 Most of this work will be around website hosting and maintenance, but there will be times when developers do stuff too.  
     13Most of this work will be around website hosting and maintenance, but there will be times when developers (more expensive) do stuff too.  
    1314 
    1415All work done for this needs to be on tickets categorised with the milestone maintenance; it is possible to have different categories (task, enhancement etc.) 
     16 
     17There have been various changes over this year which you can read about in the budget confusion section at the bottom of this page, which Ed has kept for posterity and if we need to refer to it later when we are reckoning budgets at the end of March 2014. Please don't delete these.  
    1518 
    1619== Monthly process in detail == 
     
    3336== Month's times ongoing == 
    3437 
     38* April 2013: 13:35 hrs: £421.89 billed 
     39* May 2013: 23.68 hrs: £773.39 billed 
     40* June 2013 34.93 hrs: £1,116.50 billed: Massive month with load spikes in particular and a lot of BOA work. 
     41 
     42* July 2013: 22.55 hrs: £900.69 billed: Another big month, and included 5 hrs of design time to patch up Transition Culture.  
     43* August 2013: 3.4 hrs: £118.50 billed: Very quiet - all techs on holiday. A lot of site problems though. Lots of time outs.  
     44* September 2013: 38.34 hrs: £1,367 billed: Big month; lots of drupal and server work to sort out performance issues. 
     45 
     46* October 2013: 33.57 hrs: £1,210.45 billed: Another big month 
     47* November 2013: 23.88 hrs: £808.81 billed: Calmer month. 
     48* December 2013: ... [month's total]: [£to bill]. ...  
     49 
     50 
     51== Quarterly totals and averages == 
     52 
     53* Q2: April-June 2013: 71.96 hours total: average per month: 24 
     54* Q3: July-Septe 2013: 70.44 hours total: average per month: 23.48 
     55* Q4: Oct-Decemb 2013:  
     56 
     57== Tickets and handy guide to running reports == 
     58 
     59* You can view tickets with the Milestone set to Maintenance on this page: https://tech.transitionnetwork.org/trac/report/3 
     60* Help about using TRAC to run monthly reports using start and end dates here [[TransitionTrac]] 
     61* We should, one day, copy the macro here to generate a list on this wiki page, http://www.gossamer-threads.com/lists/trac/users/48563 
     62 
     63== Notes about budget confusion here for posterity == 
     64 
     65Ed realised his budgetary maths was askew on 3/12 and that the monthly amount approved from the board meet was £6,000 + £3,250 = £9,250 = £770 per month. Somehow he had asked them for not enough money based on his assessment of 2013 Q2, and then incorrectly divvied up the money he got, assuming he got £1,027 per month instead of £770 - when actually he needed approx £840. So there is some confusion, and lots of the monthly analysis is now irrelevant, which he has since deleted for simplicity's sake. During this panic, Sally pointed out that the web and IT budget, within which this maintenance stream lives, is doing well to date and is, as a whole, under-budget, so this stream's confusion could be absorbed as Ed has spent less in other places. THEN: Since this panic, we have uncovered some excess in the Inner Transition budget which can bring £230 per month to the maintenance budget, so we can have a ceiling of £1,000 per month. Ed is targetting 22-24 hours done per month for Sam in 2014.  
     66 
     67=== Changes made in July following board meeting and new budget and daily rate === 
     68 
     69Following the web maintenance report to the board at the end of the first quarter (April to end of June 13), the board agreed to raise the web maintenance budget by £3,250, taking it to total £9,250.  
     70 
     71This gives us a quarterly budget of £2,312.50, and a monthly budget of £770. Ed took the mean hourly rates from Q1's invoices and will work on a higher estimate of £35 p/h for Q2 onwards to give us some space. So with the higher monthly budget and the higher daily rate estimate, we have a target of 22 hours for maintenance.  
     72 
     73''NB: this italics is OUT OF DATE: Keeping this here as Ed did some BAD maths - This gives us a quarterly budget of £3,08.33, and a monthly budget of £1,027.77. Ed took the mean hourly rates from Q1's invoices and will work on a higher estimate of £35 p/h for Q2 onwards to give us some space. So with the higher monthly budget and the higher daily rate estimate, we have a target of 29.4 hours for maintenance. ACTUALLY, Ed's maths was bad at assessment, and then break down - as the average monthly maintenance April-June /13 is 24 hours per month. So Ed really doesn't know what was going on.'' 
     74 
     75 
     76=== Month's times ongoing === 
     77 
     78''NB: these are Ed's OLD NOTES - NOT THE ONGOING ONES - SO IGNORE THEM - THEY ARE ONLY HERE FOR POSTERITY'' 
     79 
    3580 * April 2013: 13:35 hrs: £421.89 billed. 2.65 hrs leftover 
    3681 * May 2013: 23.68 hrs: £773.39 billed. -4.98 hrs leftover, £195.28 in debt. 
     
    4691* December 2013: ... [month's total]: [£to bill]. ...  
    4792 
    48 == Changes made in July following board meeting and new budget and daily rate == 
    49  
    50 Following the web maintenance report to the board at the end of the first quarter (April to end of June 13), the board agreed to raise the web maintenance budget by £3,250, taking it to total £9,250.  
    51  
    52 This gives us a quarterly budget of £2,312.50, and a monthly budget of £770. Ed took the mean hourly rates from Q1's invoices and will work on a higher estimate of £35 p/h for Q2 onwards to give us some space. So with the higher monthly budget and the higher daily rate estimate, we have a target of 22 hours for maintenance.  
    53  
    54 ''Keeping this here as Ed did some BAD maths - this italics is OUT OF DATE: This gives us a quarterly budget of £3,08.33, and a monthly budget of £1,027.77. Ed took the mean hourly rates from Q1's invoices and will work on a higher estimate of £35 p/h for Q2 onwards to give us some space. So with the higher monthly budget and the higher daily rate estimate, we have a target of 29.4 hours for maintenance. ACTUALLY, Ed's maths was bad at assessment, and then break down - as the average monthly maintenance April-June /13 is 24 hours per month. '' 
    55  
    56 == Quarterly totals and averages == 
    57  
    58 * Q2: April-June 2013: 71.96 hours total: average per month: 24 
    59 * Q3: July-Septe 2013: 70.44 hours total: average per month: 23.48 
    60 * Q4: Oct-Decemb 2013:  
    61  
    62  
    63  
    64 == Tickets and handy guide to running reports == 
    65  
    66 * You can view tickets with the Milestone set to Maintenance on this page: https://tech.transitionnetwork.org/trac/report/3 
    67 * Help about using TRAC to run monthly reports using start and end dates here [[TransitionTrac]] 
    68 * We should, one day, copy the macro here to generate a list on this wiki page, http://www.gossamer-threads.com/lists/trac/users/48563