answer both parts A mall-order house uses 15,975 boxes a year. Carrying costs are 42 cents per box a year, and ordering costs are $99. The followingprice schedule applies.Number of Boxes1,000 to 1,9992,000 to 4,9995,000 to 9,99910,000 or moreClick here for the Excel Data FilePrice per Box$1.451.351.251.20a. Determine the optimal order quantity. (Round your answer to the nearest whole number.)Optimal order quantityNumber of orderboxesb. Determine the number of orders per year. (Round your answer to 2 decimal places.)per year

EOQ stands for economic order quantity. It is a company's optimal order quantity that undervalues…

Answered: a. Determine the optimal order…

Practical Management Science

6th Edition

ISBN:9781337406659

Author:WINSTON, Wayne L.

Publisher:WINSTON, Wayne L.

Chapter2: Introduction To Spreadsheet Modeling

Section: Chapter Questions

Problem 20P: Julie James is opening a lemonade stand. She believes the fixed cost per week of running the stand...

See similar textbooks

Similar questions

A mail-order house uses 17,460 boxes a year. Carrying costs are 60 cents per box a year, and ordering costs are $96. The following price schedule applies. Number of Boxes Price per Box 1,000 to 1,999 $1.25 2,000 to 4,999 1.20 5,000 to 9,999 1.15 10,000 or more 1.10 a. Determine the optimal order quantity. (Round your answer to the nearest whole number.) Optimal order quantity __________ boxes b. Determine the number of orders per year. (Round your answer to 2 decimal places.) Number of order _____________ per year
A mail-order house uses 15,800 boxes a year. Carrying costs are 46 cents per box a year, and ordering costs are $94. The following price schedule applies. Number of Boxes 1,000 to 1,999 2,000 to 4,999 5,000 to 9,999 10,000 or more Price per Box $1.30 1.20 1.10 1.05 a. Determine the optimal order quantity. (Round your answer to the nearest whole number.)
An SKU costing $10 is ordered in quantities of 500 units, annual demand is 5200units, carrying costs are 20%, and the cost of placing an order is $50. Calculate thefollowing:a. Average inventory.b. Number of orders placed per year.c. Annual inventory carrying cost.d. Annual ordering cost.e. Annual total cost.
The purpose of EQQ is: A. measure the cost of ordering inventory B. to lower the level of inventory C. to determine the optimal amount of inventory to order D. to find the number of days before inventory needs to be reordered
An SKU costing $10 is ordered in quantities of 500 units; annual demand is5200 units, carrying costs are 20% and cost of placing an order is $50.Calculate1. Average inventory2. Number of orders placed per year3. Annual Inventory carrying cost4. Annual Ordering cost5. Annual total cost
Cheryl Druehl has asked you to help her determinethe best ordering policy for a new product. The demand for thenew product has been forecasted to be about I ,000 units annually.To help you get a handle on the carrying and ordering costs,Cheryl has given you the list of last year's costs. She thought thatthese costs might be appropriate for the new product. She also told you that these data were compiled for 10,000 inventoryitems that were carried or held during the year. You havealso determined that 200 orders were placed last year. Your job as a new opera tions management graduate is to help Cheryl determinethe economic order quantity for the new product.
A restaurant has an annual demand for 886 bottles of California wine. It costs $2 to store 1 bottle for 1 year, and it costs $10 to place a reorder. Find the optimum number of bottles per order.
Dave’s local college football team is playing for the national championship in next month’s bowl game, and he’s thinking about having “We’re number one” T-shirts imprinted in honor of the team. It’s too late to get the shirts before game day, but if he orders today, he can get them within a few days after the game. The shirts must be ordered in multiples of 1000, and Dave has estimated the amount of profit he will make for possible outcomes of the game. Given the following payoff table, what will Dave do if he uses the maximin criterion? The maximax criterion? The minimax regret criterion? Order no shirts $0 wins $0 loses $0 ties Order 1000 shirts $800 wins $-200 loses $200 ties Order 2000 shirts $1600 wins $-400 loses $300 ties
A bookstore manages the inventory based on a continuous review system with the order quantity Q = 40, and the reorder point = 25. The lead time is 2 days without uncertainty. At the end of day 0, the inventory position = on-hand inventory = 40. The demand in the following five days is 7, 6, 9, 13, and 8, respectively. What is the inventory position at the end of day 5? a. 22 b. 3 c. 43 d. 37
Petromax Enterprises uses a continuous review inventorycontrol system for one of its SKUs. The following informationis available on the item. The firm operates 50 weeks in a year.Demand = 50,000 units>yearOrdering cost = $35>orderHolding cost = $2>unit>yearAverage lead time = 3 weeksStandard deviation of weekly demand = 125 unitsa. What is the economic order quantity for this item?b. If Petromax wants to provide a 90 percent cycle-servicelevel, what should be the safety stock and the reorder point?
Among the following multi-period inventory models, which one has the highest probability of stockout? A. Fixed Order Quantity with Safety Stock B. Fixed Time Period Model C. Fixed Order Quantity D. Both Fixed Order Quantity & Fixed Order Quantity with Safety Stock
During the last 5 weeks, demands for a certain SKU at a retailer were 7 units (5 weeks ago), 4 units, 4 units, 4 units, and 5 units (last week). The retailer uses a period review model with order-up-to level 71 units, a review period of 2 weeks, and the lead time is 11 weeks. It is time to order. How much should the retailer order?

SEE MORE QUESTIONS

Recommended textbooks for you

Practical Management Science

Operations Management

ISBN:

9781337406659

Author:

WINSTON, Wayne L.

Publisher:

Cengage,

Operations Management

ISBN:

9781259667473

Author:

William J Stevenson

Publisher:

McGraw-Hill Education

Operations and Supply Chain Management (Mcgraw-hi…

Operations Management

ISBN:

9781259666100

Author:

F. Robert Jacobs, Richard B Chase

Publisher:

McGraw-Hill Education

Practical Management Science

Operations Management

ISBN:

9781337406659

Author:

WINSTON, Wayne L.

Publisher:

Cengage,

Operations Management

ISBN:

9781259667473

Author:

William J Stevenson

Publisher:

McGraw-Hill Education

Operations and Supply Chain Management (Mcgraw-hi…

Operations Management

ISBN:

9781259666100

Author:

F. Robert Jacobs, Richard B Chase

Publisher:

McGraw-Hill Education

Business in Action

Operations Management

ISBN:

9780135198100

Author:

BOVEE

Publisher:

PEARSON CO

Purchasing and Supply Chain Management

Operations Management

ISBN:

9781285869681

Author:

Robert M. Monczka, Robert B. Handfield, Larry C. Giunipero, James L. Patterson

Publisher:

Cengage Learning

Production and Operations Analysis, Seventh Editi…

Operations Management

ISBN:

9781478623069

Author:

Steven Nahmias, Tava Lennon Olsen

Publisher:

Waveland Press, Inc.

SEE MORE TEXTBOOKS

a. Determine the optimal order quantity. (Round your answer to the nearest whole number.) Optimal order quantity boxes b. Determine the number of orders per year. (Round your answer to 2 decimal places.) Number of order per year