Activity I: Product Development. Consider the simplified set of activities in the Table below for the development of a consumer product from initiation through the market test phase. ActivitySymbolImmediate predecessorsTime estimate (weeks)Investigate demandA 3Develop pricing strategyB 1Design productC 5Conduct promotional cost analysisDA1Manufacture prototype modelsEC6Perform product cost analysisFE1Perform final pricing analysisGB,D,F2Conduct market testHG8Draw the AOA network for this project.Calculate total slacks and free slacks, and interpret their meaning. .Determine the critical path and interpret its meaning.Construct a Gantt chart and mark the latest start times for each activity.Activity II: A project has 11 activities that can be accomplished either by one person working alone or by several people working together. The activities, precedence constraints, and time estimates are given in Table below. Suppose that you have up to five people who can be assigned on any given day. A person must work full days on each activity, but the number of people working on an activity can vary from day to day.ActivityImmediate predecessorsPerson-days requiredA10BA8CA5DB6ED8FC7GE,F4HF2IF3JH,I3KJ,G2Prepare an AOA network diagram, and calculate the critical path, total slacks, and free slacks assuming that one person (independently) is working on each task.Prepare an early-start Gantt chart.Prepare a daily assignment sheet for personnel with the goal of finishing the project in the minimum amount of time.Prepare a daily assignment sheet to “best” balance the workforce assigned to the project.By how many days could the project be compressed if unlimited personnel resources were available?

You have just joined an organization as a Security Analyst. As a security Analyst you are responsible for managing Firewall security policies in your organization. When you joined, your organization’s firewall policy was already managed by some previous employee. What will be the first step you will take to ensure that there are no policy violations or anomalies? Following are the set of rules in organizational firewall: Note make sure you want to have minimum number of rules and rearrange them in a way that there is no policy anomaly. 192.168.*.* 80 192.168.0.10 80 FTP Deny 192.168.0.* 80 192.168.0.10 80 FTP Accept 192.168.0.1 80 192.168.0.10 80 FTP Accept 192.168.0.2 80 192.168.0.10 80 FTP Accept 192.168.0.3 80 192.168.0.10 80 FTP Accept Bonus point question: Solve this correctly and you will get 1.5 marks added to your midterm. Do not worry if you don’t do it, you will not loose any marks. 192.168.0.1 is webserver your company is hosting, and you want to make sure that it has maximum visibility by allowing traffic from 172.193.77.1 and 172.193.78.2 domain. Any other IP in the above mentioned domains are blacklisted, so how will you fix the anomaly in the following example? Hint: you can use delete and insert commands, but make sure you pay attention to the rules. Add the rules in the following format, take a screenshot, fix the problem, and take another screenshot.

Lesson 12: Project DirectionsHands-On ProjectView GlossaryOverviewIn this hands-on project, you will be downloading a database from the Lifetime Media Company, a film and graphics company that does onsite filming and photos. The company uses this database to manage equipment assigned to its employees. You will be completing the following tasks in Microsoft Access:Creating a stand-alone macro Creating an embedded macro.Creating an event-driven data macroCreating a query by writing an SQL statement Project PreparationDownload the Lesson 12_Hands On Project file to your course lesson folder. Extract the file to the same folder.Open the file in Access.Save your file as "Lesson12_Project1_MEID.accdb" where MEID is your MEID.Project DirectionsOpen the Macro Designer and create a stand-alone macro to automatically open the Lifetime Media Equipment table. Select the following arguments:Table Name: Lifetime Media EquipmentView: Datasheet (default)Date Mode: Edit (default)Save the Macro as 'Open Name Objects' where name is your first name (example: Open John's Objects)Right-click the 'Open Name Objects' macro in the database and select Design View. Add an OpenForm action and the following arguments:Form Name: Equipment Checkout FormView: Form(default)Window Mode: Normal (default)Save and close the Macro. Right-click on the Equipment Assignments Report and open in Design View. The Property Sheet should also be on the right of your screen. You will now create a macro to send a reminder to the user upon closing the report to send an email to the auditor each Friday. Select 'On Close' from the Event list. Use the Macro Builder to create an embed macro that will prompt the user to send an Equipment Assignment report to the auditor each Friday by displaying a Message Box. In the Macro Builder, choose Message Box from the Actions drop-down menu.In the Message box type: 'Send Report to Auditor each Friday'.Beep: YesType: InformationTitle: 'Reminder'Save and close the macro. You can test your macro by opening the Equipment Assignments report from the Navigation pane and then closing the report. Open the Lifetime Media Equipment table if not already opened. You will be adding fields to indicate if a lost/damaged item needs to be replaced and a field indicating the replacement amount per item. Add a field titled 'ReplacementRequired' and format the field as Short Text. Add a field titled 'ReplacementAmountPerItem' and format the field as Currency. Save the Table before moving on to the next step.Create an event-driven data macro to calculate a 60% replacement amount when the 'ReplacementRequired' field has a value of "YES". Enter the arguments per the illustration below. If the 'ReplacementRequired' field has a value of "NO" the 'ReplacementAmountPerItem' field will remain empty. Event-Driven Data Macro - Sample FigureIf the 'ReplacementRequired' field = "YES" you will SetField 'ReplacementAmountPerItem' to be equal to 60% of the Per Unit Cost amount. Save and Close the macro. In the Lifetime Media Equipment table enter "YES" for 'ReplacementRequired' for records 2, 8, 9, 24, and 25. Enter "NO" for the rest. In the Lifetime Media Equipment table, add the following 2 records:One DSLR HD Camera for Jones at a per unit cost of $875.00. Replacement will not be required.One Studio HD Camera for Bernard at a per unit cost of $1200.00. Replacement will be required.Note: The replacement amounts are automatically calculated. Save and Close the Lifetime Media Equipment Table. Open a new query in SQL View. Type the following commands:SELECT [Employee Assigned To], [Item Name], [Quantity]FROM [Lifetime Media Equipment]WHERE [Per Unit Cost] >700;Run the query.View your results in Datasheet View.Save the query with the title Items over $700 Close the QueryCompact, repair, and save your database. Submit the assignment based on the instructions provided in the lesson.