Elmwood Pinecone sells fake Christmas trees with a selling price of $75 and variable costs per unit of $30. The company’s monthly fixed expenses are $22,500. NOTE: You may want to use one of the EXCEL spreadsheets I provided in the module - Chapter03 CM Income Statement.xlsx  download or Chapter03 CM Income Statement BE.xlsx  download - to help complete this problem.  The following names are to be considered when completing this problem: Operating Income Variable Costs Sales Fixed Costs per Unit Selling Price per Unit Variable Cost per Unit Contribution Margin Fixed Costs Operating Loss What is the Elmwood’s break-even point in units?  . Use commas as needed (i.e. 1,234). What is the Elmwood’s break-even point in dollars?  . Rounded to whole dollars and shown with "$" and commas as needed (i.e. $12,345). Using the names listed above, construct a contribution margin income statement for the month of November when they will sell 900 units. Rounded to whole dollars and shown with "$" and commas as needed (i.e. $12,345). Elmwood Pinecone Contribution Margin Income Statement For the Month of November

Principles of Accounting Volume 2
19th Edition
ISBN:9781947172609
Author:OpenStax
Publisher:OpenStax
Chapter10: Short-term Decision Making
Section: Chapter Questions
Problem 2PB: Mortech makes digital cameras for drones. Their basic digital camera uses $80 in variable costs and...
icon
Related questions
Question

Elmwood Pinecone sells fake Christmas trees with a selling price of $75 and variable costs per unit of $30. The company’s monthly fixed expenses are $22,500.

NOTE: You may want to use one of the EXCEL spreadsheets I provided in the module - Chapter03 CM Income Statement.xlsx  download or Chapter03 CM Income Statement BE.xlsx  download - to help complete this problem. 

The following names are to be considered when completing this problem:

Operating Income Variable Costs

Sales

Fixed Costs per Unit Selling Price per Unit

Variable Cost per Unit

Contribution Margin Fixed Costs

Operating Loss

  • What is the Elmwood’s break-even point in units?  . Use commas as needed (i.e. 1,234).
  • What is the Elmwood’s break-even point in dollars?  . Rounded to whole dollars and shown with "$" and commas as needed (i.e. $12,345).
  • Using the names listed above, construct a contribution margin income statement for the month of November when they will sell 900 units. Rounded to whole dollars and shown with "$" and commas as needed (i.e. $12,345).
Elmwood Pinecone
Contribution Margin Income Statement
For the Month of November
   
   
   
   
   
  • How many trees will Elmwood need to sell in order to realize a target profit of $45,000?  . Use commas as needed (i.e. 1,234).
  • What dollar sales will Elmwood need to generate in order to realize a target profit of $45,000?  . Rounded to whole dollars and shown with "$" and commas as needed (i.e. $12,345).
  • Construct a contribution margin income statement for the month of December that reflects $150,000 in sales revenue for Elmwood. Rounded to whole dollars and shown with "$" and commas as needed (i.e. $12,345).
    Elmwood Pinecone
    Contribution Margin Income Statement
    For the Month of December
       
       
       
       
       
Expert Solution
steps

Step by step

Solved in 3 steps

Blurred answer
Knowledge Booster
Risk Management Techniques
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.
Similar questions
  • SEE MORE QUESTIONS
Recommended textbooks for you
Principles of Accounting Volume 2
Principles of Accounting Volume 2
Accounting
ISBN:
9781947172609
Author:
OpenStax
Publisher:
OpenStax College
Managerial Accounting: The Cornerstone of Busines…
Managerial Accounting: The Cornerstone of Busines…
Accounting
ISBN:
9781337115773
Author:
Maryanne M. Mowen, Don R. Hansen, Dan L. Heitger
Publisher:
Cengage Learning
Cornerstones of Cost Management (Cornerstones Ser…
Cornerstones of Cost Management (Cornerstones Ser…
Accounting
ISBN:
9781305970663
Author:
Don R. Hansen, Maryanne M. Mowen
Publisher:
Cengage Learning
Principles of Cost Accounting
Principles of Cost Accounting
Accounting
ISBN:
9781305087408
Author:
Edward J. Vanderbeck, Maria R. Mitchell
Publisher:
Cengage Learning
Excel Applications for Accounting Principles
Excel Applications for Accounting Principles
Accounting
ISBN:
9781111581565
Author:
Gaylord N. Smith
Publisher:
Cengage Learning
Essentials Of Business Analytics
Essentials Of Business Analytics
Statistics
ISBN:
9781285187273
Author:
Camm, Jeff.
Publisher:
Cengage Learning,