PJM6025 Budget Assignment
usaggwp
saurabhsAssignmentno3.xlsxSheet1
| Month | 7th (July) | 8th(August) | 9th(September) | 10th(October) | |||||||
| Resources | Allowances Expenditure | Allowances Expenditure | |||||||||
| TOTAL OF EACH RESOURCE | |||||||||||
| Anderson R | Robert | $ 6,000.00 | $ 6,300.00 | $ 4,200.00 | _________ | ||||||
| $ 5,700.00 | $ 3,600.00 | ||||||||||
| $ 6,000.00 | $ 6,000.00 | ||||||||||
| $ 6,000.00 | $ 600.00 | ||||||||||
| Extra day(31st Aug) | $ 1,200.00 | MISC | $ 47.40 | ||||||||
| Total | $ 6,000.00 | $ 25,200.00 | $ 14,447.40 | $ 45,647.40 | |||||||
| Bhatt Manoj | $ 4,200.00 | $ 4,200.00 | $ 3,360.00 | $ 1,680.00 | |||||||
| $ 4,200.00 | Dallas office space usage | $ 250.00 | |||||||||
| Room Charge | $ 250.00 | $ 4,200.00 | |||||||||
| $ 4,200.00 | $ 3,360.00 | ||||||||||
| Extra day(31st Aug) | $ 840.00 | $ 2,520.00 | |||||||||
| $ 4,200.00 | $ 4,200.00 | ||||||||||
| Total | $ 4,200.00 | $ 17,890.00 | $ 17,890.00 | $ 1,680.00 | $ 41,660.00 | ||||||
| Bristol Christopher | $ 6,000.00 | $ 6,000.00 | $ 3,600.00 | _________ | |||||||
| $ 6,000.00 | MISC | $ 77.46 | |||||||||
| $ 4,200.00 | MISC | $ 368.06 | |||||||||
| TOTAL | $ 6,000.00 | $ 16,200.00 | $ 4,045.52 | $ 26,245.52 | |||||||
| Dennison Karl | $ 8,400.00 | $ 8,400.00 | $ 6,720.00 | $ 8,400.00 | |||||||
| mileage | $ 18.14 | $ 8,400.00 | |||||||||
| air | $ 560.20 | $ 6,720.00 | |||||||||
| room | $ 319.70 | $ 8,400.00 | |||||||||
| car rental | $ 122.05 | mileage | $ 17.92 | ||||||||
| other trans | $ 88.52 | air | $ 113.20 | ||||||||
| per diem | $ 132.50 | room | $ 591.72 | ||||||||
| $ 8,400.00 | car rental | $ 168.08 | |||||||||
| $ 8,400.00 | other trans | $ 82.01 | |||||||||
| $ 8,400.00 | per diem | $ 185.50 | |||||||||
| Extra day(31st Aug) | $ 1,680.00 | ||||||||||
| Total | $ 8,400.00 | $ 36,521.11 | $ 31,398.43 | $ 8,400.00 | $ 84,719.54 | ||||||
| Desmarias Yuvette | _____________ | _________ | |||||||||
| MISC | $ 265.90 | ||||||||||
| mileage | $ 33.60 | ||||||||||
| room | $ 388.70 | ||||||||||
| other trans | $ 193.69 | ||||||||||
| per diem | $ 139.50 | ||||||||||
| Total | $ 755.49 | $ 265.90 | $ 1,021.39 | ||||||||
| Hall Kreg | $ 11,000.00 | $ 11,000.00 | $ 8,800.00 | $ 11,000.00 | |||||||
| mileage | $ 110.88 | mileage | $ 110.88 | mileage | $ 110.88 | ||||||
| air | $ 1,020.80 | air | $ 541.05 | air | $ 741.10 | ||||||
| room | $ 480.70 | room | $ 801.92 | room | $ 400.20 | ||||||
| car rental | $ 175.99 | car rental | $ 190.65 | car rental | $ 97.23 | ||||||
| other trans | $ 71.91 | other trans | $ 103.70 | other trans | $ 47.34 | ||||||
| per diem | $ 132.50 | per diem | $ 238.50 | per diem | $ 132.50 | ||||||
| $ 4,125.00 | $ 8,800.00 | ||||||||||
| $ 11,000.00 | $ 11,000.00 | ||||||||||
| $ 11,000.00 | mileage | $ 110.88 | |||||||||
| mileage | $ 110.88 | air | $ 508.85 | ||||||||
| air | $ 900.74 | room | $ 681.73 | ||||||||
| room | $ 744.05 | car rental | $ 188.77 | ||||||||
| car rental | $ 188.77 | other trans | $ 51.48 | ||||||||
| other trans | $ 71.48 | per diem | $ 185.50 | ||||||||
| per diem | $ 185.50 | $ 11,000.00 | |||||||||
| Extra day(31st Aug) | $ 2,200.00 | ||||||||||
| Total | $ 11,000.00 | $ 43,519.20 | $ 43,313.91 | $ 12,529.25 | $ 110,362.36 | ||||||
| Herman Franklin B | ______ | $ 600.00 | ______ | _________ | |||||||
| $ 3,200.00 | |||||||||||
| $ 3,600.00 | |||||||||||
| $ 400.00 | |||||||||||
| Total | $ 7,800.00 | $ 7,800.00 | |||||||||
| Inampudi Bhagath | $ 7,000.00 | $ 7,000.00 | $ 5,600.00 | $ 7,000.00 | |||||||
| $ 7,000.00 | $ 4,200.00 | ||||||||||
| $ 7,000.00 | $ 7,000.00 | ||||||||||
| Room Charge | $ 250.00 | Room Charge | $ 250.00 | ||||||||
| $ 7,000.00 | $ 7,000.00 | ||||||||||
| Extra day(31st Aug) | $ 1,400.00 | ||||||||||
| Total | $ 7,000.00 | $ 29,650.00 | $ 24,050.00 | $ 7,000.00 | $ 67,700.00 | ||||||
| Jilla Sheetal | $ 6,600.00 | $ 6,600.00 | $ 5,280.00 | $ 6,600.00 | |||||||
| $ 6,600.00 | $ 5,280.00 | ||||||||||
| $ 6,600.00 | $ 6,600.00 | ||||||||||
| Room Charge | $ 250.00 | Rooam Charge | $ 250.00 | ||||||||
| $ 6,600.00 | MISC | $ 88.72 | |||||||||
| Extra day(31st Aug) | $ 1,320.00 | $ 6,600.00 | |||||||||
| Total | $ 6,600.00 | $ 27,970.00 | $ 24,098.72 | $ 6,600.00 | $ 65,268.72 | ||||||
| Katkam Satyapal | $ 5,400.00 | $ 5,400.00 | $ 4,320.00 | $ 5,400.00 | |||||||
| $ 5,400.00 | $ 4,320.00 | ||||||||||
| $ 5,400.00 | $ 5,400.00 | ||||||||||
| $ 5,400.00 | $ 5,400.00 | ||||||||||
| Extra day(31st Aug) | $ 1,080.00 | ||||||||||
| Total | $ 5,400.00 | $ 22,680.00 | $ 19,440.00 | $ 5,400.00 | $ 52,920.00 | ||||||
| Lemke Denise | $ 6,000.00 | $ 6,000.00 | $ 4,800.00 | __________ | |||||||
| $ 6,000.00 | $ 4,800.00 | ||||||||||
| $ 6,000.00 | $ 6,000.00 | ||||||||||
| $ 6,000.00 | $ 4,500.00 | ||||||||||
| Extra day(31st Aug) | $ 1,200.00 | ||||||||||
| Total | $ 6,000.00 | $ 25,200.00 | $ 20,100.00 | $ 51,300.00 | |||||||
| Parimi Rayudu | $ 4,200.00 | $ 4,200.00 | $ 3,360.00 | $ 4,200.00 | |||||||
| $ 4,200.00 | $ 4,200.00 | ||||||||||
| $ 4,200.00 | $ 4,200.00 | ||||||||||
| Rooma Charge | $ 250.00 | $ 250.00 | |||||||||
| $ 4,200.00 | $ 4,200.00 | ||||||||||
| Extra day(31st Aug) | $ 840.00 | ||||||||||
| Total | $ 4,200.00 | $ 17,890.00 | $ 16,210.00 | $ 4,200.00 | $ 42,500.00 | ||||||
| Walton John G | $ 7,200.00 | $ 8,662.50 | $ 1,687.50 | _______ | |||||||
| $ 8,662.50 | $ 1,687.50 | ||||||||||
| $ 8,550.00 | $ 1,350.00 | ||||||||||
| $ 6,412.50 | MISC | $ 662.35 | |||||||||
| MISC | $ 579.57 | ||||||||||
| Total | $ 7,200.00 | $ 32,867.07 | $ 5,387.35 | $ 45,454.42 | |||||||
| FINAL EXPENDITURE | $ 642,599.35 |
Sheet2
| Months | 1st | 2nd | 3rd | 4th (7) | 5th(8) | 6th(9) | 7th(10) | 8th | 9th | 10th | 11th | 12th | |
| Resources | |||||||||||||
| Anderson Robert | $ 6,000.00 | $ 25,200.00 | $ 14,447.40 | ||||||||||
| Bhatt Manoj | $ 4,200.00 | $ 17,890.00 | $ 17,890.00 | $ 1,680.00 | |||||||||
| Bristol Christopher | $ 6,000.00 | $ 16,200.00 | $ 4,045.52 | ||||||||||
| Dennison Korl | $ 8,400.00 | $ 36,521.11 | $ 31,398.43 | $ 8,400.00 | |||||||||
| Hall Kerg | $ 11,000.00 | $ 43,519.20 | $ 43,313.91 | $ 12,529.25 | |||||||||
| Herman Franklin | $ 7,800.00 | ||||||||||||
| Herman Franklin | $ 7,000.00 | $ 29,650.00 | $ 24,050.00 | $ 7,000.00 | |||||||||
| Jilla Sheetal | $ 6,600.00 | $ 27,970.00 | $ 24,098.72 | $ 6,600.00 | |||||||||
| Katkam Satyapal | $ 5,400.00 | $ 22,680.00 | $ 19,440.00 | $ 5,400.00 | |||||||||
| Lemke Denise | $ 6,000.00 | $ 25,200.00 | $ 20,100.00 | ||||||||||
| Parimi Raydu | $ 4,200.00 | $ 17,890.00 | $ 16,210.00 | $ 4,200.00 | |||||||||
| Walton John | $ 7,200.00 | $ 32,867.07 | $ 5,387.35 | ||||||||||
| Desmarais Yuvetta | $ 755.49 | $ 265.90 | |||||||||||
| TOTAL | $ 72,755.49 | $ 303,653.28 | $ 220,381.33 | $ 45,809.25 | $ 642,599.35 |
