**NEED IN EXCEL, DO NOT ANSWER IF YOU DONT KNOW.ILL REPORT YOU IF WRONG, NEED PROPER EXPLANATION.

**NEED IN EXCEL, DO NOT ANSWER IF YOU DONT KNOW.ILL REPORT YOU IF WRONG, NEED PROPER EXPLANATION.....

PROPER EXPLANATION ONLY IN EXCEL ** (DO NOT COPY FROM OTHER CHEGG ANSWERS, I DID NOT UNDERSTAND IT, SO IM POSTING AGAIN)

JL.53. Bob's bumpers has a repetitive manufacturing facility in Kentucky that makes automobile bumpers and other auto body parts. The facility operates 250 days per year and has a annual demand of 40,000 bumpers. They can produce up to 320 bumpers each day. It costs $53 to set up.the production line to produce bumpers. The cost of each bumper is $95 and annual holding costs are $25 per unit. setup labor cost is $23 per hour. a) based on the above information, what is the optimal size of the production run for bumpers? display answer to two decimal places b) based on your answer to the previous question and assuming the manufacturer holds no safety stock, what would be the average inventory for these bumpers? c) based on your answer two question back, how many production runs would be required each year to satisfy demand? d) suppose the customer (an auto manufacturer) wants to purchase these bumpers in lots of 500 and that bob's bumper is able to reduce setup cost to the poi t where 500 is now the optimal production run quantity. how much will they save in annual holding cost with this new lower production quantity? e) how much will they save in annual set up costs with this new lower production quantity?

**NEED IN EXCEL, DO NOT ANSWER IF YOU DONT KNOW.ILL REPORT YOU IF WRONG, NEED PROPER EXPLANATION.

**NEED IN EXCEL, DO NOT ANSWER IF YOU DONT KNOW.ILL REPORT YOU IF WRONG, NEED PROPER EXPLANATION.....

PROPER EXPLANATION ONLY IN EXCEL ** (DO NOT COPY FROM OTHER CHEGG ANSWERS, I DID NOT UNDERSTAND IT, SO IM POSTING AGAIN)