Reference no: EM131041994
Variance analysis
A. Solve using a spreadsheet. See the requirements embedded in the spreadsheet. Include the IF function to determine Favourable and Unfavourable variances.
| Standard direct-labour rate |
$15.40 |
| Actual direct-labour rate |
$12.20 |
| Standard direct-labour hours |
13,000 |
| Direct-labour usage variance-unfavourable |
$9,800 |
|
|
| Standard unit price of materials |
$5.00 |
| Actual quantity purchased and used |
1,800 |
| Standard quantity allowed for actual production |
1,650 |
| Material purchase price variance-favourable |
$298 |
B. Prepare a Business Report as if for senior management:
1. Critically evaluate the purpose of variance analysis,
2. Explain why the materials price variance should be calculated on purchase,
3. Identify other areas in an organisation where variance analysis would be useful and
4. Evaluate the practical relevance of detailed overhead variance analysis.
For item 4. see the reading by Murray Wells.
Suggested word limit about 300- 400 words. Ensure that your answer is in business report format. Read the following online references regarding business report writing.
https://bit.ly/FoBAcademic-Writing-Skills
and
https://unilearning.uow.edu.au/report/4b.html
|
What is the sale price of the investment
: What is the sale price of the investment? (Round your answer to the nearest dollar and exclude the dollar sign and any commas from your answer.)
|
|
Why did you choose this particular compound
: Do some research on properties and applications of liquid crystals. Present a 250 word summary of your findings to the class,
|
|
Expected return on the market portfolio
: Asset Y has a beta of 1.2. The risk-free rate of return is 6 percent, while the required rate of return on the asset is 12 percent. The expected return on the market portfolio is
|
|
What is the appropriate tax treatment of the payment
: Seller Pty Ltd makes a payment of $10 000 to Buyer Pty Ltd to cover the cost of in-store promotional activities relating to its products. What is the appropriate tax treatment of the payment in the hands of both Buyer Pty Ltd and Seller Pty Ltd
|
|
Critically evaluate the purpose of variance analysis
: Critically evaluate the purpose of variance analysis and explain why the materials price variance should be calculated on purchase.
|
|
What is the discounted payback period
: An investment project has an initial cost of $260 and cash flows $75, $105, $100, and $50 for Years 1 to 4, respectively. The cost of capital is 12 percent. What is the discounted payback period?
|
|
What is purpose of message hr employee is tasked to write
: Review the assignment directions above. What is the purpose of the message the HR employee is tasked to write? What writing strategies can you use in your writing of the message?
|
|
What is the discounted payback period
: Homer is considering a project with cash inflows of $950 a year for Years 1 to 4, respectively. The project has a required discount rate of 11 percent and an initial cost of $2,100. What is the discounted payback period?
|
|
How many irr does this project have
: An investment with an initial cost of $4,000 produces cash flows of $3,400, -$500, $2,800, -$100, and $6,000 for Years 1 to 5, respectively. How many IRR's does this project have?
|