Excel 2013 Formula help required.

It is with great annoyance that I admit defeat, and seek assistance with this piece of work.

I am creating a log of repairs for laptop devices that will be held centrally. There are 5 different models of laptop used each with differing prices for repairs associated to that device.

In the attached file I want to be able to do the following:

- When the model number is entered in Column A, I want the spreadsheet only to look at repair values corresponding to that device in rows 2-6.
- After the spreadsheet has established which row it is looking at for repair values, I want the user to be able to enter a Y if that part is required, and if left blank it is not included within the calculation. for example: Keyboard and base are required, so Y would be entered in this field to return the associated repair cost.
- This would then be calculated in the "Total" column as the repair cost for said device.

Is this at all possible?

Any help would be greatly appreciated! I've spent a few hours trying to establish which formulas I require without luck!!
Repair log.xlsx