In: Accounting
Activity Indirect Cost Allocation Base Allocation base by Ale Allocation base by nonAle Allocation base by total
Brewing $5000 Direct Labor 65hours 25 hours 90 hours
Bottling $11000 Machine hours 80hours 30 hours 110 hours
Inspecting $4000 Bottles 8000 bottles 2000 bottles 10000bottles
Other pertinent information: 1.Cost for ingredients and bottles for Ale is $0.35 per bottle 2.Cost for ingredients and bottles for NonAle is $0.25 per bottle. 3. The labor costs to make a bottle of beer is the same for each type of beer,$0.15.
Question: Determine the product cost for 1 bottle of Ale and 1 bottle of NonAle.
Activity | Indirect cost | Allocate base | Ale allocation | Non Ale Allocation | Total |
Brewing cost | 5000 | Labor hr | 65 | 25 | 90 |
Bottling cost | 11000 | Machine Hr | 80 | 30 | 110 |
Inspecting cost | 4000 | No of bottle | 8000 | 2000 | 10000 |
Labor cost to make one bottle of beer | 0.15 | 0.15 | |||
Cost of ingredient and bottle | 0.35 | 0.25 | |||
Product cost per bottle | Ale allocation | Non Ale Allocation | Total | ||
Brewing cost | 3611.111111 | 1388.888889 | 5000 | ||
5000/90*65 | 5000/90*25 | ||||
Bottling cost | 8000 | 3000 | 11000 | ||
11000/110*80 | 11000/110*30 | ||||
Inspecting cost | 3200 | 800 | 4000 | ||
4000/10000*8000 | 4000/10000*2000 | ||||
Total bottle | 8000 | 2000 | 10000 | ||
Total Brewing + Bottling+Inspecting cost | 14811.11111 | 5188.888889 | |||
Cost per bottle | 1.851388889 | 2.594444444 | |||
Labor cost to make one bottle of beer | 0.15 | 0.15 | |||
Cost of ingredient and bottle | 0.35 | 0.25 | |||
Product cost | 2.351388889 | 2.994444444 | |||
Round | 2.35 | 2.99 | |||
I hope this satisfies the answer. |
In case of doubt, please comment. Also, it would be great in case you give thumbs up. |