Answered step by step
Verified Expert Solution
Link Copied!

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)?

image text in transcribed

image text in transcribed

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

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Health And Safety Environment And Quality Audits

Authors: Stephen Asbury

3rd Edition

0815375395, 978-0815375395

More Books

Students also viewed these Accounting questions

Question

How does selection differ from recruitment ?

Answered: 1 week ago

Question

6. Conclude with the same strength as in the introduction

Answered: 1 week ago

Question

7. Prepare an effective outline

Answered: 1 week ago