Question

In: Operations Management

Sports Stuff, Inc. (SSI) is a manufacturing firm that produces sporting goods. They have started operating...

Sports Stuff, Inc. (SSI) is a manufacturing firm that produces sporting goods. They have started operating a factory in the U.S. and have opened a company owned store adjacent to the factory. The production manager at the factory is trying to ascertain the optimal number of footballs to produce with each production run. After careful analysis, she believes that the following data are correct:

  • Annual demand is 21,875 footballs per year
  • The store is open 350 days per year
  • The daily production capacity of the factory is 200 units
  • Setup cost incurred to start football production is $25
  • Annual storage cost per football is $17.50
  • Lead time is two days
  • Safety stock is 10 footballs

Answer the following questions for SSI.

a) What is the optimal lot size for football production? (round to 2 decimals)   footballs


b) What is the minimum inventory level of footballs?   footballs


c) What is the maximum inventory level of footballs? (round to 2 decimals)   footballs


d) What is the average inventory level of footballs? (round to 2 decimals)   footballs


e) What is the reorder point in units?   footballs


f) What is the annual setup cost for football production? (round to 2 decimals)  $


g) What is the annual holding cost for the football inventory? (round to 2 decimals)  $

Solutions

Expert Solution

Answer: Given: Annual Demand = D = 21,875 nos.

No. of working days N = 350 days

Daily demand = D / N = 21875 / 350 = 62.5 nos.

Daily production = p = 200 units

Set-up cost = S = $25

Annual storage cost = H = $17.50

Lead time = LT = 2 days

Safety stock = SS = 10 nos.

Economic Production Order quantity = = = 301.51

Minimum inventory = 0 nos.

Maximum inventory = = = 207.29 nos.

Average inventory = (Max. Inventory + Min Inventory) / 2 = (207.29 + 0) / 2 = 103.64 nos.

Re-order point = d * LT + SS = 62.5 * 2 + 10 = 135 nos.

Annual set-up cost = =   = $1813.79

Annual Holding cost = Average Inventory * H = 103.64 * 17.50 = $1813.79

Hence, we get answers as:

a) What is the optimal lot size for football production? 301.51 footballs

b) What is the minimum inventory level of footballs? 0 footballs

c) What is the maximum inventory level of footballs? 207.29 footballs

d) What is the average inventory level of footballs? 103.64 footballs

e) What is the reorder point in units?  135 footballs

f) What is the annual setup cost for football production? $1813.79

g) What is the annual holding cost for the football inventory? $1813.79


Related Solutions

You are the operations manager at, Sports Unlimited, a firm manufacturing sporting goods. Due to increasing...
You are the operations manager at, Sports Unlimited, a firm manufacturing sporting goods. Due to increasing demand for your products, you are looking into the possibility of outsourcing some of your operations to other countries. After an initial research you have identified 6 critical factors in your location decision. These are: stability of exchange rates, society value of quality work, availability of skilled work force, time orientation attitudes, availability of efficient transportation infrastructure, and government regulation of businesses. The countries...
You have been hired as a capital budgeting analyst by Advent Sports, a sporting goods firm...
You have been hired as a capital budgeting analyst by Advent Sports, a sporting goods firm that manufactures athletic shoes. The firm believes it can generate another $10 million per year over the next 10 years by investing $10 million in a new distribution system (which will be depreciated over the system's 10-year life to a salvage value of zero). The firm will also need an initial increase of $1 million in net working capital to take on this project....
Glades Sporting Goods Co. operates two divisions—the Winter Sports Division and the Summer Sports Division. The...
Glades Sporting Goods Co. operates two divisions—the Winter Sports Division and the Summer Sports Division. The following income and expense accounts were provided from the trial balance as of December 31, 20Y8, the end of the fiscal year, after all adjustments, including those for inventories, were recorded and posted: Sales—Winter Sports Division $33,022,500 Sales—Summer Sports Division 36,482,000 Cost of Goods Sold—Winter Sports Division 19,813,500 Cost of Goods Sold—Summer Sports Division 21,071,500 Sales Expense—Winter Sports Division 5,661,000 Sales Expense—Summer Sports Division...
Glades Sporting Goods Co. operates two divisions—the Winter Sports Division and the Summer Sports Division. The...
Glades Sporting Goods Co. operates two divisions—the Winter Sports Division and the Summer Sports Division. The following income and expense accounts were provided from the trial balance as of December 31, 20Y8, the end of the fiscal year, after all adjustments, including those for inventories, were recorded and posted: Sales—Winter Sports Division $10,505,000 Sales—Summer Sports Division 13,610,000 Cost of Goods Sold—Winter Sports Division 6,260,000 Cost of Goods Sold—Summer Sports Division 7,878,000 Sales expense—Winter Sports Division 1,665,000 Sales expense—Summer Sports Division...
Glades Sporting Goods Co. operates two divisions—the Winter Sports Division and the Summer Sports Division. The...
Glades Sporting Goods Co. operates two divisions—the Winter Sports Division and the Summer Sports Division. The following income and expense accounts were provided from the trial balance as of December 31, 20Y8, the end of the fiscal year, after all adjustments, including those for inventories, were recorded and posted: Sales—Winter Sports Division $10,540,000 Sales—Summer Sports Division 13,645,000 Cost of Goods Sold—Winter Sports Division 6,300,000 Cost of Goods Sold—Summer Sports Division 7,888,000 Sales expense—Winter Sports Division 1,660,000 Sales expense—Summer Sports Division...
Glades Sporting Goods Co. operates two divisions—the Winter Sports Division and the Summer Sports Division. The...
Glades Sporting Goods Co. operates two divisions—the Winter Sports Division and the Summer Sports Division. The following income and expense accounts were provided from the trial balance as of December 31, 20Y8, the end of the fiscal year, after all adjustments, including those for inventories, were recorded and posted: Sales—Winter Sports Division $10,525,000 Sales—Summer Sports Division 13,610,000 Cost of Goods Sold—Winter Sports Division 6,280,000 Cost of Goods Sold—Summer Sports Division 7,868,000 Sales expense—Winter Sports Division 1,650,000 Sales expense—Summer Sports Division...
Glades Sporting Goods Co. operates two divisions—the Winter Sports Division and the Summer Sports Division. The...
Glades Sporting Goods Co. operates two divisions—the Winter Sports Division and the Summer Sports Division. The following income and expense accounts were provided from the trial balance as of December 31, 20Y8, the end of the fiscal year, after all adjustments, including those for inventories, were recorded and posted: Sales—Winter Sports Division $12,600,000 Sales—Summer Sports Division 16,300,000 Cost of Goods Sold—Winter Sports Division 7,560,000 Cost of Goods Sold—Summer Sports Division 9,454,000 Sales Expense—Winter Sports Division 2,016,000 Sales Expense—Summer Sports Division...
Big Apple Sporting Goods is a retail store that sells a variety of sports equipment. The...
Big Apple Sporting Goods is a retail store that sells a variety of sports equipment. The company's fiscal year ends on December 31. Information to be used for the operating budget this coming year follows. Sales and Merchandise Purchases Budget Information • Sales for this coming year ending December 31 are expected to be as follows: First quarter: $600,000 Second quarter: $650,000 Third quarter: $660,000 Fourth quarter: $800,000 • Cost of goods sold is 40 percent of sales (this is...
Golding Manufacturing, a division of Farnsworth Sporting, Inc., produces two different models of bows and eight...
Golding Manufacturing, a division of Farnsworth Sporting, Inc., produces two different models of bows and eight models of knives. The bow-manufacturing process involves the production of two major subassemblies: the limbs and the handle. The limbs pass through four sequential processes before reaching final assembly: lay-up, molding, fabricating, and finishing. In the Lay-Up Department, limbs are created by laminating layers of wood. In Molding, the limbs are heat treated, under pressure, to form a strong resilient limb. In the Fabricating...
SportChek is Canada’s largest retailer of sporting goods and sports apparel and footwear, with over 130...
SportChek is Canada’s largest retailer of sporting goods and sports apparel and footwear, with over 130 stores across the country. Assume one of the SportChek stores reported current assets of $87,000 and its current ratio was 1.76. Assume that the following transactions were completed: Paid $6,100 on accounts payable. Purchased a delivery truck for $9,500 cash. Wrote off a bad account receivable for $2,100. Paid previously declared dividends in the amount of $24,000. Required: Compute the updated current ratio. (Round...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT