Finance assignment, business and finance homework help

Need help completing a finance assignment. Excel File provided. All answers require a formula and it needs to show the formula AND explain to the professor how these answers were obtained. EACH QUESTION REQUIRES AN INTERPRETATION AND CONCLUSION.

NOTE: I KNOW THAT THERE ARE ANSWERS ONLINE FOR THESE QUESTIONS, HOWEVER, THEY DO NOT SHOW THE FORMULAS, WHICH IS WHY I’M PAYING YOU TO FIGURE IT OUT AND ACTUALLY DO THE WORK. IF YOU CAN’T COMPLETE IT WITHOUT PLAGARIZING, DON’T WASTE MY TIME- I CAN GOOGLE, COPY AND PASTE JUST LIKE YOU.

THE FILE TO COMPLETE Q1 IS ATTACHED. I EXPECT YOU TO COMPLETE EVERYTHING IN A SEPARATE SPREADSHEET WITH ORIGINAL WORK AND CALCULATIONS AND EXPLANATIONS.

ASSIGNMENT:

Q1: Consider the data in the Excel file “Nuclear Power”. Use simple linear regression to forecast the data. What would be the forecasts for the next 3 years?

Q2: Valencia Products make automobile radar detectors and assembles two models: LaserStop and SpeedBuster. The firm can sell all it produces. Both models use the same electronic components. Two of these can be obtained only from a single supplier. For the next month, the supply of these is limited to 4,000 of component A and 3,500 of component B. The number of each component required for each product and the profit per unit are given in the table.

COMPONENTS REQUIRED/UNIT

…………………………..A………B……….PROFIT/UNIT

LASERSTOP………18………6……….$24

SPEEDBUSTER….12……..10………$40

a. Identify the decision variables, objective function, and constraints in simple verbal statements.

b. Mathematically formulate a linear optimization model.

Q3: Implement the linear optimization model that you developed for Valencia Products in Q2 in Excel and use Solver to find an optimal solution. Interpret the Solver Answer report and identify the binding constraints and verify the values of the slack variables by substituting the optimal solution into the model constraints.