Sign Up Now
Get instant access to over 1 million+ study documents
OR
Already registered? click here to login
By creating your account, you agree to our terms of service, privacy policy and student honor code.
Optimizing Inventory / Transportation
Optimizing Inventory/Transportation
Danny Wilco
Re: Quarterly Ordering Decisions
Problem Situation
Optimal order-quantity technique is one of the sophisticated inventory management systems that our organization can employ to manage our inventories. The traditional inventory management technique we are using is making our company to incur additional costs of operation. The annual inventory holding costs is 4% thereby increasing our costs operation, and reducing our profitability. In the course of this problem, we are required to implement the optimal order-quantity technique to assist our company to lower the costs of managing our inventory thereby increasing our profitability.
Assumptions
Our pricing estimate is based on the markup factor of 140% or 1.4.
There is an estimation of 4% of the annual inventory holding costs.
The quarterly sales forecast of the Kegs of the Imported Beer line is estimated based on the inflation of 100% for the last quarter, which forms the basis of the next four quarters.
Moreover, we expect a seasonal cost reduction for the next three quarters.
The ending inventory is 175 for our total number of our imported beer and our capacity for the Kegs is approximately 190 for Imported Beers.
Solution for Order Quantities
We use the costs and forecast demand in the Appendix 1 to estimate the total sales forecast. The data in the Table 1 reveals our sales forecast for each of the four quarters of our imported Beer line for our kegs. However, the inflation for the last quarter is 100% and the inventory constraint is the quarterly holding...
As being revealed in the Table 1, there is an increase in sales within the next four quarters, and we arrive at the sales forecast for each product by multiplying the price per unit with forecast demand.
Table 1
Forecast Demand
Next 4 Quarters
Product Code
1
2
3
4
Total Annual Demand
$1,468.60
$1,762.32
$1,835.75
$1,909.18
$1,460.34
$1,541.47
$1,655.05
$1,752.41
$1,481.55
$1,568.70
$1,568.70
$1,481.55
$1,056.13
$1,280.16
$1,440.18
$1,440.18
$1,454.22
$1,473.11
$1,510.88
$1,510.88
$2,384.34
$2,157.26
$2,270.80
$2,384.34
$829.92
$968.24
$1,037.40
$1,037.40
$1,606.22
$1,752.24
$1,825.25
$1,825.25
$2,234.96
$2,234.96
$2,234.96
$2,406.88
$1,101.10
$1,321.32
$1,541.54
$1,761.76
Total
$15,078.38
$16,061.78
$16,923.51
$17,513.83
$65,577.50
The table 2 reveals the costs per unit. We calculate the cost per unit based on the inflation rate of each quarter, and we arrive at the costs per unit by multiplying the product unit with the inflation rate of each quarter.
Table 2
Forecast…
Inventory management is an ongoing process (as opposed to a project which has a beginning and an end) of monitoring the constant flow of stock keeping units (SKUs) into and out of supply. The goal is to prevent the inventory from becoming too high (cost), or so low that the operations of the company are in jeopardy (service levels.) (Barcodes, 2011) Elemental management of inventory requires balancing the three key aspects
VMI is a highly orchestrated process that can drastically reduce the inventory carrying costs of a manufacturer, and is one that 3PL providers rely on public warehouses to attain. The cost benefits of reverse logistics also contribute to the cost efficiencies of public warehouses (Berglund, Laarhoven, Sharman, Wandel, 1999). Reverse logistics is a supply chain process that seeks to capture packaging, recyclable components, and potentially toxic materials in products so
52). The researcher handles or controls the items differently. It is a form of Pareto analysis where items such as customers, documents, activities, inventory items, sales territories grouped into three categories namely a, B, and C. In order of their estimated importance. Consequently, 'A' items are very important, 'B' items are important, and 'C' items are marginally important. The organization gives 'A' rating to their best customers since they
Inventory turn is the amount of times that the inventory is moved in a given year. The inventory turn is calculated as the cost of goods sold divided by the average inventory level (Investopedia, 2014). The inventory turn is expressed either in how many times the inventory turned over, or how many days' inventory is on hand at any given time. In general, inventory turn is used to measure sales performance
21). Conversely, Michman and Greco (1999) point out that, "Some department stores have failed because many have provided a stale and unexciting physical environment to customers. Another reason has been that some department stores have been unable to implement effective inventory management systems, thereby lowering costs to either match or at least approach the prices offered by discounters" (p. 4). Effectively managing inventory also requires the ability to monitor current
SCM as a Method of Inventory Control SCM and Inventory Control This paper examines the use of supply chain management (SCM) as a tool for inventory control. SCM, which coordinates and integrates the activities of supply chain members, plays an increasingly important role in companies' reducing their costs and making better informed decisions. Companies benefit from SCM and inventory control by better meeting customer demands for product availability and pricing, and by