Fundamentals of Cost Accounting
5th Edition
ISBN: 9781259565403
Author: William N. Lanen Professor, Shannon Anderson Associate Professor, Michael W Maher
Publisher: McGraw-Hill Education
expand_more
expand_more
format_list_bulleted
Videos
Textbook Question
Chapter 3, Problem 38E
Using Microsoft Excel to Perform CVP Analysis
Refer to the data for Warner Clothing in Exercise 3-30.
Required
Using the Goal Seek function in Microsoft Excel,
- a. What number must Warner Clothing sell to break even?
- b. What number must Warner Clothing sell to make an operating profit of $9,000 per month?
Expert Solution & Answer
Want to see the full answer?
Check out a sample textbook solution
Students have asked these similar questions
Discuss the accounting treatment for investments in debt and equity securities.
Saved
Required information
[The following information applies to the questions displayed below.]
On December 1, Jasmin Ernst organized Ernst Consulting. On December 3, the owner contributed $84,310 in assets to
launch the business. On December 31, the company's records show the following items and amounts.
$ 10,200 Cash withdrawals by owner
Cash
Accounts receivable
15,200
Consulting revenue
Office supplies
3,550
Rent expense
Land
45,990
Office equipment
18,310
Accounts payable
8,740
Salaries expense
Telephone expense
Miscellaneous expenses
Owner investments
84,310
$ 2,340
15,200
3,910
7,350
790
610
Use the above information to prepare a December 31 balance sheet for Ernst Consulting.
AC
Graw
Hill
ERNST CONSULTING
Balance Sheet
December 31
$
0
G-SYNC
$
0
S
0
B
Audit, Fraud, Or Forensic Accounting
Introduce yourself to your peers by sharing something unique about your background. Explain how you expect this course will help you move forward in your current or future career.
This course covers forensic accounting, so it's important to establish the differences between an audit, a fraud examination, and a forensic accounting engagement. Think about the fraud conviction of Elizabeth Holmes, as described in the video, "Elizabeth Holmes Found Guilty in Theranos Fraud Trial."
Then respond to the following:
Imagine you are assigned to the Theranos case.
Write the first five questions you would ask if you were an auditor, the first five questions as a fraud examiner, and the first five as a forensic accountant.
After your questions, explain why the questions and approaches are different among the three roles.
Be sure to respond to at least one of your classmates' posts.
Chapter 3 Solutions
Fundamentals of Cost Accounting
Ch. 3 - Write out the profit equation and describe each...Ch. 3 - What are the components of total costs in the...Ch. 3 - How does the total contribution margin differ from...Ch. 3 - Compare cost-volume-profit (CVP) analysis with...Ch. 3 - Fixed costs are often defined as fixed over the...Ch. 3 - Prob. 6RQCh. 3 - What is the margin of safety? Why is this...Ch. 3 - Prob. 8RQCh. 3 - Write out the equation for the target volume (in...Ch. 3 - How do income taxes affect the break-even...
Ch. 3 - Why is it common to assume a fixed sales mix...Ch. 3 - What are some important assumptions commonly made...Ch. 3 - Prob. 13CADQCh. 3 - Prob. 14CADQCh. 3 - The typical cost-volume-profit graph assumes that...Ch. 3 - The assumptions of CVP analysis are so simplistic...Ch. 3 - Prob. 17CADQCh. 3 - Consider a class in a business school where volume...Ch. 3 - Prob. 19CADQCh. 3 - Prob. 20CADQCh. 3 - Consider the Business Application,...Ch. 3 - Consider the Business Application,...Ch. 3 - Profit Equation Components Identify each of the...Ch. 3 - Profit Equation Components Identify the letter of...Ch. 3 - Basic Decision Analysis Using CVP Anus Amusement...Ch. 3 - Basic CVP Analysis The manager of Dukeys Shoe...Ch. 3 - CVP AnalysisEthical Issues Mark Ting desperately...Ch. 3 - Basic Decision Analysis Using CVP Derby Phones is...Ch. 3 - Prob. 29ECh. 3 - Basic Decision Analysis Using CVP Warner Clothing...Ch. 3 - Basic Decision Analysis Using CVP Refer to the...Ch. 3 - Prob. 32ECh. 3 - Prob. 33ECh. 3 - Analysis of Cost Structure Spring Companys cost...Ch. 3 - CVP and Margin of Safety Bristol Car Service...Ch. 3 - CVP and Margin of Safety Caseys Cases sells cell...Ch. 3 - Using Microsoft Excel to Perform CVP Analysis...Ch. 3 - Using Microsoft Excel to Perform CVP Analysis...Ch. 3 - CVP with Income Taxes Hunter Sons sells a single...Ch. 3 - CVP with Income Taxes Hammerhead Charters runs...Ch. 3 - Prob. 41ECh. 3 - Prob. 42ECh. 3 - CVP Analysis and Price Changes Argentina Partners...Ch. 3 - Prob. 44PCh. 3 - CVP AnalysisMissing Data Breed Products has...Ch. 3 - Prob. 46PCh. 3 - Prob. 47PCh. 3 - CVP AnalysisSensitivity Analysis (spreadsheet...Ch. 3 - Extensions of the CVP ModelSemifixed (Step) Costs...Ch. 3 - Prob. 50PCh. 3 - Extensions of the CVP ModelTaxes Odd Wallow Drinks...Ch. 3 - Prob. 52PCh. 3 - Prob. 53PCh. 3 - Extensions of the CVP ModelTaxes Toys 4 Us sells...Ch. 3 - Extensions of the CVP AnalysisTaxes Eagle Company...Ch. 3 - Extensions of the CVP ModelMultiple Products...Ch. 3 - Extensions of the CVP ModelMultiple Products...Ch. 3 - Prob. 58PCh. 3 - Prob. 59PCh. 3 - Prob. 60PCh. 3 - Prob. 61PCh. 3 - Extensions of the CVP ModelMultiple Products and...Ch. 3 - Extensions of the CVP ModelTaxes With Graduated...Ch. 3 - Financial Modeling Three entrepreneurs were...
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.Similar questions
- Degregorio Corporation makes a product that uses a material with the following direct material standards: Standard quantity 2.7 kilos per unit Standard price $9 per kilo The company produced 5,700 units in November using 15,760 kilos of the material. During the month, the company purchased 17,830 kilos of direct material at a total cost of $156,904. The direct materials purchases variance is computed when the materials are purchased. The materials quantity variance for November is: a. $3,330 F b. $3,236 F c. $3,330 U d. $3,236 Uarrow_forwardNonearrow_forwardGeneral Accountarrow_forward
- Financial accountingarrow_forwardSubject: Financial Accountingarrow_forwardThe blending department had the following data for the month of March: Units in BWIP Units completed 7,200 Units in EWIP (40% complete) 750 $27,000 Total manufacturing costs Required: 1. What is the output in equivalent units for March? 2. What is the unit manufacturing cost for March?arrow_forward
arrow_back_ios
SEE MORE QUESTIONS
arrow_forward_ios
Recommended textbooks for you
Excel Applications for Accounting PrinciplesAccountingISBN:9781111581565Author:Gaylord N. SmithPublisher:Cengage Learning
Principles of Accounting Volume 2AccountingISBN:9781947172609Author:OpenStaxPublisher:OpenStax College
Cornerstones of Cost Management (Cornerstones Ser...AccountingISBN:9781305970663Author:Don R. Hansen, Maryanne M. MowenPublisher:Cengage Learning
Excel Applications for Accounting Principles
Accounting
ISBN:9781111581565
Author:Gaylord N. Smith
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
How to Estimate Project Costs: A Method for Cost Estimation; Author: Online PM Courses - Mike Clayton;https://www.youtube.com/watch?v=YQ2Wi3Jh3X0;License: Standard Youtube License