Compute the CM ratio and variable expense ratio, accounting homework help

PROBLEM 1:

Compute the CM ratio and variable expense ratio.

Compute the break-even point.

Compute the margin of safety.

Compute the degree of operating leverage.

PLEASE ANSWER HOW TO GET EACH HIGHLIGHTED YELLOW CELL. I HAVE TO ANSWER USING THE FORMULA SO CAN YOU PLEASE SHOW YOUR WORK USING EXCEL SPREADSHEET. CORRECT ANSWERS ONLY…THANK YOU!!

PROBLEM 4:

Using the variable costing, compute unit product cost, break-even, and prepare an income statement.

Using absorption costing, compute unit product cost, and prepare an income statement.

PLEASE ANSWER HOW TO GET EACH HIGHLIGHTED YELLOW CELL. I HAVE TO ANSWER USING THE FORMULA SO CAN YOU PLEASE SHOW YOUR WORK USING EXCEL SPREADSHEET…THANK YOU!