←Back to Subject
Notes
Notes
Study material and explanations
Diagrams
Diagrams
Visualize concepts easily
Mnemonics
Mnemonics
Tricks to remember faster
One Night Prep
One Night Prep
Short and focused revision
Revision
Revision
Quick summary and key points
Important Questions
Important Questions
Practice most relevant questions
Notes

Mathematical Simulation, Excel & Software Training Activity | B.Com Notes

Study material and explanations for Unit 1

Mathematical Simulation, Excel & Software Training Activity

1. Modern Software Tools in Commercial Mathematics

In enterprise resource planning (ERP) and supply chain management, systems often contain hundreds of simultaneous equations. Software tools automate their solutions:

Primary Software Platforms for Commercial Mathematical Simulation
1. Microsoft Excel
Ubiquitous corporate spreadsheet tool. Features matrix inversion (MINVERSE), matrix multiplication (MMULT), and Solver Add-in for linear programming.
2. MATLAB / Octave
High-performance numerical computing environment designed specifically for matrix operations. Employs the backslash operator (A\B) for Gaussian elimination.
3. Python (NumPy / SciPy)
Industry-standard open-source data science ecosystem. Functions like numpy.linalg.solve(A, B) evaluate multi-variable commercial models in milliseconds.

2. Step-by-Step Lab Activity: Solving Simultaneous Equations in Excel

The Business System:

  • 3x + 2y = 3,500
  • 2x + 4y = 5,000

Matrix Formulation:

In matrix algebra: A × X = B, where:

  • Coefficient Matrix A = [[3, 2], [2, 4]]
  • Unknown Vector X = [[x], [y]]
  • Constant Vector B = [[3500], [5000]]
  • Solution: X = A⁻¹ × B

Excel Execution Steps:

  1. Enter Matrix A: In cells A1:B2, enter 3, 2 in row 1 and 2, 4 in row 2.
  2. Enter Vector B: In cells D1:D2, enter 3500 and 5000.
  3. Compute Matrix Inverse (A⁻¹):
    • Select cells A4:B5.
    • Enter formula: =MINVERSE(A1:B2)
    • Press Ctrl + Shift + Enter (or Enter in modern Excel).
  4. Multiply Inverse by Vector B to find X:
    • Select cells D4:D5.
    • Enter formula: =MMULT(A4:B5, D1:D2)
    • Press Ctrl + Shift + Enter.
  5. Output Results:
    • Cell D4 displays 500 (Price of shirt = ₹500).
    • Cell D5 displays 1000 (Price of trousers = ₹1,000).

3. Practical Activity Submission Format

Students must perform the simulation in their college computer laboratory and submit a printout with:

  1. Mathematical problem statement and formulated equations.
  2. Screenshot of the Excel spreadsheet showing formula bar and matrix solution.
  3. Verification check proving that the software results satisfy both equations.