In: Accounting
HKUST Inc. made the following transactions:
Prepare Extracted Balance sheet, cash flow statement, and income statement under weighted average method
ANSWER
working | |||||||
1-Jan | Units | Cost | Total cost | ||||
Metal plates | 1200 | 5 | 6000 | ||||
Plastic slabs | 6000 | 1 | 6000 | 12000 | |||
21-Jan | |||||||
Metal plates | 600 | 6 | 3600 | ||||
Plastic slabs | 3000 | 2 | 6000 | 9600 | |||
used | Ending Inventory | FIFO cost | Weighted average | ||||
Total Metal plates | 1800 | 1300 | 500 | 3000 | 2667 | ||
(500*6) | (6000+3600)/1800*500 | ||||||
Total Plastic slabs | 9000 | 7500 | 1500 | 3000 | 2000 | ||
Total | (1500*2) | (6000+6000)/9000*1500 | |||||
FIFO | 6000 | 4667 | |||||
Cost of good sold | |||||||
Metal plates (1200*5)+(100*6) | 6600 | ||||||
Plastic slabs (6000*1)+(1500*2) | 9000 | ||||||
15600 | |||||||
weighted average | |||||||
Metal plates | |||||||
(6000+3600)/1800*1300 | 6933 | ||||||
Plastic slabs | |||||||
(6000+6000)/9000*7500 | 10000 | ||||||
16933 | |||||||
ans 1 FIFO | |||||||
Income statement | |||||||
Sales (18000*10) | 180000 | ||||||
Less: cost of good sold | 15600 | ||||||
Gross profit | 164400 | ||||||
Less: Packaging cost | 5000 | ||||||
Less: credit card expenses | 5400 | ||||||
Net Income | 154000 | ||||||
Balance Sheet | |||||||
Cash (180000*97%)-5000 | 169600 | ||||||
Inventory | 6000 | ||||||
Total assets | 175600 | ||||||
Accounts payable (12000+9600) | 21600 | ||||||
Retained Earnings | 154000 | ||||||
Total liabilities & stockholder equity | 175600 | ||||||
Cash flow statement | |||||||
Cash flow from operating activities | |||||||
Collection from sales | 174600 | ||||||
Paid pakaging expenses | -5000 | ||||||
Ending balance of cash | 169600 | ||||||
weighted average | |||||||
Income statement | |||||||
Sales (18000*10) | 180000 | ||||||
Less: cost of good sold | 16933 | ||||||
Gross profit | 163067 | ||||||
Less: Packaging cost | 5000 | ||||||
Less: credit card expenses | 5400 | ||||||
Net Income | 152667 | ||||||
Balance Sheet | |||||||
Cash (180000*97%)-5000 | 169600 | ||||||
Inventory | 4667 | ||||||
Total assets | 174267 | ||||||
Accounts payable (12000+9600) | 21600 | ||||||
Retained Earnings | 152667 | ||||||
Total liabilities & stockholder equity | 174267 | ||||||
Cash flow statement | |||||||
Cash flow from operating activities | |||||||
Collection from sales | 174600 | ||||||
Paid packaging expenses | -5000 | ||||||
Ending balance of cash | 169600 |
_____________________________________________
If you have any query or any Explanation please ask me in the comment box, i am here to helps you.please give me positive rating.
*****************THANK YOU*************