solve in excel with working notes

Question 5 Weather instruments assembles products from component parts. It has two departments that process all products. During January the beginning work-in-process in the assembly department was half completed as to conversion and complete as to direct materials. The beginning inventory included $12,000 for materials and $4,000 for conversion costs. Overhead is applied at the rate of 50 percent of direct manufacturing labour costs. Ending work-in-process inventory in the assembly department was 40 percent complete. All spoilage is considered normal and is detected at the end of the process. Beginning work-in-process in the finishing department was 75 percent complete as to conversion and endinB work-in-process was 25 percent converted. Direct materials are added at the end of the process. Beginning inventories included $16,000 for transferred-in costs and $20,000 for conversion costs. Overhead in this depart Create a report that includes the information below for your boss. You should also explain the differences between the two and a recommendation of which methodology is better for the company. Prepare a production cost worksheet using weighted-average for the assembly department and FIFO for the finishing epartment assuming that spoilage is recognized