Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

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

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

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image_2

Step: 3

blur-text-image_3

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Business Analysis With Microsoft Excel

Authors: Conrad Carlberg

3rd Edition

0789736640, 9780789736642

More Books

Students also viewed these Accounting questions

Question

What is involved in the administration of a labor agreement?

Answered: 1 week ago

Question

What are topics included in virtually all labor agreements?

Answered: 1 week ago