W4 - Excel Workbook (10-23-2011)

W4 - Excel Workbook (10-23-2011) - Sliting Overhead Total...

Info iconThis preview shows page 1. Sign up to view the full content.

View Full Document Right Arrow Icon
Timberland's Overhead Allocation - 105% Total Depreci $800,000  Material Costs Total Labor $300,000  Product A $240,000  Total Energy $500,000  Product B $10,400  Total Other is $198,470  Product C $196,000  Total Waste i $30,000  Product D $1,295,000  Totals $1,828,470  $1,741,400  land's Overhead Allocation - 105% (Cost Per Roll) Products Material Costs Product Change Sliting Overhead Total Product Cost Cost Per Roll Product A $240,000  $11,750  $107,250  492,000 $851,000  $9,840  Product B $10,400  $11,750  - $21,320  $43,470  $10,660  Product C $196,000  $11,750  $87,750  $401,800  $697,300  $11,480  Product D $1,295,000  $11,750  - $2,654,750  $3,961,500  $15,170  Totals $1,741,400  $47,000  $195,000  3,569,870 $5,553,270  $47,150  Timerbland's Overhead Allocation - New Rate (Cost Per Roll) Products Material Costs Product Change
Background image of page 1
This is the end of the preview. Sign up to access the rest of the document.

Unformatted text preview: Sliting Overhead Total Product Cost Cost Per Roll Product A $240,000 $11,750 $107,250 458,400 $817,400 $9,168 Product B $10,400 $11,750 -$19,464 $41,614 $9,732 Product C $196,000 $11,750 $87,750 $374,360 $669,860 $10,696 Product D $1,295,000 $11,750 -$2,473,450 $3,780,200 $14,134 Totals $1,741,400 $47,000 $195,000 3,325,674 $5,309,074 $43,730 Products Material Costs Product Change Sliting Overhead Total Product Cost Product A $240,000 $11,750 $107,250 458,400 $817,400 Product B $10,400 $11,750 -$19,464 $41,614 Product C $196,000 $11,750 $87,750 $374,360 $669,860 Product D $1,295,000 $11,750 -$2,473,450 $3,780,200 Totals $1,741,400 $47,000 $195,000 3,325,674 $5,309,074...
View Full Document

This note was uploaded on 11/25/2011 for the course ACT 5060 taught by Professor Debroahpendarvis during the Fall '08 term at Nova Southeastern University.

Ask a homework question - tutors are online