(Solved): Objective: Maximize Total Estimated Profit from Production (of the 3 differen models of Skateboards ...

Objective: Maximize Total Estimated Profit from Production (of the 3 differen models of Skateboards) Changing Cells: Determine the OPTIMAL mix of production for all 3 skateboard models given the 3 constraints below (Hint: Row 5) Constraints: ADD these 3 constraints (Hint: use RANGES of Cells!) • Optimal Product Production Levels can not exceed the maximum production levels for all 3 products individually • The Minimum Production Levels must be taken into consideration for all 3 products individually • The automatically calculated # of BOM (Bill of Materials) component Parts "Required" for production must not exceed the Beginning Inventory Available quantities on a per-part basis Now SOLVE AND "Keep Solver Solution" by clicking OK to preserve/save/update the results so as to answer the REST of the questions for this portion of the Homework correctly NOTE: If it does not SOLVE - then you need to work on it/fix it MY MAIN QUESTIONS IS WHAT IS THE CELL IS THE OBJECTIVE, WHAT CELLS SHOULD CHANGE AND WHAT ARE THE CONSTRAINTS AND WHAT CELL RANGES ARE THEY?