Please help with the "Determine the customer margin for the OfficeMart orders under Activity-Based Costing" section and please include the excel formulas. Thank you! :) Required informationThe Chapter 7 Form worksheet is to be used to create your own worksheet version of the Review Problem for ActivityBased Costing found in the text (include a link of the problem).Download the Applying Excel form and enter formulas in all cells that contain question marks.For example, in cell B26 enter the formula "= B4'B8",Note that the worksheet contains a section at the bottom titled "Determine the Product Margin Under a Traditional Cost System" that is not in the Review Problem. In thissection, it is assumed that the traditional costing system allocates manufacturing overhead on the basis of the number of units produced. When completed, that part of theworksheet should contain the following results:52Determine the product margin for the OfficeMart orders under a traditional cost systemManufacturing overheadTotal activity53$500,000541,000 units55Manufacturing overhead per unit2$500 per unit56Sales$ 47,6005758Costs:59Direct materials$ 14,40060Direct labor4,00061Manufacturing overhead40,00058,400Traditional costing product margin$ (10,800)6263After entering formulas in all of the cells that contained question marks, verify that the dollar amounts match the numbers in the Review Problem.Check your worksheet by doubling the units ordered in cell B16 to 160. The customer margin under activity-based costing should now be $7,640 and the traditional costingproduct margin should be $(21,600). If you do not get these results, find the errors in your worksheet and correct them. x fxDetermine the customerА42ВD1 Chapter 7: Applying Excel3 Data4 Manufacturing overhead5 Selling and administrative overhead$500,000$300,0006AssemblingUnitsProcessingOrdersSupportingCustomers7Other8 Manufacturing overhead9 Selling and administrative overhead10 Total activity50%35%5%10%10%45%25%20%1,00025010011unitsorderscustomers1213 OfficeMart orders:1 customer4 orders14 Customers15 Orders16 Number of filing cabinets ordered in total17 Selling price18 Direct materials160 units$595$180$5019 Direct labor2021 Enter a formula into each of the cells marked with a ? below22 Review Problem: Activity-Based Costing2324 Perform the first stage allocationsProcessingOrdersSupportingAssemblingUnits$Total2$25CustomersOther250,000$ 50.00026 Manufacturing overhead27 Selling and administrative overhead28 Total cost175,000 $25,000.00135,000500.00030,00075,00060,000300,000$ 280,0002$310,000 $ 100,000$ 110,000800,0002930 Compute the activity rates31 Activity Cost Pools32 Assembling units33 Processing orders34 Supporting customersTotal ActivityActivity Rate$280 per unit$1,240 per order$1,000 per customerTotal Cost$ 280,0001.000 units$310,000250 orders$100,000100 customers3536 Compute the overhead cost attributable to the OfficeMart orders37 Activity Cost Pools38 Assembling units39 Processing orders40 Supporting customersActivity Rate$280 per unit$1,240 per order$1,000 per customerАВС Cost$44,800$4,960$1,000Activity160 units4 orders1 customer4142 Determine the customer margin for the OfficeMart orders under Activity-Based Costing43 Sales44 Costs:Direct materialsDirect labor454647Unit-related overhead48Order-related overhead49Customer-related overhead?50 Customer margin?5152 Determine the product margin for the OfficeMart orders under a traditional cost system53 Manufacturing overhead54 Total activity55 Manufacturing overhead per unit$500,0001.000 units$500 per unit5657 Sales$95.20058 Costs:59Direct materials$28.80060Direct labor8,00061 Manufacturing overhead62 Traditional costing product margin80.000116,800$ 212,00063

Name: Please help with the "Determine the customer margin for the OfficeMart
Uploaded: 2024-03-20T06:32:49.000Z
Channel: Bartleby
Description: Please help with the "Determine the customer margin for the OfficeMart orders under Activity-Based Costing" section and please include the excel formulas. Thank you! :) Required informationThe Chapter 7 Form worksheet is to be used to create your own

Question

Please help with the &#34;Determine the customer margin for the OfficeMart orders under Activity-Based Costing&#34; section and please include the excel formulas. Thank you! :) Required informationThe Chapter 7 Form worksheet is to be used to create your own worksheet version of the Review Problem for ActivityBased Costing found in the text (include a link of the problem).Download the Applying Excel form and enter formulas in all cells that contain question marks.For example, in cell B26 enter the formula &#34;= B4'B8&#34;,Note that the worksheet contains a section at the bottom titled &#34;Determine the Product Margin Under a Traditional Cost System&#34; that is not in the Review Problem. In thissection, it is assumed that the traditional costing system allocates manufacturing overhead on the basis of the number of units produced. When completed, that part of theworksheet should contain the following results:52Determine the product margin for the OfficeMart orders under a traditional cost systemManufacturing overheadTotal activity53$500,000541,000 units55Manufacturing overhead per unit2$500 per unit56Sales$ 47,6005758Costs:59Direct materials$ 14,40060Direct labor4,00061Manufacturing overhead40,00058,400Traditional costing product margin$ (10,800)6263After entering formulas in all of the cells that contained question marks, verify that the dollar amounts match the numbers in the Review Problem.Check your worksheet by doubling the units ordered in cell B16 to 160. The customer margin under activity-based costing should now be $7,640 and the traditional costingproduct margin should be $(21,600). If you do not get these results, find the errors in your worksheet and correct them. x fxDetermine the customerА42ВD1 Chapter 7: Applying Excel3 Data4 Manufacturing overhead5 Selling and administrative overhead$500,000$300,0006AssemblingUnitsProcessingOrdersSupportingCustomers7Other8 Manufacturing overhead9 Selling and administrative overhead10 Total activity50%35%5%10%10%45%25%20%1,00025010011unitsorderscustomers1213 OfficeMart orders:1 customer4 orders14 Customers15 Orders16 Number of filing cabinets ordered in total17 Selling price18 Direct materials160 units$595$180$5019 Direct labor2021 Enter a formula into each of the cells marked with a ? below22 Review Problem: Activity-Based Costing2324 Perform the first stage allocationsProcessingOrdersSupportingAssemblingUnits$Total2$25CustomersOther250,000$ 50.00026 Manufacturing overhead27 Selling and administrative overhead28 Total cost175,000 $25,000.00135,000500.00030,00075,00060,000300,000$ 280,0002$310,000 $ 100,000$ 110,000800,0002930 Compute the activity rates31 Activity Cost Pools32 Assembling units33 Processing orders34 Supporting customersTotal ActivityActivity Rate$280 per unit$1,240 per order$1,000 per customerTotal Cost$ 280,0001.000 units$310,000250 orders$100,000100 customers3536 Compute the overhead cost attributable to the OfficeMart orders37 Activity Cost Pools38 Assembling units39 Processing orders40 Supporting customersActivity Rate$280 per unit$1,240 per order$1,000 per customerАВС Cost$44,800$4,960$1,000Activity160 units4 orders1 customer4142 Determine the customer margin for the OfficeMart orders under Activity-Based Costing43 Sales44 Costs:Direct materialsDirect labor454647Unit-related overhead48Order-related overhead49Customer-related overhead?50 Customer margin?5152 Determine the product margin for the OfficeMart orders under a traditional cost system53 Manufacturing overhead54 Total activity55 Manufacturing overhead per unit$500,0001.000 units$500 per unit5657 Sales$95.20058 Costs:59Direct materials$28.80060Direct labor8,00061 Manufacturing overhead62 Traditional costing product margin80.000116,800$ 212,00063

Accepted Answer

Solution:
Introduction:
Traditional costing is the more simplest method which typically delivers…