Creating a sheet for resourcing tasks based on staff availability

[ReservoirDodds]

I am often the "go-to" person for Excel at work, however, I cannot for the life of me figure this one out.

Let's say my company is a bakery. I have 6 teams working for me, and I know I want to make 25 bagels, 64 bread buns, 31 croissants and 17 cakes on Monday and other iterations of this throughout the week.
Currently, I have a sheet where I enter the number of hours I have available for working, and then I turn this into a % so I know that Team 3 have more people available to work this week, therefore they should have more of the tasks than the other teams. My issue is when this allocation isn't a whole number, the sheet displays incorrect numbers due to it rounding up / down and I need to see it as whole numbers, not 2.2 bagels that day for example. Obviously, I'm aware this is happening, but this allocation sheet is sent to the managers of these 6 teams for them to try and ensure their team hits the required plan, and I don't want to have to spend time manually amending these figures else it defeats the purpose of the task allocation sheet, which saves an awful lot of time.
As it stands, say Team 1 account for 20% of the total hours on Monday, they would get 20% of the tasks. So in real terms, that's 5 bagels, 12.8 bread buns, 6.2 croissants and 3.4(...) cakes. Whilst rounding obviously takes a lot of the error out as one team will be rounded down when one is rounded up, it doesn't solve all my problems. When there's an instance of there being 1 task to be allocated across all teams, it shows as 0 for all teams as it's a low figure, I want this to come through and for one of the teams to show 1 next to their allocation. I hope this makes sense, I've copied the sheet below to view.

Looking at my example, on Monday the bagels allocation does technically add to the 31 expected as the cells are decimal values, however adding the numbers it is displaying together makes 32, meaning one team will make an extra bagel we didn't want because the managers just look at the figures next to their team.

They're currently on two sheets within the workbook, called "Data" and "Allocation".

Any help would be greatly appreciated

Task Allocation Example.xlsx
	A	B	C	D	E	F	G
1		Monday	Tuesday	Wednesday	Thursday	Friday
2	Team 1	21.1%	12.6%	16.7%	18.0%	19.9%
3	Team 2	15.6%	15.6%	22.2%	9.4%	11.7%
4	Team 3	21.7%	25.2%	14.0%	25.0%	7.8%
5	Team 4	13.1%	8.5%	9.7%	14.1%	16.5%
6	Team 5	10.6%	14.1%	24.9%	18.4%	20.3%
7	Team 6	18.1%	24.1%	12.5%	15.2%	23.8%
8
9
10		Monday	Tuesday	Wednesday	Thursday	Friday
11	Team 1	76	34	43	46	46	245
12	Team 2	56	42	57	24	27	206
13	Team 3	78	68	36	64	18	264
14	Team 4	47	23	25	36	38	169
15	Team 5	38	38	64	47	47	234
16	Team 6	65	65	32	39	55	256
17		360	270	257	256	231	1374
18
19
20		Monday	Tuesday	Wednesday	Thursday	Friday
21	Bagels	31	25	65	35	25	181
22	Bread Buns	41	36	32	63	41	213
23	Croissants	53	42	67	47	15	224
24	Cakes	46	15	34	63	38	196
25
26
Data

Cell Formulas
Range	Formula
B2:F2,C3:F7	B2	=B11/B$17
B3:B7	B3	=B12/$B$17
G11:G16,G21:G24	G11	=SUM(B11:F11)
B17:G17	B17	=SUM(B11:B16)

Task Allocation Example.xlsx
	A	B	C	D	E	F
1	Monday
2		Bagels	Bread Buns	Croissants	Cakes
3	Team 1	7	5	9	8
4	Team 2	5	6	12	4
5	Team 3	7	10	7	12
6	Team 4	4	3	5	6
7	Team 5	3	6	13	8
8	Team 6	6	10	7	7
9
10	Tuesday
11		Bagels	Bread Buns	Croissants	Cakes
12	Team 1	3	5	5	2
13	Team 2	4	6	7	2
14	Team 3	6	9	11	4
15	Team 4	2	3	4	1
16	Team 5	4	5	6	2
17	Team 6	6	9	10	4
18
19	Wednesday
20		Bagels	Bread Buns	Croissants	Cakes
21	Team 1	11	5	11	6
22	Team 2	14	7	15	8
23	Team 3	9	4	9	5
24	Team 4	6	3	7	3
25	Team 5	16	8	17	8
26	Team 6	8	4	8	4
27
28	Thursday
29		Bagels	Bread Buns	Croissants	Cakes
30	Team 1	6	11	8	11
31	Team 2	3	6	4	6
32	Team 3	9	16	12	16
33	Team 4	5	9	7	9
34	Team 5	6	12	9	12
35	Team 6	5	10	7	10
36
37	Friday
38		Bagels	Bread Buns	Croissants	Cakes
39	Team 1	5	8	3	8
40	Team 2	3	5	2	4
41	Team 3	2	3	1	3
42	Team 4	4	7	2	6
43	Team 5	5	8	3	8
44	Team 6	6	10	4	9
45
Allocation

Cell Formulas
Range	Formula
B2	B2	=Data!$A21
C2	C2	=Data!$A22
D2	D2	=Data!$A23
E2	E2	=Data!$A24
A3:A8	A3	=Data!A2
B3	B3	=Data!B2*Data!B21
C3:C8	C3	=Data!C2*Data!$B$22
D3:D8	D3	=Data!D2*Data!$B$23
E3:E8	E3	=Data!E2*Data!$B$24
B4	B4	=Data!B3*Data!B21
B5	B5	=Data!B4*Data!B21
B6	B6	=Data!B5*Data!B21
B7	B7	=Data!B6*Data!B21
B8	B8	=Data!B7*Data!B21
B11	B11	=Data!$A21
C11	C11	=Data!$A22
D11	D11	=Data!$A23
E11	E11	=Data!$A24
A12:A17	A12	=Data!A2
B12:B17	B12	=Data!C2*Data!$C$21
C12:C17	C12	=Data!C2*Data!$C$22
D12:D17	D12	=Data!C2*Data!$C$23
E12:E17	E12	=Data!C2*Data!$C$24
B20	B20	=Data!$A21
C20	C20	=Data!$A22
D20	D20	=Data!$A23
E20	E20	=Data!$A24
A21:A26	A21	=Data!A2
B21:B26	B21	=Data!D2*Data!$D$21
C21:C26	C21	=Data!D2*Data!$D$22
D21:D26	D21	=Data!$D2*Data!$D$23
E21:E26	E21	=Data!$D2*Data!$D$24
B29	B29	=Data!$A21
C29	C29	=Data!$A22
D29	D29	=Data!$A23
E29	E29	=Data!$A24
A30:A35	A30	=Data!A2
B30:B35	B30	=Data!$E2*Data!$E$21
C30:C35	C30	=Data!$E2*Data!$E$22
D30:D35	D30	=Data!$E2*Data!$E$23
E30:E35	E30	=Data!$E2*Data!$E$24
B38	B38	=Data!$A21
C38	C38	=Data!$A22
D38	D38	=Data!$A23
E38	E38	=Data!$A24
A39:A44	A39	=Data!A2
B39:B44	B39	=Data!$F2*Data!$F$21
C39:C44	C39	=Data!$F2*Data!$F$22
D39:D44	D39	=Data!$F2*Data!$F$23
E39:E44	E39	=Data!$F2*Data!$F$24