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%

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%

Name: Please help me with the formulas to input to get the answers where the
Uploaded: 2024-03-20T06:32:49.000Z
Channel: Bartleby
Description: 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

FINANCIAL ACCOUNTING

10th Edition

ISBN:9781259964947

Author:Libby

Publisher:Libby

Chapter1: Financial Statements And Business Decisions

Section: Chapter Questions

Problem 1Q

See similar textbooks

Similar questions

Apply the Concepts, Cost Reporting Medco Inc., a manufacturing firm, has four activities: purchasing materials, molding, inspecting molds, and grinding imperfect molds. Purchasing materials and molding are necessary activities; inspection and grinding are unnecessary. SQ provides the value-added quantity for each activity; AQ is the actual activity output. The following data pertain to the four activities for the year ending (actual price per unit of the activity driver is assumed to be equal to the standard price): Activity Activity Driver Purchasing Purchasing hours Molding Inspecting Inspection hours Molding hours Grinding. Number of units Required: SQ AQ SP 28,000 34,000 $20 42,000 47,600 121 0 8,400 15 0 6,000 6 1. Prepare a cost report for the year 1 ended that shows value-added costs, non-value-added costs, and total costs for each activity by completing the following table: Value-and Non-Value-Added Cost Report for the Year 1 Ended Activity Value-Added Costs Non-Value-Added…
Merone Company allocates materials handling cost to the company's two products using the below data: Modular Prefab Homes Barns Total expected units produced Total expected material moves Expected direct labor-hours per unit 6,700 670 9,700 270 870 370 The total materials handling cost for the year is expected to be $235,450. If the materials handling cost is allocated on the basis of material moves, the total materials handling cost allocated to the modular homes is closest to: (Round your intermediate calculations to 2 decimal places.) Multiple Choice
o Company has traditionally manufactured a number of different standard machine parts. It is now exploring an outsourcing decision r several of the parts that it currently produces. Cost information for one such machine part is given below: Variable cost/unit Fixed manufacturing costs (total) Allocated corporate overhead Unit product cost (based on 500 units) $ 31.50 5,440.00 6,760.00 $ 55.90 fty percent of the fixed manufacturing costs are directly traceable to this specific machine part and therefore avoidable. An outside upplier will sell the part at a price of $44 per unit if 500 units are purchased. equired: repare an analysis whether We Make should continue to manufacture this machine part or whether it should purchase it from the utside supplier. (Negative amounts should be indicated by a minus sign. Round "Per Unit" to 2 decimal places.) Purchase ariable cost ixed manufacturing overhead Common costs otal costs hould the company make or buy? O Make ○ Buy 500 Units Per Unit Make…
Merone Company allocates materials handling cost to the company's two products using the below data: Modular Homes 5,700 570 770 Prefab Barns 8,700 170 270 Total expected units produced Total expected material moves Expected direct labor-hours per unit The total materials handling cost for the year is expected to be $370,590. If the materials handling cost is allocated on the basis of material moves, the total materials handling cost allocated to the modular homes is closest to: (Round your intermediate calculations to 2 decimal places.)
Merone Company allocates materials handling cost to the company's two products using the below data: Modular Prefab Homes 6,200 620 820 Barns Total expected units produced Total expected material moves Expected direct labor-hours per unit 9,200 220 320 The total materials handling cost for the year is expected to be $321,120. If the materials handling cost is allocated on the basis of material moves, the total materials handling cost allocated to the modular homes is closest to: (Round your Intermedlate calculatlons to 2 declmal ploces.) Multple Cholce $237.019.80 S230,981.05 S164,265.00 S220.770.00 < Prev 9 of 10 92 F AQI 61 A E e here to search DELL
The controller of Ferrence Company estimates the amount of materials handling overhead cost that should be allocated to the company's two products using the data that are given below: The total materials handling cost for the year is expected to be $16,486.40. If the materials handling cost is allocated on the basis of material moves, how much of the total materials handling cost should be allocated to the specialty windows? (Round off your answer to the nearest whole dollar.) Question 12 options: $3,266 $9,274 $8,243 $6,595
Troy Engines, Limited, manufactures a variety of engines for use in heavy equipment. The company has always produced all of the parts for its engines, including the carburetors. An outside supplier offered to sell one type of carburetor to Troy Engines, Limited, for a cost of $30 per unit. To evaluate this offer, Troy Engines, Limited, summarized the cost of producing the carburetor internally as follows: Direct materials Direct labor Variable manufacturing overhead Fixed manufacturing overhead, traceable Fixed manufacturing overhead, allocated Total cost Per Unit $ 12 8 2 9* Required 1 Required 2 Required 3 Required 4 12 $43 *One-third supervisory salaries; two-thirds depreciation of special equipment (no resale value). Required: 1. If the company has no alternative use for the facilities being used to produce the carburetors, what would be the financial advantage (disadvantage) of buying 12,000 carburetors from the outside supplier? 2. Should the outside supplier's offer be accepted?…
Deep Sea manufactures flotation vests in Charleston, South Carolina. Deep Sea's contribution margin income statement for the month ended March 31, 2024, contains the following data: (Click the icon to view the cost information.) Read the requirements. Requirement 1. Identify each cost in the income statement as either relevant or irrelevant to Deep Sea's decision. Variable Manufacturing Costs Variable Selling and Administrative Costs Fixed Manufacturing Costs Fixed Selling and Administrative Costs Requirement 2. Prepare a differential analysis to determine whether Deep Sea should accept this special sales order. (Enter decreases to revenue or increases to costs with a parentheses or minus sign.) Decision: in operating income ▼ Suppose Overboard wishes to buy 4,000 vests from Deep Sea. Deep Sea will not incur any variable selling and administrative expenses on the special order. The Deep Sea plant has enough unused capacity to manufacture the additional vests. Overboard has offered $7…
Troy Engines, Limited, manufactures a variety of engines for use in heavy equipment. The company has always produced all of the parts for its engines, including the carburetors. An outside supplier offered to sell one type of carburetor to Troy Engines, Limited, for a cost of $30 per unit. To evaluate this offer, Troy Engines, Limited, summarized the cost of producing the carburetor internally as follows: Direct materials Direct labor Variable manufacturing overhead Fixed manufacturing overhead, traceable Fixed manufacturing overhead, allocated Total cost Per 19,000 Units Unit Per Year $ 12 $ 228,000 10 3 190,000 57,000 3* 6 57,000 114,000 $ 34 $ 646,000 "One-third supervisory salaries; two-thirds depreciation of special equipment (no resale value). Required: 1. If the company has no alternative use for the facilities being used to produce the carburetors, what would be the financial advantage (disadvantage) of buying 19,000 carburetors from the outside supplier? 2. Should the outside…
The make or buy decision Lakeview Engine Inc. produces engines for the watercraft industry. An outside manufacturer has offered to supply several component parts used in the engine assemblies, which are currently being produced by Lakeview. The supplier will charge Lakeview $270 per engine for the set of parts. Lakeview's current costs for those part sets are direct materials, $160; direct labor, $80; and manufacturing overhead applied at 100% of direct labor. Variable manufacturing overhead is considered to be 20% of the total, and fixed overhead will not change if the part sets are acquired from the outside supplier. bd 1200 Required: Should Lakeview Engine continue to make the part sets or accept the offer to purchase them for $270? Ovin
Sardi Inc. is considering whether to continue to make a component or to buy it from an outside supplier. The company uses 13,100 of the components each year. The unit product cost of the component according to the company's cost accounting system is given as follows: Direct materials $ 8.90 Direct labor 5.90 Variable manufacturing overhead 1.70 Fixed manufacturing overhead 3.70 Unit product cost $ 20.20 Assume that direct labor is a variable cost. Of the fixed manufacturing overhead, 20% is avoidable if the component were bought from the outside supplier. In addition, making the component uses 2 minutes on the machine that is the company's current constraint. If the component were bought, time would be freed up for use on another product that requires 4 minutes on this machine and that has a contribution margin of $5.30 per unit. When deciding whether to make or buy the component, what cost of making the component should be compared to the…
Z Inc. manufactures a component Zeta which it uses in production of its main product. The manufacturing costs per unit of Zeta are as follows: Item Cost per unit Direct material Direct labor Variable manufacturing overhead Fixed manufacturing overhead 3.50 4.50 2.50 2.00 Annual requirement of Zeta is 8,000 units. Fixed manufacturing overhead is allocated to Zeta based on machine-hours used in its production and cannot be avoided if production of Zeta is stopped. An outside supplier has offered Z Inc. to supply 8,000 units at a total cost of $96,000. If Z Inc. purchases the component Zeta from the outside supplier, how will it affect its operating income? a. Operating income will increase by $4,000 b. Operating income will decrease by $4,000 c. Operating income will increase by $6,000 d. Operating income will decrease by $12,000