Linear programming case study

Assignment Help Case Study
Reference no: EM13669422

Linear Programming Case Study

Your instructor will assign a linear programming project for this assignment according to the following specifications. It will be a problem with at least three (3) constraints and at least two (2) decision variables. The problem will be bounded and feasible. It will also have a single optimum solution (in other words, it won't have alternate optimal solutions).

The problem will also include a component that involves sensitivity analysis and the use of the shadow price. You will be turning in two (2) deliverable, a short write up of the project and the spreadsheet showing your work.

Write-up:

Your write-up should introduce your solution to the project by describing the problem. Correctly identify what type of problem this is. For example, you should note if the problem is a maximization or minimization problem, as well as identify the resources that constrain the solution. Identify each variable and explain the criteria involved in setting up the model. This should be encapsulated in one (1) or two (2) succinct paragraphs.

After the introductory paragraph, write out the L.P. model for the problem. Include the objective function and all constraints, including any non-negativity constraints. Then, you should present the optimal solution, based on your work in Excel.

Explain what the results mean.

Finally, write a paragraph addressing the part of the problem pertaining to sensitivity analysis and shadow price.

Excel:

As previously noted, please set up your problem in Excel and find the solution using Solver. Clearly label the cells in your spreadsheet. You will turn in the entire spreadsheet, showing the setup of the model, and the results.

CASE:

Case analysis

1. After graduating from Tech Julia was unable to find regular employment and approached the Director of Athletics at Tech to request that she remain a vendor of the following year. The Director was so impressed by Julia's progress and professionalism from the year before he decided to allow her to continue to be a vendor for the next season with the following conditions and changes:

a. Julia must do a 70:30 split of all of her profits with the Department of Athletics. Julia also has the ability to sell soft drinks. If she decide to sell soft drinks, she must agree to a 60:40 split; however, the department will not provide any monetary funding. Julia's cost for the soft drinks are 55 cents, and she sells them for two dollars. She can expect to sell just as many soft drinks as all food items combined.

b. Julia must sell food from two (2) booths; however, she will pay the same price as she paid for one booth during the previous season.

c. The department of athletics is able to use the warming ovens owned by food services at no cost since all student athletes on scholarship have a meal plan. There are three (3) warming ovens available to Julia. The warming ovens are the same capacity as those used the previous season.

d. Julia has the same options available for the types of food to sell however, she is able to take advantage of a discount that the school receives from the same vendor she purchased the pizza, hot dogs and sandwiches from; the discount is 20%, 20% and 30% respectively.

e. Due to the operation of two (2) booths, Julia must hire at least two additional persons at the same rate as previously determined.

After paying off here loans from the previous season, she has $2750.00 in savings from a part-time job at the mall, which she is able to invest in the venture. If Julia clears at least $2000.00 in profit for each game after paying all her expenses, she believes it will be worth the partnership with the Department of Athletics.

Formulate and solve a linear programming model for Julia that will help you advise her on which offer to accept from the director if any. Julia's younger brother who is a freshman at Tech wants to help Julia increase her profits by loaning her some money using his school refund check. Her brother's only requirement is that she repays him by the end of the season and he is allowed to get into the games free by posing as one of her assistants and receiving free food for him and his girlfriend. If Julia decides to take him up on his offer, how much should she borrow, if anything?

What is your recommendation to Julia?

Reference no: EM13669422

Questions Cloud

Creates a simple arraylist : Creates a simple ArrayList
Find the rms current phase angle and rms voltage : Find the rms current, phase angle and rms voltage across R & L, in an RL circuit when a 58 Hertz 123 Volt rms ac voltage is applied, where R=1.80 kΩ and L=350 mH
What are search methods : What are search methods? Do you feel search methods are relevant to topics in artificial intelligence ? If yes, please explain why and how. Specifically, describe how search methods would be used for rule-based systems, expert systems, resolu..
Basic business skills play a role in your professional life : How will basic business skills play a role in your professional life?
Linear programming case study : Explain what the results mean - write a paragraph addressing the part of the problem pertaining to sensitivity analysis and shadow price.
The ceo throws a billion dollar party : The CEO throws a billion dollar party
Compute the force acting on the electron : In the Bohr model of the hydrogen atom, the speed of the electron is approximately 2.20 x 106 m/s. Compute the force acting on the electron as it revolves in a circular orbit of radius 5.30 x 10-11 meter
An adt called squarematrix : An ADT called SquareMatrix
Calculate what is his power output : A 685 N Marine in basic training climbs a 9.00 meter vertical rope at a constant speed in 6.00 second. Determine what is his power output

Reviews

Write a Review

 

Case Study Questions & Answers

  Obtain a copy of a written contract

Obtain a copy of a written contract that is available in Australia from the net or another source. For example you could download one of the many online contracts you are asked to agree to before accessing a site or entering an online contract.

  Express your views regarding diversity at workplace

Express your views regarding diversity at workplace, do you think it is a plus or a drag on the firm? Comment on how your organization manages, or, how, in general, organizations should manage diversity at work?

  Compare and analyse business plans

Implementation plan should be developed in as an ancillary document to the business plan listing each of the objectives and breaking down strategic initiatives into tasks with realistic timeframes

  Review evans and richardson

How specifically does economic of scale serves as a value for global branding? since higher volume doesn't necessarily translate into value for global acceptance of a brand

  Discussing the future adoption of technologies

You are to provide a one page essay for the following mini case questions (total of two pages) from the textbook. The essay is to be a 1.5 line spacing response to the following mini case.

  Explain why the communication skills and techniques used

Explain why conflict resolution communication skills are not always present in everyday workplace situationsand how a skilled communications professional wouldadd value to that workplace.

  Using the university of virginia uva case study

Using the University of Virginia (UVA) Case Study, Geithner & Bernanke, Amid the Global Financial Crisis, answer the following questions:

  Prepare a journal which records your activities and

demonstrate effective communication by composing writing that communicates ideas meaning andor argument in a format

  Find the coursework requirements

Each staff member can borrow up to 17 books, a postgraduate student 10 and undergraduate student 6. The limit for a member of the public is 6 books.

  How can zara maintain its competitive advantage

The Fundamental reasons for success, with a comparison to another successful and an unsuccessful company-how can Zara maintain its competitive advantage, here the concept of sustainability may be introduced

  Product design and global distribution

Watch an NBA quoteunquote team that's got this superstar that totally just wants to be the stud and doesn't work well with anybody else

  You are security analysis specialist and complete this

you are security analysis specialist and complete this assignment to pass the current module of current training

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