Answered step by step
Verified Expert Solution
Question
1 Approved Answer
need help with this. step in excel would really be helpful 5. ABC company must determine what products they are going to buy from XRam
need help with this. step in excel would really be helpful 5. ABC company must determine what products they are going to buy from XRam (one of ther suppliers). XRam is an online sipplier and it is always pushing ABC to order products from them and then feature these products on ABC s website. ABC needs to decide about which products they should purchase from XB am Below are the details ABC has on these products: ABC can only buy complete items from XBam (non-fractional) amounts. ABC wants to maximize their profits from these items. They have a maximum space of 600 square feet for shipping and 1000 square feet for storing these items. There are only 20 hours of assembly time available. ABC needs to have at least 200 purchase points to qualify for free shipping ABC must order at least one of every product or XRam will not ship anything. However, there are only 30 Ram- Iets. Ram-Benches, and Ram-Tables available and there are only 20RamJams available. One last requirement ABC wants to meet is to ensure the sum of Ram-Iets and Ram-Tables will be at least 5 times the number of Ram-Benches they order. a) What would be the decision variables for this model? b) What would be the objective function for this model? c) What is the constraint to ensure the sum of Ram-Iets and Ram-Tables will bo at least S times the number of Ram-Benches they order? d) What is your optimal solution for this problem? Be sure to include ALL decision variables AND the total Profit
need help with this. step in excel would really be helpful
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