Answered step by step
Verified Expert Solution
Question
1 Approved Answer
The data is too big, please just answer with the process and equations on how to do those questions. Thanks! Questions 1-3 Biff Titan, a
The data is too big, please just answer with the process and equations on how to do those questions. Thanks!
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) 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) I just need the process or equation on how to do those questions. Data is too big from 1-923 cannot post all H 2 3 Store west east A Year 2011 2012 2013 2013 2013 2011 2011 5 fruit south 7 south west Group Product ice cream Edies cereal Cheerios ice cream Breyers grapes milk skim skim fruit grapes ice cream Ben and Jerry's ice cream Breyers fruit cherries fruit grapes ice cream Breyers ice cream Breyers ice cream des Ice cream Ben and Jerry's south 9 10 11 12 13 14 15 16 17 18 19 Month March March March January October December January July November February April July May March January February January August September December Apea September 2012 2011 2012 2011 2012 2012 2013 2013 2013 2011 2012 2012 2013 2011 east north east south Units Revenue 538 $ 2,800.31 847 S 944.38 790 S 1,342.20 650 $ 1,911.20 924 S 2,228.45 512 S 2,182.40 626 $ 1,037.36 6895 804.80 763 $ 1.262.06 957 $ 3,092.16 841 S 2,022.32 43 S 1,920.56 907 $ 1,722.64 881 $ 2,777.89 1088 $ 1,209.00 586 5 3,188,10 660 S 3,327.80 709 1,865.60 777 $ 2,494.81 510 S 2,889.24 864 S 2,979.84 748 5 3,018.95 west south 21 cereal Raluin Iran ice cream Breyers fruit plums skom low fat ice cream Ben and Jerry's 23 north south 2013 east fruit South west east 102 203 104 205 206 907 908 909 910 911 912 cereal August February May December June August July April September September May February October October February June July March May November November July 2013 2012 2011 2011 2012 2013 2012 2013 2011 2012 2013 2012 2011 2011 2013 2011 2012 2013 2011 2012 2012 west north north south south south west west plums ice cream Ben and Jerry's cereal Raisin Bran whole chocolate ice cream Breyers ice cream Breyers Cheerios ice cream Ben and Jerry's cereal Raisin Bran ice cream Edies grapes ice cream Breyers cereal Cheerios low fat fruit apples low fat chocolate fruit plums fruit plums fruit plums ice cream Ben and Jerry's 387 $ 1,686.45 598 $ 2.451.16 661 $ 1,896.86 687 S 1,837.04 742 $ 2,409.36 878 $ 2,664.50 755 S 1,567.28 566 $ 2,766.13 757 S 2,186.00 908 $ 2,160.48 896 S 762.44 873 $ 2,020,22 844 $ 2,522.56 701 $ 1,804.50 616 $ 2,039.70 605 S 2,525.20 715 S 2,043.20 773 $ 2,236.77 683 $ 1,152.50 779 $ 1,968.12 943 $ 3,307.52 663 $ 1,063.68 1913 1914 east west 915 916 917 918 919 920 921 922 923 east north east north north north west Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started