Plot total fixed order costs total inventory carrying costs

Assignment Help Operation Management

Reference no: EM131278199

Assume that company XYZ sells metal racks. The company estimates that the demand for metal racks is approximately 20 units per week. The unit cost of the racks is $350, but the metalworking shop charges a fixed cost of 8500 per order to cover the cost of setup for the XYZ's order. The XYZ company estimates that the cost of carrying one dollar worth of item over one year is $0.1. Given above

Please plot (using Excel) the total fixed order costs, total inventory' carrying costs and total relevant costs {i.e., the sum of total fixed costs and total inventory carrying costs) as a function of replenishment order quantity. And indicate the minimum of the total relevant cost function and the replenishment quantity corresponding to that minimum cost.

Use the EOQ formula and find optimal replenishment quantity to verify your results in part a.

Reference no: EM131278199

Questions Cloud

What is marignal coat of prodcusing one more unit of product : The following linear programming problem. what will happen to product x4 to justify its prodctuion? what is value of surplus associated with constarint 3? what is marignal coat of prodcusing one more unit of product 3?

Defining the decision variables-objective function : An advertising campaign for a new breakfast bar will be conducted in Baltimore area and may use TV commercials, radio commercials, and newspaper commercials. If the number of TV commercials cannot exceed the number of radio commercials by more than 4..

Identify problem in your current job or a previous job : Identify a problem in your current job or a previous job, such as inadequate use of technology, inefficient procedures, spotty customer service, poor product quality, low morale, or a personnel problem.

Fixed setup cost of ordering : Assume the following cost data is given for two items, X and Y, where A is the fixed setup cost of ordering (S), D is the demand per year (unit/year), v is the unit cost ($/unit) and v is the inventory carrying rate ($/$/year). Assuming that both X a..

Plot total fixed order costs total inventory carrying costs : Assume that company XYZ sells metal racks. The company estimates that the demand for metal racks is approximately 20 units per week. Please plot (using Excel) the total fixed order costs, total inventory' carrying costs and total relevant costs {i.e...

Company is considering creating-selling new type of cookies : A company is considering creating and selling a new type of cookies. Create a report explaining the research process that should be used by the company to make this decision. What is the research question? What data would you collect and how would yo..

Strategic analysis and situation analysis : Situation analysis. This will provide the background information for the sales presentation. It includes research findings About the company, customer, product, competition, marketplace, and consumers. Strategic analysis. Main problem or opportunity ..

Purchase of the mansion include the fireplace : Mrs. Rosenberry enters into a purchase and sale agreement for the sale of her mansion to Mr. Green. The house has a very large decorative gas fireplace, which Mrs. Rosenberry had specially designed. The fireplace is connected to the gas line in the h..

Identify two challenges facing the delivery of quality : Identify two challenges facing the delivery of quality in health care today. One of these must be financial in nature. Discuss ways in which the challenge can be overcome. What are the implications of implementing the solution?

User Account

All Pages