Homework Week 5 Management Accounting

xlsx

School

Pomona College *

*We aren’t endorsed by this school

Course

4310

Subject

Accounting

Date

Apr 3, 2024

Type

xlsx

Pages

14

Uploaded by CommodoreGull4135

Report
Chapter 17 Brieft Exercise 1 Budgeted Actual Overhead Cost $975,000 $950,000 Machine Hours 50,000 45,000 Direct Labor Hours 100,000 92,000 A. 975,000/100,000 = $9.75 B. 92,000 x $9.75 = $897,000 C. If there are a lot of processes going on at once then it might be more effificent to use the ABC method mig Brieft Exercise 2 Brieft Exercise 3 Production of water polo balls Cost Drivers Materials Handling Number of purchase orders Machine Setup Number of setups Factory Machine Maintenance Number of hours used Factory Supervision Number of employees overseen Quality Control Number of inspections of product Brief Exercise 4 Activity Analysis Cost Drivers a. Inventory Control Number of parts b. Machine Setup Number of setups c. Employee Training Number of employees trained d. Quality Inspections Number of inspections e. Material Ordering Number of orders f. Drilling Operations Machine hours g. Building Maintenance Square footage Brief Exercise 5 Based on the high cost of product RX3 and low cost of product Y12, it looks like it might be a more unique product requiring more overhead costs on individual proucts. So in a cost pools sense, it's skewing the overhead costs
Activity Estimated Overhead Cost Cost Drivers Machine setups $150,000 2,500 - setups Machining $375,000 25,000 - machine hours Inspections $87,500 1,750 - inspections Exercise 1 a. Compute the overhead rate using the traditional (plantwide) approach b. Compute the overhead rate using the activity-based costing approach c. Determine the difference in allocation between the two approaches Estimated Overhead = $240,000 Machining = $140,000 Machine setup = $100,000 Stadard Custom Direct Labor Costs $50,000 $100,000 Machine Hours 1,000 1,000 Setup Hours 100 400 a. plant wide 240,000/150,000 = 160% b. ABC Machining cost Machine setup cost 140,000/2,000 = $70/per hour 100,000/500 = $200/per setup c. Difference in approach Traditional Standard $50,000 x 1.6 = $80,000 $80,000 ABC Standard Machining Hours 1,000 x $70 = $70,000 Standard Machine Setup 100 x $200 = $20,000 $90,000 Exercise 2 TOTAL
Products Sales Revenue Traditional Product 540X $180,000 $55,000 Product 137Y $160,000 $50,000 Product 249S $70,000 $15,000 a. Traditional Product 540X 180,000 - 55,000 = $125,000 Product 137Y 160,000 - 50,000 = $110,000 Product 249S 70,000 - 15,000 = $55,000 b. ABC Product 540X 180,000 - 50,000 = $130,000 Product 137Y 160,000 - 35,000 = $125,000 Product 249S 70,000 - 35,000 = $35,000 c. Using Formula Product 540X 130,000 - 125,000/125,000 = 4% Product 137Y 125,000 - 110,000/110,000 = 13.64% Product 249S 35,000 - 55,000/55,000 = -36.36% d. Rational to same pricing It is likely because the labor hours/cost drivers/production methods aren't very different from eachother in b Exercise 6 Classify into activity pools out of the following options: Engineering, Machinery, Machine Setup, Quality Con Acitivty Cost Pools Machine setup $4,000 Machine Set up Inspections $16,000 Quality Control Tests $4,000 Quality Control Insurance Plant $110,000 Factory Costs Engineering Design $140,000 Engineering Depreciation Machinery $520,000 Machinery Machine Setup, Indirect Labor $20,000 Machine Set up Property Taxes $29,000 Factory Costs Oil, Heating $19,000 Factory Costs Electricity, Plant Lighting $21,000 Factory Costs Engineering Prototypes $60,000 Engineering Depreciation, Plant $210,000 Factory Costs Electricity, Machinery $36,000 Machinery Machine Maintenance Wages $19,000 Machinery Exercise 10
Your preview ends here
Eager to read complete document? Join bartleby learn and gain access to the full version
  • Access to all documents
  • Unlimited textbook solutions
  • 24/7 expert homework help
Activity Cost Pools Cost Drivers Overhead Rate Sales Commission Dollar Sales $0.05/per dollar sale Advertising - TV Minutes $300/per minute Advertising - Internet Column Inches $10/per column inch Catalogs Catalogs mailed $2.50/per catalog Cost of Catalog Sales Catalog Orders $1/per catalog order Credit and Collection Dollar Sales $0.03/per dollar sale a. 1) Traditional $400,000 x 70% = $280,000 2) ABC Sales Commission $900,000 $0.05 Advertising - TV $250 $300 Advertising - Internet $2,000 $10 Catalogs $60,000 $2.50 Cost of Catalog Sales $9,000 $1 Credit and Collection $900,000 $0.03 b. Traditional costing is undercosting how much the athletic wear selling costs. $326,000 - $280,000 = $46,000 Problem 1 a. Home Model Commercial Model Direct Materials $18.50 $26.50 Direct Labor $19.00 $19.00 Overhead $24.68 $24.68 $62.18 $70.18 $16.45 x 1.5/hour = $24.68 b. Activity Cost Pool Estimated Overhead Estimated Use of Cost Drivers Receiving $80,400 335,000 Pounds Forming $150,500 35,000 Machine hours Assembling $412,300 217,000 Parts Testing $51,000 25,500 Tests Painting $52,580 5,258 Gallons Packing and shipping $837,500 335,000 Pounds
Total $1,584,280 c. Activity Cost Pool Estimated Use of Drivers Activity Based Overhead Rates Receiving 215,000 $0.24 Forming 27,000 $4.30 Assembling 165,000 $1.90 Testing 15,500 $2.00 Painting 3,680 $10.00 Packing and shipping 215,000 $2.50 Total costs assigned Units produced Cost per unit d. ABC Manufacturing Costs Home Model Commercial Model Direct materials $18.50 $26.50 Direct labor $19.00 $19.00 Overhead $20.12 $48.80 Total cost per unit $57.62 $94.30 e. Activity Value- vs. Non-Value-Added Receiving Non-value-added Forming Value-added Assembling Value-added Testing Non-value-added Painting Value-added Packing and shipping Value-added f. 1) Activity-based costing shows the commercial model absorbs nearly 2.5 times as much overhead per unit as the home model. ($48.80 ÷ $20.12) 2) The comparison of ABC and traditional costing shows that the proper amount of overhead assigned to the two products is not equal at $24.68. $20.12 for the home model and $48.80 for the commercial model but under traditional costing, the margin of error on the commercial model was almost 100%, an understatement of $24.12 on an assignment of $24.68.
Week 5 Management Accounting ght offer a more exact cost of each area
Your preview ends here
Eager to read complete document? Join bartleby learn and gain access to the full version
  • Access to all documents
  • Unlimited textbook solutions
  • 24/7 expert homework help
Calculation Activity Based Overhead 150,000/2,500 60/per setup 375,000/25,000 15/per machine hour 87,500/1,750 50/per inspection Custom $100,000 x 1.6 = $160,000 $160,000 Custom 1,000 x $70 = $70,000 Custom 400 x $200 = $80,000 $150,000 L COSTS
ABC $50,000 $35,000 $35,000 both systems ntrol, Factory Costs Cost Driver Number of setup Number of tests Number of tests Square feet Engineering hours Machine hours Number of setup Square feet Square feet Square feet Engineering hours Square feet Machine hours Machine hours
$900,000 $250 $2,000 $60,000 $9,000 $900,000 45,000 75,000 20,000 150,000 9,000 27,000 $326,000 Activity Based Overhead Rate $0.24/per pound $4.30/per machine hour $1.90/per part $2.00/per test $10.00/per gallon $2.50/per pound Number of Cost Drivers Used per Activity
Your preview ends here
Eager to read complete document? Join bartleby learn and gain access to the full version
  • Access to all documents
  • Unlimited textbook solutions
  • 24/7 expert homework help
Cost Assigned Estimated Drivers Used Activity Based Overhead Rates $51,600 120,000 $0.24 $116,100 8,000 $4.30 $313,500 52,000 $1.90 $31,000 10,000 $2.00 $36,800 1,578 $10.00 $537,500 120,000 $2.50 $1,086,500 54,000 $1,086,500/54,000 $20.12
Costs Assigned $28,800 $34,400 $98,800 $20,000 $15,780 $300,000 $497,780 10,200 $497,780/10,200 $48.80
Your preview ends here
Eager to read complete document? Join bartleby learn and gain access to the full version
  • Access to all documents
  • Unlimited textbook solutions
  • 24/7 expert homework help