Answered step by step
Verified Expert Solution
Link Copied!

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

image text in transcribedcould 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 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_2

Step: 3

blur-text-image_step3

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Students also viewed these Finance questions

Question

2. (1 point) Given AABC, tan A b b

Answered: 1 week ago