Question

In: Accounting

The office manager for the Gotham Life Insurance Company orders letterhead stationery from an office products...

The office manager for the Gotham Life Insurance Company orders letterhead stationery from an office products firm in boxes of 500 sheets. The company uses 6,500 boxes per year. Annual carrying costs are $3 per box, and ordering costs are $28. The following discount price schedule is provided by the office supply company: Order Quantity (in boxes) Price per Box 200-999 $16 1000-2999 14 3000-5999 13 6000+ 12 a. Determine the optimal order quantity and the total annual inventory cost. b. Determine the optimal order quantity and total annual inventory cost for boxes of stationery if the carrying cost is 20% of the price of a box of stationery. Please put answers in the excel format.

ORDERING ORDERING ORDERING ORDERING
EOQ          1,000          3,000      6,000
                  =
Average inventory =  
Annual carrying cost =
Number of orders =  
Annual order cost =  
Total inventory purchase cost
Total inventory cost =

Solutions

Expert Solution

a) Calculating optimal order quantity or EOQ :

EOQ = where A is Annual demand in units, B is ordering cost(per purchase order) and C is holding cost per unit, per year.

Where A = 6,500 boxes utilized per year

B = $28 and C = $3 per box, per year

EOQ =

   =

   =

   =348.33 i.e EOQ = 348 units

Computation of total annual inventory cost :

Particulars Ordering Ordering Ordering Ordering
EOQ i.e 348 1,000 3,000 6,000
Average inventory 174 500 1,500 3,000
Note: This is the sum of opening stock and closing stock divided by 2. Here it is sum of order size and closing inventory is zero, divided by 2. i.e 348/2 i.e 1000/2 i.e 3,000/2 i.e 6000/2
Annual Carrying cost(In $) 522 1,500 4,500 9,000
i.e 174*3 i.e 500*3 i.e 1,500*3 i.e 3000*3
Number of orders 19 7 3 2
Note : Number of orders is total boxes purchased for the year, divided by ordering quantity i.e 6500/348 = 18.68. Hence no. of orders is the next whole number i.e 19 i.e 6,500/1,000 = 6.5. Hence no. of orders is the next whole number i.e 7 i.e 6,500/3,000 = 2.17 i.e 3 i.e 6,500/6000 = 1.08 i.e 2
Annual order cost(In $) 532 196 84 56
i.e 19*28 i.e 7*28 i.e3*28 i.e 2*28
Total Inventory Purchase cost(In $) 5,568 14,000 39,000 72,000
(No. of boxes * price per box) i.e 348*16 i.e 1000*14 i.e 3000*13 i.e 6000*12
Total Inventory cost(In $) 6,622 15,696 43,584 81,056
(Total inventory purchase price + Annual Carrying cost + Annual order cost) i.e 5,568 + 522 + 532 i.e 14,000+1,500+196 i.e 39,000+4,500+84 i.e 72,000+9,000+56

b) EOQ when carrying cost is 20% of price of box of stationery :

Therefore carrying cost is 20% of $16 = $3.2

EOQ =

=

=337.26 i.e 337 units

Computation of total annual inventory cost :

Particulars Ordering Ordering Ordering Ordering
EOQ i.e 337 1,000 3,000 6,000
Average inventory 169 500 1,500 3,000
Note: This is the sum of opening stock and closing stock divided by 2. Here it is sum of order size and closing inventory is zero, divided by 2. i.e 337/2 i.e 1000/2 i.e 3,000/2 i.e 6000/2
Annual Carrying cost(In $) 541 1,600 4,800 9,600
i.e 169*3.2 i.e 500*3.2 i.e 1,500*3.2 i.e 3000*3.2
Number of orders 19 7 3 2
Note : Number of orders is total boxes purchased for the year, divided by ordering quantity i.e 6500/337 = 19.29. Hence no. of orders is the next whole number i.e 20 i.e 6,500/1,000 = 6.5. Hence no. of orders is the next whole number i.e 7 i.e 6,500/3,000 = 2.17 i.e 3 i.e 6,500/6000 = 1.08 i.e 2
Annual order cost(In $) 560 196 84 56
i.e 20*28 i.e 7*28 i.e 3*28 i.e 2*28
Total Inventory Purchase cost(In $) 5,568 14,000 39,000 72,000
(No. of boxes * price per box) i.e 348*16 i.e 1000*14 i.e 3000*13 i.e 6000*12
Total Inventory cost(In $) 6,669 15,796 43,884 81,656
(Total inventory purchase price + Annual Carrying cost + Annual order cost) i.e 5,568 + 560 + 541 i.e 14,000+1,600+196 i.e 39,000+4,800+84 i.e 72,000+9,600+56

Related Solutions

The office manager for the Gotham Life Insurance Company orders letterhead stationery from an office products...
The office manager for the Gotham Life Insurance Company orders letterhead stationery from an office products firm in boxes of 500 sheets. The company uses 6,500 boxes per year. Annual carrying costs are $3 per box, and ordering costs are $28. The following discount price schedule is provided by the office supply company: Order Quantity (in boxes) Price per Box 200-999 $16 1000-2999 14 3000-5999 13 6000+ 12 a. Determine the optimal order quantity and the total annual inventory cost....
The office manager for the Mankato Life Insurance company orders letterhead stationery from an office products...
The office manager for the Mankato Life Insurance company orders letterhead stationery from an office products firm. The companhy used 12000 boxes per year. Annual carrying cost is 30% of the price of a box of stationary, and ordering costs are $50 per order. The following discount price schedule is provided by the office company. Order Quantity (boxes) Price per box 1-1999 $1.50 2000-4999 1.40 5000-9999 1.10 10000 or higher 1.05 Determine the optimal quantity by showing all your work...
The office manager for the Metro Life Insurance Company ordersletterhead stationery from an office products...
The office manager for the Metro Life Insurance Company orders letterhead stationery from an office products firm in boxes of 500 sheets. The company uses 6500 boxes per year. Annual carrying costs are $3 per box, and ordering costs are $28. The following discount price schedule is provided by the office supply company: ORDER QUANTITY (BOXES) PRICE PER BOX  200–999  $16 1000–2999  14 3000–5999  13 6000+      12 Determine the optimal order quantity and the total annual inventory cost. 13.32 Determine...
A manager for an insurance company believes that customers have the following preferences for life insurance products:
A manager for an insurance company believes that customers have the following preferences for life insurance products: 30% prefer Whole Life, 30% prefer Universal Life, and 40% prefer Life Annuities. The results of a survey of 330 customers were tabulated. Is it possible to refute the sales manager's claimed proportions of customers who prefer each product using the data? Product Number Whole 109 Universal 96 Annuities 125   Step 1 of 10: State the null and alternative hypothesis. Answer  ...
Email assignment You are an office manager at an accounting firm looking for new stationery (not...
Email assignment You are an office manager at an accounting firm looking for new stationery (not “stationary”) and printed material; write to one of the printing companies you are considering and request information. Using full sentences, correct email format, and bullet points, write a 230-250-word request for information email. Make sure that you do the following: Include a subject line Use correct email format Include bullets that have been correctly written Organize using a direct pattern Use regular bullet points...
A manager for an insurance company believes that customers havethe following preferences for life insurance...
A manager for an insurance company believes that customers have the following preferences for life insurance products: 20% prefer Whole Life, 10% prefer Universal Life, and 70% prefer Life Annuities. The results of a survey of 200 customers were tabulated. Is it possible to refute the sales manager's claimed proportions of customers who prefer each product using the data?ProductNumberWhole94Universal68Annuities38Step 1 of 10: State the null and alternative hypothesis.Step 2 of 10: What does the null hypothesis indicate about the proportions...
A manager for an insurance company believes that customers have the following preferences for life insurance...
A manager for an insurance company believes that customers have the following preferences for life insurance products: 40 % prefer Whole Life, 20 % prefer Universal Life, and 40 % prefer Life Annuities. The results of a survey of 212 212 customers were tabulated. Is it possible to refute the sales manager's claimed proportions of customers who prefer each product using the data? product number whole 70 universal 50 annuities 92 state the null and alternative hypothesis What does the...
A manager for an insurance company believes that customers have the following preferences for life insurance...
A manager for an insurance company believes that customers have the following preferences for life insurance products: 20% prefer Whole Life, 20% prefer Universal Life, and 60% prefer Life Annuities. The results of a survey of 200 customers were tabulated. Is it possible to refute the sales manager's claimed proportions of customers who prefer each product using the data? Product Number Whole 36 Universal 58 Annuities 106 1. State the null and alternative hypothesis. 2. Determine which distribution to use...
A manager for an insurance company believes that customers have the following preferences for life insurance...
A manager for an insurance company believes that customers have the following preferences for life insurance products: 40% prefer Whole Life, 20% prefer Universal Life, and 40% prefer Life Annuities. The results of a survey of 209 customers were tabulated. Is it possible to refute the sales manager's claimed proportions of customers who prefer each product using the data? Product Number Whole 86 Universal 54 Annuities 69 Step 4 of 10: Find the expected value for the number of customers...
A manager for an insurance company believes that customers have the following preferences for life insurance...
A manager for an insurance company believes that customers have the following preferences for life insurance products: 20% prefer Whole Life, 20% prefer Universal Life, and 60% prefer Life Annuities. The results of a survey of 200 customers were tabulated. Is it possible to refute the sales manager's claimed proportions of customers who prefer each product using the data? Product Number Whole 36 Universal 58 Annuities 106 Step 1 of 10: State the null and alternative hypothesis. Step 2 of...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT