Include excel formulas

A small amusement park is open seasonally in the summer. In a typical summer season, the number of adult and child tickets sold is 20,000 and 10,000, respectively. The adult ticket price is $18 and the child ticket price is $10. Revenue from food and beverage concessions is estimated to be $60,000. Sovenir revenue is expected to be $25,000. Variable costs per person (adult and child) are $3.00. Fixed costs amount to $150,000 for the season. Construct a model to calculate seasonal profitability. Use best practices as you learned in class