This is managerial accounting. Write and complete a production report from given

Question

This is managerial accounting.

Write and complete a production report from given data. If you need more information, let me know.

It would be great if it could be completed in an excel and show a good shot of it or download it so I could see it and learn from it,

Thanks in advance!

Using the Given data, produce the Manufacturing Production Report.

Highlight the reconciled numbers in BLUE (6)

omeIert gLaet Formulas Data Review iew Whap led Bad Calculation Check Cell indeit Det Fomat 131 3 Given data: 4 Steve Manufacturing 5 June 1 WIP beginning Inv. Enter formulas in these fields 24,000 60% complete $186,256 $64,864 Overhead $34,400 Steve Manufacturing Production Report Physical Flow (1) To Be Accounted For (2BA4) Beginning Inventory Started/Added during the period Total To Be Accounted For (28A4) Costs 2BA4 3) 11 June transferred out units 70,000 Units 100% Complete 13 Costs added DM DL Overhead$117,600 $267,880 $253,000 Equivalent Units (2) % complete Equivalent Units 17 Transferred Out Ending Inventory 19 June 30 ending inventory 10,000 units 70% complete Total Accounted For (A4) Cost to be accounted for Equivalent Units Equivalent Unit Cost 23 ssig Costs (5) Equivalent Units Units Equiv. Unit Cost Costs Accounted for Transferred Out Ending Inventory Total Costs Accounted for (AA Solution O Type here to search

Explanation / Answer

Physical flow Units Dollars Beginning inventory 24000 285520 Started or added during period 56000 638480 Total to be accounted for 80000 924000 Accounted for Units % complete Equivalent units Transferred out 70000 100% 70000 Ending inventory 10000 70% 7000 Total accounted for 80000 77000 Equivalent unit cost Cost to be accounted for 924000 Equivalent units 77000 Equivalent units cost 12 Assign cost Equivalent units Units Equivalent units cost Costs accounted for Transferred out 70000 12 840000 Ending inventory 10000 8.4 84000 Total cost accounted for 924000 (12*70%=8.4)

Related Questions

Navigate

• Browse (All)
• Browse T
• Subjects

---

---

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.