The first $3$ inputs are correct. Please help with the last $2$ questions. JL$.53$ Bob's Bumpers has a repetitive manufacturing facility in Kentucky that makes automobile bumpers and other auto body parts. The facility operates

$280$ days per year and has annual demand of $58,000$ bumpers. They can produce up to $415$ bumpers each day. It costs $$90$ to set up the production line to

produce bumpers. The cost of each bumper is $$148$ and annual holding costs are $$36$ per unit. Sefup labor cost is $$26$ per hour.

What is the optimal size of the production run for bumpers? $($Display your answer to the nearest whole number.$)$

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? $($Display your answer to the nearest whole number.$)$

Based on your answer two questions back, how many production runs will be required each year to satisfy demand? HINT: As a general rule, whenever

calculating a value that is based on previous calculations in Excel, always be sure to use cell references rather than a rounded value as a calculation input.

$($Display your answer to the appropriate whole number.$)$

Suppose the customer $($an auto manufacturer$)$ wants to purchase in lots of $410$ and that Bob's Bumpers is able to reduce setup costs to the point where $410$

is now the optimal production run quantity. How much will they save in annual holding costs with this new lower production quantity? $($Display your answer to

two decimal places.$)$

How much will they save in annual setup casts with this new lower production quantity? $($Display your answer to two decimal places.$)$