Question: 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
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

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Accounting Questions!