Answer and Explanation:
The Preparation of report for the plant supervisor on direct labor cost variances for March is attached with the help of spreadsheet.
The Formula are as shown below:-
Actual per hour = Actual costs ÷ Actual number of hours
Standard per hour = Standard costs ÷Standard number of hours
Quantity variance = (Actual hours -Standard hours) × Standard Rate
Price variance = (Actual Rate - Standard Rate) × Actual Hour
Therefore if actual hours is lesser than Standard hours it will become favorable and if actual hours is higher than standard hours it will become unfavorable. In the similar way if actual rate is higher than standard rate then it will become unfavorable on the other hand if actual rate is lesser than standard rate then it will become favorable.