Question

In: Economics

***** Please Read Values, Showing Work Would Be Appreciated ***** Jeri Cooper, the sales manager of...

***** Please Read Values, Showing Work Would Be Appreciated *****

Jeri Cooper, the sales manager of Brunners Corporation, is getting worried. Her last three bids were rejected in favor of a bid from a new competitor to the market. Now, she is putting together a bid for a potential new customer, and she wants to make sure the price is competitive, but still profitable. As the managerial accountant at Brunners, your job is to help Jeri prepare bids by providing the most accurate cost estimates.

Brunners is a plastic injection custom molding company, which advertises its highly automated process as keeping costs low. Currently, Brunners uses a traditional (plantwide) costing system, with overhead costs allocated based on total direct labor hours. Brunners expects to use a total of 75,000 direct labor hours this year. Suspecting that their traditional costing system is partially to blame for their recent problems, Brunners has begun the process of implementing ABC. However, before this new company entered the market, Brunners had little need to review their processes. Jeri has very little understanding of cost accounting, and has asked if her recent unsuccessful bids were due to an inaccurate costing system, or if there are process inefficiencies that have driven up costs.

In the ABC implementation process, Brunners Corporation has identified four activities. The ‘molding’ activity is a highly automated process, where a few workers oversee several machines as they process parts. This is a large cost pool, as it includes the depreciation on the building all the plastic injection molding machines (i.e., millions of dollars of property, plant, and equipment). In the ‘materials management’ activity, workers with specialized machine training prepare each machine for a new process or color (setups) by cleaning and changing the molds in the machines, and then refill the machines with plastic pellets (materials handling) as needed. In the ‘trimming’ process, workers trim extra plastic from the parts. This extra plastic normally snaps off as the parts come out of the mold, but often needs to be trimmed as the molds get worn or if the mold is not correctly installed in the machine. The trimming process is also where parts that have been underfilled are thrown out, so this activity also includes the cost of wasted materials. Finally, in the ‘inspection’ activity, inspectors randomly select and inspect parts to ensure compliance with the customer’s specifications.

Having determined four activities used at Brunners, the ABC implementation team has separated the plant’s total overhead costs into the activity cost pools (see Table 1). The next step in the ABC implementation process it to identify cost drivers for each activity. So far, they have identified cost drivers for each of the activities (see Table 1). This is still a work in progress, though, and they are still making adjustments.

The proposed job is somewhat different, requiring pieces in a variety of colors (see Table 2 for details on the proposed job). Historically, customer jobs have required only one or two setups. While Brunners has not needed to support these types of requests in the past, several of the past bids (all rejected) have had similar needs. The plant manager believes that these types of jobs will increase in the future. Proving that they can support these requests would result in new business in future years.

You’ve realized that you could provide value to Brunners in a several different ways. First, providing cost estimates from both the traditional process and the proposed ABC method could shed some light on the accuracy of the cost estimation process. Second, you can use activity based management to identify improvements that could be made to the production process (if any). Finally, with your knowledge of this job (and the market looking forward), you could provide some valuable input to the ABC implementation team.

Table 1: ABC activities, cost drivers, and cost pools

Activity

Activity cost driver

Total activity cost pool

Est. cost driver usage

Molding

Machine hours

$580,000

300,000

Materials management

Lbs of materials

220,000

120,000

Trimming

DLH (trimming)

255,000

15,000

Inspection

# of inspections

100,000

2,000

Table 2: Job proposal (resources)

Direct materials

$7,400

Direct labor (total cost)

$11,600

Direct labor hours (in molding)

300

Direct labor hours (in trimming)

500

Lbs of material

3,500

Number of setups

6

Number of colors used

4

Number of inspections

15

Number of machine-hours

1000

Required:

Write a 1-2 page memo, as the accountant of Brunners Corp, addressed to Jeri Cooper describing your analysis and the outcomes. Make sure you respond to the following items:

1.    Provide a total cost estimate using the current traditional costing system.

2.    Provide a total cost estimate using the activity based costing system proposed by the ABC implementation team.

3.    Explain to Jeri which cost estimate should be used to develop her bid, and why.

4.    Use activity based management to respond to Jeri’s question about process inefficiencies driving up costs.

5.    Evaluate the ABC system as it currently stands. Explain what specific change(s) you expect the ABC implementation team to make, and how that could affect your cost estimates.

Solutions

Expert Solution


Related Solutions

Jeri Cooper, the sales manager of Brunners Corporation, is getting worried. Her last three bids were...
Jeri Cooper, the sales manager of Brunners Corporation, is getting worried. Her last three bids were rejected in favor of a lower bid from a new competitor to the market. Now, she is putting together a bid for a potential new customer, and she wants to make sure the price is competitive, but still profitable. As the managerial accountant at Brunners, your job is to help Jeri prepare bids by providing the most accurate cost estimates. Brunners is a plastic...
Jeri Cooper, the sales manager of Brunners Corporation, is getting worried. Her last three bids were...
Jeri Cooper, the sales manager of Brunners Corporation, is getting worried. Her last three bids were rejected in favor of a lower bid from a new competitor to the market. Now, she is putting together a bid for a potential new customer, and she wants to make sure the price is competitive, but still profitable. As the managerial accountant at Brunners, your job is to help Jeri prepare bids by providing the most accurate cost estimates. Brunners is a plastic...
Please read this scenario: Your manager needs a report from youon the work you have...
Please read this scenario: Your manager needs a report from you on the work you have accomplished in the last week. He requests it in an email. But he is very vague in what is required "John, send me an email on the status of your assignments." How would you begin writing the response to this email? How do you know what to include and what not to include? Is there a right way or wrong way to send this...
If you could show work it would be greatly appreciated also, if possible use the template...
If you could show work it would be greatly appreciated also, if possible use the template that I have provided. Thank you, also this is all the question provides me with. SallyMay, Inc., designs and manufactures T-shirts. It sells its T-shirts to brand name clothes retailers in lots of one dozen. SallyMay's May 2013 static budget and actual results for direct inputs are as follows: Static Budget Number of T-shirt lots (1 lot1 dozen) 400 Per Lot of T-shirts: Direct...
Showing your work, determine the values of m and n for which the complete bipartite graph...
Showing your work, determine the values of m and n for which the complete bipartite graph Km,n has an a) Euler circuit? b) Euler path?
Hi I need the solution showing the work (in details) of this problem. Monthly sales at...
Hi I need the solution showing the work (in details) of this problem. Monthly sales at a coffee shop have been analyzed. The seasonal index values are Month Index Jan 1.38 Feb 1.42 Mar 1.35 Apr 1.03 May 0.99 June 0.62 July 0.51 Aug 0.58 Sept 0.82 Oct 0.82 Nov 0.92 Dec 1.56 and the trend line is 74123 + 26.9(t). Assume there is no cyclical component and forecast sales for year 8 (months 97 - 108).
If you could show all your work it would be greatly appreciated! Sportz, Inc., manufactures athletic...
If you could show all your work it would be greatly appreciated! Sportz, Inc., manufactures athletic shoes and athletic clothing for both amateur and professional athletes. The company has two product lines (clothing and shoes), which are produced in separate manufacturing facilities; however, both manufacturing facilities share the same support services for information technology and human resources. The following shows total costs for each manufacturing facility and for each support department. Variable Cost Fixed Cost Total Costs by Department Information...
Examples for each of those would be greatly appreciated, thank you! How do heat engines work?...
Examples for each of those would be greatly appreciated, thank you! How do heat engines work? What does a coefficient of performance mean for the engine and the different types of efficiencies? What does it mean if the engine is reversible or impossible [How to determine this]?
(Please show step by step work) Greatly Appreciated Caribbean, Inc. is considering a new investment opportunity....
(Please show step by step work) Greatly Appreciated Caribbean, Inc. is considering a new investment opportunity. The project requires an initial outlay of $525,000 and is expected to bring in a $75,000 cash inflow at the end of the first year. After the first year, annual cash flows from the project are forecasted to grow at a constant rate of 5% until the end of the fifth year and to remain constant forever thereafter. The company currently has a target...
Just want an opinion please! An educated answer would be appreciated! Are ethical choices more intensified...
Just want an opinion please! An educated answer would be appreciated! Are ethical choices more intensified and important in in a healthcare setting? Why or why not?
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT