12th Edition

ISBN: 9780134486444

Author: Tracie L. Miller-Nobles, Brenda L. Mattison, Ella Mae Matsumura

Publisher: PEARSON

Concept explainers

A master budget can be defined as an estimation of the revenue earned or expenses incurred over a specified period of time in the future and it is generally prepared on a periodic basis which can be either monthly, quarterly, half-yearly, or annually. It…

Sales Budget and Selling

A budget is a financial plan designed by an undertaking for a definite period in future which acts as a major contributor towards enhancing the financial success of the business undertaking. The budget generally takes into account both current and future…

Videos

Textbook Question

Chapter 21, Problem P21.68CT

Using Excel for cost-volume-profit(CVP) analysis

Download an Excel template for this problem online in MyAccountingLab or athttp:www.pearsonhighered.com/Horngren.

The Oceanside Garden Nursery buys flowering plants in four-inch pots for $1.00 each and sells them for $2.50 each. Management budgets monthly fixed costs of $2,100 for sales volumes between 0 and 5,000 plants.

Requirements

1. Use the contribution margin approach to compute the company's monthly breakeven point in units.
2. Use the contribution margin ratio approach to compute the breakeven point in sales dollars.
3. Use the contribution margin approach to compute the monthly sales level (in units) required to earn a target operating income of $5,000.
4. Prepare a graph of the company's CVP relationships. Include the sales revenue line, the fixed cost line, and the total cost line. Create a chart title and label the axes.

Expert Solution & Answer

Want to see the full answer?

Check out a sample textbook solution

See solution

Chapter 21, Problem P21A.67BPGB

Chapter 21, Problem P21.69CP

Students have asked these similar questions

A tree provider to plant nurseries is trying to use customer lifetime value to determine the value of its customers. Two customers are shown below. Use customer lifetime value to determine the importance of each customer. Use a 7 percent discount rate. Avg. Annual Sales Avg. Profit Margin Customer A: Customer B: $26,500 $14,000 Do not round intermediate calculans. Round your answers to the nearest dollar. NPV (Customer A): $ 25% 15% Expected Lifetime 11 years 7 years NPV (Customer B): $ What do you recommend? -Select- is more important.

A tree provider to plant nurseries is trying to use customer lifetime value to determine the value of its customers. Two customers are shown below. Use customer lifetime value to determine the importance of each customer. Use an 8 percent discount rate. Avg. Annual Sales Avg. Profit Margin 10% $12,500 $26,000 20% Do not round intermediate calculations. Round your answers to the nearest dollar. NPV (Customer A): $ NPV (Customer B): $ What do you recommend? Customer B ✓ Customer A: Customer B: is more important. Expected Lifetime 5 years 9 years

COURSE: COSTS AND BUDGETING - BREAK EVEN ANALYSIS A retailer wants to sell new pens that in turn are used as bracelets. Each pen costs $400 with the option to return any unsold pens. The permit for the sale costs $150,000. Each pen will be sold for $750. Using the ECUATION and CONTRIBUTION MARGIN methods, determine how many pens must be sold to make neither a loss nor a profit?

Chapter 21 Solutions

Horngren's Accounting (12th Edition)

Ch. 21 - For Frank’s Funky Sounds, straight-line...Ch. 21 - Prob. 2QC Ch. 21 - Prob. 3QC Ch. 21 - Prob. 4QC Ch. 21 - Prob. 5QC Ch. 21 - On a CVP graph, the total cost line intersects the...Ch. 21 - If a company increases its sales price per unit...Ch. 21 - Prob. 8QC Ch. 21 - Prob. 9QC Ch. 21 - Prob. 10QC

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.