Construct a base-case spreadsheet model

Assignment Help Operation Management
Reference no: EM13230441

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?

Reference no: EM13230441

Questions Cloud

Describe the henderson-hasselbach equation : Using the Henderson-Hasselbach equation, calculate the volume of 0.10 M Na2HPO4 and 0.10 M NaH2PO4 that would be required to make 100.0 mL of a 0.10 M (total phosphate concentration i.e. HPO4 + H2PO4) buffer with a pH of 6.91.
Calculate the rms value of the phase currents : A balanced three-phase inductive load is supplied in steady state by a balanced three-phase voltage source with a phase voltage of 120 V rms. The load draws a total of 10 kW at a power factor of 0.85. Calculate the rms value of the phase currents
Calculate per-phase current that has to be carried by cables : It operates at a power factor of 0.85 (lagging) at its rated conditions. Calculate the per-phase current that has to be carried by the cables to the power electronics converter and the step-up transformer located at the base of the tower.
Explain a cylinder of compressed gas rolls off a boat : A cylinder of compressed gas rolls off a boat and falls to the bottom of a lake. Eventually it rusts and the gas bubbles to the surface. A chemist collects a sample of the gas with the idea of trying to identify the gas.
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.
Design a signal conditioning circuit using op amps : A wind speed sensor generates an output voltage that ranges between 10 to 55 mV when the wind speed varies from 0 to 120Km/Hr.The output of the sensor is connected to an Analog to Digital Converter (ADC) through a signal conditioning circuit.
Explain the dietary macronutrient composition : Given that protein requirement is 0.8 g / kg body weight, and assuming that your caloric requirement is 30 kcal / kg body weight  calculate the macronutrient content of your ideal diet
Determine the appropriate operating frequency and voltage : A three-phase induction motor has been tested, and has small stator resistance. At 230 V, 60 Hz, the motor produces 40 N-m at 1740 RPM.a) Given a 40 N-m load, input of 115 V and 30 Hz, what operating speed do you expect
Determine and compare the relevant cost odf each approach : Design a reorder point control system for this part, given the assigned P. How would you state the inventory control policy f the ROP>Q*?

Reviews

Write a Review

Operation Management Questions & Answers

  Determine potential hot spots

You have been asked to provide a system for making fresh brownies for a church youth group fund-raiser. Since you are known to be a student at UST, the Youth Council has asked you to plan the brownie project.

  How are the situations for ford and google companies

How are the situations for Ford and Google companies similar and different? What do you learn about strategy formulation from this comparison?

  What if anything should their supervisor do

Two employees speak Spanish to each other at work. Because they often giggle or laugh, some of their coworkers and a few patients think that they are being made fun of, and they do not like it. What, if anything, should their supervisor do?

  A quality analyst wants to construct a sample mean chart

A quality analyst wants to construct a sample mean chart for controlling a packaging process. He knows from past experience that the process standard deviation is two ounces

  Describe how much investment also debt to undertake

describe how much investment also debt to undertake during the next yr. Each dollar invested reduces the NPV of my organization by 10 cents also each dollar of debt increases the NPV by 50 cents.

  State the resources you believe have been overloaded

Many times a resource can become overloaded during a human resource project. State the resources you believe have been overloaded in your organization also give your opinion explain why resources become overloaded. Suggest some solutions to solve..

  The skills they must possess to be effective

the skills they must possess to be effective in the specific role of a manager for a new department within the service division

  What are the major trade-offs that must be considered

Describe the S&OP process. What are the major trade-offs that must be considered?

  Decide the number of employees that would be needed

Decide the number of employees that would be needed. The ice cream sales record for the past 12 quarters is provided in a table below. To assist her with her plans, develop the following forecasting models.

  How does a firm assess a new capital project

How does a firm assess a new capital project? How would models of project evaluation such as NPV and IRR incorporate changes in economic outlook?

  Describe the privacy requirements under hipaa

What are the privacy requirements under HIPAA? Explain why confidentiality of health information has been a controversial public policy issue. Give a real world example.

  Calculate the overall proportion of tourists

Calculate the overall proportion of "tourists" (cars with out-of-state plates). b. Calculate the LCL and UCL for these data

Free Assignment Quote

Assured A++ Grade

Get guaranteed satisfaction & time on delivery in every assignment order you paid with us! We ensure premium quality solution document along with free turntin report!

All rights reserved! Copyrights ©2019-2020 ExpertsMind IT Educational Pvt Ltd