Answered step by step
Verified Expert Solution
Question
1 Approved Answer
Need to figure the ? in each box with formulas Chapter 7: Applying Excel Data Manufacturing overhead Selling and administrative overhead $500.000 $300.000 Processing Orolors
Need to figure the ? in each box with formulas
Chapter 7: Applying Excel Data Manufacturing overhead Selling and administrative overhead $500.000 $300.000 Processing Orolors Supporting Customers 5X B Assembling Units 50% 10% Manufacturing overhead Selling and administrative overhead Total activity 0 1.000 orders customers 1 customer 3 Orchart orders: -4 Customers 15 Orders 16 Number of filing cabinets ordered in total 17 Selling price 18 Direct materials 19 Direct labor 80 units $180 20 21 Enter a formula into each of the calls marked with a below R2 Review Problem: Activity-Based Costing 24 Perform the first stage allocations Assembling Units 250.000 Processing Orders $ 175 000 135.000 $ 310.000 Supporting Customers $ 25000 $ Other 50.000 26 Manufacturing overhead 27 Selling and administrative overhead 28 Total cost $ 2000 Total 500,000 300 000 800,000 280.000 100.000 $ 110.000 $ 30 Compute the activity rates 31 Activity Cost Pools 32 Asembling units 33 Processing orders 34 Supporting customers To Cost 280,000 $ 310,000 $ 100,000 Total Activity 1 000 units 250 orders 100 customers Activity Rate $280 per unit $1.240 per order $1,000 per customer 36 Compute the overhead cost attributable to the OfficeMart orders 37 Activity Cost Pools Aty Rate 38 Assembling units 18 Ler unit 39 Processing orders $1,240 per order 40 Suporting customers $1,000 per customer Activity 7 units ABC Cost 7 customer 42 Determine the customer margin for the OfficeMart orders under Activity Based Costing 43 Sales 44 Costs 45 Direct materials 46 Direct labor 47 Unit-related overhead 48 Order-related overhead 49 Customer related overhead 50 Customer margin 51 52 Determine the product margin for the OfficeMart orders under a traditional cost system S3 Manufacturing overhead 54 Total activity ? units 55 Manufacturing overhead per unit 57 Sales 58 Costs 59 Dect materials 60 Director 61 Manufacturing overhead 62 Traditional costing product margin 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