Optimizing Profit: Calculating the Required Sales Volume for Walt’s Woodwork Company to Achieve a $500,000 Pre-tax Profit

QUESTION

Walt’s Woodwork Company makes and sells wooden shelves.

Walt’s carpenters make the shelves in the company’s rented building. Walt has a separate
office at another location that also includes a showroom where customers can view sample shelves
and ask questions of salespeople. The company sells all the shelves it produces each year and keeps
no inventories. The following information pertains to Walt’s Woodwork Company for the past year:

(a) Units produced and sold 50,000
(b) Sales price per unit $70
(c) Carpenter labor to make shelves $600,000
(d) Wood to make the shelves $450,000
(e) Sales staff salaries $80,000
(f) Office and showroom rental expenses $150,000
(g) Depreciation on carpentry equipment $50,000
(h) Advertising $200,000
(i) Sales commissions based on number of units sold $180,000
(j) Miscellaneous fixed manufacturing overhead $150,000
(k) Rent for the building where the shelves are made $300,000
(l) Miscellaneous variable manufacturing overhead $350,000
(m) Depreciation for office equipment $10,000

Make appropriate assumptions about cost behavior and assume that direct labor costs vary
directly with the number of units produced.

How many units must the company sell in order to earn a pretax profit of $500,000?
Round up to the nearest unit.

ANSWER

Optimizing Profit: Calculating the Required Sales Volume for Walt’s Woodwork Company to Achieve a $500,000 Pre-tax Profit

To determine how many units Walt’s Woodwork Company must sell in order to earn a pre-tax profit of $500,000, we need to perform a break-even analysis. This analysis will help us find the level of sales needed to cover all expenses and achieve the desired profit.

First, let’s categorize the expenses into fixed and variable costs:

Fixed Costs

Carpenter labor: $600,000

Office and showroom rental expenses: $150,000

Depreciation on carpentry equipment: $50,000

Advertising: $200,000

Miscellaneous fixed manufacturing overhead: $150,000

Rent for the building where the shelves are made: $300,000

Depreciation for office equipment: $10,000

Variable Costs

Wood to make the shelves: $450,000

Sales staff salaries: $80,000

Sales commissions based on the number of units sold: $180,000

Miscellaneous variable manufacturing overhead: $350,000

Now, let’s calculate the contribution margin per unit. The contribution margin is the difference between the sales price per unit and the variable cost per unit.

Contribution Margin per Unit = Sales Price per Unit – Variable Cost per Unit Contribution Margin per Unit = $70 – (($450,000 + $80,000 + $180,000 + $350,000) / 50,000 units) Contribution Margin per Unit = $70 – ($1,060,000 / 50,000 units) Contribution Margin per Unit = $70 – $21.20 per unit Contribution Margin per Unit = $48.80 per unit

Now, we can use the contribution margin to calculate the number of units needed to earn a pre-tax profit of $500,000. The formula for this is:

Number of Units = (Fixed Costs + Desired Profit) / Contribution Margin per Unit

Number of Units = ($600,000 + $150,000 + $50,000 + $200,000 + $150,000 + $300,000 + $10,000 + $500,000) / $48.80 per unit

Number of Units = $1,860,000 / $48.80 per unit

Number of Units ≈ 38,180 units (rounded up to the nearest unit)

So, Walt’s Woodwork Company must sell approximately 38,180 units to earn a pre-tax profit of $500,000.

Calculate the price of your order

550 words
We'll send you the first draft for approval by September 11, 2018 at 10:52 AM
Total price:
$26
The price is based on these factors:
Academic level
Number of pages
Urgency
Basic features
  • Free title page and bibliography
  • Unlimited revisions
  • Plagiarism-free guarantee
  • Money-back guarantee
  • 24/7 Customer support
On-demand options
  • Tutor’s samples
  • Part-by-part delivery
  • Overnight delivery
  • Attractive discounts
  • Expert Proofreading
Paper format
  • 275 words per page
  • 12 pt Arial/Times New Roman
  • Double line spacing
  • Any citation style (APA, MLA, Chicago/Turabian, Harvard)

Unique Features

As a renowned provider of the best writing services, we have selected unique features which we offer to our customers as their guarantees that will make your user experience stress-free.

Money-Back Guarantee

Unlike other companies, our money-back guarantee ensures the safety of our customers' money. For whatever reason, the customer may request a refund; our support team assesses the ground on which the refund is requested and processes it instantly. However, our customers are lucky as they have the least chances to experience this as we are always prepared to serve you with the best.

Zero-Plagiarism Guarantee

Plagiarism is the worst academic offense that is highly punishable by all educational institutions. It's for this reason that Peachy Tutors does not condone any plagiarism. We use advanced plagiarism detection software that ensures there are no chances of similarity on your papers.

Free-Revision Policy

Sometimes your professor may be a little bit stubborn and needs some changes made on your paper, or you might need some customization done. All at your service, we will work on your revision till you are satisfied with the quality of work. All for Free!

Privacy And Confidentiality

We take our client's confidentiality as our highest priority; thus, we never share our client's information with third parties. Our company uses the standard encryption technology to store data and only uses trusted payment gateways.

High Quality Papers

Anytime you order your paper with us, be assured of the paper quality. Our tutors are highly skilled in researching and writing quality content that is relevant to the paper instructions and presented professionally. This makes us the best in the industry as our tutors can handle any type of paper despite its complexity.