Answered step by step
Verified Expert Solution
Question
1 Approved Answer
5 questions that require the use of SOLVER on Excel to determine the answers. May sure to show work to the Constraints All answers (Formula)
5 questions that require the use of "SOLVER" on Excel to determine the answers. May sure to show work to the "Constraints"
All answers (Formula) should be in the Excel worksheet attached.
The Electrocomp Corporation manufactures two electrical products: air conditioners and large fans. The assembly process for each is similar in that both require a certain amount of wiring and drilling. Each air conditioner takes 3 hours of wiring and 2 hours of drilling. Each fan must go through 2 hours of wiring and 1 hour of drilling. During the next production period, 240 hours of wiring time are available and up to 140 hours of drilling time may be used. Each air conditioner sold yields a profit of $25. Each fan assembled may be sold for a $15 profit. Use SOLVER to find the number of air conditioners and fans to produce in order to maximize profit. Variables Units to Produce Objective Function Constraints: Air Cond. Fans There should be at least six ads on TV or radio or some combination of those two. >The amount spent on billboards and newspapers together must not exceed the amount spent on TV ads. >No type of ad may be used more than 10 times. >The monthly budget for advertising has been set at $14,000. How many ads of each type should be placed to maximize the total number of people reached? (Do not round) TV Cost per Ad Reach per Ad $ 800 $ 30,000 TV Number to Air Objective Function Constraints: Radio 400 $ 22,000 Radio Billboards Newspapers 500 $ 100 24,000 8,000 Billboards NewspapersStep by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access with AI-Powered 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