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 5 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 Change this cell for Goal Seek Important that the amount of Sandwich B equal units of Asince the she estimates selling the same amout of each Outputs Profit Per Month Goal Seek this value Calculations These need to be links 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