Assignment on a business game project
12/18/2020 Please close this window/tab when you have finished printing
https://executive.trainingsimulations.co.uk/Whatif/index.php?Action=report&CurrentReportID=16&RoundNo=2&Print.x=6&Print.y=11 1/4
Round 2Exercise: ld0474sem1clss7a7b20 Executive Business Simulation Copyright (c) April Training Executive 2020
Production Report - Team 4 : Deccan Motors corporation
Market Sector Model Name Produced Sold In Stock Model Price £ Market Share %
9 Mini S2 60000 58228 1772 18000.00 1.12 7 Mega Z5 40000 40000 0 40000.00 1.57 8 Bolt S1 5500 5500 0 92999.00 0.95
Market Sector Model Name Workforce
Materials Cost £
Design and Options Cost
£
Labour Cost £
Gross Margin % Productivity
9 Mini S2 2000 9499.15 2914.14 1000.00 25.48 30.00 7 Mega Z5 1500 17336.61 9859.46 1125.00 29.20 26.67 8 Bolt S1 500 38644.28 16409.35 2727.27 37.87 11.00
Market Sector Model Name Target
Production
Potential Productivity
Cars/Worker/Year
Potential Productivity with
Overtime
Warranty Cost per Car £
9 Mini S2 60000 46.83 56.20 304.64 7 Mega Z5 40000 43.46 52.15 650.06 8 Bolt S1 5500 11.63 13.95 1673.61
Workforce 4000 Strike Days 2 Productivity (cars/worker/year) 26.38 Productivity Index 0.74
Total Market (m) Small Medium Large Luxury Size 5.18 4.86 2.54 0.58
12/18/2020 Please close this window/tab when you have finished printing
https://executive.trainingsimulations.co.uk/Whatif/index.php?Action=report&CurrentReportID=16&RoundNo=2&Print.x=6&Print.y=11 2/4
Round 2Exercise: ld0474sem1clss7a7b20 Executive Business Simulation Copyright (c) April Training Executive 2020
Overheads
Team 4 : Deccan Motors corporation
Sales 3159.60 Cost of Sales* 2231.67 Gross Profit (Loss) 927.93
Fixed Overheads 209.23 Stock Upkeep Cost Product Recall Cost Promotion 58.00 Research and Development 171.03 Professional Charges 20.58 Warranty Claims 52.95 Training Cost 5.00
Profit and Loss Account - £m
Extraordinary Events
*Cost of Sales Breakdown Opening Stock 0.00 plus Materials Costs 2135.44 plus Wages 120.00 minus Closing Stock 23.77 Cost of Sales 2231.67
Pre Tax Profit (Loss) 339.05 Tax 74.59 Post Tax Profit (Loss) 264.46
Cost of Redundancies Factory Sale Loss
Interest on Current Account 10.29 Interest on Loans
Operating Profit (Loss) 328.76
Depreciation 82.39
12/18/2020 Please close this window/tab when you have finished printing
https://executive.trainingsimulations.co.uk/Whatif/index.php?Action=report&CurrentReportID=16&RoundNo=2&Print.x=6&Print.y=11 3/4
Round 2Exercise: ld0474sem1clss7a7b20 Executive Business Simulation Copyright (c) April Training Executive 2020
Total Capital Employed 943.91
Loan
Share Equity 500.00 Retained Profit (Loss) 443.91 Total Subsidies Total Shareholders Funds 943.91
Total Assets Less Current Liabilities 943.91
Net Current Assets (or Liabilities) 202.40
Tax 74.59 Creditors 526.55
Overdraft
Stock Value 23.77 Debtors 259.69 Bank Balance 520.08
Cost 901.00 Depreciation -159.49 Book Value 741.51
Long Term Liabilities
Capital and Reserves
Current Liabilities
Current Assets
Fixed Assets
Balance Sheet £m - Team 4 : Deccan Motors corporation
12/18/2020 Please close this window/tab when you have finished printing
https://executive.trainingsimulations.co.uk/Whatif/index.php?Action=report&CurrentReportID=16&RoundNo=2&Print.x=6&Print.y=11 4/4
Round 2Exercise: ld0474sem1clss7a7b20 Executive Business Simulation Copyright (c) April Training Executive 2020
Opening Bank Balance 263.66 Revenue 3120.18 Corporate Subsidy Government Subsidy Insurance Claim Factory Sale Income Bank Interest 10.29
Cash Flow £m - Team 4 : Deccan Motors corporation
Extraordinary Events
Material Costs 2056.66 Wage Costs 120.00 Total Overheads 516.78 Factory Cost Redundancy Costs Automation Expenditure 30.00 Loan Repayments Tax Payments 50.61 Bank Interest New Model Production Costs 100.00
Balance Before Loan 520.08 New Loan Closing Bank Balance 520.08