1 | Calculation of Unit Product Cost, Selling Price and Predetermined Overhead rate | |||||
Product | Principles | Intermediate | Advanced | Tax | ||
Ink | $20 | $40 | $60 | $80 | ||
Paper | $10 | $20 | $20 | $30 | ||
Labor | $1 | $2 | $10 | $20 | ||
Overhead | $0.80 | $1.60 | $8.00 | $16 | ||
Total Unit Cost | $31.80 | $63.60 | $98.00 | $146.00 | ||
Selling Price multiple | 2 | 3 | 3 | 4 | ||
Selling Price | $63.60 | $190.80 | $294.00 | $584.00 | ||
Predetermined Overhead rate | $8 | $8 | $8 | $8 | ||
Working note: | ||||||
Labor rate per hour | $10 | $10 | $10 | $10 | ||
Labor productivity per hour | 10 | 5 | 1 | 0.5 | ||
Labor cost per unit (Rate/productivity) | $1 | $2 | $10 | $20 | ||
2 | Cost of Goods Manufactured | |||||
Product | Principles | Intermediate | Advanced | Tax | Total | |
Direct Materials: | ||||||
Beginning Inventory | 0 | 0 | 0 | 0 | 0 | |
Add: Purchases | 3100000 | |||||
Less: Ending Inventory | 250000 | |||||
Raw Material used | 600000 | 900000 | 800000 | 550000 | 2850000 | |
Direct Labor | 22000 | 28000 | 110000 | 90000 | 250000 | |
Applied Overhead | 17600 | 22400 | 88000 | 72000 | 200000 | |
Total Manufacturing cost | 639600 | 950400 | 998000 | 712000 | 3300000 | |
Add: Beg WIP | 0 | 0 | 0 | 0 | 0 | |
Less: Ending WIP | 60000 | 180000 | 160000 | 110000 | 510000 | |
Cost of Goods Manufactured | 579600 | 770400 | 838000 | 602000 | 2790000 | |
3 | Cost of goods sold and gross margin | |||||
Product | Principles | Intermediate | Advanced | Tax | Total | |
Sales | $954,000 | $1,908,000 | $1,470,000 | $1,752,000 | $6,084,000 | |
$0 | ||||||
Beginning Finished goods | 0 | 0 | 0 | 0 | $0 | |
Cost of goods manufactured | $579,600 | $770,400 | $838,000 | $602,000 | $2,790,000 | |
Less: Ending finished goods | $95,400 | $127,200 | $294,000 | $146,000 | $662,600 | |
Unadjusted COGS | $484,200 | $643,200 | $544,000 | $456,000 | $2,127,400 | |
Add Under or deduct over overhead | $10,000 | |||||
Adjusted COGS | $2,137,400 | |||||
Gross Margin | $3,946,600 | |||||
Ending WIP is for material only. |
Working Note: | ||||
Product | Principles | Intermediate | Advanced | Tax |
Raw Material used | 20000*20+20000*10 | (30000*20)+(30000*10) | 30000*20)+(20000*10) | 20000*20+15000*10 |
Direct Labor | 2200*10 | 2800*10 | 11000*10 | 9000*10 |
Applied Overhead | 2200*8 | 2800*8 | 11000*8 | 9000*8 |
Ending WIP | (2000*20)+(2000*10) | (6000*20)+(6000*10) | (6000*20)+(4000*10) | "(4000*20)+(3000*10) |
Ending finished goods | 3000*$31.8 | 2000*63.60 | 3000*$98 | 1000*146 |
JOINT PRODUCT AND ACTIVITY BASED COSTING IN CLASS PROBLEM ASSUMPTIONS: lava ANNİ PRINCIPLES INTER...
Activity-Based Product Costing Roberts Company produces two weed eaters: basic and advanced. The company has four activities: machining, engineering, receiving, and inspection. Information on these activities and their drivers is given below. Basic Advanced Total Units produced 150,000 450,000 $46,800,000 Prime costs $10,800,000 Machine hours 150,000 750,000 $57,600,000 900,000 2,000 200 1,800 Engineering hours Receiving orders Inspection hours 300 900 1,200 800 1,600 2,400 Overhead costs: Machining Engineering $9,000,000 860,000 468,000 Receiving Inspecting products 480,000 Required: 2. Calculate the unit...
Activity-Based Product Costing Roberts Company produces two weed eaters: basic and advanced. The company has four activities: machining, engineering, receiving, and inspection. Information on these activities and their drivers is given below. Basic Advanced Total Units produced 150,000 Prime costs 450,000 $46,800,000 750,000 $10,800,000 150,000 $57,600,000 Machine hours 900,000 2,000 200 1,800 Engineering hours Receiving orders 300 1,200 Inspection hours 800 1,600 2.400 Overhead costs: $9,000,000 860,000 Machining Engineering Receiving Inspecting products 468,000 480,000 Required: 1. Calculate the four activity...
Activity Based Product Costing Total Roberts Company produces two weed eaters: basic and advanced. The company has four activities: machining engineering, receiving and inspection Information on these activities and their drivers is given below. Basic Advanced Units produced 120,000 360,000 Prime costs $10,000,000 543,200,000 $53.280,000 Machine hours 120.000 600,000 720.000 Engineering hours 300 2,700 3,000 Receiving orders 900 Inspection hours 900 1.800 2,700 Overhead costs: Machining 10. 58,640,000 1.230,000 Engineering 11 324,000 12. Inspectre products 351,000 13. Required: 14 FOOTTI...
Mastery Problem: Activity-Based Costing (Advanced) Activity-Based Costing Traditionally, Overhead cost: Sometimes referred to as "factory overhead," this is an indirect cost that is not directly tied to the production of units, yet nonetheless must be built into product cost in order to appropriately price it. Examples are managerial salaries, rent expense, setup costs, and property taxes.overhead costs are assigned based arbitrarily on the rate of either Direct labor: This is a labor cost directly associated with the production of goods...
Activity Based Costing 1 Chapter 3: Applying Excel Fra formulato each of the cols marked when Review Problem. Activity Based Couting 6 Data Annual sales in units 9 Direct materials per unit 10 Direct labor hours per unit 2000 Tourist 10 000 $25 517 12 Direct labor rate 512 per DUH Overhead Expected Activity 16 Activities and Activity Measures 17 Labor-related (direct labor hours) 19 Machine setups (setups) 19 Production orders (orders) 20 General factory (machine hours) $ 80.000 150.000...
Problem 4-17 Contrast Activity-Based Costing and Conventional Product Costing [LO4-2, LO4-3, LO4-4] [The following information applies to the questions displayed below.] Puget World, Inc., manufactures two models of television sets, the N 800 XL model and the N 500 model. Data regarding the two products follow: Direct Labor- Hours per Unit Annual Production Total Direct Labor-Hours Model N 800 XL 3.5 4,500 units 15,750 Model N 500 1.2 12,500 units 15,000 30,750 Additional information about the company follows: a. Model...
Problem 3A-4 (Algo) Activity-Based Absorption Costing as an Alternative to Traditional Product Costing [LO3-5] Ellix Company manufactures two models of ultra-high fidelity speakers—the X200 model and the X99 model. Data regarding the two products follow: Product Direct Labor-Hours Annual Production Total Direct Labor-Hours X200 0.4 DLHs per unit 19,000 units 7,600 DLHs X99 0.6 DLHs per unit 48,000 units 28,800 DLHs 36,400 DLHs Additional information about the company follows: a. Model X200 requires $30 in direct materials per unit, and...
Traditional Product Costing Versus Activity-Based Costing Assume that Panasonic Company has determined its estimated total manufacturing overhead cost for one of its plants to be $240,000, consisting of the following activity cost pools for the current month: Activity Centers Activity Costs Cost Drivers Assembly setups $63,000 Setup hours Materials handling 33,000 Number of moves Assembly 120,000 Assembly hours Maintenance 24,000 Maintenance hours Total $240,000 Activity Level 1,500 300 12,000 1,200 Total direct labor hours used during the month were 8,000....
Plantwide versus Departmental Rates, Product-Costing Accuracy: Activity-Based Costing Ramsey Company produces speakers (Model A and Model B). Both products pass through two producing departments, Model A's production is much more labor-intensive than that of Model B. Model B is also the more popular of the two speakers. The following data has been gathered for the two products Product Data Product Data Model A Model B Units produced per year 10,000 100,000 Prime costs $150,000 $1,500,000 Direct labor hours 140,000 300,000...
Problem #3 15 Points William Company is contemplating the establishment of an activity-based costing (ABC) system. It currently applies all overhead costs based on direct labor costs. The company has estimated the following costs and activities for May: Table 1: | Cost Activity Machine Setups $33,600 400 setups Utilities 60,000 200,000 usage hours Materials Handling 84,000 12,500 crates Direct labor 35,520 $20 per labor hour Direct material 60,000 $1 per pound Direct labor cost is $20 per hour. The following...