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*************