University Business Planning Report: Financial Analysis and Budgeting

This report presents a comprehensive business planning document, including a detailed preparation of a Budgeted Profit & Loss Account, Balance Sheet, and Ratio Analysis. The analysis covers various financial aspects, such as sales, direct materials, direct labor, variable overheads, fixed overheads, administrative costs, distribution costs, selling costs, and finance costs. The report compares budgeted and actual financial statements to identify variances and assess performance. It also includes a comparison of budgeted and actual sales, direct material costs, direct labor costs, variable overhead costs, and fixed overhead costs. The report further provides a comparison of budgeted and actual operating costs and profit, along with a budgeted balance sheet. This report helps in effective financial assessment, setting financial goals, and improving the company's financial situation.

Business Planning

Report Summary
In this report, there has been a detailed preparation of a Budgeted Profit & Loss Account,
Balance Sheet and Ratio Analysis. Thus in this way the overall financial situation of the
company can be identified in a highly effective manner. Therefore this will be quite helpful in
ensuring that the financial situation of the company can be assessed in the right manner which
will be quite helpful in making sure that the financial goals and objectives can be attained
without facing problems and issues. This will be helpful in the assessment of the future steps
which can be taken to improve the financial situation.
Budg
eted
state
ment
of
profi
t and
loss...
.
Janua
ry
Febr
uary
Marc
h
April May June July Augu
st
Septe
mber
Octo
ber
Nove
mber
Dece
mber
Total
Sales 5000
00
5500
00
6050
00
6655
00
7320
50
8052
55
8857
81
9743
59
1071
794
1178
974
1296
871
1426
558
1069
2142
Less:
Direc
t
Mate
rials
(vari
able)
1000
00
1050
00
1102
50
1157
63
1215
51
1276
28
1340
10
1407
10
1477
46
1551
33
1628
89
1710
34
1591
713
Less: 4000 4120 4243 4370 4502 4637 4776 4919 5067 5219 5375 5536 5676
1

Budg
eted
state
ment
of
profi
t and
loss...
.
Direc
t...
Labo
ur
(vari
able)
0 0 6 9 0 1 2 5 1 1 7 9 81
Less:
Varia
ble
Over
heads
(vari
able
or
semi-
varia
ble)...
3000
0
3180
0
3370
8
3573
0
3787
4
4014
7
4255
6
4510
9
4781
5
5068
4
5372
5
5694
9
5060
98
Less:
Fixed
Over
heads
2500
0
2500 2500 2500 2500 2500 2500 2500 2500 2500 2500 2500 5250
0
2

Budg
eted
state
ment
of
profi
t and
loss...
.
(fixe
d,
stepp
ed
fix,
or
semi-
varia
ble)
Gros
s
profit
3050
00
3695
00
4161
06
4677
98
5251
05
5886
09
6589
53
7368
45
8230
63
9184
66
1024
000
1140
706
7974
150
Less-
Admi
nistra
tion
Costs
...
5000
0
5550
0
6160
5
6838
2
7590
4
8425
3
9352
1
1038
08
1152
27
1279
02
1419
71
1575
88
1135
659
Less:
Distri
butio
2600
0
2704
0
2812
2
2924
6
3041
6
3163
3
3289
8
3421
4
3558
3
3700
6
3848
6
4002
6
3906
71
3

Budg
eted
state
ment
of
profi
t and
loss...
.
n
Costs
....
Less:
Selli
ng
Costs
....
1000
0
1100
0
1210
0
1331
0
1464
1
1610
5
1771
6
1948
7
2143
6
2357
9
2593
7
2853
1
2138
43
Oper
ating
Profit
...
2190
00
2759
60
3142
79
3568
60
4041
44
4566
18
5148
19
5793
35
6508
17
7299
78
8176
05
9145
61
6233
977
Less:
Finan
ce
Costs
...
4000
0
4040
0
4080
4
4121
2
4162
4
4204
0
4246
1
4288
5
4331
4
4374
7
4418
5
4462
7
5073
00
Profit
Befor
e
1790
00
2355
60
2734
75
3156
48
3625
20
4145
78
4723
58
5364
50
6075
03
6862
31
7734
20
8699
35
5726
677
4

Budg
eted
state
ment
of
profi
t and
loss...
.
Tax...
Less:
Tax
(10%
)
1790
0
2355
6
2734
8
3156
5
3625
2
4145
8
4723
6
5364
5
6075
0
6862
3
7734
2
8699
3
5726
68
Profit
...
After
Tax...
1611
00
2120
04
2461
28
2840
83
3262
68
3731
20
4251
22
4828
05
5467
52
6176
08
6960
78
7829
41
5154
009
5

Actu
al
state
ment
of
profi
t and
loss...
....
Janua
ry
Febr
uary
Marc
h
April May June July Augu
st
Septe
mber
Octo
ber
Nove
mber
Dece
mber
Total
Sales 6500
00
7150
00
7865
00
8651
50
9516
65
1046
832
1151
515
1266
666
1393
333
1532
666
1685
933
1854
526
1389
9784
Less:
Direc
t
Mate
rials
(vari
able).
..
1200
00
1260
00
1323
00
1389
15
1458
61
1531
54
1608
11
1688
52
1772
95
1861
59
1954
67
2052
41
1910
055
Less:
Direc
t
Labo
ur
(vari
able).
..
4200
0
4326
0
4455
8
4589
5
4727
1
4869
0
5015
0
5165
5
5320
4
5480
0
5644
4
5813
8
5960
65
Less: 3500 3710 3932 4168 4418 4683 4964 5262 5578 5913 6268 6644 5904
6

Actu
al
state
ment
of
profi
t and
loss...
....
Varia
ble
Over
heads
(vari
able
or
semi-
varia
ble)...
.
0 0 6 6 7 8 8 7 5 2 0 0 48
Less:
Fixed
Over
heads
(fixe
d,
stepp
ed
fix,
or
3000
0
3000 3000 3000 3000 3000 3000 3000 3000 3000 3000 3000 6300
0
7

Actu
al
state
ment
of
profi
t and
loss...
....
semi-
varia
ble)
Gros
s
profit
4230
00
5056
40
5673
16
6356
55
7113
46
7951
50
8879
05
9905
32
1104
049
1229
574
1368
341
1521
707
1074
0216
Less-
Admi
nistra
tion
Costs
6500
0
7215
0
8008
6.5
8889
6
9867
5
1095
29
1215
77
1349
50
1497
95
1662
72
1845
62
2048
64
1476
357
Less:
Distri
butio
n
Costs
....
3000
0
3120
0
3244
8
3374
6
3509
6
3650
0
3796
0
3947
8
4105
7
4269
9
4440
7
4618
4
4507
74
Less:
Selli
ng
Costs
1500
0
1430
0
1573
0
1730
3
1903
3
2093
7
2303
0
2533
3
2786
7
3065
3
3371
9
3709
1
2799
96
8

Actu
al
state
ment
of
profi
t and
loss...
....
...
Oper
ating
Profit
3130
00
3879
90
4390
52
4957
10
5585
43
6281
85
7053
38
7907
71
8853
30
9899
49
1105
653
1233
569
8533
089
Less:
Finan
ce
Costs
....
4600
0
4646
0
4692
5
4739
4
4786
8
4834
6
4883
0
4931
8
4981
1
5031
0
5081
3
5132
1
5833
95
Profit
Befor
e Tax
2670
00
3415
30
3921
27
4483
16
5106
75
5798
39
6565
08
7414
52
8355
19
9396
40
1054
840
1182
248
7949
694
Less:
Tax
(10%
)....
2670
0
3415
3
3921
3
4483
2
5106
7
5798
4
6565
1
7414
5
8355
2
9396
4
1054
84
1182
25
7949
69
Profit
After
Tax...
2403
00
3073
77
3529
14
4034
85
4596
07
5218
55
5908
57
6673
07
7519
67
8456
76
9493
56
1064
023
7154
725
9

Direct Materials (variable) 191006
Direct Labour (variable).... 59607
Variable Overheads (variable or semi-variable) 59045
Fixed Overheads (fixed, stepped fix, or semi-
variable).....
36000
Administration Costs... 147636
Distribution Costs.. 45077
Finance Costs... 58340
191006
59607
5904536000
147636
45077
58340 D irec t Ma teria ls (v a ria ble) D irec t La bour (v a ria ble)
Va ria ble Ov erhea ds
(v a ria ble or s em i-v a ri-
a ble)
Fix ed Ov erhea ds (fi x ed,
s tepped fi x , or s em i-
v a ria ble)
Adm inis tra ti on C os ts D is tributi on C os ts
Fina nce C os ts
10