Advanced Cost and Management AccountingTU Board 2081
The Income Statement of Sony Manufacturing Company and other necessary details have been summarized below: Particulars Product X Product Y Total (Rs) : : : : Sales units 10,000 10,000 20,000 Sales…
10The Income Statement of Sony Manufacturing Company and other necessary details have been summarized below:
| Particulars | Product X | Product Y | Total (Rs) |
|---|---|---|---|
| Sales units | 10,000 | 10,000 | 20,000 |
| Sales revenue (Rs.) | 200,000 | 200,000 | 400,000 |
| Less: Variable cost | |||
| Direct material @Rs. 5 per kg | 100,000 | 50,000 | |
| Direct labour @Rs. 6 per DLH | 60,000 | 120,000 | |
| Total variable cost | 160,000 | 170,000 | 330,000 |
| Contribution margin | 40,000 | 30,000 | 70,000 |
| Less: Fixed cost | |||
| Product wise fixed cost | 20,000 | 10,000 | 30,000 |
| Joint fixed cost | 22,000 | ||
| Net income before tax | 18,000 |
Required: a. Weighted average contribution margin per unit. [2] b. Overall BEP in units and amount. [2] c. Linear programming model for profit maximization, under both raw materials and labours are in short supply and for the next year direct material will be available 5,000 kgs and labour hours of 4,000 hours only. [6]
Answer
a. Weighted Average Contribution Margin per Unit
The contribution margin per unit is calculated as:
Given:
- Total contribution margin = Rs. 70,000
- Total units sold = 20,000
b. Overall Break-Even Point (BEP) in Units and Amount
The break-even point (BEP) is where total revenue equals total costs (fixed + variable). It can be calculated using:
Given:
- Total fixed costs = Product-wise fixed cost (Rs. 30,000) + Joint fixed cost (Rs. 22,000) = Rs. 52,000
- Weighted average contribution margin per unit = Rs. 3.50
To find the BEP in rupees, multiply by the average selling price per unit:
c. Linear Programming Model for Profit Maximization
Given constraints:
- Raw material: 5,000 kg available (next year)
- Labour hours: 4,000 hours available (next year)
Decision Variables:
Let:
- = Number of units of Product X to produce
- = Number of units of Product Y to produce
Objective Function (Maximize Profit):
From the income statement:
- Contribution margin per unit of X = Rs. 40,000 / 10,000 = Rs. 4 per unit
- Contribution margin per unit of Y = Rs. 30,000 / 10,000 = Rs. 3 per unit
Constraints:
Raw Material Constraint:
- Product X uses 10 kg per unit (since Rs. 100,000 / 10,000 units = Rs. 10 per unit at Rs. 5/kg → 2 kg? Correction: Re-examining the data:
- For Product X: Total material cost = Rs. 100,000 for 10,000 units → Rs. 10 per unit
- Given material cost is Rs. 5 per kg, so:
- For Product Y: Total material cost = Rs. 50,000 for 10,000 units → Rs. 5 per unit
- Total material constraint:
- Product X uses 10 kg per unit (since Rs. 100,000 / 10,000 units = Rs. 10 per unit at Rs. 5/kg → 2 kg? Correction: Re-examining the data:
Labour Constraint:
- Product X uses 6 DLH per unit (since Rs. 60,000 / 10,000 units = Rs. 6 per unit at Rs. 6/DLH → 1 DLH per unit? Correction:
- For Product X: Total labour cost = Rs. 60,000 for 10,000 units → Rs. 6 per unit
- Given labour rate is Rs. 6 per DLH, so:
- For Product Y: Total labour cost = Rs. 120,000 for 10,000 units → Rs. 12 per unit
- Total labour constraint:
- Product X uses 6 DLH per unit (since Rs. 60,000 / 10,000 units = Rs. 6 per unit at Rs. 6/DLH → 1 DLH per unit? Correction:
Non-negativity Constraints:
Final Linear Programming Model:
Subject to:
Graphical Solution (Corner Points Method):
Find intersection points of constraints:
- Solve and : Multiply the second equation by 2: Subtract the first equation: Substitute back: Intersection point:
Evaluate objective function at corner points:
- :
- :
- :
- :
Optimal Solution:
- Produce 2,000 units of X and 1,000 units of Y for maximum profit of Rs. 11,000.
Verification of Constraints at Optimal Point:
- Material: kg (fully utilized)
- Labour: hours (fully utilized)
Discussion
Loading…