PLEASE INCLUDE EXCEL FORMULAS. THANK YOU! :)

Problems appear at the end of each chapter. This problem merely asks you formulate & solve Problem 2-13 in the attached spreadsheet (no algebra/graph necessary). Please change the last clause of the last sentence: "while also ensuring that it makes at least five times as many His chairs as Hers chairs." In addition, highlight the binding (tight) constraints (see Ch. 2 handout) at the optimal solution. Oakton Rockers CRump: Ensure that Oakton makes at least five times as many His chairs as Hers chairs. Total His (M) $10.00 Hers (F) $12.00 Profit Quantity Minimum Resource Legs Rockers Short Dowels Long Dowels Amount Required His Hers 4 4 2 2 4 8 8 4 Available 900 400 1,200 1,056