Question

In: Finance

The following inventory data have been established for the Thompson Company: Annual sales are 338,000 units...

  1. The following inventory data have been established for the Thompson Company:
    1. Annual sales are 338,000 units and orders must be placed in multiples of 100 units.
    2. The purchase price per unit is KES 600 and carrying cost is 20% of the purchase price of goods.
    3. Fixed order cost is KES 4,800.
    4. Three days are required for delivery while one year has 300 working days.

Required:

  1. How many orders should Thompson Company place each year?
  2. At what inventory level should an order be made?
  3. Calculate the total cost of ordering and carrying inventories if the order quantity is EOQ.

Solutions

Expert Solution

(i) Annual Demand = D = 338000/year
Ordering Cost = Co = $4800
Holding Cost = Cc = $120
Economic Order Quantity Q* = √(2DCo/Cc) = √(2*338000*4800*/120) = 5200
Number of Orders = D/Q* = 338000/5200 = 65

(ii) Reorder Point = dL,
where d = daily demand = 338000/300
L = lead time = . 3 days
Hence, Reorder point = (338000/300)*3 = 3380

(iii) Inventory Holding cost = average inventory * unit carrying cost = (Q*/2)*Cc = (5200/2)*120 = $312,000
Order cost = Number of orders * cost/order = (D/Q*)*Co = (338000/5200)*4800 = $312,000
Total Cost = Annual Inventory Holding Cost + Annual Order Cost = 312000 + 312000 = $624,000


Related Solutions

The following data concerns inventory and purchases at Muse Company. Inventory, January 1 92 units at...
The following data concerns inventory and purchases at Muse Company. Inventory, January 1 92 units at $105 Purchases: January 6 62 units at $104 January 15 47 units at $104 January 22 37 units at $98 Inventory, January 31 91 units Determine the cost of the ending inventory on January 31 under the average cost method. Determine the cost of the ending inventory on January 31 under the first in, first out (FIFO) method. Determine the cost of the ending...
Assume the following data for Kruger Sales for November 2013: Beginning inventory Nov. 15 units at...
Assume the following data for Kruger Sales for November 2013: Beginning inventory Nov. 15 units at $90 each Sale Nov. 33 units Nov. 6 purchase11 units at $95 each Sale Nov. 84 units Sale Nov. 93 units Requirement 1: calculate ending inventory and COGS for Kruger Sales assuming FIFO Requirement 2: calculate ending inventory and COGS for Kruger Sales assuming Weighted Average
The following annual per unit cost data at an activity level of 4,000 units has been...
The following annual per unit cost data at an activity level of 4,000 units has been provided below. The company produces and sells only one product.: $ Per Unit Sales 400.00 Direct labor 18.00 Direct material 22.00 Variable manufacturing overhead 4.00 Fixed manufacturing overhead 20.00 Variable selling expenses 2.00 Fixed selling expenses 5.00 Fixed administrative expenses 3.00 The relevant range is 2,500 - 5,500 units. You will be given facts for three different options. Using the facts given, calculate amounts...
Beginning inventory, purchases, and sales data for hammers are as follows: Mar. 3rd inventory 12 units...
Beginning inventory, purchases, and sales data for hammers are as follows: Mar. 3rd inventory 12 units @ $15 11 purchase 13 units @ $17 14 sale 18 units 21 purchase 9 units @ $20 25 sale. 10 units assuming the business maintains a perpetual inventory system, complete the inventory cards and calculate the cost of goods Sold and ending inventory under the following assumptions a. First–in, first-out Balances costs of goods sold $ ending inventory $ b. Last-in, first-out Balances...
Suppose we have the following annual sales data for an automobile dealership: Year                Sales            &nb
Suppose we have the following annual sales data for an automobile dealership: Year                Sales                Trend 2009                121                     1 2010                187                     2 2011                165                     3 2012                134                     4 2013                155                     5 2014                167                     6 2015                200                     7 2016                206                     8 2017                221                    9 2018                231                 10 We want to forecast sales for 2019 and 2020 using either a simple trend model or a quadratic trend model. Use a within sample forecasting technique to...
Suppose we have the following annual sales data for an automobile dealership: Year                Sales            &n
Suppose we have the following annual sales data for an automobile dealership: Year                Sales                Trend 2009                121                     1 2010                187                     2 2011                165                     3 2012                134                     4 2013                155                     5 2014                167                     6 2015                200                     7 2016                206                     8 2017                221                    9 2018                231                 10 We want to forecast sales for 2019 and 2020 using either a simple trend model or a quadratic trend model. Use a within sample forecasting technique to...
Bad Company has a new 4-year project that will have annual sales of 9,000 units. The...
Bad Company has a new 4-year project that will have annual sales of 9,000 units. The price per unit is $20.50 and the variable cost per unit is $8.25. The project will require fixed assets of $100,000, which will be depreciated on a 3-year MACRS schedule. The annual depreciation percentages are 33.33 percent, 44.45 percent, 14.81 percent, and 7.41 percent, respectively. Fixed costs are $40,000 per year and the tax rate is 34 percent. What is the operating cash flow...
Bad Company has a new 4-year project that will have annual sales of 9,800 units. The...
Bad Company has a new 4-year project that will have annual sales of 9,800 units. The price per unit is $21.30 and the variable cost per unit is $9.05. The project will require fixed assets of $108,000, which will be depreciated on a 3-year MACRS schedule. The annual depreciation percentages are 33.33 percent, 44.45 percent, 14.81 percent, and 7.41 percent, respectively. Fixed costs are $48,000 per year and the tax rate is 40 percent. What is the operating cash flow...
The following standards for variable overhead have been established for a company that makes only one...
The following standards for variable overhead have been established for a company that makes only one product: Standard hours per unit of output: 5.5 hours Standard variable overhead rate: $14.00 per hour The following data pertain to operations for the last month: Actual hours: 9,200 hours Actual total variable overhead cost: $125,100 Actual output: 1,660 units a. What is the variable overhead rate variance for the month? (Input the amount as a positive value. Leave no cells blank - be...
Beginning inventory, purchases and sales data for T-shirts are as follows: April 3 Inventory 24 units...
Beginning inventory, purchases and sales data for T-shirts are as follows: April 3 Inventory 24 units @ $10 11 Purchase 26 units @ $12 14 Sale 36 units 21 Purchase 18 units @ $15 25 Sale 20 units Assuming the business maintains a periodic inventory system; calculate the cost of merchandise sold and ending inventory under the following assumptions: FIFO LIFO Average cost In your computations, round the average cost per unit to two decimal places and round your final...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT