O Scare AutoSave + H 2 File: Home Insert BREAKEVEN EXCEL PROJECT Spirog 2019 CC Raway-1 (1- Frobeled View Pace Layout Formulas Data Review View Help MALIK AHMAD MU Share - o x Comments Draw Enable Editing (1) PROTECTED VIEW Be careful files from the Internet can canta in viruses. Unless you read to eat. It's safer to stay in Protected view (1) SUBSCRIPTION CANCELLED On Wecherclay.uly 15, 2020 inos lecies ul Excel will be disabled. Desi K L M N O P 1:19 - X f C D E F G H i Compute break-even point 2 Grand Canyon Railway is a restored train which offers one class of service, Coach. The railway's managers have 3 to find the correct balance with ticket prices and costs to earn a profit, but yet fill the seats. Because 4 most of the railway's costs are fixed, the extra costs to serve each additional passenger are low. Once fixed costs s are covered, most of the revenue from an extra guest goes toward providing a profit. Suppose the 6 price for an all-inclusive round-trip ticket is $52 per passenger. Assume variable expenses 7 and fixed costs as shown below: 70 11 Variable Cost Fixed Costs Ticket Price $12 per passenger $200,000 per month $52 per passenger 12 13 Instructions 14 Determine the railway's break-even point in (a) number of tickets sold per month and (b) ticket sales dollars. 15 NOTE: Enter a number in cells requesting a value; enter either a number or a formula in cells with a "?". 20 (a) 21 22 Determine the railway's break-even point in number of tickets per month Contribution margin per ticket Ticket price per passenger Variable cost per passenger Contribution margin per passenger 23 24 25 27 Contribution margin ratio Cantribution margini per passenger E19.9 Shert! Sheri2 Value 0 - + 1339 1 1153PM Type here to search O Scare AutoSave + H 2 File: Home Insert BREAKEVEN EXCEL PROJECT Spirog 2019 CC Raway-1 (1- Frobeled View Pace Layout Formulas Data Review View Help MALIK AHMAD MU Share - o x Comments Draw Enable Editing (1) PROTECTED VIEW Be careful files from the Internet can canta in viruses. Unless you read to eat. It's safer to stay in Protected view (i) SUBSCRIPTION CANCELLED On Wednesday.uly 15, 2020 inost lealues ul Lucel will be disabled. Eestival 119 C D E F G H J K L M N O P - 19 20 (a) 21 22 Determine the railway's break-even point in number of tickets per month Contribution margini per lickel Ticket price per passenger Variable cost per passenger Contribution margin per passenger 27 20 Contribution margin ratio Contribution margin per passenger Ticket price per passenger Contribution margin ratio Value Value Fixed costs 34 15 Break-even point in tickets Fixed costs Contribution margin per passenger Break-even point in tickets Value Value Determine the inn's break-even point in dollars. 19 (b) 10 Break-even point in dollars Break-even point in tickets Ticket price per passenger Break-even point in dollars Value Value Value 13 44 45 17 AH OR Fixed costs Contributin mainin rolin E19.9 Sherl Sheri? Value Vaali 1 D L - + L 1:53PM 193% 2 Type here to search O Scare AutoSave + H 2 File: Home Insert BREAKEVEN EXCEL PROJECT Spirog 2019 CC Raway-1 (1- Frobeled View Pace Layout Formulas Data Review View Help MALIK AHMAD MU Share - o x Comments Draw Enable Editing (1) PROTECTED VIEW Be careful files from the Internet can canta in viruses. Unless you read to eat. It's safer to stay in Protected view (1) SUBSCRIPTION CANCELLED On Wecherclay.uly 15, 2020 inos lecies ul Excel will be disabled. Desi 119 D E F G H I J K L M N O P - 42 C Value Value Break-even point in tickets Ticket price per passenger Break-even point in dollars 13 44 46 OR Fixed costs Cantribution margin ratio Break-even point in dollars Value Value 53 When you have completed the original assignment, consider the following additional question. 55 1. Now suppose that the railway decreases its round-trip ticket price from $52 to $44, in order to increase the number of passengers. Compute the new breakeven point in units and sales dollars. 56 59 2. Now, assume that the railway could reduce its variable costs by eliminating champagne from the afternoon beverages. Suppose this would reduce the variable expense per passenger from $12 to S10. Compute the new breakeven point in units and sales dollars (go back to the original information). 61 62 83 3. Suppose that Grand Canyon Railway embarks on a cost reduction drive, and slashes fixed expenses from $200,000 per month to $150,000 per month. Compute the breakeven point in units and sales dollars. Show the impact of that this change will have on the calculations E19.9 Shert! Sheri2 0 - 1 1:53PM + 1339 2 Type here to search