Mozena Corporation has collected the following information after its first year of sales.

Sales were $1,600,000 on 100,000 units;

selling expenses $241,500 (40% variable and 60% fixed);

direct materials $513,200;

direct labor $370,740;

administrative expenses $272,300 (20% variable and 80% fixed);

manufacturing overhead $350,000 (70% variable and 30% fixed).

Top management has asked you to do a CVP analysis so that it can make plans for the coming year. It has projected that unit sales will increase by 10% next year.

I already figured out the contribution margin for the current year is $320,000, and $352,000 for the projected year.

Please make an excel table and find the fixed costs, break-even point in units, and break-even point in dollars. In the table please also include the contribution margins for this and next year so I can understand it better.

Thank you and I will leave a thumbs up for a good explanation!