Assignment 2 F2023

.pdf

School

Brock University *

*We aren’t endorsed by this school

Course

5P02

Subject

Industrial Engineering

Date

Feb 20, 2024

Type

pdf

Pages

3

Uploaded by CountTankGorilla34

Report
MBAB 5P02 – Cho Fall 2023 1 ASSIGNMENT #2 (Sections 1 & 2; Group of Three or Four) (Due: 11:55 pm or earlier, Tuesday, December 5 th for all sections) INSTRUCTIONS: 1. This assignment includes three pages (including the instructions page) and fourteen problems. 2. Problems with * require the use of technology, i.e., MS Excel (and Excel Add-ins). 3. Assignment should be typed using MS Word. All necessary answers, findings, explanations, and models should be clearly written/stated in your Word document. For problems requiring technology, use an Excel worksheet for each problem and clearly indicate an appropriate question number. 4. The first page of your assignment (MS Word document) should indicate the course number, the instructor’s name, and the group members’ names, IDs & e-mail addresses. 5. Your assignment must be submitted by the group leader in each group in electronic form prior to the deadline by uploading one Word file and one Excel file to the MBAB 5P02 Brightspace course management site . Make sure that each file name contains the group leader’s name. Any submission with fewer or more than two files will not be accepted. 6. Only one submission per group is allowed. 7. Late assignments will not be accepted and will be returned without being graded. 8. Maximum mark = 140. PROBLEM #1 (10 marks): Assume the following payoff table (unit in $1,000). You are required choose the best decision based on monetary value only. States of Nature Decision Alternatives S1 S2 S3 S4 D1 0 -40 -80 -120 D2 -50 35 -5 -45 D3 -100 -15 70 30 D4 -150 -65 20 105 Using each of the following criteria, determine the best decision (based on monetary value). You should show your work. (a) Equally likely criterion (b) Maximax profit (Optimistic) criterion (c) Maximin profit (Conservative) criterion (d) Minimax Regret criterion (e) Dominance criterion PROBLEM #2 (10 marks): Problem #19 in Chapter 4 (ASW et al.: 13 th edition & 12 th edition) PROBLEM #3 (10 marks): Problem #24 in Chapter 4 (ASW et al.: 13 th edition & 12 th edition) PROBLEM #4 (10 marks): Problem #11 in Chapter 6 (ASW et al.: 13 th edition & 12 th edition)
MBAB 5P02 – Cho Fall 2023 2 PROBLEM #5 (10 marks): Based on the quarterly revenue data given in the table of Problem #28 in Chapter 6 on page 238, forecast the quarterly revenues (for all four quarters) for Year 6. Make sure to include trend and seasonality in your analysis. Use the method discussed in the class, not the one in Chapter 6.5. PROBLEM #6 (10 marks): Problem #7 (a) only in Chapter 9 (ASW et al.: 13 th edition & 12 th edition) (a) Formulate a linear programming model for the problem. You should show a complete LP model on a separate sheet, not on an Excel worksheet. (b) *Solve the model using MS Excel Solver. (Include the worksheet and the answer sheet.) PROBLEM #7 (10 marks): Problem #25 (a) only in Chapter 9 (ASW et al.: 13 th edition & 12 th edition) (a) Formulate a linear programming model for the problem. You should show a complete LP model on a separate sheet, not on an Excel worksheet. (b) *Solve the model using MS Excel Solver. (Include the worksheet and the answer sheet.) PROBLEM #8 (10 marks): Case Problem 1 – Planning an Advertising Campaign in Chapter 9 (ASW et al.: 13 th edition & 12 th edition). You do not have to be worried about the Managerial Report section. (a) Develop a LP model that can be used to determine a schedule showing the recommended number of television, radio, and newspaper advertisements and the budget allocation for each media. You should show a complete LP model on a separate sheet, not an Excel worksheet. (b) *Solve the LP model using MS Excel Solver to find the optimal solution, including the optimal number of television, radio, and newspaper advertisements and the budget allocation for each media (Include the worksheet and the answer sheet.). PROBLEM #9 (10 marks): Problem #9 in Chapter 10 (ASW et al.: 13 th edition & 12 th edition) (a) Formulate a linear programming model for the problem. You should show a complete LP model on a separate sheet, not on an Excel worksheet. (b) *Solve the model using MS Excel Solver. (Include the worksheet and the answer sheet.) PROBLEM #10 (10 marks): The Gotham City School system has three high schools that serve the needs of five neighborhood areas. The capacities of the various schools and the size (number of high school students) and ethnic mix of each neighborhood are as shown: ------------------------------------ -------------------------------------------------------------- Capacity % Minority School (max. enrollment) Neighborhood No. of Students Students ------------------------------------ -------------------------------------------------------------- A 4,000 1 2,100 30 B 3,000 2 2,400 80 C 2,000 3 1,300 20 Total 9,000 4 800 10 ------------------------------------ 5 1,600 20 Total 8,200 --------------------------------------------------------------
Your preview ends here
Eager to read complete document? Join bartleby learn and gain access to the full version
  • Access to all documents
  • Unlimited textbook solutions
  • 24/7 expert homework help