What is the correct shipment strategy to maximize profit

Assignment Help Operation Management
Reference no: EM132286897

Optimization Problem Set

Notes:

1. This handout has 3 problems.

2. Please turn in your solutions in a Word document via Canvas.

3. Your solutions should contain a snapshot of your Excel model showing the optimal solution and all associated calculations as well as a screenshot of the completed solver setup dialog. The excel screenshot should clearly indicate the row and column headers and should contain formulatext() output to show all the calculations.

4. This is a group assignment and only one submission per group is required. However, I strongly recommend that you try to work on these problems individually before discussing them as a group. Try to come up with your own spreadsheet models, run solver and interpret the results on your own first. It will go a long way in helping you prepare for the exam.

Problem 1. The Truck Packing Problem: This is a simplified version of large-scale problems that trucking folks face on a daily basis. Atlas Transportation company needs to transport 2400 chairs and 1200 tables to a warehouse. Unfortunately, one truck cannot accommodate everything. So, the company is planning to use a small truck and a large truck to transport the furniture. The large truck will leave tomorrow and must have atleast 650 chairs and 35 tables. The small truck will leave the day after tomorrow.

The large truck can take weight of 100,000 lbs maximum while the small truck can carry 50,000 lbs. Each chair weighs 10 lbs while each table weighs 100 lbs. Every chair shipped tomorrow accrues $5, every table accrues $15; every chair shipped day after tomorrow accrues $4 and every table accrues $9. What is the correct shipment strategy to maximize profit?

Problem 2: Let's revisit the Acme transportation network optimization problem discussed in the class. Recall that Acme had three plants and was trying to determine how to satisfy the demand in ten markets from these three plants.

How would you model the following situations? Please include a screenshot of the model containing the optimal solution (clearly showing the changes you made with the corresponding formulatext where necessary) and a screenshot of the solver dialog for each part below.

a) Due to a recent tornado, no shipments can be made from Chicago and Atlanta to Indianapolis.

b) The products manufactured at the Atlanta plantmeet a higher safety standard and only these products can be sold in Fremont.

c) New York has a diverse market, and to cater to this diverse market, at least 20,000 products each must be shipped from the three plants to New York.

d) Due to a trade agreement with the Georgia government, the plant in Atlanta must ship at least 50,000 units outside of the state.

Problem 3: Please solve the following problem. I have not provided a template for this problem. Please make your own, using the Acmeproblem as a rough outline. As a good practice, please write down the business objective, decision variables and constraints in plain words, and then solve it in Excel.

Attachment:- Optimization Problem Set.rar

Reference no: EM132286897

Questions Cloud

Summarize a customer success story of an organization : In answer to the challenges Nelnet faces in servicing a growing volume of student loans, the company chose to deploy a knowledge management system called.
Estimates of income and cost : A printed circuit board manufacturer will construct a new plant. The potential sites have the following estimates of income and cost.
Supporting an organization business strategy : Suppose a manager asked you to determine whether training was supporting an organization’s business strategy.
Explain the canadian arts data : Explain the Canadian Arts Data (CADAC) and how the Identity Theft Enforcement and Restitution Act was formed? Explain Metadata Encoding and Transmission.
What is the correct shipment strategy to maximize profit : SCM 421 Supply Chain Analytics : The products manufactured at the Atlanta plantmeet a higher safety standard and only these products can be sold in Fremont.
Multinational enterprise can opt for cost leadership : One mistake many organizations make in offering training to employees is. In? principle, a multinational enterprise can opt for cost leadership or _____.
Explain in terms of the risk-return principle : When the two owners go to the local bank looking for a loan, which one is likely to get a lower interest rate? Explain in terms of the risk-return principle.
Criteria for an optimal currency area : Does current eurozone's fiscal policy model meet Robert Mundell's criteria for an optimal currency area?
Create predictive models from observation : Cognitive science uses an empirical approach to explore behavior and attempts to create predictive models from observation of how people really act and behave.

Reviews

Write a Review

Operation Management Questions & Answers

  Book review - the goal

Operations Management is about a book review. Title of the book is "Goal". This book has been written by Dr. Eliyahu Goldartt. The book has been appreciated by many as one of those books which offers an insight into the operations and strategic capac..

  Operational plan in hospitality enterprise

Operational plan pertaining to a hospitality enterprise is given in detail in the solution. The operational plan is an important plan or preparation which gives guidelines regarding the role and responsibilities of each and every operation at all lev..

  Managing operations and information

Recognise the importance of a strategic approach to the development and deployment of organisational information systems. Demonstrate an understanding of the importance of databases and their integration to the organisation's overall information mana..

  A make-or-buy analysis

An analysis of the holding costs, including the appropriate annual holding cost rate.

  Evolution and contributor of operations management

Briefly explain Evolution and contributor of Operations management.

  Functions and responsibilities of an operations manager

A number of drivers of change have transformed the roles, functions and responsibilities of an operations manager over recent years. These drivers have not only been based on technological innovations but also on the need for organisations to develop..

  Compute the optimal order quantity

Compute the Optimal Order quantity of DVD players. Determine the appropriate reorder point.

  Relationship to operations practice in the organisation

Evaluate problems in operations and identify approaches to overcoming them. Critically evaluate operating plans and identify areas for improvement. Justify, implement and evaluate changes to operations in line with modern approaches.

  A make or buy analysis

Develop a report for Figi Fabricating that will address the question of whether the company should continue to purchase the part from the supplier or begin to produce the part itself.

  Prepare a staffing plan

Prepare a staffing plan showing the change of your unit from medical/surgical staffing to oncology staffing.

  Leadership styles in different organizations

Ccompare the effectiveness of different leadership styles in different organizations

  Risk management tools and models

Be able to understand the concept of risk, roles and responsibilities for risk management and risk management tools and models.

Free Assignment Quote

Assured A++ Grade

Get guaranteed satisfaction & time on delivery in every assignment order you paid with us! We ensure premium quality solution document along with free turntin report!

All rights reserved! Copyrights ©2019-2020 ExpertsMind IT Educational Pvt Ltd