Prepare a forecast of the cumulative dollar impact

Assignment Help Managerial Accounting
Reference no: EM13498178

Activity-based costing

East Coast Marine Ltd (ECM) manufactures parts for small marine craft. Over the past decade, ECM's management has met its goal of reducing its reliance on government contract work to 50 per cent of total sales. ECM is now equally reliant on commercial sales and government contracts.

Traditionally, the costs of the Material Handling Department have been allocated to direct material as a percentage of direct material dollar value. This was adequate when the majority of the manufacturing was homogeneous and related to government contracts. Recently, however, government auditors have rejected some proposals, stating that ‘the amount of Material Handling Department costs allocated to these proposals is disproportionate to the total effort involved'.

Eloise Smith, the newly hired cost accounting manager, was asked by the manager of ECM's Government Contracts Unit, Paul Jones, to find a more equitable method of allocating the Material Handling Department costs to the user departments. Her review has revealed the following information:

- The majority of the direct material purchases for government contracts are high-dollar, low-volume purchases, while commercial materials represent low- dollar, high-volume purchases.
- Administrative departments such as Marketing, Finance and Administration, Human Resources and Maintenance also use the services of the Material Handling Department on a limited basis but have never been charged in the past for material handling costs.

- One purchasing manager with a direct phone line is assigned exclusively to purchasing high-dollar, low-volume material for government contracts on an annual salary of $36 000. Employee on-costs are estimated to be 20 per cent of the annual salary. The annual costs of the dedicated phone line are $2800.

- The components of the Material Handling Department's budget for the coming year, as proposed by Lindley's predecessor, follow.

1043_Activity-based costing.png

Smith has estimated the number of purchase orders to be processed in the coming year as follows:

1438_Activity-based costing1.png

* Exclusive of high-dollar, low-volume materials.

Smith has recommended to Jones that material handling costs should be allocated on a per purchase order basis. Jones realises that the company has been allocating to government contracts more material handling costs than can be justified. However, the implication of Smith's analysis could be a decrease in his unit's earnings and, consequently, a cut in his annual bonus. Jones told Smith to ‘adjust' her numbers and modify her recommendation so that the results will be more favourable to the Government Contracts Unit.

Being new in her position, Smith is not sure how to proceed. She feels ambivalent about Jones' instructions and suspects his motivation may not be in the best interest of ECM. To complicate matters for Smith, the company's new managing director has asked her to prepare a three-year forecast of the Government Contracts Unit's results, and she believes that the newly recommended allocation method would provide the most accurate data. However, this would put her in direct opposition to Jones' directives.

Smith has assembled the following data to project the material handling costs over the next three years:

- The number of purchase orders increases 5 per cent per year.
- The ratio of government purchase orders to total purchase orders remains at 33 per cent.
- Total direct material costs increase 2.5 per cent per year.
- Material handling costs remain the same percentage of direct material costs.
- Direct government costs (payroll, employee on-costs, and direct phone line) remain constant.
- In addition, she has assumed that the cost of government material in the future will be 70 per cent of total material.

Required:

1 Calculate the material handling rate that would have been used by Eloise Smith's predecessor at East Coast Marine.

2 Calculate the revised material handling costs to be allocated on a per purchase order basis.

3 Discuss why purchase orders might be a more reliable cost driver than the dollar amount of direct material.

4 Calculate the difference due to the change to the new method of allocating material handling costs to government contracts.

5 Prepare a forecast of the cumulative dollar impact over a three-year period (based on the coming year plus 2 more years) of Eloise Smith's recommended change for allocating Material Handling Department costs to the Government Contracts Unit. Round all calculations to the nearest whole number.

6 Referring to the standards of ethical conduct for accountants described in Chapter 1:

(a) Discuss why Eloise Smith has an ethical conflict.

(b) Identify several steps that Smith could take to resolve the ethical conflict.

Reference no: EM13498178

Questions Cloud

Define water is present in air at 122 deg f : Water is present in air at 122 deg F and a total pressure of 14.696 psi in an amount such that the relative humidity is 50%. Water is removed by
Identify and discuss the strategic factors : What unit selling price should management select for each of the Clean & Bright compounds for the remaining six months of the year to maximise profit?
What is his speed after the collision : Olaf is standing on a sheet of ice that covers the football stadium parking lot in Buffalo, New York; there is negligible friction between his feet and the ice. what is his speed after the collision
Depict the structure of the stereoisomer with dipole moment : One has a dipole of 0 D, and the other has a dipole moment of 2.95 D. Draw the structure of the stereoisomer with dipole moment of 2.95 D.
Prepare a forecast of the cumulative dollar impact : Calculate the material handling rate that would have been used by Eloise Smith's predecessor at East Coast Marine and calculate the revised material handling costs to be allocated on a per purchase order basis.
Calculate the speed of the discus at release : To throw the discus, the thrower holds it with a fully outstretched arm. Starting from rest, he begins to turn with a constant angular acceleration, what will be the speed of the discus at release
Explain the mass of silver in 3.4 g agno3 : What is the mass of silver in 3.4 g AgNO3. Show and explain each step and solve.
Compute the number of lines per centimeter on the grating : The yellow light from a helium discharge tube has a wavelength of 587.5 nm. Calculate the number of lines per centimeter on the grating
Estimate the effect on sales revenue : Estimate the effect on sales revenue resulting from the planned change in fee structure for the next financial year, which starts 1 October and ends on 30 September. State any assumptions that you need to make.

Reviews

Write a Review

Managerial Accounting Questions & Answers

  Amount of direct materials cost

What is the amount of direct materials cost incurred by LP Production:

  The sparklin automotive company sac has been in business

the sparklin automotive company sac has been in business since 1930. it began business in the united states supplying

  Cost of goods manufactured-cost of goods sold

During the year, the company purchased $100,000 of raw material and spent $340,000 on direct labor. Other data: Manufacturing overhead incurred $450,000; sales, $1,560,000; selling and administrative expenses, $90,000; income tax rate, 30%.

  Roi related to years investment opportunity

What is the margin related to this years investment opportunity, and what is the turn over related to this year's investment opportunity and what is the ROI related to year's investment opportunity

  What factors could possibly explain this shift

To get an overall picture of each company's capital structure it is helpful to see a chart that summarizes the company's capital structure over the past decade.

  What is the purpose of an entity

What is the purpose of an entity and what are the rights of the stakeholders of an entity?

  Budget constraints in two period model

Explain how the budget constraint of househould in two-period model is affected by each of the following changes. In each case, do you think the household is better off or worst off or is the answer ambiguous?

  Job costing system of johnsons custom shop

The job costing system of Johnsons custom shop has five activities which are employed as indirect cost pools

  Calculate sales in dollars needed to break even in 2015

Recast the full costing income statement for 2014 into a variable costing format.  Does it appear, as Sanjay Patel contends, that the more the company sells, the more it loses?

  What are the components of budget

What are the components of a budget? Are they same for every organization? Why or why not? Should every organization forecast its operating budget? Why or why not?

  Changes in cash conversion cycle

Bello Corp. has annual sales of $50,735,000, an average inventory level of $15,012,000, and average accounts receivable of $10,008,000. The company makes all purchases on credit and has always paid on the 30th day.

  Prepare an operating budget for the banner company

You are well aware of the importance of budgeting in managing a business enterprise successfully. Consequently, you have decided to prepare an operating budget for the Banner Company for the year 2013.

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