Stuck on this managerial accounting assignment. The yellow box at the end are the questions I need help getting answered the rest of the spreadsheet is the data given.
Income Statement {FAC} Variable Selling Expense[not Shipping] Variable Mfg. OH Variable Shipping Variable Selling Expense[not Shipping] Sales $75,000 Direct tracable to Product A or B Variable Shipping 12,000 10,00 traced Direct Materials $20,000 materials per unit below 640 traced Direct Labor $10,000 spread this based on Hours [computed with info below] 18.75 15.62 traced Variable Mfg. OH $12,000 spread this based on Hours [computed with info below] Through ABCFixed. Mfg. OH $13,000 use DL hrs for Fxd. Mfg. OH to product under FAC Total COGS $55,000 Gross Profit $20,000 Variable Selling Expense[not Shipping] $3,000 Sum % of sales traced Variable Shipping $4,000 7,000 9.33% traced Through ABC Fixed Selling & Admin & R&D $11,000 Total Operating Expense $18,000 Operating Income 2,000 Toital $ Direct Labor total QTY Variable Mfg. OH COGS & Expenses Direct Indirect Rate Hrs Direct Materials 20,000 Traced through Cost System to products QTY sold Direct Labor 10,000 Traced through Cost System to products Variable Mfg. OH 12,000 10,000 Fixed. Mfg. OH 13,000 12,000 Variable Selling Expense[not Shipping] 3,000 sum of both 13,000 Variable Shipping 4,000 7,000 35,000 Fixed Selling & Admin & R&D 11,000 Only two products so all of sales/Cogs ARE THESE TWO PRODUCTS Product A sell price each = $ 30.00 Sales $ DL Hrs. unit 0.20 Units sold 1,100 S 33,000.00 220.00Units sold 1,100 $ 33,000.00 220.00 Materials per unit = $ 5.00 Total hrs. # orders 70 Product B sell price each = $ 40.00 DL Hrs. unit 0.40 Total hrs. 10,000 Units sold 1,050 $ 42,000.00 420.00 640.00 Materials per unit = $ 13.81 $ 75,000.00 640.00 15.63 # orders 40 Total company Hrs. 12,000 Shipping & Variable selling is % of sales $5 9.33% of sales $ 640.00 7,000 18.75 Cost per DL Hr. = [compute] customers = 40 40 # projects = 100 100 Departments of Indirect overhead Fixed. Mfg. OH For Production Dept. ZZZ 6,000 For Production Dept. QQQ 7,000 13,000 Fixed Selling & Admin & R&D Selling 3400 Admin 4000 R&D 3600 11000 [per customer] Order ClassCo Maintain Activities Products Sustaining Projects Customer Processing DL Hrs General Total Departments V # of Orders # of # of Unallocated Projects Customers Production Dept. ZZZ 10% 60% 15% 10% 5% 100% For Production Dept. QQQ 20% 50% 10% 10% 10% 100% Selling 20% 20% 20% 25% 15% 100% Admin 10% 25% 20% 10% 35% 100% R&D 15% 25% 35% 10% 15% 100%Departments of Indirect overhead Fixed. Mfg. OH For Production Dept. ZZZ 6,000 For Production Dept. QQQ 7,000 13,000 Fixed Selling & Admin & R&D Selling 3400 Admin 4000 R&D 3600 11000 [per customer] Order ClassCo Maintain Activities Products Projects Sustaining Customer Processing Departments V # of Orders DL Hrs General Total # of # of Unallocated Projects Customers Production Dept. ZZZ 10% 60% 15% 10% 5% 100% For Production Dept. QQQ 20% 50% 10% 10% 10% 100% Selling 20% 20% 20% 25% 15% 100% Admin 10% 25% 20% 10% 35% 100% R&D 15% 25% 35% 10% 15% 100% TO DO: A. Compute activity pools amounts & Cost per activity Unit [need to compute total # of Hrs.] B. Customer BBB in the period placed two orders for [in total] bought 100 ProductA & 120 Product B Profit for Cust. BBB using FAC & ABC costing C. Profit by product & Total company using, Variable & ABC
