Question

In: Accounting

The current policy is to order 100,000 units when the inventory level falls to 35,000 units....

The current policy is to order 100,000 units when the inventory level falls to 35,000 units. However, forecast demand to meet market requirements for next year is 625,000 units. The cost of placing and processing an order is R250, while the annual cost of holding a unit in stores is 5% of the unit purchase price. Both costs are expected to be constant during the next year. Shop n Pay sells a unit of the product for R15.00 at cost plus 50%. Orders are received two weeks after being placed with the supplier. You should assume a 350-day year and that demand is constant throughout the year.

Question

  1. Calculate the total cost of the current ordering policy

Question

Solutions

Expert Solution

Ans : PLEASE GV A RATING IF U LIKE MY EFFORTS , IT WILL KEEP US MOTIVATED. THANK YOU In Advance                  

Economic Order Quantity

Economic Order Quantity (EOQ) is the level of inventory that minimizes the total cost of holding and ordering inventory over a period of time. Usually the time period is one year.

The total cost of inventory is the sum of the purchase, ordering and holding costs. As a formula:

TC = PC + OC + HC, where TC is the Total Cost; PC is Purchase Cost; OC is Ordering Cost; and HC is Holding Cost.

Assumptions

To determine the Economic Order Quantity, these costs must be analyzed further. Some assumptions are required:

a) Purchase Cost is a straight-forward "unit cost X number of units" calculation. In other words, volume discounts do not apply. As well, the unit cost remains constant over the year.

b) Order Cost is a fixed overhead cost, and remains constant over the year. It represents, for example, the time value for employees to write up an order, mail it, follow up, inspect the received goods, and make the payment.

c) Holding Cost is fixed over the year. It represents warehouse space, with services such as refrigeration or insurance or security. It also includes the interest cost, which should be set to the "risk-free opportunity-cost" rate.

d) The rate of demand is constant over the year.

e) The total quantity ordered is delivered in one batch.

f) The lead time (between placing an order and receiving it) is constant and does not depend on the order quantity.

g) The quantities are large enough that calculus may be used to determine a minimum point. Calculus requires smooth functions on the real number system. Order quantities assume integral units.

Variables

We will use the following variables:

Q = Quantity being ordered = 100000 units

Q* = the optimal order Quantity: the result being sought

D = annual Demand for the item, over the year = 625,000 units

P = unit Purchase cost   = R10 ( computed below)

O = cost of one Order, regardless of the number of units in the order = R250

H = annual cost to Hold one unit = 5% of the unit purchase price = 5% * 10 = R0.50

Selling price = R15 ( which is cost + 50% ) (50% on cost = 33.33333% on S.P.)

Therefore , Cost = 15 – ( 15*33.3333%) = 15 – 5 = R10

Using the variables, here are the components of the first equation (TC = PC + OC + HC):

1) PC = P x D :                       Purchase Cost = unit Purchase cost times the annual Demand

      = R10 *625,000 units = R 6250000

2) OC = (D x O) / Q :             Order Cost = annual Demand times cost per Order, divided by the order Quantity (number of units)

= ( 625000 * R250 ) / 100000 = R 1750   ( since orders cannot be in fraction we are taking it as 7 instead of 6.25 )

3) HC = (H x Q) / 2:               Holding Cost = annual unit Holding cost times order Quantity (number of units), divided by 2 (because throughout the year, on average the warehouse is half full).

= ( 0.50 * 100000 ) / 2 = R25000

So TC = PC + OC + HC = R 6250000 + R 1750   + R25000 = R 6276750


Related Solutions

B. Inventory management The current policy is to order 100,000 units when the inventory level falls...
B. Inventory management The current policy is to order 100,000 units when the inventory level falls to 35,000 units. However, forecast demand to meet market requirements for next year is 625,000 units. The cost of placing and processing an order is R250, while the annual cost of holding a unit in stores is 5% of the unit purchase price. Both costs are expected to be constant during the next year. Shop n Pay sells a unit of the product for...
B. Inventory management The current policy is to order 100,000 units when the inventory level falls...
B. Inventory management The current policy is to order 100,000 units when the inventory level falls to 35,000 units. However, forecast demand to meet market requirements for next year is 625,000 units. The cost of placing and processing an order is R250, while the annual cost of holding a unit in stores is 5% of the unit purchase price. Both costs are expected to be constant during the next year. Shop n Pay sells a unit of the product for...
The current inventory policy for M&B calls for purchasing HRF 5123 in lot order quantities of...
The current inventory policy for M&B calls for purchasing HRF 5123 in lot order quantities of 155 cases from the Chem Corporation. M&B has an inventory control system that monitors inventory levels of all products on a weekly basis. Inventory records are attached. M&B operations require that 155 cases be reordered when inventory levels drop to 55 cases within the warehouse. Each case of HRF 5123 cost $10 and M&B has a 14% annual holding cost rate for its inventory....
Demand for hotdogs is 500 units per week. Lead time is one week. When inventory level...
Demand for hotdogs is 500 units per week. Lead time is one week. When inventory level reached 1500 units, the regional director orders 8 weeks of demand. Compute the average inventory. A. 1000 B. 2000 C. 3000 D. 4000 E. None of the above Demand for hamburgers is 400 units per week. Lead time is one week. When inventory level reached 1000 units, the regional director orders 6 weeks of demand. Compute the flow time. A .1.5 weeks. B. 3.5...
When there are no units in the beginning Finished Goods Inventory and the units produced are...
When there are no units in the beginning Finished Goods Inventory and the units produced are more than the units​ sold, the operating income will be higher under variable costing than absorption costing.
1) When aggregate price level in the economy falls, then the interest rate in the economy...
1) When aggregate price level in the economy falls, then the interest rate in the economy falls, which leads to an increase in investment expenditure in the economy. This phenomenon is called: A) the wealth effect B) the interest rate effect C) the exchange rate effect D) the investment effect 2)The Quantity Theory of Money can be used to explain why: A) SRAS curve is downward sloping B) SRAS curve is upward sloping C) AD curve is downward sloping, AD...
Kubin Company’s relevant range of production is 30,000 to 35,000 units. When it produces and sells...
Kubin Company’s relevant range of production is 30,000 to 35,000 units. When it produces and sells 32,500 units, its average costs per unit are as follows:    Average Cost per Unit Direct materials $ 9.00 Direct labor $ 6.00 Variable manufacturing overhead $ 3.50 Fixed manufacturing overhead $ 7.00 Fixed selling expense $ 5.50 Fixed administrative expense $ 4.50 Sales commissions $ 3.00 Variable administrative expense $ 2.50 Required: 1. Assume the cost object is units of production: a. What...
Kubin Company’s relevant range of production is 30,000 to 35,000 units. When it produces and sells...
Kubin Company’s relevant range of production is 30,000 to 35,000 units. When it produces and sells 32,500 units, its average costs per unit are as follows:    Average Cost per Unit Direct materials $ 9.00 Direct labor $ 6.00 Variable manufacturing overhead $ 3.50 Fixed manufacturing overhead $ 7.00 Fixed selling expense $ 5.50 Fixed administrative expense $ 4.50 Sales commissions $ 3.00 Variable administrative expense $ 2.50 Required: 1. Assume the cost object is units of production: a. What...
Calculate the energy change when an electron falls from the n =6 energy level to the...
Calculate the energy change when an electron falls from the n =6 energy level to the n = 1 energy level in a hydrogen atom. ΔE=−2.178×10−18 J ( 1/n^2 final)- (1/n^2 initial) How many orbitals are described by each of the below combinations of quantum numbers? n = 3, ℓ =2 n = 4, ℓ = 2, mℓ = 2 Choose one: A. orbitals that randomly fill, but that are always identical. B. orbitals of the same shape. C. orbitals...
Painter Corporation has the following information for the current month: Units started 100,000 units Beginning Work...
Painter Corporation has the following information for the current month: Units started 100,000 units Beginning Work in Process: (35% complete) 20,000 units Normal spoilage (discrete) 3,500 units Abnormal spoilage 5,000 units Ending Work in Process: (70% complete) 14,500 units Transferred out 97,000 units Beginning Work in Process Costs: Material $15,000 Conversion 10,000 All materials are added at the start of the production process. Painter Corporation inspects goods at 75 percent completion as to conversion. Refer to Painter Corporation. What are...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT