Question: Can some help answer these questions? I also need excel sheet of how you solved it. Thank you Applied Business Applications 4. A logistics company

Can some help answer these questions? I also need excel sheet of how you solved it. Thank you Applied Business Applications

4. A logistics company is operating two warehouses to manage the inventory of XYZ product. The current inventory level of XYZ product in each warehouse is: Warehouse Inventory (in units) 140 2 150 The company serves three geographically separate markets and must satisfy all orders. The demand from each market is: Market Demand in units) 1 110 2 70 3 100 The cost of shipping one unit on each route is (in dollars): From Warehouse 1 Warehouse 2 Market 1 8 12 Market 2 15 5 Market 3 6 14 The company wants to determine how many units to ship from each warehouse to each market to minimize the total shipping cost. a. (5 points) Draw a network diagram for the problem. b. (10 points) Formulate the problem into a LP model. c. (10 points) What is the optimal solution, and what is the optimal objective function value? Use Excel Solver. Provide your answer and sensitivity reports in separate worksheets). Optimal solution: Optimal objective function value

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer

Step: 1 Unlock blur-text-image

Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock

Step: 3 Unlock

Students Have Also Explored These Related General Management Questions!

1. What is the evaluation you need to perform about Medinas Health: Building a Medical Equipment Marketplace? 2. What questions will help you explore the evaluation above? 3. Choose ONE analytic...

I am doing tax return project. attachments are the materials professor provide. He wants me to do a current year engagement file (Similar with prior year engagement file). AC 371 Tax Return Project...

Please help answer the questions. I did look at the textbook solutions but someone answered it wrong. Please don't copy and paste the answers from there thank you. Baldwin Bicycle Company This case...

5. Focusing on the sellers, assess the benefits and challenges of competing on the Amazon marketplace. Should sellers expand beyond the Amazon marketplace? 6. Imagine being an advisor to Hank Harris....

Please answer the questions on M1 Rubric document 3 pgs and essay format about the document attached. Include excel about data listed in rubric. You don't have to read the whole document just skim...

Use the readings to help answer the questions on the last page. Thank you. CASE V Automotive Headlamps II: The Paradigm Shift from Standardized Glass Sealed Beams to Today's Plastic Custom Designs...

I need help answering the questions and also explanation on how you get the answer You work for Thunderduck Custom Tables Inc. This is the first month of operations. The company designs and...

Help needed please answer all the questions need it in excel format Thank you Please Answer all questions its needed in excel format the first one I posted was a bit mixed up Thank you CASE ANALYSIS...

please i need help answering questions(type out answer) Read SouthPark IV case study which can be purchased from Harvard Business Publishing at this Consider the following questions as you read the...

Please help with a-d on the required section attached Please help answer the questions a - d for Walmart on the attached. Thank you Grow Tunel Ulestaurants 1.496 0.1% INTEGRATIVE CASE 4.1...

Read the article Forms of Transformation Systems After reading the articles, select 1 article relating to your key topic that you wish to use in your thread. Adhere to the following format: 1. Key...

On January 1, 2012, Hanks Company leased a copy machine with an integrated laser printer from Officeneeds, Inc. The five-year lease is noncancelable and requires monthly payments of $200 at the end...

Which of the following is not a component of the Portfolio Management, Monitoring and Market Review process for private clients? Question 1 7 options: Accountability. Measure performance....

When older adults have difficulty with transportation and communication, or may be reluctant to request needed assistance to which they are entitled, they may be in need of: Group of answer choices...