Part 2 (30 points). The following data represents historic demand for steps in a beer supply chain. What level of inventory would need to be held at each step in order to expect a 95% service level to each subsequent customer in the chain (see attached excel sheet)? Here's a link & to z-score tables in case you find that helpful. If each piece of inventory costs $1, how much TCO would be added to the supply chain for each tier to operate at a 99% service level instead of 95%? Calculate as a dollar value and as a percentage increase. Service Level Calculation.xlsx Y, Historic Historic Historic Historic Demand Demand Demand Demand 406 474 453 478 424 468 413 ar7 402 a3 a88. 493 477 405 402 404 455 497 aas 407 406 430 a15 495 485 a75 426 499 408 464 492 470 445 449 409 214 460 493 499 416 a1 a78 456 a15 492 461 488 402 480 483 a18 460 461 a77 a8a an a1 419 404 a2 as5. 430 476 498 428 434 a67 432 408 481 aa9 497 a73 463 ass 436 426 493 433 a1 462 484 as6. 453 a74 401 439 479 a77 a77 460 490 407 408 282 458 469 470 486 497 496 409 466 490 a87 437 410 435 496 23 a37 25 416 469 494 a75 a1 459 443 455 as5. 405 a37 493