Question

Bouncy Ball Company is revamping their current inventory system for their most popular line of blue...

Bouncy Ball Company is revamping their current inventory system for their most popular line of blue bounce balls. The data they had gathered relating to their inventory control system is as follows:

             Average demand = 250/week

            Lead time = 3 weeks

            Order cost = $75/order

            Unit cost = $21.50

            Carrying charge rate = 0.20

            Number of weeks per year = 52

      

The company would like to use a fixed order quantity system. What is the economic order quantity? What should be the reorder point be?

Please answer with Excel and show all steps.

Homework Answers

Answer #1

Average demand

250/Week

Lead time

3 Weeks

Order cost

575/ Order

Unit cost

$21.50

Carrying charge rate

0,20

Number of weeks per year

52

Economic order quantity = square root of [(2 x demand x ordering costs) ÷ carrying costs]

Q= Square Root of ((2 x 250 x 575) / 0.20)

EOQ = 1198.96

Reorder Pont – (Average daily unit sales x Delivery Lead Time) + Safety Stock

Average daily unit sales = 250/7 = 35.71

Delivery Lead Time = 3 Weeks

Safety Stock = 250/ Week

                     = (35.71 x 3) + 250

Reorder quantity = 357.13

Know the answer?
Your Answer:

Post as a guest

Your Name:

What's your source?

Earn Coins

Coins can be redeemed for fabulous gifts.

Not the answer you're looking for?
Ask your own homework help question
Similar Questions
Jill's Job Shop buys two parts (Tegdiws and Widgets) for use in its production system from...
Jill's Job Shop buys two parts (Tegdiws and Widgets) for use in its production system from two different suppliers. The parts are needed throughout the entire 52-week year. Tegdiws are used at a relatively constant rate and are ordered whenever the remaining quantity drops to the reorder level. Widgets are ordered from a supplier who stops by every five weeks. Data for both products are as follows:   ITEM TEGDIW WIDGET   Annual demand 13,000 6,000   Holding cost (% of item cost)...
You manage inventory for your company and use a continuous review inventory system to control reordering...
You manage inventory for your company and use a continuous review inventory system to control reordering items for stock. Your company is open for business 300 days per year. One of your most important items experiences demand of 20 units per day, normally distributed with a standard deviation of 3 units per day. You experience a lead time on orders from your supplier of six days with a standard deviation of two days. The unit price, regardless of order size,...
16) For supply item ABC, Andrews Company has been ordering 125 units based on the recommendation...
16) For supply item ABC, Andrews Company has been ordering 125 units based on the recommendation of the salesperson who calls on the company monthly. A new purchasing agent has been hired by the company who wants to start using the economic-order-quantity method and its supporting decision elements. She has gathered the following information: Annual demand in units 250 Days used per year 250 Lead time, in days 10 Ordering costs $100 Annual unit carrying costs $20 Required: Determine the...
Procurement manager Ikbal is working on preparing a 10-day inventory management and order schedule for Dragon...
Procurement manager Ikbal is working on preparing a 10-day inventory management and order schedule for Dragon Ball Inc. The company has the following cost structure and demand structure: solve in excel and show the formula used in step by step format : Setup(order) cost is $30, unit product cost is $20 and planned holding fraction (h) is 10%. Orders take 3 days to arrive to facility and they typically hold a 10% of lead time demand as safety stock. Daily...
You are in change of inventory for a manufacturing company, and you are given the following...
You are in change of inventory for a manufacturing company, and you are given the following information: Table 3: Inventory Characteristics Average Annual Demand 7800 Standard Deviation for Annual Demand 2600 Leadtime 2 weeks Holding or Carrying Cost 15% per year Fixed Delivery Cost per Shipment $200 Price (value) per Item $80 Stockout cost per Item $20 Probability of being in stock during leadtime 85% 5 What is your optimal economic order quantity (integer)? 6 What is the reorder point?...
Bob Sean, manager at Ikea is responsible for managing the inventory of computer desks. Bob isn't...
Bob Sean, manager at Ikea is responsible for managing the inventory of computer desks. Bob isn't talkative about his inventory, but you have managed to extract the following information from him: It costs $35 to place an order. Each computer desk costs $31.33. Annual per unit holding cost is 30% of item value. Average daily demand is 100 writing desks. Standard deviation of demand during lead time is 51.96. Lead time to receive a computer desk from a supplier is...
1) Greg Fletcher, the materials manager at Easy Furniture Inc., is responsible for managing the inventory...
1) Greg Fletcher, the materials manager at Easy Furniture Inc., is responsible for managing the inventory of writing desks. Greg isn't talkative about his inventory, but you have managed to extract the following information from him: It costs $35 to place an order. Each writing desk costs $31.33. Annual per unit holding cost is 30%of item value. Average daily demand is 100 writing desks. Standard deviation of demand during lead time is 51.96. Lead time to receive a writing desk...
The manager of a company is facing an inventory problem with regard to an item whose...
The manager of a company is facing an inventory problem with regard to an item whose demand is known to be evenly distributed with an annual value of 8,000 units. The cost of placing an order is Rs 50 while the annual carrying cost of one unit in inventory is Rs 5. Further it is known that the lead time is uniform and equals 8 working days and that the total working days in a year is 320 days. Using...
Inventory Management 1. Ayo is the Purchasing Officer for a company that assembles desktop computers. The...
Inventory Management 1. Ayo is the Purchasing Officer for a company that assembles desktop computers. The computers come with 4 to 6 USB ports. The annual demand for the computers is 600 units. The cost of each computer is $1700, and the inventory carrying cost is estimated to be 10% of the cost of each computer. Ayo has made a study of the costs involved in placing an order and has concluded that the average ordering cost is $50.00 per...
Speedy Bicycle Company (SBC) is a wholesale distributor of a wide variety of bicycles and bicycle...
Speedy Bicycle Company (SBC) is a wholesale distributor of a wide variety of bicycles and bicycle parts. The most popular model is the Dragonfly, which sells for $170. All manufacturing is done at a plant in China, and shipment takes a month (30 days) from the time an order is placed. The estimated order cost is $75, including customs clearance. SBC’s cost per bicycle is 65% of retail price, and inventory carrying cost is 11% per year of SBC’s cost....