Steel

profileknohe_

Steel Company USA is a metal fabricating business that sells products mainly to the home construction market. The data table that follows should be used in this assignment. The problems are at the end of the data table.

Inputs

Costs

Sandpaper

$4,000

Materials - handling costs

$140,000

Lubricants and coolants

$10,000

Misc indirect labor

$80,000

Misc direct labor

$600,000

Direct materials inv Jan 1, 2010

$80,000

Direct materials inv Dec 31, 2010

$100,000

Finished goods inv, Jan 1, 2010

$200,000

Finished goods inv, Dec 31, 2010

$300,000

WIP Jan 1, 2010

$20,000

WIP Dec 31, 2010

$28,000

Plant lease costs

$108,000

Depreciation - PPE

$72,000

Property taxes

$8,000

Insurance

$6,000

Direct materials purchased

$920,000

Revenues

$2,720,000

Marketing Promo

$120,000

Marketing Salaries

$200,000

Distribution costs

$140,000

Customer service costs

$200,000

  1. Using the information in the table, create an income statement with a schedule for costs of goods manufactured. Make sure that for the costs you classify if they are direct or indirect and indicate if they are variable or fixed.
  2. Let's assume that both direct material costs and plant leasing costs are for the production of 1,800,000 units. What would be the direct material cost of each of these units produced? Plant leasing cost per unit? Plant leasing should be a fixed cost here.
  3. Now let's assume we build 2,000,000 units next year. Repeat the calculations in item #2 above for direct materials and plant leasing costs.
  4. Explain why the unit costs for direct materials didn't change in numbers 2 and 3, but the unit costs for the plant lease did.
    • 8 years ago
    • 5
    Answer(1)

    Purchase the answer to view it

    blurred-text
    NOT RATED
    • attachment
      steel_ltd.xlsx
    Bids(1)