Cost+Sheet+Math Updated
Cost+Sheet+Math Updated
Revenue 500000
(-) Cost of goods sold 400,000
Gross Profit 100,000
DM 114,000
DL 180,000
Prime Cost 294000
DL 180,000 60%
Indirect manufacturing cost / Factory OH 120,000 40%
Conversion Cost 300,000 100%
1 of 2
(+) Manufacturing OH / Factory Overhead (W-1) 120,000
Total Manufacturing Cost 414000
(+) WIP- Opening W-I-P 34000
Total WIP 448000
(-) WIP- E 28,000
Cost of goods Manufactured 420,000
(+) Finished Goods - O F/G 30,000
Cost of goods available for sale 450,000
(-) Finished goods – Ending 50,000
Cost of goods sold 400000
2. The following information has been taken from the Visic company’s production, sales & cost
records for the just completed year:
Production in Units 30,000
Sales in Units (10,00,000/50=20000) 20, 000
Ending finished goods inventory in units (30,000-20000) ?10,000
Sales in dollars 10,00,000
Costs:
Advertising – Selling and Administrative 1,15,000
Entertainment & travel- Selling and Administrative 40,000
Direct Labor 90,000
Indirect Labor- Factory overhead 85,000
Raw materials purchased 500,000
Building Rent (production uses 60% of the space; administrative & 40,000
sales offices use the rest)---40000*60%=24000 factory overhead
; 40000*40%= 16000 –Selling and administrative
Utilities, factory 108,000
Royalty paid for use of production patent,1.5 per unit produced ?45000
(30,000*1.5=45000)…factory overhead
Maintenance, factory 9,000
Rent for special production equipment,11000 per year plus 0.30 per ?
unit produced (11,000+0.30*30000= 11000+9000=20,000)..factory
overhead
Selling & administrative salaries 2,10,000
Other factory overhead costs 6,800
Other selling & administrative expenses 17,000
Beginning of End of
the year Year
Inventories:
Raw materials 40,000 20,000
Work in process 60,000 30,000
Finished goods 10,000 ?
The finished goods inventory is being carried at the average unit production cost for the year. The
selling price of the product is tk. 50 per unit.
Required:
2 of 2
1. Prepare the statement of cost of goods manufactured.
2. Prepare income statement for the year.
Ending Finished Goods = (Cost of goods manufactured/ Production Units)* Ending Finished
Goods
Income Statement
Revenue 10,00,000
(-) COGs 635,200
Gross Profit 364800
(-) Operating Expense
3 of 2
Net Loss 33200
Net Profit (33200)
4 of 2
10 50,000 5,000
25 50,000 2,000
50 50,000 1,000
Income Statement
Absorption Costing- External Variable Costing – Internal Decision
Reporting—Mandatory making..Not Mandatory
Sales Sales
(-) Cost of Goods sold (-) Variable Cost
Gross Profit Contribution margin
(-) Operating Expense (-) Fixed Cost
Selling and Administrative Net Profit
Net Profit
5 of 2