Using the cost estimation template and Actuals in Figure 7-5, compare the model in the figure with
Question:
Base your comparison on the mean bias, the MAR, and the tracking signal. Comment.
In Figure7-5
Transcribed Image Text:
This is a template for improving one's estimating skills 3 MAR SUM [l(A(t)/F (t)-1) /n 4 Tracking Signal SUMt(A(t)/F (t)- 1)/MAR Tracking 6 Period Forecast Actual (A(t)/F(t))-1(A(t)F() MAR Signal 155 242 46 69 75 163 240 67 78 71 423 49 157 0.052 -0.008 0.457 0.130 -0.053 0.230 -0.125 0.227 0.052 0.008 0457 0.130 0.053 0.230 0.125 0.227 0.030 1.448 0.172 2.904 0.162 3.898 0.140 4.120 0.155 5.205 0.151 4.523 0.160 5.670 10 12 13 6 56 128 15 16 17 18 Key Formulae 19 Cell D9 (C9-B9)-1 copy to D10:D16 20 Cell E9 ABS(D9) copy to E10:E16 21 Cell F10(Sum(SE$9:E10/A10 copy to F11:F16 22 Cell G10(Sum(SD$9:D10)/F10 copy to G11:G16 Total 0.908 1.281
Fantastic news! We've Found the answer you've been seeking!
Step by Step Answer:
Answer rating: 61% (13 reviews)
Tracking Period Estimate Actual AtFt1 AtFt1 MAR Sign...View the full answer
Answered By
PALASH JHANWAR
I am a Chartered Accountant with AIR 45 in CA - IPCC. I am a Merit Holder ( B.Com ). The following is my educational details.
PLEASE ACCESS MY RESUME FROM THE FOLLOWING LINK: https://drive.google.com/file/d/1hYR1uch-ff6MRC_cDB07K6VqY9kQ3SFL/view?usp=sharing
3.80+
3+ Reviews
10+ Question Solved
Related Book For
Project Management A Managerial Approach
ISBN: 978-0470533024
8th edition
Authors: Jack R. Meredith, Samuel J. Mantel Jr.
Question Posted:
Students also viewed these Management Leadership questions
-
In the template for finding bias (Figure), using the Actuals as shown, compare the estimating model shown in the figure with the following estimates: Base your comparison on the mean bias and the...
-
A producer of picture frames uses a tracking signal with limits of ±4 to decide whether a forecast should be reviewed. Given historical information for the past four weeks, compute the...
-
Cost estimates are inherently risky, irrespective of the estimation technique used. Suggest four ways in which the risk in a cost estimate can be reduced.
-
What impact does this have on the statement of cash flows using the indirect method? a.) If the balance of a current liability decreases during the accounting period, then that amount will be...
-
Use synthetic division to find the quotient and the remainder. a. (3x4 - x3 + 2x2 - 6x + 6) ( (x - 2) b. (x5 - 5) ( (x + 1)
-
Consider the Unity Gas proposed entry into the online ordering system in P1-42B. Bronson revises her estimates of the benefits from the new systems lower labor costs. She now thinks the savings will...
-
Conventional financial accounting suggests that environmental permits should be measured by using the historical cost principle. One alternative is that current market prices should be used instead....
-
Rodamex Inc. reported the following summary transactions during the year ended December 31, 2015: a. Sold merchandise for $ 5,000,000, including $ 500,000 cash and $ 4,500,000 on account, with terms...
-
Consider a sequential pay CMO that is backed by 6 0 mortgages with average balance of $ 1 0 0 , 0 0 0 each. The mortgages have monthly payments with WAM = 1 5 years and WAC = 4 % . There is a...
-
Aggregate planning: The company has decided to produce a new type of suspension assembly for a new car developed recently. The demands for this specific type of suspension assembly per month for the...
-
What should Emanon do now?
-
Conduct a discounted cash flow calculation to determine the NPV of the following project, assuming a required rate of return of 0.2. The project will cost $75,000 but will result in cash inflows of...
-
It is commonly asserted that low interest rates mean the Fed is following an easy, expansive monetary policy, while high interest rates imply a tight, contractive monetary policy. If monetary policy...
-
A multiple-choice question on a statistics quiz has possible correct answers of a, b, c, d, e. What is the probability that false is the correct answer?
-
Repeat the preceding exercise using these letters: RAWHOR. Express all probabilities as fractions
-
Consider the problem of automobile pollution in a large city in Central Asia. There are a million cars in the city, each emitting 10 grams of carbon monoxide (CO) per kilometer \((\mathrm{km})\)...
-
A: When a baby is born, it is a girl. B: When a second baby is born into a different family, it is also a girl. Independent and Dependent Events. (a) determine whether events A and B are independent...
-
If a day of the week is randomly selected, what is the probability that it is a day containing the letter y?
-
Research the Cuban missile crisis of 1962. Determine the possible strategies of the United States and the Soviet Union. Provide values to your payoff matrix. Determine what each side should do.
-
Consider the circuit of Fig. 7.97. Find v0 (t) if i(0) = 2 A and v(t) = 0. 1 3 ett)
-
Based on Exhibit B, the most appropriate recommendation regarding the triangular arbitrage trade is to: A. decline the trade, as no arbitrage profits are possible. B. execute the trade; buy BRL in...
-
BellSouth employed a number of measures to communicate the need for change. In the end, what was probably the main reason their customers accepted the change?
-
In what ways was the project scope expanded? Would you consider this to be scope creep? MINI CASE Reggie Brown, B&W Nuclear Service Companys (BWNS) project manager for Nita Light and Powers Green...
-
Given the results of the study, did the consensus approach indeed lead to a solution acceptable to all? Why wasnt everyone happy with this outcome?
-
1. A spotlight on a boat pictured below is 2.5 m above the water. A spotlight strikes the water at a point that is 8 meters behind the boat on the water's surface. The depth of the water is 4 m. How...
-
1. A high school athlete runs 1.00 x 102 m in 12.20 s. What is the velocity in m/s and km/h? 2. A person walks. 13 km in 2.0 h. What is the person's average velocity in km/h and m/s? 5. Suppose a car...
-
Suppose that a 0.225 m radius, 500 turn coil produces an average emf of 8800 V when rotated one-fourth of a revolution in 4.08 ms, starting from its plane being perpendicular to the magnetic field....
Study smarter with the SolutionInn App