Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

please use Excel to answer each question Questions 1-3 Biff Titan, a student at UWO, plans to open a hot dog stand inside UWO's football

please use Excel to answer each question image text in transcribed
Questions 1-3 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,600 for the season. The stand and other equipment will cost him $2,850 for the season. Each hot dog will cost him $0.61. 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 1,075 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) wanita 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 $0.96 each and sell them for $3.25 each. The vendor fee for that game will only be $450, and he will need to buy $225 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) Next season, hot dog costs are going up by 21% over last season, so Biff is going to charge $1.75 per regular hot dog. He will need to spend $1,950 for equipment and stand updates next season, not $2,850. In addition, he is busy, so he is hiring his friend, Dexter St. Jock, to help him at $58/game. Assume the number of games goes up by 1 from last season, hot dog sales increase 8% over the last season, and don't worry about playoffs 3) What vendor fee should Biff negotiate to make a profit of $6,250 next season? Answer to 0 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_2

Step: 3

blur-text-image_3

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

Financial accounting

Authors: Walter T. Harrison Jr., Charles T. Horngren, C. William Thom

9th edition

978-0132751216, 132751127, 132751216, 978-0132751124

More Books

Students also viewed these Accounting questions

Question

What is the formula to calculate the mth Fibonacci number?

Answered: 1 week ago