I filled out the Excel attached, please answer these 2 questions regarding the Excel: Thank you
1. How much cost will be the Per Unit Cost allocation for product #1 at the end of ABC method of allocation cost per unit?
2. How much cost will be the Per Unit Cost allocation for product #2 at the end of your ABC method of allocation cost per unit?
ALLOCATE COSTS: For the following four cost categories (indirect materials, maintenance, other, and SG\&A), make assumptions about the percentages to be assigned to each of the activities (X,Y,Z, or unallocated). Use the available pick lists from within each boxed area and enter your selection. Your total allocation must equal 100% for each row. The percentages you selected above are next used in the table below to allocate the total costs (assumed) among the various activities (experiment with alternative percentages above and observe how this changes the cost allocations below): DE.TERMINE THE. PE.R-ACTIVTTY R.ATES: Each of the products and other cost objects consumed activities at the rate indicated in the table below. Ese this iaformation and cest data above to determine the per unit activity cost measures. Use the available pick lists from within cach boxed area te select the correct values. APPLY COSTS TO OBJECTS; Given belen are the costs of difret material and direct laber. Assume that Cost Object A is allocated half to Product 1 and half to Product W2. Assume that Cost Object B is fully allocated to Product \#2. Use the piek lists from within the boxed areas below to apply all cests. The per unit amounts are autontatically calculated. Study and revicw the entire process, considering the aoals and objectives of ABC. ALLOCATE COSTS: For the following four cost categories (indirect materials, maintenance, other, and SG\&A), make assumptions about the percentages to be assigned to each of the activities (X,Y,Z, or unallocated). Use the available pick lists from within each boxed area and enter your selection. Your total allocation must equal 100% for each row. The percentages you selected above are next used in the table below to allocate the total costs (assumed) among the various activities (experiment with alternative percentages above and observe how this changes the cost allocations below): DE.TERMINE THE. PE.R-ACTIVTTY R.ATES: Each of the products and other cost objects consumed activities at the rate indicated in the table below. Ese this iaformation and cest data above to determine the per unit activity cost measures. Use the available pick lists from within cach boxed area te select the correct values. APPLY COSTS TO OBJECTS; Given belen are the costs of difret material and direct laber. Assume that Cost Object A is allocated half to Product 1 and half to Product W2. Assume that Cost Object B is fully allocated to Product \#2. Use the piek lists from within the boxed areas below to apply all cests. The per unit amounts are autontatically calculated. Study and revicw the entire process, considering the aoals and objectives of ABC
