I need help with this. Could you please do an Excel and show the formulas and how you did it

A company goes public by using an auction. The bids are contained in the table below. The firm wants to sel 10 milion shares: In a troditional offering, describe which bidders would recelve shares, the price they would pay, and how much of their orders would be filled. Enter your answers for the number of recelve shares in millions, For example, an answer of 1.2 million should be entered as 1.2 , not 1.200,000. Round the monetary values to the nearest dollar and answers for the number of receive shares to one decimal place. If the investor wouldn't receive shares, enter " 0 " in both columns