📊 Estoque ao longo do tempo para: Surgical Mask
plot_item_stock <- function(item_name) {
item_df <- df %>%
filter(Item_Name == item_name) %>%
arrange(Date)
# Obter o último valor de cada parâmetro (mais atual)
last_entry <- tail(item_df, 1)
min_required <- last_entry$Min_Required
max_capacity <- last_entry$Max_Capacity
lead_time <- last_entry$Restock_Lead_Time
avg_usage <- last_entry$Avg_Usage_Per_Day
current_stock <- last_entry$Current_Stock
last_date <- last_entry$Date
# Projeção para 30 dias a partir da última data
proj_dates <- seq(from = last_date, by = "day", length.out = 30)
projected_stock <- current_stock - avg_usage * (0:(length(proj_dates) - 1))
# Data de ruptura prevista (quando estoque projetado cruza o mínimo)
depletion_index <- which(projected_stock <= min_required)
depletion_date <- if (length(depletion_index) > 0) proj_dates[depletion_index[1]] else NA
ggplot(item_df, aes(x = Date, y = Current_Stock)) +
geom_line(color = "blue", size = 1.2) +
geom_hline(yintercept = min_required, linetype = "dashed", color = "red") +
geom_hline(yintercept = max_capacity, linetype = "dashed", color = "darkgreen") +
geom_line(
data = data.frame(Date = proj_dates, Projected = projected_stock),
aes(x = Date, y = Projected),
color = "orange", linetype = "dotdash"
) +
{ if (!is.na(depletion_date)) geom_vline(xintercept = depletion_date, color = "red", linetype = "dotted") } +
geom_vline(xintercept = last_date + lead_time, color = "purple", linetype = "longdash") +
labs(
title = paste("Estoque e Projeção para:", item_name),
y = "Estoque",
x = "Data"
) +
theme_minimal()
}
plot_item_stock(params$item_nome)
## Warning: Using `size` aesthetic for lines was deprecated in ggplot2 3.4.0.
## ℹ Please use `linewidth` instead.
## This warning is displayed once every 8 hours.
## Call `lifecycle::last_lifecycle_warnings()` to see where this warning was
## generated.

⚠️ Risco de ruptura de estoque
df %>%
group_by(Item_Name) %>%
summarise(
Days_To_Deplete = min((Current_Stock - Min_Required) / Avg_Usage_Per_Day),
Lead_Time = max(Restock_Lead_Time),
Risk = Days_To_Deplete < Lead_Time
) %>%
filter(Risk == TRUE) %>%
kable()
| Gloves |
-5.861538 |
29 |
TRUE |
| IV Drip |
-17.360000 |
29 |
TRUE |
| Surgical Mask |
-9.000000 |
29 |
TRUE |
| Ventilator |
-85.833333 |
29 |
TRUE |
| X-ray Machine |
-1.693548 |
29 |
TRUE |
🛡 Estoque de Segurança Sugerido
df %>%
mutate(Safety_Stock = round(Avg_Usage_Per_Day * Restock_Lead_Time * 0.5, 1)) %>%
select(Item_Name, Avg_Usage_Per_Day, Restock_Lead_Time, Safety_Stock) %>%
distinct() %>%
kable()
| Ventilator |
108 |
17 |
918.0 |
| Ventilator |
55 |
12 |
330.0 |
| Surgical Mask |
470 |
6 |
1410.0 |
| Surgical Mask |
207 |
15 |
1552.5 |
| IV Drip |
158 |
12 |
948.0 |
| IV Drip |
386 |
26 |
5018.0 |
| IV Drip |
207 |
24 |
2484.0 |
| IV Drip |
257 |
11 |
1413.5 |
| Ventilator |
16 |
20 |
160.0 |
| Gloves |
418 |
5 |
1045.0 |
| Surgical Mask |
161 |
21 |
1690.5 |
| Surgical Mask |
254 |
8 |
1016.0 |
| X-ray Machine |
244 |
2 |
244.0 |
| Gloves |
230 |
24 |
2760.0 |
| Gloves |
198 |
24 |
2376.0 |
| Surgical Mask |
415 |
25 |
5187.5 |
| Gloves |
106 |
26 |
1378.0 |
| X-ray Machine |
176 |
6 |
528.0 |
| Ventilator |
499 |
23 |
5738.5 |
| IV Drip |
59 |
18 |
531.0 |
| X-ray Machine |
458 |
17 |
3893.0 |
| IV Drip |
374 |
17 |
3179.0 |
| Surgical Mask |
392 |
1 |
196.0 |
| Ventilator |
415 |
19 |
3942.5 |
| X-ray Machine |
342 |
4 |
684.0 |
| Gloves |
31 |
2 |
31.0 |
| Ventilator |
426 |
7 |
1491.0 |
| X-ray Machine |
9 |
21 |
94.5 |
| Ventilator |
66 |
1 |
33.0 |
| Surgical Mask |
110 |
9 |
495.0 |
| Gloves |
470 |
25 |
5875.0 |
| IV Drip |
265 |
7 |
927.5 |
| IV Drip |
250 |
12 |
1500.0 |
| IV Drip |
238 |
5 |
595.0 |
| X-ray Machine |
50 |
22 |
550.0 |
| Ventilator |
373 |
6 |
1119.0 |
| Gloves |
65 |
8 |
260.0 |
| Gloves |
92 |
24 |
1104.0 |
| X-ray Machine |
51 |
26 |
663.0 |
| Gloves |
177 |
20 |
1770.0 |
| Gloves |
474 |
11 |
2607.0 |
| Ventilator |
158 |
6 |
474.0 |
| Ventilator |
72 |
6 |
216.0 |
| Ventilator |
27 |
5 |
67.5 |
| X-ray Machine |
480 |
29 |
6960.0 |
| X-ray Machine |
399 |
11 |
2194.5 |
| X-ray Machine |
378 |
26 |
4914.0 |
| Gloves |
276 |
13 |
1794.0 |
| IV Drip |
127 |
17 |
1079.5 |
| Gloves |
137 |
26 |
1781.0 |
| Ventilator |
40 |
6 |
120.0 |
| IV Drip |
414 |
14 |
2898.0 |
| Surgical Mask |
280 |
12 |
1680.0 |
| IV Drip |
334 |
23 |
3841.0 |
| Ventilator |
41 |
11 |
225.5 |
| Ventilator |
130 |
8 |
520.0 |
| Ventilator |
346 |
1 |
173.0 |
| Ventilator |
473 |
25 |
5912.5 |
| Surgical Mask |
287 |
17 |
2439.5 |
| IV Drip |
426 |
28 |
5964.0 |
| Surgical Mask |
337 |
24 |
4044.0 |
| Gloves |
381 |
25 |
4762.5 |
| IV Drip |
319 |
29 |
4625.5 |
| Gloves |
332 |
25 |
4150.0 |
| Gloves |
360 |
26 |
4680.0 |
| Gloves |
328 |
21 |
3444.0 |
| Ventilator |
103 |
15 |
772.5 |
| IV Drip |
470 |
1 |
235.0 |
| X-ray Machine |
473 |
15 |
3547.5 |
| IV Drip |
294 |
4 |
588.0 |
| Ventilator |
300 |
23 |
3450.0 |
| IV Drip |
444 |
16 |
3552.0 |
| Ventilator |
165 |
9 |
742.5 |
| IV Drip |
161 |
4 |
322.0 |
| IV Drip |
330 |
5 |
825.0 |
| Gloves |
242 |
21 |
2541.0 |
| Surgical Mask |
256 |
15 |
1920.0 |
| IV Drip |
489 |
29 |
7090.5 |
| X-ray Machine |
401 |
5 |
1002.5 |
| Surgical Mask |
420 |
28 |
5880.0 |
| X-ray Machine |
248 |
18 |
2232.0 |
| IV Drip |
388 |
28 |
5432.0 |
| Ventilator |
40 |
20 |
400.0 |
| IV Drip |
422 |
25 |
5275.0 |
| Gloves |
260 |
25 |
3250.0 |
| Ventilator |
425 |
4 |
850.0 |
| X-ray Machine |
59 |
19 |
560.5 |
| IV Drip |
484 |
2 |
484.0 |
| IV Drip |
130 |
13 |
845.0 |
| Ventilator |
4 |
21 |
42.0 |
| IV Drip |
12 |
8 |
48.0 |
| Surgical Mask |
388 |
23 |
4462.0 |
| X-ray Machine |
111 |
13 |
721.5 |
| IV Drip |
188 |
25 |
2350.0 |
| IV Drip |
141 |
16 |
1128.0 |
| Ventilator |
353 |
1 |
176.5 |
| Gloves |
424 |
2 |
424.0 |
| X-ray Machine |
307 |
14 |
2149.0 |
| Surgical Mask |
257 |
2 |
257.0 |
| Surgical Mask |
55 |
4 |
110.0 |
| Ventilator |
55 |
8 |
220.0 |
| Surgical Mask |
112 |
25 |
1400.0 |
| Gloves |
344 |
5 |
860.0 |
| IV Drip |
200 |
7 |
700.0 |
| X-ray Machine |
188 |
28 |
2632.0 |
| IV Drip |
322 |
27 |
4347.0 |
| Ventilator |
483 |
3 |
724.5 |
| IV Drip |
270 |
14 |
1890.0 |
| Gloves |
441 |
7 |
1543.5 |
| Surgical Mask |
31 |
16 |
248.0 |
| X-ray Machine |
342 |
26 |
4446.0 |
| Gloves |
82 |
17 |
697.0 |
| Ventilator |
152 |
17 |
1292.0 |
| X-ray Machine |
420 |
19 |
3990.0 |
| IV Drip |
418 |
10 |
2090.0 |
| Ventilator |
391 |
26 |
5083.0 |
| IV Drip |
25 |
1 |
12.5 |
| Gloves |
35 |
16 |
280.0 |
| Gloves |
105 |
22 |
1155.0 |
| Ventilator |
442 |
17 |
3757.0 |
| Surgical Mask |
359 |
11 |
1974.5 |
| Ventilator |
458 |
5 |
1145.0 |
| Surgical Mask |
153 |
8 |
612.0 |
| Ventilator |
222 |
24 |
2664.0 |
| Ventilator |
6 |
18 |
54.0 |
| X-ray Machine |
241 |
9 |
1084.5 |
| Surgical Mask |
433 |
7 |
1515.5 |
| Surgical Mask |
410 |
14 |
2870.0 |
| Gloves |
453 |
6 |
1359.0 |
| IV Drip |
239 |
18 |
2151.0 |
| Gloves |
39 |
6 |
117.0 |
| Surgical Mask |
385 |
5 |
962.5 |
| X-ray Machine |
316 |
3 |
474.0 |
| Surgical Mask |
207 |
23 |
2380.5 |
| IV Drip |
74 |
29 |
1073.0 |
| IV Drip |
229 |
27 |
3091.5 |
| Ventilator |
496 |
18 |
4464.0 |
| X-ray Machine |
435 |
28 |
6090.0 |
| Gloves |
29 |
2 |
29.0 |
| X-ray Machine |
400 |
28 |
5600.0 |
| Ventilator |
195 |
8 |
780.0 |
| Surgical Mask |
37 |
14 |
259.0 |
| IV Drip |
136 |
26 |
1768.0 |
| Surgical Mask |
466 |
6 |
1398.0 |
| Surgical Mask |
160 |
5 |
400.0 |
| Ventilator |
172 |
27 |
2322.0 |
| Gloves |
42 |
18 |
378.0 |
| Surgical Mask |
464 |
16 |
3712.0 |
| IV Drip |
285 |
22 |
3135.0 |
| IV Drip |
383 |
8 |
1532.0 |
| Gloves |
183 |
9 |
823.5 |
| Gloves |
309 |
19 |
2935.5 |
| Ventilator |
119 |
21 |
1249.5 |
| X-ray Machine |
171 |
26 |
2223.0 |
| IV Drip |
249 |
8 |
996.0 |
| Surgical Mask |
416 |
3 |
624.0 |
| Ventilator |
87 |
9 |
391.5 |
| Gloves |
58 |
19 |
551.0 |
| Surgical Mask |
499 |
18 |
4491.0 |
| X-ray Machine |
24 |
9 |
108.0 |
| Gloves |
125 |
8 |
500.0 |
| X-ray Machine |
325 |
2 |
325.0 |
| X-ray Machine |
65 |
4 |
130.0 |
| IV Drip |
402 |
27 |
5427.0 |
| IV Drip |
199 |
22 |
2189.0 |
| X-ray Machine |
69 |
16 |
552.0 |
| IV Drip |
204 |
25 |
2550.0 |
| Gloves |
481 |
18 |
4329.0 |
| X-ray Machine |
209 |
20 |
2090.0 |
| X-ray Machine |
387 |
26 |
5031.0 |
| Ventilator |
203 |
2 |
203.0 |
| Ventilator |
424 |
11 |
2332.0 |
| Ventilator |
167 |
19 |
1586.5 |
| Ventilator |
439 |
8 |
1756.0 |
| Surgical Mask |
253 |
12 |
1518.0 |
| Ventilator |
104 |
6 |
312.0 |
| Gloves |
248 |
27 |
3348.0 |
| Surgical Mask |
129 |
9 |
580.5 |
| Gloves |
266 |
6 |
798.0 |
| Ventilator |
76 |
20 |
760.0 |
| X-ray Machine |
429 |
3 |
643.5 |
| Surgical Mask |
53 |
22 |
583.0 |
| X-ray Machine |
210 |
5 |
525.0 |
| Gloves |
357 |
25 |
4462.5 |
| Gloves |
362 |
2 |
362.0 |
| Surgical Mask |
176 |
1 |
88.0 |
| Gloves |
198 |
25 |
2475.0 |
| Surgical Mask |
490 |
14 |
3430.0 |
| Gloves |
49 |
16 |
392.0 |
| X-ray Machine |
423 |
25 |
5287.5 |
| IV Drip |
37 |
5 |
92.5 |
| Ventilator |
389 |
1 |
194.5 |
| Ventilator |
252 |
5 |
630.0 |
| IV Drip |
498 |
29 |
7221.0 |
| IV Drip |
204 |
19 |
1938.0 |
| Surgical Mask |
40 |
24 |
480.0 |
| Gloves |
222 |
21 |
2331.0 |
| X-ray Machine |
236 |
5 |
590.0 |
| Ventilator |
191 |
6 |
573.0 |
| IV Drip |
174 |
15 |
1305.0 |
| IV Drip |
460 |
23 |
5290.0 |
| IV Drip |
299 |
16 |
2392.0 |
| Gloves |
161 |
20 |
1610.0 |
| X-ray Machine |
386 |
13 |
2509.0 |
| IV Drip |
237 |
8 |
948.0 |
| X-ray Machine |
176 |
1 |
88.0 |
| Ventilator |
163 |
26 |
2119.0 |
| Surgical Mask |
299 |
21 |
3139.5 |
| Ventilator |
365 |
27 |
4927.5 |
| Surgical Mask |
203 |
6 |
609.0 |
| IV Drip |
427 |
11 |
2348.5 |
| Gloves |
253 |
25 |
3162.5 |
| Surgical Mask |
233 |
12 |
1398.0 |
| Ventilator |
47 |
22 |
517.0 |
| Gloves |
488 |
29 |
7076.0 |
| Ventilator |
464 |
7 |
1624.0 |
| IV Drip |
110 |
2 |
110.0 |
| Ventilator |
219 |
21 |
2299.5 |
| IV Drip |
106 |
14 |
742.0 |
| Surgical Mask |
41 |
16 |
328.0 |
| Gloves |
109 |
16 |
872.0 |
| X-ray Machine |
369 |
12 |
2214.0 |
| Gloves |
337 |
22 |
3707.0 |
| X-ray Machine |
428 |
4 |
856.0 |
| Surgical Mask |
349 |
10 |
1745.0 |
| Ventilator |
449 |
23 |
5163.5 |
| IV Drip |
64 |
25 |
800.0 |
| IV Drip |
45 |
24 |
540.0 |
| IV Drip |
382 |
5 |
955.0 |
| Surgical Mask |
131 |
29 |
1899.5 |
| Surgical Mask |
23 |
27 |
310.5 |
| X-ray Machine |
381 |
24 |
4572.0 |
| Gloves |
409 |
25 |
5112.5 |
| Gloves |
429 |
18 |
3861.0 |
| Ventilator |
340 |
21 |
3570.0 |
| X-ray Machine |
223 |
6 |
669.0 |
| Surgical Mask |
462 |
22 |
5082.0 |
| Surgical Mask |
392 |
15 |
2940.0 |
| IV Drip |
212 |
20 |
2120.0 |
| X-ray Machine |
228 |
9 |
1026.0 |
| X-ray Machine |
310 |
4 |
620.0 |
| Surgical Mask |
319 |
6 |
957.0 |
| X-ray Machine |
414 |
4 |
828.0 |
| IV Drip |
213 |
21 |
2236.5 |
| IV Drip |
9 |
7 |
31.5 |
| Surgical Mask |
459 |
2 |
459.0 |
| Surgical Mask |
298 |
26 |
3874.0 |
| X-ray Machine |
419 |
10 |
2095.0 |
| X-ray Machine |
175 |
13 |
1137.5 |
| Gloves |
446 |
24 |
5352.0 |
| X-ray Machine |
204 |
23 |
2346.0 |
| X-ray Machine |
254 |
6 |
762.0 |
| Ventilator |
201 |
3 |
301.5 |
| Surgical Mask |
118 |
26 |
1534.0 |
| X-ray Machine |
312 |
28 |
4368.0 |
| Ventilator |
470 |
15 |
3525.0 |
| X-ray Machine |
245 |
20 |
2450.0 |
| Surgical Mask |
69 |
6 |
207.0 |
| Gloves |
304 |
27 |
4104.0 |
| IV Drip |
8 |
25 |
100.0 |
| Surgical Mask |
249 |
29 |
3610.5 |
| Surgical Mask |
313 |
29 |
4538.5 |
| Ventilator |
86 |
4 |
172.0 |
| Ventilator |
87 |
16 |
696.0 |
| Ventilator |
327 |
2 |
327.0 |
| Gloves |
20 |
26 |
260.0 |
| Ventilator |
172 |
23 |
1978.0 |
| Surgical Mask |
327 |
11 |
1798.5 |
| Ventilator |
353 |
8 |
1412.0 |
| X-ray Machine |
358 |
9 |
1611.0 |
| X-ray Machine |
343 |
18 |
3087.0 |
| IV Drip |
362 |
26 |
4706.0 |
| X-ray Machine |
278 |
8 |
1112.0 |
| IV Drip |
245 |
20 |
2450.0 |
| X-ray Machine |
140 |
8 |
560.0 |
| Gloves |
172 |
10 |
860.0 |
| IV Drip |
68 |
21 |
714.0 |
| X-ray Machine |
225 |
2 |
225.0 |
| IV Drip |
414 |
18 |
3726.0 |
| IV Drip |
406 |
25 |
5075.0 |
| X-ray Machine |
210 |
29 |
3045.0 |
| Surgical Mask |
326 |
11 |
1793.0 |
| Ventilator |
240 |
13 |
1560.0 |
| IV Drip |
476 |
16 |
3808.0 |
| IV Drip |
258 |
3 |
387.0 |
| IV Drip |
162 |
1 |
81.0 |
| Ventilator |
425 |
25 |
5312.5 |
| IV Drip |
364 |
22 |
4004.0 |
| IV Drip |
104 |
6 |
312.0 |
| X-ray Machine |
250 |
20 |
2500.0 |
| Surgical Mask |
172 |
1 |
86.0 |
| Gloves |
52 |
18 |
468.0 |
| Gloves |
486 |
24 |
5832.0 |
| Ventilator |
351 |
15 |
2632.5 |
| Gloves |
467 |
21 |
4903.5 |
| Surgical Mask |
439 |
27 |
5926.5 |
| Gloves |
464 |
5 |
1160.0 |
| Surgical Mask |
253 |
5 |
632.5 |
| Surgical Mask |
308 |
13 |
2002.0 |
| X-ray Machine |
430 |
13 |
2795.0 |
| Gloves |
233 |
5 |
582.5 |
| IV Drip |
350 |
16 |
2800.0 |
| Ventilator |
133 |
6 |
399.0 |
| IV Drip |
185 |
23 |
2127.5 |
| Gloves |
433 |
25 |
5412.5 |
| Gloves |
377 |
14 |
2639.0 |
| IV Drip |
491 |
21 |
5155.5 |
| X-ray Machine |
405 |
21 |
4252.5 |
| Gloves |
273 |
27 |
3685.5 |
| X-ray Machine |
54 |
29 |
783.0 |
| Ventilator |
470 |
8 |
1880.0 |
| Gloves |
195 |
15 |
1462.5 |
| IV Drip |
405 |
24 |
4860.0 |
| X-ray Machine |
494 |
21 |
5187.0 |
| Ventilator |
441 |
6 |
1323.0 |
| Surgical Mask |
409 |
8 |
1636.0 |
| Ventilator |
300 |
5 |
750.0 |
| X-ray Machine |
341 |
16 |
2728.0 |
| Gloves |
238 |
10 |
1190.0 |
| Gloves |
192 |
6 |
576.0 |
| Surgical Mask |
16 |
26 |
208.0 |
| X-ray Machine |
354 |
2 |
354.0 |
| Gloves |
281 |
21 |
2950.5 |
| Gloves |
345 |
1 |
172.5 |
| X-ray Machine |
361 |
2 |
361.0 |
| Ventilator |
92 |
20 |
920.0 |
| IV Drip |
318 |
10 |
1590.0 |
| Ventilator |
132 |
3 |
198.0 |
| X-ray Machine |
404 |
17 |
3434.0 |
| Ventilator |
141 |
24 |
1692.0 |
| Gloves |
115 |
27 |
1552.5 |
| X-ray Machine |
301 |
19 |
2859.5 |
| Gloves |
331 |
26 |
4303.0 |
| Gloves |
394 |
27 |
5319.0 |
| Gloves |
192 |
11 |
1056.0 |
| Ventilator |
477 |
17 |
4054.5 |
| IV Drip |
374 |
18 |
3366.0 |
| Surgical Mask |
175 |
9 |
787.5 |
| IV Drip |
224 |
29 |
3248.0 |
| Surgical Mask |
472 |
18 |
4248.0 |
| X-ray Machine |
398 |
27 |
5373.0 |
| IV Drip |
70 |
18 |
630.0 |
| Surgical Mask |
174 |
6 |
522.0 |
| Gloves |
489 |
10 |
2445.0 |
| X-ray Machine |
136 |
7 |
476.0 |
| IV Drip |
298 |
13 |
1937.0 |
| Ventilator |
111 |
7 |
388.5 |
| X-ray Machine |
401 |
16 |
3208.0 |
| Gloves |
179 |
25 |
2237.5 |
| Gloves |
296 |
2 |
296.0 |
| Gloves |
36 |
15 |
270.0 |
| Surgical Mask |
363 |
6 |
1089.0 |
| IV Drip |
285 |
10 |
1425.0 |
| X-ray Machine |
118 |
6 |
354.0 |
| IV Drip |
82 |
7 |
287.0 |
| IV Drip |
38 |
12 |
228.0 |
| Surgical Mask |
2 |
26 |
26.0 |
| Surgical Mask |
466 |
17 |
3961.0 |
| Gloves |
287 |
20 |
2870.0 |
| IV Drip |
35 |
27 |
472.5 |
| Surgical Mask |
373 |
24 |
4476.0 |
| Gloves |
4 |
19 |
38.0 |
| X-ray Machine |
418 |
26 |
5434.0 |
| Surgical Mask |
172 |
17 |
1462.0 |
| Surgical Mask |
346 |
10 |
1730.0 |
| X-ray Machine |
2 |
11 |
11.0 |
| X-ray Machine |
355 |
10 |
1775.0 |
| Surgical Mask |
441 |
10 |
2205.0 |
| X-ray Machine |
306 |
8 |
1224.0 |
| X-ray Machine |
104 |
27 |
1404.0 |
| Gloves |
297 |
24 |
3564.0 |
| Surgical Mask |
83 |
23 |
954.5 |
| X-ray Machine |
42 |
11 |
231.0 |
| Gloves |
311 |
12 |
1866.0 |
| Surgical Mask |
470 |
8 |
1880.0 |
| Surgical Mask |
176 |
28 |
2464.0 |
| Surgical Mask |
93 |
1 |
46.5 |
| X-ray Machine |
384 |
23 |
4416.0 |
| X-ray Machine |
450 |
1 |
225.0 |
| IV Drip |
298 |
3 |
447.0 |
| Gloves |
295 |
23 |
3392.5 |
| IV Drip |
397 |
16 |
3176.0 |
| Gloves |
208 |
9 |
936.0 |
| Ventilator |
413 |
16 |
3304.0 |
| IV Drip |
282 |
25 |
3525.0 |
| Surgical Mask |
252 |
23 |
2898.0 |
| Ventilator |
243 |
20 |
2430.0 |
| Ventilator |
54 |
15 |
405.0 |
| Ventilator |
471 |
3 |
706.5 |
| Gloves |
192 |
4 |
384.0 |
| X-ray Machine |
348 |
2 |
348.0 |
| X-ray Machine |
78 |
11 |
429.0 |
| Ventilator |
162 |
5 |
405.0 |
| X-ray Machine |
463 |
1 |
231.5 |
| Surgical Mask |
374 |
25 |
4675.0 |
| X-ray Machine |
393 |
19 |
3733.5 |
| Gloves |
197 |
7 |
689.5 |
| Ventilator |
47 |
24 |
564.0 |
| IV Drip |
119 |
13 |
773.5 |
| Surgical Mask |
342 |
16 |
2736.0 |
| IV Drip |
174 |
27 |
2349.0 |
| Ventilator |
477 |
24 |
5724.0 |
| Ventilator |
279 |
25 |
3487.5 |
| IV Drip |
271 |
17 |
2303.5 |
| Ventilator |
257 |
19 |
2441.5 |
| Ventilator |
435 |
14 |
3045.0 |
| Ventilator |
486 |
2 |
486.0 |
| X-ray Machine |
183 |
23 |
2104.5 |
| X-ray Machine |
179 |
4 |
358.0 |
| IV Drip |
290 |
7 |
1015.0 |
| Surgical Mask |
245 |
8 |
980.0 |
| IV Drip |
41 |
26 |
533.0 |
| IV Drip |
169 |
21 |
1774.5 |
| Gloves |
244 |
17 |
2074.0 |
| X-ray Machine |
392 |
25 |
4900.0 |
| Surgical Mask |
411 |
3 |
616.5 |
| Surgical Mask |
158 |
29 |
2291.0 |
| Gloves |
435 |
11 |
2392.5 |
| Ventilator |
186 |
20 |
1860.0 |
| IV Drip |
18 |
3 |
27.0 |
| IV Drip |
127 |
25 |
1587.5 |
| Surgical Mask |
267 |
1 |
133.5 |
| IV Drip |
300 |
7 |
1050.0 |
| Surgical Mask |
447 |
14 |
3129.0 |
| X-ray Machine |
226 |
7 |
791.0 |
| X-ray Machine |
450 |
26 |
5850.0 |
| Surgical Mask |
231 |
28 |
3234.0 |
| Gloves |
382 |
16 |
3056.0 |
| IV Drip |
276 |
6 |
828.0 |
| Surgical Mask |
222 |
14 |
1554.0 |
| Gloves |
391 |
10 |
1955.0 |
| X-ray Machine |
6 |
24 |
72.0 |
| IV Drip |
197 |
20 |
1970.0 |
| IV Drip |
451 |
23 |
5186.5 |
| X-ray Machine |
248 |
25 |
3100.0 |
| Ventilator |
425 |
14 |
2975.0 |
| Surgical Mask |
489 |
22 |
5379.0 |
| Gloves |
465 |
14 |
3255.0 |
| Gloves |
328 |
3 |
492.0 |
| Gloves |
281 |
10 |
1405.0 |
| Gloves |
216 |
2 |
216.0 |
| IV Drip |
181 |
27 |
2443.5 |
| Surgical Mask |
379 |
14 |
2653.0 |
| IV Drip |
151 |
21 |
1585.5 |
| X-ray Machine |
42 |
1 |
21.0 |
| IV Drip |
263 |
26 |
3419.0 |
| Ventilator |
121 |
29 |
1754.5 |
| Ventilator |
52 |
5 |
130.0 |
| Surgical Mask |
168 |
8 |
672.0 |
| Surgical Mask |
25 |
17 |
212.5 |
| Surgical Mask |
32 |
10 |
160.0 |
| Gloves |
149 |
13 |
968.5 |
| IV Drip |
147 |
18 |
1323.0 |
| Gloves |
292 |
5 |
730.0 |
| Gloves |
481 |
17 |
4088.5 |
| IV Drip |
213 |
17 |
1810.5 |
| Ventilator |
89 |
26 |
1157.0 |
| Surgical Mask |
481 |
17 |
4088.5 |
| Ventilator |
92 |
4 |
184.0 |
| Ventilator |
301 |
9 |
1354.5 |
| X-ray Machine |
357 |
23 |
4105.5 |
| Gloves |
467 |
3 |
700.5 |
| Surgical Mask |
151 |
1 |
75.5 |
| IV Drip |
483 |
26 |
6279.0 |
| Ventilator |
416 |
7 |
1456.0 |
| X-ray Machine |
179 |
22 |
1969.0 |
| X-ray Machine |
275 |
29 |
3987.5 |
| Ventilator |
79 |
23 |
908.5 |
| Ventilator |
8 |
28 |
112.0 |
| X-ray Machine |
12 |
26 |
156.0 |
| Gloves |
192 |
18 |
1728.0 |
| X-ray Machine |
203 |
5 |
507.5 |
| X-ray Machine |
442 |
5 |
1105.0 |
| X-ray Machine |
315 |
3 |
472.5 |
| Gloves |
39 |
26 |
507.0 |
| Gloves |
170 |
12 |
1020.0 |
| Gloves |
471 |
11 |
2590.5 |
| IV Drip |
449 |
3 |
673.5 |
| IV Drip |
35 |
12 |
210.0 |
| IV Drip |
210 |
13 |
1365.0 |
| IV Drip |
427 |
21 |
4483.5 |
| Surgical Mask |
437 |
10 |
2185.0 |
| Surgical Mask |
71 |
27 |
958.5 |
| Surgical Mask |
132 |
4 |
264.0 |
| Ventilator |
425 |
20 |
4250.0 |
| Surgical Mask |
380 |
7 |
1330.0 |
| Ventilator |
92 |
28 |
1288.0 |
| X-ray Machine |
461 |
11 |
2535.5 |
| Surgical Mask |
168 |
17 |
1428.0 |
| Gloves |
214 |
9 |
963.0 |
| IV Drip |
282 |
26 |
3666.0 |
| Ventilator |
257 |
6 |
771.0 |
| X-ray Machine |
108 |
16 |
864.0 |
| Surgical Mask |
419 |
27 |
5656.5 |
| IV Drip |
382 |
6 |
1146.0 |
| Gloves |
450 |
19 |
4275.0 |
💰 Custo de Estoque Atual
df %>%
mutate(Total_Cost = Current_Stock * Unit_Cost) %>%
summarise(Custo_Total = sum(Total_Cost)) %>%
kable()