Question: Use Solver in Excel, i need screenshot about every step. Picture 1' 3 Shoe co manufactures three types of shoes. Demand for shoes is unlimited
Use Solver in Excel, i need screenshot about every step.
Picture 1' 3 Shoe co manufactures three types of shoes. Demand for shoes is unlimited and 40 hours per week of machine time and labor are available. A 4 pair of shoes yields the following profit and uses the number of minutes of machine time and labor given in the table below. Assuming the 5number of pairs of shoes made each week must be an integer, how can Shoe co maximize weekly profit? Note that by selecting your channg cells in the constraints, you can use the Int option to ensure that your changing cells assume integer values. Shoe 1 $40 40 Shoe 2 Shoe 3 $30 30 26 10Profit 12 13 14 Minutes machine time used 45 15 16 $25 20 25 Minutes labor used Sho Shoe2 Shoe3 17 Profit 18 labor used 19 time used 20 21 Profit $40.00$25.00 $30.00 30 40 20 25 23 Labor 24 Imt
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
