Question

In: Accounting

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 places. Q* =

Reorder point. If required, round your answer to the nearest whole number. 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

Answer 1:

Economic order quantity = SQRT (2 * Annual demand * Ordering cost per order / Carrying cost per unit)

= SQRT (2 * 3200 * 23 / (4 * 21%))

= 418.6145

Q* = 418.61

Answer 2:

Reorder point = Expected demand during lead time + safety stock

As demand is deterministic, no safety stock is required.

Lead time = 5 days

Daily demand = Annual demand / Number of working days = 3200 / 250 = 12.80

Reorder point = Expected demad during lead time + safety stock = 5 * 12.80 + 0 = 64

r = 64

Answer 3:

Cycle time = SQRT (2 * Ordering cost / (Annual demand * Carrying cost)) = SQRT(2 * 23 / (3200 * 4 * 21%)) = 0.130817 year

Converting year into days:

Cycle time = 0.130817 * 365 = 47.75 days

T = 47.75 days

Answer 4:

Total annual cost = Ordering cost + inventory carrying cost

Number of orders per annum = Annual demand / EOQ

Ordering cost = Number of orders per annum * Ordering cost per order = 3200 / 418.6145 * 23 = $175.8181

Inventory carrying cost = Average inventory * Carrying cost per unit per annum

= 418.6145 / 2 * 4 * 21%

= $171.8181

Total annual cost = $175.8181 + $175.8181

= $351.64

TC = $351.64


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