Calculate the actual value of work done and the total actual profit contribution from all the projects as of the 31st of March. You are currently working as a planner in a construction company. Thecompany is currently running 4 different construction works. The monthlyplanned value of work done for each project is according to the schedule asshown in Table 2.Table 2: The Planned Value of Work Done ScheduleApril120,000140,00090,000120,000JanFebMarchProject AProject BProject CProject D60,000100,00080,000120,000100,00080,00080,000120,000120,000120,00070,000100,000Мay200,000140,000100,000150,000Based on the data obtained from each project, you have found out the value ofwork done on the 31st of March, which is shown in Table 3 below.Table 3: The Actual Value of Work Done and Direct Cost Incurred as of the31st of MarchProjectActual Value of Work Direct Cost IncurredDoneA300,000250,000250,000280,000220,000180,000200,000240,000BDEach project is supposed to contribute 10% profit and 8% overhead to thecompany. You are requested to present to the company the turnover as of the31st of March. Prepare your answer by answering the following questions.

The actual value of work done is given for each project and direct cost. The overhead is indirect…

You are currently working as a planner in a construction company. The company is currently running 4 different construction works. The monthly planned value of work done for each project is according to the schedule as shown in Table 2. Table 2: The Planned Value of Work Done Schedule Jan Project A Project B Project C Project D 60,000 100,000 80,000 120,000 Feb 100,000 80,000 80,000 120,000 March 120,000 120,000 70,000 100,000 April 120,000 140,000 90,000 120,000 May 200,000 140,000 100,000 150,000

You are currently working as a planner in a construction company. The company is currently running 4 different construction works. The monthly planned value of work done for each project is according to the schedule as shown in Table 2. Table 2: The Planned Value of Work Done Schedule Jan Project A Project B Project C Project D 60,000 100,000 80,000 120,000 Feb 100,000 80,000 80,000 120,000 March 120,000 120,000 70,000 100,000 April 120,000 140,000 90,000 120,000 May 200,000 140,000 100,000 150,000

Essentials of Business Analytics (MindTap Course List)

2nd Edition

ISBN:9781305627734

Author:Jeffrey D. Camm, James J. Cochran, Michael J. Fry, Jeffrey W. Ohlmann, David R. Anderson

Publisher:Jeffrey D. Camm, James J. Cochran, Michael J. Fry, Jeffrey W. Ohlmann, David R. Anderson

Chapter8: Time Series Analysis And_forecasting

Section: Chapter Questions

Problem 13P: The values of Alabama building contracts (in millions of dollars) for a 12-month period are as...

See similar textbooks

Similar questions

launching new software with in 5 months at a cost of $ 5000 can be categorized under a. Scope b. Objective c. Project goal
Assume you are the project manager for the Tidal 2 software project. You have been asked to calculate the expected cost for the project. Your company's database indicates that developers can handle eight function points each person-month and that the cost per developer at your firm is $8,400 per month. You and your team of five developers have come up with the following requirements: (Round your "Estimated duration" answer to 2 decimal places.) Elements Inputs Outputs Inquiries Files Interfaces Count 27 21 21 45 35 Complexity Low Low High Medium High Calculate the total number of function points and the estimated cost and duration of the Tidal project? (Use “complexity weighting"). Estimated total number of function points Estimated cost Estimated duration months
(b) List of Accounts Assume that John William has reviewed his work schedule and decided that it makes sense to complete this project on time. Assuming that he now believes that the probability for completing the project on time is 93% and otherwise it will be finished 1 week late, determine the transaction price. Transaction price Attempts: 2 of 3 used $
Q2: A project manager has a generator construction project that needs to be completed in 1 year and the entire financial plan of this project is $200,000. An evaluation meeting occurred at the beginning of the seventh month. The results of the meeting are that $120,000 have been spent till now and the actual percentage of completion is 40%. However, the schedule indicates that 50% of the work must be finished. Please answer the following questions: 1- How efficiently are we using our time? 2- Will we be ahead or behind schedule? 3- How efficiently are we using our cost? 4- Will we be under or over budget?
QUESTION 7 Use the information in the table below for the following 5 q A capital investment project is estimated to have the follow 1 21 4 -$60,000 $20,000 $22,500 $17,500 $25,000 The company utilizes a discount rate of 15% to evaluate ca thoose the closest answer. Assume cash flows are receive The NET PRESENT VALUE for the project shown above is: D-$4,789.25
Start with the partial model in the file attached. Marvel Pence, CEO of Marvel’s Renovations, a custom building and repair company, is preparing documentation for a line of credit request from his commercial banker. Among the required documents is a detailed sales forecast for parts of 2020 and 2021: Sales Labor and Raw Materials May, 2020 $75,000 $80,000 June, 2020 $115,000 $75,000 July, 2020 $145,000 $105,000 August, 2020 $125,000 $85,000 September, 2020 $120,000 $65,000 October, 2020 $95,000 $70,000 November, 2020 $75,000 $30,000 December, 2020 $55,000 $35,000 January, 2021 $45,000 N/A Estimates obtained from the credit and collection department are as follows: collections within the month of sale, 20%; collections during the month following the sale, 60%; collections the second month following the sale, 25%. Payments for labor and raw materials are typically made during the month following the…
Start with the partial model in the file attached. Marvel Pence, CEO of Marvel’s Renovations, a custom building and repair company, is preparing documentation for a line of credit request from his commercial banker. Among the required documents is a detailed sales forecast for parts of 2020 and 2021: Sales Labor and Raw Materials May, 2020 $75,000 $80,000 June, 2020 $115,000 $75,000 July, 2020 $145,000 $105,000 August, 2020 $125,000 $85,000 September, 2020 $120,000 $65,000 October, 2020 $95,000 $70,000 November, 2020 $75,000 $30,000 December, 2020 $55,000 $35,000 January, 2021 $45,000 N/A Estimates obtained from the credit and collection department are as follows: collections within the month of sale, 20%; collections during the month following the sale, 60%; collections the second month following the sale, 25%. Payments for labor and raw materials are typically made during the month following the…
Start with the partial model in the file attached. Marvel Pence, CEO of Marvel’s Renovations, a custom building and repair company, is preparing documentation for a line of credit request from his commercial banker. Among the required documents is a detailed sales forecast for parts of 2020 and 2021: Sales Labor and Raw Materials May, 2020 $75,000 $80,000 June, 2020 $115,000 $75,000 July, 2020 $145,000 $105,000 August, 2020 $125,000 $85,000 September, 2020 $120,000 $65,000 October, 2020 $95,000 $70,000 November, 2020 $75,000 $30,000 December, 2020 $55,000 $35,000 January, 2021 $45,000 N/A Estimates obtained from the credit and collection department are as follows: collections within the month of sale, 20%; collections during the month following the sale, 60%; collections the second month following the sale, 25%. Payments for labor and raw materials are typically made during the month following the…
Q3: An engineer determined the payback period of the project contract to be 9 years. The following table presents the project contact cost information: Annual cost First cost 15 M Salvage 5 M Contract 3M Ifi-13%, do you agree with that an engineer, and why?
Can Please Help Me: Engineering Economics/Civil Engineering 60 minutes only the given time. Wish you could help me. I will give UPVOTE and GOOD FEEDBACK. ////Question How many years are acquired for Php 1,000 to increase to Php 2,000 if invested at 9% per year compounded annually, semi-annually, quarterly, monthly, daily and continuously? ////Question
The values of Alabama building contracts (in millions of dollars) for a 12-month period are as follows: Construct a time series plot. What type of pattern exists in the data? Compare a three-month moving average forecast with an exponential smoothing forecast. Use α = 0.2. Which provides the better forecasts based on MSE? What is the forecast for the next month using exponential smoothing with α = 0.2?
The following were the data obtained by the manager for the first 3 quarters for 2020: Maintenance Machine Quarter Costs Hours 1st quarter 1,520,000 50,000 2nd quarter 1,718,300 62,000 3rd quarter 1,526,000 46,000 How much is the expected maintenance costs for November 2020, if the expected machine hours is 33,000?