Suppose that the R&B Beverage Company has a soft drink product that shows a constant annual demand rate of 3,400 cases. A case of the soft drink costs R&B $3. Ordering costs are $20 per order and holdingcosts are 25% of the value of the inventory. R&B has 250 working days per year, and the lead time is 5 days. Identify the following aspects of the inventory policy.(a) economic order quantity (round your answer to the nearest integer.)(b) reorder point(c) cycle time (in days) (round your answer to two decimal places.)days(d) total annual cost (in $) (round your answer to two decimal places.)$

Inventory Policy for R&B Beverage CompanyWe can find the following aspects of the inventory…

Answered: Suppose that the R&B Beverage Company…

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

the economic order quantity (see Chapter 12 for EOQformulas) for its halogen lamps. It currently buys all halogenlamps from Specialty Lighting Manufacturers in Atlanta. Annualdemand is 2,000 lamps, ordering cost per order is $30, and annualcarrying cost per lamp is $12.a) What is the EOQ?b) What are the total annual costs of holding and ordering(managing) this inventory?c) How many orders should D iscount-Mart place with SpecialtyLighting per year?
Suppose that the R&B Beverage Company has a soft drink product that shows a constant annual demand rate of 3,600 cases. A case of the soft drink costs R&B $4. Ordering costs are $22 per order and holding costs are 23% of the value of the inventory. R&B has 250 working days per year, and the lead time is 5 days. Identify the following aspects of the inventory policy: a. Economic order quantity. If required, round your answer to two decimal places.Q = b. Reorder point. If required, round your answer to the nearest whole number.r =c. Cycle time. If required, round your answer to two decimal places.T = daysd. Total annual cost. If required, round your answer to two decimal places.TC = $
4
3. Skinner’s Fish Market buys fresh Boston bluefish daily for $4.20 per pound and sells it for $6 per pound. At the end of each business day, any remaining bluefish is sold to a producer of cat food for $3 per pound. Daily demand can be approximated by a normal distribution with a mean of 64 pounds and a standard deviation of 11 pounds. What is the optimal order quantity (stocking level)? Round your answer to 2 decimal places. Answer:_______
A daily newspaper is stocked by a coffee shop so its patrons can purchase and read it while they drink coffee. The newspaper costs $1.17 per unit and sells for $1.75 per unit. If units are unsold at the end of the day, the supplier takes them back at a rebate of $1 per unit. Assume that daily demand is approximately normally distributed with μ = 150 and a = 30. (a) What is your recommended daily order quantity for the coffee shop? (Round your answer to the nearest integer.) (b) What is the probability that the coffee shop will sell all the units it orders? (Round your answer to four decimal places.) (c) In problems such as these, why would the supplier offer a rebate as high as $1? For example, why not offer a nominal rebate? Find the recommended order quantity at 25¢ per unit. (Round your answer to the nearest integer.) What happens to the coffee shop's order quantity as the rebate is reduced? The higher rebate ---Select-- the quantity that the coffee shop should order.
Polymorph Promotions finds that demand for an item is Normally distributed with a mean of 2,000 units a year and a standard deviation of 400 units. Unit cost is $100, reorder cost is $200, holding cost is 20% of value a year and lead time is fixed at 3 weeks. Compute the (s,Q) ordering policy that gives a 95% service level and the annual cost of the safety stock.
Your objective is to help company by determining EOQ* (Economic Order Quantity) that minimizes the totalinventory cost for a company that sells ceiling fans. Your worksheet provides information about the currentorder quantity, demand quantity and other costs.Questions: Answer A and Ba. With the current order quantity, what is the total cost of inventory?b. Implement the problem in Excel and find the order quantity (EOQ) (round to nearest integer) that givesminimum inventory cost. Note: this is a Non-linear programming, hence select “GRG Nonlinear” method inSolver- How much money would company save by switching to optimum quantity from current orderquantity?
AaBbCc AaBbCc AaBbCc No Spacing Normal Reuse Heading 1 Replace Files Paragraph Styles Editing Reuse Files Item SKU A3378 has a demand that is normally distributed during the lead time, with a mean of 360 units and standard deviation of 12. If Hinsdale cannot have stockouts in more than 10% of the time in any order, how much safety stock should be maintained and at what reorder point? 1. SKU F5402: daily demand is normally distributed with a mean of 16, standard deviation of 4, lead time is 4 days, and must operate at a 95% service level. 2. SKU B7319: daily demand is constant at 24 units per day, lead time is normally with a mean of 6 days and standard deviation of 2 days, and must operate at a 95% service level. 3. SKU F9004: daily demand is normally distributed with a mean of 21 units and a standard deviation of 3 days. The lead time is also normally distributed with a mean of 4 days, standard deviation of 2 days, and a service level of 90% is required. dictions: On acer %24 4. % &…
You work as a sales representative in a company that manufactures surgical equipment. Before calling on an important prospect, you decide to search the Internet and find out details about her/him. What step in the selling process is being carried out here? What is the importance of this step? please give the reference where you get data to collect information about it.
The Hodson Gallery and Art Museum distributes a printed guide for its visitors. There are about 18000 visitors per year. Holding costs for the brochures are 20% and it costs $30 to place an order with the printer. A. Assuming the cost for each guide is $2.50, how many should be printed at a time? B. Now assume the printer has offered the following discount schedule: Category Order Size Unit Cost 1 0 - 1499 $2.50 2 1500 - 2999 $2.20 3 3000 and over $1.80 Now how many brochures should be printed at a time?
your company is facing the situation in which the demand is stochastic but the lead time is known with certainty. Your company has recently implemented a periodic review policy in which your inventory is reviewed every 30 days. The demand is normally distributed with a mean of 600 items annually. The lead time is 25 days, and the annual standard deviation is 100 units. Inventory shows 20 parts in stock. Your company has a policy of 90% service level type I. Also, ordering cost in $20 and holding cost is also $20 per item per year. a) find the order quantity for the next period b) how would your answer change if service level is defined as the expected number of parts available from stock.

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