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.
Enjoy 24/7 customer support for any queries or concerns you have.
Phone: +1 213 3772458
Email: support@gradeessays.com