Please show your math/work ( even if you use excel) :)!

It's close to a $40,000 loser and we ought to devote our efforts elsewhere," noted Karenne Whitmore, after reviewing financial reports of her company's attempt to offer a reduced-price daycare service to employees. The daycare's financial figures for the year just ended follow.

Revenues: $120,000

Variable Costs 45,000

Tracable Fixed 89,000

Allocated corporate overhead 24,000

If the daycare service/center is closed, 70% of the traceable fixed cost will be avoided. In addition, the company will incur one-time closure costs of $6,800.

Required: (30 points) A. Show calculations that support Whitmore's belief that the daycare center lost almost $40,000. B. Should the center be closed? Show calculations to support your answer. C. What problem might the company experience if the center is closed?