Can someone give me solution for this question
Avinash (CA Final) (45 Points)
01 March 2012Can someone give me solution for this question
C.A. M.Com. Suhas A. Nagpure
(CA)
(1175 Points)
Replied 01 March 2012
Hi Avinash
Please see bellow
Sr No | Particulers | Referance | A | B | C | D |
1 | Std Cost | Given | 500,000 | 375,000 | 400,000 | 425,000 |
2 | Comi | Given | 29,900 | 23,500 | 24,500 | 25,800 |
3 | Actual Sales | 1 / 5% | 598,000 | 470,000 | 490,000 | 516,000 |
4 | Price Variance | Given | 4,000 | (6,000) | (5,000) | (2,000) |
5 | Volume Variance | Given | (6,000) | 26,000 | 15,000 | 8,000 |
6 | Margine Mix | Given | (14,000) | 8,000 | 17,000 | (3,000) |
7 | Total | (16,000) | 28,000 | 27,000 | 3,000 | |
8 | actual Cost ofSales | 1+2+7 | 513,900 | 426,500 | 451,500 | 453,800 |
9 | Actual Sales | As per 3 Above | 598,000 | 470,000 | 490,000 | 516,000 |
10 | Contribution | 9 - 8 | 84,100 | 43,500 | 38,500 | 62,200 |
11 | Contribution - Excluding Commision | 9 - 8 - 2 | 54,200 | 20,000 | 14,000 | 36,400 |
C.A. M.Com. Suhas A. Nagpure
(CA)
(1175 Points)
Replied 01 March 2012
Please see attached Excel sheet for your referance.
Please correct if i am wrong..............