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?
specify the decision variables.

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.

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.

build a model in excel where you can specify values for the input variables and see the effects on the constraints and objective. note that in order to receive credit, your spreadsheet must be sufficiently annotated so that it is readable. fit it to one page; if necessary, use landscape orientation to print and title it exhibit 1.

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 either go to the formula tab in excel and find "show formulas" from the "formula auditing" section or use the short cut key: ctrl + ` (note the grave accent key). you may need to resize some of the columns to maximize the readability.

to include row and column headings, there are multiple approaches. if you are using print screen to capture a picture of your model - then the column and row headings are there. if you are printing your model to a printer or a file, then you need to go to the "page layout" tab, there under the "sheet options" section you will find a check box for "print" under "headings". make sure to select to print the headings.

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?

according to excel solver, what is the optimal production schedule?