i) Produce a budget statement for Caltex for November ii) Produce a profit statement for Caltex for November b. Produce a flexed budget statement for Caltex for November c. Calculate: i) Sales price variance ii) Sales profit – volume variance iii) Materials price variance (both materials) iv) Labour rate variance v) Labour efficiency variance vi) Overhead variances (both)
Caltex Products plc manufactures electric mini-lawnmowers. Its sales and costs’
budget for November 20X2 is as follows:
Sales: 3 000 units × £72/unit
Costs:
Direct materials (metal): 3 000 units × (1kg per unit × £14/kg)
Direct materials (plastic) 3 000 units × (0.5kg per unit × £7/kg)
Direct labour: 3 000 units × (0.75 hours per unit × £8/hr)
Production overhead £86 500
Other
• The company does not absorb production overheads using an
overhead absorption rate.
• It may be assumed that all of its overheads are fixed in nature.
The company’s actual results for the same month (November) are as follows:
Sales: 2 950 units × £73/unit
Costs:
Direct materials (metal): 2 950 units × (0.9kg per unit × £13.80/kg)
Direct materials (plastic): 2 950 units × (£0.5kg per unit × £7.20/unit)
Direct labour: 2 950 units × (0.7 hrs per unit × £8.20/hr)
Production overhead: £84 250
Other overheads: £32 250
Net profit: £34 658
Page 6 of 11
[2307]
Arden University © reserves all rights of copyright and all other intellectual property rights in the learning materials and this publication. No part of any of the learning
materials or this publication may be reproduced, shared (including in private social media groups), stored in a retrieval system or transmitted in any form or means,
including without limitation electronic, mechanical, photocopying, recording or otherwise, without the prior written consent of Arden University. To find out more about
the use and distribution of programme materials please see the Arden Student Terms and Conditions.
Required:
a.
i) Produce a budget statement for Caltex for November
ii) Produce a profit statement for Caltex for November
b.
Produce a flexed budget statement for Caltex for November
c.
Calculate:
i) Sales price variance
ii) Sales profit – volume variance
iii) Materials price variance (both materials)
iv) Labour rate variance
v) Labour efficiency variance
vi) Overhead variances (both)
d.
Comment on your calculations produced in c above
Step by step
Solved in 4 steps