PR 18-4B Activity-based produ Activity-based product costing EXCEL TEMPLATE Obj. 4 Sweet Sugar Company manufactures three products (white sugar, brown sugar, and powdered sugar) in a continuous production process. Senior management has asked the controller to conduct an activity-based costing study. The controller identified the amount of factory overhead required by the critical activities of the organization as follows: Activity Production Setup Inspection Shipping Customer service Total Budgeted Activity Cost $500,000 144,000 44,000 115,000 84,000 $887,000 The activity bases identified for each activity are as follows: The activity bases identified for each activity are as follows: Activity Base Activity Production Setup Inspection Shipping Customer service Machine hours Number of setups Number of inspections Number of customer orders Number of customer service requests The activity-base usage quantities and units produced for the three products were determined from corporate records and are as follows: Customer Service Requests Number of Customer Orders 1,150 2,600 Units Machine Hours 5,000 2,500 2,500 10,000 Number of Number of Setups Inspections 85 220 330 White sugar Brown sugar Powdered sugar Total 170 10,000 5,000 5,000 20,000 195 2,000 190 450 550 1,100 5,750 Each product requires 0.5 machine hour per unit. Instructions 1. Determine the activity rate for each activity. 2. Determine the total and per-unit activity cost for all three products. (Round to nearest cent.) Answer + - Why aren't the activity unit costs equal across all three products since they require the same machine time per unit? fox E F G H I J K L M N O P Q R S T U V W X Y Z AA AB -C2 x A B c o Problem 18/41-4B 1 Name: Section: Score: 096 Koy Cody koy code here 3 Instructions Answers are entered in the onls with gray backgrounds. 0 Cells with non-gray backgrounds are protected and cannot be edited. 1 An asterisk (*) will appear to the right of an incorect entry. The essay answer wil not be graded Production Setup -OGO CON Total activity cost - Total activity base Activity rate setups setup inspections Inspect cust, anders cust. ord. requests /request imh White Sugar Activity Rate Activity Cost Activity Cost Activity Cout Activity Base Usage - Powdered Sugar Activity Activity Base Usage Rate mh setups - Brown Sugar Activity Activity Base Uwage Rate mrh setups insp. cust. orders requests N Activity Production Setup Inspection Shipping Customer service Total Number of units Activity cost per unit insp. setups insa. cust. orders requests cust. orders requests [Key essay answer here! ac CN - O fox E F G H I J K L M N O P Q R S T U V W X Y Z AA AB -C2 x A B c o Problem 18/41-4B 1 Name: Section: Score: 096 Koy Cody koy code here 3 Instructions Answers are entered in the onls with gray backgrounds. 0 Cells with non-gray backgrounds are protected and cannot be edited. 1 An asterisk (*) will appear to the right of an incorect entry. The essay answer wil not be graded Production Setup -OGO CON Total activity cost - Total activity base Activity rate setups setup inspections Inspect cust, anders cust. ord. requests /request imh White Sugar Activity Rate Activity Cost Activity Cost Activity Cout Activity Base Usage - Powdered Sugar Activity Activity Base Usage Rate mh setups - Brown Sugar Activity Activity Base Uwage Rate mrh setups insp. cust. orders requests N Activity Production Setup Inspection Shipping Customer service Total Number of units Activity cost per unit insp. setups insa. cust. orders requests cust. orders requests [Key essay answer here! ac CN - O 55. Draw Page Layout WRD FinMan 14e PR 18(4)-48 Insert Formulas Data Review View me hr Paste UUD ShareCom BI Conditional Formatting Formatas table hert A . Format X T esty Anwen an entered in the cele wth guy backgrounds Cene with money backgrounds are protected and cannot be edited Anastark wil gear to the right of a cometenty. They are be graded Total y cost Acthyst culo WRD FnMan 14e PR 18(4)-43 Home Insert Draw Page Layout Formulas Data Review View Cordonal Formati Forsbe e rt Format x fx 1 Problem 18/4)-48 Answers are entered in the with grey backgrounds Cells with nongray backgrounds are protected and cannot be edited Anastank wil pear to menght of an orderly were not beed Total activity cost - Total activity base Activity rate Inspect Setup Shipping FERRARARRRRRRRAS Nurcer of units Key say nowether DWRD_FinMan 14e_PR 18(4-48 Home Insert Draw Page Layout Formulas Data Review View Share Como WRD Fin Man 14e PR 18(4)-48 Draw Home Insert v X Page Layout Formulas Data Review View 27- 09 Forma Table Col Styles Section Score: Answers are entered in the cats w ay backgrounds 10 Calls with non-gray backgrounds are protected and cannot be edited 11 An asterisk C) will appear to the roof an comedy They were not beer Total activity cost Ayo per un E F G H I J K L M N O P Q R S T U V W X Y Z AA AB A B C D Problem 18141-46 Name: Section: Scores Arses are entered in the ceils with gray backgrounds O Cells with non-gray backgrounds are protected and cannot be edited An will appear to the ght of an income . They will not be de Total actity cost Total activity base Activity customers Ali Activity cost per unit
