0% found this document useful (0 votes)
555 views5 pages

Foxwood Company 2017 Financial Overview

The document provides cost and revenue information for Braided Rugs, Inc. to produce area rugs in three different countries: Portugal, Italy, and Thailand. It calculates the contribution margin, break-even point in units, projected revenues, and operating income for each country. Italy has the lowest annual fixed costs of $5 million and requires the fewest units, 29,412, to break even, making it the best location. Thailand has the highest fixed costs of $9 million and needs to produce the most units, 51,429, to break even, making it the worst location.

Uploaded by

烈仙雪
Copyright
© All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as DOCX, PDF, TXT or read online on Scribd
0% found this document useful (0 votes)
555 views5 pages

Foxwood Company 2017 Financial Overview

The document provides cost and revenue information for Braided Rugs, Inc. to produce area rugs in three different countries: Portugal, Italy, and Thailand. It calculates the contribution margin, break-even point in units, projected revenues, and operating income for each country. Italy has the lowest annual fixed costs of $5 million and requires the fewest units, 29,412, to break even, making it the best location. Thailand has the highest fixed costs of $9 million and needs to produce the most units, 51,429, to break even, making it the worst location.

Uploaded by

烈仙雪
Copyright
© All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as DOCX, PDF, TXT or read online on Scribd
  • Foxwood Company Data Overview
  • Foxwood Company Financial Statements
  • Zahner Corporation Financial Analysis
  • Break-even Analysis

Foxwood Company data for 2017:

Sandpaper $ 2,000
Materials-handling costs 70,000
Lubricants and coolants 5,000
Miscellaneous indirect manufacturing labor 40,000
Direct manufacturing labor 300,000
Direct materials inventory, Jan. 1 , 2017 40,000
Direct materials inventory, Dec. 31, 2017 50,000
Finished goods inventory, Jan. 1, 2017 100,000
Finished goods inventory, Dec. 31, 2017 150,000
Work-in-process inventory, Jan. 1, 2017 10,000
Work-in-process inventory, Dec. 31,
2017 14,000
Plant-leasing costs 54,000
Depreciation - plant equipment 36,000
Property taxes on plant equipment 4,000
Fire insurance on plant equipment 3,000
Direct materials purchased 460,000
Revenues 1,360,000
Marketing promotions 60,000
Marketing salaries 100,000
Distribution costs 70,000
Customer-service costs 100,000
Schedule of Cost of Goods Manufactured
For the year Ended December 31, 2017

Direct materials
Beginning inventory, January 1, 2017 $ 40,000 variable costs
Purchases of direct materials 460,000
Costs of direct materials available for use 500,000
Ending inventory, December 31, 2017 50,000
Direct materials used 450,000
Direct manufacturing labor 300,000
Indirect manufacturing costs

Sandpaper 2,000
Materials-handling costs 70,000
Lubricants and coolants 5,000
Miscellaneous indirect manufacturing labor 40,000
Plant-leasing costs 54,000 fixed costs
Depreciation - plant equipment 36,000
Property taxes on plant equipment 4,000

Fire insurance on plant equipment 3,000 214,000

Manufacturing costs incurred during 2017 964,000


Beginning work-in-process inventory, January 1, 2017 10,000
Total manufacturing costs to account for 974,000
Ending work-in-process inventory, December 31, 2017 14,000
Costs of goods manufactured (to income statement) 960,000

Fixwood Company
Income Statement
For the year Ended December 31, 2017

Revenues 1,360,000
Cost of goods sold
Beginning finished goods inventory, January 1, 2017 100,000
Cost of goods manufactured (see above) 960,000
Cost of good available for sale 1,060,000
Ending finished good inventory, December 31, 2017 150,000 910,000
Gross margin (gross profit) 450,000
Operating costs
Marketing promotions 60,000
Marketing salaries 100,000
Distribution costs 70,000
Customer-service costs 100,000 330,000
Operating income 120,000
P3-48
1 Zahner Corporation
Income Statement
For the Year Ended December 31, 2017
Using Sales Agents Using Own Sales Force

Revenues 35,200,000 35,200,000


COGS
Variable 13,375,000 13,375,000
Fixed 4,125,000 17,500,000 4,125,000 17,500,000

Gross margin 17,700,000 17,700,000


Marketing costs

Commissions 7,040,000 3,520,000

Fixed costs 4,025,000 11,065,000 7,545,000 11,065,000

Operating income 6,635,000 6,635,000

Contribution margin 14,785,000 18,305,000

CM % 42% 52%

BEP Revenues 19,403,449 22,441,082

DOL 2.23 2.76

The calculations indicate that at sales of $35,200,000, a percentage change in sales and
2 contribution margin will result in 2.23 times that percentage change in operating income if
Zahner continues to use sales agents and 2.76 times that percentage change in operating income
if Zahner employs its own sales staff. The higher contribution margin per dollar of sales and
higher fixed costs gives Zahner more operating leverage, that is, greater benefits (increases in
operating income) if revenues increase but greater risks (decreases in operating income) if
revenues decrease. Zahner also needs to consider the skill levels and incentives under the two
alternatives. Sales agents have more incentive compensation and, hence, may be more motivated
to increase sales. On the other hand, Zahner’s own sales force may be more knowledgeable and
skilled in selling the company’s products. That is, the sales volume itself will be affected by who
sells and by the nature of the compensation plan.
COGS
3 Revenue = X Variable 38%

X - (.38X + .15X) - (4,125,000 + 7,545,000) = 6,635,000

.47X = 6,635,000 + 11,570,000

.47X = $18,205,000
X = $38,734,043
E3-31 Braided Rugs, Inc.
Variable Manufacturing Cost Variable Marketing & Distribution Cost Contribution Margin BEP in Projected
Country Sales Price to Retail Outlets Annual Fixed Costs per Area Rug per Area Rug Per Rug BEP in units revenues Units OI
Portugal $ 250.00 $ 7,500,000 $ 45.00 $ 10.00 $ 195.00 38,462 $ 9,615,385 80,000 $ 8,100,000
Italy 250.00 5,000,000 65.00 15.00 $ 170.00 29,412 $ 7,352,941 80,000 $ 8,600,000
Thailand 250.00 9,000,000 55.00 20.00 $ 175.00 51,429 $ 12,857,143 80,000 $ 5,000,000
Italy is the best location because of low fixed costs. Thailand is the worst; it requires at least 51,429 rugs to be produced to break even.

Common questions

Powered by AI

Zahner Corporation's decision to use either sales agents or an in-house sales force involves weighing several factors. Financially, using an in-house sales force offers a higher contribution margin (52% vs. 42%) and greater operating leverage, which can lead to more significant increases in operating income as sales increase, albeit with higher fixed costs. Non-financially, factors such as the motivation and knowledge of the sales representatives play a role. Sales agents, who earn commissions, might be more incentivized to increase sales, but the company's own sales force may possess better product knowledge and selling skills. Therefore, Zahner must balance the financial benefits of higher margins and operating leverage against potential differences in sales effectiveness due to skill and incentive structures .

Zahner Corporation's contribution margin when using sales agents is 42%, compared to 52% when using its own sales force. This higher contribution margin when using its own sales force results in greater operating leverage, as indicated by a Degree of Operating Leverage (DOL) of 2.76 compared to 2.23 with sales agents. This means there is a greater percentage increase in operating income for a given percentage increase in sales when using its own sales force, but also a greater risk of decrease in operating income when sales decline .

The choice between using sales agents and an in-house sales team significantly impacts Zahner Corporation's fixed costs and breakeven point. Sales agents incur lower fixed costs but higher variable costs through commissions, which lowers the contribution margin. Conversely, an in-house sales team results in higher fixed costs but a higher contribution margin due to lower variable costs. This difference in fixed costs and contribution margin influences Zahner's breakeven revenues and operational risk, offering greater potential profitability but also greater financial risk if sales decline with the in-house team. The decision therefore requires careful balancing of potential revenue growth against the financial stability provided by lower fixed costs with sales agents .

Foxwood Company reported an operating income of $120,000 for 2017, which is influenced by its gross margin of $450,000 after accounting for cost of goods sold at $910,000. The main key cost components affecting this profitability include marketing promotions ($60,000), marketing salaries ($100,000), distribution costs ($70,000), and customer-service costs ($100,000), totaling $330,000. The company's ability to generate a gross margin and manage operating costs through strategic cost control are crucial for maintaining positive operating income .

In Zahner Corporation's sales strategy, variable marketing costs, such as commissions (7,040,000 using sales agents), directly relate to sales volumes, affecting the contribution margin but keeping fixed costs relatively low. Using an in-house sales team shifts expenses to fixed marketing costs ($7,545,000), thereby increasing the break-even point due to higher fixed expenditures. This distinction shapes financial outcomes by determining flexibility and scalability in response to changing sales volumes, with higher fixed costs carrying increased risk and reward potential due to their impact on total operating costs and leverage .

Italy is considered the best location for Braided Rugs, Inc. due to its lower fixed costs, requiring just 29,412 units to break even, compared to 38,462 in Portugal and 51,429 in Thailand. Lower fixed costs lead to a more financially stable and less risky operation since fewer units need to be produced and sold to cover the costs. This makes operational sustainability more attainable compared to Thailand, which has the highest breakeven point due to higher variable costs and fixed costs .

Thailand has the highest breakeven point for Braided Rugs, Inc., needing 51,429 units to be sold to cover its costs, as opposed to just 29,412 units in Italy. This high breakeven point suggests a higher operational risk, requiring more sales to achieve profitability. Despite being a potentially larger market given the lower variable costs, Thailand's high breakeven threshold due to greater fixed costs makes it less financially viable compared to Italy. Thus, the financial success potential in Thailand is hampered by requiring a significant volume of sales for profitability, positioning it as less appealing compared to its peers .

Foxwood Company incurs various direct manufacturing costs, such as direct materials used ($450,000) and direct manufacturing labor ($300,000), which directly affect the cost of goods manufactured. Indirect manufacturing costs total $214,000, including costs like materials handling, plant leasing, depreciation, and other equipment-related expenses. These indirect costs contribute to the total manufacturing costs and impact operational efficiency, affecting gross margins by influencing the total cost of goods sold alongside direct costs .

Foxwood Company's gross margin for 2017 is derived from revenues of $1,360,000 and a cost of goods sold (COGS) of $910,000, resulting in a gross margin of $450,000. The COGS includes the beginning finished goods inventory of $100,000, cost of goods manufactured at $960,000, and ends with an adjusted COGS after accounting for ending finished goods inventory of $150,000 .

To enhance future profitability, Foxwood Company should prioritize improving its gross margin by optimizing the cost of goods sold, potentially through more efficient manufacturing processes or better cost management of direct materials and labor. Furthermore, reducing operating costs, including marketing, distribution, and customer service expenses, would enhance operating income. Monitoring and improving inventory management to minimize carrying costs and optimizing the supply chain for manufacturing efficiency are crucial financial metrics for enhancing profitability .

Foxwood Company data for 2017: 
 
 
 
 
 
 
 
 
Sandpaper 
 
 
 
 
$        2,000  
Materials-handling costs 
 
 
70,000 
Lub
Schedule of Cost of Goods Manufactured 
 
 
 
 
 
  For the year Ended December 31, 2017 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
Dir
P3-48 
 
 
 
 
 
 
1 
 
Zahner Corporation 
 
 
 
 
 
   Income Statement 
 
 
 
 
               For the Year Ended December
E3-31
Braided Rugs, Inc. 
Variable Manufacturing Cost Variable Marketing & Distribution Cost Contribution Margin 
BEP in 
P

You might also like