Suppose you have a project with a Budget at Completion (BAC) of $250,000 and a projected length of 10 months. After tracking the project for six months, you have collected the information in the table below. a. Complete the table. How do Earned Value SPI (based on $) and Earned Schedule SPI differ? b. Calculate the schedule variances for the project for both Earned Value and Earned Schedule. How do the values differ?

Suppose you have a project with a Budget at Completion (BAC) of $250,000 and a projected length of 10 months. After tracking the project for six months, you have collected the information in the table below. a. Complete the table. How do Earned Value SPI (based on $) and Earned Schedule SPI differ? b. Calculate the schedule variances for the project for both Earned Value and Earned Schedule. How do the values differ?

Practical Management Science

6th Edition

ISBN:9781337406659

Author:WINSTON, Wayne L.

Publisher:WINSTON, Wayne L.

Chapter2: Introduction To Spreadsheet Modeling

Section: Chapter Questions

Problem 32P

See similar textbooks

Similar questions

Bad simulations Explain why each of the followingsimulations fails to model the real situation properly:a) Use a random integer from 0 through 9 to representthe number of heads when 9 coins are tossed. b) A basketball player takes a foul shot. Look at a ran-dom digit, using an odd digit to represent a good shot and an even digit to represent a miss.c) Use random numbers from 1 through 13 to represent thedenominations of the cards in a five-card poker hand.
An urn contains 10 red balls and 30 blue balls.a Suppose you draw 4 balls from the urn. Let Xi bethe number of red balls drawn on the ith ball (Xi 0 or1). After each ball is drawn, it is put back into the urn. Are the random variables X1, X2, X3, and X4 indepen-dent random variables? b Repeat part (a) for the case in which the balls are notput back in the urn after being drawn.
The process of packing 3 16-ounce bottles of Hershey chocolate syrup in super-sized packages like those sold at Sam’s and Costco is an example of:
You work for a small retail store. You must decide how many cases of kombucha to order. Twenty cases fit on a pallet and because of shipping costs, orders must be placed in multiples of 20. You can either order 20, 40, 60, 80 or 100 cases. Each case costs $15. If you order more than 1 pallet, you receive a discount of 5% per additional pallet ordered (2 pallets would be 5%, 3 would be 10%, etc). The cases can be sold for $25 each. Any that are left unsold can be sold to a discount store for $10. Your records suggest that the probability that you will sell 25 cases is 20%, 45 cases is 45%, 65 cases is 20% and 85 cases is 15%. a) Construct a payoff table to provide reflect the decisions and outcomes What would be your decision based on each of the following? Maximin Maximax Minimax regret Expected value Overall - what would you do? Why?
The production function q = 9K0.8L0.1 exhibits [increasing return to scale, constant return to scale, decreasing constant return to scale]
In Output 7.1: Is the (Pearson) chi-square statistically significant? Explain what it means. Are the expected values in at least 80% of the cells ≥ 5? How do you know? Why is this important?
In case of a production company which produces 3 different products (RE1, RE2, RE3), we know the following information: Measuring Unit RE1 RE2 RE3 Quantity unit 3,000,000 4,000,000 5,000,000 Sales Price Euro/unit 2,500 3,000 3,500 Production Cost Euro/unit 1,500 1,500 1,500 Consumption Factor kg/unit 0.02 0.04 0.01 Tasks: a) Has a company scarce resource if the company has only 250 tons raw material? b) Calculate the optimal composition of products! c) Determine the estimated total sales!
Lifang Wu owns an automated machine shop that makes precision auto parts. He has just compiled an input—output report for the grinding work center. Period 1 2 3 4 Total Planned input 70 70 85 85 Actual input 75 75 75 75 Deviation Planned output 75 75 75 75 Actual output 85 85 80 80 Deviation Initial backlog: 20 For the given information related to "inputs," the values for deviation and total are: The deviation in period 2 = units (enter your response as an integer, including a minus sign if necessary). Note:- Do not provide handwritten solution. Maintain accuracy and quality in your answer. Take care of plagiarism. Answer completely. You will get up vote for sure.
For a particular process, originally each 200 units of product manufactured yielded 180 conforming units, 9 units that must be scrapped, and the remaining units that must be reprocessed. Each scrapped unit results in a $30 loss and each reprocessed unit requires an extra 0.45 hours of processing time. The resource time of producing the original 200 units is 30 hours. As a result of a quality improvement program that was recently introduced, for each 200 units manufactured, the process now yields 190 conforming units, 4 unit to be scrapped, and the remaining units that must be reprocessed. Calculate the productivity (in units per hour) for the original process.
Lifang Wu owns an automated machine shop that makes precision auto parts. He has just compiled an input —output report for the grinding work center. Period 1 2 3 4 Total Planned input 90 90 95 95 Actual input 95 95 95 95 Deviation Planned output 85 85 85 85 Actual output 85 85 80 80 Deviation Initial backlog: 35 Part 2 For the given information related to "inputs," the values for deviation and total are: The deviation in period 2 = enter your response here units (enter your response as an integer, including a minus sign if necessary). Part 3 The deviation in period 4 = enter your response here units (enter your response as an integer, including a minus sign if…
A)What would the model be if the minimum calories were 450? B)What happens to the model if the total Liquid value is 3? C)What happens in the model if the coefficient of the objective function of peanut butter is 8? D)What should be the coefficient of the objective function for the cracker to be the basic variable? None of above less than 5.50 less than 1.43 less than 7.76 less than 6.56 E)What is the objective function value? Please donot provide solution in image format and it should be in step by step format and provide solution asap
When will you use scatter diagram?a. For 2 variables that have relationshipb. For 2 variables that have no relationshipc. For data that are inversely proportionald. For data that are directly proportionale. None of the above