Challenging Engineering Problems with Detailed Answers
PERT (Program Evaluation and Review Technique) is used to - assist the manager in scheduling the activities assist in project scheduling similar to CPM none of the above assist the manager to know when should each activity start From the given table of a project the critical path, the project duration and the free float for activity A are respectively ABCD E Activity precedence A AB,C DE Durations (weeks) 16 20 8 10 6 12 OA-C-E-F,50 weeks, and 0 week B-E-F,38 weeks, and 0 week OA-D-F,38 weeks, and 2 weeks OA-C-E-F,42 weeks, and 0 week
Gigi is planning to pursue her dream to be a successful human resource manager working for multinational company and she wants to do her full-time degree in Malaysia. You as a cousin, needs to assist Gigi to shortlist at least 4 institutions of higher learning (IHLs) which is offering human resource related degree programs. List down all the assumptions/values/methods and references used to solve the following questions. a. Identify the key variables such as duration, tuition fees, ranking of the IHL, starting pay of the fresh graduate etc for the shortlisting of the IHLs and tabulated it into a table. (7 marks) b. Show how you can apply the statistical toolpak and probability toolpak in EXCEL for the data analysis and draw meaningful conclusions based on the data that you have collected in part (a). You need to compare the EXCEL result with manual calculation. Refer to your own significant findings, suggest to Gigi which IHL is most suitable for her and justify your suggestion. Appendix A (Fill up the empty column) No Brand 1 A 2 A 3 A 4 A 5 A 6 A 7 A A A A B B B B 8 B 8 B B B C C C C C C C C D D 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 59 60 D D D D D D D D Sugar content (g/100g) 13.5 14.7 15.7 18.0 22.5 24.2 17.0 14.0 15.0 19.0 15.2 15.5 17.8 17.0 18.0 25.0 21.2 23.4 22.0 16.0 15.0 16.0 18.0 19.0 26.5 21.5 22.5 14.0 25.0 16.5 19.0 14.5 15.5 16.8 17.5 19.5 20.5 22.0 22.5 23.0 Question 1: Ginny is working as a chemist for a food manufacturing company. She is tasked to perform a sugar content analysis on the 4 types of company products - biscuit brand A, B, C and D. She has completed the sugar content analysis in the 60 biscuits (15 for each brand) and tabulated in Table Q1 as shown in Appendix A. List down all methods/assumptions/values used to solve the following questions. a. Complete the Table Q1 which consists of 60 biscuits details and use EXCEL to draw a graph for sugar content comparison in 4 different brands and draw conclusion b. Refer to part (a) Table Q1, use EXCEL to calculate the average sugar content and standard deviation for the brand A biscuit. If the sugar contents are normally distributed, calculate the probability that a randomly selected brand A biscuit will have sugar content smaller than 19g/100g. Repeat the same calculation for brand B. Compare the answers with manual calculation and draw conclusions. c. Refer to part (a) Table Q1, the company has decided to reject any biscuit with sugar content greater than 20g/100g. Use EXCEL to calculate the probability that a randomly selected 30 biscuits will have the following: (i) Exactly 18 good biscuits. (ii) At least 20 good biscuits. Compare the answer(s) with manual calculation and draw conclusion(s).