Question

In: Statistics and Probability

R&B Beverages, Inc., provides a complete line of beer, wine, and soft drink products for distribution...

R&B Beverages, Inc., provides a complete line of beer, wine, and soft drink products for distribution through retail outlets in central Iowa. Unit price data for 2011 and 2014 and quantities sold in cases for 2011 follow. Item 2011 quantity (cases) Unit price 2011 2014 Beer 35,000 17.50 20.15 Wine 5,000 100.00 118.00 Soft drink 60,000 8.00 8.80 Compute a weighted aggregate index for the R&B Beverage Sales in 2014, with 2011 as the base period.

Solutions

Expert Solution

SOLUTION:

From given data,

R&B Beverages, Inc., provides a complete line of beer, wine, and soft drink products for distribution through retail outlets in central Iowa. Unit price data for 2011 and 2014 and quantities sold in cases for 2011 follow.

The given information is shown in below.

2011 Quantity Unit Price ($)

Item 2011 Quality (cases) 2011 2014
Beer 35,000 17.50 20.15
Wine 5,000 100.00 118.00
Soft drink 60,000 8.00 8.80

We need to compute a weighted aggregate price index for the R & B Beverage sales in 2014 , with 2011 as the base period .

By definition using a weighted aggregate price index in period t,

= ( / ​ ) 100

Where,

​​​​​​ = unit price for item i in period t

= unit price for item i in the base period

= quantity of usage for the item i

The weighted aggregate price index for the component part in the year 2014

=

[20.15 (35,000)+ 118.00 (5,000)+8.80(60,000) /17.50 (35,000)+ 100.00 (5,000)+8.00(60,000)] * 100

= [ 1823250 / 1592500 ] * 100

= 1.1448979*100

= 114.48979

  114

Therefore , the weighted aggregated price index for the R&B Beverage sales in 2014 is $114


Related Solutions

A certain beverage company provides a complete line of beer, wine, and soft drink products for...
A certain beverage company provides a complete line of beer, wine, and soft drink products for distribution through retail outlets in central Iowa. Unit price data for 2011 and 2014 and quantities sold in cases for 2011 follow. Use 2011 as the base period. Unit Price ($) Item 2011 Quantity (cases) 2011 2014 Beer 30,000 18.50 20.15 Wine 5,000 100.00 118.00 Soft drink 60,000 8.00 8.80 Compute the price relatives for this company's products. (Round your answers to two decimal...
A certain beverage company provides a complete line of beer, wine, and soft drink products for...
A certain beverage company provides a complete line of beer, wine, and soft drink products for distribution through retail outlets in central Iowa. Unit price data for 2011 and 2014 and quantities sold in cases for 2011 follow. Use 2011 as the base period. Unit Price ($) Item 2011 Quantity (cases) 2011 2014 Beer 35,000 18.50 20.15 Wine 5,000 100.00 116.00 Soft drink 70,000 8.00 8.80 Compute the price relatives for this company's products. (Round your answers to two decimal...
A certain beverage company provides a complete line of beer, wine, and soft drink products for...
A certain beverage company provides a complete line of beer, wine, and soft drink products for distribution through retail outlets in central Iowa. Unit price data for 2011 and 2014 and quantities sold in cases for 2011 follow. Use 2011 as the base period. Unit Price ($) Item 2011 Quantity (cases) 2011 2014 Beer 40,000 18.50 20.15 Wine 5,000 100.00 116.00 Soft drink 50,000 8.00 8.80 Compute the price relatives for this company's products. (Round your answers to two decimal...
You are the CFO of a beer and wine distribution company, B&W Company, which is planning...
You are the CFO of a beer and wine distribution company, B&W Company, which is planning to expand into Florida. The Board has asked you to do an analysis of the expected return on a new warehouse and related equipment required for the expansion. The new warehouse would be more efficient and could handle the volume anticipated in the new territory. The project would require an initial investment of $20 million with an add-on investment of $5 million at the...
A soft drink bottling company just ran a long line of 12-ounce soft drink cans filled...
A soft drink bottling company just ran a long line of 12-ounce soft drink cans filled with cola. A sample of 32 cans is selected by inspectors looking for non-conforming items. Among the things the inspectors look for are paint defects on the can, improper seal, incorrect volume, leaking contents, incorrect mixture of carbonation and syrup in the soft drink, and out-of-spec syrup mixture. The results of this inspection are given here. Construct a c chart from the data. Can...
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...
1.When Coca-Cola traded their soft drink for wine in Slovenia, the company was engaged in: A.Exchange...
1.When Coca-Cola traded their soft drink for wine in Slovenia, the company was engaged in: A.Exchange control. B.Countertrade. C.Tariff trading. D.Quota trade. E.Global bargaining 2. In the global marketplace. Production invention A. is the most inexpensive solution to production introduction B. is the most localized solution to production introduction C. is the most global solution to the production introduction D. is the least commonly enjoyed option to production introduction E. is the most commonly employed option to the production introduction...
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...
A soft drink company has recently received customer complaints about its one-liter-sized soft drink products. Customers...
A soft drink company has recently received customer complaints about its one-liter-sized soft drink products. Customers have been claiming that the one-liter-sized products contain less than one liter of soft drink. The company has decided to investigate the problem. According to the company records, when there is no malfunctioning in the beverage dispensing unit, the bottles contain 1.02 liters of beverage on average, with a standard deviation of 0.15 liters. A sample of 70 bottles has been taken to be...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT