Data Modeling Question:

Imelda manages a shoe factory that makes two types of shoes: casual shoes and dress shoes. The factory can make a total of 1,000 pairs of shoes per day. On any given day, it cannot make more than 800 casual pairs of shoes. Each pair of casual shoes needs 2 units of labor, while each pair of dress shoes needs 3 units of labor. The factory has 2,400 units of labor available daily. Each pair of casual shoes earns a profit of $15, while each pair of dress shoes earns a profit of $20. How many pairs of each type should the factory make each day?

a Specify the decision variables

b Specify the objective. This must be based on the inputs specified in the problem, the decision variables specified in (a), and/or intermediate variables specified in (c) below.

c Specify the constraints. These must be based on the input numbers specified in the problem, the decision variables specified in (a), and/or intermediate variables that you chose to specify

d Build a model in Excel where you can specify values for the input variables and see the effects on the constraints and objective. Please note that your spreadsheet must be sufficiently annotated so that it is readable. Title it Exhibit 1.

e Please ensure that Exhibit 1 is well edited and appropriately formatted, which includes showing formulas and including row and column headings. To show formulas you can go to the Formula tab in Excel and find "show formulas" from the "Formula Auditing" section. Resize columns to maximize readability.

f Using your model, is it feasible to produce 500 pairs of casual shoes and 500 pairs of dress shoes? If no, why not? If yes, how do you read that from your model?

g What is the optimal production schedule? (Hint: you can use Excel Solver)