Calculate the ABC costs for each product on a per-box basis. Thank you in advance for any help. I have attached any relevant tables and data.

Activity Data by Product Small shallomama Large glass ballons Specialty ballaments Omaments per Box 12 6 1 1 Sales Price por los $9.00 $11,00 $17.00 All US dolls Product Omaments per Box Inspections per Box So Footage Per Box Machine Number of Number of Operations Omaments Batches Batches per Omament 420,000 800 300,000 750 100,000 500 Small colored glass Large colored glass Specialty omaments 12 6 1 2 4 1 0.5 0.2 Cost Accounting atur Ornaments In the third week of January, Yucalled the sales department inquire about pricing procedures for the afferent product lines. Se quickly discovered that the sales department investigated the prices of similar products available in the marketplace instant's prices accordingly. company was profitable overall but wondered if the prices by Yow that the sales department were sufficient to sure that the individual product lines were profitable costs for each of user's three products. She thought this might be helpful in determining She decided to have one of her senior mulys. Yung Chen, prepare a atalysis of his product whether any adjustments in the product prices were warranted to assist Chen in his task. Yu provided him with a schedule of the factory's mal overhead costs, as follows Overhem Anna Cost Production scheduling 385.000 Machine 160.000 Et depreciation 220.000 Part depreciation 150.000 Quality inspection 70.000 Padang 185.000 Daniet 300.000 TO $1.170.000 v page 10 r Historical Five-Year Plant-Administration Costs and Other Data page 72 ZAUNER ORNAMENTS Calculation of Product Costs: Volume-Based Costing System 2003 2002 2001 2000 1999 Total Plant Administration Costs $300,000 295,000 285,000 280,000 290,000 Ending Inventory Cost $90,000 83.000 58,000 50,000 76,000 Plant Personnel 122 122 119 112 116 Number of Customers 1200 1250 1100 800 600 Total Direct % of Plant Labor Costs Capacity Urod $520,000 70% 515,000 75% 555,000 85% 540,000 90% 500,000 95% Product Number of Onaments page 112 Smal colored gas Large colored glass Specialtymuments 420,000 300.000 100.000 Omat Number OM & DE Total Alocated Total Cost per Box Rose per Box DM & DE Overhead Total Cost per Box 12 35.000 5 4.00 $140.000 5590,283 5 739.268 5 2112 6 50.000 $ 500 250.000 428040 478,049 5 13.50 + 100.000 7.00 700.000 142 142. $.43 185.000 $ 1.000.000 51.170,000 $2,200.000 $ Plant Databy Product Line 100,000 Large Colored Glas Small Colored Glass Omama 526.100 | Specially Omaments $12.500 Total $90.000 551300 ZAUNER ORNAMENTS NA NA Calculation of Product Costs: DM- and DL-Based Costing System NA 24 24 Ending or Parsonnel Non-specialty Specialty painting Number of customers Total direct labor costs Puncted 500 420 10 1.200 $93.800 5343.200 583.200 NA 5520.000 70% NA NIA Number of Omaments Product Omaments per Box Number of Boxes DM & DL per Box Total DM&DL Allocated Overhead Total Cost Total Cost por Box Small colored glass Large colored glass Specialty omaments 420,000 300,000 100.000 12 6 1 35,000 $ 50,000 $ 100,000 $ 4.00 5.00 7.00 $ 140,000 250,000 700.000 $ 150,275 $ 268,349 $ 751,376 $ 290,275 518 349 1,451 376 $ 8.29 $ 10.37 $ 14.51 820,000 185.000 $ 1,000,000 $ 1,170,000 $ 2, 260,000 Activity Data by Product Small shallomama Large glass ballons Specialty ballaments Omaments per Box 12 6 1 1 Sales Price por los $9.00 $11,00 $17.00 All US dolls Product Omaments per Box Inspections per Box So Footage Per Box Machine Number of Number of Operations Omaments Batches Batches per Omament 420,000 800 300,000 750 100,000 500 Small colored glass Large colored glass Specialty omaments 12 6 1 2 4 1 0.5 0.2 Cost Accounting atur Ornaments In the third week of January, Yucalled the sales department inquire about pricing procedures for the afferent product lines. Se quickly discovered that the sales department investigated the prices of similar products available in the marketplace instant's prices accordingly. company was profitable overall but wondered if the prices by Yow that the sales department were sufficient to sure that the individual product lines were profitable costs for each of user's three products. She thought this might be helpful in determining She decided to have one of her senior mulys. Yung Chen, prepare a atalysis of his product whether any adjustments in the product prices were warranted to assist Chen in his task. Yu provided him with a schedule of the factory's mal overhead costs, as follows Overhem Anna Cost Production scheduling 385.000 Machine 160.000 Et depreciation 220.000 Part depreciation 150.000 Quality inspection 70.000 Padang 185.000 Daniet 300.000 TO $1.170.000 v page 10 r Historical Five-Year Plant-Administration Costs and Other Data page 72 ZAUNER ORNAMENTS Calculation of Product Costs: Volume-Based Costing System 2003 2002 2001 2000 1999 Total Plant Administration Costs $300,000 295,000 285,000 280,000 290,000 Ending Inventory Cost $90,000 83.000 58,000 50,000 76,000 Plant Personnel 122 122 119 112 116 Number of Customers 1200 1250 1100 800 600 Total Direct % of Plant Labor Costs Capacity Urod $520,000 70% 515,000 75% 555,000 85% 540,000 90% 500,000 95% Product Number of Onaments page 112 Smal colored gas Large colored glass Specialtymuments 420,000 300.000 100.000 Omat Number OM & DE Total Alocated Total Cost per Box Rose per Box DM & DE Overhead Total Cost per Box 12 35.000 5 4.00 $140.000 5590,283 5 739.268 5 2112 6 50.000 $ 500 250.000 428040 478,049 5 13.50 + 100.000 7.00 700.000 142 142. $.43 185.000 $ 1.000.000 51.170,000 $2,200.000 $ Plant Databy Product Line 100,000 Large Colored Glas Small Colored Glass Omama 526.100 | Specially Omaments $12.500 Total $90.000 551300 ZAUNER ORNAMENTS NA NA Calculation of Product Costs: DM- and DL-Based Costing System NA 24 24 Ending or Parsonnel Non-specialty Specialty painting Number of customers Total direct labor costs Puncted 500 420 10 1.200 $93.800 5343.200 583.200 NA 5520.000 70% NA NIA Number of Omaments Product Omaments per Box Number of Boxes DM & DL per Box Total DM&DL Allocated Overhead Total Cost Total Cost por Box Small colored glass Large colored glass Specialty omaments 420,000 300,000 100.000 12 6 1 35,000 $ 50,000 $ 100,000 $ 4.00 5.00 7.00 $ 140,000 250,000 700.000 $ 150,275 $ 268,349 $ 751,376 $ 290,275 518 349 1,451 376 $ 8.29 $ 10.37 $ 14.51 820,000 185.000 $ 1,000,000 $ 1,170,000 $ 2, 260,000