Question
Santosh corporation produces a single product that is manufactured in two departments, Assembly and Finishing. Units of Product are started in the Assembly Department and
Santosh corporation produces a single product that is manufactured in two departments, Assembly and Finishing. Units of Product are started in the Assembly Department and then transferred to the Finishing Department, where they are completed. Units are inspected for spoilage in the Finishing Department exactly halfway through the production process. If spoilage is detected at this time,the spoiled units are removed from production and scrapped. Good units are transferred to finished goods inventory, normal spoilage is charged to good units completed, and abnormal spoilage is charged as a period expense to the income statement. Normal spoilage is expected to be 10% of the good units transferred to finished goods inventory during the month.
At the end of June, 12,000 units were still in process in the Finishing Department, 40% complete as to materials and 30% complete as to conversion costs. During July, 25,000 units were transferred from the Assembly Department to the Finishing Department, and 28,500 were transferred from the Finishing Department to finished goods inventory. At the end of July, the Finishing Department still had 4,500 units in process, 60% complete as to materials, and 40% complete as to conversion costs. Cost data related to July operations for the Finishing Department is provided below. Manufacturing overhead is applied to production in the Finishing Department at the rate of 120% of direct labor cost. Beginning Inventory: Cost From Preceding Department:$65,000 Direct Materials:12,000 Direct Labor:30,000 Current Period Costs: Costs From Preceding Department:76,200 Direct Materials:80,400 Direct Labor:227,000
Required:
1.Data should be input in the sheet
DATA SECTION | |||||||||
Company Name | St. John's Corporation | ||||||||
Department | |||||||||
Period Ending | |||||||||
Cost Flow | Enter 1 or 2 in Cell B15 | ||||||||
1=FIFO | 2=AVERAGE COST | ||||||||
Percentage Complete | Dollars of Cost | ||||||||
Prior | Direct | Direct | Manufacturing | Prior | Direct | Direct | Manufacturing | ||
Physical | Department | Materials | Labor | Overhead | Department | Materials | Labor | Overhead | |
Units | Costs | Costs | Cost | Cost | Costs | Cost | Cost | Cost | |
Beginning WIP | |||||||||
United Started | |||||||||
Units Completed | |||||||||
Current Period | |||||||||
Costs | |||||||||
Normal Spoilage | |||||||||
(Units) OR | |||||||||
(Percentage of | |||||||||
Good Units) | |||||||||
Ending WIP |
Step by Step Solution
There are 3 Steps involved in it
Step: 1
![blur-text-image](https://dsd5zvtm8ll6.cloudfront.net/includes/images/document_product_info/blur-text-image.webp)
Get Instant Access with AI-Powered Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
![blur-text-image](https://dsd5zvtm8ll6.cloudfront.net/includes/images/document_product_info/blur-subtext-image.webp)
Step: 3
![blur-text-image](https://dsd5zvtm8ll6.cloudfront.net/includes/images/document_product_info/blur-subtext-image.webp)
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started