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   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).

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

 

  • 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
trending now

Trending now

This is a popular solution!

steps

Step by step

Solved in 4 steps

Blurred answer
Knowledge Booster
Capital Budgeting
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
Principles of Cost Accounting
Principles of Cost Accounting
Accounting
ISBN:
9781305087408
Author:
Edward J. Vanderbeck, Maria R. Mitchell
Publisher:
Cengage Learning
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
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,