Using the least-squares regression method, estimate the variable cost per wedding and the total fixed cost per month. (Round off the variable cost per wedding to the nearest cent and the total fixed cost to the nearest dollar.)

The number of properties newly listed with a real estate agency in each quarter over the last four years is given below. Assume the time series has seasonality without trend. Quarter 1 2 3 4 Year 1 73 89 123 92 Year 2 81 87 115 95 Year 3 76 91 108 87 Year 4 77 88 120 97 a. Develop the optimization model that finds the estimated regression equation that minimize the sum of squared error. b. Solve for the estimated regression equation. c. Forecast the four quarters of Year 5. *Please solve in excel

For the following two alternatives, if the MARR is 10% per year (a)which one has a shorter payback period (b) which one do you select if you use the PW analysis. (c) is your selection different in (a) and (b)? Why? (d) use Spreadsheet to solve a and b. Alternative A: initial cost = $300,000 Revenue = $60,000 Alternative B: initial costs = $300,000 Revenue starts from n=1 at $10,000 and increases by $15,000 per year The expected life is 10 years for each alternative.

In this part of the project, you will be purchasing the home you chose in the Budget Project. You will need to obtain a loan from a financial institution since you cannot pay cash for your home. You will be researching three different loan scenarios and determining which loan option best fits your situation and needs. Purchase price of the home you chose from the Budget Project: ________$431,873______ Part 1: Financing your home Loan Scenario 1: In this scenario, your financial institution is offering you a 30-year fixed mortgage with a 20% down payment at a 3.43% fixed rate. Determine the following: Calculate the down payment for this loan. How much will you need to finance from the bank for this loan? What is your monthly payment?  Use technology or the monthly payment formula in your text to get the monthly payment for this loan. What is the total cost of the loan over 30 years? How much of this cost is interest? What is the total you will expect to pay at closing for this loan…