Standard costing

Final 803 views 2 replies

Can someone give me solution for this question

 

GLOBAL LTD. is engaged in marketing of wide range of consumer goods. A, B, C and D are the zonal sales officers for four zones. The company fixes annual sales target for them individually. You are furnished with the following:
(1) The standard costs of sales target in respect of A, B, C and D are 5,00,000, 3,75,000, 4,00,000 and 4,25,000 respectively.
(2) A, B, C and D respectively earned ` 29,900, ` 23,500, ` 24,500 and ` 25,800 as commission at 5% on actual sales effected by them during the previous year.
(3) The relevant variances as computed by a qualified cost accountant are as follows:
                                                                A              B                  C                   D
Sales price variance                     4,000 (F)    6,000 (A)     5,000 (A)     2,000 (A)
Sales volume variance                 6,000 (A)  26,000 (F)   15,000 (F)    8,000 (F)
Sales margin mix variance        14,000 (A)    8,000 (F)    17,000 (F)    3,000 (A)
(A) = Adverse variance and (F) = Fabourable variance.
 
You are required to:
(1) Compute the amount of sales target fixed and the actual amount of contribution earned in case of each of the zonal sales officer.
(2) Evaluate the overall performance of these zonal sales officers taking three relevant base factors and then recommend whose performance is the best.
Replies (2)

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

 

Please see attached Excel sheet for your referance.

 

Please correct if i am wrong..............


CCI Pro

Leave a Reply

Your are not logged in . Please login to post replies

Click here to Login / Register