Inventory 01 July 2017 $ Raw Materials
Inventory 01 July 2017 $
Raw Materials 3,200
Factory Supplies 2,400
Inventory 30 June 2018
Raw Materials 4,ooo
Factory Supplies 1,600
Work in Progress 01 july 2018 7,200
Work in Progress 30 june 2018 11,200
Duty on Raw Materials 3,200
Freight inwards 3,600
Raw Materials purchases 72,000
Factory Supplies purchased 10,400
Direct Labour
Wages Paid 67,600
Manufacturing Overhead
Insurance on Factory Machinery 400
Factory Light and Power 1,600
Factory Manager’s salary 12,000
Foreman’s wages 8,000
Other Indirect Labour 6,400
Repairs to Factory Machinery 2,ooo
Other Manufacturing Overhead 14,000
How to create Manufacturing Statement using excel spreadsheet