Required (Do not round down in calculations until the final answer at two decimal point.)

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.

3. What does the information in both 2018 tables tell you?

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

5. Calculate the fixed cost and variable cost components of COGS for the two clients using the least squares regression method. Show your work and write out the regression model equation for each client.

6. Discuss the two clients COGS in terms of fixed cost and variable cost according to special specifications.

Case info: Harvard Square Inc., a leading manufacturing company has two main lines of products: Traditional and Modern with unit sales prices of $400 and $550. Currently manufacturing overheads are applied as $580 per direct labor hours. Below is some internal company information. Harvard Square Partial budgeted statement of gross margin 2019 Products Traditional 12500 Modern Sales in units Beginning inventory Direct material Direct labor Ending inventory Total 25000 1,350,000.00 6,875,000.00 12500 600,000.00 750,000.00 $ $2,500,000.00 $4,375,000 S462,962.50$ $600,000.00 $ 231,482.50 $ 750,000.00 $ 694,445.00 1,350,000.00 Overhead breakdown in percentage Machining Assembly Material Handling Inspection Total 50.00% 25.00% 7.00% 18.00% 100.00% Products Cost pool info for 2018 Direct labor hours Machine hours Assembly hours Material handling parts Inspection hours Traditional Modern 2500 37500 15000 12.5 1250 75000 13750 201.25 1250 15001.25 Case info: Harvard Square Inc., a leading manufacturing company has two main lines of products: Traditional and Modern with unit sales prices of $400 and $550. Currently manufacturing overheads are applied as $580 per direct labor hours. Below is some internal company information. Harvard Square Partial budgeted statement of gross margin 2019 Products Traditional 12500 Modern Sales in units Beginning inventory Direct material Direct labor Ending inventory Total 25000 1,350,000.00 6,875,000.00 12500 600,000.00 750,000.00 $ $2,500,000.00 $4,375,000 S462,962.50$ $600,000.00 $ 231,482.50 $ 750,000.00 $ 694,445.00 1,350,000.00 Overhead breakdown in percentage Machining Assembly Material Handling Inspection Total 50.00% 25.00% 7.00% 18.00% 100.00% Products Cost pool info for 2018 Direct labor hours Machine hours Assembly hours Material handling parts Inspection hours Traditional Modern 2500 37500 15000 12.5 1250 75000 13750 201.25 1250 15001.25