Posted: March 14th, 2016

On the Supplier Financial Analysis spreadsheet, calculate the basic ratios of each company. Submit printed spreadsheet.

COMINC Case Write-up
20 Point Case

Assignments:

1. Supplier Financial Analysis (15% of Grade)
(a) On the Supplier Financial Analysis spreadsheet, calculate the basic ratios of each company. Submit printed spreadsheet.
(b) For each ratio, highlight which company is strongest, which one is weakest and the implication for each. Submit 1 single spaced page.

2. Total Cost of Ownership (TCO) (20% of Grade)
On the Bid Summary and TCO Worksheet, calculate the total cost of ownership across the four companies. You will need to think through some of the calculations, such as quality and inventory. Submit printed spreadsheet.