Please explain one by one with EXCEL SHEET. it will help me a lot. Tonight is du
ID: 2556624 • Letter: P
Question
Please explain one by one with EXCEL SHEET. it will help me a lot. Tonight is due date. please help me. Thank you.
1&2 picture : Question
3 picture : Need to answer. please help me.
P5-9 Change in unit cost from prior department and valuation of inventory Pasquale Products Co. has two departments: Mixing and Cooking At the beginning of the month, Cooking had 4,000 units in process with costs of $8,600 from Mixing, and its own departmental costs of $500 for materials, $1,000 for labor, and $2,500 for factory over- head. During the month, 10,000 units were received from Mixing with a cost of $25,000. Cooking incurred costs of $4,250 for mate- rials, $8,500 for labor, and $21,250 for factory overhead, and fin- ished 12,000 units. At the end of the month, there were 2,000 units in process, one-half completed. ?07 Required 1. Determine the unit cost for the month in Cooking. 2. Determine the new average unit cost for all units received from MixingExplanation / Answer
Units Unit cost Cost from mixing dept Material Labor fac Overhead Total cost In process, Beginning of the month 4000 2.150 8600 $500 1000 2500 12600 Received from Mixing during the month 10000 2.5 25000 25000 Cost incurred this month 4250 8500 21250 34000 Total units and cost to be accounted for 14000 33600 4750 9500 23750 71600 Avg cost of units from mixing dept 2.40 2.40 (33600/14000) Unit cost for month in cooking with equivalent production 13000 0.365 0.731 1.827 2.923 (4750/13000) unit cost for finished goods 5.323 (2.4+2.923) Assignment of cost Units finished 12000 5.323 28800 4380 8772 21924 63876 12000*2.4 12000*365 12000*.731 12000*1.827 In process end of the month 1000 5.323 4800 365 731 1827 7724 2000*2.4 1000*.365 1000*.731 1000*1.827 Total equ units and cost 13000 5.323 33600 4745 9503 23751 71600 Equivaalent units Finished during the month 12000 equivalent units in process,ed of the month 1000 Equivlent units end 13000