DeLoan Corporation uses a six-month moving average to calculate material scrap rate. Both the auditor and...

DeLoan Corporation uses a six-month moving average to calculate material scrap rate. Both the auditor and technical analyst concur with the use of this procedure. Both have also validated the available data.

Month January February March April May June July

Scrap $6,000 $5,500 $4,200 $6,500 $5,800 $5,300 $5,700

Material Req $100,000 $100,000 $69,000 $105,000 $89,000 $88,000 $99,000

1. What would you estimate the scrap rate to be using a 6-month moving average? 2. Using that scrap rate, what would be your material estimate for a new contract for the item when the material required for the finished product is $90,000? 3. Is your estimate in Question 2 reasonable?

Solutions

Expert Solution

1. What would you estimate the scrap rate to be using a 6-month moving average?

Estimate of the Scrap rate usingg a six month moving average can be calculated by the following method:

Last six months would be from February till July, ie., February, March, April, May, June and July

Scrap rate = (5,500+4,200+6,500+5,800+5,300+5,700)/6 = $5,500

2. Using that scrap rate, what would be your material estimate for a new contract for the item when the material required for the finished product is $90,000?

Based on the scrap rate calculated in the above question number 1, of $5,500, the material estimate for the new contract will be $90,000 + $5,000 = $95,000.

3. Is your estimate in Question 2 reasonable?

Taking into consideration the of the materials requirement in the month of February, the scrap rate was $5,500 but the materials required was $100,000. So our estimate of $95,000 is close and within the specified limit.

I do say that "Yes" it is reasonable.

ekkarill92 answered 1 year ago

Next > < Previous

Related Solutions

Find the MAD for the 3-month and the 12-month moving average forecast. Year Month Rate(%) 2009 ...

Find the MAD for the 3-month and the 12-month moving average forecast. Year Month Rate(%) 2009 Jan 7.9 2009 Feb 8.5 2009 Mar 8.7 2009 Apr 9.1 2009 May 9.4 2009 Jun 9.4 2009 Jul 9.7 2009 Aug 9.5 2009 Sep 9.9 2009 Oct 9.9 2009 Nov 9.9 2009 Dec 9.7 2010 Jan 9.7 2010 Feb 9.6 2010 Mar 9.8 2010 Apr 9.7 2010 May 9.5 2010 Jun 9.4 2010 Jul 9.4 2010 Aug 9.4 2010 Sep 9.4 2010 Oct ...

For the attached data set, 1. create a 3-month and 6-month moving average forecast. 2. Calculate...

For the attached data set, 1. create a 3-month and 6-month moving average forecast. 2. Calculate the standard errors 3. compare their forecast accuracy Month/Year Unemployment rate Jan-17 5.1 Feb-17 4.9 Mar-17 4.6 Apr-17 4.1 May-17 4.1 Jun-17 4.5 Jul-17 4.6 Aug-17 4.5 Sep-17 4.1 Oct-17 3.9 Nov-17 3.9 Dec-17 3.9 Jan-18 4.5 Feb-18 4.4 Mar-18 4.1 Apr-18 3.7 May-18 3.6 Jun-18 4.2 Jul-18 4.1 Aug-18 3.9 Sep-18 3.6 Oct-18 3.5 Nov-18 3.5

Alpha Company uses the weighted-average process costing method. During the month of March the direct material...

Alpha Company uses the weighted-average process costing method. During the month of March the direct material equivalent unit cost was $10.00 and the conversion cost equivalent unit was $6.00. Alpha completed and transferred $96,000 of production to the finished goods inventory for the month of March. Use this information to determine the number of units that were transferred from the Work in Process.

Degregorio Corporation makes a product that uses a material with the following direct material standards: Standard...

Degregorio Corporation makes a product that uses a material with the following direct material standards: Standard Quantity is 3.8 kilos per unit; Standard price is $7.00 per kilo. The company produced 5,600 units in November using 21,750 kilos of the material. During the month, the company purchased 24,800 kilos of the direct material at a total cost of $168,640. The direct materials purchases variance is computed when the direct materials are purchased. The direct materials purchase price variance for November...

Gunes Corporation uses the weighted-average method in its process costing system. This month, the beginning inventory...

Gunes Corporation uses the weighted-average method in its process costing system. This month, the beginning inventory in the first processing department consisted of 1,500 units. The costs and percentage completion of these units in beginning inventory were: Cost Percent Complete Materials costs $ 11,300 65% Conversion costs $ 13,500 30% A total of 9,200 units were started and 8,100 units were transferred to the second processing department during the month. The following costs were incurred in the first processing department...

Domingo Corporation uses the weighted-average method in its process costing system. This month, the beginning inventory...

Domingo Corporation uses the weighted-average method in its process costing system. This month, the beginning inventory in the first processing department consisted of 400 units. The costs and percentage completion of these units in beginning inventory were: Cost Percent Complete Materials costs $ 5,500 50% Conversion costs $ 1,700 20% A total of 6,800 units were started and 6,100 units were transferred to the second processing department during the month. The following costs were incurred in the first processing...

Domingo Corporation uses the weighted-average method in its process costing system. This month, the beginning inventory...

Domingo Corporation uses the weighted-average method in its process costing system. This month, the beginning inventory in the first processing department consisted of 1,100 units. The costs and percentage completion of these units in beginning inventory were: Cost Percent Complete Materials costs $ 6,200 50% Conversion costs $ 2,400 20% A total of 7,500 units were started and 6,800 units were transferred to the second processing department during the month. The following costs were incurred in the first processing department...

Gunes Corporation uses the weighted-average method in its process costing system. This month, the beginning inventory...

Gunes Corporation uses the weighted-average method in its process costing system. This month, the beginning inventory in the first processing department consisted of 800 units. The costs and percentage completion of these units in beginning inventory were: Cost Percent Complete Materials costs $ 10,600 65% Conversion costs $ 12,800 30% A total of 8,500 units were started and 7,400 units were transferred to the second processing department during the month. The following costs were incurred in the first processing department...

Annenbaum Corporation uses the weighted-average method in its process costing system. This month, the beginning inventory...

Annenbaum Corporation uses the weighted-average method in its process costing system. This month, the beginning inventory in the first processing department consisted of 400 units. The costs and percentage completion of these units in beginning inventory were: Cost Percent Complete Materials costs $ 5,700 65% Conversion costs $ 6,800 45% A total of 6,500 units were started and 5,900 units were transferred to the second processing department during the month. The following costs were incurred in the first processing department...

Atwich Corporation uses the weighted-average method in its process costing system. This month, the beginning inventory...

Atwich Corporation uses the weighted-average method in its process costing system. This month, the beginning inventory in the first processing department consisted of 600 units. The costs and percentage completion of these units in beginning inventory were: Cost percent complete Material Cost $10,700 70% Conversion Cost $13,900 50% A total of 5,100 units were started and 4,400 units were transferred to the second processing department during the month. The following costs were incurred in the first processing department during the...

Subjects