Answered step by step
Verified Expert Solution
Link Copied!

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

image text in transcribed
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

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Horngrens Cost Accounting A Managerial Emphasis

Authors: Rajan Datar, Srikant M. Datar

16th Edition

9352860195, 978-9352860197

More Books

Students also viewed these Accounting questions

Question

=+2. Explain the interactions in the newspaper and magazine market!

Answered: 1 week ago