Business Planning: Budgeted Statement Profit & Loss, Budgeted and Actual Balance Sheet

Business planning

Table of Contents
Report summary...............................................................................................................................3
Budgeted statement Profit & loss....................................................................................................3
Budgeted and actual balance sheet..................................................................................................9

Report summary
The report summaries the budgeted and actual income statement for a respective year for a
newly developed business that help the manager to make certain valuables steps to increase the
performance of business. This income statement includes the monthly sales and revenue for a
business which aids manages to define the areas that that increase revenue and make measures of
those activity that increase expenses in a year. In the second part of the project budgeted and
actual balance sheet of company is demonstrated with some important ratios calculation that
shows the overall financial status of newly developed business in a year.
Budgeted statement Profit & loss
Budgeted statement of
profit and loss
Ja
n-
u-
ar
y
Fe
b-
ru-
ary
M
ar
ch
A
pr
il
M
ay
Ju
ne
Ju
ly
A
u-
gu
st
Sep
tem
ber
Oc
to-
ber
No-
ve
m-
ber
De-
ce
m-
ber
Tot
al
Sales
50
00
0
55
00
0
60
50
0
66
55
0
73
20
5
80
52
6
8
8
5
7
8
97
43
6
107
179
11
78
97
129
687
142
656
10
69
21
4
Less: Direct Materials
(variable)
10
00
0
10
50
0
11
02
5
11
57
6
12
15
5
12
76
3
1
3
4
0
1
14
07
1
147
75
15
51
3
162
89
171
03
15
91
71
Less: Direct Labour
(variable)
40
00
41
20
42
44
43
71
45
02
46
37
4
7
7
6
49
19
506
7
52
19
537
6
553
7
56
76
8
Less: Variable Over-
heads (variable or semi-
variable)
30
00
31
80
33
71
35
73
37
87
40
15
4
2
5
6
45
11
478
2
50
68
537
3
569
5
50
61
0
Less: Fixed Overheads
(fixed, stepped fix, or
semi-variable)
25
00
25
00
25
00
25
00
25
00
25
00
2
5
0
0
25
00
250
0
25
00
250
0
250
0
30
00
0
Gross profit 30
50
0
34
70
0
39
36
1
44
53
0
50
26
0
56
61
1
6
3
6
71
43
4
800
56
89
59
7
100
150
111
821
77
26
65

4
5
Less- Administration
Costs
50
00
55
50
61
60
.5
68
38
75
90
84
25
9
3
5
2
10
38
1
115
23
12
79
0
141
97
157
59
11
35
66
Less: Distribution
Costs
26
00
27
04
28
12
29
25
30
42
31
63
3
2
9
0
34
21
355
8
37
01
384
9
400
3
39
06
7
Less: Selling Costs
10
00
11
00
12
10
13
31
14
64
16
11
1
7
7
2
19
49
214
4
23
58
259
4
285
3
21
38
4
Operating Profit
21
90
0
25
34
6
29
17
8
33
43
6
38
16
4
43
41
2
4
9
2
3
2
55
68
4
628
32
70
74
8
795
10
892
06
59
86
48
Less: Finance Costs
40
00
40
40
40
80
41
21
41
62
42
04
4
2
4
6
42
89
433
1
43
75
441
8
446
3
50
73
0
Profit Before Tax
17
90
0
21
30
6
25
09
8
29
31
5
34
00
2
39
20
8
4
4
9
8
6
51
39
5
585
00
66
37
3
750
92
847
43
54
79
18
Less: Tax (10%)
17
90
21
31
25
10
29
31
34
00
39
21
4
4
9
9
51
39
585
0
66
37
750
9
847
4
54
79
2
Profit After Tax
16
11
0
19
17
5
22
58
8
26
38
3
30
60
2
35
28
7
4
0
4
8
7
46
25
5
526
50
59
73
6
675
83
762
69
49
31
26
Actual statement of
profit and loss
Ja
n-
u-
ar
y
Fe
b-
ru-
ary
M
arc
h
A
pr
il
M
ay
Ju
ne
Ju
ly
A
u-
gu
st
Sep
tem
ber
Oc
to-
be
r
No-
ve
m-
ber
De-
ce
m-
ber
To
tal