Information provided is for end of day 6:1. What is the actual cost so far?2. What is the estimated time to completion? ( show formula and working)3. What is the estimated cost to completion? ( show formula and working) ActivityLandscapeDesignRetaining wallDirt workMove utilitiesSprinkler systemPlantingPlanned CostDuration in days6 9 123 1322Cumulative Planned Cost 2Actual Cost2Cumulative Actual Cost5 346234153128 14 9 1510 24 33489Planned Value2+3+1=65+3 = 84+2=66+3 = 94+3 = 71248% Comp1005051000ΣEarned Value6*100% = 68*50% = 46*5% = 0.39*10% = 0.90011.2

Answered: Image /qna-images/answer/a1051803-78c2-4da3-9ebe-95e49011c01f.jpg

Answered: What is the actual cost so far? 2.…

What is the actual cost so far? 2. What is the estimated time to completion? ( show formula and working) 3. What is the estimated cost to completion? ( show formula and working)

Practical Management Science

6th Edition

ISBN:9781337406659

Author:WINSTON, Wayne L.

Publisher:WINSTON, Wayne L.

Chapter2: Introduction To Spreadsheet Modeling

Section: Chapter Questions

Problem 20P: Julie James is opening a lemonade stand. She believes the fixed cost per week of running the stand...

See similar textbooks

Related questions

Q: A single server queuing system with a Poisson arrival rate and exponential service time has an…

A: As per the guidelines, the first question is taken for answering purposes,

Q: Eakins Enterprises makes model boats, and it is switching to a lean manufacturing process. At one…

A: Here, I would determine how fast a container has to make it through the system to accomplish the…

Q: Can you explain the basic ideas behind risk management?

A: Risk management is fundamental process that involves identifying, assessing, and mitigating the…

Q: Please offer a description of the sector of technical equipment as well as a list of potential work…

A: The technical equipment sector plays an important role in supporting diversified industries, In…

Q: A specific rate in an industrial process is dependent on many factors and varies according to the…

A: Process arrival time represents when a process becomes available for execution in a system and is a…

Q: Bloomington Corporation has four regional stores in New York state. These four stores are located in…

A: Network Flow Model consists of a network of sources and destinations. These are represented with…

Q: Here is how the producer-consumer conundrum is described: Give an operating system example and…

A: A fundamental problem in operations management and computer science is the producer-consumer…

Q: An international company in healthcare industry is currently serving the European market from three…

A: The transportation problem is a classic optimization and linear programming problem that involves…

Q: Mention some drawbacks of the Linear Model?

A: Listed below are some issues with the linear model:Linearity assumption:The linear model makes the…

Q: Highlight any four guidelines which should be followed to ensure fairness in a competitive tendering…

A: In operation management, the competitive tendering process is critical aspect of procurement and…

Q: What multidisciplinary challenges (different roles and responsibilities) face the security manager…

A: In today's complex and interconnected world, security management plays critical role in safeguarding…

Q: A community playhouse needs to determine the lowest-cost production budget for an upcoming show.…

A: Linear programming helps us to find the optimal solution/best outcome, given the constraints.Integer…

Q: What we mean when we talk about the "vision" of a successful project is the "components" of that…

A: Basically, we should find the components areas to build the vision of a project, again, whenever, we…

Q: Some software subsystems are "low quality, high value." Analyze how subsystem re-engineering can…

A: In the context of operations management, the term "low quality, high value" refers to software…

Q: 3 The Sweet Smell Fertilizer Company markets bags of manure labeled "not less than 60 pounds dry…

A: The graphical LP method is a way to solve linear programming problems by graphing the constraints…

Q: briefly outline the step-by-step procedures you would take for the following qualitative data…

A: As per this question, I will outline the step-by-step procedures for applying the qualitative data…

Q: Noe 1 and 2 only have the supply as inflow, we call them the Supply Node. Node 6 only has the demand…

A: AnswerThe correct statement regarding the general formulations of these nodes is:D. For the Supply…

Q: What are the common challenges faced during the planning of work activities and how do you overcome…

A: For any project to succeed, we must consider the planning of work activities, through effective…

Q: List the design characteristics of a service blueprint.

A: With the help of a service blueprint, we can represent a visual diagram, Here, we will use the…

Q: How has the implementation of data warehousing positively impacted both you and your organization?

A: Data warehousing has given people better access to thorough and trustworthy data from a variety of…

Q: What kind of problems

A: A workflow control system is a software solution designed to streamline and optimize the tactics…

Q: (a) What is the optimal solution, and what is the value of the total annual return (in $)? U H…

A: In the question, I have been given the LP formulation along with the computerized output, I would…

Q: in manufacture industry. Make Ergonomic Design and Improvement by identifying, evaluating and…

A: ***Below answer is explained in the context of Business***Ergonomic design and improvement in the…

Q: 3. Make or Buy. A sudden increase in the demand for smoke detectors has left Acme Alarms with…

A: Find the Given details below: DepartmentMonthly HoursElectronic - Hours/UnitBattery -…

Q: A company that produces pleasure boats has decided to expand one of its lines. Current facilities…

A: Given:Alternative A (new location)Fixed Cost = $ 285,000Variable Cost per boat = $570Alternative B…

Q: The Barberton Municipal division of Road Maintenance is charged with road repair in the city of…

A: The operations-level workforce plan is an important component of the overall business strategy. It…

Q: Use the following network with activities and times estimated in days to answer the questions. Start…

A: A network diagram is a graphical representation of project that helps to identify the activity…

Q: How do the fundamental building blocks of manufacturing vary from one another, and what are those…

A: Manufacturing utilizes various fundamental building blocks, each representing different types or…

Q: Please do not give solution in image format thanku Daily demand for Chandler's Footballs varies…

A: Mean (x) = 195Standard deviation (Sd) = 12Lead time(L) = 3

Q: In a linear programming problem, the binding constraints for the optimal solution are 5X + 3Y ≤ 30…

A: In a LPP, the binding constraints for optimal solutions are given below:

Q: The R&D department is planning to bid on a large project for the development of a new communication…

A: A network diagram is a graphical representation of project that helps to identify the activity…

Q: As a Restaurant Manager, describe a challenging experience in managing a restaurant inventory?…

A: One of the prominent challenges faced in restaurant with regard to inventory management was dealing…

Q: Gubser Welding, Inc., operates a welding service for construction and automotive repair jobs. Assume…

A: Single server queuing theory, also known as single-server queuing system or M/M/1 queuing model, is…

Q: ERP systems? What are the pros and cons of such design strategies?

A: First, I would state the definition of ERP systems, Then, I would state the pros and cons of ERP…

Q: How is the implementation of the organization's new risk management framework taking place? What are…

A: In response to ever-evolving cyber threat landscape and critical importance of safeguarding the…

Q: Activity Duration A B C D E TI F Start For the project represented above, determine the earliest and…

A: Path duration:ABEG=7+5+7+7=26ABDFG=7+5+3+3+7=25ABDH =7+5+3+9 =24ACFG=7+7+3+7=24ACH=7+7+9…

Q: 06 Mention some drawbacks of the Linear Model?

A: The Linear Model, also known as the Waterfall Model, is a sequential software development process in…

Q: During the planning and execution of a training event, it is crucial to evaluate the efficacy and…

A: Training is an important part of the management function where employees are given specific…

Q: In what ways do the Internet and information systems affect Porter's five forces of competition, and…

A: The Internet and information systems have a singificant impact on Porter's five forces of…

Q: Data collected on the yearly registrations for a Six Sigma seminar at the Quality College are shown…

A: Forecasting is the method that helps the organization in the analysis of historical data that is…

Q: Which forecasting technique will you choose based on MAD? O a. Exponential 1 O b. Moving Average O…

A: Here, for each month, I have been given the actual demand data, After applying three forecasting…

Q: A company is about to begin production of a new product. The manager of a department that is asked…

A: It is based on the inventory management model, that is used to estimate the optimal production…

Q: A local large company has adopted a policy of procuring from local SME, how can the implementation…

A: SCM is a strategic approach to integrating supply and demand in the market. It involves several…

Q: What are some commercially available software package that is designed to be a project management…

A: Tools for project management are crucial for teams and organizations to successfully plan, execute,…

Q: The Robotics Manufacturing Company operates an equipment repair business where emergency jobs arrive…

A: Single server queuing theory, also known as single-server queuing system or M/M/1 queuing model, is…

Q: III. Productivity and Quality. Read and analyze each problem. For better presentation, draw diagrams…

A: Quality management practices help identify potential risks and hazards associated with products,…

Q: How can I Consider how local regulations influence facility design.

A: Considering how local regulations influence facility design is essential for ensuring compliance and…

Q: In the context of Business Performance Management, could you please explain why it would be…

A: Business Performance Management can be explained as a tool to monitor and assess the performance of…

Q: Thelonious and Prince both arrive at a coffee shop. Through the windows they can see that the line…

A: Queuing theoryWaiting line theory is about the mathematical study of of waiting lines, or queues…

Q: You are required to review the narrative process below to construct a process map.

A: A process map is a graphical representation of a workflow or business process using standardized…

Question

Information provided is for end of day 6:

1. What is the actual cost so far?

2. What is the estimated time to completion? ( show formula and working)

3. What is the estimated cost to completion? ( show formula and working)

Activity
Landscape
Design
Retaining wall
Dirt work
Move utilities
Sprinkler system
Planting
Planned Cost
Duration in days
6 9 12
3 1
3
2
2
Cumulative Planned Cost 2
Actual Cost
2
Cumulative Actual Cost
5 3
4
6
2
3
4
15
3
12
8 14 9 15
10 24 33
48
9
Planned Value
2+3+1=6
5+3 = 8
4+2=6
6+3 = 9
4+3 = 7
12
48
% Comp
100
50
5
10
0
0
Σ
Earned Value
6*100% = 6
8*50% = 4
6*5% = 0.3
9*10% = 0.9
0
0
11.2

Expert Solution

This question has been solved!

Explore an expertly crafted, step-by-step solution for a thorough understanding of key concepts.

SEE SOLUTION Check out a sample Q&A here

Step 1: State the given information in the question

VIEW

Step 2: 1. Calculate the actual cost incurred so far.

VIEW

Step 3: 2. Calculate the estimated time to completion (ETC)

VIEW

Step 4: 3. Calculate the estimated cost to completion (EAC)

VIEW

Solution

VIEW

Step by step

Solved in 5 steps with 5 images

SEE SOLUTION Check out a sample Q&A here

Similar questions

The Role of Income Taxes For the most recent year, Triad Company had fixed costs of $240,000and variable costs of 75% of total sales revenue, earned $70,000 of net income after taxes, and anincome tax rate of 35%.Required Determine:1. Before-tax income.2. Total contribution margin.3. Total sales.4. Breakeven point in dollar sales
matching.
Help Save & Exit Submit Saved g Enabled: Chapter 5 What-If Analysis for Linear ... i Based on the following sensitivity report, what would be the impact of changing the objective function coefficient for Product_1 to 17 and changing the objective function coefficient for Product_3 to 10? Variable Cells Final Objective Allowable Allowable Value Reduced Cost Coefficient Increase Decrease Cell Name 12 7. 1E+30 $B$2 Product 1 -2 :58 1E+30 Product 2 175 $B$3 $B$4 1E+30 -1.5 8 Product 3 Constraints Allowable Allowable Final Shadow Constraint R.H.Side Increase Decrease Cell Name Value Price 100 1E+30 100 $H$9 Resource A 800 1E+30 275 Resource B 525 $H$10 $H$11 700 366.6666667 700 Resource_C 700 1.75 100%. because the total change in the objective function coefficients Applying the 100% rule, Prev 1 of 5 Next > CO CO
38. Last year, the Montvilo family spent $1,745.10 for electricity. They are optingto use balanced billing for next year. What will their monthly payment beunder balanced billing? A. $1,745.10B. $290.85C. $174.51D. $145.43
22. Some arque that an SIS gives a company an unfair advantage and might even cause thedemise of smaller, weaker companies that cannot afford to build similar systems. Is this good orbad for customers? Explain your opinion.
2. How may engineer manager meet the threat of a compeitor's product? 3. What is the finance function? 4. waht is the difference between the short-term and long-term sources of funds?
Student Portal | Main BUS-660 Topic 1 DQ 1 /ilm/takeAssignment/takeAssignmentMain.do?invoker=&takeAssignmentSessionLocator=&inprogress=false eBook X X State of Nature Decision Alternative Strong Demand S₁ Weak Demand S₂ Small complex, d₁ 7 6 Medium complex, d₂ 12 6 Large complex, d3 19 -9 CengageNOWv2 | Online teachin X MindTap-Cengage Learning Problem 4-11 (Algorithmic) Following is the payoff table for the Pittsburgh Development Corporation (PDC) Condominium Project. Amounts are in millions of dollars. x + A million, the large complex remains the best decision. 30 G Suppose PDC is optimistic about the potential for the luxury high-rise condominium complex and that this optimism leads to an initial subjective probability assessment of 0.8 that demand will be strong (S₁) and a corresponding probability of 0.2 that demand will be weak (S₂). Assume the decision alternative to build the large condominium complex was found to be optimal using the expected value approach. Also, a…
Please Help I am confused. Classifying Costs The following is a list of costs that were incurred in the production and sale of large commercial airplanes: Classify each cost as either a product cost or a period cost. Indicate whether each product cost is a direct materials cost, a direct labor cost, or a factory overhead cost. Indicate whether each period cost is a selling expense or an administrative expense. Costs Classification a. Annual bonus paid to the chief operating officer of the company b. Annual fee to a celebrity to promote the aircraft c. Cost of electronic guidance system installed in the airplane cockpit d. Cost of electrical wiring throughout the airplane e. Cost of miniature replicas of the airplane used to promote and market the airplane f. Cost of normal scrap from production of airplane body g. Cost of paving the headquarters employee parking lot h. Decals for cockpit door, the cost of which is immaterial to the cost of the…
What would the SC value be?
1. Why business card important? 2. Explain three objectives of fiverr.
Subject: Logistic Management Q#6) What is Porters Power Model explain with example? Q#7) What is risk management & mitigation explain with example?
•..• 4.34 Boulanger Savings and Loan is proud of its long tra- dition in Winter Park, Florida. Begun by Michelle Boulanger 22 years after World War II, the S&L has bucked the trend of financial and liquidity problems that has repeatedly plagued the industry. Deposits have increased slowly but surely over the years, despite recessions in 1983, 1988, 1991, 2001, and 2010. Ms. Boulanger believes it is necessary to have a long-range strategic plan for her firm, including a 1-year forecast and preferably even a 5-year forecast of deposits. She examines the past deposit data and also peruses Florida's gross state product (GSP) over the same 44 years. (GSP is analogous to gross national product [GNP] but on the state level.) The resulting data are in the following table. YEAR DEPOSITS? GSPb YEAR DEPOSITS? GSpb 1 .25 .4 13 .50 1.2 .24 .4 14 .95 1.2 .24 .5 15 1.70 1.2 4 .26 .7 16 2.3 1.6 .25 .9 17 2.8 1.5 .30 1.0 18 2.8 1.6 7 .31 1.4 19 2.7 1.7 8 .32 1.7 20 3.9 1.9 9. .24 1.3 21 4.9 1.9 10 .26…