Evergreen Fertilizer Company produces fertilizer. The company's fixed monthly cost is $25,000.00, and its variable cost per pound of fertilizer is $0.15. Evergreen sells the fertilizer for $0.40 per pound. a) Determine the break-even volume for the company. What is the Contribution Margin? b) If Evergreen Fertilizer Companychanges the price of its fertilizer from $0.40 per pound to $0.60 per pound. What effect will the change have on the break-even volume. What is the Contribution Margin? c) Using the price of $0.60 per pounds, if Evergreen Fertilizer Companyc hanges its production process to add a weed killer to the fertilizer in order to increase sales, the variable cost per pound will increase from $0.15 to $0.22. What effect will this change have on the break-even volume.
Evergreen Fertilizer Company produces fertilizer. The company's fixed monthly cost is $25,000.00, and its variable cost per pound of fertilizer is $0.15. Evergreen sells the fertilizer for $0.40 per pound. a) Determine the break-even volume for the company. What is the Contribution Margin? b) If Evergreen Fertilizer Companychanges the price of its fertilizer from $0.40 per pound to $0.60 per pound. What effect will the change have on the break-even volume. What is the Contribution Margin? c) Using the price of $0.60 per pounds, if Evergreen Fertilizer Companyc hanges its production process to add a weed killer to the fertilizer in order to increase sales, the variable cost per pound will increase from $0.15 to $0.22. What effect will this change have on the break-even volume.
Cornerstones of Cost Management (Cornerstones Series)
4th Edition
ISBN:9781305970663
Author:Don R. Hansen, Maryanne M. Mowen
Publisher:Don R. Hansen, Maryanne M. Mowen
Chapter16: Cost-volume-profit Analysis
Section: Chapter Questions
Problem 11E
Related questions
Question
Could you please help me solve this on excel using the excel formulas?

Transcribed Image Text:Fomula:
0onat is the Conthbution Margin?
d)
New Fixed cost =
New Variable cost =
New Price =
V =
Ibs.
Fomula:
Prob 2
Instructions
Prob 1
Prob 2
e: 1 of 1
MacBook Pro

Transcribed Image Text:Evergreen Fertilizer Company produces fertilizer. The company's fixed monthly cost is $25,000.00, and its variable cost
per pound of fertilizer is $0.15. Evergreen sells the fertilizer for $0.40 per pound.
4
a) Determine the break-even volume for the company. What is the Contribution Margin?
6
b) If Evergreen Fertilizer Companychanges the price of its fertilizer from $0.40 per pound to $0.60 per pound. What effect
will the change have on the break-even volume. What is the Contribution Margin?
7
8
c) Using the price of $0.60 per pounds, if Evergreen Fertilizer Companyc hanges its production process to add a weed
killer to the fertilizer in order to increase sales, the variable cost per pound will increase from $0.15 to $0.22. What effect
will this change have on the break-even volume.
10
11
12
13
d) If Evergreen Fertilizer Company increases its advertising expenditures by $14,000 per year and using variable cost of
$0.22 and price of $0.60, what effect will the increase have on the break-even volume.
14
15
16
17
18
19
20
a)
Fixed Cost
21
22
Variable cost
23
Formula box type in the formula in words that you used
24
Price =
to calculate the answer.
25
26
V =
Ibs. per month
Formula:
27
28
What is the Contribution Margin?
Fomula:
29
30
b)
New Price =
31
- 32
33
V =
Ibs. per month
Fomula:
34
35
What is the Contribution Margin?
36
Fomula:
37
38
39
c)
New Variable cost =
40
V =
41
Ibs.
Fomula:
42
What is the Contribution Margin?
43
Fomula:
Instructions
Prob 1
Prob 2
Page: 1 of 1
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 3 steps

Knowledge Booster
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.Recommended textbooks for you

Cornerstones of Cost Management (Cornerstones Ser…
Accounting
ISBN:
9781305970663
Author:
Don R. Hansen, Maryanne M. Mowen
Publisher:
Cengage Learning
Principles of Accounting Volume 2
Accounting
ISBN:
9781947172609
Author:
OpenStax
Publisher:
OpenStax College

Cornerstones of Cost Management (Cornerstones Ser…
Accounting
ISBN:
9781305970663
Author:
Don R. Hansen, Maryanne M. Mowen
Publisher:
Cengage Learning
Principles of Accounting Volume 2
Accounting
ISBN:
9781947172609
Author:
OpenStax
Publisher:
OpenStax College