• Internal Code :
  • Subject Code :
  • University :
  • Subject Name : Management

Data Analysis and Recommendation Assignment

In this case study, A “Shovel” is a hydraulic excavator used to extract ore from the ground onto a truck for transport, it is used in the mining for an Open -pit mining operation. Mining unit has been able to get the detail data for the trucks working for their speed and ideal time minute by minute. The Company is also have high cost equipment’s and high fixed cost and overheads. The expenses were budgeted and now the actual has also been received.

This data is analysed for both variance analysis of budget vs actual and also for the time and speed data for the trucks to identify the trends if any. Results are shared as below to find to a conclusion to provide a recommendation. This table can be found in the attached Excel file under the “Truck Geospatial Output” tab. The geospatial data for the mine are provided, After analysing the available data, which is only for one day, no specific trend was identified may be because the data is only for one day which can be a normal idle day as per the efficiency of the Truck is concerned.

  • All the data is tabulated in the as per table below to calculate the overall scenario and on the basis of that few charts and trend lines have been created which show the following:-
  • Average speed of all trucks range similar and are between 8.2 to 10.41, so not very high variance
  • There is not trend in night vs day working
  • Truck H11 seems to be most efficient among all four in terms of KM and Total Time Worked
 

H10

H11

H12

H13

 

Total

Day

Night

Total

Day

Night

Total

Day

Night

Total

Day

Night

Average Speed of Truck

9.15

9.18

9.56

9.30

8.28

10.43

8.62

8.00

9.40

8.86

8.26

9.52

Total Time Worked in Hours

7.19

3.35

3.44

8.02

4.05

3.57

7.54

3.44

4.1

7.58

3.51

4.07

Average Kilometres done

0.078

0.080

0.077

0.07

0.06

0.080

0.07

0.07

0.06

0.072

0.72

0.72

Total Kilometres

210.5

105.4

105.1

213.

99.3

114.5

199.

96.0

103

203.

99.1

104.

 

 

H10

H11

H12

H13

 

Total

Total

Total

Total

Total Time Worked in Hours

7.19

8.02

7.54

7.58

Total Kilometers

210.566

213.95

199.501

203.957

The financial information is processed to identify the reasons for the difference between budget and actual. Suggestions are provided on improving the budgeting process and the benefits of improving operations (e.g. create three scenarios may be there which will improve the financial position of the mine)

On the basis of data available Variances are calculated for Revenue , Variable Cost , Fixed Cost and Total Cost and it is projected in bar charts with trend line showing the variance % also.

Monthly variance shows that is a good amount of variance in budget vs actual, which is an indication of gaps in the budgeting process. To improve the process we can identity the gaps in the overall budgeting process as shared in the recommendation.

Excel File attached

Total Fixed Cost

 

Budget

1,28,33,333.33

   

Actual

1,61,83,333.33

Other cost

 

Budget

3,53,33,333.33

   

Actual

3,74,73,706.33

TOTAL COST/mnth

 

Budget

4,81,66,666.67

   

Actual

5,36,57,039.67

     

-54,90,373.00

     

-11%

Budget Variance of 11% is treated as huge variance and specially in the fixed cost also there is variance 26% which can easily be reduced

Recommendation:

Budgets are prepared on the basis of previous data , market research and current information and future prediction or forecast.

Management in this case should revisit their budgeting process by :

  • Breaking the whole budgets into different activities and analysing the variances activity wise to identify the gap , currently two broad numbers are Variable cost and Fixed cost
  • Variance in monthly Variable cost though there is a difference in budget vs actual but it is consistent except only in the month of June
  • Budgets for Variable cost is always higher whereas Actuals are lower. But overall Total Variance shows that Actuals are more than Budgets
  • This gap is majorly because of Fixed cost by 26%
  • So the management needs to improve the Budgeting of fixed cost , or improvement in terms of Asset utilization planning
  • Management should fix the rate of Fixed cost / hour or truck for better and accurate budgets
  • Standard Costing method can be applied for various activities to define the budgeted rates for all activities to observe the fixed cost properly and reduce the difference between Actual vs Budgeted Fixed Cost
  • Idle time can be found from speed graphs and trucks can be put to use in that time to get more output which will reduce the overhead cost /day /truck

Remember, at the center of any academic work, lies clarity and evidence. Should you need further assistance, do look up to our Management Assignment Help

Get It Done! Today

Applicable Time Zone is AEST [Sydney, NSW] (GMT+11)
Not Specific >5000
  • 1,212,718Orders

  • 4.9/5Rating

  • 5,063Experts

Highlights

  • 21 Step Quality Check
  • 2000+ Ph.D Experts
  • Live Expert Sessions
  • Dedicated App
  • Earn while you Learn with us
  • Confidentiality Agreement
  • Money Back Guarantee
  • Customer Feedback

Just Pay for your Assignment

  • Turnitin Report

    $10.00
  • Proofreading and Editing

    $9.00Per Page
  • Consultation with Expert

    $35.00Per Hour
  • Live Session 1-on-1

    $40.00Per 30 min.
  • Quality Check

    $25.00
  • Total

    Free
  • Let's Start

Get
500 Words Free
on your assignment today

Browse across 1 Million Assignment Samples for Free

Explore MASS
Order Now

Request Callback

My Assignment Services- Whatsapp Tap to ChatGet instant assignment help

Hire Certified Experts
Ask your Question
Need Assistance on your
existing assignment order?

We care

MyAssignmentServices uses cookies to deliver the best experience possible.
My Assignment Services acknowledges the academic integrity guidelines prescribed as per Australian Universities to ensure that the services, sample material, and study resources available on our website, in no way are utilised to commit academic misconduct of any type. All users of our services must adhere to and affirm acceptance of all conditions elucidated in our policy document on academic integrity.

Please accept and affirm the following to be able to continue exploring our website and services: I agree to NOT use any educational material, study resources, assignment samples, online mentoring services, available on the web domain www.myassignmentservices.com and all its subdomains to commit any academic misconduct. I have read and been made fully aware of the academic integrity policy of My Assignment Services and by clicking on the button below, I am in principle, wilfully and legally bound to adhere to guidelines of the academic integrity policy in whole and in part.
View Cookies policy | How we ensure Academic Integrity?