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=3&Print.x=12&Print.y=4 1/4

Round 3Exercise: 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 58650 60422 0 18000.00 1.05 7 Mega Z5 40000 40000 0 40000.00 1.45 8 Bolt S1 10000 9492 508 92999.00 1.40 5 Cruise X 40000 40000 0 15000.00 0.70

Market Sector Model Name Workforce

Materials Cost £

Design and Options Cost

£

Labour Cost £

Gross Margin % Productivity

9 Mini S2 1500 9727.54 3018.28 831.20 24.57 39.10 7 Mega Z5 1250 17753.43 10340.80 1015.63 27.23 32.00 8 Bolt S1 750 39573.40 17761.98 2437.50 35.73 13.33 5 Cruise X 1000 9727.54 3847.45 812.50 4.08 40.00

Market Sector Model Name TargetProduction

Potential Productivity

Cars/Worker/Year

Potential Productivity with

Overtime

Warranty Cost per Car £

9 Mini S2 58650 62.07 74.49 199.38 7 Mega Z5 40000 56.50 67.80 424.67 8 Bolt S1 10000 14.17 17.01 1223.42 5 Cruise X 40000 62.07 74.49 416.89

Workforce 4500 Strike Days 2 Productivity (cars/worker/year) 33.03 Productivity Index 0.96

Total Market (m) Small Medium Large Luxury Size 5.75 5.23 2.76 0.68

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=3&Print.x=12&Print.y=4 2/4

Round 3Exercise: ld0474sem1clss7a7b20 Executive Business Simulation Copyright (c) April Training Executive 2020

Overheads

Team 4 : Deccan Motors corporation

Sales 4170.34 Cost of Sales* 3127.32 Gross Profit (Loss) 1043.02

Fixed Overheads 306.38 Stock Upkeep Cost 3.57 Product Recall Cost Promotion 85.00 Research and Development 51.97 Professional Charges 20.95 Warranty Claims 57.32 Training Cost 25.00

Profit and Loss Account - £m

Extraordinary Events

*Cost of Sales Breakdown Opening Stock 23.77 plus Materials Costs 2987.67 plus Wages 146.25 minus Closing Stock 30.36 Cost of Sales 3127.32

Pre Tax Profit (Loss) 358.13 Tax 78.79 Post Tax Profit (Loss) 279.34

Cost of Redundancies Factory Sale Loss

Interest on Current Account 15.70 Interest on Loans

Operating Profit (Loss) 342.43

Depreciation 150.40

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=3&Print.x=12&Print.y=4 3/4

Round 3Exercise: ld0474sem1clss7a7b20 Executive Business Simulation Copyright (c) April Training Executive 2020

Total Capital Employed 1,223.25

Loan

Share Equity 500.00 Retained Profit (Loss) 723.25 Total Subsidies Total Shareholders Funds 1,223.25

Total Assets Less Current Liabilities 1,223.25

Net Current Assets (or Liabilities) -130.34

Tax 78.79 Creditors 736.68

Overdraft

Stock Value 30.36 Debtors 342.77 Bank Balance 312.01

Cost 1,663.48 Depreciation -309.89 Book Value 1,353.59

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=3&Print.x=12&Print.y=4 4/4

Round 3Exercise: ld0474sem1clss7a7b20 Executive Business Simulation Copyright (c) April Training Executive 2020

Opening Bank Balance 520.08 Revenue 4087.27 Corporate Subsidy Government Subsidy Insurance Claim Factory Sale Income Bank Interest 15.70

Cash Flow £m - Team 4 : Deccan Motors corporation

Extraordinary Events

Material Costs 2777.53 Wage Costs 146.25 Total Overheads 550.19 Factory Cost 712.48 Redundancy Costs Automation Expenditure 50.00 Loan Repayments Tax Payments 74.59 Bank Interest New Model Production Costs

Balance Before Loan 312.01 New Loan Closing Bank Balance 312.01