Answered step by step
Verified Expert Solution
Question
1 Approved Answer
Excel exercise that has 5 parts. Please see attached for instruction. Thank you. This case is based on Chapter 15, Case 15.3 which is found
Excel exercise that has 5 parts. Please see attached for instruction. Thank you.
This case is based on Chapter 15, Case 15.3 which is found on Page 15-50. Remember, this the textbook. Please refer to the Cengage Brain website. Read the problem carefully. On the tab labeled "Solutions", there are 5 questions about the problem that will require you Excel file model or interpret the results of the model upon entering the required information validate your responses using Microsoft Project. Each question is worth 16 points: 8 point technical information and 8 points for a clear, concise, grammatically answer to the questio on the "Solutions" tab and typed in unbolded black font right after the statement of the ques Good luck and as always...HAVE FUN! Page 15-50. Remember, this reading material is not included in the problem carefully. problem that will require you to either make an input to the ng the required information. You will also be required to n is worth 16 points: 8 points for producing the correct ically answer to the question. Questions should be answered ter the statement of the question. D B A E C F G H K J I Activity A B C D E F G H I J K Description Collect Info Prototype Marketing Program Instructions Design Packaging Get Approval Training Info Guide Hire Actors POS Racks Finish Predecessors Days Req'd G,H,I,J 0 Forward Pass EST EFT Backwards Pass LST LFT Slack Question 1 (16 Points) On the tab labeled "CPM Network", you will find a skeleton AON netw required to complete the project discussed in the case. Based on the reading of the problem problem. In the model you will note I left a single arc (line) for you. You may copy/paste this adjust the slope and length of the line as required by clicking your mouse on the line itself. enter the arcs according to the statement of the problem. In the network model I have provi represent? Question 2 (16 Points) On the tab labeled "CPM Calculation" you will find a matrix where I ha carefully, enter the predecessors and the associated durations (Days Required) for each tas "Finish" activity. What is the definition of a predecessor? Question 3 (16 Points) On the tab labeled "CPM Calculation" complete the calculations nece for each activity. Please note the spreadsheet is not set up with formulas for calculations; y appropriate values in the spreadsheet. What is the duration of the project? Question 4 (16 Points) On the tab labeled "CPM Calculation" complete the calculations nece each activity. Please note the spreadsheet is not set up with formulas for calculations; you appropriate values in the spreadsheet. Does the duration of the project differ from the durat Question 5 (16 Points) After completing Questions 3 and 4, go back to the "CPM Calculation slack for each activity. What activities are on the critical path? Using the information you h information in Microsoft Project. On Line 1 of your Project file, title this summary task as Ca subtasks (indented). Do the critical path and duration match what you calculated here in the will find a skeleton AON network model for Case 15.3. The layout includes the activities on the reading of the problem, enter the arcs (lines) to connect the activities according to the ou. You may copy/paste this as many times as required to assemble your model. You can ur mouse on the line itself. Do not change any other formatting in the CPM Network tab, just network model I have provided on the CPM Network tab, what do the lines you entered u will find a matrix where I have listed the activities for the project. By reading the problem Days Required) for each task. Do not change the predecessors I have entered for the mplete the calculations necessary to show the early start (EST) and early finish (EFT) times formulas for calculations; you must manually complete these calculations and enter the he project? mplete the calculations necessary to show the late finish (LFT) and late start (LST) times for mulas for calculations; you must manually complete these calculations and enter the project differ from the duration found in the forward pass? ack to the "CPM Calculation" tab and in the Critical Path column (column J), compute the Using the information you have assembled in the "CPM Calculation" tab, enter this itle this summary task as Case 15.3 Duration and ensure all subsequent tasks are entered as at you calculated here in the Excel file? ivities rding to the . You can work tab, just ntered e problem r the EFT) times nter the T) times for r the mpute the his e entered asStep by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started