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

  Manage budgets and financial plans

Explain the budgeting process and its importance to a business, identifying the components of different budgets, forecast estimates for inclusion in the budgets.

  Prepare a retained earnings statement

Prepare a retained earnings statement for the year and Prepare a stockholders' equity section of given case.

  Prepare a master budget for the three-month period

Prepare a master budget for the three-month period.

  Construct the companys direct labor budget

Construct the company's direct labor budget for the upcoming fiscal year, assuming that the direct labor workforce is adjusted each quarter to match the number of hours required to produce the forecasted number of units produced.

  Evaluate the predetermined overhead rate

Evaluate the Predetermined Overhead Rate

  Determine the company''s bid

Determine the company's bid if activity-based costing is used and the bid is based upon full manufacturing cost plus 30 percent.

  Compute the pool rates for the different activities

Complete the schedule to compute the pool rates for the different activities.

  Prepare Company financial statements

Prepare Company financial statements

  Prepare an analysis of terracycles

This individual assignment is based on the TerraCycle Inc.

  Discuss the ethical issues

Discuss the ethical issues

  Political resources in emerging markets

Calculate the GDP in Income Approach  and Expenditure Approach

  Management accounting - ehsan electronics company

A new plant accountant suggested that the company may be able to assign support costs to products more accurately by using an activity based costing system that relies on a separate rate for each manufacturing activity that causes support costs.

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