Apollo Can Ltd manufactures recyclable soft drink cans. A unit of production is a box of 12 cans. The following standards have been set by the production engineering staff and the factory accountant:

Direct material _________________________________ Direct labour

Quantity: it kilograms ..................................... Quantity: 0.25 hour

Price: $0.60 per kilogram ................................. Rate: $22 per hour

Actual material purchases amounted to 240 000 kilograms at $0.62 per kilogram. Actual c incurred in the production of 50 000 units were as follows:

Direct material ............................................ $130 200 for 210 000 kilograms

Direct labour ...................................................... $299 000 for 13 000 hours

Required:

1. Construct an Excel® spreadsheet to calculate the direct material price and quantity variances and the direct labour rate and efficiency variances. Indicate whether each variance is favourable or unfavourable.

2. Use your spreadsheet to show how the solution will change if the following information changes: standard direct material price is $0.59 per kilogram and standard direct labour rate is $24.