Please answer the question below fully and include excel spreadsheet if used to find answer. There is no additional information except for what is stated in the question below. The correct answer will receive a thumbs up.

In a production department Kanbans are used to support the JIT production policy. Data on the rules and POQ are given below.

POQ	Hourly Production	Hourly Usage	Lead Time (Hrs.)	Safety Policy %
140	200	60	10	15%

Note that the response to part b relies on the correct response to part a so confirm your part a answer before recording and proceeding.

a. What is the integer value number of JIT Kanbans to provide for this part?

b. Due congestion on the production floor the directive came to reduce the number of Kanbans for all parts by 5 (for example from 14 to 9). To achieve this lead time reduction was required. What is the longest lead time in half hour time periods required to meet this directive? Half hour time period examples are 4.0, 4.5, 5.0, 5.5 etc. Round down not up in your conversion.