Question

In: Accounting

Wisconsin Milk and Ice Cream Manufacturing operates a single plant in Sun Prairie, Wisconsin. It manufactures...

Wisconsin Milk and Ice Cream Manufacturing operates a single plant in Sun Prairie, Wisconsin. It manufactures milk and ice cream for retail and private label marketers in the Midwest.

Joint costs Joint costs of processing raw milk Cream Liquid Skim
Joint costs $                      1,000,000
[from 300,000 gallons of milk]
Separable costs buttercream $                               600,000
Separable costs milk $                         500,000
Raw Milk is processed further to make Cream and Liquid Skim Cream is processed further to make Buttercream Liquid Skim is processed further to make Milk
Cream Liquid Skim Buttercream Milk
Beg Inventory (Gallons) 0 0 0 0
Production 100,000 150,000 90,000 125,000
Transfer 100,000 150,000
Sales in June 80,000 115,000
End inventory (Gallons) 10,000 10,000
Selling price per gallon 25 18 40 50
Required:
1). Compute the Net Realizable Value (NRV) Method
2). Compute the Product Line Income statement for month ended June using the NRV Method

Requirements:

Compute the Net Realizable Value (NRV) method.

Complete the Product Line Income statement for month ended June using the NRV Method

Solutions

Expert Solution

Net Realizable value = Sale value - Further processing cost

Here sale value should be taken for total production.

Butter cream Milk
Units Produced 90000 125000
Selling price 40 50
Sale value of production 3600000 6250000
(-) Further processing cost
or separable cost (SC) 600000 500000
NRV = Sale value - S.C 3000000 5750000

Question - 2

The Joint cost of 1000,000 to be shared between these two products using the NRV method. That means we use NRV ratio = 3000,000 : 5750,000 or 12 :23

Butter cream = 1000,000 * 12/35 = 342,857

Milk = 23 / 35 * 1000,000 = 657,143

Product line Income statement

Butter cream Milk Total
Joint cost 342857 657143 1000000
Seperable cost 600000 500000 1100000
Total cost 942857 1157143 2100000
Units produced 90000 125000
Cost per unit 10.47618889 9.257144
Sales Revenue 3200000 5750000 8950000
(-) Cost of goods sold 838095 1064572 1902667
Gross profit 2361905 4685428 7047333

Related Solutions

Wisconsin Milk and Ice Cream Manufacturing operates a single plant in Sun Prairie, Wisconsin. It manufactures...
Wisconsin Milk and Ice Cream Manufacturing operates a single plant in Sun Prairie, Wisconsin. It manufactures milk and ice cream for retail and private label marketers in the Midwest. Requirements: Compute the Net Realizable Value (NRV) method. Complete the Product Line Income statement for month ended June using the NRV Method Follow the instructions on the Data tab of the worksheet. Show all calculations within the cells of the Excel spreadsheet. This means that you must use formulas and links...
Dairies make low-fat milk from full-cream milk. In the process of making low-fat milk, the cream , which is made into ice cream
Dairies make low-fat milk from full-cream milk. In the process of making low-fat milk, the cream , which is made into ice cream . In the market for low-fat milk, the following events time. Explain the effect of each event on the supply of low-fat milk. ( i ) With advice from health - care experts, dairy farmers decide to switch from producing 18 cream milk to growing vegetables. ( ii ) A new technology lowers the cost of producing ice cream....
A manufacturing plant produces the cardboard cut outs that will be used to wrap ice cream...
A manufacturing plant produces the cardboard cut outs that will be used to wrap ice cream cones. Circles with a radius of 6 inches are punched out of a sheet of cardboard. Next, a sector of the circle must be cut out from the circle so that the cardboard can be rolled up into a cone. To determine the angle of the sector that needs to be cut out to maximum the volume of the cone, one must calculate the...
At an Ice Cream Store, a single scoop of ice-cream can be modeled by a hemisphere...
At an Ice Cream Store, a single scoop of ice-cream can be modeled by a hemisphere which is 1 inch tall. The ice-cream fits perfectly on top of a cone that is 4 inches tall and has a 1 inch radius at the top. 1. Write one equation in Cartesian coordinates (x, y, z) to describe the scoop and one equation for the cone. 2. If the mass of one scoop of ice cream is 60 grams and that the...
Irene operates an ice cream store called Ice Queen Irene’s Ice Cream Dream, Incorporated. Irene is...
Irene operates an ice cream store called Ice Queen Irene’s Ice Cream Dream, Incorporated. Irene is the sole owner and shareholder. The company has been in operation for a few years now, so much that Irene has been able to hire employees and pay herself a salary of $150, 000 per year for being the President, CEO and Operations Manager of the company. From sourcing more affordable products, to keeping up to date with the industries latest gadgets for efficiency,...
Devon’s total production of milk Devon’s total productio­­­­­n of ice cream Ravi’s total production of milk...
Devon’s total production of milk Devon’s total productio­­­­­n of ice cream Ravi’s total production of milk Ravi’s total production of ice cream Devote all time to producing Milk 80 pints of milk 0 pints of ice cream 175 pints of milk 0 pints of ice cream Devote all time to producing ice cream 0 pints of milk 20 pints of ice cream 0 pints of milk 25 pints of ice cream Note: Assume that both Devon and Ravi can produce...
IcyPop Inc. is an ice cream manufacturing company. It produces two major types of ice-cream products:...
IcyPop Inc. is an ice cream manufacturing company. It produces two major types of ice-cream products: FruityGo and BerryWafers. You have been brought on as an Analyst, with your first task being to ascertain the most appropriate method of assigning overhead costs to its FruityGo and BerryWafers products. The following information relates to these products for the year just ended for its two main production departments. Mixing Packaging Budgeted Overhead $400,000 $80,000 Budgeted Direct Labour Hours: FruityGo 1,000 5,000 BerryWafers...
Single plant wide factory rate: Spotted Cow Dairy Company manufactures three products-whole milk, skin milk, and...
Single plant wide factory rate: Spotted Cow Dairy Company manufactures three products-whole milk, skin milk, and cream- in two production departments, blending and packaging. The factory overhead for Spotted Dairy is $356,400. The three products consume both machine hour and direct labor hours in the two production departments as follows: Blending department. Direct labor hr. Machine hr. Whole milk. 300 880 skin milk. 320. 800 cream. 250. 330 870. 2,010 Packing Department Whole Milk. 370. 490 skin milk. 580. 610...
Candice operates an ice cream parlor in a small town in Tristate area. She knows that...
Candice operates an ice cream parlor in a small town in Tristate area. She knows that this a monopolistically competitive business because other producers in the area supply different flavors of ice cream. Candice runs her business as efficiently as possible, to maximize her profits. This year, Candice charges $5 per ice cream and experiences marginal cost of $3 and average total cost of $4 per ice cream at the optimal level of output. Does Candice have profits in short...
Spotted Cow Dairy Company manufactures three products—whole milk, skim milk, and cream—in two production departments, Blending...
Spotted Cow Dairy Company manufactures three products—whole milk, skim milk, and cream—in two production departments, Blending and Packing. The factory overhead for Spotted Cow Dairy is $226,200. The three products consume both machine hours and direct labor hours in the two production departments as follows: Direct Labor Hours Machine Hours Blending Department Whole milk 250 740 Skim milk 270 670 Cream 210 270 730 1,680 Packing Department Whole milk 330 460 Skim milk 530 570 Cream 150 190 1,010 1,220...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT