asap please with cell referencing
make sure you do not forget to label the variance you or F you need to show your work either by cell referencing or showing your calculations to the side
1- calculate the direct materials Price and quantity variance. Please note that the material price variance is based on actual material purchased, and the quantity variance is based on materials used.
Material price variance:
Material quantity variance:
2- Calculate the direct labor rate, and Efficiency variance.
Labor rate variance:
Label, efficiency variance:
3- Calculate the variable overhead spending and efficiency variance.
Variable overhead spending variance:
Variable overhead, efficiency variance:
4- Calculate the fixed overhead budget variance.
Fixed overhead budget variance:
5- Pick out the two variances that you computed above that you think should be further investigated. Explain why you picked these two variances and what might be the possible cause of the variances. You need to provide specific detail other than the variance was "U" or "F" Or a large dollar amount
This part relates to Module 23. I have variance analysis support material in the Module 23 folder in course resources: Gourmet, Inc produces containers of frozen food. During October the companv had the following antual nrorlirtinn and anete. Overtiead is budgeted and applied using direct-labor hours. Standard cost and annual budget information are as folows