Prepare an activity based or variance analysis

Assignment Help Managerial Accounting
Reference no: EM133708386

Management Accounting

Assessment Type: Report to management

Your Task
Your task is to effectively create spreadsheets or tables relating to Workshops 3, 7, 8 & 10 to support your recommendations in a report to senior management which uses your accumulated understanding of management accounting.

You are required to read the case scenario provided in Week 11.
You are required to use spreadsheets or tables to answer some questions.
You are required to show and explain your calculations and work processes.
You are required to provide conclusions and make recommendations to senior management based on your analysis.
You are required to attend the Week 12 Workshop to participate in Revision Activities.

Learning Objective 1: Prepare an activity based or variance analysis in a practical scenario to assist with a decision- making scenario.

Learning Objective 2: Relate analysis to organisational budgets, costings, and processes with explanations.

Learning Objective 3: Formulate conclusions and recommendations based on your analysis.

Learning Objective 4: Communicate your findings and suggested courses of action in a persuasive manner.

Question 1: Fox Books is a bookstore that has a café as well as selling books and stationery. It currently allocates Administration, Selling and Other Operating Expenses using the Cost of Goods Sold of each product department. Fox Books wants to maximise the accurate pricing and cost management of each department. Management is questioning whether the accounting system is providing the best information for making cost decisions.

Fox Books - Department Information for 30 June 2024


Café

Books

Stationery

Revenues

$1,472,432

$7,440,960

$4,630,720

Cost of Goods Sold

$1,113,370

$5,313,454

$3,444,622

Café Cleaning Expense

$36,500

-

-

Number of Orders Placed

4,000

5,600

5,000

Number of Deliveries Received

3,200

2,800

3,400

Hours of Loading Inventory

20,000

30,000

28,000

Items Sold

736,216

372,048

347,304





 

The following Administration, Selling & Other Expenses are incurred:

Purchasing Department Expenses

$949,000

Receiving Department Expenses

$864,800

Inventory Loading Expenses

$975,000

Customer Support Expenses

$273,552


$3,062,352

 

Required:
i) Prepare an income statement for each department using Cost of Goods Sold to allocate Administration, Selling & Other Expenses.

ii) Identify and explain a better method for allocating Administration, Selling & Other Expenses across the 3 departments. Use your proposed method of allocation to prepare alternative income statements for each department and compare them with the results in a).

iii) Write a brief report to the management of Fox Books to summarise your recommendations for improvements to the accounting system, and how this information would be useful for management decisions.

Question 2: Nice & Natural manufactures muesli bars for health food stores. The management accountant, Lionel, is unhappy with the standard costing system used by the business. The standard and actual amounts for Direct Materials and Direct Manufacturing Labour for May were as follows:


Standard

Actual

Muesli Bars Manufactured

12,000

13,464

Direct Material Costs

$60,000

$60,588

Direct Materials - Rice Flakes in Kilograms

360

410

Direct Materials - Carob in Kilograms

24

28

Direct Manufacturing Labour Costs

$54,000

$55,386

Direct Manufacturing Labour Hours

3,000

3,060

 

The standard costs are based on an independent survey conducted by an external consultant. Lionel had noticed that since the survey, unfavourable variances have been extremely rare. He has also observed that workers seem to have a lot of time to enjoy work breaks at the café nearby. He is concerned that the production manager is aware of the spare time, however, he is unwilling to reduce the standard requirements because his performance looks better at the current standards.

Required:

i) Calculate the price and efficiency variances for Direct Materials - Rice Flakes and Carob, and Direct Manufacturing Labour in May.

ii) Discuss the types of actions that employees may have taken to reduce the accuracy of the standards set by the external consultant. Why would employees take those actions?

iii) What actions should be taken by Lionel to correct the standards currently being used?

iv) If Lionel can obtain industry benchmarks for the estimated costs, discuss the advantages and disadvantages of using industry information to calculate the variances in a).

Question 3: Darylyn Chocolate company produces Rockyroady chocolate squares which are sold in brightly decorated canisters. Cool Canisters' sales manager has approached Darylyn with an offer to supply canisters at $1.50 each. Currently, Darylyn assigns the following costs to production of canisters:

Direct Material


$610,000

Direct Labour

11,000 Hours @ $ per Hour

$495,000

Variable Overhead

$20 per Direct Labour Hour

$220,000

Fixed Overhead

$50 per Direct Labour Hour

$550,000

Total Cost


$1,875.000

Number of Canisters


750,000

 

A conventional make-or-buy analysis suggests that Cool Canister's offer should be accepted, as the cost per canister would be more than $1.50. If Darylyn decides to buy the canisters, then $1,475,000 of total costs would be avoided, as $400,000 Fixed Overhead relates to Building Depreciation.

The management accountant has requested that further detailed analysis should be conducted before a decision is made. The management accountant has also provided activity drivers that relate to both Variable and Fixed Overheads in the production of canisters as follows:

Product Specs

10

$600 per Spec

Supervisory Hours

2,000

$40 per Hour

Material Handling Hours

6,000

$8 per Hour

Purchase Orders

55

$250 per Order

Inspections

30

$300 per Inspection

Setups

15

$400 per Setup

Machine Hours

70,000

$2.50 per Hour

 

Required:

i) Explain how the $1,475,000 of cost savings was calculated using conventional make-or-buy analysis.

ii) Determine the costs that will be saved by purchasing the canisters using the activity drivers.

iii) Finalise the make-or-buy decision using the activity data. Should Darylyn buy the canisters?

iv) If the conventional and activity-based analyses produced different conclusions, explain why.

 

Reference no: EM133708386

Questions Cloud

Why do we need a bureaucracy : In a time of fiscal restraint, politicians campaign on getting rid of "bureaucrats" who make government more inefficient and cost taxpayers more money.
How did colonial americans view disease-health and healing : How did colonial Americans view disease, health, and healing? What roles did they ascribe to God and man in maintaining health and fighting disease?
Hospitalised person has become unresponsive : A hospitalised person has become unresponsive. The left side of the body is flaccid. The attending doctor believes the person may have had a stroke
Evaluate the effectiveness of different approaches : Evaluate the effectiveness of different approaches in deterring and apprehending serial killers, as well as supporting victims and their families.
Prepare an activity based or variance analysis : Prepare an activity based or variance analysis in a practical scenario to assist with a decision- making scenario, Relate analysis to organisational budgets
Provide an example of a federal administrative agency : Provide an example in your own words of a federal administrative agency creating a law and subsequently enforcing that law.
Surgeon performs small intestine resection : A surgeon performs a small intestine resection but the bowel is left in discontinuity as part of damage control surgery in a trauma patient.
Discuss the types of actions that employees may have taken : Discuss the types of actions that employees may have taken to reduce the accuracy of the standards set by the external consultant. Why would employees take
How do these republican learning-republican : How do these Republican learning/Republican and Democratic learning/Democratic groups vary in relation to inward.

Reviews

Write a Review

Managerial Accounting Questions & Answers

  Calculate charltons operating income

Use the time saved to increase revenues proportionately. Assume travel costs will remain at $21,000. Calculate Charlton's operating income for 2013.

  Calculate the predetermined overhead allocation rate

In December 2021, she estimated the following amounts for 2022: Calculate the predetermined overhead allocation rate for 2022

  What is the journal entry for overhead applied during month

During the month, direct labor cost of $1,300 was charged to Job 88, $1,000 to Job 89, What is the journal entry for overhead applied during month

  Find the present value ratio of the new production equipment

The new equipment will have a five-year life and cost $390,000, Find the present value ratio of the new production equipment

  What would be the average waiting time

If SU can reduce the average advising time to 10 minutes, what would be the average waiting time if 400 students were seen each day

  Find what are primary information needs of each manager

Name one special-purpose management accounting report that could be designed for each manager. Include the name of the report

  How do journalize the february transactions

What was the amount of under- or overlapped manufacturing overhead? Explain what the meaning of under or overlapped manufacturing overhead?

  What the manufacturing overhead for darrin products is

Bases on the results of the previous requirement, we close the difference on manufacturing overhead by? The manufacturing overhead for Darrin Products is

  What external price for the units would sheffield

The component externally, $2800 of the fixed costs can be avoided. Below what external price for the 600 units would Sheffield choose to buy instead of make?

  Prepare the master budget for the next quarter

BAC104 Management Accounting Fundamentals - prepare the Master budget for the next quarter - Prepare the Budgets for the months of July, August and September and for the quarter

  Which single product should blossom industries produce

What is the contribution margin per unit of limited resource for each product? which single product should Blossom Industries produce?

  What the number of units required to be sold

What The number of units required to be sold to achieve $60,000 of operating profit is? 7,000 units were sold In year resulting in $70,000 of sales revenue.

Free Assignment Quote

Assured A++ Grade

Get guaranteed satisfaction & time on delivery in every assignment order you paid with us! We ensure premium quality solution document along with free turntin report!

All rights reserved! Copyrights ©2019-2020 ExpertsMind IT Educational Pvt Ltd