Question

JL.53 Bob's Bumpers has a repetitive manufacturing facility in Kentucky that makes automobile bumpers and other...

JL.53 Bob's Bumpers has a repetitive manufacturing facility in Kentucky that makes automobile bumpers and other auto body parts. The facility operates 290 days per year and has annual demand of 75,000 bumpers. They can produce up to 330 bumpers each day. It costs \$59 to set up the production line to produce bumpers. The cost of each bumper is \$131 and annual holding costs are \$37 per unit. Setup labor cost is \$28 per hour.

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

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 wholenumber.)

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 nearest whole number.)

Suppose the customer (an auto manufacturer) wants to purchase in lots of 620 and that Bob's Bumpers is able to reduce setup costs to the point where 620 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 costs with this new lower production quantity? (Display your answer to two decimal places.)

Annual demand (D) = 75000

Daily demand (d) = 75000/290 = 258.62

Daily production capacity (p) = 330

Setup cost (S) = 59

Product cost (P) = 131

Holding cost (H) = 37

Optimal size

Q = sqrt( 2DS/ (H*(1-(d/p))))

Q = sqrt (2*75000*59/(37*(1-(258.62/330)))) = 1051.57 units or 1052 units

Average inventory

I = (Q/2)*(1 – d/p)

I = (1052/2)*(1-(258.62/330)) = 113.775 units

Number of production run

R = D/Q = 75000/1052 = 71.29 or 72 runs

Annual holding cost

C = (HQ/2)*(1-(d/p))

The setup cost has no role in the annual holding cost of the inventory.

At the current situation, C1 = (37*1052/2)*(1-(258.62/330)) = 4209.68

With the new quantity, C2 = (37*620/2)*(1-(258.62/330)) = 2480.99

The saving is 1728.69

Annual setup cost

O = DS/Q

However, we need to determine the new value of S.

620 = sqrt(2*75000*X/(37*(1-(258.62/330))))

X = 20.50

Old annual setup cost = 75000*59/1052 = 4206.27

New annual setup cost = 75000*20.5/620 = 2479.83

The saving is 1726.43

Earn Coins

Coins can be redeemed for fabulous gifts.

Similar Homework Help Questions
• JL.53 Bob's Bumpers has a repetitive manufacturing facility in Kentucky that makes automobile bumpers and other...

JL.53 Bob's Bumpers has a repetitive manufacturing facility in Kentucky that makes automobile bumpers and other auto body parts. The facility operates 350 days per year and has annual demand of 55,000 bumpers. They can produce up to 395 bumpers each day. It costs \$85 to set up the production line to produce bumpers. The cost of each bumper is \$106 and annual holding costs are \$23 per unit. Setup labor cost is \$25 per hour. 1) What is the...

• Please show your work so I can understand this portion, Thank you! JL.51 Carl's Custom Cans...

Please show your work so I can understand this portion, Thank you! JL.51 Carl's Custom Cans produces small containers which are purchased by candy and snack food producers. The production facility operates 260 days per year and has annual demand of 13,800 units for one of its custom cans. They can produce up to 120 of these cans each day. It costs \$43.31 to set up one of their production lines to run this can. (Carl pays \$18 per hour...

• Need help within 30 minutes please! JL.52 A producer of industrial climate control modules has recently...

Need help within 30 minutes please! JL.52 A producer of industrial climate control modules has recently changed to cellular manufacturing. The production facility operates 250 days per year and has annual demand of 6,500 units They can produce up to 80 modules each day. It costs \$18.50 to set up a work cell to produce this module. The cost of each module is \$32 and annual holding costs are \$4 per unit. Setup labor cost is \$14 per hour. What...

• JL.61 A producer of refrigerator compressors wants to implement a just-in-time production line to support demand...

JL.61 A producer of refrigerator compressors wants to implement a just-in-time production line to support demand from a neighboring appliance manufacturer. Demand from the appliance manufacturer is for 285 compressors a day. The production lead time is 4 days and the producer wants to have a 18% safety stock factor. This producer has also cut setup costs such that the optimal production quantity is 93 units. How many kanbans does this producer of compressors require? (Display your answer to the...

• IM.82 A distributor of industrial equipment purchases specialized compressors for use in air conditioners. The regular...

IM.82 A distributor of industrial equipment purchases specialized compressors for use in air conditioners. The regular price is \$40, however, the manufacturer of this compressor offers quantity discounts per the following discount schedule: Option Plan Quantity Discount A 1 - 299 0% B 300 - 1,299 0.50% C 1,300+ 1.00% The distributor pays \$80 each time it places an order with the manufacturer. Holding costs are negligible (none) but they do earn 13% annual interest on all cash balances (meaning...

• IM.81 An appliance distributor in Arizona has high-volume sales for an ice cleaner solution. The manufacturer...

IM.81 An appliance distributor in Arizona has high-volume sales for an ice cleaner solution. The manufacturer of this cleaner offers quantity discounts per the following discount schedule Quantity     Unit Price   1 - 399 \$15.00 400 - 1,199 \$14.50 1,200+ \$14.00 The appliance distributor pays \$60 each time it places an order with the manufacturer. Holding costs are \$4.50 per unit. Annual demand is expected to be 3,600 units. 1. Based on this information, which quantity discount option should you select?...

• Radovilsky Manufacturing​ Company, in​ Hayward, California, makes flashing lights for toys. The company operates its production...

Radovilsky Manufacturing​ Company, in​ Hayward, California, makes flashing lights for toys. The company operates its production facility 300 days per year. It has orders for about 11,900 flashing lights per year and has the capability of producing 95 per day. Setting up the light production costs \$49. The cost of each light is \$0.95.The holding cost is \$0.10 per light per year. ​a) What is the optimal size of the production​ run? _ units ​(round your response to the nearest...

• A chemical plant produces sodium bisulfate in 150 kg bags. Demand for this product is 20...

A chemical plant produces sodium bisulfate in 150 kg bags. Demand for this product is 20 tonnes per day. The capacity for producing this product is 55 tonnes per day. Setup cost is \$320, and storage and handling costs are \$150 per tonne per year. The company operates 220 days a year. (Note: 1 tonne = 1,000 kg). a. What is the optimal number of bags per production run? (Round your intermediate calculations to 2 decimal places and the final...

• Question 1 Fork Motor Company is an automobile manufacturer operating in the US. It has divided...

Question 1 Fork Motor Company is an automobile manufacturer operating in the US. It has divided its market into three regions and has built three regional distribution centers (RDC) to serve these markets. The RDCs are located in California, Florida and Texas. The annual demand at each regional distribution center is estimated as follows and the company wants to meet all the demand. - RDC – California: 1.5M automobiles (i.e., 1.5 million) - RDC – Florida: 0.5M automobiles - RDC...

• Foods Galore is a major distributor to restaurants and other institutional food users. Foods Galore buys...

Foods Galore is a major distributor to restaurants and other institutional food users. Foods Galore buys cereal from a manufacturer for \$23 per case. Annual demand for cereal is 225,000 cases, and the company believes that the demand is constant at 900 cases per day for each of the 250 days per year that it is open for business. Average lead time from the supplier for replenishment orders is eight days, and the company believes that it is also constant....

Free Homework Help App

Need Online Homework Help?

Most questions answered within 3 hours.