PLEASE WRITE CONSTRAINTS IN STANDARD FORMAT

ALSO PLEASE USE THE TEMPLATE

M4.3 The Cullowhee Bicycle Shop (CBS) stocks three types of bicycle-road, cross-country, and mountain. CBS buys these bikes from a supplier to sell A road bike costs $1250, a cross-country cost $1300, and a mountain bike costs $950. CBS can spend up to $12.500 a month to restock their inventory. They sell road bike for $1900, a cross-country for $1800, and a mountain bike for $1300 Each bike must be assembled after they are delivered to the shop. The road be takes & hours to assemble, the cross-country takes 12 hours to assemble, and the mountain bike takes 16 hours to assemble. The employees have 120 hours of available time per month to assemble the bikes. The store has room to store 15 new bike purchases per month. CBS sells more road than cross-country bikes than mountain, so they want the ratio of cross-country to mountain bikes to be at least 2. CBS purchase at least 2 bikes of each type every month. Assume they can sell each bike they purchase from the supplier, how many of each bike should they purchase to maximize their profit? (Hint: Profit Revenue - Cost). Formulate and solve this problem in Excel SOLUTION: The optimal solution, the value of the profit, should be $5.508. Your answer will have a decision variable that is not an integer Formulation: Formulate this problem by defining decision variables, objective function, and constraints in standard format as specified/demonstrated in videos Questions a) How many road bikes should be purchased each month based on your optimal solution? b} How many cross-country bikes should be purchased each month based on your optimal solution? c) How many mountain bikes should be purchased each month based on your optimal solution? d) Are the budget or assembly constraints binding constraints based on your optimal solution? Explain. e Are the budget or assembly constraints slack constraints based on your optimal solution? Explain +) Are any of the constraints for minimum monthly purchase surplus constraints based on your optimal solution? Explain Use the LP Template.xlsx provided to you in the Module Documents & Files. Solve the problem using Excel Solver, place the formulation and answers to the questions in the appropriate text boxes. I will delete your decision variables in your Excel submission and re-solve your problem. There is no credit for the problem if your Excel submission doesn't solve. If necessary.remove problem constraints so that your Excel file solves. It is better to get partial credit than no credit. Your Excel Solver solution must result in the follow dialog box for full credit for the solution. Note the highlighted text. DV#1 DV#2 LHS Sign RHS Decision Variables Objective Function Coefficient Constraints: Constraint #1 Constraint #2 Constraint #3 Constraint #4 FORMULATION ANSWERS TO QUESTIONS (do not just put numbers. answers should be complete sentences) Decision Variables: a) Objective Function: b) Constraints: c)