Question

In: Accounting

There is a retailer called "The Coop", which carries a wide variety of products with MIT's...

There is a retailer called "The Coop", which carries a wide variety of products with MIT's name and logo: shirts, caps, keychains, pens... you name it! Anything from golf balls and teddy bears to pocket protectors and jewelry. With a store inside MIT's Student Center, and another one in the popular Kendall Square, across the street from MIT campus, The Coop is a favorite stop for casual MIT visitors, current students and their relatives, and nostalgic alumni.

The Coop carries a line of products that feature MIT's official seal cast in a jewelry-grade steel. The same seal (about the size of a coin) is used in multiple finished goods, such as necklaces, tie pins, cufflinks, and paperweights. The Coop is considering introducing in 2018 a new line of products featuring MIT's seal cast in 18 karat gold. These seals would be used in upscale jewelry, and as an ornament in the diploma frames that sell especially during commencement season.

Based on their experience with similar products in the past, The Coop has projected the following demand for gold MIT seals for each month of 2018.

January February March April
1300 300 600 500
May June July August
2000 5500 1800 1400
September October November December
600 500 1000 2500

The seals would be produced, under license, by Seventh Seal, a specialty manufacturer of commemorative seals cast in precious metals, located in Syracuse, New York. Seventh Seal has offered to produce the gold MIT seals exclusively for The Coop. Seventh Seal has explained to The Coop that there is a cost to setting up the equipment to produce the gold MIT seal. Because of this, Seventh Seal will charge The Coop a set-up cost of $1417.5 every time the MIT seal is produced.

Because of the high set-up cost, one of the managers at The Coop proposes doing all the seals that will be needed for 2018 in a one-time production batch. "This will save us a lot of money in set-up costs", he says.

Another manager, however, warns that - because the gold seals are expensive - there is an associated holding cost. The Coop estimates that the holding cost will be about $0.21000000000000002 per seal per month (the dot is a decimal mark).

Because of the high holding costs, that manager proposes doing monthly batches in the amount of seals that will be required that month, according to the demand projection. "This will save us a lot of money in holding costs", she says.

What are the total costs (e.g. the sum of set-up costs and holding costs) of producing the gold seals using a fixed economic order quantity (FOQ) vs periodic order quantity (POQ)?

Solutions

Expert Solution

2018 Seal demands projection
Month Qty Average Monthly Inventory on periodic order basis=Monthly demand/2
Jan               1,300                   650
Feb                  300                   150
Mar                  600                   300
Apr                  500                   250
May               2,000                1,000
Jun               5,500                2,750
Jul               1,800                   900
Aug               1,400                   700
Sep                  600                   300
Oct                  500                   250
Nov               1,000                   500
Dec               2,500                1,250
Yearly Demand             18,000                9,000
A .EOQ Ordering
EOQ
Details
Annual usgae             18,000
Set Up cost per Production order $     1,417.50
Holding cost per unit per year=0.210*12 $             2.52
EOQ = Sq Root of [(2*Set up cost*Annual usage)/(Annual Holding cost per unit]
EOQ= Sq Rt [(2*1417.5*18000)/2.52]
EOQ =4500
So no of Orders in a year=18000/4500=4
Total Set up cost in a year =4-1417.5= $5,670
EOQ =4500
So average annual Inventory =4500/2= 2250
Annual Inventory Holding cost =2250*2.52= $5,670
Total annual set up and holding cost = $11,340
B. Periodic Order
No of orders in a year= 12
Yearly Set Up cost=12*1417.5= $        17,010
Average monthly Inventory holding =9000 units
Monthly holding cost/unit= $0.21
Annual Holding cost=9000*0.210= $1,890.00
Total Annual Cost =Set Up +Holding cost= $18,900

Related Solutions

There is a retailer called "The Coop", which carries a wide variety of products with MIT's...
There is a retailer called "The Coop", which carries a wide variety of products with MIT's name and logo: shirts, caps, keychains, pens... you name it! Anything from golf balls and teddy bears to pocket protectors and jewelry. With a store inside MIT's Student Center, and another one in the popular Kendall Square, across the street from MIT campus, The Coop is a favorite stop for casual MIT visitors, current students and their relatives, and nostalgic alumni. The Coop carries...
2. Airbiz Food Products produces a wide variety of food and related products. The? company's tomato-canning...
2. Airbiz Food Products produces a wide variety of food and related products. The? company's tomato-canning operation relies partly on tomatoes grown on Airbiz?'s own farms and partly on tomatoes bought from other growers. Airbiz?'s tomato farm is on the edge of? Sharpestown, a? fast-growing, medium-sized city. It produces 14 million pounds of tomatoes a year and employs 58 persons. The annual costs of tomatoes grown on this farm are as? follows: Variable production costs $605,000 Fixed production costs 1,250,000...
Problem 13-12 Pronghorn Music Emporium carries a wide variety of musical instruments, sound reproduction equipment, recorded...
Problem 13-12 Pronghorn Music Emporium carries a wide variety of musical instruments, sound reproduction equipment, recorded music, and sheet music. Pronghorn uses two sales promotion techniques—warranties and premiums—to attract customers. Musical instruments and sound equipment are sold with a 1-year warranty for replacement of parts and labor. The estimated warranty cost, based on past experience, is 1% of sales. The premium is offered on the recorded and sheet music. Customers receive a coupon for each dollar spent on recorded music...
Problem 13-12 Sunland Music Emporium carries a wide variety of musical instruments, sound reproduction equipment, recorded...
Problem 13-12 Sunland Music Emporium carries a wide variety of musical instruments, sound reproduction equipment, recorded music, and sheet music. Sunland uses two sales promotion techniques—warranties and premiums—to attract customers. Musical instruments and sound equipment are sold with a one-year warranty for replacement of parts and labor. The estimated warranty cost, based on past experience, is 2% of sales. The premium is offered on the recorded and sheet music. Customers receive a coupon for each dollar spent on recorded music...
Plano Products manufactures a wide variety of chemical compounds and liquids for industrial uses. The standard...
Plano Products manufactures a wide variety of chemical compounds and liquids for industrial uses. The standard mix for producing a single batch of 100 liters of its biggest selling product is as follows. Input Quantity Cost Total Chemical (in liters) (per liter) Cost Chem-A 22 $ 13 $ 286 Chem-B 62 14 868 Chem-C 41 20 820 125 $ 1,974 There is a standard 20 percent loss in liquid volume during processing due to evaporation. The finished liquid is put...
A Corporation manufactures and sells a wide variety of packaging products. Performance reports are prepared monthly...
A Corporation manufactures and sells a wide variety of packaging products. Performance reports are prepared monthly for each department. The planning budget and flexible budget for the Production Department are based on the following formulas, where q is the number of labor-hours worked in a month: Cost Formulas Direct labor $16.50q Indirect labor $4,100 + $2.00q Utilities $5,100 + $0.70q Supplies $1,600 + $0.20q Equipment depreciation $18,600 + $3.00q Factory rent $8,200 Property taxes $2,800 Factory administration $13,800 + $0.80q...
Perkins Company manufacturers a wide variety of products in its Dallas Division. The Dallas plant was...
Perkins Company manufacturers a wide variety of products in its Dallas Division. The Dallas plant was created to be an efficient producerof standardized products made in long-production runs although both high and low volume products are now producted there . Annual volums range from severl thousand units for some products to fewer than 10 for others. In recent year, much of the Dallas plants usual business in high volume products ha been lost to competitiors who price aggressivley and who...
Acompany manufactures and sells a wide variety of products. Performance reports are prepared monthly for each...
Acompany manufactures and sells a wide variety of products. Performance reports are prepared monthly for each department. The planning budget and flexible budget for the Production Department are based on the following formulas, where q is the number of labor-hours worked in a month: Cost Formulas Direct labor $16.30q Indirect labor $4,200 + $1.80q Utilities $5,500 + $0.70q Supplies $1,600 + $0.20q Equipment depreciation $18,700 + $2.70q Factory rent $8,300 Property taxes $2,700 Factory administration $13,200 + $0.80q The Production...
An analytical method which can be applied in a wide variety of sample matrices is A....
An analytical method which can be applied in a wide variety of sample matrices is A. robust B. sensitive C. accurate D. selective
Packaging Solutions Corporation manufactures and sells a wide variety of packaging products. Performance reports are prepared...
Packaging Solutions Corporation manufactures and sells a wide variety of packaging products. Performance reports are prepared monthly for each department. The planning budget and flexible budget for the Production Department are based on the following formulas, where q is the number of labor-hours worked in a month: Cost Formulas Direct labor $16.30q Indirect labor $4,500 + $1.40q Utilities $5,400 + $0.60q Supplies $1,200 + $0.20q Equipment depreciation $18,300 + $2.90q Factory rent $8,100 Property taxes $2,400 Factory administration $13,000 +...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT