Coffs Fabricators Ltd makes extensive use of financial performance reports for each of its departments.Most departments have been reporting favourable cost variances with the company's current inventory system.However,management is concerned about the overall performance of the purchasing department.For example,the following information is for the purchasing of materials for a product the company has been manufacturing for several years:
$$\begin{array} { | l | l | l | l | }
\hline \text { Purchase Year } & \text { Quantity Used } & \begin{array} { l }
\text { Average } \
\text { Inventory }
\end{array} & \text { Price Variance } \
\hline 2013 & 5000 & 1000 & \$ 1000 \mathrm {~F} \
\hline 2014 & 10000 & 2500 & 10000 \mathrm {~F} \
\hline 2015 & 0000 & 3000 & 12000 \mathrm {~F} \
\hline 2016 & 7500 & 1875 & 30000 \mathrm { U } \
\hline 2017 & 3100 & 2700 & 3000 \mathrm {~F} \
\hline 2018 & 7000 & 2800 & 9750 \mathrm {~F} \
\hline
\end{array}$$
Required:
a.Calculate the inventory turnover for each year.Can any conclusions be drawn for a yearly comparison of the purchase price variance and the inventory turnover?
b.Identify problems likely to be caused by evaluating purchasing only on the basis of the purchase price variance.
c.What recommendations will improve the evaluation process?
_____________________________________________________________________________________________
_____________________________________________________________________________________________

Question

Coffs Fabricators Ltd makes extensive use of financial performance reports for each of its departments.Most departments have been reporting favourable cost variances with the company's current inventory system.However,management is concerned about the overall performance of the purchasing department.For example,the following information is for the purchasing of materials for a product the company has been manufacturing for several years:
 $$\begin{array} { | l | l | l | l | } 
\hline \text { Purchase Year } & \text { Quantity Used } & \begin{array} { l } 
\text { Average } \
\text { Inventory }
\end{array} & \text { Price Variance } \
\hline 2013 & 5000 & 1000 & \$ 1000 \mathrm {~F} \
\hline 2014 & 10000 & 2500 & 10000 \mathrm {~F} \
\hline 2015 & 0000 & 3000 & 12000 \mathrm {~F} \
\hline 2016 & 7500 & 1875 & 30000 \mathrm { U } \
\hline 2017 & 3100 & 2700 & 3000 \mathrm {~F} \
\hline 2018 & 7000 & 2800 & 9750 \mathrm {~F} \
\hline
\end{array}$$ 
Required:
a.Calculate the inventory turnover for each year.Can any conclusions be drawn for a yearly comparison of the purchase price variance and the inventory turnover?
b.Identify problems likely to be caused by evaluating purchasing only on the basis of the purchase price variance.
c.What recommendations will improve the evaluation process?
_____________________________________________________________________________________________
_____________________________________________________________________________________________

Quizplus · Accepted Answer

The Answer of Coffs Fabricators Ltd makes extensive use of financial performance reports for each of its departments.Most departments have been reporting favourable cost variances with the company's current inventory system.However,management is concerned about the overall performance of the purchasing department.For example,the following information is for the purchasing of materials for a product the company has been manufacturing for several years:
 $$\begin{array} { | l | l | l | l | } 
\hline \text { Purchase Year } & \text { Quantity Used } & \begin{array} { l } 
\text { Average } \
\text { Inventory }
\end{array} & \text { Price Variance } \
\hline 2013 & 5000 & 1000 & \$ 1000 \mathrm {~F} \
\hline 2014 & 10000 & 2500 & 10000 \mathrm {~F} \
\hline 2015 & 0000 & 3000 & 12000 \mathrm {~F} \
\hline 2016 & 7500 & 1875 & 30000 \mathrm { U } \
\hline 2017 & 3100 & 2700 & 3000 \mathrm {~F} \
\hline 2018 & 7000 & 2800 & 9750 \mathrm {~F} \
\hline
\end{array}$$ 
Required:
a.Calculate the inventory turnover for each year.Can any conclusions be drawn for a yearly comparison of the purchase price variance and the inventory turnover?
b.Identify problems likely to be caused by evaluating purchasing only on the basis of the purchase price variance.
c.What recommendations will improve the evaluation process?
_____________________________________________________________________________________________
_____________________________________________________________________________________________

Coffs Fabricators Ltd Makes Extensive Use of Financial Performance Reports