How to calculate lamps per fixture based on lamp type & lamps per fixture?

MATH PROBLEM:

I have 1000 light bulbs.

I need to put all of them into light fixtures that hold the following number of lights:
8 lights per fixture
4 lights per fixture
2 lights per fixture
1 light per fixture

I need to know how to allot the lights to the fixtures when:
60% of the fixtures are 8-lights
14% of the fixtures are 4-lights
14% of the fixtures are 2-lights
12% of the fixtures are 1-light

I cannot wrap my mind around how to write a formula to accomplish this. I will be using this formula on a list of 40 different light bulb totals. Example: "John has 1000 lights, Mary has 3115 lights, Jimmy has 5900 lights, how many fixtures of each type will they each end up with?"

Here's a file that may help:
FORUMLA FOR LAMPS PER FIXTURE.xlsx

Here is a solution but your percentages do not yield a whole number of any type of fixture. How do you want to resolve that?


P.S. I see that you have commented that your thread title was "not perfect"; to be clear, it gave no insight at all to your question and that's why I flagged it.

This version rounds each number of fixtures to a whole number and then uses the 1-lamp fixtures to resolve the rounding errors.