Prepare And Monitor Assignment

Prepare And Monitor
Budget

Table of Contents
INTRODUCTION...........................................................................................................................1
TASK...............................................................................................................................................1
5.1 Calculate the budgeted cost of sales for the year ending 30 June 2016:..........................1
5.2 Prepare a budgeted income statement for the year ending 30 June 2017.........................1
5.3 Reconstruct the Debtors control account to evaluate the estimated balance at 30 June
2016:.......................................................................................................................................2
5.4 Reconstruct the Debtors control account to evaluate the estimated balance at 30 June
2017:.......................................................................................................................................2
6. Direct Labour Budget:........................................................................................................2
7. Sales Budget:......................................................................................................................3
Part A:.....................................................................................................................................3
(a) Scope and Nature of required budgets:.............................................................................3
(b) Identify, access and interpret data and data sources required for budget preparation:.....4
(c) Internal and external factors for potential impact on budget:...........................................4
(d) General control ledgers:....................................................................................................6
(e) Budgeted cash flow statement for Cupcake Heaven for the month ending 31 August 2017:
................................................................................................................................................6
(f) Comment on the likely future cash position of this business:..........................................7
(g) Budgeted profit and loss for the month ending 31 August 2017:.....................................7
(h)Future performance expectations of Cupcake Heaven in related to the expected profit or
loss: ........................................................................................................................................7
Part B......................................................................................................................................8
(a) Prepare a cash budget for Cakes-2-U for the period January - June 2017:.......................8
(b)...........................................................................................................................................9
(c) Budget Explanation and Recommendation:......................................................................9
Part C....................................................................................................................................10
Part 1:....................................................................................................................................10
A. Budget variance report for the quarter ended 30 September 2017:.................................10
B. Predicted cash balance on 30 September:........................................................................10

C. Actual cash balance on 30 September:............................................................................10
PART 2.................................................................................................................................11
D. Major causes of the difference between the budgeted and actual bank balance:............11
C. Appropriateness of Quarterly period for cash budgeting:...............................................11
CONCLUSION..............................................................................................................................11
REFERENCES..............................................................................................................................13

INTRODUCTION
A budget is a financial plan which is prepared by every type of organisation to evaluate
of future activities. It is producing for particular period of time where consist of planned sales
volumes and revenues, resource quantities, costs and expenses, assets, liabilities and cash flows.
It is important to prepare and monitor budget activities in efficient manner. The report contains
practical knowledge of preparation of various budgets like cash budget, master budget etc. and
general ledger control accounts (Gupta and Yläoutinen, 2014). This report also evaluates to what
extent internal and external factors affects budgets and discussion on identification, access and
interpret data and its sources required for budget preparation.
TASK
5.1 Calculate the budgeted cost of sales for the year ending 30 June 2016:
As per the income statement of 2015, Sales in 2015 about 1100 units which is sale out at
$200 per unit inc GST. So budgeted cost of sales for the year ending 30 June 2016 -
1100 units * $200 = $220,000
5.2 Prepare a budgeted income statement for the year ending 30 June 2017
Particulars Details 2017 (Amount)
Sales (80% credit) 1265 units @ $525 664125
Cost of sales 1265 units @ $200 253000
Gross Profit 411125
Less: Indirect expenses
Bad Debts 20% of 531300* 106260
Depreciation@15% on
Equipment
18000
Wages (5% increase + $65000)** 164750
Office Expenses 30800
Total Expenses 319810
1

Net Profit 91315
* Credit sales is 80% of total sales i.e. 664125*80% = 531300
**Wages = ($95000*5% + $95000) + $65000 = 106260
Note:
 All sales are on credit.
 Bad debts 20% of credit sales.
5.3 Reconstruct the Debtors control account to evaluate the estimated balance at 30 June 2016:
Particulars Amount Particulars Amount
To Balance b/d 52000 By Bad debts 4000
To Credit sales 440000
By Closing c/d 488000
492000 492000
5.4 Reconstruct the Debtors control account to evaluate the estimated balance at 30 June 2017:
Debtor Control Account – It indicate the total amount which is owned by the all the
individuals debtors. It is a nominal account which is reconciled easily as accountant enter new
transaction. At the time of reconciliation of debtor control account accountant check that this
account's balance is matches with total due amount of accounts receivables.
Particulars Amount Particulars Amount
To Balance b/d 52000 By Bad debts 106260
To credit sales 531300 By collection 500,0000
To closing c/d 4522960
5106260 5106260
6. Direct Labour Budget:
A direct labour budget has been used to compute the labour of hours that will be required
to develop the units itemized in the manufacturing budget. It is complex to prepare and analysing
2

every activities to calculate not only the total number of hours needed but will also break down
this information by labour category (Berman, 2015).
BC Corps Direct Labour Budget
Direct Labour Budget
Q1 Q2 Q3 Q4 Year
Units to be
produced
5000 600 7000 8000 20600
Machine
Operator
12500 1500 17500 20000 51500
Other Labour 3750 450 5250 6000 15450
Total Direct
labour cost
16250 1950 22750 26000 66950
Working Note
Machine Operator:
Quarter 1 = 5000*0.1*25 = 12500
Quarter 2 = 600*0.1*25 = 1500
Quarter 3 = 7000*0.1*25 = 17500
Quarter 4 = 8000*0.1*25 = 20000
Other Labour:
Quarter 1 = 5000*0.05*15 = 3750
Quarter 2 = 600*0.05*15 = 450
Quarter 3 = 7000*0.05*15 = 5250
Quarter 4 = 8000*0.05*15 =6000
7. Sales Budget:
Sales Budget
Q1 Q2 Q3 Q4 Year
Units to be 2500 450 1750 2000 6700
3

sold out
Selling Price 10 10 12.25 12.25
Sales 25000 4500 21875 24500 75875
Less –
Discount (5%)
1250 225 1093.75 1225
Total Sales 23750 4275 20781.25 23275 72081.25
Part A:
(a) Scope and Nature of required budgets:
Budgets are determined by business entities which act as benchmark for company. Such
budgets are fixed by entities according to their past performances. Any favourable or adverse
variation in budgets exhibits company's operational efficiencies. Budgets for August month are
well determined. In cash and credit sales an improvement of approx 1.54% and 1.80% is
estimated but it is less than the estimated increment in cost of sales i.e. 2.22%. In amounts of
stock loss, wages and office expenses no change is predicted (Dener and Young, 2013). So it has
been assumed that loss of stock is normal. Maximum 40% increase in Stock control account can
lead to reduction in budgeted profit. Whereas predicted figures of Debtor and Creditor control
account is quit obvious.
From balance sheet Actual Predicted
31st, July 2017 31st, Aug 2017
(Predicted –
Actual)/ Actual
*100
Balance of stock control 2600 3640 40.00%
Balance of debtors control 2400 2800 16.66%
Balance of creditors control 8600 9600 11.63%
From the profit and loss statement Actual Predicted
31st , July 2017 31st , Aug 2017
Cash sales 6500 6600 1.54%
Credit sales 2750 2800 1.82%
Cost of sales 4500 4600 2.22%
4

Stock loss 800 800 -
Wages 1600 1600 -
Office expenses 200 200 -
Discount expense 110 120 9.09%
Discount revenue 150 160 6.67%
Bad debts 100 100 -
(b) Identify, access and interpret data and data sources required for budget preparation:
Generally budgets are prepared on the basis of company's objectives, historical data and
managerial personnel's experiences. In budget preparation process, at first step relevant data are
identified and classified to assess the performance result. Thereafter managers and other officials
set budgeted figures by collecting such data, historical data and applying experiences (Chen,
Weikart and Williams, 2014). Normally discussed process of identify, access and interpreting
data is part of finalisation of accounts. Only budgeted figures are determined on the basis of
analysis of past results and data sources like financial statement, income statement etc.
(c) Internal and external factors for potential impact on budget:
Budgets and other documents are are highly affected by several internal and external
factors. Such factors also determines company's efficiencies to attain targeted figures. Following
is discussion on analysis of internal and external factors for possible effect on budget and
document in a report, as follows:
Internal Factors: These factors are integral part of an organisation and have direct impact on
company's budgets. Analysis of these variables are important, as this can lead to increase in
reliability and accuracy of budgeted figures. Following are the major internal factors which can
influence company's budget, as follows:
 Revenues: Budget forecasts will be affected if the real income obtained is not as
much as initially expected. External variables that adversely affect presumed income
can include an downturn in the economy, unanticipated competitiveness that causes
lower revenues or an failure to maintain the necessary growth rate (Lynch and
Tollestrup, 2012). Internal factors like insufficient collections and weak receivable
accounts can also affect revenue. Hostile forecasts that believe a high level of
5

development or enhanced income have a much higher inaccuracy capability than
optimistic estimates on the basis of previous years ' information.
 Expenditure: Expenditure is most challenging variable in predicting budget.
Expenses are not reliably predictable because these may be increased or decreased by
change in circumstances. Any unanticipated fiscal event can change the variances in
actual and budgeted figures. For instance salary expenses can be predicted easily on
the basis of current pays but if any change in employee turnover will arise in future
than such prediction is not so much relevant for company.
External Factors: These are most considerable variables in budget preparation. Analysing
external factors is time consuming task and also require professional expertise. Managers always
tries to predetermine the effect of external factors as it is necessary for increasing the
creditability of budgets. Following are major external factors, as discusses below:
 Market Conditions: There are several ways wherein the industry, market and present
business circumstances can affect monetary and fiscal forecasts. A shifts in rate of
inflation and events of stock market directly influence current worth of company and its
capacity to develop new resources. In case company is dependent on investments then in
case of adverse stock market condition this would lead to negative impacts on estimation
made in budgets (Kelly and Rivenbark, 2014).
 Legislative Changes: Several legislature changes or happenings directly influence
budget's projections. Mostly business entities tracks pending legislation and
predetermines the effect accordingly. Introduction of any new or future legislation can
lead to change in current projections. Although a legislation doest not affect immediately
and future impact of legislation can be easily assessed by business entity.
(d) General control ledgers:
Debtor Control Account
Dr. Cr.
Particular $ Particular $
To Balance B/d 2400 By Bank 2920
To Sales including GST 3080 By Discount 120
6

By Balance C/d 2800
Total 5480 Total 5840
Creditors Control Account
Dr. Cr.
Particular $ Particular $
To Bank 3900 By Balance B/d 8600
To Discount 160 By Purchase including GST 5060
To Balance C/d 9600
Total 13660 Total 13660
Stock Control Account
Dr. Cr.
Particular $ Particular $
To Balance B/d 2600 By Stock Loss 800
To Purchases 11240 By Sales 9400
By Balance C/d 3640
Total 13840 Total 13840
(e) Budgeted cash flow statement for Cupcake Heaven for the month ending 31 August 2017:
Statement of Cash Flows
31/08/17
Cash flows from operating activities
Cash Sales 6,600.00
Cash collected from Debtors 2,920.00
Cash paid to suppliers (3,900.00)
Cash paid to employees (1,600.00)
Office Expenses (200.00)
Discount Expenses (120.00)
Discount Income 160.00
Cash generated from operations 3,860.00
7

Opening Cash Balance 3,210.00
Closing Cash Balance 7,070.00
(f) Comment on the likely future cash position of this business:
As per budgeted cash flow prepared in Point (e) it has been analysed that company has
expected a positive cash flow. Opening cash flow for August month is $3210.00 and closing
budgeted cash flow after considering all budgeted incomes and expenses, at the end of month is
$7070.00. Figures of cash collected from Debtors and Cash paid to suppliers are obtained from
budgeted ledgers.
(g) Budgeted profit and loss for the month ending 31 August 2017:
Budgeted Profit and Loss for the month ending 31 August 2017
Dr. Cr.
Particular $ Particular $
To Opening Stock 2600 By Sales:
To Cost of Sales 4600 Cash 6600
Credit 2800
To Gross Profit 5840 By Closing Stock 3640
Total 13040 Total 13040
To Stock Loss 800 By Gross Profit 5840
To Wages 1600 By Discount Revenue 160
To Office Expenses 200
To Discount Expenses 120
To Bad Debts 100
To Net Profit 3180
Total 6000 Total 6000
(h)Future performance expectations of Cupcake Heaven in related to the expected profit or loss:
According to the budgeted profit and loss account it has been analysed that company is
expecting gross and net profit in August month. Company's expected gross profit is $5840 and
8

expected net profit is $3180. It indicates that company is expecting overall growth in profitability
position of company. Company has reported no change in bad-debt's amount.
9

Part B
(a) Prepare a cash budget for Cakes-2-U for the period January - June 2017:
Jan-2017
Feb-
2017
Mar-
2017
Apr-
2017 May-2017
Jun-
2017
Revenue 13100 15400 16500 13300 11400 9500
Less: Cost of material 3275 3850 4125 3325 2850 2375
Less: Payments:
 Salary of Assistant:
 Full Time Employed 200 200 200 200 200 200
 Casual Basis 2000 2000 2000 1600 1600 1600
 Petrol Expenses 240 240 240 200 200 200
 Vehicle Service
Expenses 320
 Insurance 640
 Vehicle Registration 540
 Advertisement
Expenses 150 150 150 150 150 150
 Equipment Loan's
Deposit 1000
 Instalment 400 400 400 400
 Office Expenses 100 100 100 100 100 100
 Loan Repayments 1500 1500
Less: Drawings 500 500 500 500 500 500
Cash Available 6635 5540 8145 6825 3900 3435
Working Notes:
10

1. Calculation of Expected Revenue:
Jan-2016 Feb-2016 Mar-2016
Apr-
2016 May-2016 Jun-2016
Revenue 12000 14000 15000 14000 12000 10000
Jan-2017 Feb-2017 Mar-2017 Apr-2017 May-2017 Jun-2017
Expected
Revenue Piketon's 1900
14000+1400
0*10/100
15000+1450
00*10/100
14000-
14000*5/10
0
12000-
12000*5/1
00
10000-
10000*5/10
0
Fox 1750
Tan 1800
Singh 1950
Strong 1850
Albert 1950
O'Conne 1900
Total 13100 15400 16500 13300 11400 9500
2. Calculation of Cost of Material:
Cost of material (25% of
Revenue)
13100*2
5/100
15400*2
5/100
16500*2
5/100
13300*2
5/100
11400*2
5/100
9500*25/
100
(b)
Jan-2017 Feb-2017 Mar-2017 Apr-2017 May-2017 Jun-2017
Cash Available 6635 5540 8145 6825 3900 3435
Accumulated Cash
Balance 6635
6635 +
5540 =
12175
12175 +
8145 =
20320
20320 +
6825 =
27145
27145 +
3900 =
31045
31045 +
3435 =
34480
From above table it has been analysed that Allan will be able to afford the 10,000 deposit
for the new vehicle in February 2017.
11

(c) Budget Explanation and Recommendation:
Presented Budget in Point (a) on the basis of provided information shows that there is
decline in figures of cash budgeted. In Feb 2017 and May 2017 cash flows at month end are
reduced due to loan repayment. In Feb 2017 a deposit in respect of equipment loan also a reason
for low cash flow. It is recommended that a provision should be made in order to defer such
capital expenses. Also company should improve their revenue in April to June to make
uniformity in entire budget (Galindo and Batta, 2013).
12

Part C
Part 1:
A. Budget variance report for the quarter ended 30 September 2017:
Budgeted ($) Actual ($) Variance
Receipts
Cash fees 24000 32000 -8000
Collections form debtors 12000 14500 -2500
Loan form ABC finance company 5000 5000
GST collected 2400 3200 -800
0
Payments 0
Wages 6000 6500 -500
Insurance 800 840 -40
Suppliers 14000 16400 -2400
Postage and telephone [phone]
Purchase of new equipment 5000 4600 400
Cleaning of shop 1200 1200 0
Drawing 4500 3800 700
GST paid 2140 2342 -202
Net Cash Flow 9360 13638 -4278
B. Predicted cash balance on 30 September:
Budgeted Cash/Bank Account
Dr. Cr.
Particular $ Particular $
Balance B/d 500.00 Wages 6000.00
Cash fees 24000.00 Insurance 800.00
Collections form debtors 12000.00 Suppliers 14000.00
Loan form ABC finance company 5000.00 Postage and telephone 400.00
GST collected 2400.00 Purchase of new equipment 5000.00
13

Cleaning of shop 1200.00
Drawing 4500.00
GST paid 2140.00
Balance C/d 9860.00
Total 43900.00 Total 43900.00
So predicted cash balance as on 30th September is $9860 after making adjustment of all
cash receipts and payments.
C. Actual cash balance on 30 September:
Cash/Bank Account
Dr. Cr.
Particular $ Particular $
Balance B/d 500.00 Wages 6500.00
Cash fees 32000.00 Insurance 840.00
Collections form debtors 14500.00 Suppliers 16400.00
GST collected 3200.00 Postage and telephone 380.00
Purchase of new equipment 4600.00
Cleaning of shop 1200.00
Drawing 3800.00
GST paid 2342.00
Balance C/d 14138.00
Total 50200.00 Total 50200.00
Thus as per above cash account actual amount of cash balance as on 30th September is
$14138 after considering all actual cash receipts and payments.
D. Major causes of the difference between the budgeted and actual bank balance:
According to budgeted and actual bank account it has been analysed that budgeted cash
balance is below the actual figure. Budgeted cash balance is $9860 whereas actual cash balance
$14138.00. One of the main reason of difference is estimated loan amount to be received from
ABC finance company. Moreover variation in budgeted and actual figures is due to cash fees,
collection from debtors and payment to suppliers. Variance in such figures are 8000, 2500 and
14

2400 respectively. Overall variations are favourable for company, as it performed well as
comparison of budgeted figures.
C. Appropriateness of Quarterly period for cash budgeting:
In large organisation cash budgeting on monthly basis more time consuming but relevant
task. Whereas in small organisation monthly cash budging has not so much relevance. Quarterly
period for cash budgeting is more appropriate as it help to determine the status of trade
receivable and provides more clear view about company's cash management and performance.
Some time monthly cash budgeting may provide ambiguous results (Caamaño-Alegre and et.al.,
2013). As budgeting is generally considered as a long term process so quarterly period for cash
budgeting is more reliable and effective.
15