Question: 3 4 5 File Home Insert Page Layout Formulas Data Review View Help Power Pivot X Cut Arial -AA == Paste Copy BIU G
3 4 5 File Home Insert Page Layout Formulas Data Review View Help Power Pivot X Cut Arial -AA == Paste Copy BIU G - Undo Format Painter Clipboard Font V34 fx A 1 Q2 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30: 31 32 33 34 35 36 Comments Share Wrap Text General AutoSum Normal Bad O Merge & Center $ % 88 Formatting Conditional Format as Table Good Neutral Insert Delete Format Clear Sort & Find & Filter -Select- Alignment Number Styles Cells Editing Analyze Data Analysis Sensitivity Sensitivity G Tanner Park is a small amusement park that provides a variety of rides and outdoor activities for children and teens. In a typical summer season, the number of adult and children's tickets sold is 30,000 and 18,000, respectively. Adult ticket prices are $23 and the children's price is $12. Revenue from food and beverage concesions is estimated to be $55,000 and souvenir revenue is expected to be $35,000. Variable costs per person (adult or child) are $4, and fixed costs amount to $200,000. Develop a model on this worksheet to compute the expected profit. Design your spreadsheet using good spreadsheet-engineering principles. H K L M N P R S U V
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
