Question

In: Accounting

Widget Co. has the following data available relative to its investment in materials: Number of units...

Widget Co. has the following data available relative to its investment in materials: Number of units of material used annually 20,000 Number of workdays in a year 250 Cost of placing an order $20 Annual carrying cost per unit of inventory $5 Requirements: 1. Compute the economic order quantity (please show your work). EOQ=√(2*20*20,00)/5=400 2. Give some examples of order costs and carrying costs. Order costs: cost of placing a purchase order, cost of inspection of received batches, documentations costs, transporttion cost Carrying costs: 3. Using the above data, compute the order size that results in the minimum total order and carrying cost by completing the following table. Order Size Number of Orders Total Order Cost Average Inventory Total Carrying Cost Total Order and Carrying Costs \ 100 200 300 400 500 600 700 800

I do not understand how to calculate all those things with the information given. Can someone please tell me how to? Thank you

Solutions

Expert Solution

1. Economic Order Quantity =

= = 400 units.

2. Examples of ordering costs might be, cost of placing orders, order processing costs etc.

Examples of carrying costs might be, Storage cost, inventory insurance, loss of interest in money tied up in inventory.

3. Using the given data, the order size that results in the minimum total order and carrying cost can be witnessed in the following table:

You are given with the order sizes, to which you have to apply the above information. In the above information, we are given that total demand was 20,000 units. So number of orders can be found by dividing the annual demand by the order size.

Cost of order is given as $20, to know the total ordering cost, we need to multiply the total no. of orders with the ordering cost of $20.

Average inventory is the average of the opening and closing inventory. Since the order size is same, it can be taken as 50% of one order size.

Inventory carrying cost is given as $5 per unit. Total inventory carrying cost can be calculated by multiplying the average inventory with the carrying cost per unit.

Total ordering and carrying cost can be arrived by adding the total ordering cost and total carrying cost.

From the above table, we can witness that the total order and carrying cost is minimum with an order size of 400 units.

Hope it is helpful!!


Related Solutions

The following monthly data in contribution format are available for the MN Co. and its only...
The following monthly data in contribution format are available for the MN Co. and its only product: Total Per Unit Sales……………………………………………………………. $83,700 $279 Variable expenses………………………………………. 32,700 109 Contribution margin…………………………………… 51,000 $170 Fixed expenses……………………………………………. 40,000 Net operating income…………………………………. $11,000               The Company is currently selling 300 units of product per month. Required: (each point is separate) Management is contemplating the use of plastic gearing rather than metal gearing in its product. This change would reduce variable expenses by $18 per unit....
Assume that the following data relative to Eddy Company for 2021 is available: Net Income for...
Assume that the following data relative to Eddy Company for 2021 is available: Net Income for the year : $2,100,000; On Jan.1,there are 700 ,000 shares of common shares outstanding transactions in common shares: May purchase of 60,000 treasury shares June stock split 2-1 Nov issuance of 120,000 shares 8% Cumulative Convertible Preferred Stock: $1,000,000, convertible into 200,000 shares of common stock. (adjusted for split) Stock Options: exercisable to 60,000 shares of common stock at the price of $25 per...
Philips Company has the following data available Transaction Units purchased Unit cost Units sold Transaction 300...
Philips Company has the following data available Transaction Units purchased Unit cost Units sold Transaction 300 10 March 1 Purchase 200 12 April 25 sale 330 June 10 Purchase 370 14 July 20 sale 250 October 30 Purchase 340 11 December 15 sale 390 if Philips uses a perpetual FIFO inventory system, the cost of ending inventory on Dec 31 is I need the steps in the form of table
Potter Company has the following data​ available: Transaction Units Purchased Unit Cost Units Sold Beginning Inventory...
Potter Company has the following data​ available: Transaction Units Purchased Unit Cost Units Sold Beginning Inventory 500 ​$10 March 1 Purchase 200 ​$12 April 25 Sale 350 June 10 Purchase 300 ​$14 July 20 Sale 250 October 30 Purchase 300 ​$15 December 15 Sale 400 If Potter Company uses a perpetual movingminus average inventory​ system, the cost of goods sold for the year is​ ________. ​ (Round average cost per unit to four decimal places and all other numbers to...
Assume that the following data relative to Kane Company for 2018 is available: Net Income $2,790,000...
Assume that the following data relative to Kane Company for 2018 is available: Net Income $2,790,000 Transactions in Common Shares Change Cumulative Jan. 1, 2018, Beginning number 680,000 Mar. 1, 2018, Purchase of treasury shares (66,600) 613,400 June 1, 2018, Stock split 2-1 613,400 1,226,800 Nov. 1, 2018, Issuance of shares 234,000 1,460,800 6% Cumulative Convertible Preferred Stock Sold at par, convertible into 200,000 shares of common (adjusted for split). $1,000,000 Stock Options Exercisable at the option price of $25...
Assume that the following data relative to Kane Company for 2020 is available: Net Income                           &nbs
Assume that the following data relative to Kane Company for 2020 is available: Net Income                                                                                                                                                                                                                $2,100,000 Transactions in Common Shares Change Cumulative Jan. 1, 2020, Beginning number 700,000 Mar. 1, 2020, Purchase of treasury shares (60,000) 640,000 June 1, 2020, Stock split 2-1 640,000 1,280,000 Nov. 1, 2020, Issuance of shares 120,000 1,400,000 8% Cumulative Convertible Preferred Stock Sold at par, convertible into 200,000 shares of common (adjusted for split).    $1,000,000 Stock Options Exercisable at the option price...
Assume that the following data relative to Dakota Company for 2015 is available: Net Income $2,500,000...
Assume that the following data relative to Dakota Company for 2015 is available: Net Income $2,500,000 Jan. 1, 2015, Beginning number of Common Shares 600,000 Transactions in Common Shares in 2015 On February 1, the corporation purchased on the market 100,000 of its own outstanding shares. On May 1, the corporation declared and issued a 2-for-1 stock split. On August 1, the corporation issued 200,000 new shares to raise additional capital. On November 1, the corporation issued a 10% stock...
Assume that the following data relative to Kane Company for 2018 is available: Net Income $2,800,000...
Assume that the following data relative to Kane Company for 2018 is available: Net Income $2,800,000 Transactions in Common Shares Change Cumulative Jan. 1, 2018, Beginning number 650,000 Mar. 1, 2018, Purchase of treasury shares (55,200) 594,800 June 1, 2018, Stock split 2-1 594,800 1,189,600 Nov. 1, 2018, Issuance of shares 216,000 1,405,600 6% Cumulative Convertible Preferred Stock Sold at par, convertible into 190,000 shares of common (adjusted for split). $950,000 Stock Options Exercisable at the option price of $25...
Assume that the following data relative to Kane Company for 2015 is available: Net Income $2,800,000...
Assume that the following data relative to Kane Company for 2015 is available: Net Income $2,800,000 Jan. 1, 2015, Beginning number of Common Shares 700,000 Transactions in Common Shares in 2015 On April 1, the corporation purchased on the market 60,000 of its own outstanding shares. On July 1, the corporation declared and issued a 2-for-1 stock split. On October 1, the corporation issued 240,000 new shares to raise additional capital. The following dilutive securities were issued prior to 2015....
Assume that the following data relative to Kane Company for 2018 is available: Net Income $2,890,000...
Assume that the following data relative to Kane Company for 2018 is available: Net Income $2,890,000 Transactions in Common Shares Change Cumulative Jan. 1, 2018, Beginning number 740,000 Mar. 1, 2018, Purchase of treasury shares (72,000) 668,000 June 1, 2018, Stock split 2-1 668,000 1,336,000 Nov. 1, 2018, Issuance of shares 222,000 1,558,000 6% Cumulative Convertible Preferred Stock Sold at par, convertible into 180,000 shares of common (adjusted for split). $900,000 Stock Options Exercisable at the option price of $25...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT