I need help answering the following comprehensive problem. I need and answer to all three parts (i.e. a, b, and c). I provided an example of the Pro balance spreadsheet that I need to create using the information below.

Thanking you in advance for your help.

Comprehensive Problem Mansfield Corporation had 2010 sales of $100 million. The balance sheet items that vary directly with sales and the profit margin are as follow:

Percent Cash