Hello, I need A lite bit of help wit this question. I need the answers in the excel sheet with the work so that I can see and understand the calculations. Please include the Excel Sheet with the work. Thank you very much.

Instruction:

A third-party company approached Hawley's management offering to assemble and test pendant lights for $27 per unit.

Use Excel to calculate Unit Profit for each product (in cells B8:J8) and Total Profit (in cell B19). Assume an advertising budget with a $18,000 limit - you do not need to redistribute the advertising budget for this part.

Run Excel Solver for this Tab to estimate the optimal production plan and produce another sensitivity report. Analyze the tactical and strategic information provided by the optimal solution.

Should the Hawley's management consider the offer? If yes, how much of pendant light units should be outsourced and how many units should be produced in-house.

\f