Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Ayesha operates a hot dog stand, a street food cart in downtown DC . She sells a combo package: one hot dog with a soda

image text in transcribed
Ayesha operates a hot dog stand, a street food cart in downtown DC. She sells a combo package: one hot dog with a soda and a bag of chips. Ayesha charges $5.95 for the combo package. At this price she sells 95 combos per day. Ayesha's costs are simple. A hot dog costs her seventy-five cents, a roll costs her fifteen cents, a bag of chips costs her fifty cents, and a soda costs her thirty-five cents for each can. Ayesha uses one jar of mustard, $1.75 and a bottle of ketchup, $1.45, per day. Miscellaneous supplies cost $10 per day. Ayesha's vendor license costs $100 per month, with Ayesha working 20 days per month. Ayesha also pays an 18% tax on his profits
On an Excel worksheet create model that includes an income statement. I recommend starting with your known values and assumptions u) calculating her revenue
c) calculating her costs
d) calculating her profit
e) from that profit, just take off 18%
Now please use that model to predict Ayesha's profit for a day when she sells 95 combos at $5.95 each.
Now use the same model to product Ayesha's profit for a day when she sells 112 combos at $5.50 each.
Which of the two options above is better for Ayesha?
image text in transcribed

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

Managerial Accounting The Cornerstone of Business Decision Making

Authors: Maryanne M. Mowen, Don R. Hansen, Dan L. Heitger

7th edition

978-1337116008, 1337116009, 1337115770, 978-1337516150, 1337516155, 978-1337115773

More Books

Students also viewed these Accounting questions

Question

Queue object is usec in FlexSim as a wait object True False

Answered: 1 week ago