The answer and procedures of the exercise are attached in the following archives.
Explanation
You will find the procedures, formulas or necessary explanations in the archive attached below. If you have any question ask and I will aclare your doubts kindly.
In a sealed bidding, bidders have no opportunity to discuss/negotiate. They just present an offer adjusted to the terms of the requirer of the good or service that is submitted to bidding.