Question: Please work this problem in excel sheet and upload the results screenshot and also the formula used screenshot. Please do the detailed discussion for second

Please work this problem in excel sheet and upload the results screenshot and also the formula used screenshot.
Please do the detailed discussion for second part of the question.
Thanks. Will rate the answer for sure if you do good work.
Q Samantha Kelly, a student at SWOSU, plans to open a barbeque stand inside SWOSU's Milam stadium during home games. There are seven home games scheduled for the upcoming season. The football season is 14 weeks or 98 days long. She must pay the SWOSU athletic department a vendor's fee of $3,000 for the season. Her stand and other equipment will cost her $2,500 for the season. She estimates that each chopped beef brisket sandwich she sells will cost her $1.75. She has talked to friends at other universities who sell food at games. Based on their information and the athletic department's forecast that each game will sell out, she anticipates that she will sell approximately 675 chopped beef brisket sandwiches during each game. Calculate i) What price should she charge for a chopped beef brisket sandwich in order to break even for the season. ii) Write an analysis of your calculations and discuss what Samantha should do based on your calculations (Be detailed with the discussion) Q Samantha Kelly, a student at SWOSU, plans to open a barbeque stand inside SWOSU's Milam stadium during home games. There are seven home games scheduled for the upcoming season. The football season is 14 weeks or 98 days long. She must pay the SWOSU athletic department a vendor's fee of $3,000 for the season. Her stand and other equipment will cost her $2,500 for the season. She estimates that each chopped beef brisket sandwich she sells will cost her $1.75. She has talked to friends at other universities who sell food at games. Based on their information and the athletic department's forecast that each game will sell out, she anticipates that she will sell approximately 675 chopped beef brisket sandwiches during each game. Calculate i) What price should she charge for a chopped beef brisket sandwich in order to break even for the season. ii) Write an analysis of your calculations and discuss what Samantha should do based on your calculations (Be detailed with the discussion)
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
