Assessment 3 PART A
docx
keyboard_arrow_up
School
Royal Melbourne Institute of Technology *
*We aren’t endorsed by this school
Course
SITHCCC012
Subject
Accounting
Date
Nov 24, 2024
Type
docx
Pages
3
Uploaded by SargentGoose3054
1.
Overview of issues
•
Identify and prioritise at least two significant issues in the
financial statements for Q1 and the remainder of the forecast
budget for 2021.
a)
The company was not able to market itself effectively to boost the membership revenue.
b)
The profit is way lower than expected because employees were not able to accept the change
and deliver their best.
2.
Budget variances
•
Calculate variance, and in the table format below, identify the
income line items with the most significant variances (+
or -)
Income line items
Forecast
Actual
Variance
Full membership – 12 months
900,000.00
180,000.00
-80
Full membership – 6 months
80,000.00
16,000.00
-80
Full membership – 3 months
30,000.00
6,000.00
-80
Month to month – 3 classes per week
115,000.00
23,000.00
-80
Month to month – all classes
80,000.00
16,000.00
-80
10 class pass
5,000.00
1,000.00
-80
Weekly drop in/ visitor
1,800.00
0.00
-100
Daily drop in/ visitor
4,000.00
0.00
-100
Personal training
4,500.00
0.00
-100
Retail Sales
25,000.00
7,000.00
-80
$50 Virtual month to month membership
14,100.00
16,800.00
19.15%
Equipment rental income
2,000.00
3,200.00
60
Total Income
1,255,300.00
249,000.00
--80.16%
•
Calculate variance, and in the table format below, identify
the expense line items with the most significant variances (+ or -)
Expense line items
Forecast
Actual
Variance %
Payroll
7,500.00
4,500.00
-40
Rent
56,360.31
47,906.27
-15
Utilities
2,164.24
1,298.54
-40
Consumables
541.06
324.64
-40
Gym management software
862.99
862.99
0
Accounting software
535.65
535.65
0
Training fees
676.32
0.00
-100
Merchandising
180.35
0.00
-100
Stock
901.77
541.06
-40
Depreciation of equipment
1,183.57
1,183.57
0
Maintenance
338.16
236.71
-30
Insurance
0.00
0.00
0
Banking
62.00
62.00
0
Video conferencing software
839.70
839.70
0
Total Operating Expenses
71,306.42
58,291.12
-18.25263008
•
Discuss the impact of the variances on the company’s financial
position
The variances have huge negative impact on the financial position; the variances of expenses are
negative which the good sign is. However, the variances of income are very high in poor performance. If
the company keeps working in the way, it would soon be seized.
•
identify four areas of the budget that need to be
reviewed
with highest priority, and suggest how they should
be modified for the next three quarters
The four areas are:
•
Increase in marketing budget: it is necessary to improve the business exposure.
•
Increase in IT expenditure is necessary to make the online process smooth.
•
Reduction in gym membership fee further is necessary.
•
Targeting engineering and other companies more to improve the target audience rate.
3.
Financial management processes
•
analyse the effectiveness of existing financial management
processes that
were used to prepare
the
budget forecast for
2021 – i.e. what were two key inefficiencies in the financial
management policy and process that you used?
The current system is efficient as it works in incremental budgeting. An incremental budget is
prepared by using previous budget and performance to check incremental amounts for new budget
period. The resource allocation depends on the allocation from previous periods. This approach does
not consider the changing circumstances; besides, it encourages spending up to the budget which
leads to “spend it or lose” mentality. Overall, the budget is stable and less time consuming;
managers can perform in their departments on consistent basis. There is a strong coordination
between budgets. The record allowed us to analyze the expenditures and income and make the
forecasting process easy. The spreadsheet analysis allowed us to make contingency plans clear.
However, the inefficiency is that the performance is tracked based on previous results.
•
make recommendations for four improvements
to the financial management policy and process
in order to ensure:
o
For accurate budgeting, the focus must be made on industry
forecasting reports where it is clearly mentioned how the next year
would be for a specific country.
o
The company needs to analyze the latest trends to meet customers’
demands which would assist in maximizing the profit.
o
The cost can be controlled by maintaining proper records of expenses to
check where the company spends lavishly.
o
In order to manage account receivables, the company needs to
motivate customers by giving them discounts on early payment.
Your preview ends here
Eager to read complete document? Join bartleby learn and gain access to the full version
- Access to all documents
- Unlimited textbook solutions
- 24/7 expert homework help
Related Documents
Related Questions
Correct answer please
Do not give solution in image format
arrow_forward
PRINCIPLE OF HEALTHCARE FINANCE
arrow_forward
please dont provide answer in an image format thnku
arrow_forward
Analyze the variances from the flexible budget and identify issues that management should be concern about. You only need to highlight bariances that are a concern
arrow_forward
Note:-
Do not provide handwritten solution. Maintain accuracy and quality in your answer. Take care of plagiarism.
Answer completely.
You will get up vote for sure.
arrow_forward
How do I calculate the flexible budget sheet?
arrow_forward
Please Do not Give Image Format
arrow_forward
9)
Ehrlich Corporation compares monthly actual operating results to a static budget prepared at the beginning of the month. When the actual level of activity is less than budgeted, which of the following would be true?
Group of answer choices
a. Variable costs would show unfavorable variances.
b. Variable costs would show favorable variances.
c. Fixed costs would show favorable variances.
d. Fixed costs would show unfavorable variances.
arrow_forward
Do not give image format
arrow_forward
Lavage Rapide is a Canadian company that owns and operates a large automatic car wash facility near Montreal. The following table
provides estimates concerning the company's costs:
Cleaning supplies
Electricity
Maintenance
Wages and salaries
Depreciation
Rent
For
Actual cars washed
Revenue
Expenses:
Administrative expenses
$ 0.03
For example, electricity costs should be $1,200 per month plus $0.09 per car washed. The company expects to wash 8,100 cars in
August and to collect an average of $6.70 per car washed.
The actual operating results for August are as follows:
Lavage Rapide
Income Statement
the Month Ended August 31
Cleaning supplies.
Electricity
Maintenance
Wages and salaries
Depreciation
Rent
Fixed Cost Cost per
per Month Car Washed
$0.40
$ 0.09
$0.15
$0.30
Administrative expenses
Total expense
Net operating incom
$1,200
$4,700
$ 8,200
$1,900
$ 1,600
8,200
$ 56,370
3,740
1,899
1,455
7,490
8,200
2,100
1,743
26,627
$ 29,74)
arrow_forward
Requirement 2. Prepare a flexible-budget-based variance analysis of the September performance.
Begin with the actual results, then complete the flexible budget columns and the static budget columns. Label each variance as favorable or unfavorable. (For variances with a $0 balance, make sure to enter "0" in the appropriate field. If the variance is zero, do not select a label. Enter operating losses with a minus sign or parentheses.)
Actual
Results
Units sold
Revenues
Variable costs
Contribution margin
Fixed costs
Operating income (loss)
arrow_forward
Chapter 18
1. List and explain the three types of flexible budget variance.
Chapter 19
2. Estimates play an important role in finance. List and explain the four common uses of estimates.
Chapter 20
3. Compare and contrast the difference between the retrospective analytics approachand the predictive analytics approach to data analytics.
Chapter 21
4. Knowledge of statistical and mathematical terms is very important in finance. Explain the difference in the field of mathematics and the discipline of statistics.
Chapter 22
5. Organizations determine whether to take on debt and how much to take on are common and necessary parts of financial planning. Explain the sources of capital that are available to an organization to obtain funds.
Chapter 23
6. Explain why an organization should buy or lease when purchasing equipment.
arrow_forward
K
Jay Draperies makes and sells curtains. Information related to its performance in 2020 is given below:
(Click the icon to view the information.)
(Click the icon to view the partially completed performance report.)
Calculate Jay Draperies' flexible-budget and sales-volume variances for (a) revenues, (b) variable costs, (c) fixed costs, and (d) operating income.
Begin with the flexible-budget variance column, then the sales-volume variance column. Label each variance as favorable (F) or unfavorable (U). (For variances with a $0 balance, make sure to
enter "0" in the appropriate field. If the variance is zero, do not select a label.)
Units sold
Revenues (sales)
Variable costs
Contribution margin
Fixed costs
Operating income
Data table
EA
Actual
Flexible-Budget
Results
Variance
1,500
EA
$
285,000
162,750
122,250
75,000
47,250
Flexible
Sales-Volume
Budget
Variance
1,500
ᏌᏊ
69
$
300,000
165,000
135,000
77,000
58,000
- ☑
Reference
EA
EA
Static
Budget
1,400
280,000
154,000
126,000
77,000…
arrow_forward
Devin Company has the following data for their budget and actual performance.
Master Budget
Variance
Master budget
Actual
Sales
153,163
156,097
?
69,245
Variable Costs
64,012
?
13,372
11,551
Fixed Costs
What is the operating income master budget variance? If it is an unfavorable variance use a
negative sign immediately before your answer. Hint: Remember you'll need to calculate budgeted
and actual operating income before you can determine the operating income master budget variance.
arrow_forward
Modified from text Table 1.2
To calculate the performance report of advertising revenue at the Daily News for March 2021,
below are the relevant information
Actual
Budget
25
Advertising pages sold
24
Average rate per page
23
47
Advertising revenue
552
1175
What is the performance or technically, type of variance for advertising revenue at the Daily
News in the month of March 2021? Enter number 1 for favourable variance and enter number 2
for unfavourable variance.
Answer:
arrow_forward
Don't use ai to answer I will report your answer Solve it Asap with explanation and calculation .
arrow_forward
please don't give solution in image format
arrow_forward
1. A planning budget is prepared before the period begins and is valid for only the planned level of activity. TRUE OR FALSE
2. An unfavorable activity variance for a cost indicates that spending was higher than it should have been for the actual level of activity for the period. TRUE OR FALSE
3. The activity variance for revenue is unfavorable if the actual revenue for the period is less than the revenue in the static planning budget. TRUE OR FALSE
4. If the actual level of activity is 4% more than planned, then the fixed costs in the static budget should be increased by 4% before comparing them to actual costs.
TRUE OR FALSE
arrow_forward
In analyzing company operations, the controller of the Carson Corporation found a $250,000 favorable flexible budget revenue variance. The variance was
calculated by comparing the actual results with the flexible budget. This variance can be wholly explained by: (CMA adapted)
Multiple Choice
О
the total flexible budget variance.
О
the total static budget variance.
О
changes in unit selling prices.
changes in the number of units sold.
arrow_forward
Click Draperies makes and sells curtains. Information related to its performance in 2020 is given below:
(Click the icon to view the data.)
Calculate Click Draperies' static-budget variance for (a) revenues, (b) variable costs, (c) fixed costs, and (d) operating income.
Begin by determining all of the actual amounts, then the static budget amounts, and finally the static-budget variances. Label each variance as
favorable (F) or unfavorable (U).
Units sold
Revenues
Variable costs
Contribution margin
Fixed costs
Operating income
Actual
Results
Data table
Units made and sold
Selling price
Variable costs
Fixed costs
Print
Actual
1,300
$205 per curtain
165,000
77,000 $
Done
Budgeted
1,400
$215 per curtain
$115 per curtain
76,000
X
arrow_forward
Need help on part 3
arrow_forward
Management Accounting
Question (Qualitative Short Answer)
a. Why is the sales forecast the starting point in budgeting?
b. What is a perpetual budget?
c. Which is a better basis for evaluating actual results: budgeted performance or past performance? Why?
d. The materials price variance can be computed at what two different points in time? Which point is better and why?
e. What effect, if any, would you expect purchasing poor-quality materials to have on direct labor variances?
f. Distinguish between ideal and practical standards.
g. Costs associated with the quality of conformance can be broken down into four broad groups. What are these four groups and how do they differ?
h. What is likely the most effective way to reduce a company's total quality costs?
i. What are the three main uses of quality cost reports?
arrow_forward
SEE MORE QUESTIONS
Recommended textbooks for you
Principles of Accounting Volume 2
Accounting
ISBN:9781947172609
Author:OpenStax
Publisher:OpenStax College

Excel Applications for Accounting Principles
Accounting
ISBN:9781111581565
Author:Gaylord N. Smith
Publisher:Cengage Learning

Principles of Cost Accounting
Accounting
ISBN:9781305087408
Author:Edward J. Vanderbeck, Maria R. Mitchell
Publisher:Cengage Learning
Related Questions
- Analyze the variances from the flexible budget and identify issues that management should be concern about. You only need to highlight bariances that are a concernarrow_forwardNote:- Do not provide handwritten solution. Maintain accuracy and quality in your answer. Take care of plagiarism. Answer completely. You will get up vote for sure.arrow_forwardHow do I calculate the flexible budget sheet?arrow_forward
- Please Do not Give Image Formatarrow_forward9) Ehrlich Corporation compares monthly actual operating results to a static budget prepared at the beginning of the month. When the actual level of activity is less than budgeted, which of the following would be true? Group of answer choices a. Variable costs would show unfavorable variances. b. Variable costs would show favorable variances. c. Fixed costs would show favorable variances. d. Fixed costs would show unfavorable variances.arrow_forwardDo not give image formatarrow_forward
- Lavage Rapide is a Canadian company that owns and operates a large automatic car wash facility near Montreal. The following table provides estimates concerning the company's costs: Cleaning supplies Electricity Maintenance Wages and salaries Depreciation Rent For Actual cars washed Revenue Expenses: Administrative expenses $ 0.03 For example, electricity costs should be $1,200 per month plus $0.09 per car washed. The company expects to wash 8,100 cars in August and to collect an average of $6.70 per car washed. The actual operating results for August are as follows: Lavage Rapide Income Statement the Month Ended August 31 Cleaning supplies. Electricity Maintenance Wages and salaries Depreciation Rent Fixed Cost Cost per per Month Car Washed $0.40 $ 0.09 $0.15 $0.30 Administrative expenses Total expense Net operating incom $1,200 $4,700 $ 8,200 $1,900 $ 1,600 8,200 $ 56,370 3,740 1,899 1,455 7,490 8,200 2,100 1,743 26,627 $ 29,74)arrow_forwardRequirement 2. Prepare a flexible-budget-based variance analysis of the September performance. Begin with the actual results, then complete the flexible budget columns and the static budget columns. Label each variance as favorable or unfavorable. (For variances with a $0 balance, make sure to enter "0" in the appropriate field. If the variance is zero, do not select a label. Enter operating losses with a minus sign or parentheses.) Actual Results Units sold Revenues Variable costs Contribution margin Fixed costs Operating income (loss)arrow_forwardChapter 18 1. List and explain the three types of flexible budget variance. Chapter 19 2. Estimates play an important role in finance. List and explain the four common uses of estimates. Chapter 20 3. Compare and contrast the difference between the retrospective analytics approachand the predictive analytics approach to data analytics. Chapter 21 4. Knowledge of statistical and mathematical terms is very important in finance. Explain the difference in the field of mathematics and the discipline of statistics. Chapter 22 5. Organizations determine whether to take on debt and how much to take on are common and necessary parts of financial planning. Explain the sources of capital that are available to an organization to obtain funds. Chapter 23 6. Explain why an organization should buy or lease when purchasing equipment.arrow_forward
arrow_back_ios
SEE MORE QUESTIONS
arrow_forward_ios
Recommended textbooks for you
- Principles of Accounting Volume 2AccountingISBN:9781947172609Author:OpenStaxPublisher:OpenStax CollegeExcel Applications for Accounting PrinciplesAccountingISBN:9781111581565Author:Gaylord N. SmithPublisher:Cengage LearningPrinciples of Cost AccountingAccountingISBN:9781305087408Author:Edward J. Vanderbeck, Maria R. MitchellPublisher:Cengage Learning
Principles of Accounting Volume 2
Accounting
ISBN:9781947172609
Author:OpenStax
Publisher:OpenStax College

Excel Applications for Accounting Principles
Accounting
ISBN:9781111581565
Author:Gaylord N. Smith
Publisher:Cengage Learning

Principles of Cost Accounting
Accounting
ISBN:9781305087408
Author:Edward J. Vanderbeck, Maria R. Mitchell
Publisher:Cengage Learning