Now change all of the dollar amounts in the data area of your worksheet so that it looks like this: Chapter 1: Applying Excel Data Sales $59,500 Variable costs: Cost of goods sold $34,000 Variable selling $3,400 Variable administrative $3,200 Fixed costs: Fixed selling $2,500 Fixed administrative $1,500 If your formulas are correct, you should get the correct answers to the following questions. (a) What is the gross margin now? (b) What is the net operating income now? (c) What is the contribution margin now?

Now change all of the dollar amounts in the data area of your worksheet so that it looks like this: Chapter 1: Applying Excel Data Sales $59,500 Variable costs: Cost of goods sold $34,000 Variable selling $3,400 Variable administrative $3,200 Fixed costs: Fixed selling $2,500 Fixed administrative $1,500 If your formulas are correct, you should get the correct answers to the following questions. (a) What is the gross margin now? (b) What is the net operating income now? (c) What is the contribution margin now?

Cornerstones of Cost Management (Cornerstones Series)

4th Edition

ISBN:9781305970663

Author:Don R. Hansen, Maryanne M. Mowen

Publisher:Don R. Hansen, Maryanne M. Mowen

Chapter3: Cost Behavior

Section: Chapter Questions

Problem 5CE: Refer to Cornerstone Exercise 3.4 for data on Dohini Manufacturing Companys purchasing cost and...

See similar textbooks

Similar questions

Chapter 1: Applying Excel: Exercise (Part 2 of 2) 1. Now change all of the dollar amounts in the data area of your worksheet so that it looks like this: A B 1 2 3 4 5 6 7 8 9 10 11 Chapter 1: Applying Excel Data Sales $18,500 Variable costs: Cost of goods sold $12,000 Variable selling $1,200 Variable administrative $1,000 Fixed costs: Fixed selling $2,500 Fixed administrative $1,500 If your formulas are correct, you should get the correct answers to the following questions. (a) What is the gross margin now? (b) What is the net operating income now? (c) What is the contribution margin now? 2. Suppose that sales are 12% higher as shown below: A B 1 2 3 4 5 6 7 8 9 10 11 Chapter 1: Applying Excel Data Sales $20,720 Variable costs: Cost of goods sold $13,440 Variable selling $1,344 Variable administrative $1,120 Fixed costs: Fixed…
A small company manufactures a certain item and sells it online. The company has a business model where the cost, C in dollars, to make x items is given by the equation C = 20/3 x + 50. The revenue R , in dollars , made by selling x items is given by the equation R = 10x. How many items must the company sell in order for the cost to equal their revenue?
The controller for the Lillian Corporation created an Excel worksheet that included a profit calculation. The worksheet also contained a data table created using the What-if analysis tool to analyze the sales price, volume, and profit related to the graphics card the company manufactures. The worksheets are pictured next. Profit calculation 2 Sales price per unit $50 3 Less: Variable cost per unit $20 4 Contribution margin per unit $30 5 × Volume 700 6 Total contribution margin $21,000 7 Less: Fixed expenses $12,000 8 Operating income $9,000 9 10 Monthly target profit (minimum) $9,999 Data table 2 $9,000 $45 $50 $55 $60 $65 $70 3 900 $10,500 $15,000 $19,500 $24,000 $28,500 $33,000 4 850 $9,250 $13,500 $17,750 $22,000 $26,250 $30,500 5 800 $8,000 $12,000 $16,000 $20,000 $24,000 $28,000 6 750…
The controller for the Lillian Corporation created an Excel worksheet that included a profit calculation. The worksheet also contained a data table created using the What-if analysis tool to analyze the sales price, volume, and profit related to the graphics card the company manufactures. The worksheets are pictured next. Profit calculation 2 Sales price per unit $50 3 Less: Variable cost per unit $20 4 Contribution margin per unit $30 5 × Volume 700 6 Total contribution margin $21,000 7 Less: Fixed expenses $12,000 8 Operating income $9,000 9 10 Monthly target profit (minimum) $9,999 Data table 2 $9,000 $45 $50 $55 $60 $65 $70 3 900 $10,500 $15,000 $19,500 $24,000 $28,500 $33,000 4 850 $9,250 $13,500 $17,750 $22,000 $26,250 $30,500 5 800 $8,000 $12,000 $16,000 $20,000 $24,000 $28,000 6 750…
On the Data Tables - Student tab in your Excel spreadsheet, update the given information section of the Income Statement for Hello Company with the data below: Income Statement Product A Product B Product C Max Capacity Units 42,000 7,000 3,000 52,000 Price per unit $ 11.00 $ 8.00 $ 60.00 Variable expense per unit $ 4.00 $ 2.00 $ 20.00 Total Fixed Costs $ 20,000 $ 40,000 $ 10,000 Required: 2. Using the Data Table What-If Analysis tool in Excel, determine the Units and Operating Income (Loss) for each product based on the following scenarios. (Hint: Don't forget that the warehouse can only hold up to 52,000 units.) Scenario 1: Pete wants to find the mix of units that will result in the highest overall Operating Income, perform this analysis using a two variable data table. Product A can vary between 39,000 units and a maximum of 44,000 units. Product B can vary between 5,000 units…
a) Build a spreadsheet model that calculates profit or loss, using the principles of good spreadsheet design. If Harris makes 15,000 units, what is the resulting profit? b) Construct a one-way data table with production volume as the column input and profit as the output. Vary production volume from 0 to 100,000 in increments of 10,000. In which interval of production volume does breakeven occur? c) Construct a two-way data table with production volume as the column input and revenue per unit as the row input. Vary production volume from 0 to 100,000 in increments of 10,000. Input the revenue per units as $.75, $.85, $.95, $1.05. d) Use Goal Seek to find the exact breakeven point. Hint: To value: = 0.
Use the accompanying Profit_Analysis spreadsheet model to answer the following questions. Assumptions: Fixed cost: $ 5,000.00 Material costs per item: $ 2.25 Labor costs per item: $ 6.50 Shipping costs per 100 items: $ 200.00 Price per item: $ 12.99 Quantity: 2000 Outputs: Total revenues: $ 25,980.00 Total costs: $ 26,500.00 Total profits: $ -520.00 1. Use the data table tool to show the impact of quantity ranging from 1,500 to 5,000 with 500 unit increments on the total revenues, total costs, and total profits. What are the revenues, costs, and profits for 3,500 units? 2. Use the data table tool to show the impact of labor costs ranging from $5.00 to $8.00 with $0.50 increments and price per item ranging from $10.99 to $15.99 with $1.00 increments on the total profits. What is the total profit if the labor costs are $6.50, and the price is $14.99? Note: Round your answers to 2 decimal places. 3.…
SEARCH ASK AN EXPERT CHAT MATH SOLVER Question The Variable Cost of Goods Sold in the Marin Company totals P325,000. Fixed selling and administrative expenses totaled P115,000 and variable selling and administrative expenses were P210,000. If Marin Company's contribution margin totaled P590,000, then sales is? Also, What is the effect of this in the company of Marin? a.P650,000 B.Ph 915,000 C.Ph 1,030,000 D.Ph 1,125,000 Topic: Cost Volume Profit Please explain each clearly and solve in good form.
A department store has overhead costs of $250; 000 and a linear total cost function. The controller has set thestore's margin policy using the example of a $140 markup on an item retailing for $500. The controller has alsoestimated that other variable costs on the same retail item selling for $500 are $15.i. Find the revenue, cost, and prot functions using s for sale volume.ii. Find the break-even dollar volume of sales.iii. Draw the break-even chart.iv. What will the net prot be if sales are $3; 000; 000 ?
there are still these to answer Draw up a marginal cost statement on the basis that 12,000 units will be sold and calculate the net profit or loss c. Briefly explain what is meant by breakeven points d. Calculate the breakeven units in value and explain what it means to the director e. Calculate the sales activity to reach a target profit of £20,000.
A department store has overhead costs of $250; 000 and a linear total cost function. The controller has set thestore’s margin policy using the example of a $140 markup on an item retailing for $500. The controller has alsoestimated that other variable costs on the same retail item selling for $500 are $15.i. Find the revenue, cost, and profit functions using s for sale volume.ii. Find the break-even dollar volume of sales.iii. Draw the break-even chart.iv. What will the net profit be if sales are $3; 000; 000? Need the solution for only (iv)
A department store has overhead costs of $250,000 and a linear total cost function. The controller has set the store’s margin policy using the example of a $140 markup on an item retailing for $500. The controller has also estimated that other variable costs on the same retail item selling for $500 are $15. i. Find the revenue, cost, and profit functions using s for sale volume.ii. Find the break-even dollar volume of sales.iii. Draw the break-even chart.iv. What will the net profit be if sales are $3,000,000 ?

SEE MORE QUESTIONS

Recommended textbooks for you

Cornerstones of Cost Management (Cornerstones Ser…

Accounting

ISBN:

9781305970663

Author:

Don R. Hansen, Maryanne M. Mowen

Publisher:

Cengage Learning

Quickbooks Online Accounting

Accounting

ISBN:

9780357391693

Author:

Owen

Publisher:

Cengage

Excel Applications for Accounting Principles

Accounting

ISBN:

9781111581565

Author:

Gaylord N. Smith

Publisher:

Cengage Learning

Cornerstones of Cost Management (Cornerstones Ser…

Accounting

ISBN:

9781305970663

Author:

Don R. Hansen, Maryanne M. Mowen

Publisher:

Cengage Learning

Quickbooks Online Accounting

Accounting

ISBN:

9780357391693

Author:

Owen

Publisher:

Cengage

Excel Applications for Accounting Principles

Accounting

ISBN:

9781111581565

Author:

Gaylord N. Smith

Publisher:

Cengage Learning

SEE MORE TEXTBOOKS

GET THE APP

About FAQ Academic Integrity Sitemap Document Sitemap

Contact Bartleby Contact Research (Essays)High School Textbooks Literature Guides Concept Explainers by Subject Essay Help Mobile App

GET THE APP

Privacy

Your CA Privacy Rights

Your NV Privacy Rights

About Ads

Manage My Data

bartleby, a Learneo, Inc. business

Chapter 1: Applying Excel

Data
Sales	$59,500
Variable costs:
Cost of goods sold	$34,000
Variable selling	$3,400
Variable administrative	$3,200
Fixed costs:
Fixed selling	$2,500
Fixed administrative	$1,500