MGNT 3150 Management Science <\/p>\n
Homework Assignment 1<\/p>\n
Topic Questions Value<\/p>\n
Chapter 1 Question 1 5 points<\/p>\n
Question 2 5 points<\/p>\n
Chapter 2 Question 3 6 points<\/p>\n
Question 4 9 points<\/p>\n
Question 5 12.5 points<\/p>\n
Chapter 3 Question 6 12.5 points<\/p>\n
Chapter 4*<\/p>\n
Question 7 or Question 8 (Choose one)* 12.5 points<\/p>\n
Chapter 7 Question 9 12.5 points<\/p>\n
Total Questions 75 points<\/p>\n
* You need to answer only Question 7 or Question 8 for Chapter 4.<\/p>\n
You MUST submit your file as a ONE .doc or .pdf file. Other formats (.jpeg, .png, etc.) will not be accepted.<\/p>\n
Chapter 1: An Introduction to Management Science<\/p>\n
Question 1 (5 points): Micromedia offers computer training seminars on a variety of topics. In the seminars each student works at a personal computer, practicing the particular activity that the instructor is presenting. Micromedia is currently planning a two-day seminar on the use of Micro- soft Excel in statistical analysis. The projected fee for the seminar is $600 per student. The cost for the conference room, instructor compensation, lab assistants, and promotion is $9600. Micromedia rents computers for its seminars at a cost of $120 per computer per day.<\/p>\n
Develop a model for the total cost to put on the seminar. Let x represent the number of students who enroll in the seminar. (1 point)<\/p>\n
9600 + (2*120x) = 9600+ 240x<\/p>\n
Develop a model for the total profit if x students enroll in the seminar. (1 point)<\/p>\n
600x \u2013 (9,600 + 240x)= 360x – 9600<\/p>\n
Micromedia has forecasted an enrollment of 30 students for the seminar. How much profit will be earned if their forecast is accurate? (1.5 points)<\/p>\n
360 (30) \u2013 9,600 = $1,200<\/p>\n
d.Compute the breakeven point. (1.5 points)<\/p>\n
total revenue = total cost<\/p>\n
9,600 + 240x= 600x<\/p>\n
360x= 9,600 <\/p>\n
X= 26.66\u2026(27)<\/p>\n
Question 2 (5 points): Preliminary plans are under way for the construction of a new stadium for a major league baseball team. City officials have questioned the number and profitability of the luxury corporate boxes planned for the upper deck of the stadium. Corporations and selected individuals may buy the boxes for $300,000 each. The fixed construction cost for the upper- deck area is estimated to be $4,500,000, with a variable cost of $150,000 for each box constructed.<\/p>\n
What is the breakeven point for the number of luxury boxes in the new stadium? (2.5 points)<\/p>\n
Profit on each box = (300,000 \u2013 150,000) = $150,0000<\/p>\n
Breakeven point = $4,500,000 = 30 boxes<\/p>\n
$150,000<\/p>\n
Preliminary drawings for the stadium show that space is available for the construction of up to 50 luxury boxes. Promoters indicate that buyers are available and that all 50 could be sold if constructed. What is your recommendation concerning the construction of luxury boxes? (1.25 points) What profit is anticipated? (1.25 points)<\/p>\n
Total revenue \u2013 Total expenses= Profit<\/p>\n
= 50 boxes \u2013 30 boxes (break- even point) = 20 boxes<\/p>\n
= 20 X $150,000 = $3,000,000 in sales<\/p>\n
The marginal profit is positive, so the construction should be continued.<\/p>\n
Chapter 2: An Introduction to Linear Programming<\/p>\n
Question 3 (6 points):: Reiser Sports Products wants to determine the number of All-Pro (A) and College (C) footballs to produce in order to maximize profit over the next four-week planning ho- rizon. Constraints affecting the production quantities are the production capacities in three departments: cutting and dyeing; sewing; and inspection and packaging. For the four-week planning period, 340 hours of cutting and dyeing time, 420 hours of sewing time, and 200 hours of inspection and packaging time are available. All-Pro football\u2019s provide a profit of $5 per unit, and College footballs provide a profit of $4 per unit. The linear programming model with production times expressed in minutes is as follows:<\/p>\n
A portion of the graphical solution to the Reiser problem is shown in Figure. <\/p>\n
a.Shade the feasible region for this problem. (1 point)<\/p>\n
b.Determine the coordinates of each extreme point and the corresponding profit. Which extreme point generates the highest profit? (1 point)<\/p>\n
c.Draw the profit line corresponding to a profit of $4000. Move the profit line as far from the origin as you can in order to determine which extreme point will provide the optimal solution. Compare your answer with the approach you used in part (b). (2 points)<\/p>\n
d.Which constraints are binding? Explain (2 points)<\/p>\n
Question 4 (9 points): Solve the following linear programming problem using the graphical solution procedure:<\/p>\n
Max 5A + 5B<\/p>\n
s.t. <\/p>\n
1A \u2264 100 <\/p>\n
1B \u2264 80 <\/p>\n
2A + 4B \u2264 400<\/p>\n
A, B \u22650<\/p>\n
Question 5 (12.5 points): Kelson Sporting Equipment, Inc., makes two different types of baseball gloves: a regular model and a catcher\u2019s model. The firm has 900 hours of production time available in its cut- ting and sewing department, 300 hours available in its finishing department, and 100 hours available in its packaging and shipping department. The production time requirements and the profit contribution per glove are given in the following table:<\/p>\n
Assuming that the company is interested in maximizing the total profit contribution, answer the following: a.What is the linear programming model for this problem? (2.5 points)<\/p>\n
b.Find the optimal solution using the graphical solution procedure. How many gloves of<\/p>\n
each model should Kelson manufacture? (5 points)<\/p>\n
c. What is the total profit contribution Kelson can earn with the given production quantities? (2.5 points)<\/p>\n
d.How many hours of production time will be scheduled in each department? (1.25 points)<\/p>\n
e.What is the slack time in each department? 1.25 points)<\/p>\n
Chapter 3 – Linear Programming: Sensitivity Analysis and Interpretation of Solution<\/p>\n
Question 6 (12.5 points). Consider the following linear program:<\/p>\n
Min8X + 12Y <\/p>\n
s.t.1X + 3Y \u2265 9 <\/p>\n
2X + 2Y \u226510 <\/p>\n
6X + 2Y \u226518<\/p>\n
X, Y \u2265 0<\/p>\n
a.Use the MS Excel Solver to find the optimal solution with sensitivity analysis and provide the reports by copying or taking screenshot from excel. After providing report calculate the optimal solution. (5 points)<\/p>\n
P.S: If you will miss to provide the MS Excel Solver, you will be graded for zero for this question.<\/p>\n
b.Based on the computer solution (sensitivity analysis report) for the linear program in part (a): <\/p>\n
Assume that the objective function coefficient for X changes from 8 to 6. Does the optimal solution change? (1.5 points)<\/p>\n
c.Based on the computer solution (sensitivity analysis report) for the linear program in part (a): <\/p>\n
Assume that the objective function coefficient for X remains 8, but the objective function coefficient for Y changes from 12 to 6. Does the optimal solution change? (1.5 points)<\/p>\n
d. Based on the computer solution (sensitivity analysis report) for the linear program in part (a): <\/p>\n
Determine the dual value for constraint 1. (1.5 points)<\/p>\n
e. Based on the computer solution (sensitivity analysis report) for the linear program in part (a): <\/p>\n
Suppose that the right-hand side for constraint 1 is increased from 9 to 10. Find the new optimal solution. What does the right-hand-side range information for constraint 1 tell you about the dual value for constraint 1? (1.5 points)<\/p>\n
f. The dual value for constraint 2 is 3. Using this dual value and the right-hand-side range information in part (a), what conclusion can be drawn about the effect of changes to the right-hand side of constraint 2? (1.5 points)<\/p>\n
Chapter 4 – Linear Programming Applications in Marketing, Finance and Operations Management<\/p>\n
In this part you need to answer only Question 7 or Question 8. (12.5 points)<\/p>\n
Question 7. The Westchester Chamber of Commerce periodically sponsors public service seminars and programs. Currently, promotional plans are under way for this year\u2019s program. Advertising alternatives include television, radio, and online. Audience estimates, costs, and maximum media usage limitations are as shown.<\/p>\n
To ensure a balanced use of advertising media, radio advertisements must not exceed 50% of the total number of advertisements authorized. In addition, television should account for at least 10% of the total number of advertisements authorized.<\/p>\n
What is the linear programming model for this problem? (4 points)<\/p>\n
If the promotional budget is limited to $18,200, how many commercial messages should be run on each medium to maximize total audience contact? What is the allocation of the budget among the three media, and what is the total audience reached? For solution, use Excel Solver and provide the screenshots of results from Excel. Use the MS Excel Solver to find the optimal solution with sensitivity analysis and provide the reports by copying or taking screenshot from excel. After providing report calculate the optimal solution. (6 points)<\/p>\n
P.S: If you will miss to provide the MS Excel Solver, you will be graded for zero for this question.<\/p>\n
By how much would audience contact increase if an extra $100 were allocated to the<\/p>\n
promotional budget? (2.5 points)<\/p>\n
LetT = number of television spot advertisements<\/p>\n
R = number of radio advertisements<\/p>\n
O = number of online advertisements<\/p>\n
Question 8. The management of Hartman Company is trying to determine the amount of each of two products to produce over the coming planning period. The following information concerns labor availability, labor utilization, and product profitability:<\/p>\n
Develop a linear programming model of the Hartman Company problem. What is the linear programming model for this problem? (4 points)<\/p>\n
Solve the model to determine the optimal production quantities of products 1 and 2. For solution, use Excel Solver and provide the screenshots of results from Excel. Use the MS Excel Solver to find the optimal solution with sensitivity analysis and provide the reports by copying or taking screenshot from excel. After providing report calculate the optimal solution. (6 points)<\/p>\n
P.S: If you will miss to provide the MS Excel Solver, you will be graded for zero for this question.<\/p>\n
c. In computing the profit contribution per unit, management doesn\u2019t deduct labor costs because they are considered fixed for the upcoming planning period. However, suppose that overtime can be scheduled in some of the departments. Which departments would you recommend scheduling for overtime? How much would you be willing to pay per hour of overtime in each department? (2.5 points)<\/p>\n
Letx1 = units of product 1 produced<\/p>\n
x2 = units of product 2 produced<\/p>\n
Chapter 7: Integer Linear Programming<\/p>\n
Question 9 (12.5 points):Consider the following all-integer linear program:<\/p>\n
Max 1×1 + 1×2 <\/p>\n
s.t.4×1 + 6×2 \u226422 <\/p>\n
1×1 +5×2 \u226415 <\/p>\n
2×1 + 1×2 \u2264 9<\/p>\n
x1, x2 \u2265 0 and integer<\/p>\n
a.Graph the constraints for this problem. Use dots to indicate all feasible integer solutions. (4 points)<\/p>\n
b.Solve the LP Relaxation of this problem. (4 points)<\/p>\n
c.Find the optimal integer solution. (4.5 points)<\/p>\n","protected":false},"excerpt":{"rendered":"
MGNT 3150 Management Science Homework Assignment 1 Topic Questions Value Chapter 1 Question 1 5 points Question 2 5 points<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[],"tags":[],"class_list":["post-52499","post","type-post","status-publish","format-standard","hentry"],"yoast_head":"\n