Moorcroft Company plans to sell 3,000 candy bars with the following information:

Financial Information

Selling price per candy bar.........................................................................$1.00

Variablecost of goods sold per candy bar...............................................$.40

Fixed manufacturing cost per year.............................................................$12,000

Variablecost of goods sold per candy bar....................................................$.30

Variable selling and administrative expense per candy bar......................$.05

Fixed selling and administrative expense..................................................$ 4,000

Instructions:Using Excel, prepare the following

1. CVP formatted income statement
2. Break even point in units
3. Break even point in dollars
4. Margin of safety in dollars
5. Margin of safety ratio