Create a balance sheet using the current information given, This is for a service selling app like
Question:
Create a balance sheet using the current information given, This is for a service selling app like uber, craigslist, kijiji.
Rent
We have rented out a 3,320 square feet office space in Mississauga. The rental costs $15/sqft per year.
Salary
Every team has the standard 8 hours a day and 40 hours a week working hours. However, we want to give the employees flexibility in working times so they are not restricted to a 9am-5pm or 8am-4pm but they can work at whichever time works best for them. That being said, they are all expected to be present for team meetings regardless of time period. Moving on to the breakdown of employee salary:
Dev team:
- Manager - $150,000 salary
- Each Member - $110,000 salary
Marketing team:
- Manager - $90,000 salary
- Each Member - $65,000 salary
Communication team
- Manager - $80,000 salary
- Each Member - $55,000 salary
Design team
- Manager - $100,000 salary
- Each Member - $85,000 salary
Finance team
- Manager - $100,000 salary
- Each Member - $75,000 salary
HR team
- Manager - $95,000 salary
- Each Member - $75,000 salary
Supplies
Chairs
- 36 office chairs - $4,320
Tables
- 24 individual desks - $4,056
- 2 conference tables - $1,100
Lounge room
- 4 tables and 16 chairs - $536
IT Hardware
- 24 iMac with mouse and keyboard - $49,440
- 2 Macbook Pro for conference rooms - $3,398
- 4 iPad Pro with Apple Pencil - $4,672
- 2 Epson Projector - $2,878
IT Software
- Microsoft Visual Studio Professional Edition - $45/month
- Microsoft Office 365 E3 - $46.20/month/user
- SharpSpring - $399/month
- Zendesk - $99/month/agent
- Adobe Creative Cloud All Apps - $66/month
- Quickbooks - $30/month
- Eddy - $49/month + $8/month/employee
Marketing
We plan to do our advertising and marketing in main ways but not limited to; website, online, and social media.
- Website - $15,000/year
- Online - $12,000/year
- Social Media - $7,500/year
Utilities
Energy
- Hydro One - $217.12/month
Internet
- Bell Fibe - $129.95/month
Phone
- Bell Total Connect - $34.91/month
Insurance
By law, Ontario requires that businesses have at least business, or general, liability insurance.
Zensurance
- General liability insurance - $650/year
WSIB
- Workers compensation insurance - $28,765/year
| Monthly Cost | Yearly Cost | One Time | |
| Rent | $4,150 | $49,800 | |
| Salary | $158,749 | $1,904,988 | |
| Supplies | $2,034 | $24,406 | $70,400 |
| Marketing | $2,875 | $34,500 | |
| Utilities | $381.98 | $4583.76 | |
| Insurance | $2,451 | $29,415 |
