I recently had a death in the family. Due to this, it's been extremely hard to keep up with assignments. I've managed to do 4 of the 5 assignments that I have due but I don't have the mental capacity to finish this one. I could really use some last minute assistance.

Unitselgprice Chapter 7 15e - Worksheet II Note: Use your text and provided resources See Problem details beginning Applying Excel Follow-up Instructions: Complete worksheet, do not respond to questions unless instructed to do so. Everything in this worksheet Exercises at the end of the chapter in the assigned text. Enter a formula into each of the shaded cells below Applying Excel Ch07 (p. 315-317) Complete this worksheet then proceed with REQUIREMENTS 2 only. See data provided on p. 316-31 *Complete the worksheet using the data in the text. Cell references in this worksheet DO NOT align with cell references in the Provided Data Manufacturing overhead Selling and administrative overhead Manufacturing overhead Selling and administrative overhead Total activity $500,000 $300,000 Assembling Processing Supporting Units Orders Customers 50% 35% 5% 10% 45% 25% 1,000 250 100 units orders customers OfficeMart orders: Customers Orders Number of filing cabinets ordered in total Selling price Direct materials Direct labor Other 10% 20% 1 customer 4 orders 80 units $595 $180 $50 Enter a formula into each of the shaded cells below Review Problem: Activity-Based Costing Perform the first stage allocations Assembling Units Processing Orders Supporting Customers Other Manufacturing overhead Selling and administrative overhead Total cost Compute the activity rates Activity Cost Pools Assembling units Processing orders Supporting customers Total Cost Total Activity 1,000 units 250 orders 100 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 Activity Rate Activity 80 units 4 orders 1 customer $3 Determine the customer margin for the OfficeMart orders under Activity-Based Costing Sales Incorrect Costs: Direct materials # of filing cabinets ordered x Direct Materials Direct labor # of filing cabinets ordered x Direct Labor Unit-related overhead Order-related overhead Customer-related overhead Incorrect Customer margin Incorrect Determine the product margin for the OfficeMart orders under a traditional cost system Manufacturing overhead Total activity $ 1,000 units Manufacturing overhead per unit per unit Incorrect Sales Costs: Direct materials Direct labor Manufacturing overhead Traditional costing product margin Incorrect Incorrect Incorrect 2. Provided Data Manufacturing overhead Selling and administrative overhead Manufacturing overhead Selling and administrative overhead Total activity $500,000 $300,000 OfficeMart orders: Customers Orders Number of filing cabinets ordered in total Selling price Direct materials Direct labor 1 customer 20 orders 80 units $795 $185 $90 Enter a formula into each of the shaded cells 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 = 0.2 Assembling Processing Supporting Units Orders Customers 50% 35% 5% 10% 45% 25% 1,000 250 100 units orders customers Assembling Processing Units Orders $ - $ $ - $ $ - $ - Total Cost Supporting Customers $ $ $ - Total Activity Other 10% 20% Other $ $ $ - Activity Rate Assembling units Processing orders Supporting customers $ $ $ - 1,000 units 250 orders 100 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 $ $ $ $15 - Activity 80 units 20 orders 1 customer Determine the customer margin for the OfficeMart orders under Activity-Based Costing Sales Incorrect Costs: Direct materials Direct labor Unit-related overhead Order-related overhead Customer-related overhead Incorrect Customer margin $ - Incorrect Determine the product margin for the OfficeMart orders under a traditional cost system Manufacturing overhead Total activity units Manufacturing overhead per unit per unit Incorrect Sales Costs: Direct materials Direct labor Manufacturing overhead Traditional costing product margin Incorrect $ - Incorrect Incorrect Attention: Tests (and/or quizzes) in Managerial Finance WILL NOT include the CORRECT / INCORRECT indicators. Therefore, your goal should not be to merely arrive a solution that moves the indictor from INCORRRECT to CORRECT but to know how you arrived at the correct solution. The End oUnitsvlerghpaicdrte Estimaedtoalmountfhealoctinbase ur text and provided resources! details beginning page 315 Everything in this worksheet relates directly to Problems and NTS 2 only. ign with cell references in the text. Total $ $ $ - Incorrect - Incorrect - Incorrect Activity Rate per unit Incorrect per order Incorrect per customer Incorrect ABC Cost Incorrect Incorrect Incorrect $ 8 0 , $3 = 0.2 = =160% x Direct Materials x Direct Labor Total $ $ $ Activity Rate - Incorrect - Incorrect - Incorrect $15 $50, directmaerilscot per unit per order per customer ABC Cost $ $ $ - / INCORRECT indicators. INCORRRECT to