In order to maintain a modicum of ties to Canada Justin Bieber developed a product called Blend it like Bieber a maple and honey blend designed to compete with table syrups, honey, and other honey-like natural sweeteners.

The honey is sourced from a private Bee Farm on the outskirts of Medicine Hat, Alberta from 4th generation bee farmers. The maple syrup comes from a maple syrup production plant in Val-dOr in the province of Quebec.

Last year was the first year for Blend it like Bieber and had sales of $5,799,000. BILB only sells wholesale and only has two sizes. A price of $3.25 for their 150mL bottle and $6.75 for their 475mL bottle. Sales were nearly even with the 475 mL bottle selling 812,700 units only 3,000 more units than the small bottle. A price change is planned and it is estimated that unit sales will rise.

A. Create a sales budget with the projected units and sales prices for next year.

Use your projected unit sales to create a production budget to answer the question below.

Beginning Inventory Ending Inventory

150mL bottle 120,400 units ???,??? units

475mL bottle 89,200 units ???,??? units

Blend it like Bieber Inc. wants ending inventory to be 25% of sales for the smaller bottles and 15% for the larger bottles

B. Create a production budget for both size bottles based on all the above information.

The blend can be broken down into three parts:

Maple: 40%, Honey 10%, Other Additives 50%.

The cost for the parts is as follows

Maple Syrup = $10 / liter

Honey = $17 / liter

Additives = $4 / liter

Liter = 1000 mL

C. Create a Direct Materials Purchases Budget for both size bottles based on all the above information.

D. What is the projected Gross Margin (Sales COGS) for next year?