Question: Please include an Excel screen shoot for questions explanations, thank you. DancingRetro company produces clothing, footwear, and accessories for dancing and gymnastics. They produce three


Please include an Excel screen shoot for questions explanations, thank you.
DancingRetro company produces clothing, footwear, and accessories for dancing and gymnastics. They produce three models of pointe shoes used by ballerinas to balance on the tips of their toes. The shoes are produced from four materials: cardstock, satin, plain fabric, and leather. The number of square inches of each type of material used in each model of shoe, the amount of material available, and the profit/model are shown in Part III worksheet. Help company by formulating profit maximization model. Solve the model to optimality, generate the sensitivity report and answer the following questions: 1. What are the decision variables? 2. What is the objective function? 3. What are the constraints? 4. What is the optimal solution and what is the objective function value at the optimal solution? 5. Purchase department informed that any material can be obtained for $2 per square inch and maximum of 300 square inch is available for each material. Which material would you advise to purchase? Why or why not? DancingRetro company produces clothing, footwear, and accessories for dancing and gymnastics. They produce three models of pointe shoes used by ballerinas to balance on the tips of their toes. The shoes are produced from four materials: cardstock, satin, plain fabric, and leather. The number of square inches of each type of material used in each model of shoe, the amount of material available, and the profit/model are shown in Part III worksheet. Help company by formulating profit maximization model. Solve the model to optimality, generate the sensitivity report and answer the following questions: 1. What are the decision variables? 2. What is the objective function? 3. What are the constraints? 4. What is the optimal solution and what is the objective function value at the optimal solution? 5. Purchase department informed that any material can be obtained for $2 per square inch and maximum of 300 square inch is available for each material. Which material would you advise to purchase? Why or why not
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
