The budget is basically
a measurement and setting of parameters that works according to the designed parameters
and the measurement. The budget provides a guideline to the organization operations,
and activities of the managers are provided through the variance reports. In the
present work, based on the provided scenarios the financial management approaches
are used to manage the resources effectively and efficiently through the main ingredients.
The main requirement
is the classification of the budget plans and negotiation with the changes provided
by the managers. The budget analysis provides risk identification, and contingency
plan is designed to minimize and prevent the risk. The previously provided budget
neglects some essential requirements, but still it is not achievable. The present
variance report identifies the gap and provides some way to overcome. The basic
accounting principles are used for the identification of the changes and negotiate
with the manager. The organizational requirement is financial management, policies,
procedures, and budget reports. For preparing the budget to meet a large scale,
techniques and principles are needed.
The Budgeted
gross profit is $(3100000-77500-200000-400000 = $ 242250). The expenses are constant
and remained the same at $ 1401500 while the tax and the net profit before the interest
was
. The analysis
defines that projected budget is defined accurately and the target of $ 1,000 000
can be achieved. The budget provides more than the target of the company. The cost
allocation is required to define the needs and the importance of the sales volume
according to the budgets. The equal cost is defined in the cost distribution. The
cost allocation process distributes the cost of production and the actual consumptions
for the production and the services. the expenses are used for the preparation of
production and allocable cost.
The variance analysis
provides information about the planned and actual activity. The variance
analysis indicates a decline in the sales of the business by 6.45% for the present
year. The sales volume changes defined decline in the direct cost of the sales by
5%. The commission on the sales was not determined properly, and the variance report
has shown decline of 6.45. The reduction in wages was 0%, and it can be said
that wages were planned accurately. The 10% reduction
in the travel was defended for the short-term contracts that have no significant
impact on the business. The decrease in the sales was 20% for the gross profit,
and decline rate was less as 17.95%. The decrease in the general, as well as
administrative expenses, is 50% that provides advantage to the business. The substantial
increase in the employee expense involved the time wastage and distracted the contracted
employees in the company. The predefined objectives of the incentive programs and
the training programs are not achieved, and less variation in the marketing cost
is observed, and fixed cost of advertisement expenses are determined (Yang, Northcott, & Sinclair, 2017). The cost of occupancy
increased but required less attention for the employees due to reduction in the
cost of the raw materials, water, paper, wastage, and electricity consumption. The
lack of participation of employees in the budget-making process results in dissatisfaction
with employee. The decrease in the net profit is 45%, and the projected profits
can be decreased by 10%. The managers are required to consider effective measures
to reduce the cost and to improve efficiency.
Details
|
Yearly
|
Q1
|
Q2
|
Q3
|
Q4
|
|
Budgeted
|
Actual
|
Variance
|
Variance
|
Budgeted
|
Actual
|
Variance
|
Budgeted
|
Actual
|
Variance
|
Budgeted
|
Actual
|
Variance
|
Budgeted
|
Actual
|
REVENUE
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
Commissions
|
77,500
|
72,500
|
-6.45%
|
-14.29%
|
17,500
|
15,000
|
-10.00%
|
25,000
|
22,500
|
-14.29%
|
17,500
|
15,000
|
-14.29%
|
17,500
|
15,000
|
Direct wages
fixed
|
200,000
|
200,000
|
0.00%
|
0.00%
|
50,000
|
50,000
|
0.00%
|
50,000
|
50,000
|
0.00%
|
50,000
|
50,000
|
0.00%
|
50,000
|
50,000
|
Sales
|
3,100,000
|
2,900,000
|
-6.45%
|
-14.29%
|
700,000
|
600,000
|
-10.00%
|
1,000,000
|
900,000
|
14.29%
|
700,000
|
800,000
|
-14.29%
|
700,000
|
600,000
|
Cost of Goods
Sold
|
400,000
|
380,000
|
-5.00%
|
-5.00%
|
100,000
|
95,000
|
-5.00%
|
100,000
|
95,000
|
-5.00%
|
100,000
|
95,000
|
-5.00%
|
100,000
|
95,000
|
Gross Profit
|
2,422,500
|
2,247,500
|
-7.22%
|
-5.16%
|
532,500
|
505,000
|
-2.42%
|
825,000
|
805,000
|
32.39%
|
532,500
|
705,000
|
-5.16%
|
532,500
|
505,000
|
EXPENSES
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
General &
Administrative Expenses
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
Travel
|
20,000
|
22,000
|
10.00%
|
-20.00%
|
5,000
|
4,000
|
20.00%
|
5,000
|
6,000
|
20.00%
|
5,000
|
6,000
|
20.00%
|
5,000
|
6,000
|
Legal Fees
|
5,000
|
4,500
|
-10.00%
|
-16.00%
|
1,250
|
1,050
|
-8.00%
|
1,250
|
1,150
|
-8.00%
|
1,250
|
1,150
|
-8.00%
|
1,250
|
1,150
|
Bank Charges
|
600
|
700
|
16.67%
|
33.33%
|
150
|
200
|
33.33%
|
150
|
200
|
0.00%
|
150
|
150
|
0.00%
|
150
|
150
|
Office
Supplies
|
5,000
|
4,000
|
-20.00%
|
-20.00%
|
1,250
|
1,000
|
-20.00%
|
1,250
|
1,000
|
-20.00%
|
1,250
|
1,000
|
-20.00%
|
1,250
|
1,000
|
Postage &
Printing
|
400
|
500
|
25.00%
|
25.00%
|
100
|
125
|
25.00%
|
100
|
125
|
25.00%
|
100
|
125
|
25.00%
|
100
|
125
|
Dues &
Subscriptions
|
500
|
600
|
20.00%
|
20.00%
|
125
|
150
|
20.00%
|
125
|
150
|
20.00%
|
125
|
150
|
20.00%
|
125
|
150
|
Telephone
|
10,000
|
11,200
|
12.00%
|
12.00%
|
2,500
|
2,800
|
12.00%
|
2,500
|
2,800
|
12.00%
|
2,500
|
2,800
|
12.00%
|
2,500
|
2,800
|
Repairs &
Maintenance
|
50,000
|
45,000
|
-10.00%
|
-20.00%
|
25,000
|
20,000
|
0.00%
|
25,000
|
25,000
|
|
|
|
|
|
|
Payroll Tax
|
25,000
|
25,000
|
0.00%
|
0.00%
|
6,250
|
6,250
|
0.00%
|
6,250
|
6,250
|
0.00%
|
6,250
|
6,250
|
0.00%
|
6,250
|
6,250
|
Marketing
Expenses
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
Advertising
|
200,000
|
208,000
|
4.00%
|
4.00%
|
50,000
|
52,000
|
12.00%
|
50,000
|
56,000
|
0.00%
|
50,000
|
50,000
|
0.00%
|
50,000
|
50,000
|
Employment
Expenses
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
Superannuation
|
45,000
|
45,000
|
0.00%
|
0.00%
|
11,250
|
11,250
|
0.00%
|
11,250
|
11,250
|
0.00%
|
11,250
|
11,250
|
0.00%
|
11,250
|
11,250
|
Wages &
Salaries
|
500,000
|
500,000
|
0.00%
|
0.00%
|
125,000
|
125,000
|
0.00%
|
125,000
|
125,000
|
0.00%
|
125,000
|
125,000
|
0.00%
|
125,000
|
125,000
|
Staff Amenities
|
20,000
|
23,000
|
15.00%
|
20.00%
|
5,000
|
6,000
|
0.00%
|
5,000
|
5,000
|
20.00%
|
5,000
|
6,000
|
20.00%
|
5,000
|
6,000
|
Occupancy
Costs
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
Electricity
|
40,000
|
38,000
|
-5.00%
|
-20.00%
|
10,000
|
8,000
|
0.00%
|
10,000
|
10,000
|
0.00%
|
10,000
|
10,000
|
0.00%
|
10,000
|
10,000
|
Insurance
|
100,000
|
100,000
|
0.00%
|
0.00%
|
25,000
|
25,000
|
0.00%
|
25,000
|
25,000
|
0.00%
|
25,000
|
25,000
|
0.00%
|
25,000
|
25,000
|
Rates
|
100,000
|
100,000
|
0.00%
|
0.00%
|
25,000
|
25,000
|
0.00%
|
25,000
|
25,000
|
0.00%
|
25,000
|
25,000
|
0.00%
|
25,000
|
25,000
|
Rent
|
200,000
|
200,000
|
0.00%
|
0.00%
|
50,000
|
50,000
|
0.00%
|
50,000
|
50,000
|
0.00%
|
50,000
|
50,000
|
0.00%
|
50,000
|
50,000
|
Water
|
30,000
|
35,000
|
16.67%
|
33.33%
|
7,500
|
10,000
|
33.33%
|
7,500
|
10,000
|
0.00%
|
7,500
|
7,500
|
0.00%
|
7,500
|
7,500
|
Waste Removal
|
50,000
|
60,000
|
20.00%
|
20.00%
|
12,500
|
15,000
|
20.00%
|
12,500
|
15,000
|
20.00%
|
12,500
|
15,000
|
20.00%
|
12,500
|
15,000
|
TOTAL EXPENSES
|
1,401,500
|
1,422,500
|
1.50%
|
-0.01%
|
362,875
|
362,825
|
3.32%
|
362,875
|
374,925
|
1.33%
|
337,875
|
342,375
|
1.33%
|
337,875
|
342,375
|
NET PROFIT
(BEFORE INTEREST & TAX)
|
1,021,000
|
825,000
|
-19.20%
|
-54.50%
|
169,625
|
77,175
|
-22.62%
|
462,125
|
357,575
|
52.92%
|
194,625
|
297,625
|
-49.84%
|
194,625
|
97,625
|
Income Tax
Expense (25%Net)
|
255,250
|
206,250
|
-19.20%
|
-54.50%
|
42,406
|
19,294
|
-22.62%
|
115,531
|
89,394
|
52.92%
|
48,656
|
74,406
|
-49.84%
|
48,656
|
24,406
|
NET PROFIT
AFTER TAX
|
765,750
|
618,750
|
-19.20%
|
-54.50%
|
127,219
|
57,881
|
-22.62%
|
346,594
|
268,181
|
52.92%
|
145,969
|
223,219
|
-49.84%
|
145,969
|
73,219
|
Referring to the spreadsheet, commission,
direct wages fixed, and sales are the revenue sources of the company. The actual
commissions are less than forecasted commissions, i.e., 72,500 and 77,500, respectively,
while actual direct wages fixed are the same as forecasted direct fixed wages, i.e.,
200,000. In employment expenses, the only variation is observed in staff amenities
where actual amount is higher than projected amount, i.e., 23000 and 20000 respectively
while actual and forecasted superannuation and wages & salaries are same, i.e.,
500, 000 and 500,000 respectively. Also, there is a minor difference in actual sales
and forecasted sales, i.e., 2,900,000 and 3,100,000 respectively. On the other hand,
the actual travel expenses are higher than forecasted travel expenses, i.e., 22,000
and 20,000 respectively, interestingly actual legal fee is 4,500 that is less than
forecasted amount, i.e., 5,000, and similarly actual repair and maintenance expenses
and office supplies expenses are 45,000 and 4,000 respectively that is less than
forecasted amount, i.e., 50,000 and 5,000 respectively. Contrary, actual advertising
expenses are much higher than forecasted expenses, i.e., 208,000 and 200,000 respectively.
Last but not least, there is high variation in actual net profit after tax and forecasted
net profit after tax, i.e., 618,750 and 765,750 respectively.
Modified contingency
plan
Revised Contingency Plan
|
Company name: Big
Red Bicycle Pty Ltd
Individual creating the strategy or plan
Name: Tom Copeland
Position: Managing director
|
Risk Identified
|
1. The profit estimated in the budget is 19% above the
actual profit.
2. Total expenses are estimated at 1.50% lower than
actual
3. The sales are an estimated 6.45% higher than
actual sales.
|
Strategies and activities for the minimization of the risk
|
By when
|
By whom
|
Analyzing the selling products and finishing the cycle of operation.
|
Accounting’s same
year
|
CEO, MD and the CFO of the company
|
Keeping
the data protected by password and allows it only to the reliable and authorized
hands. The featured databases should be n excel with macros and generate the reports
on these bases.
|
At the time while preparing the reports
|
Operation manager
|
Develop
a report of quarterly variance for the identification of the income expense and
the profit.
|
Q2
|
PR
|
Implementation
of sales training and coaching programs.
|
Q2
|
PR
|
Introduce
some programs of customer reward for the increase in sales.
|
Q2
|
PR
|
Consider
the participation of the employee in the decision-making and budgetary processes.
|
Q2
|
PR
|
Consider
the impact of wastage, water, paper, raw material, and electricity.
|
Q2
|
PR
|
|
|
|
|
Modified implementation
plan
Risk identified: The
profit of FY is higher and less than the budgeted programs
|
Activity
|
Monitored activities
|
By whom
|
Monitoring
of Variance
|
Complete the variance report Q2
|
PR
|
Analyse
the report for the identification of the issues
|
Management of the report Q2
|
PR
|
Send
the emails to the employees to warn them about the risks of the jobs
|
Monitoring of results of variance report Q4
|
PR
|
Send
a message or email to all employees to present the increase in commission to
14.29%
|
Monitoring of results of variance report Q3
|
PR
|
Send
emails to workers about the present unapproved overtime.
|
Monitoring of results of variance report Q3
|
PR
|
Send
emails to inform the employees about all the required and mandatory skills of
sales and training programs
|
Monitoring of results of variance report Q4
|
PR
|
Send
emails to the customers as well as employees regarding the modified consumer reward
programs.
|
Monitoring of results of variance report Q4
|
PR
|
Voluntary
training programs conducted in the company
|
Monitoring of results of variance report Q3
|
PR
|
Modification
of the procedures for the re-education in the occupancy costs
|
Monitoring of results of variance report Q3
|
PR
|
Procedure of Manage budgets and
financial plans
In order to update the plan and to
improve the training models, there are some important components that must be considered,
including goals, options and obstacles, reward programs, and the current reality.
Action and activity
|
Monitoring process
|
Timeline
|
Accountable
|
Management
of the working capital
|
Report
on working capital ratios
|
Must
be provided at the end of the quarters
|
Senior
accountant
|
Management
of the cash
|
Development
of the cash budget
|
On
a monthly basis
|
Senior
accountant
|
Reduction
in the variable costs
|
Variance
report and the variable expense budget
|
Must
provide at the end of all the quarters
|
Senior
accountant
|
References of Manage budgets
and financial plans
Yang, C., Northcott,
D., & Sinclair, R. (2017). The accountability information needs of key charity
funders. Public Money & Management , 37 (03), 173-180.
Kung, F. H., Huang, C. L., & Cheng, C. L. (2013). An examination
of the relationships among budget emphasis, budget planning models, and performance.
Management Decision , 51 (01), 120-140.
Macinati, M. S., & Rizzo, M. G. (2014). budget goal commitment,
clinical managers’ use of budget information, and performance. Health policy
, 117 (02), 228-238.