Attached is an example of an Inventory report with 3 different projects. 1 Identify which projects are
Fantastic news! We've Found the answer you've been seeking!
Question:
Attached is an example of an Inventory report with 3 different projects.
1 Identify which projects are profitable projects or losing projects.
2 Try to explain why the projects are profitable or losing. You can explain each individual project.
3.3 Explain in words what the formula in Column “Project's Hour Budget” means.
4 Explain in words what the formula in Column “Remaining Hours per current invoices” means.
Transcribed Image Text:
Project # 1250.00 1260.00 1270.00 Project Leader Kevin Joe Jim A.B.C Architechts Projects' Details & Working Plan 2014 General Details Client Developer A Subtotal for Project Developer B Subtotal for Project Developer C Subtotal for Project Project Name Project A Project B Project C Milestones / Payment Terms Contract Info Retainer / Initial Payment Schematic Design Design Development Construction Documents Construction Administration Retainer / Initial Payment Schematic Design Design Development Construction Documents Construction Administration Retainer / Initial Payment Schematic Design Design Development Construction Documents Construction Administration Subtotal for Projects 70,000 sf - Residential 25,000 sf - Commercial 45,000 sf - Residantial Fee in Contract 50,000 120,000 150,000 250,000 130,000 700,000 20,000 40,000 55,000 75,000 45,000 235,000 30,000 60,000 80,000 150,000 80,000 400,000 1,335,000 Subcontract Amount Paid ors Fee (Total) 50.000 120,000 150,000 5,000 12,000 15,000 25,000 13,000 70,000 0 0 70,000 320,000 20,000 40,000 Project Mapping Paid to Sub- contractors 60,000 30,000 60,000 80,000 150,000 320,000 700,000 5,000 12,000 15.000 32,000 0 0 32,000 Outstanding Invoices 100,000 100,000 0 Collection $110 Invoice $110 Due to Sub- Contractor S 10,000 10,000 0 0 0 100,000 10,000 Remaining Balance in Contract 0 0 0 135,000 117,000 252,000 0 0 55.000 75,000 45,000 175,000 0 0 0 0 80,000 80,000 507,000 Hours 2014 Work Hours Before 2014 400.0 500.0 0.0 0.0 0.0 900.0 200.0 0.0 0.0 0.0 0.0 200.0 78.0 0.0 0.0 0.0 0.0 78.0 1,178.0 Total Hours 2014 0 755 1,025 810 0 2,590 0 280 48 0 0 328 151 440 509 1,121 45 2,266 5,184 Project's Hour Budget 409 982 1,227 2.045 1,064 5,727 182 364 500 682 409 2,136 273 545 727 1,364 727 3,636 11,500 Profitability Current Total Hours ***:-****- 1,255 1,025 3.490 0 0 528 229 440 509 1,121 45 2,344 6,362 30/11/2014 Remaining Hours per current invoices 9 -273 202 8 0 -54 -18 84 -48 0 0 17 44 105 218 243 -45 565 529 Total Remaining Hours 9 -273 202 1,235 1,064 2,237 -18 84 452 682 409 1,608 44 105 218 243 682 1,292 5,138 Project # 1250.00 1260.00 1270.00 Project Leader Kevin Joe Jim A.B.C Architechts Projects' Details & Working Plan 2014 General Details Client Developer A Subtotal for Project Developer B Subtotal for Project Developer C Subtotal for Project Project Name Project A Project B Project C Milestones / Payment Terms Contract Info Retainer / Initial Payment Schematic Design Design Development Construction Documents Construction Administration Retainer / Initial Payment Schematic Design Design Development Construction Documents Construction Administration Retainer / Initial Payment Schematic Design Design Development Construction Documents Construction Administration Subtotal for Projects 70,000 sf - Residential 25,000 sf - Commercial 45,000 sf - Residantial Fee in Contract 50,000 120,000 150,000 250,000 130,000 700,000 20,000 40,000 55,000 75,000 45,000 235,000 30,000 60,000 80,000 150,000 80,000 400,000 1,335,000 Subcontract Amount Paid ors Fee (Total) 50.000 120,000 150,000 5,000 12,000 15,000 25,000 13,000 70,000 0 0 70,000 320,000 20,000 40,000 Project Mapping Paid to Sub- contractors 60,000 30,000 60,000 80,000 150,000 320,000 700,000 5,000 12,000 15.000 32,000 0 0 32,000 Outstanding Invoices 100,000 100,000 0 Collection $110 Invoice $110 Due to Sub- Contractor S 10,000 10,000 0 0 0 100,000 10,000 Remaining Balance in Contract 0 0 0 135,000 117,000 252,000 0 0 55.000 75,000 45,000 175,000 0 0 0 0 80,000 80,000 507,000 Hours 2014 Work Hours Before 2014 400.0 500.0 0.0 0.0 0.0 900.0 200.0 0.0 0.0 0.0 0.0 200.0 78.0 0.0 0.0 0.0 0.0 78.0 1,178.0 Total Hours 2014 0 755 1,025 810 0 2,590 0 280 48 0 0 328 151 440 509 1,121 45 2,266 5,184 Project's Hour Budget 409 982 1,227 2.045 1,064 5,727 182 364 500 682 409 2,136 273 545 727 1,364 727 3,636 11,500 Profitability Current Total Hours ***:-****- 1,255 1,025 3.490 0 0 528 229 440 509 1,121 45 2,344 6,362 30/11/2014 Remaining Hours per current invoices 9 -273 202 8 0 -54 -18 84 -48 0 0 17 44 105 218 243 -45 565 529 Total Remaining Hours 9 -273 202 1,235 1,064 2,237 -18 84 452 682 409 1,608 44 105 218 243 682 1,292 5,138
Expert Answer:
Answer rating: 100% (QA)
1 IDENTIFY WHICH PROJECTS ARE PROFITABLE PROJECTS OR LOSING PROJECTS Project A is a profitable proje... View the full answer
Related Book For
Posted Date:
Students also viewed these business communication questions
-
Identify whether each scenario is an example of a marginal cost, marginal benefit, or neither. Sort each scenario into the correct category. All options should be placed. 1. Jonthana is the chef and...
-
Explain how sequential skimming is an example of price segmentation.
-
Which of the following is an example of an inventory item that would best suit the specific identification inventory method: a. Pile of birds-eye gravel at the local gravel pit b. Cartons of...
-
A curve C in three dimensions is given parametrically by (x(t), y(t), z(t)), where t is a real parameter, with a t b. Show that the equation of the tangent line at a point P on this curve where t...
-
A fraud investigator might construct a fraud- triangle profile of a suspect that includes both work and personal data. Identify the three elements (sides) of a fraud- triangle profile.
-
For which of the following reasons is the recognition as an asset of an internally generated intangible prohibited? (a) Because there may not be an active market for that asset (b) Because its cost...
-
DeLaval turbine is a/an _____.
-
Southeast Suites operates a regional hotel chain. Each hotel is operated by a man-ager and an assistant manager/ controller. Many of the staff who run the front desk, clean the rooms, and prepare the...
-
How do advanced hazard analysis techniques, such as Bowtie Analysis and Layer of Protection Analysis (LOPA), assist in designing and implementing effective risk control measures and safety barriers?...
-
The accounts in the ledger of Time Is Money Delivery Service contain the following balances on July 31, 2015. Accounts Receivable ......... $10,642 Prepaid Insurance ............ $ 1,968 Accounts...
-
Hanks Company has prepared the following changes in account balances for the spreadsheet to support its 2016 statement of cash flows: Additional information : The net income was $1,300. Depreciation...
-
What structural feature allows DNA to store information?
-
Describe the molecular process of X-chromosome inactivation. This description should include the three phases of inactivation and the role of the Xic. Explain what happens to the X chromosomes during...
-
W hat would you predict to be the phenotype of a Drosophila larva whose mother was homozygous for a loss-of-function allele in the nanos gene?
-
The alignment of homologs along the metaphase plate during metaphase of meiosis I is random. In your own words, explain what this means.
-
Scurs in cattle is a sex-influenced trait. A cow with no scurs whose mother had scurs has offspring with a bull with scurs whose father had no scurs. What is the probability of each of the following...
-
For a two-tailed test with a sample size of 18 and a 0.20 levelof significance, the t value is _____.a. 1.333b. 0.863c. 1.328d. 1.7292 answers
-
The following information is for Montreal Gloves Inc. for the year 2020: Manufacturing costs Number of gloves manufactured Beginning inventory $ 3,016,700 311,000 pairs 0 pairs Sales in 2020 were...
-
Whose income do you predict will be more affected by the expansion of Internet access: a. Stockbrokers or lawyers? b. Doctors or pharmacists? c. Bookstore owners or the owners of galleries that sell...
-
Indicate how you think each of the following would shift demand in the indicated market: a. The incomes of buyers in the market for Adirondack vacations increases. b. Buyers in the market for pizza...
-
Jones, who is currently unemployed, is a participant in three means-tested welfare programs: food stamps, rent stamps, and day care stamps. Each program grants him $150 per month in stamps, which can...
-
1. Describe the bases of power held by Dr. Jamie Thompson. Describe the bases of power held by Dr. Elizabeth Clarke. 2. What activities and people have contributed to Jaime Thompsons power? What...
-
What is the current in the wire in Figure Q22.1? 1.0 VR + 1.0-1.0V + FIGURE Q22.1
-
Electroplating uses electrolysis to coat one metal with another. In a copper-plating bath, copper ions with a charge of +2e move through the electrolyte from the copper anode to the cathode the metal...
Study smarter with the SolutionInn App