In one of PLE’s manufacturing facilities, a drill press that has three drill bits is used...

In one of PLE’s manufacturing facilities, a drill press that has three drill bits is used to fabricate metal parts. Drill bits break occasionally and need to be replaced. The present policy is to replace a drill bit when it breaks or can no longer be used. The operations manager is considering a different policy in which all three drill bits are replaced when any one bit breaks or needs replacement. The rationale is that this would reduce downtime. It costs $200 each time the drill press must be shut down. A drill bit costs $85, and the variable cost of replacing a drill bit is $14 per bit. The company that supplies the drill bits has historical evidence that the reliability of a single drill bit is describes by a Poisson probability distribution with the mean time between failures is an exponential distribution with mean μ = 1 / λ = 1 / 0.01 = 100 hours. (Professor Cursio: see below.) The operations manager at PLE would like to compare the cost of the two replacement policies. Develop spreadsheet models to determine the total cost for each policy over 1,000 hours and make a recommendation. Explain and summarize your findings in a report

Expert Solution

milcah answered 1 year ago

Exercise 17.4 Alliance Manufacturing Company is considering the purchase of a new automated drill press to...

Exercise 17.4 Alliance Manufacturing Company is considering the purchase of a new automated drill press to replace an older one. The machine now in operation has a book value of zero and a salvage value of zero. However, it is in good working condition with an expected life of 10 additional years. The new drill press is more efficient than the existing one and, if installed, will provide an estimated cost savings (in labor, materials, and maintenance) of $6,000 per...

On January 1, 2018, Hobart Mfg. Co. purchased a drill press at a cost of $39,300. The drill press is expected to last 10 years and has a residual value of $6,300.

On January 1, 2018, Hobart Mfg. Co. purchased a drill press at a cost of $39,300. The drill press is expected to last 10 years and has a residual value of $6,300. During its 10-year life, the equipment is expected to produce 500,000 units of product. In 2018 and 2019, 26,500 and 87,000 units, respectively, were produced. Required: Compute depreciation for 2018 and 2019 and the book value of the drill press at December 31, 2018 and 2019, assuming the...

Tech Mfg. is thinking about replacing an existing drill press. The existing press was purchased 2...

Tech Mfg. is thinking about replacing an existing drill press. The existing press was purchased 2 years ago for $78,000 with a salvage value of $9,000. It will last for three more years and then will be scrapped. It can be sold today for $37,000. A new press can be purchased for $95,000 with an expected salvage value of $10,500 at the end of its three-year life. The new press will decrease labor costs by $18,000 per year. Sales generated...

Wermers Industries Inc. has developed a new drill press, model LS-88, that is designed to offer...

Wermers Industries Inc. has developed a new drill press, model LS-88, that is designed to offer superior performance to a comparable drill press sold by Wermers’s main competitor. The competing drill press sells for $31,000 and needs to be replaced after 1,000 hours of use. It also requires $6,000 of preventive maintenance during its useful life. ModelLS-88’s performance capabilities are similar to the competing product with two important exceptions—it needs to be replaced only after 2,000 hours of use and...

Boback Industries Inc. has developed a new drill press, model DP-18, that is designed to offer...

Boback Industries Inc. has developed a new drill press, model DP-18, that is designed to offer superior performance to a comparable press sold by Boback's main competitor. The competing press sells for $88,000 and needs to be replaced after 29,600 hours of use. It also requires $59,200 of preventive maintenance during its useful life. Model DP-18’s performance capabilities are similar to the competing product with two important exceptions—it needs to be replaced only after 118,400 hours of use and it...

A high-speed multiple-bit drill press costing $1,080,000 has an estimated salvage value of $90,000 and a...

A high-speed multiple-bit drill press costing $1,080,000 has an estimated salvage value of $90,000 and a life of ten years. What is the annual depreciation for each of the first two full years under the following depreciation methods? Units of production (activity) method (lifetime output is estimated at 110,000 units; the press produced 12,000 units in year one and 18,000 in year two): Double-declining-balance method: Year one, $______________. Year two, $______________. Units of production (activity) method (lifetime output is estimated...

Iron-Bit is a manufacturer of industrial drill bits. The management is concerned about the adequacy of...

Iron-Bit is a manufacturer of industrial drill bits. The management is concerned about the adequacy of the firm’s working capital in funding daily operations. a) The average collection period and average payment period are 35 days and 30 days respectively. The firm turns over its inventory 20 times each year (assume 365 days year), and currently has annual sales of $185 million. (i) Calculate the firm’s operating cycle (OC) and cash conversion cycle (CCC), correct to 1 decimal place. (ii)...

ABC Manufacturing Corp. is a private company that operates three manufacturing facilities. Each manufacturing facility produces...

ABC Manufacturing Corp. is a private company that operates three manufacturing facilities. Each manufacturing facility produces one of the three product lines ABC sells. ABC purchased the facilities using nonrecourse debt. (Nonrecourse debt is a loan that is secured by a pledge of collateral, in this case the facility, but for which the borrower is not personally liable. If the borrower defaults, the lender can seize the collateral, but the lender’s recovery is limited to the collateral.) Each facility is...

A machine shop owner is attempting to decide whether to purchase a new drill press, a...

A machine shop owner is attempting to decide whether to purchase a new drill press, a lathe, or a grinder. The profit or loss from each purchase are shown in the following table where one of two states of nature could occur (the company succeeds in getting a military contract, or it does not get a contract). Contract status Purchase Get Contract No contract Drill press 40000 -8000 Lathe 25000 4000 Grinder 12000 10,000 a-for each purchase...

A tool and die company is considering the purchase of a drill press with fuzzy-logic software...

A tool and die company is considering the purchase of a drill press with fuzzy-logic software to improve accuracy and reduce tool wear. The company has the opportunity to buy a slightly used machine for $15,000 or new one for $21,000. Because the new machine is a more sophisticated model, its operating cost is expected to be $7000 per year, while the used machine is expected to require $8200 per year. Each machine is expected to have 25 years life...

Question