Loading...

Messages

Proposals

Stuck in your homework and missing deadline? Get urgent help in $10/Page with 24 hours deadline

Get Urgent Writing Help In Your Essays, Assignments, Homeworks, Dissertation, Thesis Or Coursework & Achieve A+ Grades.

Privacy Guaranteed - 100% Plagiarism Free Writing - Free Turnitin Report - Professional And Experienced Writers - 24/7 Online Support

Mat 540 week 8 assignment 1

01/01/2021 Client: saad24vbs Deadline: 12 Hours

Assignment 1. 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) deliverables, a short writeup of the project and the spreadsheet showing your work.


Writeup.


Your writeup 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.


Click here to view the grading rubric for this assignment.


The Rayhoon Restaurant:

Brayden and Behrad were roommates. They decided to open a restaurant in the small town that they were living. They bought an old home for their new restaurant which they named Rayhoon.

Not knowing the taste of their customers, they decided to serve only two full course meals each night, one with pork and the other with chicken.

They estimated that they would sell a maximum of 60 meals each night. Each chicken dinner requires 15 minutes to prepare, and each pork dinner takes twice as long. There is a total of 20 hours of kitchen staff labor available each day. They thought that they would sell at least 3 chicken dinners for every two pork dinners. They also believe that at least 10 percent of their customers will order pork dinners. The profit from each chicken dinner will be $12, and the profit from a pork dinner will be $16.

Formulate a linear programming model for B & B, that will help them estimate the number of meals they should prepare each night and solve this model by computer.

A. They are considering investing in some advertising to increase the maximum number of meals they serve. They estimate that if they spend $30 per day on a newspaper ad, it will increase the maximum number of meals they serve per day from 60 to 70. Should they make the investment?

B. They are concerned about the reliability of their kitchen staff. They estimate that on some evenings they could have a staff reduction of as much as 5 hours. How would this affect their profit level?

C. The final question they would like to explore is raising the price of the chicken dinner. Brayden has suggested a price increase that will increase profit for the chicken dinner to $14. Would this be acceptable, and how much additional profit would be realized?



Homework is Completed By:

Writer Writer Name Amount Client Comments & Rating
Instant Homework Helper

ONLINE

Instant Homework Helper

$36

She helped me in last minute in a very reasonable price. She is a lifesaver, I got A+ grade in my homework, I will surely hire her again for my next assignments, Thumbs Up!

Order & Get This Solution Within 3 Hours in $25/Page

Custom Original Solution And Get A+ Grades

  • 100% Plagiarism Free
  • Proper APA/MLA/Harvard Referencing
  • Delivery in 3 Hours After Placing Order
  • Free Turnitin Report
  • Unlimited Revisions
  • Privacy Guaranteed

Order & Get This Solution Within 6 Hours in $20/Page

Custom Original Solution And Get A+ Grades

  • 100% Plagiarism Free
  • Proper APA/MLA/Harvard Referencing
  • Delivery in 6 Hours After Placing Order
  • Free Turnitin Report
  • Unlimited Revisions
  • Privacy Guaranteed

Order & Get This Solution Within 12 Hours in $15/Page

Custom Original Solution And Get A+ Grades

  • 100% Plagiarism Free
  • Proper APA/MLA/Harvard Referencing
  • Delivery in 12 Hours After Placing Order
  • Free Turnitin Report
  • Unlimited Revisions
  • Privacy Guaranteed

6 writers have sent their proposals to do this homework:

Top Essay Tutor
Helping Hand
University Coursework Help
Writer Writer Name Offer Chat
Top Essay Tutor

ONLINE

Top Essay Tutor

I have more than 12 years of experience in managing online classes, exams, and quizzes on different websites like; Connect, McGraw-Hill, and Blackboard. I always provide a guarantee to my clients for their grades.

$85 Chat With Writer
Helping Hand

ONLINE

Helping Hand

I am an Academic writer with 10 years of experience. As an Academic writer, my aim is to generate unique content without Plagiarism as per the client’s requirements.

$80 Chat With Writer
University Coursework Help

ONLINE

University Coursework Help

Hi dear, I am ready to do your homework in a reasonable price.

$82 Chat With Writer

Let our expert academic writers to help you in achieving a+ grades in your homework, assignment, quiz or exam.

Similar Homework Questions

Fact finding techniques in database - FN week 6 - Criminal justice - How does bradbury create irony in his story the pedestrian - Broad crested weir formula - Discussion project - Ephesians 3 14 20 nlt - The hidden life of garbage essay - Compliance based ethics codes course hero - "A" WORK PLAGIARISM FREE IN 15 HOURS - Executive planet - Wiltshire council parking permit - Vle usw unicaf log in - What is ethics and diversity in social work? - Australian jazz fusion band from the 70s - Snap fitness penn ave minneapolis - Coulomb's law lab report - Letter of complaint hotel - Variant characteristics of culture - Nursing informatics - Major diseases afflicting the nervous system - Benchmark assignment risk and quality management paper - What are some shortcomings of the goal of profit maximization - Greek gods roman counterparts - Myhr performance capability and talent - Skin care lesson plans - Web server plugin for websphere application server - Diesel fire pump pressure relief valve - Food studies a level - Virat kohli and ab de villiers friendship - Upper canine access cavity - Global supply chain management simulation solution - Explain two goals of politicians when they gerrymander during redistricting - Al roker son nicholas autistic - MT 3 - Valuation of securities problems and solutions - SLP--ACCOUNTING COST SYSTEMS AND COST BEHAVIOR - Decrease in acid test ratio - Fire safety pass acronym - As 1926 swimming pool safety - Cultural approach to organizations - Network diagram for a college - Southern cross school of distance education - List the four possible subshells in the quantum-mechanical model. - The great gatsby argumentative essay - Finance Quiz 1 - John lewis partnership model disadvantages - Compilation of separate clips in a film crossword - Module 5 Homework - Foundation degree in person centred counselling - Research paper(Data mining) - Assignment 5 professional cover letter - Disney's design case study answers - Caboolture waste transfer station - Http faculty washington edu herronjc softwarefolder allelea1 html - Zuckerberg family photo leaked - How does stage hypnosis work - Bitterne ce primary school - Human sexuality forum - Case study on windows 7 operating system - What strategic business objectives do ups's - Mk 160 fire control system - Cap 1 M3 - Why does uv intensity change with latitude - Benchmark - Human Experience Across the Health-Illness Continuum - Ian wallace psychologist forestway - Biology for year 8 - Discussion - 24723 katy freeway katy tx 77494 - Fundamentals of Programming Assignment Option 1: PaSciRo Simulation - As 1170.1 table a2 - Puregym off peak hours greenwich - Code 3 tv show 1992 - Labor connections hickory north carolina - Mannerly margery milk and ale analysis - Books of original entry questions and answers pdf - Key concepts of confucian ethics - Asda case study - Walden university nurs 6541 final exam - What are the three types of endowments - Capstone Project Change Proposal Presentation for Faculty Review and Feedback - Dexter company applies the direct write-off method in accounting for uncollectible accounts. - How to analyze a quote - POWER POINT - Nursing care plan for cerebral palsy - Jasper jones charlie's mother - Analystsoft statplus mac le - Prepare a diagram 0 dfd for the new system - F4transkript free download full version - Service oriented software engineering ppt - Develop workplace policy and procedures for sustainability assessment 1 - What is the function of bandpass filter in a modulator - Hotel reservation system documentation doc - Sunrise model by madeleine leininger - EDU - Sophos virtual partner conference - Abbot davies balancing rein kit - Water supply and drainage system ppt - 250 words/ two scholarly sources due TODAY! - What atm can i use with hsbc australia