Question

In: Finance

Financial management. Thika filters Company is a distributor of air filters to retail stores. It buys...

Financial management.

Thika filters Company is a distributor of air filters to retail stores. It buys its filters from severalmanufacturers. Filters are ordered in lot sizes of 1,000 and each order costs Kshs. 40 to place.Demand from the retail stores is 20,000 filters per month and carrying cost is Kshs. 0.10 a filterper month.

(i) What is optimal filter order quantity in lot sizes of 1,000
(ii) What would be the optimal order quantity if the carrying costs were cut I half to Kes.0.05 afilter per month.
(iii)What would be the optimal order quantity if ordering costs were reduced to Kshs. 10 perorder.

Solutions

Expert Solution

Economic Order Quantity (EOQ) EOQ

=(2 × Annual demand × ordering cost per order/carrying cost per annum)1/2

(i)

  • Annual demand = 20,000 filters × 12 = 240,000 filters
  • Ordering cost per order = $40
  • Carrying cost per unit per annum = $0.10 × 12 = $1.2

Optimal filter order quantity =

=(2 × 240,000 × 40 /1.2)1/2

= (19,200,000/1.2)1/2

=(16,000,000)1/2

= 4,000

The optimal filter order quantity is 4,000 filters

The optimal filter order quantity in lot sizes of 1,000 =

4,000/1,000 = 4

(ii)

  • Annual demand = 20,000 filters × 12 = 240,000 filters
  • Ordering cost per order = $40
  • Carrying cost per unit per annum = $0.05 × 12 = $0.6

Optimal filter order quantity =

=(2 × 240,000 × 40 /0.6)1/2

= (19,200,000/0.6)1/2

=(32,000,000)1/2

= 5,656.85

Since the lot size is 1000, the company will order 6000 filters

The optimal filter order quantity is 6,000 filters

The optimal filter order quantity in lot sizes of 1,000 =

6,000/1,000 = 6

(iii)

  • Annual demand = 20,000 filters × 12 = 240,000 filters
  • Ordering cost per order = $ 10
  • Carrying cost per unit per annum = $0.10 × 12 = $1.2

Optimal filter order quantity =

=(2 × 240,000 × 10 /1.2)1/2

= (4,800,000/1.2)1/2

=(4,000,000)1/2

= 2,000

The optimal filter order quantity is 2,000 filters

The optimal filter order quantity in lot sizes of 1,000 =

2,000/1,000 = 2

Summary:

(i) 4

(ii) 6

(iii) 2


Related Solutions

-Financial Management Principles German Technologies Inc. operates a small chain of speciallity retail stores throughout the...
-Financial Management Principles German Technologies Inc. operates a small chain of speciallity retail stores throughout the U.S. southwest. The conpamy markets technology-based consumer products both in its stores and over the internet, with sales split roughly equally between the two channel distribution. The company’s products range from radar detection devices and GPS mapping systems used in automobiles to home-based weather monitoring stations. The company recently began investigating the possible acquisition of a regional wearhousing faciltiy that could be used to...
Sweet Air Filtration Products Company, a major supplier of air filters sold throughout the United States,...
Sweet Air Filtration Products Company, a major supplier of air filters sold throughout the United States, employs one hundred workers at its principal manufacturing plant. The plant is located in Thunder Bay, which has a population that is 50 percent white and 25 percent African American, with the balance Hispanic American, Asian American, and others. Sweet Air requires a high school diploma as a condition of employment for its cleaning crew. Three-fourths of the white population completed high school, compared...
East Point Retail, Inc., sells professional women's apparel through company-owned retail stores. Recent financial information for...
East Point Retail, Inc., sells professional women's apparel through company-owned retail stores. Recent financial information for East Point is provided below (all numbers in thousands). Fiscal Year 3 Fiscal Year 2 Net income $152,300 $78,400 Interest expense 3,100 11,700 Fiscal Year 3 Fiscal Year 2 Fiscal Year 1 Total assets (at end of fiscal year) $3,250,715 $3,092,143 $2,720,761 Total stockholders' equity (at end of fiscal year) 1,106,640 1,084,726 804,430 Assume the apparel industry average return on total assets is 8.0%,...
Bendigo Pottery Ltd is a wholesale distributor of hand-made glazed garden pots to retail stores. All...
Bendigo Pottery Ltd is a wholesale distributor of hand-made glazed garden pots to retail stores. All garden pots are identical. Details for January 2020 are shown below. January 1 Opening inventory 2,000 pots – cost $39 each 8 Sales 1,200 pots – selling price $80 each 9 Purchases 1,600 pots – purchase price $44 each 28 Sales 1,800 pots – selling price $84 each 31 Closing inventory 600 pots from the stock stake Additional information: Freight costs from the supplier...
Bendigo Pottery Ltd is a wholesale distributor of hand-made glazed garden pots to retail stores. All...
Bendigo Pottery Ltd is a wholesale distributor of hand-made glazed garden pots to retail stores. All garden pots are identical. Details for January 2020 are shown below. January 1 Opening inventory 2,000 pots – cost $39 each 8 Sales 1,200 pots – selling price $80 each 9 Purchases 1,600 pots – purchase price $44 each 28 Sales 1,800 pots – selling price $84 each 31 Closing inventory 600 pots from the stock stake Additional information: Freight costs from the supplier...
Profitability Ratios East Point Retail, Inc., sells professional women's apparel through company-owned retail stores. Recent financial...
Profitability Ratios East Point Retail, Inc., sells professional women's apparel through company-owned retail stores. Recent financial information for East Point is provided below (all numbers in thousands). Fiscal Year 3 Fiscal Year 2 Net income $156,200 $80,500 Interest expense 3,200 12,000 Fiscal Year 3 Fiscal Year 2 Fiscal Year 1 Total assets (at end of fiscal year) $2,334,072 $2,220,214 $1,984,332 Total stockholders' equity (at end of fiscal year) 1,151,547 1,128,745 834,669 Assume the apparel industry average return on total assets...
Profitability Ratios East Point Retail, Inc., sells professional women's apparel through company-owned retail stores. Recent financial...
Profitability Ratios East Point Retail, Inc., sells professional women's apparel through company-owned retail stores. Recent financial information for East Point is provided below (all numbers in thousands). Fiscal Year 3Fiscal Year 2 Net income$150,000 $77,300   Interest expense3,100 11,500   Fiscal Year 3Fiscal Year 2Fiscal Year 1 Total assets (at end of fiscal year)$2,120,642 $2,017,196 $1,761,528 Total stockholders' equity (at end of fiscal year)1,089,928 1,068,346 794,304 Assume the apparel industry average return on total assets is 8.0%, and the average return on...
ABC Company is a producer of electronic furnace air filters. A significant jump in new housing...
ABC Company is a producer of electronic furnace air filters. A significant jump in new housing starts in the region has triggered a 25 percent increase in orders for the filter units, especially the quality model that ABC sells for $270. Six weeks after increasing production to supply the increased orders, the production intern questions you about the following cost data: Filter This month Last month Change Average total coast per unit $167.20 $171.14 ($3.96) Average Variable cost per unit...
Accounts Receivable Analysis Bassett Stores Company and Fox Stores Inc. are large retail department stores. Both...
Accounts Receivable Analysis Bassett Stores Company and Fox Stores Inc. are large retail department stores. Both companies offer credit to their customers through their own credit card operations. Information from the financial statements for both companies for two recent years is as follows (all numbers are in millions): Bassett Fox Merchandise sales $292,000 $408,800 Credit card receivables—beginning 44,298 40,499 Credit card receivables—ending 36,982 31,181 a. (1) Determine the accounts receivable turnover for both companies. Round to one decimal place. Bassett...
Accounts Receivable Analysis Xavier Stores Company and Lestrade Stores Inc. are large retail department stores. Both...
Accounts Receivable Analysis Xavier Stores Company and Lestrade Stores Inc. are large retail department stores. Both companies offer credit to their customers through their own credit card operations. Information from the financial statements for both companies for two recent years is as follows (in millions): Xavier Lestrade Sales $8,500,000 $4,585,000 Credit card receivables—beginning 820,000 600,000 Credit card receviables—ending 880,000 710,000 a. Determine the (1) accounts receivable turnover and (2) the number of days' sales in receivables for both companies. Round...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT