SmartExpert

(118)

$30/per page/Negotiable

About SmartExpert

Levels Tought:
Elementary,Middle School,High School,College,University,PHD

Expertise:
Accounting,Business & Finance See all
Accounting,Business & Finance,Economics,English,HR Management,Math Hide all
Teaching Since: Apr 2017
Last Sign in: 8 Weeks Ago
Questions Answered: 7559
Tutorials Posted: 7341

Education

  • BS,MBA, PHD
    Adelphi University/Devry
    Apr-2000 - Mar-2005

Experience

  • HOD ,Professor
    Adelphi University
    Sep-2007 - Apr-2017

Category > Business & Finance Posted 30 Jul 2017 My Price 10.00

Waste Wizard

Waste Wizard

Waste Wizard is a commercial waste management company with both collection and landfill disposal operations. This case focuses on the waste collection unit. Waste collection is an asset-intensive business, involving a large fleet of vehicles, and the success of the business relies on high levels of operational efficiency and asset utilization.

Anecdotal evidence suggests that the Waste Wizard collection unit contains a number of inefficiencies and opportunities for improvement. The challenge facing the management team is that many improvement opportunities require an upfront investment and they do not have a robust tool to quantify the financial benefits of making incremental improvements as an operational metric.

Background to Project

Waste Wizard is a commercial (B2B) waste management company with both collection and landfill disposal operations. It had revenues (or “turnover”) in FY2013 of over $300 million. This report covers the collection unit only, which deploys a large fleet of vehicle assets to collect waste from over 200,000 commercial customers distributed over a wide geographical area. The main business process is simple. Each vehicle leaves a depot and drives a route that covers a number of customers. At each customer location the vehicle empties the customer’s garbage bins into the back of the truck (an action referred to as a “lift”). Once the truck is full it drives to a landfill location to be unloaded. Waste Wizard’s customers are billed a fixed amount each time their garbage bin is emptied, with pricing based on the volume of the bin (in m3). The collection unit incurs a cost at the landfill gate for the amount of refuse it unloads, with pricing based on the weight disposed (in tonnes). This volume / weight mismatch between revenue and cost represents a fundamental tension in Waste Wizard’s finances that needs to be actively managed.

Analysis of Operating System

Waste Wizard’s operating system is based on deploying a number of assets and processes, as outlined in the table below. The business is asset-intensive, and it involves a simple, commoditized product with limited opportunities for differentiation. As a result, the business pursues a low-cost strategy and requires supporting strategic capabilities including maximizing asset utilization, minimizing cost-to-serve, and achieving economies of scale in indirect costs (SG&A, fleet management, and corporate overheads).

Because the business operates at thin margins, Waste Wizard has been reluctant to invest in new technologies unless a clear financial gain can be demonstrated, however the business lacks the analytical sophistication to be able to link improvements in operational metrics to financial benefits.

In the analysis below you should:

1. Build a ROIC tree that quantitatively links operational metrics to financial performance. This is best done using a spreadsheet. Then, identify three operational key performance indicators (KPIs) to be analyzed in detail.

 

Appendix 1: Income StatementFY2013 ($)

Revenue

395,784,823

Revenue - Intercompany

9,357,264

Waste Levy Paid

-7,352,923

OPERATING REVENUE

397,789,163

Labor and Subcontractors

59,885,500

Disposal

64,851,954

Other Operating Costs

117,882,631

Selling, General & Admin Exp

25,404,393

Other Income & Expense

-3,206,425

Management Fees

15,360,750

Non recurring items

-

EBITDA

117,610,360

Depreciation

46,853,756

Intangibles Amortisation

795,912

EBIT

69,960,692

 

Landfill Time Adj

-808,257

Interest Intercompany

-13,571,101

Interest Expense

1,579,282

Interest Income

-133,277

Equity Earnings

-5,792,880

FX Adjustments & Dividends

-222

PRETAX

88,687,145

Taxation

18,624,300

NPAT

70,062,845

 

Implied effective tax rate

21.0%

 

 

Statement

 

Balance Sheet

Income

 

Current Asset

32,816,000

   

Current Liability

37,207,000

   

Working Capital

-4,391,000

Total income

0

PPE

122,446,000

Total expenses

 

Goodwill

107,854,000

Operating profit/EBIT

69,960,692

Fixed Asset

230,300,000

Tax

 

Inversed Capital

225,909,000

NPAT

70,062,845

   

ROIC

31.0 %

   

 

Revenue

 
 

Existing

What if

%

 

Number Trucks

782

785

0.0 %

 

Number Lifts

3,755,287

3,792,840

1.0 %

37,533

Trucks Unit Lifts

4,802

4,850

1.0 %

 

Bin Volume

       

Collected

10,787,872

10,787,872

0.0 %

 

Trucks Unit Volume

13,795

13,795

0.0 %

 

Number of customers

225,191

225,191

0.0 %

 

Customers unit volume

47.91

47.91

0.0 %

 

No Days

330

327

-1.0 %

 

No Lifts Per Day

11,380

11,610

2.0 %

 

Vol per Day

32,691

33,021

1.0 %

 

Revenue

395,784,823

     

Expenses

 

Price average

36.69

     

Disposal Cost

64,851,954

     

Disposal Quantity

979,288

     

Disposal Average

66.22

     

Trucks Average km

42,971

     

Truck Total Km

33,603,322

     

Truck km/liters

1.19

     

Truck liters

28,238,086

     

Truck liters cost

1.95

     

Truck Fuel Cost

55,064,267

     

Truck Unit R&M

27,764

28,042

1.0 %

217,114

Truck R&M Cost

21,711,448

21,928,562

1.0 %

 

Truck Driver Hourly

15.21

15.21

0.0 %

 

Truck Hour Shift

10.00

10.00

0.0 %

 

Labor Shift Per Day

33.0

32.7

-1.0 %

 

Truck Labor Cost

129,528,056

126,950,447

2.0%

-277,608

 

 

 

 

 

invested Capital

KPI

Old ROIC

New ROIC

Revenue Lift per truck no days

31.0%

32.2%

Cost truck unit->operating cost

31.0%

30.9%

Cost Driver hourly->Operating cost

31.0%

30.4%

Answers

(118)
Status NEW Posted 30 Jul 2017 05:07 PM My Price 10.00

Was-----------te -----------Wiz-----------ard-----------

Attachments

file 1501435485-Waste Wizard.xlsx preview (212 words )
Re-----------ven-----------ueR-----------eve-----------nue----------- - -----------Int-----------erc-----------omp-----------any-----------Was-----------te -----------Lev-----------y P-----------aid-----------OPE-----------RAT-----------ING----------- RE-----------VEN-----------UEL-----------abo-----------r a-----------nd -----------Sub-----------con-----------tra-----------cto-----------rsD-----------isp-----------osa-----------lOt-----------her----------- Op-----------era-----------tin-----------g C-----------ost-----------sSe-----------lli-----------ng,----------- Ge-----------ner-----------al -----------&am-----------p;a-----------mp;----------- Ad-----------min----------- Ex-----------pOt-----------her----------- In-----------com-----------e &-----------amp-----------;am-----------p; -----------Exp-----------ens-----------eMa-----------nag-----------eme-----------nt -----------Fee-----------sNo-----------n r-----------ecu-----------rri-----------ng -----------ite-----------ms------------EBI-----------TDA-----------Dep-----------rec-----------iat-----------ion-----------Int-----------ang-----------ibl-----------es -----------Amo-----------rti-----------sat-----------ion-----------EBI-----------TLa-----------ndf-----------ill----------- Ti-----------me -----------Adj-----------Int-----------ere-----------st -----------Int-----------erc-----------omp-----------any-----------Int-----------ere-----------st -----------Exp-----------ens-----------eIn-----------ter-----------est----------- In-----------com-----------eEq-----------uit-----------y E-----------arn-----------ing-----------sFX----------- Ad-----------jus-----------tme-----------nts----------- &a-----------mp;-----------amp-----------; D-----------ivi-----------den-----------dsP-----------RET-----------AXT-----------axa-----------tio-----------nNP-----------ATI-----------mpl-----------ied----------- ef-----------fec-----------tiv-----------e t-----------ax -----------rat-----------eSt-----------ate-----------men-----------tBa-----------lan-----------ce
Not Rated(0)