Exercise 1 (from Superprof) A store has requested a manufacturer to produce pants and sports jackets. For materials, the

[answerhappygod]

Exercise 1 (from Superprof)
A store has requested a manufacturer to produce pants and sports
jackets.
For materials, the manufacturer has of cotton textile
and of polyester. Every pair of
pants (1 unit) needs of cotton
and of polyester. Every jacket
needs of cotton
and of polyester. The price of
the pants is fixed at $50 and the jacket, $40. What is the number
of pants and jackets that the manufacturer must give to the stores
so that these items obtain a maximum sale?
Save all the Solver Reports
Answer the following Questions in your spread sheet on the same
spreadsheet where you entered your data:
I put everything in solver and it came with an error of the
objective function not having a formula.
File G7 A 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 12 Point Home Insert ▾ I x B A Sheet1 + Accessibility Cood to go Draw Page Layout fx D Objective Function MAX 50 P+40*J Constraints 1*1.5*) 2*P+1*P P.J. C Formulas Data E F < € RHS Review View G 750 1000 0 LHS 0 Help H Cell References 0 13+1.5*13 02*13+J3 Power Pivot I P K I M O Ma N SG$7 O Value of J Solver Parameters Sat Objective: TA: Ⓒ Max By Changing Variable Cells $1$4:$193 Subject to the Constraints: 5G512 56$13-$F$12 SFS13 $153:5053 >=0 Add Change Ecleta Reset All Load/Save Make Unconstrained Variables Non-Negative Select a Saling Method: Simplex LP Sclving Method Select the CRG Nonlinear engine for Solver Problems that are smooth nonlinear. Select the LP Simplex engine for lineer Solver Problems, and select the Evolutionary engine for Solver problems that are non-smooth Hep Salve A P 0 0 P A Comments Share R 5 TA 100%