AIN3701 Assignment 3 2026 | Due 15 June 2026 - Distinction Guaranteed

AIN3701 ASSIGNMENT 3 2026

DUE 15 JUNE 2026



QUESTION 1: SECTION A

Scenario Micro-Simba Ltd (SMC) manufactures microchips. SMC uses three
depreciation methods to depreciate its fixed assets. Production machines are
depreciated based on the number of microchips produced. It is estimated that each
production machine can produce 1 000 000 microchips over its useful life. Delivery
vehicles are depreciated over 4 years using the straight-line method. All other assets
are depreciated at 20% per year using the diminishing balance method.




VBA Code Completion:

1.1 Const

1.2 Const

1.3 Const

1.4 String

1.5 Double (or Currency for monetary values)

1.6 Double (or Currency)

, 1.7 Double (or Long for whole number of microchips)

1.8 Double (or Currency)

1.9 Double (or Currency)

1.10 LastRow




1.11 2 (assuming row 1 contains headers)

1.12 LastRow

1.13 MachineType =

1.14 OriginalCost =

1.15 OpeningAccDep =

1.16 MicrochipsManuf =

1.17 OriginalCost

1.18 MaxChipsProduced

1.19 MicrochipsManuf

1.20 OriginalCost

1.21 DeliveryVehicleDeprYrs

1.22 (OriginalCost

1.23 OpeningAccDep)

1.24 OtherAssetsRate

Note: Line 1.25 is the closing bracket for the formula - no code needed

1.26 ClosingAccDep = OpeningAccDep + DepreciationCurrentYear