Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

please use excel and goal seek to find the answer. also can u please show formulas Biff Titan, a student at UWO, plans to open

please use excel and goal seek to find the answer. also can u please show formulas image text in transcribed
Biff Titan, a student at UWO, plans to open a hot dog stand inside UWO's football stadium during home games. There are eight (8) home games scheduled for the upcoming season. He must pay the UWO athletic department a vendor's fee of $1,700 for the season. The stand and other equipment will cost him $2,462 for the season. Each hot dog will cost him $0.73. He has talked to friends at other universities who sell hot dogs at games. Based on their information and the athletic department's forecast that each game will sell out, he anticipates that he will sell approximately 860 hot dogs during each game. 1) What will he need to charge per hot dog to break even for the season? Answer to 2 decimal places. Include the excel table you used to answer this (copy and paste it into the word document) and note any formulas you created. (5 pts) UWO has made the playoffs and will be adding one more game. Biff is going to sell premium hot dogs (instead of regular) that cost $1.40 each and sell them for $3.50 each. The vendor fee for that game will only be $755, and he will need to buy $395 in supplies for that game only. 2) How many hot dogs will he need to sell at that game to break even for that game? Round to o decimal places. Include the excel table you used to answer this (copy and paste it into the word document) and note any formulas you created. (5 pts)

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Organization Theory And Public Management

Authors: Jonathan R. Tompkins

1st Edition

053417468X, 978-0534174682

More Books

Students also viewed these General Management questions

Question

agreeableness emotionality and extroversion are all part of

Answered: 1 week ago

Question

Is it clear what happens if an employee violates the policy?

Answered: 1 week ago