Question

Mario Co. makes plumbing supplies. One of the main products they sell is a drain cleaner called Fireball. When Mario Co. was preparing their budget for 2018, they had estimated these numbers in regard to Fireball Drain cleaner: Units Sold: 110,000 bottles Revenue: $742,500 Direct Material per bottle: 1.4 liters Total Cost of Direct Materials: $52,360 Total Direct Labor Manufacturing Hours: 11,000 hours Labor Wage Rate: $10 per hour Variable Manufacturing Costs (based off DLMH): $60,500 Fixed Manufacturing Costs : $10,800 On December 31st, Mario Co. had these numbers regarding the manufacture and sale of Fireball Drain Cleaner: Units Sold: 109,600 bottles Average Price per Unit: $6.80 Average Direct Material per bottle: 1.5 liters Average cost per liter of DM: .33 per liter Total Direct Labor Manufacturing Hours: 10,940 hours Total Direct Labor Manufacturing Costs: $112,135 Variable Manufacturing Costs (based off DLMH): $62,905 Fixed Manufacturing Costs : $11,272 Using this information, please do the following: a. Put together the static budget for 2018 b. Put together the flexible budget for 2018 c. Calculate the Flexible Budget Variance and the Sales Volume Variance for all items (Level 2 analysis) d. Calculate the Spending and Efficiency variance for Direct Materials and Direct Labor (Level 3 analysis)

Answer 1