Calculate the annual inventory holding costs based

Assignment Help Operation Management

Reference no: EM132247121

SHOW ALL THE FORMULAS IN AN EXCEL FORMAT AND ANSWER ALL QUESTIONS.

A manufacturing operation must periodically purchase bulk quantities of bolts. The bolts are purchased in boxes of 500 and are consumed at a constant rate. The operation expects to purchase 30,000 boxes over the coming year. Each box costs $150, the annual holding cost per box is $20, and the cost of placing an order is $240 (regardless of the quantity ordered). For the following questions, use the basic economic order quantity model (without quantity discounts).

1. What is the economic order quantity (in boxes)?

2. Calculate the annual inventory holding costs based on the average inventory level and annual holding cost per box.

3. Calculate the annual inventory ordering costs based on the number of orders expected to be placed during the coming year.

4. Create a data table showing the total inventory costs (only) for order quantities varying from 100 to 1050 (use a step size of 50).

5. Create a scatter chart (use the one with markers and smooth lines) showing how total inventory costs are a function of the order quantity. Be sure to label your axes appropriately.

Reference no: EM132247121

Questions Cloud

Make with regard to country of origin of rocking horses : What decision will U. S. Customs make with regard to the country of origin of the rocking horses? By what process will they arrive at that decision?

Find an interesting ethical dilemma related : Find an interesting ethical dilemma related to AI.

Where the skills approach of leadership will work : List one situation where the skills approach of leadership will work. List one situation where the skills approach of leadership will not work.

Compute the total of ordering and carrying costs for napkins : A restaurant purchases paper napkins in packages of 1000. Compute the total of ordering and carrying costs for napkins.

Calculate the annual inventory holding costs based : Calculate the annual inventory holding costs based on the average inventory level and annual holding cost per box.

Company producing custom-made teddy bears : A company producing custom-made teddy bears is considering several options for expanding their existing capacity.

Corporate social responsibility is good business : Discuss at least four different reasons why companies that are based on a foundation of corporate social responsibility (CSR) is good business?

What sources of power did the customer have : What sources of power did the customer have? What sources of power did you have?

What are potential weaknesses of swot analysis : What are potential weaknesses of SWOT analysis?

User Account

All Pages