Select Page

Managing Jobs or Projects to Measure Profitability

EzyLearn Online Course Case Studies using Excel, Xero, Social Media MarketingMYOB and Xero Training Course Case Study: Projects and Job Tracking – The $600 Shed

 

Project and Job Tracking using MYOB & Xero Accounting software training courses

 

This case study demonstrates how using MYOB and Xero can help you understand and control costs and always make a profit from each project with certainty.

See other case studies

 

 

Garden shed-on-slab example

Let’s consider the simple task of erecting a 3m x 3m garden shed. As long as the shed fits within certain parameters, like height,

Job Tracking, Projects in Xero, MYOB AccountRight & QuickBooks Online Training Courses to report profits for tradies and builders - garden shed

Col Western Sheds

distance from boundary and so forth, it will be exempt from council Development Applications (DA’s). In this way, any handyperson (and even the not so handy) can generally erect one.

 

This Micro Course is designed for our following online training courses:

 

Looks simple but can take days and several people

A typical backyard garden shed may look simple enough to build, according to websites from the shed manufacturers and hardware retailers like Bunnings. However, they’re a little complex for the average homeowner.

We’ll demonstrate the steps and typical scenarios that tradespeople go through and keep track of the income and costs using Job Tracking and Projects in MYOB and Xero.

The steps involved

Digging grass for concrete slab for Garden shed being erected at Newcastle investment property 2 - office admin courses - Advanced Xero Projects CourseThe following steps will be involved in the backyard shed erection:

  1. Measure size and slope of land
  2. Estimate how deep the land needs to be dug
  3. Work out how much steel reinforcement bars are needed
  4. How many bags of cement are needed?
  5. What type of cement is needed?
  6. Tools needed to complete the project
  7. Time for completion
  8. How many people are needed and when are they available?
  9. Whether the shed is onsite or does it need to be collected and delivered?
  10. Is there power to the site?
  11. What is the weather going to be like?

 

Expenses and trips to Bunnings or Mitre 10

Concrete slab 3 for Garden shed being erected at Newcastle investment property 2 - office admin courses - Advanced Xero Projects CourseIf you’ve ever had a handyman or tradesperson come to work at your house, you may have experienced that sometimes they won’t always have the tools, equipment or parts with them. Also, sometimes these tools and equipment can break.

Trips back and forth to Bunnings can cost the builder or handyman time (of the staff member) and money. This cost is paid using cash, credit card and/or sometimes on an account.

How do you keep track of these expenses?

Another spanner in the works can be lack of power to the work site. The handyman might need to wait around while a tenant or owner arrives at the site to provide power or water.

Sometimes the builder may need to wait for some of the parts to arrive, or they will need to organise to go and collect them.

In our training course scenario, the tradesperson will need to use his vehicle and two other people to collect the garage shed from Cardiff (in Newcastle) as the home owner didn’t want to pay the shed company $200 to have it delivered.

 

The $600 cost of the shed blows out to $4000 including labour and slab

Garden shed 3 being erected at Newcastle investment property 2 - office admin courses - Advanced Xero Projects CourseSo now you understand more about what’s involved in a simple building job, let’s do the transactions so you can understand why it’s so important to keep a tight control of time and costs. Key elements in this case study are:

  1. Some of the products are in stock, but more are needed to complete the job
  2. It takes two hours for the grass to be dug up and put aside
  3. A trip needs to be made to Bunnings for wood and nails for the formwork
  4. The formwork takes two hours to build
  5. One of the tradespeople has to go to Bunnings again to get the reinforcement and plastic sheeting
  6. It rains so they must leave the project for the day, after assembling the formwork
  7. They come back two days later (after completing another indoor job) and fill the formwork with concrete, bringing 10 bags of concrete from the depot and collecting another 10 bags from Mitre 10 on the way
  8. They fill the concrete and smooth it over then leave for the day
  9. Next Monday morning they go to the shed retailer and collect the shed to deliver it to the site (two hours in total after confirming that it has been paid and they have the right one – with the two sliding doors)
  10. They arrive at site and realise that their tools have no power; they need to ask the neighbour for use of their power and an extension cord
  11. They assemble the main outside frame but realise they need a third person and call for one of their workmates who is working 25 minutes away
  12. The 3rd worker is onsite for 30 minutes and the shed is fully assembled with roof and all.

 

[gravityform id=”1″ title=”true” description=”true”]

 

Learn about these features at the software vendors’ websites:

Xero Accounting Projects

MYOB AccountRight Job Tracking

QuickBooks Online Projects