Need a step-by-step walkthrough

I don't understand this. Last year [year 1), we decided to drop our highest-end Red model and only produce the Yellow and Green models, because the cost system indicated we were losing money on Red. Now, looking at the preliminary numbers, our profit is actually lower than last year and it looks like Yellow has become a money loser, even though our prices, volumes, and direct costs are the same. Can someone please explain this to me and maybe help me decide what to do next year? Robert Dolan President & CEO Dolan Products Dolan Products is a small, family-owned audio component manufacturer. Several years ago, the company decided to concentrate on only three models, which were sold under many brand names to electronic retailers and mass-market discount stores. For internal purposes, the company uses the product names Red, Yellow, and Green to refer to the three components. Data on the three models and selected costs follow. Total 48,000 Year 1 Units produced and sold Sales price per unit Direct materials cost per unit Direct labor-hours per unit Wage rate per hour Total manufacturing overhead Red 10,000 $145 $ 80 3 $ 10 Yellow 15,000 $125 $ 70 2 $ 10 Green 23,000 $ 80 $ 50 0.2 $ 10 $969,000 This year (year 2), the company only produced the Yellow and Green models. Total overhead was $778,500. All other volumes, unit prices, costs, and direct labor usage were the same as in year 1. The product cost system at Dolan Products allocates manufacturing overhead based on direct labor-hours. Complete this question by entering your answers in the tabs below. Required A Required B Required C Compute the product costs and gross margins (revenue less cost of goods sold) for the three products and total gross profit (loss) for year 1. (Do not round intermediate calculations. Negative amounts should be indicated by a minus sign. Round your answers to 2 decimal places.) Red Yellow Green Total Product cost per unit Gross margin (loss) per unit Total gross profit (loss) Required A Required B Required C Should Dolan Products drop Yellow for year 3? Yes ONO