Reference no: EM131004325
Custom Computers, Inc. assembles custom home computer systems. The heat sinks for the central processing units are bought for $12 each and are ordered in quantities of 1300 units. Annual demand is 5200 heat sinks, the annual inventory holding cost is $3 per unit, and the cost to place an order is estimated to be $50. Assume that demand occurs continuously through the year and that a new order is placed in time so the order arrives at the same time as the previous inventory runs out.
(a) Construct a base-case spreadsheet model to help analyze different order quantities. The primary output of interest is the total annual inventory-related cost, comprising total ordering cost and total holding cost. Holding cost can be applied to the average inventory level through the year. Given the assumption about continuously occurring demand and that orders arrive just in time, the average inventory level will be half of the order quantity.
(b) For the base-case order quantity of 1300 heat sinks, what is the average inventory level, the number of orders placed per year, the total annual inventory holding cost, the total annual ordering cost, and the total annual cost?
(c) Repeat (b) for an order quantity of 650 heat sinks. Repeat for 1950 heat sinks.
(d) The Economic Order Quantity (EOQ) is defined as the order quantity that minimizes total inventory-related costs. Construct a Data Table and an XY chart and find the EOQ for this situation.
(e) How much would ordering the EOQ save Custom Computers on an annual basis, compared to its current order quantity?
|
Why the sampling method and sample size make these results
: Discuss why the sampling method and sample size make these results questionable, even though the numbers were reported as if they were precise.
|
|
How many atoms of deuterium are present in regular water
: If atomic ratio of 2H (Deuterium) in H isotopes in regular water is 0.15%, how many atoms of Deuterium are present in regular water - how to solve differential equations and he does not know anything about nuclear engineering.
|
|
Learn from looking at data and reports
: What are some of the things managers can learn by walking around and having daily contact with line employees that they might not be able to learn from looking at data and reports?
|
|
Does the article adequately address an issue of diversity
: Relevance of article; does the article adequately address an issue of diversity and health? If only one element, points will not be awarded
|
|
Construct a base-case spreadsheet model
: Construct a base-case spreadsheet model to help analyze different order quantities. The primary output of interest is the total annual inventory-related cost, comprising total ordering cost and total holding cost.
|
|
European and north american freight transportation
: In 2-3 pages (not counting cover and references), compare and contrast the European and North American freight transportation systems, globalized trade, and global policy implications . Lastly, reviewing the future research, what part do you find ..
|
|
Analysis and a part of strategic formulation
: Why are directional strategies part of the situational analysis and a part of Strategic formulation.? How is strategy formulation related to the situational analysis.
|
|
Pros and cons of microsoft
: Discuss the pros and cons of Microsoft's most recent "I'm a PC" campaign. Is Microsoft doing a good thing by acknowledging Apple's campaign in its own marketing message? Why or why not?
|
|
Moral issue for the nurses caring for the patient
: Excellent examples. Do you feel that an ethical dilemma becomes more of a moral issue for the nurses caring for the patient? They are passing judgment based on their own personal values and beliefs, however, are wishes of the patient being fulfill..
|