Question: Do not Have to use excel to prepare the cost of goods manufactured schedule begin{tabular}{|c|c|c|} hline multicolumn{3}{|l|}{ Costs Incurred: } hline Raw materials purchased

\begin{tabular}{|c|c|c|} \hline \multicolumn{3}{|l|}{ Costs Incurred: } \\ \hline Raw materials purchased & & $186,000 \\ \hline Direct labor & & 99,000 \\ \hline Indirect labor & & 34,000 \\ \hline Equipment maintenance & & 18,000 \\ \hline Insurance on factory & & 19,000 \\ \hline Rent on factory & & 28,000 \\ \hline Equipment depreciation & & 15,000 \\ \hline Advertising expenses & & 27.000 \\ \hline Selling \& administrative expenses & & 46,000 \\ \hline Inventories: & Beginning & Ending \\ \hline Raw materials & $24,000 & $36,000 \\ \hline Work in process & 44,000 & 58,000 \\ \hline Finished goods & 59,000 & 81,000 \\ \hline \end{tabular} 1. Using Excel, prepare a Cost of Goods Manufactured schedule. Refer to Illustration 14.11 in your textbook. 2. Using Excel, prepare a Cost of Goods Sold schedule. Refer to Illustration 14.9 in your textbook
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
