Question

In: Operations Management

M. Cotteleer Electronics supplies microcomputer circuitry to a company that incorporates microprocessors into refrigerators and other...

M. Cotteleer Electronics supplies microcomputer circuitry to a company that incorporates microprocessors into refrigerators and other home appliances. One of the components has an annual demand of 250 units, and this is constant throughout the year. Carrying cost is estimated to be $1 per unit per year, and the ordering (setup) cost is $20 per order.

a) To minimize cost, how many units should be ordered each time an order is placed?

b) How many orders per year are needed with the optimal policy?

c) What is the average inventory if costs are minimized?

d) Suppose that the ordering (setup) cost is not $20, and Cotteleer has been ordering 150 units each time an order is placed. For this order policy (of Q=150) to be optimal, determine what the ordering (setup) cost would have to be.

Solutions

Expert Solution

Given values:

Annual demand, D = 250 units

Carrying cost, Cc = $1 per unit per year

Ordering cost, Co = $20 per order

Solution:

(a) The cost is minimum when the number of units ordered are in accordance with the Economic Order Quantity (EOQ).

EOQ is calculated as;

EOQ = SQRT (2*D*Co) / Cc

where,

D = Annual demand

Co = Cost of ordering

Cc = Carrying cost

Putting the given values in the above formula, we get;

EOQ = SQRT (2 x 250 x 20) / 1

EOQ = SQRT (10000)

EOQ = 100 units

To minimize cost, 100 units should be ordered each time an order is placed.

(b) Number of orders per year is calculated as;

Number of orders = Annual demand / EOQ

Number of orders = 250 / 100

Number of orders = 2.5 orders per year

(c) Average inventory is calculated as;

Average inventory = EOQ / 2

Average inventory = 100 / 2

Average inventory = 50 units

(d) Given, Ordering quantity, Q = 150 units

For, Q = 150 units to be optimal, it should be the New Economic Order Quantity (EOQ).

EOQ = SQRT (2*D*Co) / Cc

150 = SQRT (2 x 250 x Co) / 1

150 = SQRT (500 x Co)

500 Co = 150 ^ 2

500 Co = 22500

Co = $45

New ordering (setup) cost = $45


Related Solutions

Tech Supplies Company, Incorporated, is a leading retailer specializing in consumer electronics
Tech Supplies Company, Incorporated, is a leading retailer specializing in consumer electronics. A condensed income statement and balance sheet for the fiscal year ended February 1, 2020, are shown below.Tech Supplies Company, IncorporatedBalance SheetAt February 1, 2020($ in millions)Assets Current assets: Cash and cash equivalents$ 2,106Accounts receivable (net)1,227Inventory5,064Other current assets418Total current assets8,815Long-term assets3,698Total assets$ 12,513Liabilities and Shareholders’ Equity Current liabilities: Accounts payable$ 5,100Other current liabilities3,775Total current liabilities8,875Long-term liabilities2,242Shareholders’ equity1,396Total liabilities and shareholders’ equity$ 12,513Tech Supplies Company, IncorporatedIncome StatementFor the Year...
Janus Products, Inc. is a merchandising company that sells binders, paper, and other school supplies. The...
Janus Products, Inc. is a merchandising company that sells binders, paper, and other school supplies. The company is planning its cash needs for the third quarter. In the past, Janus Products has had to borrow money during the third quarter to support peak sales of back-to-school materials, which occur during August. The following information has been assembled to assist in preparing a cash budget for the quarter: a. Budgeted monthly absorption costing income statements for July to October are as...
Janus Products, Inc. is a merchandising company that sells binders, paper, and other school supplies. The...
Janus Products, Inc. is a merchandising company that sells binders, paper, and other school supplies. The company is planning its cash needs for the third quarter. In the past, Janus Products has had to borrow money during the third quarter to support peak sales of back-to-school materials, which occur during August. The following information has been assembled to assist in preparing a cash budget for the quarter: a. Budgeted monthly absorption costing income statements for July to October are as...
Skolt Products, Inc., is a merchandising company that sells binders, paper, and other school supplies. The...
Skolt Products, Inc., is a merchandising company that sells binders, paper, and other school supplies. The company is planning its cash needs for the third quarter. In the past, Skolt Products has had to borrow money during the third quarter to support peak sales of back-to-school materials, which occur during August. The following information has been assembled to assist in preparing a cash budget for the quarter: a. Budgeted monthly absorption costing income statements for July–October are as follows: July...
Janus Products, Inc. is a merchandising company that sells binders, paper, and other school supplies. The...
Janus Products, Inc. is a merchandising company that sells binders, paper, and other school supplies. The company is planning its cash needs for the third quarter. In the past, Janus Products has had to borrow money during the third quarter to support peak sales of back-to-school materials, which occur during August. The following information has been assembled to assist in preparing a cash budget for the quarter: a. Budgeted monthly absorption costing income statements for July to October are as...
Skolt Products, Inc., is a merchandising company that sells binders, paper, and other school supplies. The...
Skolt Products, Inc., is a merchandising company that sells binders, paper, and other school supplies. The company is planning its cash needs for the third quarter. In the past, Skolt Products has had to borrow money during the third quarter to support peak sales of back-to-school materials, which occur during August. The following information has been assembled to assist in preparing a cash budget for the quarter:    a. Budgeted monthly absorption costing income statements for July–October are as follows:...
Astro Athletic Supply Company specializes in selling sporting goods, gymnasium equipment, and other athletic supplies to...
Astro Athletic Supply Company specializes in selling sporting goods, gymnasium equipment, and other athletic supplies to high schools and colleges. The company handles both written and telephone orders, using the following procedures, One of several company-employed field sales representatives records customer orders on a three-part form (Form 191A). The original is left with the customer, the duplicate is mailed to central headquarters each day in a special color-coded envelope, and the triplicate is retained in the sales representative's order pad....
Chance Company had two operating divisions, one manufacturing farm equipment and the other office supplies. Both...
Chance Company had two operating divisions, one manufacturing farm equipment and the other office supplies. Both divisions are considered separate components as defined by generally accepted accounting principles. The farm equipment component had been unprofitable, and on September 1, 2021, the company adopted a plan to sell the assets of the division. The actual sale was completed on December 15, 2021, at a price of $630,000. The book value of the division’s assets was $1,070,000, resulting in a before-tax loss...
Chance Company had two operating divisions, one manufacturing farm equipment and the other office supplies. Both...
Chance Company had two operating divisions, one manufacturing farm equipment and the other office supplies. Both divisions are considered separate components as defined by generally accepted accounting principles. The farm equipment component had been unprofitable, and on September 1, 2021, the company adopted a plan to sell the assets of the division. The actual sale was completed on December 15, 2021, at a price of $680,000. The book value of the division’s assets was $1,170,000, resulting in a before-tax loss...
LMN Ltd manufactures three products L, M and N. The company which supplies the two raw...
LMN Ltd manufactures three products L, M and N. The company which supplies the two raw materials which are used in all three products has informed LMN that their employees are refusing to work overtime. This means that supply of the materials is limited to the following quantities for the next period: Material A 1,030 kg Material B 1,220 kg No other source of supply can be found for the next period. Information relating to the three products manufactured by...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT