Reference no: EM132165078
Analysis and calculations
1. Complete the following variance report (calculations required).
|
Budgeted sales |
Actual sales |
Variance |
|
|
|
|
Product |
Qty |
$ |
Qty |
$ |
Qty |
$ |
% |
Product X |
100 |
20,000 |
120 |
26,000 |
|
|
|
Product Y |
150 |
18,000 |
160 |
19,200 |
|
|
|
Product Z |
200 |
40,000 |
190 |
36,100 |
|
|
|
Total |
450 |
78,000 |
470 |
81,300 |
|
|
|
2. Complete the missing figures in the following variance report (calculations required).
Materials
|
Budget
|
Actual
|
Variance
|
|
|
|
|
Material A
|
$30,000
|
$28,000
|
|
|
|
|
|
Material B
|
$55,000
|
$59,000
|
|
|
|
|
|
Material C
|
$48,000
|
$45,000
|
|
|
|
|
|
Total
|
|
|
|
3. Prepare a cash flow plan for the Sandoz Company from the following information for the month of February 20xx.
Item
|
$
|
|
|
Cash sales
|
600,000
|
|
|
Collection from Accounts Receivable
|
1,386,000
|
|
|
Purchases (January 20aa)
|
470,000
|
|
|
GST payable to ATO
|
130,000
|
|
|
Salaries and wages
|
502,000
|
|
|
Interest payments
|
213,000
|
|
|
Other operating expenses paid
|
108,000
|
|
|
Loans repaid during the period
|
780,000
|
|
|
Capital expenditure
|
65,000
|
|
|
Opening cash balance
|
132,000
|
Sandoz Company
Cash Flow Plan for the month February 20xx
Opening cash balance
|
|
Receipts
|
|
Cash sales
|
|
Collection from Accounts Receivable
|
|
Other
|
|
Total receipts
|
|
Payments
|
|
Payments to creditors (purchases)
|
|
GST payable to ATO
|
|
Salaries and wages
|
|
Interest payments
|
|
Payments for operating expenses
|
|
Loans repayments
|
|
Capital expenditure
|
|
Total payments
|
|
Closing cash balance
|
|
|
4. Prepare a selling expense budget for the month of February 20xx for CDA Pty Ltd. The sales for February are expected to be $120,000. The bases to be used for budget purposes are as follows.
- Annual fixed expenses are allocated equally to each month.
- Sales staff salaries for the month are equal to 4% of sales.
- Depreciation of sales vehicles amounts to $18,000 per year.
- Sales staff insurance is 2.5% of monthly sales staff salaries.
- The advertising budget is currently $19,200 per annum.
- Sales vehicle maintenance costs the organisation 2% of sales revenue per month.
- Freight out per month is calculated a 0.65% of revenue.
- Complete the table as requested (calculations required).
Item
|
$
|
|
|
Salaries
|
|
|
|
Depreciation
|
|
|
|
Staff insurance
|
|
|
|
Advertising
|
|
|
|
Vehicle maintenance
|
|
|
|
Freight
|
|
|
|
Total
|
|
|
|
5. A Company expects to spend $200,000 on general administration expenses in the month of January 20aa. In February, these will be 90% of the January expenses; in March, these will be 105% of January's expenses.
The selling and distribution expenses total is expected to be 5%, and financial expenses 1% of each month's sales.
Prepare the operating expense budget for the three months January to March. The selling price for each unit is $25.
Quantities to be sold each month are as follows.
January
|
12,000
|
February
|
10,800
|
March
|
12,600
|
Complete the table as requested (calculations required).
|
January
|
February
|
March
|
|
|
|
|
Sales
|
|
|
|
|
|
|
|
Expenses
|
|
|
|
|
|
|
|
General and administrative
|
|
|
|
|
|
|
|
Selling and distribution
|
|
|
|
|
|
|
|
Financial expenses
|
|
|
|
|
|
|
|
Total expenses
|
|
|
|
Attachment:- Manage budget forecasts.rar