60.1K

Verified Solution

Link Copied!

I attached the problem and the page from the book that is needed to solve it. I need it all answered with excel formulas. For example, =B12 or =SUM(A12:H7) and so on. Thank you

D E F G H K L M N Enter formulas or descriptions in these fields 1 Overhead assigned to each product under traditional costing system Junior $92 $51 $390 4000 Expert $115 $75 $615 9000 Traditional costing overhead rate Junior Expert Total B 1 Chapter 4 Lab 2 PB 4-4, page 203 3 4 5 6 7 8 Given Data: 9 10 11 Direct materials cost per unit 12 Direct labor cost per unit 13 Sales price per unit 14 Expected unit production per month 15 16 17 Cost Drivers 18 Number of setups required 19 Number of inspections 20 Number of Machine hours 21 Number of engineering hours 22 23 24 25 26 Overhead Cost Pools: 27 Setups 28 Quality Control 29 Maintenance 30 Engineering 31 32 33 Traditional Overhead applied Junior 60 975 350 352 Expert 86 675 650 612 Total 146 1650 1000 964 2 Calculate the traditional product unit cost Junior Expert Material Labor Overhead Total Product Cost 3 Calculate Unit Gross Margin per product Overhead Costs $136,364 $163,020 $78,840 $106,522 $484,746 Junior Expert Sales COGS Gross Margin A B D E F I K M N G H 4 Calculate Activity Rates OH costs Driver Driver Vol. Activity Rate 34 35 36 37 38 39 40 41 42 43 44 Cost Pool Setups Quality Control Maintenance Engineering Total 5 Apply activity overhead Junior Expert Total 45 46 Setups Quality Control Maintenance Engineering Total Overhead Per Unit OH 47 48 49 50 51 52 53 54 55 56 57 58 6 Calculate per unit ABC cost Junior Expert Material Labor Overhead Total Product Cost 7 Calculate Unit Gross Margin for ABC costing Junior Expert 59 60 61 62 63 64 65 66 67 68 69 Sales COGS Gross Margin Traditional Gross Margin 8 Unit Gross Margin Differences Difference 70 71 Summit Company makes two models of snowboards, the Junior and the Expert. Its basic production information follows: Page 203 Junior Expert Direct materials cost per unit $ 92 $115 Direct labor cost per unit 51 75 Sales price per unit 390 615 Expected production per month 4,000 units 9,000 units Summit has monthly overhead of $484,746, which is divided into the following cost pools: Setup costs $136,364 Quality control 163,020 Maintenance 78,840 Engineering 106,522 Total $484.746 The company has also compiled the following information about the chosen cost drivers: Junior Expert Total Number of setups required 60 86 146 Number of inspections 975 675 1,650 Number of machine hours 350 650 1,000 Number of engineering hours 352 612 964

Answer & Explanation Solved by verified expert

See Answer