Mat 540 Assignment 1 Linear Programming Case Study

In: Business and Management

Submitted By coursehomework
Words 1301
Pages 6
MAT 540 ASSIGNMENT 1 LINEAR PROGRAMMING CASE STUDY
To purchase this visit following link: http://coursehomework.com/product/mat-540-assignment-1-linear-programming-case-study/ Contact us at:
HELP@COURSEHOMEWORK.COM
MAT 540 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,…...

Similar Documents

Mat 540 Week 8 Assignment 1 Linear Programming Case Study

...MAT 540 Week 8 Assignment 1 Linear Programming Case Study Click below link for Answer http://workbank247.com/q/mat-540-week-8-assignment-1-linear-programming-cas/4119 Click the link above to submit your assignment. Students, please view the "Submit a Clickable Rubric Assignment" in the Student Center. Instructors, training on how to grade is within the Instructor Center. 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,...

Words: 363 - Pages: 2

Linear Programming Case Study

...much is remaining? c) For the production combination of 800 bags of Lime and 600 bags of Vinegar, which resource is not completely used up and how much is remaining? d) Discuss: Slack (if any); shadow price, and sensitivity analysis results using the program of your choice. Above problem is a maximization problem as one is trying to maximize the profits by making different bags of chips. It takes salt, flour and herbs to make two different types of chips – Lime and Vinegar. There are constrained amounts of salt, flour and herb and the owner want to maximize his profits. The amount of profit per bag is given as well. The LP problem thus becomes: Maximize Profits from the sale of bags of both lime and vinegar chips Constraints: 1. Salt consumed should not exceed 4,600 2. Flour consumed should not exceed 9,400 3. Herbs consumed should not exceed 2,200 In mathematical terms, let’s say X1 to be the number of Lime bags and X2 to be the number of Vinegar bags. LP is: Maximize: 0.48 X1 + 0.59 X2 Subject to: 1.5X1 + 4 X2...

Words: 331 - Pages: 2

Mat 300 Assignment 1 Bottling Company Case Study

...MAT 300 Assignment 1 Bottling Company Case Study http://hwguiders.com/downloads/mat-300-assignment-1-bottling-company-case-study/ MAT 300 Assignment 1 Bottling Company Case Study Assignment 1: Bottling Company Case Study: Imagine you are a manager at a major bottling company. Customers have begun to complain that the bottles of the brand of soda produced in your company contain less than the advertised sixteen (16) ounces of product. Your boss wants to solve the problem at hand and has asked you to investigate. You have your employees pull thirty (30) bottles off the line at random from all the shifts at the bottling plant. You ask your employees to measure the amount of soda there is in each bottle. Note: Use the data set provided by your instructor to complete this assignment. Write a two to three (2-3) page report in which you: 1. Calculate the mean, median, and standard deviation for ounces in the bottles. 2. Construct a 95% Confidence Interval for the ounces in the bottles. 3. Conduct a hypothesis test to verify if the claim that a bottle contains less than sixteen (16) ounces is supported. Clearly state the logic of your test, the calculations, and the conclusion of your test. 4. Provide the following discussion based on the conclusion of your test: a. If you conclude that there are less than sixteen (16) ounces in a bottle of soda, speculate on three (3) possible causes. Next, suggest the strategies to avoid the deficit in the future. Or b.......

Words: 306 - Pages: 2

Mat 300 Assignment 1 Bottling Company Case Study

...MAT 300 Assignment 1 Bottling Company Case Study http://hwguiders.com/downloads/mat-300-assignment-1-bottling-company-case-study/ MAT 300 Assignment 1 Bottling Company Case Study Assignment 1: Bottling Company Case Study: Imagine you are a manager at a major bottling company. Customers have begun to complain that the bottles of the brand of soda produced in your company contain less than the advertised sixteen (16) ounces of product. Your boss wants to solve the problem at hand and has asked you to investigate. You have your employees pull thirty (30) bottles off the line at random from all the shifts at the bottling plant. You ask your employees to measure the amount of soda there is in each bottle. Note: Use the data set provided by your instructor to complete this assignment. Write a two to three (2-3) page report in which you: 1. Calculate the mean, median, and standard deviation for ounces in the bottles. 2. Construct a 95% Confidence Interval for the ounces in the bottles. 3. Conduct a hypothesis test to verify if the claim that a bottle contains less than sixteen (16) ounces is supported. Clearly state the logic of your test, the calculations, and the conclusion of your test. 4. Provide the following discussion based on the conclusion of your test: a. If you conclude that there are less than sixteen (16) ounces in a bottle of soda, speculate on three (3) possible causes. Next, suggest the strategies to avoid the deficit in the future. Or b.......

Words: 306 - Pages: 2

Mat 300 Assignment 1 Bottling Company Case Study

...MAT 300 Assignment 1 Bottling Company Case Study http://homeworkfy.com/downloads/mat-300-assignment-1-bottling-company-case-study/ To Get this Tutorial Copy & Paste above URL Into Your Browser Hit Us Email for Any Inquiry at: Homeworkfy@gmail.com Visit our Site for More Tutorials: (http://homeworkfy.com/ ) Assignment 1: Bottling Company Case Study Imagine you are a manager at a major bottling company. Customers have begun to complain that the bottles of the brand of soda produced in your company contain less than the advertised sixteen (16) ounces of product. Your boss wants to solve the problem at hand and has asked you to investigate. You have your employees pull thirty (30) bottles off the line at random from all the shifts at the bottling plant. You ask your employees to measure the amount of soda there is in each bottle. Note: Use the data set provided by your instructor to complete this assignment. Write a two to three (2-3) page report in which you: 1. Calculate the mean, median, and standard deviation for ounces in the bottles. 2. Construct a 95% Confidence Interval for the ounces in the bottles. 3. Conduct a hypothesis test to verify if the claim that a bottle contains less than sixteen (16) ounces is supported. Clearly state the logic of your test, the calculations, and the conclusion of your test. 4. Provide the following discussion based on the conclusion of your test: a. If you conclude that there are less than sixteen (16) ounces in a bottle of......

Words: 328 - Pages: 2

Mat 540 Assignment 1 Linear Programming Case Study

...MAT 540 Assignment 1 Linear Programming Case Study http://homeworkfy.com/downloads/mat-540-assignment-1-linear-programming-case-study/ To Get this Tutorial Copy & Paste above URL Into Your Browser Hit Us Email for Any Inquiry at: Homeworkfy@gmail.com Visit our Site for More Tutorials: (http://homeworkfy.com/ ) You are to solve Problem 30 in Chapter 4 on page 158 of your textbook. It’s about publishing three weekly magazines. You can use QM for Windows to perform a sensitivity analysis for Objective function coefficients and the RHS values of the constraints. Be sure give the shadow price/dual values for an extra hr of production time or an extra lb of paper. Be sure to follow instructions written for Assignment 1, Linear Programming Case Study. 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....

Words: 590 - Pages: 3

Mat 300 Assignment 1 Bottling Company Case Study

...MAT 300 Assignment 1 Bottling Company Case Study http://hwguiders.com/downloads/mat-300-assignment-1-bottling-company-case-study/ MAT 300 Assignment 1 Bottling Company Case Study Assignment 1: Bottling Company Case Study: Imagine you are a manager at a major bottling company. Customers have begun to complain that the bottles of the brand of soda produced in your company contain less than the advertised sixteen (16) ounces of product. Your boss wants to solve the problem at hand and has asked you to investigate. You have your employees pull thirty (30) bottles off the line at random from all the shifts at the bottling plant. You ask your employees to measure the amount of soda there is in each bottle. Note: Use the data set provided by your instructor to complete this assignment. Write a two to three (2-3) page report in which you: 1. Calculate the mean, median, and standard deviation for ounces in the bottles. 2. Construct a 95% Confidence Interval for the ounces in the bottles. 3. Conduct a hypothesis test to verify if the claim that a bottle contains less than sixteen (16) ounces is supported. Clearly state the logic of your test, the calculations, and the conclusion of your test. 4. Provide the following discussion based on the conclusion of your test: a. If you conclude that there are less than sixteen (16) ounces in a bottle of soda, speculate on three (3) possible causes. Next, suggest the strategies to avoid the deficit in the future. Or b.......

Words: 306 - Pages: 2

Mat 300 Assignment 1 Bottling Company Case Study

...MAT 300 Assignment 1 Bottling Company Case Study http://hwguiders.com/downloads/mat-300-assignment-1-bottling-company-case-study/ MAT 300 Assignment 1 Bottling Company Case Study Assignment 1: Bottling Company Case Study: Imagine you are a manager at a major bottling company. Customers have begun to complain that the bottles of the brand of soda produced in your company contain less than the advertised sixteen (16) ounces of product. Your boss wants to solve the problem at hand and has asked you to investigate. You have your employees pull thirty (30) bottles off the line at random from all the shifts at the bottling plant. You ask your employees to measure the amount of soda there is in each bottle. Note: Use the data set provided by your instructor to complete this assignment. Write a two to three (2-3) page report in which you: 1. Calculate the mean, median, and standard deviation for ounces in the bottles. 2. Construct a 95% Confidence Interval for the ounces in the bottles. 3. Conduct a hypothesis test to verify if the claim that a bottle contains less than sixteen (16) ounces is supported. Clearly state the logic of your test, the calculations, and the conclusion of your test. 4. Provide the following discussion based on the conclusion of your test: a. If you conclude that there are less than sixteen (16) ounces in a bottle of soda, speculate on three (3) possible causes. Next, suggest the strategies to avoid the deficit in the future. Or b.......

Words: 306 - Pages: 2

Mat 540 Week 8 Discussion Mat 540 Week 1 Discussion

...MAT 540 Complete Course MAT540 Complete Course Click Link for the Answer: http://workbank247.com/q/mat-540-complete-course-mat540-complete-course/22085 http://workbank247.com/q/mat-540-complete-course-mat540-complete-course/22085 MAT 540 Week 1 Discussion "Class Introductions"  Please respond to the following: * Please introduce yourself, including your educational and career goals, as well as some personal information about yourself. In your introduction, please draw from your own experience (or use a search engine) to give an example of how probability is used in your chosen profession. If you get your information from an online or other resource, be sure to cite the source of the information. MAT 540 Week 1 Homework Chapter 1 1. The Retread Tire Company recaps tires. The fixed annual cost of the recapping operation is $65,000. The variable cost of recapping a tire is $7.5. The company charges$25 to recap a tire. a. For an annual volume of 15, 000 tire, determine the total cost, total revenue, and profit. b. Determine the annual break-even volume for the Retread Tire Company operation. 2. Evergreen Fertilizer Company produces fertilizer. The company’s fixed monthly cost is $25,000, and its variable cost per pound of fertilizer is $0.20. Evergreen sells the fertilizer for $0.45 per pound. Determine the monthly break-even volume for the company. 3. If Evergreen Fertilizer Company in problem 2 changes the price of its fertilizer from $0.45 per pound to $0.55 per pound,......

Words: 15000 - Pages: 60

Mat 300 Assignment 1 Bottling Company Case Study

...MAT 300 ASSIGNMENT 1 BOTTLING COMPANY CASE STUDY To purchase this visit following link: http://coursehomework.com/product/mat-300-assignment-1-bottling-company-case-study/ Contact us at: HELP@COURSEHOMEWORK.COM MAT 300 ASSIGNMENT 1 BOTTLING COMPANY CASE STUDY MATH 300 Week 10 Assignment 1: Bottling Company Case Study Imagine you are a manager at a major bottling company. Customers have begun to complain that the bottles of the brand of soda produced in your company contain less than the advertised sixteen (16) ounces of product. Your boss wants to solve the problem at hand and has asked you to investigate. You have your employees pull thirty (30) bottles off the line at random from all the shifts at the bottling plant. You ask your employees to measure the amount of soda there is in each bottle. Note: Use the data set provided by your instructor to complete this assignment. Write a two to three (2-3) page report in which you: 1. Calculate the mean, median, and standard deviation for ounces in the bottles. 2. Construct a 95% Confidence Interval for the ounces in the bottles. 3. Conduct a hypothesis test to verify if the claim that a bottle contains less than sixteen (16) ounces is supported. Clearly state the logic of your test, the calculations, and the conclusion of your test. 4. Provide the following discussion based on the conclusion of your test: a. If you conclude that there are less than sixteen (16) ounces in a bottle of soda, speculate on three (3)......

Words: 701 - Pages: 3

Mat 300 Assignment 1: Bottling Company Case Study

...MAT 300 Assignment 1: Bottling Company Case Study Click Link Below To Buy: http://hwcampus.com/shop/mat-300-assignment-1-bottling-company-case-study/ Due Week 10 and worth 140 points Imagine you are a manager at a major bottling company. Customers have begun to complain that the bottles of the brand of soda produced in your company contain less than the advertised sixteen (16) ounces of product. Your boss wants to solve the problem at hand and has asked you to investigate. You have your employees pull thirty (30) bottles off the line at random from all the shifts at the bottling plant. You ask your employees to measure the amount of soda there is in each bottle. Note: Use the data set provided by your instructor to complete this assignment. Bottle Number Ounces Bottle Number Ounces Bottle Number Ounces 1 14.5 11 15 21 14.1 2 14.6 12 15.1 22 14.2 3 14.7 13 15 23 14 4 14.8 14 14.4 24 14.9 5 14.9 15 15.8 25 14.7 6 15.3 16 14 26 14.5 7 14.9 17 16 27 14.6 8 15.5 18 16.1 28 14.8 9 14.8 19 15.8 29 14.8 10 15.2 20 14.5 30 14.6 Write a two to three (2-3) page report in which you: 1. Calculate the mean, median, and standard deviation for ounces in the bottles. 2. Construct a 95% Confidence Interval for the ounces in the bottles. 3. Conduct a hypothesis test to verify if the claim that a bottle contains less than sixteen (16) ounces...

Words: 541 - Pages: 3

Mat-540 Week 8 Assignment 1

...MAT-540 WeeK 8 Assignment 1 http://homeworklance.com/downloads/mat-540-week-8-assignment-1/ You are to solve Problem 30 in Chapter 4 on page 158 of your textbook. It’s about publishing three weekly magazines. You can use QM for Windows to perform a sensitivity analysis for Objective function coefficients and the RHS values of the constraints. Be sure give the shadow price/dual values for an extra hr of production time or an extra lb of paper. Be sure to follow instructions written for Assignment 1, Linear Programming Case Study. 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......

Words: 556 - Pages: 3

Mat-540 Week 8 Assignment 1

...MAT-540 WeeK 8 Assignment 1 http://homeworklance.com/downloads/mat-540-week-8-assignment-1/ You are to solve Problem 30 in Chapter 4 on page 158 of your textbook. It’s about publishing three weekly magazines. You can use QM for Windows to perform a sensitivity analysis for Objective function coefficients and the RHS values of the constraints. Be sure give the shadow price/dual values for an extra hr of production time or an extra lb of paper. Be sure to follow instructions written for Assignment 1, Linear Programming Case Study. 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......

Words: 556 - Pages: 3

Mat 300 Assignment 1 Bottling Company Case Study

...MAT 300 Assignment 1 Bottling Company Case Study http://hwguiders.com/downloads/mat-300-assignment-1-bottling-company-case-study/ MAT 300 Assignment 1 Bottling Company Case Study     Assignment 1: Bottling Company Case Study: Imagine you are a manager at a major bottling company. Customers have begun to complain that the bottles of the brand of soda produced in your company contain less than the advertised sixteen (16) ounces of product. Your boss wants to solve the problem at hand and has asked you to investigate. You have your employees pull thirty (30) bottles off the line at random from all the shifts at the bottling plant. You ask your employees to measure the amount of soda there is in each bottle. Note: Use the data set provided by your instructor to complete this assignment.     Write a two to three (2-3) page report in which you: 1. Calculate the mean, median, and standard deviation for ounces in the bottles. 2. Construct a 95% Confidence Interval for the ounces in the bottles. 3. Conduct a hypothesis test to verify if the claim that a bottle contains less than sixteen (16) ounces is supported. Clearly state the logic of your test, the calculations, and the conclusion of your test. 4. Provide the following discussion based on the conclusion of your test: a. If you conclude that there are less than sixteen (16) ounces in a bottle of soda, speculate on three (3) possible causes. Next, suggest the strategies to avoid the deficit in the future. Or b.......

Words: 306 - Pages: 2

Mat-540 Week 8 Assignment 1

...MAT-540 WeeK 8 Assignment 1 Follow Below Link to Download Tutorial http://homeworklance.com/downloads/mat-540-week-8-assignment-1/ For More Information Visit Our Website ( http://homeworklance.com/ ) Email us At: Support@homeworklance.com or lancehomework@gmail.com You are to solve Problem 30 in Chapter 4 on page 158 of your textbook. It’s about publishing three weekly magazines. You can use QM for Windows to perform a sensitivity analysis for Objective function coefficients and the RHS values of the constraints. Be sure give the shadow price/dual values for an extra hr of production time or an extra lb of paper. Be sure to follow instructions written for Assignment 1, Linear Programming Case Study. 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......

Words: 581 - Pages: 3