Cost-volume-Profis: Break-Even Analysis Uaing twrel Compieting this accvity wit bele you leam to: 1. undertand bow cewts and ales price aneerect to krodret prots 2. creste a resicabie spreatuhert. 1. Geate ahseiste fincel referentert that wis nut ongrepe nhen a formuls is copied and paced. 4. croate a graph to viwolly see a bresk-chen point. 2. Variptie cects that are waired fer each jackit grobuce Aegumed You change the costs (foued or varioble) or saies price. You change the couts (fictd od vandeble) or akles price. theouth the steps. Hiktistir-BYistep whLkrHAiovar 1. Eace Formula Section Peiform the foloning tadculations ubing the given dats. 3. In cet c., calcuiate the cothroveian thargin per jack unit. th. In celt ce, calculate the break even peint in jacket unts. Note: You muat create this date table to be able to graph the break-even point. groducing wese jacket? terportant: Aithough cost is often wought of as a negative humber in accounting. keap vour cerugagns if postive numben. Cogy and paste yeur formula into the remainder of cohumn c. seiling one facket? Copy and poste vere formola for the reminete st column D The cirrect graph is Use your streadweet to emplore haw cests and vohume irteract. What Aappens to the break eved point it you lower the fixed couts? The birek even bont wat What hepgena te the break-ven gount a you increase your sales prow? The Break tren point wit 4. Use your spreadsheet to explore how costs and volume interact. What happens to the break-even point if you lower the fixed costs? The break-even point will What happens to the break-even point it you increase your sales grice? The break-even point will What hapgens to the break-even point if you lower the variable costs? The break-even point will Cost-Volume-Profiti Breah-Even Analysis Using Excel completing this activity will help you leden to: 1. uncentand how obsts and seles price interact to prodice probe. 2. create a reukible spreadsheet 3. creqce absolve Ercel references that wil not change wher a formus is copied and pasted. 4) crebte a graph to visually see a break-even point. 2. Yanable cats that are incurred for eqch jacket produced, e.g. wool materid: graph the utits, profiss, and cost to "lee"' the break.even point. Hequiled: X Downioad apreadsheet BreaktyenPointCaseoata-53ack alix you change the costs (fixed or variable) or sates price. thiengigh thin steps HINTI STE GYSTEP WALKTINOUCH 1. Excel formula Section: Ferfors the folowing caiculabens uning the given data 3. In ces Cr, calfidate the contribution margin per jacket unit. b. In cell Cs, calculase the break-even point in gacket units. 2. Data Tabie Section: Perform the following calcuibtions using the given basta. Hewi You need to ust absolute reforences Note: You must create this data table to be able to graph the break-even polnt. producing one jacher? Important: Athooght coet is often thought of as a negstivn number in accounting, keep your calculations in positive mumben. Copy and paste vour formule into the nemainder of column C seiling one jeket? B. In oel D13, create a formwie using the number of unis in colomin a and the soles price to colculate the grows revenue for seiling that inaty jackets. For exampie, in ors, what is the groit revenue foe seling ent Jacket? Copy and paste vour formula for the remainder of coliamn 0 . The correct graph is 4. Use your spresdsheet th explore how costs and volume imteract. What happens to the break-even point if vou lower the fixed costs? The break-even pert wil What hapgens to the break-even point if you tictease your sales price? The breakeven point will The correct graph is 4. Use your eprebdshect to ekplore how costs and volme interact. What hbppens to the breakeeven goipt in rou logner the fixed caste? The hasesk-cveis peint yiil Wist hapgens to the break-even point if yeu increate your sales peice? The areak even goint wh What nappens to the break-even point if you lover the yariable costs? The break-even point will 5. Cuculate profits in column E. For example, in E13, what is the profit for producing one jscket? use a minus aign ro enter ioss, Af any 6. Wsing the graph, explain how a treak-eyte point changes in relation to cost and seil price. The input in the box below wilt not be grsded, but may be feviewed and considered by your instructor Cost-volume-Profis: Break-Even Analysis Uaing twrel Compieting this accvity wit bele you leam to: 1. undertand bow cewts and ales price aneerect to krodret prots 2. creste a resicabie spreatuhert. 1. Geate ahseiste fincel referentert that wis nut ongrepe nhen a formuls is copied and paced. 4. croate a graph to viwolly see a bresk-chen point. 2. Variptie cects that are waired fer each jackit grobuce Aegumed You change the costs (foued or varioble) or saies price. You change the couts (fictd od vandeble) or akles price. theouth the steps. Hiktistir-BYistep whLkrHAiovar 1. Eace Formula Section Peiform the foloning tadculations ubing the given dats. 3. In cet c., calcuiate the cothroveian thargin per jack unit. th. In celt ce, calculate the break even peint in jacket unts. Note: You muat create this date table to be able to graph the break-even point. groducing wese jacket? terportant: Aithough cost is often wought of as a negative humber in accounting. keap vour cerugagns if postive numben. Cogy and paste yeur formula into the remainder of cohumn c. seiling one facket? Copy and poste vere formola for the reminete st column D The cirrect graph is Use your streadweet to emplore haw cests and vohume irteract. What Aappens to the break eved point it you lower the fixed couts? The birek even bont wat What hepgena te the break-ven gount a you increase your sales prow? The Break tren point wit 4. Use your spreadsheet to explore how costs and volume interact. What happens to the break-even point if you lower the fixed costs? The break-even point will What happens to the break-even point it you increase your sales grice? The break-even point will What hapgens to the break-even point if you lower the variable costs? The break-even point will Cost-Volume-Profiti Breah-Even Analysis Using Excel completing this activity will help you leden to: 1. uncentand how obsts and seles price interact to prodice probe. 2. create a reukible spreadsheet 3. creqce absolve Ercel references that wil not change wher a formus is copied and pasted. 4) crebte a graph to visually see a break-even point. 2. Yanable cats that are incurred for eqch jacket produced, e.g. wool materid: graph the utits, profiss, and cost to "lee"' the break.even point. Hequiled: X Downioad apreadsheet BreaktyenPointCaseoata-53ack alix you change the costs (fixed or variable) or sates price. thiengigh thin steps HINTI STE GYSTEP WALKTINOUCH 1. Excel formula Section: Ferfors the folowing caiculabens uning the given data 3. In ces Cr, calfidate the contribution margin per jacket unit. b. In cell Cs, calculase the break-even point in gacket units. 2. Data Tabie Section: Perform the following calcuibtions using the given basta. Hewi You need to ust absolute reforences Note: You must create this data table to be able to graph the break-even polnt. producing one jacher? Important: Athooght coet is often thought of as a negstivn number in accounting, keep your calculations in positive mumben. Copy and paste vour formule into the nemainder of column C seiling one jeket? B. In oel D13, create a formwie using the number of unis in colomin a and the soles price to colculate the grows revenue for seiling that inaty jackets. For exampie, in ors, what is the groit revenue foe seling ent Jacket? Copy and paste vour formula for the remainder of coliamn 0 . The correct graph is 4. Use your spresdsheet th explore how costs and volume imteract. What happens to the break-even point if vou lower the fixed costs? The break-even pert wil What hapgens to the break-even point if you tictease your sales price? The breakeven point will The correct graph is 4. Use your eprebdshect to ekplore how costs and volme interact. What hbppens to the breakeeven goipt in rou logner the fixed caste? The hasesk-cveis peint yiil Wist hapgens to the break-even point if yeu increate your sales peice? The areak even goint wh What nappens to the break-even point if you lover the yariable costs? The break-even point will 5. Cuculate profits in column E. For example, in E13, what is the profit for producing one jscket? use a minus aign ro enter ioss, Af any 6. Wsing the graph, explain how a treak-eyte point changes in relation to cost and seil price. The input in the box below wilt not be grsded, but may be feviewed and considered by your instructor