Following are data for preparing a profitability report for five different projects.

1.1. You are required to prepare an Excel spreadsheet that present the profit and loss for each of the projects below.

Projects data: 4 Park Avenue South – Income: $100,934, Subcontractors $23,400, hours spent 324 hours.

189 Broadway, Brooklyn – Income: $327,954, Subcontractors $57,000, hours spent 1,020 hours.

245 East 54th St. – Income: $72,000, Subcontractors $5,600, hours spent 952 hours.

102 West 41st St. – Income: $350,000, No Subcontractors, hours spent 1,564 hours.

315 S. Biscayne Blvd. Miami – Income: $427,000, Travel Expenses $50,254, hours spent 2,420 hours.

* The average cost per hour is $110.

1.2. You are required to present in a graph the profitability of the project.

Appendix A – invoice no. 1

A.B.C Architects New York, NY Attn: Mr Jones Re: Project 129 East 31st For professional services rendered for the last period for the referenced project.

Initial Payment $20,000 X 100% = $20,000

Schematic Design $40,000 X 25% = $10,000

Total fee $30,000

Paid up to date $0

Total current billing $30,000