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.)
`` 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
