Question No-4
a. Inventory Control refers to the process of managing a company’s warehouse inventory levels. The inventory control process involves managing items from the moment they are ordered; throughout their storage, movement and usage; to their final destination or disposal.
Importance of inventory control:
Inventory control helps to know what you have, where it is in your warehouse, and when stock is going in and out can help lower costs, speed up fulfillment, and prevent fraud.
Inventory control is also important to maintaining the right balance of stock in your warehouses. You don’t want to lose a sale because you didn’t have enough inventory to fill an order. Constant inventory issues can drive customers to other suppliers entirely. When you have control over your inventory, you’re able to provide better customer service. It will also help you get a better, more real-time understanding of what’s selling and what isn’t.
Inventory control helps to reduce excess inventory taking up space in warehouses unnecessarily. Too much inventory can trigger profit losses–whether a product expires, gets damaged, or goes out of season.
b. Bin Card
Bin card is the statement of all the receipts and issue of the stock from the store department. It is also called stock card or bin tag. It is the responsibility of the store keeper to write every in and out of stock from the store. The physical stock count and the stock quantity reported according to the bin card should be equal; otherwise internal audit department will have the right to investigate the matter with management.
Bin card only contain quantity column for both and receipts and at the close of each transaction, the stock level is calculated to make sure that at every point of time, it can be reconciled with the physical count.
Bin Card
Material Code: Maximum Level:
Material Description: Minimum Level:
Location: Reorder Level:
Unit of Measurement:
Date |
Doc No. |
Received from/Issued to |
Receipt |
Issue |
Balance |
Verification with SL Date & verified by |
|
c. EOQ =
Here,
A is annual demand of raw material, that is 50000 units
O is Cost of placing one order including the cost of receiving the goods or ordering cost, that is $ 100
C is carrying cost per unit per annum, that is $ 5
EOQ=
=
= 1414.21 units of Raw material (Approximately 1414 units)
A firm has been ordering a certain item 600 units at a time. The firm estimates that ordering cost is $200/order, and that annual demand is 1800 units per year. The assumptions of the basic EOQ model are thought to apply. For what value of holding cost (H: avg $cost of holding one piece for 1 year) would their ordering policy (600 units per order) be economically optimal (be the EOQ)? EOQ = Sq Root[(2D*S)/H] Where: D...
4. An assistant manager is reviewing the costs associated with the store's best-selling product. The data available is: Demand - 500 units/year Ordering cost- $90/order Holding cost-$1/unit/year a. What is the EOQ and its associated ordering and holding costs? b. If annual demand doubles and the ordering cost is brought down to $80 and holding cost remains at $1, what is the new EOQ and total annual cost?
4a. A computer company has annual demand of 100,000. They want to determine EOQ for circuit boards which have an annual holding cost (H) of $10/unit, and an ordering cost (S) of $200. What is the EOQ? 2000 4b. A computer company has annual demand of 100,000. They want to determine EOQ for circuit boards which have an annual holding cost (H) of $10/unit, and an ordering cost (S) of $200. What is the total annual inventory cost (setup and...
QUESTION 27 A local retailer purchased Inventory from an oversens supplier and believes the assumptions of the EOQ model are met reasonably well. Data from their accountant show annual demand (D) -6,588 units, ordering cost (S) - $42 per order, and holding cost 1) - $4 per unit per year How many times per year will she replenish her Inventory of this material for 'How many orders will she place in one year?') Demand 6,588 unit per year ordering cost...
Thomas Kratzer is the purchasing manager for the headquarters of a large insurance company chain with a central inventory operation. Thomas’s fastest moving inventory item has a demand of 6000 units per year. The cost of each unit is $100.00, and the inventory carrying cost is $10.00 per unit per year. The average ordering cost is $30.00 per order. It takes about 5 days for an order to arrive, and demand for 1 week is 120 units (this is a...
A local retailer purchased inventory from an overseas supplier and believes the motions of the EOQ moet are met wat was tomar show annual demand) -28,217 units, ordering cost (S) - $42 per order, and holding cost-$4 per unit per year How many times per year with repliester inventory of this material for 'How many orders will she place in one year?) Demand 28,217 unit per year ordering cost $42 per order holding cost $4 per unit per year Excel...
TEST Assignment 1 A computer-supply mail- order house has a memory chips in inventory that it sells to customers around the coutry. A Japanese manufacture supplies theitem using airfreigt. It has following characteristics:m Annual demand 1.200 units Leadtime Holding costs -25% per year Purchase price, delivered 75 USD per unit Ordering cost 25USD per unit - 1 week 1. Design a reorder point method of control for this item. Plot orders time diagramme. 2. What are the annual ordering and...
QUESTION 26 A local retailer purchased inventory from an overseas supplier and believes the assumptions of the EOQ model are met reasonably well. Data from their accountant show annual demand (D) =19,951 units, ordering cost (S) - $42 per order, and holding cost (11) - 54 per unit per year How many times per year will she replenish her inventory of this material? (or 'How many orders will she place in one year?) Demand 19,951 unit per year ordering cost...
Eagle Insurance is a large insurance company chain with a central inventory operation. The company’s fastest-moving inventory item has a demand of 80,000 units per year. The cost of each unit is $200, and the inventory carrying cost is $15 per unit per year. The average ordering cost is $60 per order. It takes about 2 days for an order to arrive. This is a corporate operation, and there are 250 working days per year. (Please show all work including...
"Peterson Enterprises uses a fixed order quantity inventory control system. The firm operates 50 weeks per year and has the following characteristics for an item: Demand = 50,000 units/year, Ordering cost = $35/order, Inventory-carrying or holding cost as a percent of item value = 25%, Item (Unit) cost = $8 calculate the economic order quantity (EOQ) that is the Square Root (2 * Demand * Ordering cost)/Square root (holding cost * unit cost)"