Question

1 Approved Answer

Posted on Aug 11, 2024

Calculate the turnover of gold rings sold in the South African market annually. Demonstrate your approach to getting to an answer Calculate the turnover of

Calculate the turnover of gold rings sold in the South African market annually. Demonstrate your approach to getting to an answer

Calculate the turnover of gold rings sold in the South African market annually. Demonstrate your approach to getting to an answer Explanation and Assumptions for market size... Use this and the next slide to demonstrate your analysis: PS: Round off numbers eg: 105.4243 100 The answer is less important than the structure and framework to get to the answer Your Approach Structure Your Assumptions Your answer: R?27777 Per annum AutoSave Or File Home Insert Page Layout Formulas Mining Value Driver Model - RBI Case Study 2018 - Compatibility Mode Excel Review View Help Tell me what you want to do Share Comments AutoSum A Fill Cut Copy For matting 1 Fomb atas Styles. Insert Delete Fonmat Sort& Find& ,,! . E- I 2.. -EMerge & Center B-%, . Format Painter Ock at . Formatting Table Styles Styles Filter Select Clipboard Alignment Number Cells Editing G16 Key Financials Tons Milled Gold Mining Corporation Income Statement Kilograms Pioduced 500 Update Numbers R000 R000 F000 R000 Rit 50000 30000 30000 20000 Provides a financial summary on the performance of the mine Allows the user to test different scenarios by entering figures in the % improvement column Cost by Element Cost by Process Profit Element Cost Riton Process Cost iton 30000 20000 300 Base Case % Improvement Scenario Case Revenue Drivers Revenue R000 ons Mled Kiograms Produced Recovory Grada 500,0 60 000 50 000 40 000 30 000 20 000 10 000 0.0% Cost by Element R'O00 2 000 Fixed Vriable 11880.0 120,0 9000,0 21 9 000,0 90,0 Cost by Element R'000 Cost by Process R000 c & Wate 500,0 35,0 3500,0 0.0% 27 Variable 40 000 30 000 400020 000 10 000 40 000 30 000 a 20 000 10 000 R 30 000 R 30 000 600,0 600,0 30 Variable 2 000,0 2000.0 2000,0 2000.0 Fixed Vriable 290,0 Income Statement Scenario Resulting Cost R per ton Dump Truck Times Dump Truck Utilisatio Ready Calculate +90% 19:36 rP ^ENG 2019/08/10 Mining Value Driver Model - RBI Case Study 2018 - Compatibility Mode Excel File Home Insert Page Layout Formulas Data Review View Help Tell me what you want to do Share Comments Wrap Tet General condtional Formatas (Cell. Formatting Table Styles Sort & Find& Filter Select Insert Delete Format Format Painter BTUA ES @l. %, Merge & Center or. . Clipboard Font Number Unit Base Scenario % Change Gold Mining Corporation Cost R/ton Analysis Sort Numbers Kilograms Produced R000 5000050000 R0001 30000 | 30000 R000 30000 30000 R000 2000020000 Update Numbers This sheet displays the output from the previous scenario sheet Please olick on Sort Numbers for graphs to be updated Cost by Element Profit Element Cost Riton Process Cost Rlton Base Case Scenario % Change % Tota Cummu Cost by Element 30 000 R 300,0 0% 100% 100% Coat by Elamant R'000 9000,0 3500,0 Eloc & Water IT. R9 000 R 10 2000,0 290,0 2 000 Surface Infra-struct NRM Stoping 2800,0 2 700,0 R27,0 %Charge --Base Case Trackless Dev Cost by Prooss 00o Oro Resorves LG Eng Trackless Stoping 3%| 82% R 0 000R5500 5 000 Income Statement Scenario Resulting Cost R per ton Dump Truck TimesDump Truck Utilisatio Ready Calculate rP ^40) ENG 2019/03/10 10 80 70 50 40 30 20 10 0% 00 g's ost ost | 000 000 000 000 000 000 000 RO 0% 0% 0% 0% 0% 0% 0% 0% 0% 0% 0% 0% 0% 0% 0% 0% 0% 0% 2 50 29 27 25 20 12 00, 500 000 000 220| 000 500 000 00 700 500 000 200 000 350 900 0,0 0,0 0,0 0,0 0,0 0,0 0,0 0,0 0,0 0,0 0,0 50 00 70 50 00 20 00 35 90 9-10-18 19 20 21 22 23 24 25 26 28 29 30 31 32 333333 39 40- 07 Calculate the turnover of gold rings sold in the South African market annually. Demonstrate your approach to getting to an answer Explanation and Assumptions for market size... Use this and the next slide to demonstrate your analysis: PS: Round off numbers eg: 105.4243 100 The answer is less important than the structure and framework to get to the answer Your Approach Structure Your Assumptions Your answer: R?27777 Per annum AutoSave Or File Home Insert Page Layout Formulas Mining Value Driver Model - RBI Case Study 2018 - Compatibility Mode Excel Review View Help Tell me what you want to do Share Comments AutoSum A Fill Cut Copy For matting 1 Fomb atas Styles. Insert Delete Fonmat Sort& Find& ,,! . E- I 2.. -EMerge & Center B-%, . Format Painter Ock at . Formatting Table Styles Styles Filter Select Clipboard Alignment Number Cells Editing G16 Key Financials Tons Milled Gold Mining Corporation Income Statement Kilograms Pioduced 500 Update Numbers R000 R000 F000 R000 Rit 50000 30000 30000 20000 Provides a financial summary on the performance of the mine Allows the user to test different scenarios by entering figures in the % improvement column Cost by Element Cost by Process Profit Element Cost Riton Process Cost iton 30000 20000 300 Base Case % Improvement Scenario Case Revenue Drivers Revenue R000 ons Mled Kiograms Produced Recovory Grada 500,0 60 000 50 000 40 000 30 000 20 000 10 000 0.0% Cost by Element R'O00 2 000 Fixed Vriable 11880.0 120,0 9000,0 21 9 000,0 90,0 Cost by Element R'000 Cost by Process R000 c & Wate 500,0 35,0 3500,0 0.0% 27 Variable 40 000 30 000 400020 000 10 000 40 000 30 000 a 20 000 10 000 R 30 000 R 30 000 600,0 600,0 30 Variable 2 000,0 2000.0 2000,0 2000.0 Fixed Vriable 290,0 Income Statement Scenario Resulting Cost R per ton Dump Truck Times Dump Truck Utilisatio Ready Calculate +90% 19:36 rP ^ENG 2019/08/10 Mining Value Driver Model - RBI Case Study 2018 - Compatibility Mode Excel File Home Insert Page Layout Formulas Data Review View Help Tell me what you want to do Share Comments Wrap Tet General condtional Formatas (Cell. Formatting Table Styles Sort & Find& Filter Select Insert Delete Format Format Painter BTUA ES @l. %, Merge & Center or. . Clipboard Font Number Unit Base Scenario % Change Gold Mining Corporation Cost R/ton Analysis Sort Numbers Kilograms Produced R000 5000050000 R0001 30000 | 30000 R000 30000 30000 R000 2000020000 Update Numbers This sheet displays the output from the previous scenario sheet Please olick on Sort Numbers for graphs to be updated Cost by Element Profit Element Cost Riton Process Cost Rlton Base Case Scenario % Change % Tota Cummu Cost by Element 30 000 R 300,0 0% 100% 100% Coat by Elamant R'000 9000,0 3500,0 Eloc & Water IT. R9 000 R 10 2000,0 290,0 2 000 Surface Infra-struct NRM Stoping 2800,0 2 700,0 R27,0 %Charge --Base Case Trackless Dev Cost by Prooss 00o Oro Resorves LG Eng Trackless Stoping 3%| 82% R 0 000R5500 5 000 Income Statement Scenario Resulting Cost R per ton Dump Truck TimesDump Truck Utilisatio Ready Calculate rP ^40) ENG 2019/03/10 10 80 70 50 40 30 20 10 0% 00 g's ost ost | 000 000 000 000 000 000 000 RO 0% 0% 0% 0% 0% 0% 0% 0% 0% 0% 0% 0% 0% 0% 0% 0% 0% 0% 2 50 29 27 25 20 12 00, 500 000 000 220| 000 500 000 00 700 500 000 200 000 350 900 0,0 0,0 0,0 0,0 0,0 0,0 0,0 0,0 0,0 0,0 0,0 50 00 70 50 00 20 00 35 90 9-10-18 19 20 21 22 23 24 25 26 28 29 30 31 32 333333 39 40- 07