Buckshot Electronics is a chain of electronics superstores that is located throu
ID: 3144025 • Letter: B
Question
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
Questions:
3. What is the per unit cost for each item? Cost is the amount the company pays their supplier per unit. Find C: (Choose the closest answer)
Using Present Lot Size (Q = 900)
According to the information supplied, what is the present annual inventory cost? (In other words, using their present lot size what is the annual inventory cost?) Also, separately identify, the annual cost of purchasing the inventory, the annual holding cost (AHC) and annual ordering cost (AOC).
7. What is the annual cost to purchase the items? (Q = 900) (Choose the closest answer)
8. What is the annual ordering cost, AOC? (Q = 900) (Choose the closest answer)
9. What is the annual holding cost, AHC? (Q = 900) (Choose the closest answer)
10. What is the total annual cost of inventory, TC? (Q = 900) (Choose the closest answer)
Using the Economic Order Quantity (Q=EOQ)
11. What is the EOQ? (Choose the closest answer)
According to the information supplied, what would be the annual inventory cost if they used the calculated EOQ? Also, separately identify the annual holding cost (AHC) and annual ordering cost (AOC).
14. Using the calculated EOQ, what is the annual ordering cost (AOC)? (Choose the closest answer)
15. What is the total annual cost of inventory, TC? (Q = EOQ) (Choose the closest answer)
PROPER ORDER SIZE The store must decide how often they want to order. • Remember, the weekly demand is 150 units. • If they order weekly, the store will require at minimum 200 units per week. • If they order every other week, the store will require at minimum 300 units to get to the next ordering period. (150 units per week, 2 weeks.)
18. If they order every 3 weeks, what will be the minimum required order size? Remember, you must abide by the Sony Distributor’s ordering rules.
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.
Explanation / Answer
3. What is the per unit cost for each item?
Answer: $399 per unit
Present Lot Size = 900 Quantity
Expected Units = 7800 units
Order is made every 6 weeks
No. of orders to be placed = (7800/900) i.e. 9 orders
Each lot of 900 makes the total quantity (TQ) = 8100 units
Wholesale Price of the cellphone = $ 325
7. Annual Cost to Purchase Inventory = 8100 * 325 = $2,632,500
8. Cost to place each order will include all the
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
Cost to place each order amounts to $1,000
Annual Ordering Cost = Cost per order * No. of orders in a year
= $1,000 * 9
=$9,000
9. Annual per unit holding cost = 35% of wholesale price i.e. $325
= $ 113.75 per unit
Annual Holding cost = Total quantity * Holding Cost per unit
= 8100 * 113.75
= $ 921,375
10. Total Annual Cost of Inventory = Annual Cost to purchase Inventory + Annual Holding Cost + Annual Ordering Cost
= $2,632,500 + $ 9,000 + $ 921,375
= $ 3,562,875
11). EOQ = ?(2*D*S/H) = ?(2*7800*1000/113.75) = 370
14). Annual Ordering Cost (AOC) = 7800/370*1000 = $ 21,081
15). Total inventory related cost (TC) = 21044+21081 = $ 42,125
18.If they order every 3 weeks, what will be the minimum required order size?Remember, youmust abide by the Sony Distributor’s ordering rules.
Ans: 52/3=17.33 7800/17.33 = 450 ~ 500 units
21. If they instead order every 2 weeks what will be the minimum required order size?
Ans: 30,022.
Please rate
Related Questions
drjack9650@gmail.com
Navigate
Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.