pls see attachment

1 answer below »

View more »
Answered 3 days AfterApr 09, 2023

Answer To: pls see attachment

Sandeep answered on Apr 12 2023
38 Votes
Sheet1
    Ans 1    Nonpersonal Expense
        Expense Type    FY2014    Inflation in cost ($)    Decrease    Others ($)    Tota
l ($)
        General Supplies    $69,532    $70,923            $70,923
        Utilities    $152,227        $144,616        $144,616
        Leased Space    $720,000    $741,600            $741,600
        Fuel    $50,571    $51,582            $51,582
        Inspection Supplies    $327,595    -        $81,899    $378,582
        Inspection Start-ups    $125,000    -        $0    $125,000
            $1,444,925                $1,512,303
        All departments are expected to achieve a 1% improvement in efficiency on all lines of cost and in all programs.
        -1% Total Nonpersonal expense by $ 1444,925- ($ 1444,925 * 1%) = $ 1430,476
    Ans 2     Personal Expense
        Expense Type    FY2014    Budget Increase        Budget Expense
        Salaries    $1,500,257    $45,008        $1,545,265
        Fixed Benefits     $534,240    $625        $534,865
        Variable Benefits    $262,545    $3,282        $265,827
        Total Nonpersonal     $2,297,042    $48,915        $2,345,957
        FTE    $50            $50
        Note 1 : Salaries
        Base =    $1,500,257    A
        Cost of Living Increase (3%) =     $45,007.71    B
        Total Budget Salaries ($) =     $1,545,265    ( A + B)
        Note 2 :...
SOLUTION.PDF

Answer To This Question Is Available To Download

Submit New Assignment

Copy and Paste Your Assignment Here
April
January
February
March
April
May
June
July
August
September
October
November
December
2025
2025
2026
2027
SunMonTueWedThuFriSat
30
31
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
1
2
3
00:00
00:30
01:00
01:30
02:00
02:30
03:00
03:30
04:00
04:30
05:00
05:30
06:00
06:30
07:00
07:30
08:00
08:30
09:00
09:30
10:00
10:30
11:00
11:30
12:00
12:30
13:00
13:30
14:00
14:30
15:00
15:30
16:00
16:30
17:00
17:30
18:00
18:30
19:00
19:30
20:00
20:30
21:00
21:30
22:00
22:30
23:00
23:30