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 places.

Q^*=
Reorder point.

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

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

TC = $

Solutions

Expert Solution

Solution:

Holding cost = $4 x 0.26 = $1.04

a. The economic order quantity, Q* is calculated using the formula:-

Q* = 2 x Annual Demand x Ordering cost/Holding cost
Q* = 2 x 3,650 x 25/1.04

Q* = 418.9 approx 419

--------------------------------------------------------------------------------------------

b. The reorder point, r is calculated using the formula:

r = Average daily usage x Lead time

r = 3650/250 x 5

r = 73 units

--------------------------------------------------------------------------------------------

c. The cycle time, T is calculated using the formula:

T = Q*/Annual demand x Number of working days per year

T = 490/3650 x 250

T = 33.56 days

----------------------------------------------------------------------------------------------

d. The total annual cost, TC is calculated using the formula:

TC = Total annual demand x Cost per unit + Ordering cost + Storage cost

TC = (3,650 x $4) + (3,650/419 x $25) + (3,650 x 1.04)

TC = $18,613.8

jeff jeffy answered 1 year ago

Next > < Previous

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...

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...

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 2017, management estimates the following revenues and costs. Sales $1,840,000 Selling expenses—variable $50,000 Direct materials 410,000 Selling expenses—fixed 45,000 Direct labor 350,000 Administrative expenses—variable 16,000 Manufacturing overhead—variable 370,000 Administrative expenses—fixed 60,000 Manufacturing overhead—fixed 365,750 A. Prepare a CVP income statement for 2017 based on management estimates. B. Calculate...

Subjects