+1 (208) 254-6996 [email protected]
  

Problem 1

SOLVE THE FOLLOWING NON-LINEAR PROBLEM USING SOLVER
YOU HAVE TO INSERT THE FORMULAS IN GREEN CELLS
MARKETING COSTS ARE HIGHLIGHTED IN RED IN CELLS C20 AND D20
INSERT THE FORMULA FOR MARKETING COST IN CELL C19 AND D19
Problem With Nonlinear Marketing Costs
Doors (D) Windows (W) Range Name Cells
Unit Profit (Gross) $4 $6 DoorsProduced C12
Hours Hours GrossProfitFromSales H12
Hours Used Per Unit Produced Used Available HoursAvailable G7:G9
Plant 1 1 3 <= 8 HoursUsed E7:E9
Plant 2 5 2 <= 14 HoursUsedPerUnitProduced C7:D9
MarketingCost C14:D14
TotalMarketingCost H14
Doors Windows TotalProfit H16
Units Produced 0.000 0.000 Gross Profit from Sales UnitProfit C4:D4
UnitsProduced C12:D12
Marketing Cost Total Marketing Cost WindowsProduced D12
D^3 2*W^2
Total Profit

Problem 2

Daily price of Disney stock and NYSE are gi

Order your essay today and save 10% with the discount code ESSAYHELP