Question What is the expected time to complete a task with the pessimistic, most likely, and optimistic times of 3.0, 3.0, and 9.0 days respectively? hint the beta distribution

Chapter 4: Project Management (CPM & PERT TECHNIQUES) QUESTION 1 A network consists of the following list. Times are given in weeks. Preceding Activity A B C D E F G H I J K Duration 9 2 12 5 6 A A A B B CF ဝ ထt D H GI E, ] 3 2 8 6 2 a. Draw the network diagram. b. Which activities form the critical path? c. What is the duration of the project completion? QUESTION 2 A PERT problem is detailed in the table below. Times are given in weeks. Preceding Activity A B с D E F G H I J K A A A B B CF D H GI E,J Optimistic Time 7 2 8 3 4 6 2 2 6 4 2 Probable Time/ Most likely time 9 2 12 5 6 8 3 2 8 6 2 Pessimistic Time 14 8 16 10 8 10 4 8 16 14 5 a. Calculate the expected time and ES, EF, LF, and LS of each activity. b. Draw diagram network for this project. c. What are the project variance and the project standard deviation? d. What is the estimated completion time? e. What is the probability of completion of the project after week 40?

P3.5 The sales revenue, food cost of sales, and guests served for a small fast- food carryout division of a restaurant for the past six months are given below. Sales Month Cost of Revenue Guests Served Sales, Food 1 2. 4 $258,200 274,800 285,600 289,400 298,300 304,600 $ 96,200 104,300 110,500 113,100 118,900 123,700 10,200 10,400 10,300 10,100 10,400 10,500 6 For each of the six months calculate average check and average costs of sales food. Using these averages, calculate an index number. Set the in- dex for month 1 at 100 and complete index numbers for the remaining five months. With the index numbers identified, convert sales revenue and cost of sales food from historic to current dollars.

A cylindrical rock sample has a length of 6 cm, a diameter of 4 cm, and a dry weight of 166.4 g. When fully saturated with an oil of density 0.85 g/cm3, the weight of this sample is 176.9 g. Assuming constant temperature, find: i) The porosity of the sample ii) The pore compressibility of the sample, given that 0.2 cm of oil leaves the sample when a pressure of 3200 psig is applied on it iii) The amount of oil that can be extracted from the sample when a pressure of 2000 psig is applied on it

2.7 LAB - Alter Movie table The Movie table has the following columns: ID - integer, primary key Title - variable-length string Genre - variable-length string RatingCode - variable-length string Year - integer Write ALTER statements to make the following modifications to the Movie table: Add a Producer column with VARCHAR data type (max 50 chars). Remove the Genre column. Change the Year column's name to ReleaseYear, and change the data type to SMALLINT.

Victory Company uses weighted average process costing. The company has two production processes. Conversion cost is added evenly throughout each process. Direct materials are added at the beginning of the first process Additional information for the first process follows Direct Materials Conversion Percent Percent Units Complete Complete Beginning work in process inventory 72, eee 100% 80% Units started this period 833,eee Units completed and transferred out 71e,eee Ending work in process inventory 195, eee 1ees 50% Beginning work in process inventory Direct materials $ 411,775 Conversion 100,938 $ 512, 713 Costs added this period Direct materials 2,755,725 Conversion 1,917,812 4,673,537 Total costs to account for $ 5,186,250 Required: 1. Compute equivalent units of production for both direct materials and conversion Equivalent Units of Production (EUP). Weighted Average Method Units % Materials EUP-Materials % Conversion EUP. Conversion Total units 2. Compute cost per equivalent unit of production for both direct materials and conversion Cost per equivalent unit of production Materials Conversion Costs Costs Total costs Equivalent units of production (from part 1) Cost per equivalent unit of production EUP EUP 0 0 3. Assign costs to the department's output-specifically, to the units transferred out and to the units in ending work in process Inventory (Round "Cost per EUP" to 2 decimal places.) EUP Cost per EUP Total cost Cost assignment-Weighted average Completed and transferred out Direct materials Conversion Total completed and transferred out Ending work in process Direct materials Conversion Total ending work in process Total costs accounted for $ 0 0.00 $ 0.00 S 0

Help in SQL.. please take your time 3.12 LAB - Create LessonSchedule table with FK constraints Two tables are created: 1. Horse with columns: - ID - integer, primary key RegisteredName - variable-length string 2. Student with columns: ID - integer, primary key FirstName - variable-length string LastName - variable-length string Create the Lesson Schedule table with columns: • HorselD-integer with range 0 to 65 thousand, not NULL, partial primary key, foreign key references HorseID) • StudentID - integer with range 0 to 65 thousand, foreign key references Student(ID) • LessonDate Time - date/time, not NULL, partial primary key If a row is deleted from Horse, the rows with the same horse ID should be deleted from LessonSchedule automatically. If a row is deleted from Student, the same student IDs should be set to NULL in Lesson Schedule automatically. 387240.1399152.qx3zay? LAB ACTIVITY 3.12.1: LAB - Create Lesson Schedule table with FK constraints 0/10 Main.sql Load default template... 1 CREATE TABLE Horse ( 2 ID SMALLINT UNSIGNED AUTO_INCREMENT, 3 RegisteredName VARCHAR(15), 4. PRIMARY KEY (ID) 5); 7 CREATE TABLE Student ( 8 ID SMALLINT UNSIGNED AUTO_INCREMENT, 9 FirstName VARCHAR(20), 10 LastName VARCHAR(30), 11 PRIMARY KEY (ID) 12 ); 13 If a row is deleted from Student, the same student IDs should be set to NULL in LessonSchedule automatically. SB/270.7399152 gy LAB ACTIVITY 3.12.1: LAB - Create Lesson Schedule table with FK constraints 0/10 Main.sql Load default template... 1 CREATE TABLE Horse 2 2 ID SMALLINT UNSIGNED AUTO_INCREMENT, 3 RegisteredName VARCHAR(15), 4 PRIMARY KEY (ID) 5); 6 7 CREATE TABLE Student 8 ID SMALLINT UNSIGNED AUTO_INCREMENT, 9 FirstName VARCHAR(20), 10 Last Name VARCHAR(30), 11 PRIMARY KEY (ID 12); 13 14 -- Your SQL statements go here 15 16 17 Develop mode Submit mode Explore the database and run your program as often as you'd like, before submitting for grading. Click Run program and observe the program's output in the second box. Main.sql Run program Output (shown below) (Your program) Program output displayed here Coding trail of your work What is this? History of your effort will appear here once you begin working on this zylab.