Question

In: Operations Management

Michigan State Figurine Inc. (MSF) sells crystal figurines to Spartan fans. MSF buys the figurines from...

Michigan State Figurine Inc. (MSF) sells crystal figurines to Spartan fans. MSF buys the figurines from a manufacturer for $12 per unit. They send orders electronically to the manufacturer, costing $25 per order and they experience an average lead time of seven days for each order to arrive from the manufacturer. Their inventory carrying cost is 20 percent. The average daily demand for the figurines is four units per day. They are open for business 250 days a year. Answer the following questions:

a. How many units should the firm order each time? Assume there is no uncertainty at all about the demand or the lead time. (Do not round intermediate calculations. Round your answer to the nearest whole number.)

b.
How many orders will they place in a year? (Use your rounded answer from Part a. Round your answer to 2 decimal places.)

c.
What is the average inventory? (Use your rounded answer from Part a. Round your answer to 1 decimal place.)

d.
What is the annual ordering cost? (Use your rounded answer from Part b. Round your answer to 2 decimal places.)

e.
What is the annual inventory carrying cost? (Use your rounded answer from Part a. Round your answer to 2 decimal places.)

Solutions

Expert Solution

Given data:

cost per unit = $12

per order cost = $25

Holding cost is 20% i.e. 0.2*12 = $2.4

Daily demand = 4 units

Days in year are 250

Thus, Annual demand = 4*250 = 1000 units

1.) Order size,

To minimize the total ordering and holding cost, they should follow Economic order quantity

EOQ =

Here, D is annual demand,

S is per order cost and

H is inventory carrying cost

EOQ = =

EOQ = 144.33 or 145 units

Thus order size should be 145 units

2.) No. of orders = =

No. of orders = 6.89

Thus, no. of orders placed is 6.89

3.) Average Inventory =

Average inventory = =  72.5 units

Thus, average inventory is 72.5 units

4) Annual ordering cost = No. of orders * cost per order

Annual ordering cost = 6.89 * 25 = 172.25

Thus annual ordering cost is $172.25

5) Annual Inventory carrying cost = Avg inventory * per unit holding cost

Annual Inventory carrying cost =

Annual Inventory carrying cost = = 174

Thus annual inventory carrying cost is $174


Related Solutions

Michigan State Figurine Inc. (MSF) sells crystal figurines to Spartan fans. MSF buys the figurines from...
Michigan State Figurine Inc. (MSF) sells crystal figurines to Spartan fans. MSF buys the figurines from a manufacturer for $34 per unit. They send orders electronically to the manufacturer, costing $62 per order and they experience an average lead time of nine days for each order to arrive from the manufacturer. Their inventory carrying cost is 20 percent. The average daily demand for the figurines is two units per day. They are open for business 250 days a year. The...
Michigan State Figurine Inc. (MSF) sells crystal figurines to Spartan fans. MSF buys the figurines from...
Michigan State Figurine Inc. (MSF) sells crystal figurines to Spartan fans. MSF buys the figurines from a manufacturer for $21 per unit. They send orders electronically to the manufacturer, costing $35 per order and they experience an average lead time of eight days for each order to arrive from the manufacturer. Their inventory carrying cost is 20 percent. The average daily demand for the figurines is four units per day. They are open for business 250 days a year. The...
Spartan Corporation manufactures quidgets at its plant in Sparta, Michigan. Spartan sells its quidgets to customers...
Spartan Corporation manufactures quidgets at its plant in Sparta, Michigan. Spartan sells its quidgets to customers in the United States, Canada, England, and Australia. Spartan markets its products in Canada and England through branches in Toronto and London, respectively. Spartan reported total gross income on U.S. sales of $15,000,000 and total gross income on Canadian and U.K. sales of $5,000,000, split equally between the two countries. Spartan paid Canadian income taxes of $600,000 on its branch profits in Canada and...
Spartan Corporation manufactures quidgets at its plant in Sparta, Michigan. Spartan sells its quidgets to customers...
Spartan Corporation manufactures quidgets at its plant in Sparta, Michigan. Spartan sells its quidgets to customers in the United States, Canada, England, and Australia. Spartan markets its products in Canada and England through branches in Toronto and London, respectively. Spartan reported total gross income on U.S. sales of $15,000,000 and total gross income on Canadian and U.K. sales of $5,000,000, split equally between the two countries. Spartan paid Canadian income taxes of $600,000 on its branch profits in Canada and...
Spartan Corporation manufactures quidgets at its plant in Sparta, Michigan. Spartan sells its quidgets to customers...
Spartan Corporation manufactures quidgets at its plant in Sparta, Michigan. Spartan sells its quidgets to customers in the United States, Canada, England, and Australia. Spartan markets its products in Canada and England through branches in Toronto and London, respectively. Title transfers in the United States on all sales to U.S. customers and abroad (FOB: destination) on all sales to Canadian and English customers. Spartan reported total gross income on U.S. sales of $11,400,000 and total gross income on Canadian and...
Corporation manufactures quidgets at its plant in Sparta, Michigan. Spartan sells its quidgets to customers in...
Corporation manufactures quidgets at its plant in Sparta, Michigan. Spartan sells its quidgets to customers in the United States, Canada, England, and Australia. Spartan markets its products in Canada and England through branches in Toronto and London, respectively. Spartan reported total gross income on U.S. sales of $15,000,000 and total gross income on Canadian and U.K. sales of $5,000,000, split equally between the two countries. Spartan paid Canadian income taxes of $600,000 on its branch profits in Canada and U.K....
Michigan and Michigan State play each other this Saturday in football. Based on data from ESPN,...
Michigan and Michigan State play each other this Saturday in football. Based on data from ESPN, Michigan averages 38.1 points per game with a SD of 8.4 and average 424 yards gained per game with a SD of 72. The correlation between points scored and yards gained is 0.68. Thus: Average points = 38.1, SD= 8.4 Average yards gained = 424, SD= 72, r = 0.68 Find the slope of the regression equation for predicting number of points scored based...
C) currently sells its microbrews in a seven-state area: Illinois, Indiana, Michigan, Minnesota, Mississippi, Ohio, and...
C) currently sells its microbrews in a seven-state area: Illinois, Indiana, Michigan, Minnesota, Mississippi, Ohio, and Wisconsin. The company’s marketing department has collected data from its distributors in each state. This data consists of the quantity and price (per case) of microbrews sold in each state, as well as the average income (in thousands of dollars) of consumers living in various regions of each state. The data for each state are available via the link below--please note there are multiple...
The state of Michigan has just changed one of its toll roads from human collection of...
The state of Michigan has just changed one of its toll roads from human collection of tolls to machine collection. The idea behind the change was to allow traffic to flow more smoothly through the toll plaza. With human attendants, the mean number of cars passing through the toll plaza was 1,253 per hour. A random sample of 100 hours under the new machine system of toll collection shows a mean of 1,261, with a standard deviation of 59. Present...
Electronics Inc. buys and sells photocopy equipment that are used in businesses across Ontario. The company...
Electronics Inc. buys and sells photocopy equipment that are used in businesses across Ontario. The company follow IFRS. Unit selling prices range from $10,000 to $100,000. Electronic Inc. sells a photocopy system to Centennial College on September 10th, 2020. The selling price for the photocopy equipment is usually $85,500. - Electronic Inc. will also install the photocopy system. The estimated fair value of installing the photocopy system is $2,700. Electronic Inc. will also provide one year of maintenance service for...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT