Absolutely! Let's create a detailed step-by-step cost sheet based on the information provided.
### Step-by-Step Cost Sheet
1. Opening Stock:
- Raw Materials: Rs. 40,000
- Semi-finished Goods: Rs. 60,000
- Finished Goods: Rs. 80,000
2. Costs:
- Production Cost (PC): Rs. 385,000
- Fixed Cost (FC): Rs. 505,000
- Cost of Production (COP): Rs. 555,000
- Cost of Goods Sold (COGS): Rs. 610,500
- Total Cost (TC): Rs. 631,500
3. Administrative and Selling Costs:
- Rent: Rs. (Not provided, assume it is included in FC)
- Indirect wages: Rs. (Not provided, assume it is part of PC and FC)
- Carriage inwards: Rs. (Not provided, assume it is part of PC)
- Direct wages: Rs. (Not explicitly provided, assume part of PC)
- Factory insurance: Rs. (Not provided, assume included in FC)
- Stationery: Rs. 14,000
- Advertisement: Rs. (Not provided, assume part of FC or separate as relevant)
- Salary: Rs. (Not provided, assume it is part of FC)
- Profit: 2%
4. Sales Commission:
- Note: 20% on sales is mentioned, but the sales amount is not provided. We can ignore it for this context or consider it later if sales are provided.
### Cost Sheet
| Particulars | Amount (Rs.) |
|------------------------------------------|-----------------|
| Opening Stock | |
| Raw Materials | 40,000 |
| Semi-finished Goods | 60,000 |
| Finished Goods | 80,000 |
| Total Opening Stock | 180,000 |
| Add: Production Cost (PC) | 385,000 |
| Add: Fixed Cost (FC) | 505,000 |
| Cost of Production (COP) | 555,000 |
| Cost of Goods Sold (COGS) | 610,500 |
| Total Cost (TC) | 631,500 |
| Add: Administrative and Selling Costs| |
| Stationery | 14,000 |
| Profit Percentage | |
| Profit Calculation (2% of sales) | Not explicitly calculated, profit seen in proportion to costs and sales. |
| Grand Total | - (Here, sum of TC + other administrative costs) |
This cost sheet segment includes details up to the costs and not the final portion due to lack of explicit sales mentioned. If you have the sales value, you can identify specific values like for sales commission and profit as exact amounts against these figures.
### Simplified Summary:
- Finished goods: 500 units
- Production Cost (PC): Rs. 3,85,000
- Fixed Cost (FC): Rs. 5,05,000
- Cost of Production (COP): Rs. 5,55,000
- Cost of Goods Sold (COGS): Rs. 6,10,500
- Total Cost (TC): Rs. 6,31,500
- Profit (2%): Inclusive, check specific sales details for absolute values.
I hope this detailed breakdown clarifies the cost sheet for you! If there are sales or additional data, it would refine the final amounts especially for administrative costs and profit.
