Cost Accounting Report Calculations EY-1.xlsx - Calculation of Cost Allocated to different Activities Milking General Administrative Bottling Processing

Cost Accounting Report Calculations EY-1.xlsx - Calculation...

This preview shows page 1 - 4 out of 10 pages.

Calculation of Cost Allocated to different Activities Milking General & Administrative Bottling Processing Costs $ 140,499.30 Facilities Cost $ 35,128.33 Total Cost $ 175,627.63 Calculation of Cost per Activity Cost Milking $ 175,627.63 Separating $ 77,275.32 Mixing $ 73,762.48 Bottling $ 1,498,110.00 Warehousing $ 90,743.52 Cleaning & Repairs $ 26,929.38 General & Admin $ 136,018.67 Receiving & Inspecting $ 152,862.00 Calculation of OH Cost Whole Milk Milking $ 26,448.31 Separating $ 6,122.91 Mixing $ - Bottling $ 227,923.46 Warehousing $ 15,292.82 Cleaning & Repairs $ 3,311.27 General & Admin $ 10,072.88 Receiving & Inspecting $ - Total OH Cost $ 289,171.65 Bottles produced 292,000 OH per Bottle $ 0.99 Calculation of Cost per Unit (Glass) Whole Milk Cocoa Sugar Spices Packaging (Cost of Glass Bottles) $ 0.75 OH Cost per Bottle $ 0.99 Total Cost per Unit $ 1.74
Image of page 1
Calculation of Cost per Unit (Plastic) Whole Milk Cocoa Sugar Spices Packaging (Cost of Glass Bottles) $ 0.25 OH Cost per Bottle $ 0.99 Total Cost per Unit $ 1.24 Calculation of Cost per Unit (Plastic + Machine Cost) Whole Milk Cocoa Sugar Spices Packaging (Cost of Glass Bottles) $ 0.25 OH Cost per Bottle $ 0.61 Total Cost per Unit $ 0.86
Image of page 2
Separating Mixing Bottling Warehousing $ 1,375,758.00 $ 70,249.65 $ 70,249.65 $ 117,082.75 $ 46,833.10 $ 7,025.67 $ 3,512.83 $ 5,269.25 $ 43,910.42 $ 77,275.32 $ 73,762.48 $ 1,498,110.00 $ 90,743.52
Image of page 3
Image of page 4

You've reached the end of your free preview.

Want to read all 10 pages?

  • Left Quote Icon

    Student Picture

  • Left Quote Icon

    Student Picture

  • Left Quote Icon

    Student Picture

Stuck? We have tutors online 24/7 who can help you get unstuck.
A+ icon
Ask Expert Tutors You can ask You can ask You can ask (will expire )
Answers in as fast as 15 minutes