Question

In: Operations Management

Suppose that the R&B Beverage Company has a soft drink product that shows a constant annual...

Suppose that the R&B Beverage Company has a soft drink product that shows a constant annual demand rate of 3,450 cases. A case of the soft drink costs R&B $4. Ordering costs are $23 per order and holding costs are 26% 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:

  1. Economic order quantity. If required, round your answer to two decimal places.

    Q*=
  2. Reorder point. If required, round your answer to the nearest whole number.

    r =
  3. Cycle time. If required, round your answer to two decimal places.

    T =  days
  4. Total annual cost. If required, round your answer to two decimal places.

    TC = $  

Solutions

Expert Solution

DEMAND = 3450

ORDERING COST = 23

HOLDING COST = 1.04

COST PER UNIT = 4

LEAD TIME = 5

WORKING = 250


1. EOQ = SQRT(2 * ANNUAL DEMAND * ORDERING COST / HOLDING COST PER UNIT) = SQRT(2 * 3450 * 23 / 1.04) = 390.64

2. REORDER POINT = DAILY DEMAND * LEAD TIME = (3450 / 250) * 5 = 69

3. CYCLE TIME = EOQ / (ANNUAL DEMAND / WORKING) = 390.64 / (3450 / 250) = 28.31

4. ANNUAL HOLDING COST = (EOQ / 2) * HOLDING COST PER UNIT = (390.64 / 2) * 1.04 = 203.1

ANNUAL ORDERING COST = (DEMAND / EOQ) * ORDERING COST = (3450 / 390.64) * 23 = 203.1

TOTAL COST OF MANAGING INVENTORY = ANNUAL HOLDING COST + ANNUAL ORDERING COST = 203.1 + 203.1 = 406.2

ANNUAL MATERIAL COST = ANNUAL DEMAND * PRICE PER UNIT = 3450 * 4 = 13800

TOTAL COST OF INVENTORY = ANNUAL HOLDING COST + ANNUAL ORDERING COST + ANNUAL MATERIAL COST = 203.1 + 203.1 + 13800 = 14206.2

A Thumbs Up! would be really helpful for me. If you have any questions, please leave a comment and I will get back to you as soon as possible.


Related Solutions

Suppose that the R&B Beverage Company has a soft drink product that shows a constant annual...
Suppose that the R&B Beverage Company has a soft drink product that shows a constant annual demand rate of 3,200 cases. A case of the soft drink costs R&B $4. Ordering costs are $23 per order and holding costs are 21% 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: Economic order quantity. If required, round your answer to two decimal...
Suppose that the R&B Beverage Company has a soft drink product that shows a constant annual...
Suppose that the R&B Beverage Company has a soft drink product that shows a constant annual demand rate of 3650 cases. A case of the soft drink costs R&B $4. Ordering costs are $25 per order and holding costs are 26% 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: Economic order quantity. If required, round your answer to two decimal...
Problem 14-1 (Algorithmic) Suppose that the R&B Beverage Company has a soft drink product that shows...
Problem 14-1 (Algorithmic) Suppose that the R&B Beverage Company has a soft drink product that shows a constant annual demand rate of 3000 cases. A case of the soft drink costs R&B $3. Ordering costs are $19 per order and holding costs are 27% 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...
Monty Company bottles and distributes B-Lite, a diet soft drink. The beverage is sold for 50...
Monty Company bottles and distributes B-Lite, a diet soft drink. The beverage is sold for 50 cents per 16-ounce bottle to retailers, who charge customers 75 cents per bottle. For the year 2017, management estimates the following revenues and costs. Sales $1,640,000 Selling expenses—variable $50,000 Direct materials 420,000 Selling expenses—fixed 70,000 Direct labor 350,000 Administrative expenses—variable 30,000 Manufacturing overhead—variable 380,000 Administrative expenses—fixed 48,000 Manufacturing overhead—fixed 208,250 1.Prepare a CVP income statement for 2017 based on management’s estimates. MONTY COMPANY CVP...
Blossom Company bottles and distributes B-Lite, a diet soft drink. The beverage is sold for 50...
Blossom Company bottles and distributes B-Lite, a diet soft drink. The beverage is sold for 50 cents per 16-ounce bottle to retailers, who charge customers 75 cents per bottle. For the year 2020, management estimates the following revenues and costs. Sales $1,950,000 Selling expenses—variable $67,000 Direct materials 550,000 Selling expenses—fixed 61,000 Direct labor 350,000 Administrative expenses—variable 28,000 Manufacturing overhead—variable 370,000 Administrative expenses—fixed 59,250 Manufacturing overhead—fixed 260,000 Correct answer iconYour answer is correct. Prepare a CVP income statement for 2020 based...
Jorge Company bottles and distributes B-Lite, a diet soft drink. The beverage is sold for 50...
Jorge Company bottles and distributes B-Lite, a diet soft drink. The beverage is sold for 50 cents per 16-ounce bottle to retailers, who charge customers 75 cents per bottle. For the year 2020, management estimates the following revenues and costs. Sales $1,800,000 Selling expenses—variable $70,000 Direct materials 430,000 Selling expenses—fixed 65,000 Direct labor 360,000 Administrative expenses—variable 20,000 Manufacturing overhead—variable 380,000 Administrative expenses—fixed 60,000 Manufacturing overhead—fixed 280,000 Prepare a CVP income statement for 2020 based on management’s estimates.    Calculate variable...
Wildhorse Company bottles and distributes B-Lite, a diet soft drink. The beverage is sold for 50...
Wildhorse Company bottles and distributes B-Lite, a diet soft drink. The beverage is sold for 50 cents per 16-ounce bottle to retailers, who charge customers 75 cents per bottle. For the year 2020, management estimates the following revenues and costs. Sales $1,750,000 Selling expenses—variable $108,000 Direct materials 450,000 Selling expenses—fixed 54,000 Direct labor 400,000 Administrative expenses—variable 22,000 Manufacturing overhead—variable 420,000 Administrative expenses—fixed 71,000 Manufacturing overhead—fixed 120,000 Compute the break-even point in (1) units and (2) dollars. (Round answers to 0...
Cullumber Company bottles and distributes B-Lite, a diet soft drink. The beverage is sold for 60...
Cullumber Company bottles and distributes B-Lite, a diet soft drink. The beverage is sold for 60 cents per 16-ounce bottle to retailers, who charge customers 75 cents per bottle. For the year 2020, management estimates the following revenues and costs. Sales $1,800,000 Selling expenses—variable $105,000 Direct materials 510,000 Selling expenses—fixed 62,000 Direct labor 390,000 Administrative expenses—variable 25,000 Manufacturing overhead—variable 410,000 Administrative expenses—fixed 96,000 Manufacturing overhead—fixed 130,000 Prepare a CVP income statement for 2020 based on management’s estimates. Calculate variable cost...
Ivanhoe Company bottles and distributes B-Lite, a diet soft drink. The beverage is sold for 50...
Ivanhoe Company bottles and distributes B-Lite, a diet soft drink. The beverage is sold for 50 cents per 16-ounce bottle to retailers, who charge customers 75 cents per bottle. For the year 2020, management estimates the following revenues and costs. Sales $1,650,000 Selling expenses—variable $76,500 Direct materials 460,000 Selling expenses—fixed 51,000 Direct labor 330,000 Administrative expenses—variable 21,000 Manufacturing overhead—variable 350,000 Administrative expenses—fixed 99,000 Manufacturing overhead—fixed 180,000 Part 1 Partially correct answer iconYour answer is partially correct. Prepare a CVP income...
Cullumber Company bottles and distributes B-Lite, a diet soft drink. The beverage is sold for 50...
Cullumber Company bottles and distributes B-Lite, a diet soft drink. The beverage is sold for 50 cents per 16-ounce bottle to retailers, who charge customers 75 cents per bottle. For the year 2020, management estimates the following revenues and costs. Sales $1,750,000 Selling expenses—variable $113,000 Direct materials 460,000 Selling expenses—fixed 50,000 Direct labor 390,000 Administrative expenses—variable 27,000 Manufacturing overhead—variable 410,000 Administrative expenses—fixed 77,500 Manufacturing overhead—fixed 100,000 Prepare a CVP income statement for 2020 based on management’s estimates. CULLUMBER COMPANY CVP...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT