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

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

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Finance Questions!