formula help for staffing issue

[webejamn]

i have attached the the work ive gathered for my staffing requirements, it seems like i should be able to mathematically figure this out but i just cant make it click. i need to staff 55 people, which means i have 275 shifts to fill, and 385 options. and i have my staffing estimates. i know i cant meet 100% but i just cant figure out what formula to give me how many people i should put on what shifts


thanks for the help