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.

 

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