Question: Please work in Excel with formulas showing. XO-20 is an oil-based product used to remove rust on bolts and nuts that are stuck. Its accounting
Please work in Excel with formulas showing.


XO-20 is an oil-based product used to remove rust on bolts and nuts that are stuck. Its accounting system uses standard costs. The standards per 0.50-liter can of solution call for 0.80 liters of material and four hours of labor. (0.80 liters of material are needed due to evaporation in the production process.) The standard cost per liter of material is $2.70. The standard cost per hour for labor is $12. Overhead is applied at the rate of $14.18 per can. Expected production is 7,300 cans with fixed overhead per year of $22,484 and variable overhead of $11.10 per unit (a 0.50-liter can). During 2021, 7,500 cans were produced; 12,300 liters of material were purchased at a cost of $58,425; 10,800 liters of material were used in production. The cost of direct labor incurred in 2021 was $336,000, based on an average actual wage rate of $10 per hour. Actual overhead for 2021 was $112,800. (a) Determine the standard cost per unit. (Round answer to 2 decimal places, eg. 15.25.) Standard cost $ per unit eTextbook and Media Save for Later Attempts: 0 of 3 used Submit Answer (b) Calculate material, labor, and overhead variances. (Round intermediate calculations to 2 decimal places, e.g. 14.37 and final answers to O decimal places, e.g. 125. Enter all variances as a positive number.) Material Price Variance $ Material Quantity Variance $
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
