the basic solver.

linsuant 

I use named formulas within 365.  The total profit and calculated resources consumed were calculated using

totalProfit
= SUM(quantity*profit)

consumed
= BYROW(resources, LAMBDA(r, SUM(r*quantity)))

Solver optimised the profit with the settings