Reference no: EM131115949

Problem 1:

Napa Valley Wine Industries of Pacific Coast California in the U.S. creates a unique component to aid in the fermenting of wine in casks in the noted Napa Valley region. The components are sold for $4180 a barrel. Export duties are significant when sold outside the Continental U.S., adding $450 to each barrel exported. The component is sold in various parts of the world where wine making is viewed favorably by the local governments and they hope to compete against the traditional European producers.

The company uses the weighted-average method in its process costing system. The first stage in the production process is carried out in the Fermenting Department, which removes the foreign matter and blends them in the proper proportions in large vats. The POR based on MH is $16.42/MH. The Blending Department adds 80% direct materials at the start of the process. 20% are added at the end of the process. Subsequent to this processing, the product proceeds to a split-off off point and some of the component is processed into raw material for the health care industry.

	Barrels in Fermenting Dept.	Percent Complete Direct Labor	Percent Complete Mfg. Overhead	Percent Complete Direct Material
Work in process 6/1/16	20,000	30%	50%	78%
Work in process 6/30/16	10,000	60%	30%	85%
Started into process in May	386,000	--	--	--
Started into process in June	440,000	--	--	--

The total costs to be accounted for during the month are $537,000. The total value of the ending WIP is $1,205, 200. The WIP costs were 4.93% higher than forecasted due to large internal failure costs with spoiled raw material products.

Prepare the complete schedule of the flow of units and equivalent units in the Mashing Department for June.

Quantities	Physical Units	Equivalent Units Materials	Equivalent Units Direct Labor	Equivalent Units Mfg. Overhead
Units accounted for
WIP, 6/1/16
Started in Production
Total Units
Units accounted for
Finished
WIP, 6/30/16
Total Units

Problem 2:

The Boulder Technology Center has its most recent contribution margin income statement shown on the worksheet. In each of the following scenarios, calculate the values indicated. (CALCULATE ALL CHANGES FROM THE BEGINNING SCENARO OF NUMBERS)

A) The breakeven point in dollars and units.

B) The sales volume decreases by 10% and the price increase by $4.00 per unit.

C) The selling price decreases $2.00 per unit, fixed expenses increase by $300,000, and the sales volume increases by 80%.

D) The selling price increases by 35%, variable expense increases by $21.50 per unit, fixed expenses decrease to $385,000, and the sales volume decreases by 15%.

E) The selling price increases by $7.00 per unit, variable cost increases by 14% per unit, fixed expenses increase by $363,940, and sales volume increases by 4.2%

Calculate the Degree of Operating Leverage for all five scenarios.

Problem 3

Complete the table in the Excel template for Dakota Agricultural Products Industries. The company sells three products: Nitrogen, Premium Seeds, and Fertilizer. Total product sales are $9,200,000. Calculate the sales for each product and the variable cost for each product. Finally, calculate the C/M for each product and the total. Determine the net income or (loss) for the overall company. Indicate the percent of total (two decimal places XX.XX%) for each product for the sales, variable costs and contribution margin.

Calculate the overall sales dollars necessary to break-even. Suggest using the C/M ratio (%) formula.

Problem 4:

The Pittsburgh Biotech Development, Inc. has been instrumental in the revival of economic activity in the Steel City. The company based in suburban Braddock develops, produces and markets two types of Biogen products: AD-882 and SP-664. The below data were gathered on activities last year.

Financial & Operational Information	AD-882	SP-664
Sales in units	2,450	4,800
Selling price per unit	$200	$600
Variable production costs per unit	$40	$116
Traceable fixed production costs	$284,500	$118,500
Variable selling expenses per unit	$8	$35
Traceable fixed selling expenses	$27,900	$48,300
Allocated division administrative expenses	$17,900	$230,500

Prepare a segmented income statement in the contribution format for last year.

Problem 5:

You have been presented with four independent scenarios, i.e. they are not related in any manner. Complete the missing information in the scenarios.

Problem 6:

Golden Adult Beverages of Golden, CO utilizes the weighted-average method in its process costing system. The following data concern the operations of the company's first processing department for a recent month.

Work in process, beginning:
Units in process	19,290
Stage of completion with respect to materials	72%
Stage of completion with respect to conversion	47%
Costs in the beginning inventory:
Materials cost	$167,042
Conversion cost	$986,574
Units activity during the month:
Units started into production during the month	1,738,710
Units completed and transferred out	1,747,000
Costs added to production during the month:
Materials cost	$2,380,464
Conversion cost	$4,626,706
Work in process, ending:
Units in process	11,000
Stage of completion with respect to materials	90%
Stage of completion with respect to conversion	65%

Attachment:- excel template.xls