Answered step by step
Verified Expert Solution
Link Copied!

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 image text in transcribed
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

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

Students also viewed these Accounting questions