Of course! Let's prepare the cost sheet step-by-step based on the given information and derived results.
### Given Data:
1. Raw Material Consumed: ₹20,000
2. Direct Wages: ₹18,000
3. Machine Hours Worked: 1,000 hours
4. Machine Hour Rate: ₹2 per hour
5. Office Overhead: 20% of works cost
6. Selling Overhead: ₹0.40 per unit sold
7. Units Produced: 20,000 units
8. Units Sold: 18,000 units
### Calculations:
#### 1. Works Cost:
To calculate the works cost, we need to include the raw material consumed, direct wages, and machine cost.
- Raw Material Consumed: ₹20,000
- Direct Wages: ₹18,000
- Machine Cost: Machine Hours Worked * Machine Hour Rate
[tex]\( 1,000 \text{ hours} \times ₹2/\text{hour} = ₹2,000 \)[/tex]
Adding these up:
[tex]\[ \text{Works Cost} = \text{Raw Material Consumed} + \text{Direct Wages} + \text{Machine Cost} \][/tex]
[tex]\[ \text{Works Cost} = ₹20,000 + ₹18,000 + ₹2,000 = ₹40,000 \][/tex]
#### 2. Office Overhead:
The office overhead is calculated as 20% of the works cost.
[tex]\[ \text{Office Overhead} = 20\% \times ₹40,000 = 0.20 \times ₹40,000 = ₹8,000 \][/tex]
#### 3. Cost of Production:
The cost of production is the sum of the works cost and the office overhead.
[tex]\[ \text{Cost of Production} = \text{Works Cost} + \text{Office Overhead} \][/tex]
[tex]\[ \text{Cost of Production} = ₹40,000 + ₹8,000 = ₹48,000 \][/tex]
#### 4. Cost of Goods Sold:
For the cost of goods sold, we need to add the selling overhead to the cost of production. The selling overhead is calculated based on the units sold.
[tex]\[ \text{Total Selling Overhead} = \text{Selling Overhead per Unit} \times \text{Units Sold} \][/tex]
[tex]\[ \text{Total Selling Overhead} = ₹0.40 \times 18,000 = ₹7,200 \][/tex]
Adding this to the cost of production:
[tex]\[ \text{Cost of Goods Sold} = \text{Cost of Production} + \text{Total Selling Overhead} \][/tex]
[tex]\[ \text{Cost of Goods Sold} = ₹48,000 + ₹7,200 = ₹55,200 \][/tex]
### Summary of Calculations:
- Raw Material Consumed: ₹20,000
- Direct Wages: ₹18,000
- Machine Cost: ₹2,000
- Works Cost: ₹40,000
- Office Overhead: ₹8,000
- Cost of Production: ₹48,000
- Total Selling Overhead: ₹7,200
- Cost of Goods Sold: ₹55,200
### Cost Sheet:
| Particulars | Amount (₹) |
|-----------------------------------|-------------|
| Raw Material Consumed | 20,000 |
| Direct Wages | 18,000 |
| Machine Cost | 2,000 |
| Works Cost | 40,000 |
| Office Overhead (20% of Works Cost) | 8,000 |
| Cost of Production | 48,000 |
| Selling Overhead (₹0.40 per unit, 18,000 units)| 7,200 |
| Cost of Goods Sold | 55,200 |
This is the detailed cost sheet for the given manufacturing information for the month of January 2024.
