Business Homework Solutions
Problem
#12427

suppy chain

In European Metals, we examined a "cyclic schedule," in which we produce each item in turn, until all items have been produced; then we start over at the beginning. Refer to the EuroMet spreadsheet.

a. If you increase the slack required from 0.05 to 0.075 (EuroMet cell E31), the costs (see Cost Comparison worksheet) go down. This is surprising since inventory cost increases. The reason for the reduction is that the setup cost and other costs would imply an EOQ value of around 2361, greater than the current value of 1918 (cycle time in hours, 92.76, times demand per hour, 20.68).

Use the total setup cost of 24 items times 0.5 hour per setup times $160 per hour of setup; also use the total demand rate per hour for all items of 20.68, and the inventory cost per hour per unit of $480*0.26/(365*24).

Compute the EOQ for the overall cycle; i.e., act as if the demand was for one aggregate item. Verify the 2361 value. Then, how many days of supply is that; that is, what cycle time is implied?

Attached file(s):
Attachments
EuroMet.xls  View File
Solution
What is this?
By OTA - Overall OTA Rating
Purchase Cost Now
$2.19 CAD (was ~$31.92)
Included in Download
  • Plain text response
$2.19 Instant Download
Add to Cart
Why you can trust BrainMass.com
  • Your Information is Secure
  • Best Online Academic Help Service
  • Students find real academic Success
Related Solutions
  • Inventories and ratios - Which is true and WHY? Which of the following is correct? a) A reduction in inventories held would have no effect on the current ratio. b) An increase in inventories would have no effect on the ...
  • e5-8 - In a comparison of 2005 to 2004 performance, Neir Company's inventory turnover increased substantially, although sales and inventory amounts were essentially unchanged. Required: Which of the fo ...
  • Inventory and Earnings - If net earnings equal: Net Sales - Cost of goods sold - SG&A, how mathematically would changes in inventory levels effect earnings?
  • Spreadsheet Analysis of the EOQ at the Neighborhood Pharmacy, Inc. - Spreadsheet Analysis of the EOQ at the Neighborhood Pharmacy, Inc. During the relevant planning period, the per unit purchase cost for an important prescribed (ethical) drug is P=$4, the total est ...
  • Inventory turnover comparison to industry leaders: Widget Inc. - Widget inc wants to compare its inventory turnover to those of industry leaders, who have turnover of 13 times per year and 8% of their assets invested in inventory. a. what is widget inc inventor ...
Browse