Traditional costing method vs Activities method

1. Prepare a gross margin table based on traditional costing method with sales and COGS in total dollars for 2018 for both product lines

2. Prepare a gross margin table based on activities method with sales and COGS in total dollars for 2018 for both product lines

Inc, a leading manufacturing compamy has two main lines of products Tradtional and Modern with the unit sales prices for $340 and $400 respectively. Manufacturing overhead are appied as $544.025 per direct labor hour. Bucgeted statement of gross margin 201B Traditiona Modern Sales in units 10000 5480,000.00 $600000.00 $1,080,000 00 $2,000,000.00 $3,500,000.00 $5,500,000.00 $370,370.00 185,186.00 $555,555.00 Beginning finished goods Ending finished goods Overhead breakdown in percentage 52 02% 26 59% Material Handing Tota Cost pool info for 2018 Direct labor hours Machine hours Assembly hours Material handling parts Inspection hours Traditiona Modern 2000 1000 30000 20 1000 1500 Projections 2019 Ending inventory in dollars Sales in units Traditional Modern 5260,0c0.00 $140000.00 Material, labors and overhead are expected to increase by 10% each in 2019. Unit sale prices for both products are expected to increase by $10 each in 2019 Percentage of averhead remains the same in 2019 The cost drivers units are staying the same in 2019