Compute profitability per pound under abc system at lehigh

Assignment Help Financial Accounting
Reference no: EM131404567

Assignment

Exhibit 4 Sample Product Data

 

Alloy: Condition Round

Conversion: Roller Wire

Die Steel: Chipper Knife

Die Steel: Round Bar

High Speed: Machine Coil

Production (lbs)

478,679

2,081,543

2,413,299

6,697,682

2,530,552

Number of skus

311

473

418

172

102

Number of orders

957

4,163

3,218

3,349

1,012

Bill of Materials (lbs / lb of output)






Steel scrap

1.00

0.00

1.00

1.00

1.00

Alloys

0.01

0.00

0.01

0.01

0.01

 

(@ $48.29 / lb)


(@ $6.29 / lb)

(@ $15.29 / lb)

(@ $152.29 / lb)

Machine Time (min / lb; crew = 1)






Melting (Electric Arc Furnace)

0.20

0.00

0.09

0.09

0.09

Refining (VOD)

0.21

0.00

0.10

0.10

0.10

Molding / Breakdown (Ingot / PFF)

0.12

0.00

0.07

0.08

0.07

Rolling (CRM)

0.10

0.15

0.33

0.09

0.03

Finishing (multiple)

0.06

0.02

0.07

0.08

0.05

Total time

0.69

0.17

0.66

0.44

0.34

Exhibit 5 Standard Cost Results

Standard Cost ($ / lb)

Alloy: Condition Round

Conversion: Roller Wire

Die Steel: Chipper Knife

Die Steel: Round Bar

High Speed: Machine Coil

Price

$2.31

$0.77

$1.02

$0.93

$2.33

Materials

$0.54

$0.00

$0.12

$0.21

$1.58

Direct labor

$0.29

$0.07

$0.28

$0.18

$0.14

Direct manufacturing expense

$0.24

$0.06

$0.23

$0.16

$0.12

Contribution margin

$1.24

$0.64

$0.39

$0.38

$0.49

Contribution margin (%)

53.7%

83.1%

38.2%

40.9%

21.0%

Total contribution

$593,562

$1,332,188

$941,187

$2,545,119

$1,239,970

Manufacturing & administrative overhead

$0.64

$0.64

$0.64

$0.64

$0.64

Operating profit

$0.60

$0.00

($0.25)

($0.26)

($0.15)

Operating profit (%)

26.0%

0.0%

-24.5%

-28.0%

-6.4%

Total operating profit

$287,207

$0

($603,325)

($1,741,397)

($379,583)

Exhibit 6 Lehigh Activity Cost Pools

Activity

Driver

Driver Volume

Amount

Melting: Depreciation

melt machine minutes

5,145,632

$2,139,865

Melting: Maintenance

melt machine minutes

5,145,632

$975,130

Melting: Utilities

melt machine minutes

5,145,632

$2,036,477

Refining: Depreciation

refine machine minutes

5,691,042

$1,711,892

Refining: Maintenance

refine machine minutes

5,691,042

$780,104

Refining: Utilities

refine machine minutes

5,691,042

$1,745,551

Molding: Depreciation

mold machine minutes

4,226,965

$427,973

Molding: Maintenance

mold machine minutes

4,226,965

$390,052

Molding: Utilities

mold machine minutes

4,226,965

$290,925

Rolling: Depreciation

roll machine minutes

8,258,382

$2,995,811

Rolling: Maintenance

roll machine minutes

8,258,382

$975,130

Rolling: Utilities

roll machine minutes

8,258,382

$872,776

Finishing: Depreciation

finish machine minutes

4,057,311

$1,283,919

Finishing: Maintenance

finish machine minutes

4,057,311

$780,104

Finishing: Utilities

finish machine minutes

4,057,311

$872,776

General & Administrative

pounds

50,299,420

$5,400,955

Material Handling & Setup*

orders

57,147

$4,936,068

Order Processing

orders

57,147

$3,953,709

Production Planning

orders

57,147

$3,339,500

Technical Support

skus

6,642

$5,766,579

Total



$41,675,296

1. For each of the five sample products, compute the profitability per pound under the ABC system at Lehigh.

2. For each of the five sample products, compute the profitability per pound per unit of the constraint under the TOC approach implemented at Lehigh.

3. Critique the ABC and TOC approaches with respect to determining Lehigh's optimal product mix. Which costing system/perspective should Lehigh use to determine its product mix? Devise an alternative method of calculating profits that combines the insights/assumptions of ABC and TOC in a way that is appropriate for Lehigh's business situation while eliminating those insights/assumptions that are inappropriate in the current situation.

4. Compute the profits for the five sample products under the new method you advocate in #3.

Reference no: EM131404567

Questions Cloud

Is there a positive association or a negative association : For each of the following pairs of variables, is there likely to be a positive association, a negative association, or no association?
Correlation between price and annual cigarette consumption : What are some other explanations for the negative correlation between cigarette price and annual cigarette consumption?
Analyze the strategic scope of the horizontal acquisition : In this case study you are to analyze the strategic scope of the horizontal acquisition by Verizon Communications (hereafter referred to as Verizon) of Verizon Wireless from Vodafone
Calculate three-point moving averages for the series : Construct a time series chart and examine it for evidence of a trend and recurring components for parts of the day.
Compute profitability per pound under abc system at lehigh : Compute the profitability per pound under the ABC system at Lehigh. For each of the five sample products, compute the profitability per pound per unit of the constraint under the TOC approach implemented at Lehigh.
Discuss any potential ethical or social responsible issues : Select/ identify a major consumer product and the company that makes it. Provide a brief history of them both. (Select an existing publicly owned company. View the link Public Companies for a comprehensive list of publicly traded companies.)Identi..
Determine nature of the relationship between two variables : Sometimes the main purpose of a regression analysis is to determine the nature of the relationship between two variables, and sometimes the main purpose is to use the equation in the future to predict a y value when the x value is known.
Determine the payback period for each site : Using a discount rate of 8% calculate the net present value for each site.
Sketch a scatterplot with an outlier : Sketch a scatterplot with an outlier that would inflate the correlation between the two variables. Sketch a scatterplot with an outlier that would deflate the correlation between the two variables.

Reviews

Write a Review

Financial Accounting Questions & Answers

  Express differences between canadian gaap and ifrs

Analyze your comparator company and explain and evaluate similar adjustments, if any exist. Complete the grid in Exhibit 2 of the solution template for each item.

  Brad jolie recently decided to open a restaraunt

brad jolie recently decided to open a restaraunt specializing in new orleans cuisine. he purchased a restaraunt

  Explain how much liability for outstanding premiums

If the bowls cost LeMay Company $3 each, explain how much liability for outstanding premiums should be recorded at the end of 2012.

  How much do firms market and book values per share differ

Tucker Electronic System's current balance sheet shows total common equity of $3,125,000. The company has 125,000 shares of stock outstanding, and they sell at a price of $52.50 per share. By how much do the firm's market and book values per share di..

  Determine the new depreciation charge for the third year

Given this information, determine the new depreciation charge for the third year on the basis of the revised estimated useful life.

  Prepare a bank reconciliation for december 2016

Journalize the selected transactions, starting on page 21 of the journal.-  Prepare a bank reconciliation for December 2016.

  Determine the effective-interest rate

Headland Company sells 8% bonds having a maturity value of $2,400,000 for $2,053,950. The bonds are dated January 1, 2017, and mature January 1, 2022. Interest is payable annually on January 1. Collapse question part (a) Determine the effective-inter..

  What is internal rate of return

The project would generate before tax annual cash inflows of $28,500. The tax rate is 35% and the company’s discount rate is 14%. What is internal rate of return?

  Calculation of net income amp retained

calculation of net income amp retained earnings.calculate1net income2retained earnings based on the information below.

  1 find what purposes are served by shelter partnerships

1. find what purposes are served by shelter partnerships cost information?2. find what are cost objects?3. are ruth

  Prepare the essential entries to clear the intangible assets

Prepare the essential entries to clear the Intangible Assets account and to set up separate accounts for distinct types of intangibles. Make the entries as of December 31, 2015, recording any essential amortization.

  Although the manufacturing equipment is perfectly functional

Elliott Incorporated manufactures garden tools, and although the manufacturing equipment is perfectly functional, it is not modern. Upgrading to modern equipment would speed up the manufacturing process such that direct labor and variable manufacturi..

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