The rate of consumption of an item is 20 units per year. The cost of procurement (i.e. placing an order and receiving the goods) per order is Rs. 40. The unit cost is Rs. 100. Inventory carrying cost is 0.16% and it depends upon the average stock. Use Model I to determine: (i) EOQ (ii) If lead time is 3 months, determine the reorder point

The rate of consumption of an item is 20 units per year. The cost of procurement (i.e. placing an order and receiving the goods) per order is Rs. 40. The unit cost is Rs. 100. Inventory carrying cost is 0.16% and it depends upon the average stock. Use Model I to determine: (i) EOQ (ii) If lead time is 3 months, determine the reorder point

EBK CONTEMPORARY FINANCIAL MANAGEMENT

14th Edition

ISBN:9781337514835

Author:MOYER

Publisher:MOYER

Chapter18: The Management Of Accounts Receivable And Inventories

Section: Chapter Questions

Problem 19P

See similar textbooks

Similar questions

Sterling Corporation has an EOQ of 5,000 units. The company uses an average of 500 units per day. An order to replenish the part requires a lead time of five days. Required: 1. Calculate the reorder point, using Equation 20.3. 2. Graphically display the reorder point, where the vertical axis is inventory (units) and the horizontal axis is time (days). Show two replenishments, beginning at time zero with the economic order quantity in inventory. 3. What if the average usage per day of the part is 500 units but a daily maximum usage of 575 units is possible? What is the reorder point when this demand uncertainty exists?
Ranger Industries has provided the following information at June 30: Other information: Average selling price, 196 Average purchase price per unit, 110 Desired ending inventory, 40% of next months unit sales Collections from customers: In month of sale20% In month after sale50% Two months after sale30% Projected cash payments: Inventory purchases are paid for in the month following acquisition. Variable cash expenses, other than inventory, are equal to 25% of each months sales and are paid in the month of sale. Fixed cash expenses are 40,000 per month and are paid in the month incurred. Depreciation on equipment is 2,000 per month. REQUIREMENT You have been asked to prepare a master budget for the upcoming quarter (July, August, and September). The components of this budget are a monthly sales budget, a monthly purchases budget, a monthly cash budget, a forecasted income statement for the quarter, and a forecasted September 30 balance sheet. The worksheet MASTER has been provided to assist you. Ranger Industries desires to maintain a minimum cash balance of 8,000 at the end of each month. If this goal cannot be met, the company borrows the exact amount needed to reach its goal. If the company has a cash balance greater than 8,000 and also has loans payable outstanding, the amount in excess of 8,000 is paid to the bank. Annual interest of 18% is paid on a monthly basis on the outstanding balance.
Ottis, Inc., uses 640,000 plastic housing units each year in its production of paper shredders. The cost of placing an order is 30. The cost of holding one unit of inventory for one year is 15.00. Currently, Ottis places 160 orders of 4,000 plastic housing units per year. Required: 1. Compute the annual ordering cost. 2. Compute the annual carrying cost. 3. Compute the cost of Ottiss current inventory policy. Is this the minimum cost? Why or why not?
Johnson Corporation had beginning inventory of 20,000 at cost and 35,000 at retail. During the year, it made net purchases of 180,000 at cost and 322,000 at retail. Johnson nude sales of 300,000. Assuming a price index of 100 at the beginning of the year and 110 at the end of the year, compute Johnsons ending inventory at cost using the dollar-value LIFO retail method.
When prices are rising (inflation), which costing method would produce the highest value for gross margin? Choose between first-in, first-out (FIFO); last-in, first-out (LIFO); and weighted average (AVG). Evansville Company had the following transactions for the month. Calculate the gross margin for each of the following cost allocation methods, assuming A62 sold just one unit of these goods for $10,000. Provide your calculations. A. first-in, first-out (FIFO) B. last-in, first-out (LIFO) C. weighted average (AVG)
Refer to Cornerstone Exercises 2.2 and 2.3. Next year, Pietro expects to produce 50,000 units and sell 49,300 units at a price of 12.50 each. Beginning inventory of finished goods is 42,500, and ending inventory of finished goods is expected to be 34,000. Total selling expense is projected at 26,000, and total administrative expense is projected at 134,000. Required: 1. Prepare an income statement in good form. Be sure to include the percent of sales column. 2. What if the cost of goods sold percentage for the past few years was 65 percent? Explain how management might react.
Click the Chart sheet tab. On the screen is a column chart showing ending inventory costs. During a deflationary period, which bar (A, B, or C) represents FIFO costing, which represents LIFO costing, and which represents weighted average? Explain your reasoning. On January 4 following year-end, Rio Enterprises received a shipment of 60 units of product costing 580 each. These units had been ordered by Del in December and had been shipped to him on December 27. They were shipped FOB shipping point. Revise the FIFOLIFO3 worksheet to include this shipment. Preview the printout to make sure that the worksheet will print neatly on one page, and then print the worksheet. Save the completed file as FIFOLIFOT. Using the FIFOLIFO3 file, prepare a 3-D bar (stacked) chart showing the cost of goods sold and ending inventory under each of the four inventory cost flow assumptions. No Chart Data Table is needed. Use the values in the Calculations Section of the worksheet for your chart. Enter your name somewhere on the chart. Save the file again as FIFOLIFO3. Print the chart.
Pedee Companys inventory turnover in days is 80 days. Which of the following actions could help to improve that ratio? a. Increase the sales price. b. Increase manufacturing costs. c. Reduce the cost of goods sold. d. Reduce average inventory. e. All of these.
Ottis, Inc., uses 640,000 plastic housing units each year in its production of paper shredders. The cost of placing an order is 30. The cost of holding one unit of inventory for one year is 15.00. Currently, Ottis places 160 orders of 4,000 plastic housing units per year. Required: 1. Compute the economic order quantity. 2. Compute the ordering, carrying, and total costs for the EOQ. 3. How much money does using the EOQ policy save the company over the policy of purchasing 4,000 plastic housing units per order?
Assume your company uses the periodic inventory costing method, and the inventory count left out an entire warehouse of goods that were in stock at the end of the year, with a cost value of $222,000. How will this affect your net income in the current year? How will it affect next years net income?
A company wishes to establish an EOQ for an item for which the annual demandis $800,000, the ordering cost is $32, and the cost of carrying inventory is 20%.Calculate the following:a. The EOQ in dollars.b. Number of orders per year.c. Cost of ordering, cost of carrying inventory, and total cost.d. How do the costs of carrying inventory compare with the costs of ordering?
What is the inventory conversion period for O'Brian's if it has sales of $320,000, an average inventory of $5,333 and a cash conversion cycle of 20 days? Assume the cost of sales is 55% of sales.