Answered step by step
Verified Expert Solution
Question
1 Approved Answer
Please complete the excel sheet that is in the attachment. qattachments_5dfc4f51392bc973ca04de16ffff3da5d7a3563e.xlsx Chapter 6: Applying Excel Data Manufacturing overhead Selling and administrative overhead Manufacturing overhead Selling
Please complete the excel sheet that is in the attachment.
qattachments_5dfc4f51392bc973ca04de16ffff3da5d7a3563e.xlsx Chapter 6: Applying Excel Data Manufacturing overhead Selling and administrative overhead Manufacturing overhead Selling and administrative overhead Total activity OfficeMart orders: Customers Orders Number of filing cabinets ordered in total Selling price Direct materials Direct labor $500,000 $300,000 Assembling Processing Supporting Units Orders Customers 50% 35% 5% 10% 45% 25% 1,000 250 100 units orders customers Other 10% 20% 1 customer 4 orders 80 units $595 $180 $50 Enter a formula into each of the cells marked with a ? below Review Problem: Activity-Based Costing Perform the first stage allocations Manufacturing overhead Selling and administrative overhead Total cost Compute the activity rates Activity Cost Pools Assembling units Processing orders Supporting customers Assembling Units ? ? ? Processing Supporting Orders Customers ? ? ? ? ? ? Total Cost ? ? ? Total Activity ? units ? orders ? customers Compute the overhead cost attributable to the OfficeMart orders Activity Cost Pools Activity Rate Assembling units ? per unit Processing orders ? per order Supporting customers ? per customer Determine the product margin for the OfficeMart orders under a traditional cost system Manufacturing overhead ? Total ? ? ? ? ? ? Activity Rate ? per unit ? per order ? per customer Activity ? units ? orders ? customer Determine the customer margin for the OfficeMart orders under Activity-Based Costing Sales ? Costs: Direct materials ? Direct labor ? Unit-related overhead ? Order-related overhead ? Customer-related overhead ? ? Customer margin ? Page 1 Other ABC Cost ? ? ? qattachments_5dfc4f51392bc973ca04de16ffff3da5d7a3563e.xlsx Total activity Manufacturing overhead per unit Sales Costs: Direct materials Direct labor Manufacturing overhead Traditional costing product margin ? units ? per unit ? ? ? ? Page 2Step 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