Introduction To Management Science Assignment Issue

K 302 Introduction To Management Scienceassignment Idue Onby Mon

K 302 Introduction To Management Scienceassignment Idue Onby Mon

K-302 – Introduction to Management Science Assignment – I Due on/by: Monday Points possible: 100 Instructions: a. Please answer all questions. b. Answers to each question must be on separate worksheets in one Excel file. c. This is an individual assignment – no group work. d. Submissions must be made via Assignments on OnCourse e. Failure to turn in the assignment will result in a Zero for this component Q1 Please answer all parts of Fagersta Steelworks: problem 3.18 from Chapter 3 in your text book. 3.18 a) is worth 5 points 3.18 b) is worth 8 points 3.18 c) is worth 7 points Q2 A company produces coffee makers at its two different plants, in South Bend, Indiana and Gary, Indiana. The cost of production (per unit) in South Bend and Gary are $400 and $ 360 respectively. Each plant can produce a maximum of 300 units per month. Inventory holding costs are assessed at $30 per unit in beginning inventory each month. The company estimates the demand for its product to be 300, 400 and 500 units respectively over the next three months and wants to be able to meet this demand at minimum cost. Assume starting inventory as 0 units. a. Formulate an LP model for this problem. (7 points) b. Implement your model in a spreadsheet and solve it. ( 7 points) c. What is the optimal solution? ( 3 points) d. How does the solution change if the each plant is required to produce at least 50 units per month in order to fulfil labor union agreements? ( 3 points) Q3 Please solve problem 3.24 from chapter 3 in your text book ( Oxbridge University computer laboratory staffing). 20 points a. Spreadsheet formulation including data, named ranges with a clear legend (8 points) b. Specifying all constraints and other required parameters in solver (8 points) c. Optimal solution (4 points) Q4 Best Lawn Trimmers produces two types of lawn trimmers: an electric model and a gas model. The company has received a large order for 30,000 electric trimmers and 15,000 gas model trimmers. The production infrastructure of the company consists of three departments: Production, Assembly and Packaging. The table below summarizes the hours of processing time available and the processing time required by each department for both types of trimmers. Hours required per trimmer Electric Gas Hours available Production 0..,000 Assembly 0..,000, Packaging 0..,000 The company makes its in-house electric trimmers for $55 and $85 for the gas model trimmers. A new vendor is willing to manufacture and supply the company with unbranded electric and gas trimmers according to Best Lawn Trimmers’ specifications for $67 and $95 respectively. How many electric and gas trimmers should Best Lawn Trimmers make and how many should they buy in order to meet the large order received, at the least cost? a. Formulate a linear programming model for this problem. ( 7 points) b. Create a spreadsheet model for this problem and solve it using Solver. (10 points) c. What is the optimal solution? (3 points) Q5 A ranch feeds cattle for Midwestern farmers and delivers them to processing plants in Topeka, Kansas and Tulsa, Oklahoma. The ranch must determine the amounts of cattle feed to buy so that various nutritional requirements are met while minimizing total feed costs. The mixture fed to the cows must contain different levels of four key nutrients and can be made by blending three different feeds. The amount of each nutrient (in ounces) found in each pound of feed is summarized as follows: Nutrient (in ounces) per pound of feed Nutrient Feed 1 Feed 2 Feed 3 A B C D The cost, per pound, of feeds 1, 2 and 3 are $2.00, $2.50 and $3.00 respectively. The minimum requirement per cow, each month is 4 pounds of nutrient A, 5 pounds of nutrient B and 1 pound of nutrient C and 8 pounds of nutrient D. However cows should not be fed more than twice the requirement of any given nutrient each month. The ranch, being a small one, cannot afford to buy more than 1,500 pounds of feed in any given month and, since there are usually 100 cows in a month, no more than 15 pounds of each type of feed can be used per cow each month. a. Identify the type of linear programming problem and justify your choice. (2 points) b. Formulate a linear programming model to determine how much of each type of feed a cow should be fed each month. ( 7 points) c. Create a spreadsheet model for this problem and solve it using Solver. (8 points) d. What is the optimal solution? (3 points) Good Luck!