Answered step by step
Verified Expert Solution
Question
1 Approved Answer
Question 3: On page 4 of attachment Createa monthly profit report using ABC overhead allocation. Like one below. PERFORMANCE DRINKS - MONTHLY PROFIT REPORT Basic
Question 3: On page 4 of attachment Createa monthly profit report using ABC overhead allocation. Like one below.
PERFORMANCE DRINKS - MONTHLY PROFIT REPORT Basic REVENUE Sales COSTS Direct Materials Direct Labor Fringe Benefits on Direct Labor Manufacturing Overhead TOTAL COST GROSS MARGIN $ $ $ $ $ 125,000 $ 40,000 25,000 11,250.00 43,750.00 $ $ $ $ Intensity 120,000 $ 50,000 20,000 9,000.00 35,000.00 $ $ $ $ Post Workout 74,250 $ 31,000 10,000 4,500.00 17,500.00 $ $ $ $ $ 120,000.00 $ 114,000.00 $ 63,000.00 $ $ Total 93,000 $ 33,000 18,000 8,100.00 31,500.00 90,600.00 $ 387,600.00 $ $ 5,000.00 $ 6,000.00 $ 11,250.00 $ 2,400.00 $ 5.00% 15.15% 2.58% 100,000 1.25 $ 1.200 $ 80,000 1.50 $ 1.425 $ 45,000 1.65 $ 1.400 $ 412,250 $ 154,000 $ 73,000 $ 32,850.00 $ 127,750.00 4.00% GROSS MARGIN RATIO Annual Volume: Unit Price: Unit Cost: Hydration 60,000 1.55 $ 1.510 $ 24,650.00 5.98% 285,000 1.45 1.360 PERFORMANCE DRINKS - MONTHLY MFG OHD COST REPORT Indirect Labor Fringe Benefits on Indirect Labor Utilities Processing Equipment - Depreciation Preventative Maintenance $ $ $ $ $ Monthly Charge 55,000.00 24,750.00 5,000.00 10,000.00 10,000.00 Information Technology Total $ $ 23,000.00 127,750.00
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started