I am working on an excel sheet for my accounting course. The worksheet itself will flip certain areas from incorrect to correct once the correct answer is placed in. I have found, and the instructor has admitted, that some spaces will not turn to correct due to some type of malfunction. I've done calculations on the last two sections of this worksheet and the worksheet is still showing incorrect. Could I have someone assist in double-checking my answers or letting me know where I'm messing up? Any help would be greatly appreciated as the assignment is overdue at this point.

The two sections I need assistance with are labeled "Determine the customer margin for the OfficeMart orders under Activity-Based Costing" and "Determine the product margin for the OfficeMart orders under a traditional cost system." You will also notice that the answers in that area are still labeled "incorrect."

Please help.

Thank you.

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 Manufacturing overhead Selling and administrative overhead Total cost Assembling Processing Units Orders $ 250,000 $ 175,000 30,000 135,000 $ 280,000 $ 310,000 Compute the activity rates Activity Cost Pools Assembling units Processing orders Supporting customers Total Cost $ 280,000 $ 310,000 $ 100,000 Supporting Customers Other $ 25,000 $ 50,000 75,000 60,000 $ 100,000 $ 110,000 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 $ 280 per unit Processing orders $ 1,240 per order Supporting customers $ 1,000 per customer $ $ $ Activity Rate 280 1,240 1,000 Activity 80 units 4 orders 1 customer $3 Determine the customer margin for the OfficeMart orders under Activity-Based Costing Sales $ 47,600 Correct Costs: Direct materials $ 14,400 # of filing cabinets ordered x Direct Materials Direct labor 4,000 # of filing cabinets ordered x Direct Labor Unit-related overhead 22,400 Order-related overhead 4,960 Customer-related overhead 1,000 46,760 Correct Customer margin $ 840 Correct Determine the product margin for the OfficeMart orders under a traditional cost system Manufacturing overhead $ 500,000 Total activity $ 1,000 units Manufacturing overhead per unit $ 500 per unit Correct Sales Costs: Direct materials Direct labor Manufacturing overhead Traditional costing product margin $ $ $ 2. Provided Data Manufacturing overhead Selling and administrative overhead Manufacturing overhead Selling and administrative overhead Total activity $ 47,600 Correct 14,400 4,000 40,000 $ $ 58,400 Correct (10,800) Correct $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 $ 250,000 $ 175,000 $ 30,000 $ 135,000 $ 280,000 $ 310,000 Total Cost Other 10% 20% Supporting Customers Other $ 25,000 $ 50,000 $ 75,000 $ 60,000 $ 100,000 $ 110,000 Total Activity Activity Rate Assembling units Processing orders Supporting customers $ $ $ 280,000 310,000 100,000 1,000 units 250 orders 100 customers Compute the overhead cost attributable to the OfficeMart orders Activity Cost Pools Activity Rate Assembling units $ 280 per unit Processing orders $ 1,240 per order Supporting customers $ 1,000 per customer $ $ $ $15 280 1,240 1,000 Activity 80 units 20 orders 1 customer Determine the customer margin for the OfficeMart orders under Activity-Based Costing Sales $ 47,600 Incorrect Costs: Direct materials $ 14,400 Direct labor 4,000 Unit-related overhead 22,400 Order-related overhead 4,960 Customer-related overhead 1,000 46,760 Incorrect Customer margin $ 840 Incorrect Determine the product margin for the OfficeMart orders under a traditional cost system Manufacturing overhead $ 500,000 Total activity $ 1,000 units Manufacturing overhead per unit $ 500 per unit Correct Sales Costs: Direct materials Direct labor Manufacturing overhead Traditional costing product margin $ $ $ $ 47,600 Incorrect 14,400 4,000 40,000 $ $ 58,400 Incorrect (10,800) 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 500,000 Correct 300,000 Correct 800,000 Correct Activity Rate per unit Correct per order Correct per customer Correct ABC Cost $ 22,400 Correct $ 4,960 Correct $ 1,000 Correct $ 8 0 , $3 = 0.2 = =160% x Direct Materials x Direct Labor $ $ $ Total 500,000 Correct 300,000 Correct 800,000 Correct Activity Rate $15 $50, directmaerilscot per unit per order per customer ABC Cost $ 22,400 $ 24,800 $ 1,000 / INCORRECT indicators. INCORRRECT to