Homework Help is Here – Start Your Trial Now!
Business
Accounting
Alanco, Incl manufactures a variety of products and is currently maunfacturing all of its own component parts. 2 An outside supplier has offered to sell one of those components to Alanco. To evaluate this offer, the following 3 information has been gathered relating to the cost of producing the component internally: 4 5 Direct materials 6 Direct labor 7 Variable manufacturing overhead 4.00 6.00 2.00

Alanco, Incl manufactures a variety of products and is currently maunfacturing all of its own component parts. 2 An outside supplier has offered to sell one of those components to Alanco. To evaluate this offer, the following 3 information has been gathered relating to the cost of producing the component internally: 4 5 Direct materials 6 Direct labor 7 Variable manufacturing overhead 4.00 6.00 2.00

Managerial Accounting: The Cornerstone of Business Decision-Making
Managerial Accounting: The Cornerstone of Business Decision-Making
7th Edition
ISBN:9781337115773
Author:Maryanne M. Mowen, Don R. Hansen, Dan L. Heitger
Publisher:Maryanne M. Mowen, Don R. Hansen, Dan L. Heitger
Chapter8: Tactical Decision-making And Relevant Analysis
Section: Chapter Questions
Problem 39E
See similar textbooks
icon
Related questions
Question

Alanco Inc. manufactures a veriety of products and is currently manufacturing all of its own component parts.

 

Please provide Excel formula for all answers

1 Alanco, Ind manufactures a variety of products and is currently maunfacturing all of its own component parts. 2 An outside supplier has offered to sell one of those components to Alanco. To evaluate this offer, the following 3 information has been gathered relating to the cost of producing the component internally: 4 5 Direct materials 6 Direct labor 7 Variable manufacturing overhead 8 Fixed manufacturing overhead, traceable* 9 Fixed manufacturing overhead, common but allocated 10 Total cost $ 4.00 6.00 2.00 5.00 8.00 25.00 11 12 Supplier price 21.00 13 14 Units used per year 12,000 15 16 *Fixed manufacturing overhead, traceable is composed of two items: 17 30% Depreciation of equipment (no resale value) Supervisor salary 18 70% 19 20 1. Assuming the company has no alternative use for the facilities now being used to produce the 21 component, complete the following analysis to determine if the outside supplier's offer should be accepted. 22 23 Per Unit Differential Cost 12,000 units 24 Make Buy Make Buy 25 26 Cost of purchasing 27 Direct materials 28 Direct labor 29 Variable manufacturing overhead 30 Fixed manufacturing overhead, traceable 31 Fixed manufacturing overhead, common 32 Total costs 33 34 Based on this analysis, write an if statement to determine if Alanco should make or buy the component. 35 36 Alanco should the component 37 38 39 40
Transcribed Image Text:1 Alanco, Ind manufactures a variety of products and is currently maunfacturing all of its own component parts. 2 An outside supplier has offered to sell one of those components to Alanco. To evaluate this offer, the following 3 information has been gathered relating to the cost of producing the component internally: 4 5 Direct materials 6 Direct labor 7 Variable manufacturing overhead 8 Fixed manufacturing overhead, traceable* 9 Fixed manufacturing overhead, common but allocated 10 Total cost $ 4.00 6.00 2.00 5.00 8.00 25.00 11 12 Supplier price 21.00 13 14 Units used per year 12,000 15 16 *Fixed manufacturing overhead, traceable is composed of two items: 17 30% Depreciation of equipment (no resale value) Supervisor salary 18 70% 19 20 1. Assuming the company has no alternative use for the facilities now being used to produce the 21 component, complete the following analysis to determine if the outside supplier's offer should be accepted. 22 23 Per Unit Differential Cost 12,000 units 24 Make Buy Make Buy 25 26 Cost of purchasing 27 Direct materials 28 Direct labor 29 Variable manufacturing overhead 30 Fixed manufacturing overhead, traceable 31 Fixed manufacturing overhead, common 32 Total costs 33 34 Based on this analysis, write an if statement to determine if Alanco should make or buy the component. 35 36 Alanco should the component 37 38 39 40
Expert Solution
trending now

Trending now

This is a popular solution!

steps

Step by step

Solved in 2 steps

SEE SOLUTIONCheck out a sample Q&A here
Blurred answer
Follow-up Questions
Read through expert solutions to related follow-up questions below.
Follow-up Question

What is the equation for Fixed MFG Over head, traceable? What is the equation for Fixed MFG Overhead, Common? 

also can you help with the IF Statement? 

 

33 34 Based on this analysis, write an if statement to determine if Alanco should make or buy the component. 35 36 37 38 Alanco should the component
Transcribed Image Text:33 34 Based on this analysis, write an if statement to determine if Alanco should make or buy the component. 35 36 37 38 Alanco should the component
Solution
Bartleby Expert
SEE SOLUTION
Knowledge Booster
Characteristics Of Insurance
Learn more about
Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, accounting and related others by exploring similar questions and additional content below.
Similar questions
  • SEE MORE QUESTIONS
Recommended textbooks for you
Managerial Accounting: The Cornerstone of Busines…
Managerial Accounting: The Cornerstone of Busines…
Accounting
ISBN:
9781337115773
Author:
Maryanne M. Mowen, Don R. Hansen, Dan L. Heitger
Publisher:
Cengage Learning
Principles of Accounting Volume 2
Principles of Accounting Volume 2
Accounting
ISBN:
9781947172609
Author:
OpenStax
Publisher:
OpenStax College
Cornerstones of Cost Management (Cornerstones Ser…
Cornerstones of Cost Management (Cornerstones Ser…
Accounting
ISBN:
9781305970663
Author:
Don R. Hansen, Maryanne M. Mowen
Publisher:
Cengage Learning
Survey of Accounting (Accounting I)
Survey of Accounting (Accounting I)
Accounting
ISBN:
9781305961883
Author:
Carl Warren
Publisher:
Cengage Learning
Managerial Accounting
Managerial Accounting
Accounting
ISBN:
9781337912020
Author:
Carl Warren, Ph.d. Cma William B. Tayler
Publisher:
South-Western College Pub
SEE MORE TEXTBOOKS