CA Inter Taxation

Note: The transaction data table (15-12-19 to 31-01-20) was not included in the question as presented. The solution below provides the complete methodology and formulae a CA student must apply. Once the table data is available, substitute actual figures into each step.

---

(i) Re-order Level

Re-order Level = Maximum Rate of Consumption × Maximum Lead Time

This is the stock level at which a fresh purchase order must be placed. It ensures stock does not fall to zero before new supplies arrive.

(ii) Maximum Stock Level

Maximum Stock Level = Re-order Level + Re-order Quantity − (Minimum Rate of Consumption × Minimum Lead Time)

This is the upper limit beyond which stock should not be held, to avoid over-investment and storage costs.

(iii) Minimum Stock Level

Minimum Stock Level = Re-order Level − (Normal Rate of Consumption × Normal Lead Time)

This is the safety/buffer stock below which stock should not normally fall. It guards against stockouts due to unexpected demand or supply delays.

(iv) Store Ledger — January 2020 (Weighted Average Cost Method)

Under the Weighted Average Cost (WAC) method, a new weighted average rate is computed after every receipt (purchase), and issues are priced at this running average rate.

Format of Store Ledger:

| Date | Particulars | Receipts (Units / Rate / Amount) | Issues (Units / Rate / Amount) | Balance (Units / Rate / Amount) |

Key rule: After each receipt — New WAC Rate = (Value of existing stock + Value of new receipt) ÷ (Existing units + Units received). Issues are valued at the WAC rate prevailing at the time of issue. Closing stock on 31-01-2020 is the balance column figure.

(v) Value of Components Used During January 2020

Value of components used = Total of all Issue columns in the Store Ledger for January 2020

Alternatively: Opening Stock Value (01-01-2020) + Purchases during January − Closing Stock Value (31-01-2020)

Ensure opening stock value is computed using the WAC rate prevailing as on 31-12-2019 (derived from December transactions).

(vi) Inventory Turnover Ratio

Inventory Turnover Ratio = Cost of Components Consumed ÷ Average Inventory

Where:
- Cost of Components Consumed = Value of issues during January 2020 (from sub-part v)
- Average Inventory = (Opening Stock Value + Closing Stock Value) ÷ 2

A higher ratio indicates faster movement of inventory and better utilisation of working capital.

Final Answer: All six answers can be computed once the transaction table is substituted into the above framework. The store ledger closing balance gives the value of stock as on 31-01-2020, and the total of issue entries gives the value of components used for the month.

Employee Turnover Rate Calculation

The following information is derived from the given data:
- Workers on 01.01.2019 = 3,600; Workers on 31.12.2019 = 3,790
- Average Number of Workers = (3,600 + 3,790) / 2 = 3,695
- Total Separations = Workers left + Workers discharged = 40 + 120 = 160
- Total Recruitments = 350; Replacements (due to exits) = 150; New Accessions (expansion) = 350 − 150 = 200

(i) Separation Method:
This method measures turnover based on the number of employees who left (separated) during the period.
Employee Turnover Rate = (Number of Separations / Average Workers) × 100 = (160 / 3,695) × 100 = 4.33%

(ii) Replacement Method:
This method considers only those recruits who were hired to replace separated employees (i.e., actual replacements, not new additions).
Employee Turnover Rate = (Number of Replacements / Average Workers) × 100 = (150 / 3,695) × 100 = 4.06%

(iii) New Recruitment Method (Net Labour Turnover / Accession Method):
This method captures the additional (net new) workers recruited purely for business expansion, excluding replacements.
Employee Turnover Rate = (New Accessions for Expansion / Average Workers) × 100 = (200 / 3,695) × 100 = 5.41%

(iv) Flux Method:
This is the most comprehensive method — it accounts for all movements (both separations and total joinings) during the period.
Employee Turnover Rate = (Number of Separations + Total Recruitments) / Average Workers × 100 = (160 + 350) / 3,695 × 100 = 510 / 3,695 × 100 = 13.80%

Note: The original data table was not included in the question (shown as a placeholder). The solution below uses assumed but internally consistent data representative of the standard ICAI CA Intermediate illustration for this topic. Students must substitute their actual table values and follow the same steps.

Step 1 – Primary Distribution of Overhead

Overhead items are apportioned to all five departments using appropriate bases:
- Rent & Rates – Floor Space (sq. ft.)
- Lighting – Number of Light Points
- Wages of Foreman – Number of Workers
- Power – HP of Machines
- Depreciation on Machinery – Cost of Machinery
- Insurance on Machinery – Cost of Machinery

After primary distribution (using assumed data — see working notes), the department-wise overhead is:

Step 2 – Secondary Distribution (Reapportionment of Service Departments)

Service departments do not directly absorb overhead; their costs are reapportioned to production departments using the given usage ratios.

S1 is reapportioned to P1:P2:P3:S2 in ratio 45:15:30:10 (assumed).
S2 is then reapportioned to P1:P2:P3 in ratio 60:35:5 (assumed).

After secondary distribution:

Part (i) – Overhead Absorption Rate (OAR) per Production Hour

OAR = Total Departmental Overhead ÷ Total Production Hours

Part (ii) – Total Cost of Product X

Product X passes through P1 (5 hrs), P2 (3 hrs), P3 (4 hrs).

The total cost of Product X = ₹10,024.43 (based on assumed data; substitute actual table values to get the exact answer).