Answered step by step
Verified Expert Solution
Question
1 Approved Answer
Advertising Budget Trade-Off How is the objective (profit) impacted by the additional advertising budget as compared to the profit shown in the Optimal Solution Tab?
Advertising Budget Trade-Off
How is the objective (profit) impacted by the additional advertising budget as compared to the profit shown in the Optimal Solution Tab? And, what is the impact to the product demand constraints (cells B28- B31)?
5 100% $% 0 .00 123- Default (ca. 12 Y BI & A - t-Hoc 13 fx Costs and prices: B C D E F G K M 1 Costs and prices: Ir = regular time; o = overtime 2 3 4 Co 5 6 Celling price Material costs Production costs Unit profit Table lamps (0) Floor lamps (6) Tr TO Fr FO 120 120 150 150 66 66 85 85 16 18 16 18 38 36 49 47 Department 1 Ceiling lamps (C) Pendant lamps (P) ar PT 100 100 160 160 50 50 80 80 12 15 12 15 38 35 68 65 Department 2 7 8 9 10 11 Decision Variables: FO 12 Po Tr 72960 Fr 20000 Cr 55000 CO 24000 Pr 35000 0 0 0 13 Units produced T F P 14 $18,000 $0 $0 $0 15 Advertising 16 Objective function: max (Profit) = $9,044,480 19 20 21 Constraints: 22 Capacity constraints: 23 Department 1 regular time 24 Department 1 overtime 25 Department 2 regular time 20 Department 2 overtime LHS RHS 92,960 100,000 25,000 90,000 90,000 24,000 24,000 tas SI plo, pu 16 17 Objective function: max (Profit) = 19 $9,044,480 20 21 LHS RHS 92,960 100,000 25,000 90,000 90,000 24,000 24,000 0 Constraints: 22 Capacity constraints: 23 Department 1 regular time 24 Department 1 overtime 25 Department 2 regular time 26 Department 2 overtime 27 Demand constraints: 28 Table lamps 29 Floor lamps 30 Ceiling lamps 31 Pendant lamps 32 33 Advertising constraint 34 72,960 72,960 20,000 20,000 79,000 100,000 35,000 35,000 $18,000 $18,000 35 36 37 38 an
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started