Logo
Home Study Material Contact Search
AI Chat FREE
  1. business
  2. accounting
  3. fannys famous funnel cakes in branson, mo has had

Fannys Famous Funnel cakes in Branson, MO has had a hard year because of lack...

50.1K

Verified Solution

Question

Accounting

Fannys Famous Funnel cakes in Branson, MO has had a hard year because of lack of visitors during the pandemic. The owner has decided to go mobile and is equipping a food truck and must decide how many fry stations to rent for the truck. It will cost $400 to rent each fry station per month and $1500 per month to staff the truck. Miscellaneous fixed costs are estimated at $200 per month. Ingredients and preparation costs are $1.45 per funnel cake and they will be sold for $4.00 each.

Assume that the truck will be produce to order and has a maximum capacity of 100 cakes per day. The truck will travel around the Branson area and be open for business 150 days per year.

a. Build a spreadsheet model for the food truck that will calculate Annual Profit. The following uncertain variables must be used: Number of fry stations; Daily demand.

b. Use a two-way table to display the sensitivity of profit to number of fry stations (from 1 to 5) and daily demand (from 100 to 500)

c. Use Goal-Seek to determine what the daily demand for funnel cakes must be for us to break-even if we rent three fry stations.

PLEASE SHOW ALL STEPS IN EXCEL

Answer & Explanation Solved by verified expert
Get Answers to Unlimited Questions

Join us to gain access to millions of questions and expert answers. Enjoy exclusive benefits tailored just for you!

Membership Benefits:
  • Unlimited Question Access with detailed Answers
  • Zin AI - 3 Million Words
  • 10 Dall-E 3 Images
  • 20 Plot Generations
  • Conversation with Dialogue Memory
  • No Ads, Ever!
  • Access to Our Best AI Platform: Flex AI - Your personal assistant for all your inquiries!
Become a Member

Other questions asked by students