Ross White's machine shop uses 2,500 brackets during the course of a year, and this usage is relatively constant throughout the year.  These brackets are purchased from a supplier 100 miles away for $15 each, and the lead time is 2 days.  The holding cost per bracket per year is $1.50 (or 10% of the unit cost) and the ordering cost per order is  $18.75.  There are 250 working days per year. Required: (a).   What is the EOQ? ( b.)   Given the EOQ, what is the average inventory?  What is the annual inventory holding costs? ( c).   In minimizing cost, how many orders would be made each year?  What would be the annual ordering cost?

A local toolmaker makes the best hammers on the market. The head of the hammer costs $19.75 and the handle costs $3.52. It takes 1.4 minutes to assemble the hammer and the hourly cost is $73 for assembly time. The company has fixed operating costs of $27746 per month. They sell the hammers for three times their total variable cost. The company wants to make a monthly profit of $14085. How many hammers must they sell? Round to the nearest whole number Answer:

A firm orders on average 400 wheels each month. Demand is normally distributed with standard deviation of the monthly demand being 20 wheels. The ordering cost is $8 per order. The cost to buy one wheel is $4 per wheel. Annual carrying costs are 50% of unit cost. The supplier lead time is 2 operating days. The firm operates 240 days per year, in other word, the firm operates 20 days each month. Each order is received from the supplier in a single delivery. There are no quantity discounts. Write your answer and then Round your answer up to the nearest number for future calculation. (e.g 9.6 => 10). Please clearly write down the formulation and calculation for your answers. Note: Here I make the time measures bolded for you to make you pay the attention to their differences. Please notice the difference in times measure units, so that you do not make mistake by doing calculations with different time measures. You need to convert the data to the same time measures before doing any…

PLEASE MAKE IT IN EXCEL AND SHOW THE FORMULAS Comercial El Alacrán, S.A., purchases 200,000 units per year of the only product it sells. The cost of each order is $35.00. The annual unit maintenance cost is 23% of its cost of $8.00. The supplier currently takes 5.5 days to deliver, and the company sorts and stores it in 3 days. The company makes significant efforts to shorten these lead times. If it manages to reduce, through an agreement with the supplier, its delivery time to 3.5 days and to do the sorting in 1.5 days, how many units does the decrease in the reorder point amount to?