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.

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.

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.

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.

Attachment:- excel template.xls