Reference no: EM13507144
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?
|
Prepare the consolidated financial statements for nanotech
: If the marketing software was undervalued by $20,000, what amounts for SoftPlus wouldappear in PanTech's December 31, 2013, consolidated financial statements?
|
|
Calculate the total cost using a one-month planning horizon
: 1. Calculate the total cost using a one-month planning horizon.
|
|
Calculate the moment of inertia of the barbell
: A barbell spins around a pivot at its center at A. The barbell consists of two small balls, each with mass 450 grams (0.45 kg), Calculate the moment of inertia I of the barbell
|
|
Calculate the total kinetic energy of the barbell
: A barbell spins around a pivot at its center at A. The barbell consists of two small balls, each with mass 450 grams (0.45 kg), at the ends of a very low mass rod of length d = 35 cm, calculate the total kinetic energy of the barbell
|
|
Assembles custom home computer system
: Custom Computers, Inc. assembles custom home computer system
|
|
What is cash flow from operating activities
: Consider the following: Net income = $10,000, depreciation expense = $2,000, accounts receivable increased by $700, inventory decreased by $400, and accounts payable increased by $300.
|
|
What is the moment of inertia of the device about its center
: Mounted on a low-mass rod of length 0.52 m are four balls. Two balls each of mass 0.89 kg, are mounted at opposite ends of the rod. What is the moment of inertia of the device about its center
|
|
Prepare the cost-of-goods-sold method
: Prepare the necessary December 31 entry under (a) the cost-of-goods-sold method and (b) the loss method.
|
|
What is the final intensity of the beam passing
: Unpolarized light with I=120 w/m^2 travels in the x direction and passes through a linearly polarizing film oriented in the z direction, What is the final intensity of the beam passing through all three polarizing films
|