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

Answer is given below


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