Logo
Home Study Material Contact Search
AI Chat FREE
  1. business
  2. accounting
  3. complete all calculations using excel spreadsheet:

Complete all calculations using Excel Spreadsheet: Acme electric manufactures circuit breaker boxes. The product manufacturing...

80.2K

Verified Solution

Question

Accounting

Complete all calculations using Excel Spreadsheet:

Acme electric manufactures circuit breaker boxes. The product manufacturing overheads for last year are known:

Utility costs (related to machine hours) = $298,000

Product setup costs = $189,200

Cost of ordering

materials = $28,380

Cost of material requisitions = $52,030

Details of three product models are the relevant information for last year are:image

Labor cost = $65/hour

a) Calculate the unit cost for each of the three products using traditional cost accounting (based on labor content)

b) Calculate the unit cost of each of the three products using ABC

c) Calculate the unit cost of each of the three products using traditional cost accounting (based on machine time content) Hint: calculate the overhead allocation per machine hour (instead of per labor hour).

Model 1 Model 2 Model 3 Number of production runs (setups) 26 37 27 52 Number of material orders 30 45 45 Number of material requisitions 150 105 Units produced 1000 2000 2500 Machine hours per unit 1.5 2.25 1 0.5 Direct labor hours per unit Direct materials per unit $15 $18 $23

Answer & Explanation Solved by verified expert
Get Answers to Unlimited Questions

Join us to gain access to millions of questions and expert answers. Enjoy exclusive benefits tailored just for you!

Membership Benefits:
  • Unlimited Question Access with detailed Answers
  • Zin AI - 3 Million Words
  • 10 Dall-E 3 Images
  • 20 Plot Generations
  • Conversation with Dialogue Memory
  • No Ads, Ever!
  • Access to Our Best AI Platform: Flex AI - Your personal assistant for all your inquiries!
Become a Member

Other questions asked by students