Pivot table merging 2 tables field values (most efficient solution)

I need to combine the data of 2 tables but they are not very similar, attached is the document in question.

Basically, I have a 9 classes that use various items (some items used in multiple classes at varying quantities needed), and I have a schedule for when I need them. I don't know how to merge them, I tried powerpivot but I ran into 2 problems

1) power pivot wont let me show sum of QTY, only count (i dont have this problem with creating pivot straight from item list, but i do with power pivot)
2) TAB "Merge Question", I know the answer to my problem is by merging the 2 columns (powerpivot value fields) by each other. How can I do this without making a huge raw data list... essentially so that anyone that edits/makes a new entry into "Item List" or "Date" refreshes data onto pivot

Hi

1) The Qty field in the Item List table contains several entries of "As Needed". Hence this field cannot be considered numeric within the Data Model and thus SUM is not an option for non-numeric fields. The easiest solution would be to remove those text entries. Failing that, you could create a measure which excludes them.

2) I don't understand your second question. Perhaps you could give some practical examples of what you would like to see with reference to your workbook.

Regards

See updated document... basically if I created them as seperate pivots, I could see by columns (year-month) the date they are scheduled for, or the QTY needed per part, merging these 2 columns is the task (and this seems very hard to do to raw data because 1 date belongs to a class with multiple parts, and vice versa)

Remove those text entries in the Qty field, as I said, then add a new measure:

=SUMX('Item List','Item List'[Qty]*[Count of Schedule Date])

and use that in the Pivot Table Values field.

Regards