A local manufacturer uses 2,000 electronic switches boxes a year. Carrying costs are 23% of the...

A local manufacturer uses 2,000 electronic switches boxes a year. Carrying costs are 23% of the cost of the switch per year, and ordering costs are $15 per order. The following price schedule applies. What is the optimal order quantity? Show all total costs calculations and explain your answer.

Number of Switches Price per Switch

0 - 99 $17.50

100 - 999 $17.00

1000 or more $16.50

Solutions

Expert Solution

DEMAND = 2000

ORDERING COST = 15

HOLDING COST % = 23 %

EOQ = SQRT(2 * D * S / H), WHERE D = DEMAND, S = ORDERING COST, H = HOLDING COST

ANNUAL HOLDING COST = (Q* / 2) * H

ANNUAL ORDERING COST = (DEMAND / Q*) * S

ANNUAL PURCHASE COST = DEMAND * PER UNIT COST IN PARTCIULAR PRICE BRACKET

TCI = AHC + AOC + APC

OPTIMAL ORDER QUANTITY = 124

TOTAL COST FOR OPTIMAL QUANTITY = 34484

#	MINIMUM QUANTITY	MAXIMUM QUANTITY	UNIT COST	ADJUSTED HOLDING COST	Q	Q*	AHC	AOC	APC	TCI
1	1	99	17.5	4.025	122	99	(99 / 2) * 4.025 = 199.24	2000 / 99 * 15 = 303.03	2000 * 17.5 = 35000	199.24 + 303.03 + 35000 = 35502
2	100	999	17	3.91	124	124	(124 / 2) * 3.91 = 242.42	2000 / 124 * 15 = 241.94	2000 * 17 = 34000	242.42 + 241.94 + 34000 = 34484
3	1000	OR MORE	16.5	3.795	126	1000	(1000 / 2) * 3.795 = 1897.5	2000 / 1000 * 15 = 30	2000 * 16.5 = 33000	1897.5 + 30 + 33000 = 34928

Do leave a like for the answer if you found it helpful.

keosha answered 7 months ago

Next > < Previous

Related Solutions

Stanley’s Secretarial Services uses an average of 1,215 boxes of envelopes each year. Carrying costs per...

Stanley’s Secretarial Services uses an average of 1,215 boxes of envelopes each year. Carrying costs per box are $75 per year, and it costs $10 to place and receive an order. a. What is the optimal order quantity for boxes of envelopes, to the nearest whole number? Economic order quantity boxes b. What is the average number of boxes of envelopes in inventory, to the nearest whole number? Average number of boxes c. How times will Stanley order envelopes...

A mail-order house uses 15,950 boxes a year. Carrying costs are 69 cents per box a...

A mail-order house uses 15,950 boxes a year. Carrying costs are 69 cents per box a year, and ordering costs are $100. The following price schedule applies. Number of Boxes Price per Box 1,000 to 1,999 $1.40 2,000 to 4,999 1.30 5,000 to 9,999 1.20 10,000 or more 1.15 a. Determine the optimal order quantity. (Round your answer to the nearest whole number.) b. Determine the number of orders per year. (Round your answer to 2 decimal places.)

A mail-order house uses 18,000 boxes a year. Carrying costs are 60 cents per box a...

A mail-order house uses 18,000 boxes a year. Carrying costs are 60 cents per box a year, and ordering cost are $96. the folling price schedule applies. Number of boxes Price per box 1,000 to 1,999 $1.25 2,000 to 4,999 1.20 5,000 to 9,999 1.15 10,000 or more 1.10 A. What is the maximum level of inventory the company would have to plan for? B. what is the average level of inventory the company would have to plan for? C....

A mail-order house uses 15,750 boxes a year

A mail-order house uses 15,750 boxes a year. Carrying costs are 60 cents per box a year and ordering costs are $96. The following price schedule applies.Number of BoxesPrice per Box1,000 to 1,999$1.252.000 to 4,9991.205,000 to 9,9991.1510.000 or more1.10a. Determine the optimal order quantity (Round your answer to the nearest whole number) Optimal order quantity = _______ boxes b. Determine the number of orders per year. (Round your answer to 2 decimal places.) Number of order _______ per yearA jewelry firm buys semiprecious...

Equipment maintenance costs for manufacturing explosion-proof pressure switches are projected to be $100,000 in year 1...

Equipment maintenance costs for manufacturing explosion-proof pressure switches are projected to be $100,000 in year 1 and increase by 4% each year through year 5. What is the present worth of the maintenance costs at an interest rate of 10% per year, compounded quarterly for the first 3 years, if the interest rate for years 4 and 5 are 10%/year compounded monthly? (solve by hand DON'T use Excell program)

1. By paying off the manufacturer in 15 days rather than a year, the dollar carrying...

1. By paying off the manufacturer in 15 days rather than a year, the dollar carrying cost of the car to the dealership is A. sometimes increased, sometimes decreased. B. increased. C. decreased. D. unchanged. 2. Your aunt is planning to invest in a bank CD that will pay 7.0 percent interest semiannually. If she has $13,000 to invest, how much will she have at the end of four years? (Round your answer to the nearest penny.) Value of investment...

Satriale uses 145,600 switches per year (or 2,800 per week) and currently orders 2,800 weekly (assume...

Satriale uses 145,600 switches per year (or 2,800 per week) and currently orders 2,800 weekly (assume they are delivered immediately). If the carrying cost per switch is $6.20 and the fixed order cost is $1,200, is the company’s inventory policy optimal? What is the economic order quantity they should use? How much money will they save by changing their ordering behavior to that quantity compared to what they are spending now?

Highlander Corporation is a manufacturer that uses the average cost method to account for costs of...

Highlander Corporation is a manufacturer that uses the average cost method to account for costs of production. Highlander manufactures a product that is produced in three separate departments : Molding, Assembling and Finishing. The following information was obtained for the assembling department for the month of June: Work in process, June 1, 4,000 units composed of the following" Transferred in from the molding department amount $ 60,000, percent of completion 100%. cost added by the assembling department: direct materiasl $...

Highlander Corporation is a manufacturer that uses the average cost method to account for costs production....

Highlander Corporation is a manufacturer that uses the average cost method to account for costs production. Highlander manufactures a product that is produced in three separate departmenst: Molding, Assembling, and Finshing. The following information was obtained for the assembling department for the month of June. Work in process, Jun 1 : 4,000 units composed of the following: Transferred in from the molding department Amount 60,000 percent of completion 100%, Cost added by the assembling department: Direct Materials $ 0 ,...

Quacker Manufacturing uses just-in-time inventory techniques to reduce their carrying costs. Despite having a low level...

Quacker Manufacturing uses just-in-time inventory techniques to reduce their carrying costs. Despite having a low level of working capital, they experience significant sales and production levels. Quacker reported the following information at year-end: Beginning Raw Materials Inventory $1,000 Ending Raw Materials inventory: $5,200 Beginning Work in Process: $4,000 Ending Work in Process: $4,200 Beginning Finished Goods Inventory: $2,400 Ending Finished Goods Inventory: $1,800 Materials Purchased: $130,000 Indirect Materials Used: $4,000 Direct Labor Wages: $144,000 Indirect Labor Wages: $200,000 Production Equipment...

Subjects