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

Five little monkeys swinging in the tree song - You give me that bottom of the ninth quote - Pittman company is a small but growing - Rosaline romeo and juliet - Michelangelo ceiling tiles nz - Oh deer project wild - Cane creek scr 5v - Gartner magic quadrant for security awareness computer-based training - Liard gray plaid square cocktail ottoman - Explain the relationships between motivation emotion and behavior - Perpendicular planes in real life - Discussion: Issues Critical to Training and Safety - Classic books public domain - Me talk pretty one day analysis - Readiness for enhanced knowledge related to newborn care - Dc load line circuit - Overcoming barriers to change in nursing - Nike pricing strategy - Comptia security+ 501 objectives - Wk 7 forum 1 Brittney - Specific security mechanism - Country manager simulation toothpaste - Jb hi fi glendale - Gibson dunn vacation scheme - Bridging Tradition and Innovation in European Culture - Needed in 8 hours - Interview questions - 1.1 explain the importance of effective communication in customer service - Latin america and the caribbean david clawson pdf - What salesperson duty is vicki nguyen performing in the scenario described in the case? - Us liner cranberry pa - Geopolitical community and phenomenological community - Essay 2 A Rhetorical Analysis - Fast food restaurants - Obituaries isle of wight - Reply - How is heinz ketchup made - Probability and statistical inference 10th edition pdf - Brian tracy youtube self discipline - Shadow health musculoskeletal assessment - The outsiders chapter 7 8 summary - Swot and tows analysis pdf - Antifa manual found on evergreen college campus - Whirlpool 6th sense freezer manual - Malus ioensis 'plena growth rate - Nineteen measures of solvency and profitability - International marketing terpstra foley sarathy pdf - Coders strike back solution java - Continuities and changes of the silk road - Look into the word document attached only - Authentic leadership self-assessment questionnaire - The two major problems that transcription solves for the cell are - Why is the transportation industry cyclical in nature - System analysis and design final project - List of community concerns - Mgt351 week 4 - Association of professional chaplains code of ethics - Disconnect and reconnect licence vic - Colloidal silver ppm meter - Anthropology Discussion post - 2.03 save invest or spend quizlet - Energy flow in ecosystem ppt - Peer Reviewed article for recurrent UTI - The importance of mobile apps in the modern business environment - Economy Quiz - Rio de janeiro housing problems - Keynows - Casa de diseno case study solution - Posci personal knowledge reports - Why did kathy experience the altered sensation - Wk 1, IOP 470: DQ - Home by gwendolyn brooks answers - Phil 201 liberty university quiz 1 - Igcse travel and tourism revision notes - Estas faldas elegantes están de moda - Provide a 50-75 word discussion reply to the following post below. Finding opportunities in the Energy Industry - Weaknesses of fenty beauty - Etl audit table structure - Rizak meaning in punjabi - National pawnbrokers association uk - Ieee communications surveys & tutorials abbreviation - Anima Behavior - Experiment 4 blood typing experiment - Which of the following best characterizes jit systems - Case Study - What are the two major branches of statistics - Response paper - Worldventures policies and procedures - Research Questions - Variance of discrete probability distribution - I need 1500 words on Private Business School - HR downsizing - Sodium hydroxide + hydrochloric acid word equation - “mom, may i have a smart phone?” all of my friends have one” is an example of: - Hp elite x2 1012 g1 hdmi - Radiant efficiency of the luminous source depends on - What is the net torque about the axle - Evaluating instructional materials checklist - Paper of finance - You want to learn about your congresspersons voting record brainly