Attached is an example of an Inventory report with 3 different projects.

3.1 Identify which projects are profitable projects or losing projects.

3.2 Try to explain why the projects are profitable or losing. You can explain about each individual project.

3.3 Explain in words what does the formula in Column Project's Hour Budget means.

3.4 Explain in words what does the formula in Column Remaining Hours per current invoices means.

30/11/2014 Collection A.B.C Architechts Projects' Details & Working Plan 2014 $110 $110 Invoice General Details Project Mapping Hours 2014 Project Leader Project # Client Project Name Due to Sub- Contractor Fee in Contract Milestones / Payment Terms Contract Info Subcontract Amount Paid ors Fee (Total) Paid to Sub- contractors Outstanding Invoices Remaining Balance in Contract Work Hours Total Hours Before 2014 2014 Project's Hour Budget Total Remaining Hours S 1250.00 50.000 120,000 150,000 5,000 12,000 15.000 Kevin Retainer / Initial Payment Schematic Design Design Development Construction Documents Construction Administration Developer A Project A 70,000 sf - Residential 5,000 12,000 15,000 25,000 13,000 70,000 100,000 10,000 Subtotal for Project 32,000 100,000 10,000 320,000 20,000 40,000 1260.00 Joe Developer B Retainer / Initial Payment Schematic Design Design Development Construction Documents Construction Administration Project B 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 9 -273 202 1,235 1,064 2,237 -18 84 452 682 409 Profitability Remaining Current Hours per Total Hours current invoices 400 9 1.255 -273 1,025 202 810 8 0 0 3,490 -54 200 18 280 84 48 -48 0 0 0 0 528 17 229 44 440 105 509 218 1,121 243 45 -45 2,344 565 6,362 529 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 25,000 sf - Commercial 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 0 755 1,025 810 0 2,590 0 280 48 0 0 328 151 440 509 1.121 45 2,266 5,184 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 Subtotal for Project 0 0 0 0 1,608 1270.00 60,000 30,000 60,000 80,000 150,000 Jim Developer Retainer / Initial Payment Schematic Design Design Development Construction Documents Construction Administration Project C 45,000 sf - Residantial 44 105 218 243 682 1,292 5,138 Subtotal for Project Subtotal for Projects 0 70,000 320,000 700,000 0 32,000 0 100,000 0 10,000