Please answer the questions using excel formulas only. Most of the questions are straight forward but become challenging when you have to utilize the formula so please show all work using that

1. As an intern, your host company has tasked you with managing a conference it sponsors. The sponsor's fixed costs are $15000, and it has to pay $700 each to 10 speakers. In addition, it has to pay the venue $300 per conference participant for food and lodging. Each participant who is not a speaker will have to pay $900 to cover conference fee, food and lodging. How many paid conference participants must the conference sponsor have to break even? paid registrants speakers fixed cost Food and lodging costs/participant speaker fee registration fee/participant (non-speaker) 10 $ 15,000.00 $ 300.00 $ 700.00 $ 900.00 profit 0 Answer: The conference needs at least paid participants to break even. *********** 2. Before heading to college, Winston who just graduated from high school decided to earn some money by selling gourmet fruit juices in the neighborhood. He has invested $400 in equipment, fruit and supplies. Each glass will be sold for $4. His unit cost of production is $2.0. 2(a) Based on the information provided, how many glasses of juice must he sell to break even? 400 No. of Glasses Sold 200 fixed cost glasses sold price unitcost 4 2 revenue 0 costs profit Winston will have to sell glasses of juices to breakeven