Please answer this question by creating a table, filling in ALL of the blanks for the schedule showing the computation of the activity-based overhead rates(per cost driver). Could you please mimic the layout of the schedule in the picture when answering so i can fill out the correct answer :)
Wildhorse Corporation produces two grades of non-alcoholic wine from grapes that it buys from California
e.high-cos han the CoolDay lin
Jack Eller,president and founder of Wildhorse,is skeptical about this idea He points out
the same quantity as CoolDay.CoolDay requires1month of agingLiteMistrequires 1 year.CoolDay requires cleaning and inspection of equip
Jack has asked the accounting department to prepare an analysis of the cost per liter
CoolDay LiteMist Direct materials per liter $0.40 $1.20 Direct laborcost perliter $0.50 $0.90 Direct labor hours per liter 0.07 0.12 Totaldirect labor hours 210,000 36,000
timated Useo
Estimated Use of Cost Drivers 6,600 6,600,000 900,000 900,000
Estimated Overhead $160,380 759,000 309,600 208,800 242,400 $1,680,180
Cost Drivers Cart of grapes Total months
Activity Cost Pools Grape processing Aging Bottling and corking
LiteMist 6,000 600 3,000,000 3,600,000 600,000 300,000 600,000 300,000 350 450
Number of bottles
Labeling and boxing
Number of bottles
Maintain and inspect equipmen
Number of inspectiont
800
Answer each of the fo
b)
imol ploces,e.3.12.250
Activity Cost Pools
Estimated Overhead
Estimated Use of Cost Drivers
Activity-Based Overhead Rates
Grape processing
per cart
Aging
per month
Bottling and corking
per bottle
Labeling and boxing
per bottle
Maintain and inspect equipme
per inspection