The following information is provided to assist you in evaluating the performance of the production Missing Data; Review of operations of Odysius, Inc.:

Chapters 16 and 17 otal/costs:

kG.) Direct material purchased ANd USE... cece $188,700 (102,000 pounds)

Diet (ADO iNe Tae DRIER, «ctr aera nescdem Gets 140,000 (10,700 hours)

Manufacturing OVEMNGAG .......cccccccssccnseceernesentecenee| 204,000 (61% is variable)

Standard costs per unit:

DIREC t MALEKA lle. cea ccavuSceaec eeses ,areensal $ 1.65 < 5 pounds per unit of output eXcel MOC HD Onna nmeattta, taker | mena et ae bogies 14.00 per hour x 1/2 hour per unit mhhe.convhilton4e Variable overhead ...........c00 Poe ee 11.90 per direct-labor hour Production budget:

IDSr SiS UMR ENSIf el ies acaanesecnes tonne caicoorao ar eennscrminbooncebane $165,000 DifeCt la Domes Ptrsetar tceet asinioern eea ts 140,000 Manufacturing OVenneadwccscnsctssscs cmeeeat : 199,000 Variable overhead is applied on the basis of direct-labor hours. The company’s actual production was 21,000 units.

Required

a. Asa group, prepare a complete cost-variance report suitable for presentation to the class. Include the following in your report:

Direct-materials price and quantity variances.

Direct-labor rate and efficiency variances.

~ Variable-overhead spending and efficiency variances.

fs7 Fixed-overhead budget and volume variances.

b. BUILD YOUR OWN SPREADSHEET. Build an Excel spreadsheet to solve requirement (a).