questions 1&2

Grant budget an approved by TWIT The below table reflects the three year summary budget an approved by TWIT.This budget is in TOS. Table 1: Full TWIT Budget Category Year 1 Year 3 Total Personnel 495 000 720 000 840 000 2055 000 Travel 82 500 120 000 140 000 342 500 Program Activities 206250 350 000 300 000 60000 Administration Cost 20000 Total 325 000 200 000 140 000 425 000 Table Grant Information Grant Number Donor Start Date End Date P001 31-Dec-2015 P002 01. 2012 01-Jan-2015 01. 2015 31-Dec-2017 31-Dec-2016 PR8003 MAC PR8004 01. 2015 31 Dec 2015 PRBOOS 01 Nov 2015 30 Nov 2015 01-Feb-2014 31. Jan 2015 The following table is an extract from the P2P lance Sheet as at 30 June 2017. These accounts relate to provisions raised for personnel expenses Table 3: P2P's General Ledger Mapping Category GL Account Number Range Start GL Account Number Range End Personnel 61010 62520 20110 Program Activities 73510 Administration Costs 84105 Attached information The detailed GL transaction listing for expenses from 01 January 2015 to 31 June 2017 is in the attached Excel Workbook Required to be completed 1. Provide a budgets actual analysis for Year across the category lines for TWIT indicating the warence for eacheory What was the actual spend under Travel for MAC in Year 2? 3. How much was spent under TWIT for Year 1 for Personnel and Program Acides? Provide your reasons for the possible variances in these two categories identified A new donor would like to fund P2P from 2018 in Malawian Kwacha MK Provide the projected budget using Year 3 TWIT Budget while a sting for inflation and using a rate of TDS: 720W Grant budget an approved by TWIT The below table reflects the three year summary budget an approved by TWIT.This budget is in TOS. Table 1: Full TWIT Budget Category Year 3 Total Personnel 495 000 720 000 840 000 2055 000 Travel 82 500 120 000 140 000 342 500 Program Activities 206250 350 000 856 250 Administration Cost 41 250 300 000 60000 200 000 17120 20000 1400 DOO Total 325 000 425 000 Table Grant information Grant Number Donor Start Date End Date P001 OFID 31-Dec-2015 P002 01.2012 01-Jan-2015 01. 2015 31-Dec-2017 31-Dec-2016 PR8003 MAC PR8004 01. 2015 31 Dec 2015 PRBOOS 01 Nov 2015 30 Nov 2015 01-Feb-2014 31. Jan 2015 The following table is an extract from the P2P Balance Sheets at 30 June 2017. These accounts relate to provisions raised for personnel expenses Table 3: P2P General Ledger Mapping Category GL Account Number Range Start GL Account Number Range End Personnel 61010 62520 20110 Program Activities 73510 Administration Costs 84105 Attached information The detailed GL transaction listing for expenses from 01 January 2015 to 31 June 2017 is in the attached Excel Workbook Required to be completed 1. Provide a budgets actual analysis for Year across the category lines for TWIT indicating the variance for each Geory What was the actual spend under Travel for MAC in Year 2? 3. How much was spent under TWIT for Year 1 for Personnel and Program Acides? Provide your reasons for the possible variances in these two categories identified A new donor would like to fund P2P from 2018 in Malawian Kwacha MK Provide the projected budget using Year 3 TWIT Budget while a sting for inflation and using a rate of TDS: 720W 50training | Dashb... Grant budget as approved by TWIT The below table reflects the three year summary budget as approved by TWIT. This budget is in TDS. Table 1: Full TWIT Budget Category Year 1 Year 2 Year 3 Total Personnel 495 000 720 000 840 000 2 055 000 Travel 82 500 120 000 140 000 342 500 Program Activities 206 250 300 000 350 000 856 250 Administration Costs 41 250 60 000 70 000 171 250 Total 825 000 1 200 000 1 400 000 3 425 000 Table 2: Grant Information Grant Number Donor End Date Start Date 01-Jan-2012 PRB001 31-Dec-2015 DFID TWIT PRB002 01-Jan-2015 31-Dec-2017 PRB003 MAC 01-Jan-2015 31-Dec-2016 PRB004 DOH 31-Dec-2015 PRBOO5 01-Jan-2015 01-Nov-2015 01-Feb-2014 ELMA UN 30-Nov-2015 PRB006 31-Jan-2015 The following table is an extract from the P2P Balance Sheet as at 30 June 2017. These accounts relate to provisions raised for personnel expenses. Table 3: P2P's General Ledger Mapping Category GL Account Number Range Start GL Account Number Range End Personnel 61010 62520 Travel 70110 73440 Program Activities 73510 83110 Administration Costs 84105 86060 Attached information The detailed GL transaction listing for all PRB expenses from 01 January 2015 to 31 June 2017 is in the attached Excel Workbook. Required to be completed 1. Provide a budget vs actual analysis for Year 3 across the budget category lines for TWIT indicating the variance for each category. 2. What was the actual spend under Travel for MAC in Year 2? Grant budget an approved by TWIT The below table reflects the three year summary budget an approved by TWIT.This budget is in TOS. Table 1: Full TWIT Budget Category Year 1 Year 3 Total Personnel 495 000 720 000 840 000 2055 000 Travel 82 500 120 000 140 000 342 500 Program Activities 206250 350 000 300 000 60000 Administration Cost 20000 Total 325 000 200 000 140 000 425 000 Table Grant Information Grant Number Donor Start Date End Date P001 31-Dec-2015 P002 01. 2012 01-Jan-2015 01. 2015 31-Dec-2017 31-Dec-2016 PR8003 MAC PR8004 01. 2015 31 Dec 2015 PRBOOS 01 Nov 2015 30 Nov 2015 01-Feb-2014 31. Jan 2015 The following table is an extract from the P2P lance Sheet as at 30 June 2017. These accounts relate to provisions raised for personnel expenses Table 3: P2P's General Ledger Mapping Category GL Account Number Range Start GL Account Number Range End Personnel 61010 62520 20110 Program Activities 73510 Administration Costs 84105 Attached information The detailed GL transaction listing for expenses from 01 January 2015 to 31 June 2017 is in the attached Excel Workbook Required to be completed 1. Provide a budgets actual analysis for Year across the category lines for TWIT indicating the warence for eacheory What was the actual spend under Travel for MAC in Year 2? 3. How much was spent under TWIT for Year 1 for Personnel and Program Acides? Provide your reasons for the possible variances in these two categories identified A new donor would like to fund P2P from 2018 in Malawian Kwacha MK Provide the projected budget using Year 3 TWIT Budget while a sting for inflation and using a rate of TDS: 720W Grant budget an approved by TWIT The below table reflects the three year summary budget an approved by TWIT.This budget is in TOS. Table 1: Full TWIT Budget Category Year 3 Total Personnel 495 000 720 000 840 000 2055 000 Travel 82 500 120 000 140 000 342 500 Program Activities 206250 350 000 856 250 Administration Cost 41 250 300 000 60000 200 000 17120 20000 1400 DOO Total 325 000 425 000 Table Grant information Grant Number Donor Start Date End Date P001 OFID 31-Dec-2015 P002 01.2012 01-Jan-2015 01. 2015 31-Dec-2017 31-Dec-2016 PR8003 MAC PR8004 01. 2015 31 Dec 2015 PRBOOS 01 Nov 2015 30 Nov 2015 01-Feb-2014 31. Jan 2015 The following table is an extract from the P2P Balance Sheets at 30 June 2017. These accounts relate to provisions raised for personnel expenses Table 3: P2P General Ledger Mapping Category GL Account Number Range Start GL Account Number Range End Personnel 61010 62520 20110 Program Activities 73510 Administration Costs 84105 Attached information The detailed GL transaction listing for expenses from 01 January 2015 to 31 June 2017 is in the attached Excel Workbook Required to be completed 1. Provide a budgets actual analysis for Year across the category lines for TWIT indicating the variance for each Geory What was the actual spend under Travel for MAC in Year 2? 3. How much was spent under TWIT for Year 1 for Personnel and Program Acides? Provide your reasons for the possible variances in these two categories identified A new donor would like to fund P2P from 2018 in Malawian Kwacha MK Provide the projected budget using Year 3 TWIT Budget while a sting for inflation and using a rate of TDS: 720W 50training | Dashb... Grant budget as approved by TWIT The below table reflects the three year summary budget as approved by TWIT. This budget is in TDS. Table 1: Full TWIT Budget Category Year 1 Year 2 Year 3 Total Personnel 495 000 720 000 840 000 2 055 000 Travel 82 500 120 000 140 000 342 500 Program Activities 206 250 300 000 350 000 856 250 Administration Costs 41 250 60 000 70 000 171 250 Total 825 000 1 200 000 1 400 000 3 425 000 Table 2: Grant Information Grant Number Donor End Date Start Date 01-Jan-2012 PRB001 31-Dec-2015 DFID TWIT PRB002 01-Jan-2015 31-Dec-2017 PRB003 MAC 01-Jan-2015 31-Dec-2016 PRB004 DOH 31-Dec-2015 PRBOO5 01-Jan-2015 01-Nov-2015 01-Feb-2014 ELMA UN 30-Nov-2015 PRB006 31-Jan-2015 The following table is an extract from the P2P Balance Sheet as at 30 June 2017. These accounts relate to provisions raised for personnel expenses. Table 3: P2P's General Ledger Mapping Category GL Account Number Range Start GL Account Number Range End Personnel 61010 62520 Travel 70110 73440 Program Activities 73510 83110 Administration Costs 84105 86060 Attached information The detailed GL transaction listing for all PRB expenses from 01 January 2015 to 31 June 2017 is in the attached Excel Workbook. Required to be completed 1. Provide a budget vs actual analysis for Year 3 across the budget category lines for TWIT indicating the variance for each category. 2. What was the actual spend under Travel for MAC in Year 2