Goal Seek Problems: Solution Have to made in Excel file. Problem 1:Look into the following table: Price Unit Cost Fixed Cost $ 3.00 $ 0.45 $ 45,000.00 For given situation, how many glasses of lemonade does a lemonade store need to sell per year to break even? Problem 2:We want to pay off our mortgage in 15 years. The annual interest rate is 6%. The bank told us we can afford monthly payments of $2,000 for monthly payments. How much can we borrow? Problem 3: Maria drives 64 miles per hour toward her mother's home in Los Angeles. Two hours later after Maria leaves, Edmund starts journey by driving 80 miles per hour. How many miles will each person have traveled when Edmund catches Maria? Problem 4:1 am managing a conference at my college. My fixed costs are $15,000. I must pay the 10 speakers $700 each, and the college union $300 per conference participant for food and lodging costs. I am charging $900 to each conference participant who is not speaker. How many paid registrants need to attend for me to break even? Problem 5: Three electricians are wiring my new home. Electrician 1 by himself will need 11 days to do the job. Electrician 2 by himself will need 5 days to do the job. Electrician 3 by himself will need 9 days to do the job. If all the three electricians work on the job, how long the job take to complete?