Alanco, Inc. manufactures a variety of products and is currently maunfacturing all of its own component parts. An outside supplier has offered to sell one of those components to Alanco. To evaluate this offer, the following information has been gathered relating to the cost of producing the component internally: Direct materials Direct labor Variable manufacturing overhead Fixed manufacturing overhead, traceable* Fixed manufacturing overhead, common but allocated Total cost Supplier price Units used per year * The fixed manufacturing overhead, traceable Depreciation of equipment (no resale value) Supervisor salary $4.00 6.00 2.00 5.00 8.00 $25.00 $21.00 12,000 30% 70%

FINANCIAL ACCOUNTING
10th Edition
ISBN:9781259964947
Author:Libby
Publisher:Libby
Chapter1: Financial Statements And Business Decisions
Section: Chapter Questions
Problem 1Q
icon
Related questions
icon
Concept explainers
Topic Video
Question

Please help me with the formulas to input to get the answers where the cells are yellow. Thank you!

Alanco, Inc. manufactures a variety of products and is currently maunfacturing all of its own component parts.
An outside supplier has offered to sell one of those components to Alanco. To evaluate this offer, the following information has been gathered relating to the
cost of producing the component internally:
Direct materials
Direct labor
Variable manufacturing overhead
Fixed manufacturing overhead, traceable*
Fixed manufacturing overhead, common but allocated
Total cost
Supplier price
Units used per year
* The fixed manufacturing overhead, traceable
Depreciation of equipment (no resale value)
Supervisor salary
$4.00
6.00
2.00
5.00
8.00
$25.00
$21.00
12,000
30%
70%
Transcribed Image Text:Alanco, Inc. manufactures a variety of products and is currently maunfacturing all of its own component parts. An outside supplier has offered to sell one of those components to Alanco. To evaluate this offer, the following information has been gathered relating to the cost of producing the component internally: Direct materials Direct labor Variable manufacturing overhead Fixed manufacturing overhead, traceable* Fixed manufacturing overhead, common but allocated Total cost Supplier price Units used per year * The fixed manufacturing overhead, traceable Depreciation of equipment (no resale value) Supervisor salary $4.00 6.00 2.00 5.00 8.00 $25.00 $21.00 12,000 30% 70%
Required:
1. Assuming the company has no alternative use for the facilities now being used to produce the component,
complete the following analysis to determine if the outside supplier's offer should be accepted.
(Use cells A6 to B19 from the given information to complete this question. Blank or zero value answers should be entered as =0.)
Cost of purchasing
Direct materials
Direct labor
Variable manufacturing overhead
Fixed manufacturing overhead, traceable
Fixed manufacturing overhead, common
Total costs
Per Unit Differential Cost
Make
Buy
2. Based on this analysis, determine if Alanco should make or buy the component.
Alanco should
the component.
12,000 units
Make
Buy
Transcribed Image Text:Required: 1. Assuming the company has no alternative use for the facilities now being used to produce the component, complete the following analysis to determine if the outside supplier's offer should be accepted. (Use cells A6 to B19 from the given information to complete this question. Blank or zero value answers should be entered as =0.) Cost of purchasing Direct materials Direct labor Variable manufacturing overhead Fixed manufacturing overhead, traceable Fixed manufacturing overhead, common Total costs Per Unit Differential Cost Make Buy 2. Based on this analysis, determine if Alanco should make or buy the component. Alanco should the component. 12,000 units Make Buy
Expert Solution
trending now

Trending now

This is a popular solution!

steps

Step by step

Solved in 3 steps with 2 images

Blurred answer
Knowledge Booster
Costing Systems
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
FINANCIAL ACCOUNTING
FINANCIAL ACCOUNTING
Accounting
ISBN:
9781259964947
Author:
Libby
Publisher:
MCG
Accounting
Accounting
Accounting
ISBN:
9781337272094
Author:
WARREN, Carl S., Reeve, James M., Duchac, Jonathan E.
Publisher:
Cengage Learning,
Accounting Information Systems
Accounting Information Systems
Accounting
ISBN:
9781337619202
Author:
Hall, James A.
Publisher:
Cengage Learning,
Horngren's Cost Accounting: A Managerial Emphasis…
Horngren's Cost Accounting: A Managerial Emphasis…
Accounting
ISBN:
9780134475585
Author:
Srikant M. Datar, Madhav V. Rajan
Publisher:
PEARSON
Intermediate Accounting
Intermediate Accounting
Accounting
ISBN:
9781259722660
Author:
J. David Spiceland, Mark W. Nelson, Wayne M Thomas
Publisher:
McGraw-Hill Education
Financial and Managerial Accounting
Financial and Managerial Accounting
Accounting
ISBN:
9781259726705
Author:
John J Wild, Ken W. Shaw, Barbara Chiappetta Fundamental Accounting Principles
Publisher:
McGraw-Hill Education