Question

In: Accounting

Lokal Food Manufacturer produces the "Fresh" brand of pasteurised coconut milk from one of its manufacturing...

Lokal Food Manufacturer produces the "Fresh" brand of pasteurised coconut milk from one of its manufacturing processes. The following information of process inputs, outputs and work in process relates to the month of September 2018:

kg

Opening work in process ...........26,700

Raw materials input.................. 110,600

Output completed....................... 98,400

Closing work in process............. 29,200

The opening and closing work in process are respectively 30 per cent and 60 per cent complete as to conversion costs. Raw materials are added at the beginning of the manufacturing process. However, conversion costs are incurred evenly throughout the manufacturing process. Spoilages are assumed to occur at the stage of completion where inspection takes place and these spoilages can be sold to a bio-fuel company at an estimated disposal value $0.25 per kg. Inspection takes place when the products are 90% complete. The opening work in process included raw material costs of $60,920 and conversion costs of $35,597.

Costs incurred during the period were:

Raw material input .......$276,500

Conversion costs.......... $373,248

The company uses FIFO method of process costing and assumes that the normal spoilage are 8 per cent of the good units produced.

Required: (a) Using the 4 step approach:

(i) Compute the cost per equivalent unit for each product cost category for the month of September.

(ii) Calculate the cost of goods transferred to the finished goods store at the end of September.

(iii) Calculate the cost of abnormal spoilage in September.

(iv) Calculate the cost of ending work in process at the end of September.

Solutions

Expert Solution

(i) Cost per equivalent unit for each product cost category for the month of September
Total Units Percentage complete Equivalent Unit
Beginning Work in Process (100% - 30% complete)                  26,700 70%              18,690
Units Started and completed                  71,700 100%              71,700
Normal spoilage                    7,872 90%                7,085
Abnormal spoilage                    1,828 90%                1,645
Ending work in process                  29,200 60%              17,520
Total Equivalent units            116,640
Cost per equivalent unit = Current cost added this period/Total equivalent units
Conversion cost incurred during the period $373,248
Total Equivalent units 116640
Cost per equivalent units $3.20
Equivalent Unit Cost per equivalent unit Total cost
Beginning Work in Process                  18,690 $3.20 $59,808
Units Started and completed                  71,700 $3.20 $229,440
Normal spoilage                    7,085 $3.20 $22,671
Abnormal spoilage                    1,645 $3.20 $5,265
Ending work in process                  17,520 $3.20 $56,064
Total Equivalent units               116,640 $373,248
(ii) The cost of goods transferred to the finished goods store
Material cost Conversion cost Total cost
Beginning WIP $60,920 $35,597 $96,517
Cost added to WIP $59,808 $59,808
Cost of units started and completed $179,250 $229,440 $408,690
Total cost of goods transferred $240,170 $324,845 $565,015
(iii) The cost of abnormal spoilage in September
Abnormal spoilage units 1828
Material cost $4,570
Abnormal spoilage equivalent units 1645
Cost per Equivalent unit $3.20
Conversion cost $5,265
Total cost $9,835
(iv) The cost of Ending Work in Process
Ending WIP units 29200
Material cost (29200 x 2.50) $73,000
Ending WIP equivalent units 17520
Cost per Equivalent unit $3.20
Conversion cost $56,064
Total cost $129,064
Working note:
Physical flow of units
Beginning work in processs 26700
Units started this period 110600
Total units 137300
Units completed and transferred
Beginning work in processs 26700
Units started and completed 71700
Output completed 98400
Normal spoilage 7872
Abnormal spoilage 1828
Ending work in process 29200
Total units 137300
Cost of Raw Material $276,500
Units of raw materials 110600
Cost of each unit $2.50
Cost of units started and trasferred $179,250.00
(71700 x $2.50)

Related Solutions

A food engineer stated that the milk sample he analyzed in the laboratory was “FRESH MILK”...
A food engineer stated that the milk sample he analyzed in the laboratory was “FRESH MILK” in terms of acidity; reported that the concentration of non-sodium hydroxide base used in the experiment was 4 times higher than normal, and the sample analysis amount was used at the standard value.According to this information, how many microliters of base did most people use in the analysis?
Problem 1: a) Marketing mix strategy for a company that produces coconut milk b) Controls and...
Problem 1: a) Marketing mix strategy for a company that produces coconut milk b) Controls and evaluation of the marketing plan to improve sales of coconut milk
A manufacturer supplies fresh milk to high-priced hotels. Advise the manufacturer on a suitable Aggregate Planning...
A manufacturer supplies fresh milk to high-priced hotels. Advise the manufacturer on a suitable Aggregate Planning Strategy. Justify your answer.
The Fresh Detergent Case Enterprise Industries produces Fresh, a brand of liquid detergent. In order to...
The Fresh Detergent Case Enterprise Industries produces Fresh, a brand of liquid detergent. In order to more effectively manage its inventory, the company would like to better predict demand for Fresh. To develop a prediction model, the company has gathered data concerning demand for Fresh over the last 33 sales periods. Each sales period is defined as one month. The variables are as follows: Demand = Y = demand for a large size bottle of Fresh (in 100,000) Price =...
Enterprise Industries produces Fresh, a brand of liquid laundry detergent. In order to manage its inventory...
Enterprise Industries produces Fresh, a brand of liquid laundry detergent. In order to manage its inventory more effectively and make revenue projections, the company would like to better predict demand for Fresh. To develop a prediction model, the company has gathered data concerning demand for Fresh over the last 30 sales periods (each sales period is defined to be a four-week period). The demand data are presented in table concerning y (demand for Fresh liquid laundry detergent), x1x1 (the price...
Q7. Enterprise Industries produces Fresh, a brand of liquid laundry detergent. In order to manage its...
Q7. Enterprise Industries produces Fresh, a brand of liquid laundry detergent. In order to manage its inventory more effectively and make revenue projections, the company would like to better predict demand for Fresh. To develop a prediction model, the company has gathered data concerning demand for Fresh over the last 30 sales periods (each sales period is defined to be a four-week period). Summary of Fit RSquare 0.940514 RSquare Adj 0.928121 Root Mean Square Error 0.18111 Mean of Response 8.382667...
Enterprise Industries produces Fresh, a brand of liquid laundry detergent. In order to manage its inventory...
Enterprise Industries produces Fresh, a brand of liquid laundry detergent. In order to manage its inventory more effectively and make revenue projections, the company would like to better predict demand for Fresh. To develop a prediction model, the company has gathered data concerning demand for Fresh over the last 30 sales periods (each sales period is defined to be a four-week period). The demand data are presented in table concerning y (demand for Fresh liquid laundry detergent), x1x1 (the price...
Efrem Food Products Inc. (EFPI) produces various food products. One of its joint products is soybean...
Efrem Food Products Inc. (EFPI) produces various food products. One of its joint products is soybean that is processed in a joint manufacturing process to produce Soybean Oil and the Meal. The total cost of input and joint manufacturing process is estimated to be $400,000 for 2020. During the year the company expects to produce 45,000 units of Soybean Oil and 35,000 units of Meal. The company has an option to sell Soybean Oil and the Meal at the split-off...
Efrem Food Products Inc. (EFPI) produces various food products. One of its joint products is soybean...
Efrem Food Products Inc. (EFPI) produces various food products. One of its joint products is soybean that is processed in a joint manufacturing process to produce Soybean Oil and the Meal. The total cost of input and joint manufacturing process is estimated to be $400,000 for 2020. During the year the company expects to produce 45,000 units of Soybean Oil and 35,000 units of Meal. The company has an option to sell Soybean Oil and the Meal at the split-off...
Race One Motors is an Indonesian car manufacturer. At its largest manufacturing​ facility, in​ Jakarta, the...
Race One Motors is an Indonesian car manufacturer. At its largest manufacturing​ facility, in​ Jakarta, the company produces subcomponents at a rate of 290 per​ day, and it uses these subcomponents at a rate of 12,800 per year ( of 250 working days).  Holding costs are $2 per item per year, and ordering costs are $31 per order. a, What is the economic production quantity? (ROUND YOUR RESPONSE TO TWO DECIMAL PLACES) b, How many production runs per year will be...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT