Calculate material handling rate that would have been used

Assignment Help Managerial Accounting
Reference no: EM131176880

Management Accounting

Question 1: 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.

Payroll

$180000

Employee on-costs

36 000

Telephone

38 000

Other utilities

22 000

Materials and supplies

6000

Depreciation

6000

Direct material budget:

 

Government contracts

2006000

Commercial products

874 000

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

Government contracts*

80 000

Commercial products

156000

Marketing

1800

Finance and Administration

2700

Human Resources

500

Maintenance

1000

Total

242000

* 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.

Question 2: Pricing & possible plant closure

Handy Household Products Ltd is a multiproduct company with several manufacturing plants. The Fremantle plant manufactures and distributes two household cleaning and polishing compounds, standard and commercial, under the Clean & Bright label. The forecast operating results for the first six months of the current year, when 100000 boxes of each compound are expected to be manufactured and sold, are presented in the following statement:

Clean & Bright Compounds, Fremantle plant Forecast results of operations for the six-month period ending June 30 (in $'000s)

 

Standard

Commercial

Total

 

$2000

$3000

$5000

Sales

 

 

 

Cost of goods sold

1600

1900

3500

Gross profit

$  400

$1100

$1500

Selling and administrative  expenses:

 

 

 

Variable

$  400

$ 700

$1100

Fixed*

240

 

§QQ

Total selling and administrative expenses

$ 640

$1060

$1700

Profit (loss) before taxes

$ (240)

$ 40

$ (200)

*The fixed selling and administrative expenses are allocated between the two products on the basis of dollar sales volume.

The standard compound sold for $20 a box and the commercial compound sold for $30 a box during the first six months of the year. The manufacturing costs are presented in the schedule below. Each product is manufactured on a separate production line. Annual normal manufacturing capacity is 200 000 boxes of each product. However. the plant is capable of producing 250 000 boxes of standard compound and 350000 boxes of commercial compound annually.

 

Cost per box

 

Standard

Commercial

Direct material

$7.00

$8.00

Direct labour

4.00

4.00

Variable manufacturing overhead

1.00

2.00

Fixed manufacturing overhead

4.00

5.00

Total manufacturing cost

$16.00

$19.00

Variable selling and administrative costs

$4.00

$7.00

The following schedule reflects the consensus of top management regarding the price-volume alternatives for the Clean & Bright products for the last six months of the current year. These are essentially the same alternatives management had during the first six months of the year.

Standard compound

Commercial compound

Alternative prices (per box)

Sales volume (in boxes)

Alternative prices (per box)

Sales volume (in boxes)

$18

120000

$25

175000

20

100000

27

140000

21

90000

30

100000

22

80000

32

55000

23

50000

35

35000

Handy Household Products' top management believe that the loss for the first six months reflects a tight profit margin caused by intense competition. Management also believe that many companies will leave this market by next year and profit should improve.

Required:

1. 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? Support your selection with appropriate calculations.

2. Independently of your answer to requirement 1, assume that the optimum alternatives for the last six months were as follows: a selling price of $23 and volume of 50 000 boxes for the standard compound, and a selling price of $35 and volume of 35 000 boxes for the commercial compound.

(a) Should management consider closing down the plant's operations until January 1 of the next year in order to minimise its losses? Support your answer with appropriate calculations.

(b) Identify and discuss the strategic factors that should be considered in deciding whether the Fremantle plant should be closed down during the last six months of the current year.

Question 3: Budgeting

Hawthorn Leisure Works (HLW) offers tennis courts and other physical fitness facilities to its members. The club has 2000 members. Revenue is derived from annual membership fees and hourly court fees. The annual membership fees are:

Individual $45
Student 30
Family 100

Approximately half the members are 'family', and the remaining memberships are split equally between individuals and students. For the next two financial years, the hourly court fees are $8 and $12, depending on the season and the time of day (prime versus non-prime time). There are 10 courts at each club. The courts are available for 12 hours per day, from 9 am to 9 pm.

The peak tennis season runs from October to April (181 days). During this period, court usage averages from 90 to 100 per cent of capacity during prime time (5 to 9 pm) and from 50 to 60 per cent of capacity during the remaining hours (9 am to 4 pm). Daily court usage during the off-season averages from only 20 to 40 per cent of capacity, and is charged at $6 per hour. All of HLW's memberships expire at the end of September. A substantial amount of the cash receipts is collected during the early part of the tennis season due to the renewal of annual membership fees and heavy court usage. However, cash receipts are not as large in autumn and drop significantly in the winter months.

For the start of the new financial year on 1 October, HLW is considering introducing a new membership and fee structure in an attempt to improve its cash flow planning. Under the new membership plan, only an annual membership fee would be charged, rather than a membership fee plus hourly court fees. There would be two classes of membership, with annual fees as follows:

Individual $ 300
Family 500

The annual fee would be collected in advance at the time the membership application was completed. Members would be allowed to use the tennis courts as often as they wished during the year under the new plan. All future memberships would be sold under these new terms. A special promotional campaign would be instituted to attract new members and to encourage current members to remain with the club. The annual fees for individual and family memberships would be reduced to $250 and $450 respectively if members pay for their yearly memberships in advance during the two-month promotional campaign.

Hawthorn Leisure Works' management estimates that 70 per cent of the current members will continue with the club, and student members would convert to individual membership. The most active members (45 per cent of the current members) would pay the yearly fee in advance and receive the special fee reduction, while the remaining members who continued would renew memberships in October. Those members who would not rejoin are not considered active (that is, they play five times or less during the year). Management estimates that the loss of members would be offset fully by new members within six months of instituting the new plan. These new members would pay a proportional amount of the yearly fee on joining. Furthermore, many of the new members would be individuals who would play during non-prime time. Management estimates that adequate court time will be available for all members under the new plan.

If the new membership plan is adopted, it would be instituted at the start of the new financial year (1 October), which is the start of the tennis season. The special promotional campaign would be conducted during August and September, prior to the start of the new financial year.

Required:

Your consulting firm has been hired to help HLW to evaluate its new fee structure. Write a letter to the club's managing director dealing with the following issues:

1 Will HLW's new membership plan and fee structure improve its ability to plan its cash receipts? Explain your answer.

2 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.

3 Hawthorn Leisure Works should evaluate the new membership plan and fee structure completely before it decides to adopt or reject it.

(a) Identify the key factors that HLW should consider in its evaluation.

(b) Explain what type of financial analyses HLW should prepare in order to make a complete evaluation.

4 Explain how HLW's cash management practices may differ from the present if the new membership plan and fee structure are adopted.

Reference no: EM131176880

Questions Cloud

Identifies the general relevance of the area of study : INTRODUCTION: Explains the importance of the study and how it addresses a problem or gap in the literature.  Identifies the general relevance of the area of study and Provides a purposeful and critical integrative overview of relevant existing knowle..
How much would g have to increase by : Suppose that the MPC is 0.8 and that Y is currently 1000. However, the government wants Y to be 1100 to fulfill an expectation of full employment. How much would G have to increase by?
Draw a state transition diagram for a machine : Draw a state transition diagram for a machine that solves this problem for any (arbitrarily long) value of N .
Does a rise in the value of a dollar result : Does a rise in the value of a dollar result in US equilibrium output (y) rising or falling?
Calculate material handling rate that would have been used : Calculate the material handling rate that would have been used by Eloise Smith's predecessor at East Coast Marine. Calculate the revised material handling costs to be allocated on a per purchase order basis.
What is the mpc : If equilibrium output (y) equals 1000 and autonomous consumption is 100 and autonomous investment is 100, what is the MPC?
Calculate number of flip-flops needed to build that circuit : Assuming that ref is an eight-bit signal, regular sequential encoding is used for the FSM, the debouncing time interval is 1 ms, and f clk = 50 MHz, calculate the number of flip-flops needed to build that circuit.
Identify the perspective of he conteporary theory : IDENTIFY THE PERSPECTIVE OF HE CONTEPORARY THEORY AND DESCRIBE CURRNT RESEARCH AND APPLICATION TO THE FIELD OF LIFESPAN DEVELOPMENT.
Disadvantages of a subsistence economy based on farming : What are the advantages and disadvantages of a subsistence economy based on farming?

Reviews

Write a Review

 

Managerial Accounting Questions & Answers

  Analyze the effect on profit of dropping accessories

Analyze the effect on profit of dropping accessories. Then write a paragraph explaining the role of common costs in your analysis and how allocation of common costs can lead to the cost allocation death spiral.

  Evaluate the equivalent units for materials

Evaluate the equivalent units for materials using FIFO and compute the equivalent units for conversion costs using FIFO.

  What additional changes

Do you think the Domino's Pizza' strategy for entering foreign markets worldwide has been appropriate? What additional changes, if any, would you recommend to Dominoes?

  How a csr agenda and its related activities are developed

Do you believe that the leadership group of an organisation can have a significant impact on how a CSR agenda and its related activities are developed and implemented?

  How much of the losses can lucy deduct

If Lucy's AGI before the losses was $90,000, how much of the losses can she deduct? How much of the losses can Lucy deduct?

  Define business processes and determine systems requirement

What a Baker does? Discuss the business activities/processes of the organisation to show your understanding about the business and What outcomes are required from these processes to achieve business objectives?

  Arctic cat produces snowmobiles for sale

Arctic Cat produces snowmobiles for sale. Identify some of the variable and fixed product costs associated with that production.

  Standard costing and variance analysis

Camping for Fun, Inc., produces a variety of camping products on a year-round basis. The best-selling item is a compact portable camping stove made from sheets of rust-free aluminum.

  Why are batch sizes generally larger in bottleneck

Why are batch sizes generally larger in bottleneck departments?

  Recalculate the customer level operating profit

Calculate the customer level operating profit for each of the above merchandising firms based on the actual number of orders written - Prepare a customer profitability analysis ranking the firms from most to least profitable showing the level of ne..

  General administrative expenses are allocated

Given the current level of sales, would you recommend that the model C3 lawn chair be dropped? Prepare appropriate computations to support your answer.

  Further information was determined by examining the company

Further information was determined by examining the company's 2014 income statement.

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