Brehm Vineyards grows a unique white pinot noir grape that they use to produce a white wine that is in high demand. Brehm uses all the grapes they can grow to produce their own white pinot noir wine. Brehm pinot noir wine contains 100 percent Brehm grown grapes. The company neither buys nor sells grapes. Because of the uniqueness and difficulty of growing white pinot grapes, Brehm can only produce 8,000 cases (12 bottles per case) in a normal year. A good growing season might yield 10,000 cases, whereas bad weather can cut production to 5,000 cases. In a normal year Brehm expects to sells its wine to wholesalers for $ 120 per case.

The following table summarizes how Brehm managers expect their costs to vary with the number of cases produced.

Required: a. Prepare a flexible budget ( including budgeted net income) assuming Brehm produces and sells 8,000 cases of wine. b. Calculate the break- even number of cases. c. How many cases does Brehm have to produce if they want an after- tax profit of $ 300,000 and the income tax rate is 40 percent? d. Bad weather this year cut Brehm’s production and sales to only 6,000 cases. The low yield drove up wholesale prices of the white pinot wine from $ 120 to $ 140 per case. Brehm’s actual expenses for the year were:

Actual Costs for the Year
Grape costs........... $ 260,000
Labor .............98,000
Packaging ...........83,000
Selling and administrative costs.. 39,000
Utilities ...........8,800

Design and prepare a table that reports the performance of Brehm for the year.
e. Write a short memo summarizing Brehm’s performance during the past year. Did management do a good or badjob?

Transcribed Image Text:

Grape costs Labor Packaging Selling and administrative costs Utilities Fixed Cost (per year) $240.000 75,000 Variable Cost (per case) $2.10 2.15 14.00 36,000 4,000 0.75