Solution 7.5

 

 

a) The appropriate price to charge per holiday if the number of holidays sold and total profit remain the same for the forthcoming year.

In the approach to part (a) of this question one must firstly calculate last years profit figure. This should be presented by way of a marginal costing statement as parts (b), (c), and (d) will require information on fixed costs, variable costs and contribution. Once last years profit is calculated then calculate the forthcoming years fixed and variable costs and by using the CVP formula one can calculate the price to charge that will maintain last years profit. 

Calculation of last years profit

                                                            Profit Statement

          

 

     €

Holidays sold

    €

 

 

 

 

Sales

 

750

1200

900000

 

 

 

 

Less variable costs

 

 

 

 

 

 

 

 

Materials

125

 

 

 

 

 

 

 

Labour

200

1200

 

 

 

 

 

 

 

325

1200

390000

 

 

 

 

Contribution

 

       425

1200

510000

 

 

 

 

Less Fixed costs

 

 

300,000

 

 

 

 

 

 

 

 

210000

 

 

 

 

 

 

 

 

 

 

 

 

Fixed costs increase by 5%

 

 

 

315,000

 

 

Material costs increase by 12.5%

 

140.6

 

 

 

Labour costs increase by 9%

 

 

218.0

358.6

 

 

 

 

 

 

 

 

 

 

By using the CVP formula  p = P(x) - a + b(x) one can calculate a value for P 

 

P(1200)  -  (315,000 +  358.6 x 1200)  =  210,000

 

 

1200P   =

955320

 

 

 

 

 

P          =

796.1

 

 

 

 

The price per holiday that will achieve a profit of €210,000 is €796.10

 

b)      The number of holidays which must be sold if the existing selling price and total profit are maintained

The approach to answer this part of the question is to use the required profit formula

Fixed costs + required profit  

Contribution per unit

This will give the number of packages sold to achieve the required profit 

 

 

315,000  + 210,000 / (750 - 358.62)

 

 

 

 

 

315,000  + 210,000 / 391.38

 

 

 

 

 

 

1341  Holidays

 

 

 

 

 

c)      The number of holidays which must be sold to break-even if the price arrived at in a) is used

The approach to answer this part of the question is to use the break-even formula and divide fixed costs by the contribution per unit.

This will give the number of packages sold to break-even

 

 

315,000 / (796.12 - 358.62)

 

 

 

 

 

 

315,000 /  437.5

 

 

 

 

 

 

 

720  Holidays

 

 

 

 

 

d) The appropriate price to charge per holiday if a profit of €300,000 is required and if they succeed in selling 1,400 holidays

By using the CVP formula  p = P(x) - a + b(x) one can calculate a value for P

          

 

P(1400)  -  (315,000 +  358.62 x 1400)  =  300,000

 

 

 

 

1400P   =

1,117,068

 

 

 

 

 

 

 

P          =

798