Question

In: Operations Management

Question Set A manufacturing operation must periodically purchase bulk quantities of bolts. The bolts are purchased...

Question Set

A manufacturing operation must periodically purchase bulk quantities of bolts. The bolts are purchased in boxes of 500 and are consumed at a constant rate. The operation expects to purchase 28,000 boxes over the coming year. Each box costs $140, the annual holding cost per box is $22, and the cost of placing an order is $170 (regardless of the quantity ordered). For the following questions, use the basic economic order quantity model (without quantity discounts).

1. What is the economic order quantity (in boxes)? (2pts)

2. Calculate the annual inventory holding costs based on the average inventory level and annual holding cost per box. (2pts)

3. Calculate the annual inventory ordering costs based on the number of orders expected to be placed during the coming year. (2pts)

4. Create a data table showing the total inventory costs (only) for order quantities varying from 100 to 1050 (use a step size of 50). You must use a data table structure to receive full credit for this problem. (8pts)

5. Create a scatter chart (use the one with markers and smooth lines) showing how total inventory costs are a function of the order quantity. Be sure to label your axes appropriately. (6pts)

Show work and in excel please

Solutions

Expert Solution

****Please please please LIKE THIS ANSWER, so that I can get a small benefit, Please****


Related Solutions

Show all work in Excel With formulas used in cells Question Set 2. A manufacturing operation...
Show all work in Excel With formulas used in cells Question Set 2. A manufacturing operation must periodically purchase bulk quantities of washers. The washers are purchased in boxes of 1000 and are consumed at a constant rate. The operation expects to purchase 20,000 boxes over the coming year. Each box costs $120, the annual holding cost per box is $15, and the cost of placing an order is $120 (regardless of the quantity ordered). For the following questions, use...
Samtech Manufacturing purchased land and building for $4 million. In addition to the purchase price, Samtech...
Samtech Manufacturing purchased land and building for $4 million. In addition to the purchase price, Samtech made the following expenditures in connection with the purchase of the land and building: Title insurance $ 21,000 Legal fees for drawing the contract 7,500 Pro-rated property taxes for the period after acquisition 41,000 State transfer fees 4,500 An independent appraisal estimated the fair values of the land and building, if purchased separately, at $3.9 and $1.1 million, respectively. Shortly after acquisition, Samtech spent...
samtech manufacturing purchased land and building for 3 million. In addition to the purchase price samtec...
samtech manufacturing purchased land and building for 3 million. In addition to the purchase price samtec made the following expenditures in connection with the purchase of the land and building. Title Insurance 30,000. Legal fees for drawing the contract 7000. Prorated property taxes for the. After acquisition 50,000. State transfer fees 5400. An independent appraisal estimated the fair values of the land and building if purchased separately at 3 and 1 million respectively shortly after acquisition samtec spent 96,000 to...
Samtech Manufacturing purchased land and building for $3 million. In addition to the purchase price, Samtech...
Samtech Manufacturing purchased land and building for $3 million. In addition to the purchase price, Samtech made the following expenditures in connection with the purchase of the land and building: Title insurance $ 17,000 Legal fees for drawing the contract 5,500 Pro-rated property taxes for the period after acquisition 37,000 State transfer fees 4,100 An independent appraisal estimated the fair values of the land and building, if purchased separately, at $3 and $1 million, respectively. Shortly after acquisition, Samtech spent...
Samtech Manufacturing purchased land and building for $4 million. In addition to the purchase price, Samtech...
Samtech Manufacturing purchased land and building for $4 million. In addition to the purchase price, Samtech made the following expenditures in connection with the purchase of the land and building: Title insurance $ 19,000 Legal fees for drawing the contract 6,500 Pro-rated property taxes for the period after acquisition 39,000 State transfer fees 4,300 An independent appraisal estimated the fair values of the land and building, if purchased separately, at $3.7 and $1.3 million, respectively. Shortly after acquisition, Samtech spent...
Samtech Manufacturing purchased land and building for $4 million. In addition to the purchase price, Samtech...
Samtech Manufacturing purchased land and building for $4 million. In addition to the purchase price, Samtech made the following expenditures in connection with the purchase of the land and building: Title insurance $ 33,000 Legal fees for drawing the contract 8,500 Pro-rated property taxes for the period after acquisition 53,000 State transfer fees 5,700 An independent appraisal estimated the fair values of the land and building, if purchased separately, at $3 and $2 million, respectively. Shortly after acquisition, Samtech spent...
Samtech Manufacturing purchased land and building for $4 million. In addition to the purchase price, Samtech...
Samtech Manufacturing purchased land and building for $4 million. In addition to the purchase price, Samtech made the following expenditures in connection with the purchase of the land and building: Title insurance $ 16,000 Legal fees for drawing the contract 5,000 Pro-rated property taxes for the period after acquisition 36,000 State transfer fees 4,000 An independent appraisal estimated the fair values of the land and building, if purchased separately, at $3.3 and $1.1 million, respectively. Shortly after acquisition, Samtech spent...
Semtech Manufacturing purchased land and building for $4 million. In addition to the purchase price, Semtech...
Semtech Manufacturing purchased land and building for $4 million. In addition to the purchase price, Semtech made the following expenditures in connection with the purchase of the land and building: Title insurance $ 25,000 Legal fees for drawing the contract 9,500 Pro-rated property taxes for the period after acquisition 45,000 State transfer fees 4,900 An independent appraisal estimated the fair values of the land and building, if purchased separately, at $3 and $2 million, respectively. Shortly after acquisition, Semtech spent...
Samtech Manufacturing purchased land and building for $4 million. In addition to the purchase price, Samtech...
Samtech Manufacturing purchased land and building for $4 million. In addition to the purchase price, Samtech made the following expenditures in connection with the purchase of the land and building: Title insurance $ 34,000 Legal fees for drawing the contract 9,000 Pro-rated property taxes for the period after acquisition 54,000 State transfer fees 5,800 An independent appraisal estimated the fair values of the land and building, if purchased separately, at $3.5 and $1.5 million, respectively. Shortly after acquisition, Samtech spent...
Samtech Manufacturing purchased land and building for $3 million. In addition to the purchase price, Samtech...
Samtech Manufacturing purchased land and building for $3 million. In addition to the purchase price, Samtech made the following expenditures in connection with the purchase of the land and building: Title insurance $ 23,000 Legal fees for drawing the contract 8,500 Pro-rated property taxes for the period after acquisition 43,000 State transfer fees 4,700 An independent appraisal estimated the fair values of the land and building, if purchased separately, at $3 and $2 million, respectively. Shortly after acquisition, Samtech spent...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT