Economic Order Quantity Exercise (25 Points) SCM 300 Buckshot Electronics is a chain of electronics superstores that is located throughout California. They have 15 locations concentrated primarily in heavily populated areas. They sell thousands of products made by hundreds of different manufacturers. Buckshot sells everything from phones, cameras, DVD players, and video game consoles to large items like televisions. Sony is one of their larger suppliers. They offer products in nearly every category Buckshot offers to its customers. In fact, Sony sells multiple cell phone models through Buckshot. One such model is the Q9900. One of Buckshot's San Francisco stores is forecasted to sell about 7800 units of the Q9900 in the coming year. This forecasted demand is about average in terms of Buckshot's 15 other California locations. Presently they order 900 units of the Q9900 every 6 weeks. Each store fills weekly orders through its Sony Distributor for items like TV's, DVD Players, cameras, and of course, cell phones, in addition to many other items. Orders for cell phones must be made in increments of 100 units. The distributor takes only one order per week, but Buckshot is not obligated to order every item every week. That order is then shipped 2 days later to that individual Buckshot Electronics location by truck. Buckshot's Central Procurement is looking to save money by investigating order sizes and subsequent order frequency. You are being asked to create a recommendation for order size and time between orders for the Q9900 based on the numbers for this San Francisco location. Answer the questions that follow in order to create a detailed report for your supervisor. Below are some the key figures important in your analysis: Q9900 Wholesale Price $ 325.00 Q9900 Retail Price $ 399.00 Annual Per Unit Holding Costs are estimated at 35% of the wholesale cost of the Q9900. Costs associated with each order include: Order Placement Fees (Documentation, Network Support) $ 250.00 Delivery (Fuel, Driver, Truck, etc.) $ 350.00 Packaging $ 150.00 Receiving (Inspection, Documentation, etc.) $ 150.00 Labor (5 hours @ $10.00/hr) Stocking, Misc. $ 50.00 21. If they instead order every 2 weeks what will be the minimum required order size? Remember, you must abide by the Sony Distributor's ordering rules. 22. Assume they sell exactly 150 units per week. Based on the appropriate answer to the previous question, how many extra units will they have left at the end of the 2-week period? 23. Based on the weekly ordering scenario, over a 52-week year, how much extra inventory will this store have accumulated? (Take your answer to #22, divide by 2, and then multiply by 52) 24. Realistically, which of the following options is most attractive? An attractive option is one where the order size is close or equal to the EOQ, abides by the distributor's ordering rules, and minimizes the amount of unnecessary inventory. (We will call this Q*)
