Answered step by step
Verified Expert Solution
Question
1 Approved Answer
could you please explain/show how to do these questions whilst using excel? Suzy's sister, Sandy, wants to sell sandwiches from a truck she will name
could you please explain/show how to do these questions whilst using excel?
Suzy's sister, Sandy, wants to sell sandwiches from a truck she will name "Sandy's Wiches." She figures half her customers will order the $5 sandwich, half will order the $7 sandwich. Each sandwich will cost her $1 to make (there are slight differences in costs but not enough to worry about). Her truck, equipment, and supplies will cost $36,000 per year in fixed costs plus she want to make $2,000 per month profit for her own income. How many sanwiches per day will she need to sell to break even if she is willing to work 6 days a week? Parameters Sandwich A Price Sandwich B Price Sandwich cost/unit Fixed Costs Target Monthly Profit Inputs Sandwich A Units/Day Sandwich B Units/Day Workdays Outputs Profit Per Month Calculations Sandwich A Price Sandwich A Units Sandwich cost/unit Revenue Sandwich A Sandwich B Price Sandwich B Units Sandwich cost/unit Revenue Sandwich B Daily Sandwich Revenue Workdays Annual Revenue Fixed Costs Monthly ProfitStep 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