Draw a detailed break-even chart, making sure to label the variables on the y- a
ID: 370972 • Letter: D
Question
Draw a detailed break-even chart, making sure to label the variables on the y- and x-axes, as well as all other significant points in the chart - 2 marks. (Create the graph in Excel-use legend to identify the lines and data labels to identify the break-even point).
8:35 PM 11/26/2017 Assignment 3 in Excel AUG 31-2017 Excel Abdul-Mannaan Giles Insert Draw Page Layout Formulas Data Reviow View Nitro Pro 10 Tell me what you want to do Cut AutoSum . A General Insert Delete Fommat Fill Clear. at as Good Merge & Center-51% , Conditional Form Formatting Table Sort& Find & Filter Select Paste B 1 u,, -A Neutral Format Painter Clipboard 1 Question 2 Q1: Solve the following problem 3A manufacturer plans to introduce a new shirt based on the following information. The 4selling price is $57.00; variable cost perunit is $18.00; fixed costs are $7800.00; and capacity CLR CLR 6 L7 Obj. 1, 2 Lesson & Ob 5 per period is 500 units 7a) Calculate the break-even point, showing your calculations-3 marks. 8 () in units 9 $57-$18 39 10 7800.00/39 200 units 12 15 (i) in dollars 16 200.00 57.00 11400 sales 17 7800 200 18 11400 dollars (cost) 18 19 20 (ii as a percent of capaci 21 200/500=.40 22.40 * 100-40% capacity b) Draw a detailed break-even chart, making sure to label the variables on the y- andx-axes, as well as all other significant points in the chart 2 marks. (Create the graph in Excel-use 23 legend to identify the lines and data labels to identify the break-even point) 24 25 26 27 28 29 31 Question 1 Q2 Q3 Q4 Q5-7 Q8-9 + 100%Explanation / Answer
Break-even point is the quantity of production/ sales at which Total Revenue = Total Cost
Quantity * Price = Fixed cost + Quantity * variable cost
Quantity- Break-even point = Fixed cost / (Price-Variable cost) = Fixed Cost / Margin
Given that unit Price is $57, Variable Cost per unit is $18, Fixed cost is $7,800
Therefore Breakeven point = 7800/39 = 200 units
Related Questions
drjack9650@gmail.com
Navigate
Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.