Question

In: Accounting

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.  


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...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT