1. Using the below data, calculate the cost per unit for each cost element (materials, overhead, labor) for May using the weighted average approach. Show the answer in an Excel worksheet.

2. Using the below data, calculate cost of goods sold. Show the answer in an Excel worksheet.

Kristina Company, which manufactures quality paint sold at premium prices, uses a single production department. Production begins with the blending of various chemicals, which are added at the beginning of the process, and ends with the canning of the paint. Canning occurs when the mixture reaches the 90% stage of completion. The gallon cans are then transferred to the shipping department for crafting and shipment. Labor and overhead are added continuously throughout the process. Factory overhead is applied on the basis of direct labor hours at the rate of $3.00 per hour. The following data relate to actual production during the month of May: Information for York Plastics as of December 31 follows. \begin{tabular}{|c|c|} \hline Administrative salaries expense. & $135,000 \\ \hline Depreciation expense - Factory equipment... & 52,400 \\ \hline Depreciation expense - Delivery vehicles... & 36,200 \\ \hline Depreciation expense - Office equipment......... & 24,800 \\ \hline & 22,350 \\ \hline Direct labor . & 268,000 \\ \hline Factory supplies used.. & 12,000 \\ \hline Income taxes expense & 91,500 \\ \hline Indirect labor ............ & 35,000 \\ \hline Indirect material & 24,000 \\ \hline Factory insurance. & 15,500 \\ \hline Factory utilities ........... & 14,000 \\ \hline Factory maintenance & 7,500 \\ \hline \multicolumn{2}{|l|}{ Inventories } \\ \hline Raw materials inventory, January 1 ............... & 32,000 \\ \hline Raw materials inventory, December 31 & 28,000 \\ \hline Goods in process inventory, January 1 & 33,780 \\ \hline Goods in process inventory, December 31 & 37,460 \\ \hline Finished goods inventory, January 1 & 56,970 \\ \hline Finished goods inventory, December 31 & 62,000 \\ \hline & 325,000 \\ \hline Rent expense - Factory ................ & 50,000 \\ \hline Rent expense - Office space...... & 24,000 \\ \hline Rent expense - Selling Space ...... & 24,000 \\ \hline Sales salaries expense ............... & 97,500 \\ \hline Sales ....................... & 1,452,000 \\ \hline & 29,000 \\ \hline \end{tabular}