Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Create an excel spreadsheet with a profit model to answer the following questions. You are expected to use what-if-analysis and goal seek to answer your

Create an excel spreadsheet with a profit model to answer the following questions. You are expected to use what-if-analysis and goal seek to answer your questions. A student at OSU plans to open a hot dog stand inside the football stadium during home games. There are seven home games scheduled for the upcoming season. She must pay the OSU athletic department a vendors fee of $3,000 for the season. Her stand and other equipment will cost her $4,500 for the season. She estimates that each hotdog she sells will cost her $0.35 per hotdog. Based on the athletic departments forecast and other information, she anticipates that she will sell approximately 2,000 hot dogs during each game. a) What will her revenue, total cost, and profit be if she is currently charging $1.75 per hot dog? b) At what price would she be able to break even? c) If she plans on making a profit of $3000 per game, how much would she need to charge? d) Create a one-way table comparing price to profit.

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

Auditor Jokes The Ultimate Collection Of Auditor Jokes

Authors: Chester Croker

1st Edition

1080090169, 978-1080090167

More Books

Students also viewed these Accounting questions

Question

Describe the nature of negative messages.

Answered: 1 week ago