Comprehensive Finance Data Analysis Report - University

This finance report presents a comprehensive analysis of various financial aspects. It includes an examination of fiscal year volumes, showcasing percentage changes and data trends. The report delves into monthly sales volume, providing detailed figures across different months. It further analyzes financial data, including opening cash, additions, and balances over specific periods. The report also covers weekly and yearly revenue calculations, with breakdowns of selling prices and gross revenue. Additionally, it addresses supply budgets, comparing previous and budgeted years, along with patient service data. The report concludes with an analysis of salary budgets, including FTE requirements and payment schedules, providing a detailed overview of financial operations.

Running head: FINANCE
Finance
Name of the Student:
Name of the University:
Authors Note:

2FINANCE
Table of Contents
11.....................................................................................................................................................3
12.....................................................................................................................................................3
13.....................................................................................................................................................4
14.....................................................................................................................................................4
15.....................................................................................................................................................5
16.....................................................................................................................................................5
Bibliography....................................................................................................................................7

3FINANCE
11.
Fiscal year volume Percentage Change
1 4600
2 4800 4%
3 5000 4%
4 5200 4%
5 5400 4%
6 2800 -93%
7 2904
12.
Month
Jul
y
aug
ust
Septe
mber
Oct
obe
r
Nove
mber
Dece
mber
Jan
uar
y
Febr
uary
mar
ch
Apr
il may
Jun
e
Volum
e
100
0
100
0 1000
110
0 1100 1100
120
00 1200
120
0
130
0
130
0
130
0
Sales
100
000
100
000
10000
0
110
000
1100
00
1100
00
120
000
0
1200
00
120
000
130
000
130
000
130
000
Collect
ion 80000
800
00
8000
0
8800
0
880
00
8800
0
960
000
960
00
960
00
104
000
Openin
g Cash
500
00
100
00
-
30000
100
00
5000
0
9000
0
138
000
1860
00
234
000
115
400
0
121
000
0
126
600
0
Additio
n 80000
800
00
8000
0
8800
0
880
00
8800
0
960
000
960
00
960
00
104
000
Less:
Wage
400
00
400
00 40000
400
00
4000
0
4000
0
400
00
4000
0
400
00
400
00
400
00
400
00
Balanc
e
100
00
-
300
00 10000
500
00
9000
0
1380
00
186
000
2340
00
115
400
0
121
000
0
126
600
0
133
000
0
13.
Weekly Basis Yearly Basis

4FINANCE
Service 1 Service 2 service 1 Service 2
Volume 10000 20000 520000 1040000
Selling Price 200 100 200 100
Gross Revenue (Sales) 2000000 2000000 104000000 104000000
Collection 1500000 1500000 78000000 78000000
Net Revenue= 500000 500000 26000000 26000000
14.
Supply budget ( previous)
Particulars Amount Per unit
Office supplies (F) 1200000
Clinic Supplies(f) 1350000
Medical Supplies(v) 3500000 56
Pharmaceuticals(v) 5500000 88
Small Instruments (f) 444000
Books and Periodicals (f) 5000
Miscilleiones (F) 1000
Patient Served 62500
Supply budget ( Budgeted year)
Particulars Amount Per unit
Office supplies (F) 1200000
Clinic Supplies(f) 1350000
Medical Supplies(v) 9240000 56
Pharmaceuticals(v) 14520000 88
Small Instruments (f) 444000
Books and Periodicals (f) 5000
Miscilleiones (F) 1000
Total 26760000
Patient Served 165000

5FINANCE
15.
Payment Per Weak 40
Leave and other 15%
Effective Working Time 34
Time Requirement to Serve 0.5
Number Of Screanoning 2000000
FTE Requirement 29411.765
Time Requirement
public Health Work 20
Documentation 10
Hourly Rate 0.5
16.
Salary Budget
Production 108000
FTE yearly Production 8500
FTE Requirement 12.71
Salary Budget for Fiscal Year 30,20x8)
Employee FTE Valve oct x6 july x7 july x8 payment
anderson 0.5 34.5 34.85 35.19 149572.1625
baker 1 31.25 31.56 31.88 270964.0625
Carson 1 29.35 29.64 29.94 254489.4475
Davis 1 32.65 32.98 33.31 283103.2525
Evans 0.5 24.75 25.00 25.25 107301.7688
Filnton 0.5 36.2 36.56 36.93 156942.385
Gates 1 31 31.31 31.62 268796.35
Hayes 0.5 29 29.29 29.58 125727.325
New FTE 12.71 34 34.34 34.68 3745807.2
Total 5362703.954

6FINANCE

7FINANCE
Bibliography
Gitman, L.J., Juchau, R. and Flanagan, J., 2015. Principles of managerial finance. Pearson
Higher Education AU.
Scarborough, N.M., 2016. Essentials of entrepreneurship and small business management.
Pearson.