Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

I don't understand how to start this question using excel and set it up in excel in this Linear Programming problem. How do I enter

image text in transcribed

I don't understand how to start this question using excel and set it up in excel in this Linear Programming problem. How do I enter the data on excel so I can solve this question? (constraints, decision variables, etc.)

image text in transcribed
`` Assignment 9 - Lined X \EL Winter 2019 Linear P X Linear Programming X| [ LP Product Mix using X| G homework help - Go X| Course Hero X + X > D & https: / / learn . macewan . ca / blocs web dav / pid - 205 5640 - at- content- rid - 8394529 _ 1 / courses / 005214 - 07- 2191 - 1 - CC07 - 71220 / Winter % 2020 1 9 % 20 Linear % 2 . O : {} Apps ! [ Office My Account ) https : / / support 2 . se .\ DO You Tube [ @) Fitness Blender * How to Clean a Flat ." \ Project Wild Wands ." - How to repair eyela ." No More Girly Fitne . Decision 4 : Operations and Marketing - Product Mix Richelieu Specialty Paints has received a special order for two types of paints : Marine Coat , used on* boats and Blocker , used on items that receive a great deal of strong , hot sun . Both paints use a UV* blocking additive and a mold inhibitor . Richelieu currently has 240 litres of the mold inhibitor on hand and 300 litres of the UV blocking additive . Blocker Marine Coat Mold Inhibitor Used ( litres per can ) 0 . 4 0 . 6 UV Blocking Additive Used ( litres per can ) 1 0 . 5 CM per can $5. 00 $4. 00 The special- order customer has requested at least 200 cans of Marine Coat but will take up to 450 cans* if available . The customer will take as much Blocker paint as Richelieu can provide . Amanda would like* to generate the highest contribution margin possible for this order and needs to know how much of each product should be made ." Additionally , she would like to see a graphical depiction of the constraints in this situation , because she is a visual learner and she feels this will help her understand the situation better ." Instructions for the graph :" This can be done by hand and then scanned and pasted into the memo or plotted in Excel and pasted in the memo . If done by hand it must be neat , on graph paper , and completed using a straightedge to draw the lines . Please plot Blocker on the X axis and Marine Coat on the Y axis . The graph must be labelled appropriately and show the feasible region and the optimal solution . ENG

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

Mathematical Interest Theory

Authors: Leslie Jane, James Daniel, Federer Vaaler

3rd Edition

147046568X, 978-1470465681

Students also viewed these Finance questions