=+Ell Decision making SPREADSHEET Oasis Bottling Company bottles popular beverages in the Bottling Department. The beverages are produced by blending concentrate with water and sugar. The concentrate is purchased from a concentrate producer. The concentrate producer sets higher prices for the more popular con¬

centrate flavors. Below is a simplified Bottling Department cost of production report separating the cost ofbottling the four flavors.