Help with excel formulas and solver constraints? Thanks

Maximize Profit, Capacity Constraint Part I: The Abel Skateboard Company manufactures skateboards. They have identified four customer segments, two that are willing to pay a higher price for a customized skateboard, and the other two are more price-sensitive and are willing to take a standardized skateboard. Price Demand Revenue Mfg Cost Profit Type Customi Custom2 Standard1 Standard2 TOT Demand for the two segments is: Custom1: 19,000 13.5 x Price Custom2: 18,000 - 15 x Price Standard 1: 26,000 - 32 x Price Standard2: 20,000 - 34 x Price Manufacturing cost per skateboard is: Custom 1: $550 Custom2: $500 Standard 1: $375 Standard2: $325 Max Demand 22,000 Manufacturing Cost Custom 1 $550 Custom2 $500 Standard1 $375 Standard2 $325 Demand per Type 19000 - 13.5 x Price Custom2 18000 - 15 x Price Standard1 26,000 - 32 x Price Standard2 20,000 - 34 x Price Customi Use the first 4 tab/worksheets of the M06_Homework_Template spreadsheet to run a Solver model to determine what price the Abel Skateboard Company should charge each segment under the following scenarios: (8 points each) 1. Manufacturing capacity is limited to 22,000 skateboards, and the company wishes to maximize profit. fill the decision variable cells with yellow, and the objective variable cell with light yellow. Fill in all boxes Maximize Profit, Capacity Constraint Part I: The Abel Skateboard Company manufactures skateboards. They have identified four customer segments, two that are willing to pay a higher price for a customized skateboard, and the other two are more price-sensitive and are willing to take a standardized skateboard. Price Demand Revenue Mfg Cost Profit Type Customi Custom2 Standard1 Standard2 TOT Demand for the two segments is: Custom1: 19,000 13.5 x Price Custom2: 18,000 - 15 x Price Standard 1: 26,000 - 32 x Price Standard2: 20,000 - 34 x Price Manufacturing cost per skateboard is: Custom 1: $550 Custom2: $500 Standard 1: $375 Standard2: $325 Max Demand 22,000 Manufacturing Cost Custom 1 $550 Custom2 $500 Standard1 $375 Standard2 $325 Demand per Type 19000 - 13.5 x Price Custom2 18000 - 15 x Price Standard1 26,000 - 32 x Price Standard2 20,000 - 34 x Price Customi Use the first 4 tab/worksheets of the M06_Homework_Template spreadsheet to run a Solver model to determine what price the Abel Skateboard Company should charge each segment under the following scenarios: (8 points each) 1. Manufacturing capacity is limited to 22,000 skateboards, and the company wishes to maximize profit. fill the decision variable cells with yellow, and the objective variable cell with light yellow. Fill in all boxes