In Some Ordering Problems Like The One For Sam's Bookstore

In Some Ordering Problems Like The One For Sams Bookstore Whenev

In Some Ordering Problems Like The One For Sams Bookstore Whenev

In this assignment, we explore detailed modifications to Sam's Bookstore ordering model, focusing on three key areas: adjusting for expedited demand fulfillment, incorporating a tiered quantity discount structure, and analyzing the optimal order quantity against variable expediting costs through a two-way data table. These adjustments aim to enhance the operational accuracy and decision-making capacity of the model, providing a robust tool for devising cost-effective inventory policies.

Paper For Above instruction

Sam’s Bookstore faces complex inventory management challenges that require sophisticated modeling to optimize ordering strategies, minimize costs, and meet customer demand efficiently. The three primary modifications addressed are: 1) accounting for expedited orders when demand exceeds inventory, 2) implementing variable unit costs based on quantity discounts, and 3) analyzing the impact of different expediting costs on optimal order quantity via a two-way data table. These improvements not only refine the model's realism but also facilitate strategic decision-making under varying cost and demand scenarios.

Introduction

Inventory management in retail contexts such as Sam’s Bookstore often involves balancing order costs, holding costs, and service levels to minimize total costs while satisfying customer demand. Traditional models assume complete demand fulfillment from existing stock, but real-world scenarios entail costs associated with expedited orders for unmet demand and tiered pricing structures. This paper discusses the extensions necessary to capture these dynamics, emphasizing practical implications for inventory and supply chain managers.

Integrating Expedited Orders into the Inventory Model

In many inventory systems, unmet demand leads to lost sales; however, in some cases like Sam’s Bookstore, unmet demand is mitigated via expedited orders. These come at a significant additional cost, which must be incorporated into the existing model. To reflect this reality, a new variable representing the quantity of expedited orders and their associated costs is introduced. Specifically, if demand exceeds available inventory, the excess is fulfilled through expedited shipping at a unit cost of $40, substantially higher than the regular ordering cost.

This adjustment involves modifying the total cost calculations within the spreadsheet model. When demand surpasses on-hand stock, the excess quantity is directly added to the expedited cost component: Excess Demand × $40. This modification ensures the model accounts for actual operational expenses, enabling more accurate assessments of cost versus service level trade-offs and supporting decision-making regarding the trade-off between stock levels and expedited ordering.

Variable Quantity Discount Model

The originally assumed uniform unit pricing across all units ordered simplifies the cost calculation but often diverges from real-world discounts negotiated by retailers. In Sam’s case, the unit cost varies based on the quantity purchased, with tiered pricing: \$24 for the first 1500 units, \$23 for units 1501-2500, and \$22 for 2501 and above.

Implementing this tiered pricing model requires the use of nested IF functions within the spreadsheet to determine the per-unit cost based on the total order quantity. For example, the formula in Excel might look like:

=IF(OrderQuantity

IF(OrderQuantity24)+(OrderQuantity-1500)23, 


(150024)+(100023)+(OrderQuantity-2500)*22))

This approach accurately reflects the tiered costs, allowing for precise calculation of total purchasing expenses depending on the order size. The resulting model aids in identifying order quantities that minimize total costs while satisfying demand constraints, factoring in both quantity discounts and associated procurement costs.

Two-Way Data Table Analysis of Expected Profit

Understanding how different expoiting costs influence the optimal order quantity provides strategic insights. A two-way data table method allows for examining how expected profit varies with adjustments in order quantity and unit expediting costs. The process involves setting up a grid where the rows correspond to order quantities (from 500 to 4500 in steps of 500), and columns represent potential expediting costs (from $36 to $45 in increments of $1).

To facilitate this analysis, the existing spreadsheet model needs to include a cell for expected profit that dynamically updates based on the current values of order quantity and expediting cost. Each cell in the data table references this calculation, enabling the construction of a comprehensive matrix of profit outcomes.

Analysis of this table reveals the changing behavior of the optimal order quantity as expediting costs escalate. Typically, higher expediting costs discourage the use of expedited orders, prompting adjustments toward larger inventory positions to preempt unmet demand. Conversely, lower expediting costs incentivize smaller orders with riskier stockouts mitigated through faster replenishments.

This analysis guides management decisions on inventory sizing, balancing the costs of holding inventory against expediting expenses, and helps formulate responsive policies under variable supply chain conditions.

Discussion and Conclusions

The modifications to Sam’s Bookstore inventory model demonstrate the importance of capturing real-world complexities such as expedited shipping costs and tiered discounts. Incorporating expedited orders reflects a more realistic cost structure, enabling the store to evaluate the potential benefits and drawbacks of relying on urgent replenishment versus maintaining higher safety stocks.

Implementing a tiered pricing structure offers precise cost estimation, aiding strategic order quantity decisions that minimize procurement costs. The two-way data table analysis provides a powerful visualization tool, illustrating how adjustments in expediting costs influence optimal ordering policies, thus enhancing managerial understanding of supply chain trade-offs.

Overall, these enhancements lead to more nuanced, flexible, and actionable inventory management strategies, supporting Sam’s Bookstore in optimizing costs and service levels amidst fluctuating demand and operational costs.

References

  • Chopra, S., & Meindl, P. (2016). Supply Chain Management: Strategy, Planning, and Operation. Pearson.
  • Coughlan, J., Anderson, E., Stern, L. W., & El-Ansary, A. (2019). Marketing Channels (8th ed.). Pearson Education.
  • Krajewski, L. J., Ritzman, L. P., & Malhotra, M. (2019). Operations Management: Processes and Supply Chains. Pearson.
  • Silver, E. A., Pyke, D. F., & Peterson, R. (2016). Inventory Management and Production Planning and Scheduling. Wiley.
  • Heizer, J., Render, B., & Munson, C. (2020). Operations Management (13th ed.). Pearson.
  • Simchi-Levi, D., Kaminsky, P., & Simchi-Levi, E. (2021). Designing and Managing the Supply Chain: Concepts, Strategies and Case Studies. McGraw-Hill Education.
  • Hopp, W. J., & Spearman, M. L. (2011). Factory Physics. Waveland Press.
  • Axsäter, S. (2007). Inventory Control. Springer.
  • Larson, P. D., & Ferrell, O. C. (2017). Strategic Management: Text and Cases. Cengage Learning.
  • Bozarth, C. C., & Handfield, R. B. (2016). Introduction to Operations and Supply Chain Management. Pearson.

Related Assignments