Using the IF function, write a formula in J38 to display "Yes" if the activity is critical and display "No" if the activity is not critical. Copy the formula to cells J39:J44.
Q: 1. Sue now has $125. How much would she have after 8 years if she leaves it invested at 8.5% with…
A: Future value: Amount that is going to be received in the future including the rate of compounding.…
Q: The following table shows the XY coordinates for five locations in a network of production sites.…
A: x¯=XiQiny¯=YiQinn= total number of shipments/destinations
Q: UCLp = of a sample size of 500, the upper and lower (enter your response as a number between 0 and…
A: It is given that defect rate is 4.50 % or 0.045. So, p-bar = 0.045 Sample Size (n) = 500z = 3…
Q: Research the following: 1. Forecasting 2. Steps in forecasting process 3. Forecast accuracy
A: NOTE: We are allowed to do the first three sub-parts only. Forecasting is a difficult task because…
Q: Company XYZ, Inc. purchases widgets from a supplier at a cost of $20 per unit and sells the widgets…
A: Inventory management is the process of forecasting and controlling inventory levels, in order to…
Q: Northcutt manufactures high-end racing bikes and is looking for a source of gear sprocket sets.…
A: Supplier selection is a strategic decision in supply chain management. Total landed cost refers to…
Q: Discuss why many modern organizations adopt a just-in-time philosophy for their manufacturing…
A: Just-in-time is a kind of inventory system where the company or the buyer makes an order only when…
Q: Answer the following questions based on the Tornado and Sensitivity graphs given below. Which input…
A: In optimization, it is important to identify a variable that requires effort to evaluate but has the…
Q: (a) Which constraints are binding? (b) Which constraints are non-binding? (c) What is the increase…
A: Linear programming is a mathematical technique that is also used in operations management…
Q: Gator Beach Marts, a chain of convenience grocery stores in the Fort Lauderdale area, has store…
A: Remember all these formulas: High low Method Variable Cost = (Highest Activity Cost-Lowest Activity…
Q: Please answer part i of question 1. 1. A food manufacturer wants to locate a warehouse to serve its…
A: Formulae used: Cx= ∑dix × Vi∑Vi CY= ∑diy × Vi∑Vi Here X and Y are - coordinates dix = is the X…
Q: Given the following demand data, compute a simple exponential smoothing forecast for alpha values of…
A: The exponential smoothing forecast is a type of forecast which is used for time series data. It is…
Q: During which relationship is the “from” activity unable start until the “to” activity is started?…
A: Finish-to-start (FS) implies that the "from" activity can only start when the "to" activity has…
Q: What are the consequences of outsourcing production on the welfare of countries? Discuss in 3 points
A: (1) A scenario known as outsourcing occurs when a corporation decides that a particular area may be…
Q: t one example of delivering poor quality on an IT project. What happened? What would you have done…
A: Studying and the use of facts era isn't a smooth subject. For the system to be implemented…
Q: Briefly describe what happens in each of the five project management process groups (initiating,…
A: Project management is concerned with designing and planning business projects keeping in mind the…
Q: 20. The three inputs for an MRP parts explosion are
A: MRP stands for Material Requirement Planning. MRP Parts explosion is used to generate purchase…
Q: Suppose that the demand in period 1 was 7 units and the demand in period 2 was 9 units. Assume that…
A: Forecasting is a technique used to predict future outcomes on the basis of past data. In businesses…
Q: Part 2 Calculation Questions As assistant manager of a soccer specialty store you have been asked to…
A: Given data: Average weekly demand (d) = 18 pairs/week Standard Deviation of demand = 6 pairs Lead…
Q: Audi Profile, History and Status Quo: In 1910, the first Audi car was produced in Zwickau, Saxony.…
A: The case is about an automobile manufacturer that produces luxurious cars. The company follows a…
Q: What is the average number of errors per order? Do not round intermediate calculations. Round your…
A: c-bar = Average number of errors per order = Total Errors/Total Samples =…
Q: What is a layout strategy for a retail facility?
A: To start off, it is important to understand what the objectives of your retail facility are. What do…
Q: Safety stock = units (round your response to the nearest whole number).
A: Mean demand = 70 units Standard Deviation of demand = 7 units Service Level = 90%
Q: Mr. John produces a special type of shoes on an assembly line. The process involves eight different…
A:
Q: 1- A sourcing strategy for items in the leverage quadrant will be to build long-term alliances with…
A: Ans) 1) A sourcing strategy for items in the leverage quadrant do not means to build long term…
Q: Coady used a strategy of focusing on reducing the number of projects in the portfolio.” Briefly…
A: The case is about a bankrupt airline. A new CIO was hired after a year of bankruptcy. The new CIO…
Q: e weapon" Justify the statemen
A: Since quality is an integral component of an organization's overall competitive advantage, the…
Q: Among the advantages of using project management software are the provisions for; a. Logical…
A: Project management software is employed to plan, coordinate, and distribute resources. It clarifies…
Q: If he uses the earliest due date first priority rule to schedule these jobs, what will be the…
A: Scheduling is the process of arranging production activities in order to complete the manufacturing…
Q: Janson's Department Store in Stark, Ohio, maintains a successful catalog sales department in which…
A:
Q: CRISIS IT In May 2007, Frontier Airlines Holdings hired Gerry Coady as chief information officer…
A: 1. Too many projects and too few resources: The airline had accepted too many projects. As the…
Q: 7- A sourcing strategy for items in the bottleneck quadrant can be to a-adjust specifications to…
A: Ans) 7) A sourcing strategy for items in the bottleneck quadrant can be to 1) increasing…
Q: CASE STUDY In September 2020, ACME Fabricators advised its staff that their new factory and offices…
A: Every company involves in some project at some point of time. The duration varies from company to…
Q: An engineering firm retains a technical specialist to assist four design engineers working on a…
A: Based on the question description, the following information is extracted. Number of design…
Q: follows: The monthly sales for Yazici Batteries, Inc., were as MONTH January February March April…
A: a)
Q: Identify and briefly explain ANY 4 problems Frontier Airlines Holdings were experiencing. By using…
A: The case is about a bankrupt airline. A new CIO was hired after a year of bankruptcy. The new CIO…
Q: Identify the appropriate inventory model to obtain the optimal lot size for the given problem…
A: Find out the number of T-shirts Rick should order so as to maximize his expected profits.
Q: A cause -and-effect diagram is used to identify the possible causes of defects. Draw a Cause and…
A: Cause and effect diagram aka fishbone diagram aka Ishikawa diagrams are causal diagrams created by…
Q: What are burn up charts and burn down charts? Describe when you would use a burn up chart versus a…
A: Managers utilize burn-up as well as burn-down charts to monitor the situation with the project.…
Q: 4. Consider the following problem Maximize Z = 3x₂ + 2x₂ subject to x₁ ≤4 2x₂ ≤ 12 3x₂ + 2x₂ ≤ 15…
A: Primal to the dual problem: Need to consider the below: In primal, There are 2 variables and 3…
Q: Part e & f is incorrect e.)Ls=3.125+0.75=3.875 ships f.) Lq=(6^2(1/6)^2+0.75^2)/2(1-.75)=3.125…
A: Given that: Arrival rate (A) 6 Service rate (S) 8 number of servers C 1
Q: Which of the following is the first phase in the design of a global supply chain network? a. Define…
A: Global supply chains are structures that are used to purchase & supply services and goods…
Q: Consider the simplex tableau given below. X₁ x₂ X3 $₁ S₂ S3 3 0 1 3 0 0 0 0 0 -2 2 1 2 0 x₂ = O X₁,…
A: The simplex method is an algebraic technique to solve linear programming questions. Using the…
Q: What do you mean by importance of quality control and quality assurance for the national and…
A: High certification criteria are upheld by educational agencies. Although the terms acknowledgment…
Q: Problem 11-14 (Algo) Charlie's Pizza orders all of its pepperoni, olives, anchovies, and mozzarella…
A: Given data: Average weekly Demand (d) =160 pounds/week Standard deviation = 26 pounds Inventory (I)…
Q: A start-up company in Vanderbijlpark that produces toy buses and cars, has two primary resources…
A: Here, I have been given a case, from these data, I would formulate an LP, after formulating this LP,…
Q: g system help the hospitals?
A: The processes a hospital takes to get the medical supplies, goods, or services it requires can be…
Q: Hart Manufacturing makes three products. Each product requires manufacturing operations in three…
A: Mixed integer linear programming is an optimization technique used to solve complex problems. In the…
Q: Using trend projection, develop a formula to predict sales for years 11 and 12. You have to show all…
A: The given data stated below, Year TV Sales 1 150 2 300 3 480 4 600 5 630 6 640 7…
Q: Create a decision table and a decision tree. b) If the executive is an optimistic decision maker,…
A: A decision tree is used to make a decision by evaluating the possible outcomes of a given event.…
(g) Using the IF function, write a formula in J38 to display "Yes" if the activity is critical and display "No" if the activity is not critical. Copy the formula to cells J39:J44.
To calculate the entire project's variance, we simply add variance for activities on the critical path.
Screenshot
attached
tahnks!!!
Step by step
Solved in 2 steps with 2 images
- Your hospital has applied for certification as a level 1 stroke center. It is critical that the following project is completed in 18 weeks, before the next Joint Commission survey. Project activity times are listed in the table attached as an image. Determine the minimum cost-schedule for this project to be completed in 18 weeks. Assume a linear relationship between crash cost and crash time. For example, crash cost per week for activity A can be calculated as: ($650 - $200)/(4-2) = $225. 2. What is the difference in total project costs between the earliest completion time of the project using normal times and the minimum cost-schedule you found in part 1?You are the project manager of the software installationproject in Table 7.12. You would like to find the minimum-costschedule for your project. There is a $1,000-per-week penaltyfor each week the project is delayed beyond week 25. In addi-tion, your project team determined that indirect project costsare $2,500 per week.a. What would be your target completion week?b. How much would you save in total project costs with yourschedule?Using your results from Problem 6,(a) Calculate the probability that the project will be completedin 38 weeks.(b) Calculate the probability that the project will be completedin 42 weeks
- A project is scheduled to complete in six months duration. There are two activities in the project. The actual cost of Activity 1 is SAR 300,000 and that of Activity 2 is SAR 200,000. The planned value of these activities is SAR 280,000 and 150,000 respectively. On reviewing, the current project status is Activity 1 is 100% completed and Activity 2 is only 75% completed. (i) Perform the earned value calculations of the above project scenario and fill the given table. (ii) What do you infer about the project schedule and cost based on your calculations? Earned Value Planned Value Actual Cost Cost Variance Activity Scheduled Variance Cost performance Index Schedule performance Index Month 1A project is scheduled to complete in six months duration. There are two activities in the project. The actual cost of Activity 1 is SAR 300,000 and that of Activity 2 is SAR 200,000. The planned value of these activities is SAR 280,000 and 150,000 respectively. On reviewing, the current project status is Activity 1 is 100% completed and Activity 2 is only 75% completed. (i) Perform the earned value calculations of the above project scenario and fill the given table. Activity Month 1 Earned Value Planned Value Actual Cost Cost Variance Scheduled Variance Cost performance Index Schedule performance Index (ii) What do you infer about the project schedule and cost based on your calculations?The Advanced Tech Company has a project to design an integrated information data base for a major bank. Data for the project are given in the following table. Indirect project costs amount to $250 per day. The company will incur a $200 per day penalty for each day the project lasts beyond day 12. Activity Normal Time (days) Normal Cost ($) Crash Time (days) Crash Cost ($) Immediate Predecessor(s) A 5 800 4 1,000 − B 5 1,100 2 2,900 − C 2 600 1 900 A, B D 3 1,200 2 2,000 B E 3 1,500 2 1,700 C, D F 2 1,300 1 1,400 E G 3 900 3 900 E H 5 500 2 800 G a. What is the project's duration if only normal times are used? The project duration is nothing day(s). (Enter your response as an integer.)…
- The following information has been computed from aproject:Expected total project time = T = 62 weeksProject variance (s2p ) = 81What is the probability that the project will be completed18 weeks before its expected completion date?B/U pe Activity A B D 11. A project has the activity duration and cost information indicated in the table where all times are in weeks. There is a penalty of $4,000 per week for every week the project exceeds 37 weeks. What is the lowest total cost for completing this project? Predecessor Time 18 11 A A B C E D Normal A H 12 15 3 19 Asbe de ABC' AMBBC RACE AB 7 8 12 6 Normal Cost Crash Time Crash Cost $22,000 $32,000 $62,000 $18,000 $35,000 $8,000 $23,000 $32,000 $56,000 $12,000 5 $18,000 19 $22,000 $9,000 $15,000 $5,000 $13,000 $20,000 $45,000 2 5 4A project has three critical paths: A-B-C-D-E, A-G-H-E, and A-F-I-E. Crashing costs (in thousands, per week) for each activity is listed below: Activity Crashing 1st time Crashing 2nd time Crashing 3rd time 35 2 28 1 C 29 4 1 8 8 4 E 34 1 IF 34 28 3 G 27 19 1 8 7 1 5 4 What is the total cost of reducing this project by two weeks? а. 36 b. 58 С. 69 d. 43 57 LO e.
- Image of Diagram included Using the diagram, find: The critical path. How long it will take to complete the project? How does simulation determine the probabilities of various project completion times? What is "slack" and why is it important? Why is activity-on-arrow (AOA) or activity-on-node (AON) of significant value to the project manager? How is the uncertainty in project scheduling dealt with? Should the critical path activities be managed differently from noncritical path activities? Explain.Project Scope Management Khan, (2006) (see below) states that, "Managing the scope of a project is the most important function of a project manager ... Effective scope management of a project also ensures the success of key completion areas, including time, cost, and quality. Project scope management can be further subdivided into its components which include: project initiation, scope planning, scope definition, scope verification, and scope change control." Based on your Integrated Project: Select two of the subdivisions above and discuss the primary issues that could arise from the process. Your response should begin with a definition of the selected subdivision before detailing the selected processYou are in charge of a project at the local community center. The center needs to remodel one ofthe rooms in time for the start of a new program. Delays in the project mean that the center mustrent other space at a nearby church at additional cost. Time and cost data for your project arecontained in below table. Your interest is in minimizing the cost of the project to the communitycenter.Using the normal times for each activity, what is the earliest date you can complete the project?Suppose the variable overhead costs are $50 per day for your project. Also, suppose that thecenter must pay $40 per day for a temporary room on day 15 or beyond. Find the minimum-costproject schedule using below format.The AON diagram for the community center project is below. Crash 4 times and find total cost.