How do I create a gross margin table based on activities method with sales and COGS in total dollars for 2020 for both product lines?

Traditional Classic Total Sales (units) 10000 8000 18000 Beggining Finished Goods 480.000,00 $ 500.000,00 $ 980.000,00 Direct Material $ 2.000.000,00 $ 3.400.000,00 $5.400.000,00 Direct Labor S 370.370,00 $ 185.186,00 $ 555.556,00 Ending Finished Goods S 480.000,00 $ 520.000,00 $ 1.000.000,00 Overhead Breakdown Percentage Machining 49% Assembly 29,60% Material Handling 6,95% Inspection 14,45% Total 100% Traditional Classic Cost Pool for 2020 Direct Labor Hours 2000 1000 Machine Hours 30000 60000 Assembly Hours 12000 11000 Material Handling Parts 10 20 Inspection Hours 1000 1500