Piedmont Fasteners Corporation makes three different clothing fasteners in its manufacturing facility in North Carolina. All three products are sold in highly competitive markets, so the company is unable to raise prices without losing an unacceptable number of customers. Data from the most recent period concerning these products appear below: Velcro Metal Nylon 203,600 1.50 $ 0.70 $ Annual sales volume 101,800 407,200 Unit selling price Variable expense per unit Contribution margin per unit 1.65 $ 1.25 $ 0.40 $ 0.85 0.25 0.80 $ 0.60 Total fixed expenses are $407,200 per period. Of the total fixed expenses, $20,000 could be avoided if the Velcro product is dropped, $80,000 if the Metal product is dropped, and $60,000 if the Nylon product is dropped. The remaining fixed expenses of $247,200 consist of common fixed expenses such as administrative salaries and rent on the factory building that could be avoided only by going out of business entirely. The company's managers would like to compute the break-even point in dollar sales for the company as a whole, and the break-even point in unit sales for each product. They are considering two methods for computing each product's break-even point unit sales: Method #1. Include each product's traceable fixed costs and an allocated share of the common fixed costs in the numerator of each break-even calculation. The common fixed costs would be allocated to the three products using sales dollars as the allocation base. Method #2. Only include each product's traceable fixed costs in the numerator of each break-even calculation. Required: 1. Using data from the most recent period, prepare a contribution format segmented income statement. 2. What is the company's over-all break-even point in dollar sales? 3a. Calculate the break-even point in unit sales for each product using method 1. 3b. If the company sells exactly the break-even quantity of each product, what will be the overall profit for the company using method 1? 4a. Calculate the break-even point in unit sales for each product using method 2. 4b. If the company sells exactly the break-even quantity of each product, what will be the overall profit for the company using method 2? 5. Which method should the company use to calculate each product's break-even point in unit sales?
Piedmont Fasteners Corporation makes three different clothing fasteners in its manufacturing facility in North Carolina. All three products are sold in highly competitive markets, so the company is unable to raise prices without losing an unacceptable number of customers. Data from the most recent period concerning these products appear below: Velcro Metal Nylon 203,600 1.50 $ 0.70 $ Annual sales volume 101,800 407,200 Unit selling price Variable expense per unit Contribution margin per unit 1.65 $ 1.25 $ 0.40 $ 0.85 0.25 0.80 $ 0.60 Total fixed expenses are $407,200 per period. Of the total fixed expenses, $20,000 could be avoided if the Velcro product is dropped, $80,000 if the Metal product is dropped, and $60,000 if the Nylon product is dropped. The remaining fixed expenses of $247,200 consist of common fixed expenses such as administrative salaries and rent on the factory building that could be avoided only by going out of business entirely. The company's managers would like to compute the break-even point in dollar sales for the company as a whole, and the break-even point in unit sales for each product. They are considering two methods for computing each product's break-even point unit sales: Method #1. Include each product's traceable fixed costs and an allocated share of the common fixed costs in the numerator of each break-even calculation. The common fixed costs would be allocated to the three products using sales dollars as the allocation base. Method #2. Only include each product's traceable fixed costs in the numerator of each break-even calculation. Required: 1. Using data from the most recent period, prepare a contribution format segmented income statement. 2. What is the company's over-all break-even point in dollar sales? 3a. Calculate the break-even point in unit sales for each product using method 1. 3b. If the company sells exactly the break-even quantity of each product, what will be the overall profit for the company using method 1? 4a. Calculate the break-even point in unit sales for each product using method 2. 4b. If the company sells exactly the break-even quantity of each product, what will be the overall profit for the company using method 2? 5. Which method should the company use to calculate each product's break-even point in unit sales?
Practical Management Science
6th Edition
ISBN:9781337406659
Author:WINSTON, Wayne L.
Publisher:WINSTON, Wayne L.
Chapter2: Introduction To Spreadsheet Modeling
Section: Chapter Questions
Problem 20P: Julie James is opening a lemonade stand. She believes the fixed cost per week of running the stand...
Related questions
Question
Need help on these questions
Expert Solution
This question has been solved!
Explore an expertly crafted, step-by-step solution for a thorough understanding of key concepts.
This is a popular solution!
Trending now
This is a popular solution!
Step by step
Solved in 2 steps with 2 images
Knowledge Booster
Learn more about
Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, operations-management and related others by exploring similar questions and additional content below.Recommended textbooks for you
Practical Management Science
Operations Management
ISBN:
9781337406659
Author:
WINSTON, Wayne L.
Publisher:
Cengage,
Operations Management
Operations Management
ISBN:
9781259667473
Author:
William J Stevenson
Publisher:
McGraw-Hill Education
Operations and Supply Chain Management (Mcgraw-hi…
Operations Management
ISBN:
9781259666100
Author:
F. Robert Jacobs, Richard B Chase
Publisher:
McGraw-Hill Education
Practical Management Science
Operations Management
ISBN:
9781337406659
Author:
WINSTON, Wayne L.
Publisher:
Cengage,
Operations Management
Operations Management
ISBN:
9781259667473
Author:
William J Stevenson
Publisher:
McGraw-Hill Education
Operations and Supply Chain Management (Mcgraw-hi…
Operations Management
ISBN:
9781259666100
Author:
F. Robert Jacobs, Richard B Chase
Publisher:
McGraw-Hill Education
Purchasing and Supply Chain Management
Operations Management
ISBN:
9781285869681
Author:
Robert M. Monczka, Robert B. Handfield, Larry C. Giunipero, James L. Patterson
Publisher:
Cengage Learning
Production and Operations Analysis, Seventh Editi…
Operations Management
ISBN:
9781478623069
Author:
Steven Nahmias, Tava Lennon Olsen
Publisher:
Waveland Press, Inc.