Table 2.5. Inventory list of raw materials in September 2014, DMZ Tourism Joint Stock Company
INVENTORY LIST
September 2014
University of Economics
unmarketable
Hu
Account 152 (Raw materials)
Date
Interpretation | Dry food | Frozen food | Market food | |||||||
SL | DG | TT | SL | DG | TT | SL | DG | TT | ||
Beginning balance | 293 | 10,729 | 3,143,460 | 47 | 119,702 | 5,626,020 | 288 | 49,336 | 14,208,718 | |
1/9 | Enter | 86 | 12,767 | 1,098,000 | 8 | 128,313 | 1,026,500 | 37 | 75,838 | 2,806,000 |
1/9 | Export | 50 | - | - | 20 | - | - | 65 | - | - |
2/9 | Enter | 1 | 37,400 | 37,400 | 14 | 143,686 | 2,011,600 | 55 | 49,546 | 2,725,000 |
2/9 | Export | 140 | - | - | 35 | - | - | 100 | - | - |
3/9 | Enter | 11 | 8,182 | 90,000 | 23 | 82,609 | 1,900,000 | 13 | 43,616 | 567,000 |
3/9 | Export | 135 | - | - | 26 | - | - | 80 | - | - |
… | ||||||||||
September 30 | Export | 52 | - | - | 31 | - | - | 50 | - | - |
Ending balance | 394 | 9,699 | 3,821,210 | 57 | 68,133 | 3,883,550 | 266 | 42,964 | 11,428,410 | |
Maybe you are interested!
-
Ensuring Raw Materials for Production in the Enterprise: -
Current status of production cost accounting and pricing of food and beverage products and services at DMZ Tourism Joint Stock Company - 11 -
Accounting for General Materials and Equipment by Periodic Inventory Method -
Completing the accounting of raw materials at Son Thuy Production and Trading Joint Stock Company - 1 -
Completing the accounting of raw materials for yarn production at Ha Nam Textile Company - 9
Author (signature, full name)
Storekeeper
(Sign, full name)
September 30, 2014 Chief Accountant
(Sign, full name)
University of Economics
unmarketable
Hu
STT | Product name | Head | Enter | Export | Last stock | ||||
I. | DRY FOOD | 293 | 3,143,460 | 2,556 | 1,318,000 | 2,455 | 13,563,525 | 394 | 3,821,210 |
II. | FROZEN FOOD COLD | 47 | 5,626,020 | 421 | 3,038,100 | 410 | 54,496,820 | 57 | 3,883,550 |
III. | MARKET FOOD | 289 | 14,208,718 | 23,361 | 99,064,912 | 23,384 | 94,237,074 | 266 | 11,428,410 |
TOTAL COST | 629 | 22,978,198 | 26,338 | 103,421,012 | 26,249 | 162,297,419 | 717 | 19,133,170 | |
Table 2.6. Summary table of import - export - inventory of raw materials SUMMARY TABLE OF SEPTEMBER 2014
Based on the List of imported and exported materials, we can calculate the export unit price of each type of material as follows:
Day
Material Type | Number quantity | Unit price | Total amount | |
1/9 | Dry food | 50 | 10,729 | = 50*10,729=536,450 |
Frozen food | 20 | 119,702 | =20*119,702=2,394,040 | |
Market food | 65 | 49,336 | =65*49,336=3,206,840 | |
2/9 | Dry food | 140 | 10,729 | =140*10,729=1,502,060 |
Frozen food | 35 | 140,960 | =27*119,702+8*128,313=4,258,458 | |
Market food | 100 | 49,336 | =100*49,336=4,933,600 | |
3/9 | Dry food | 135 | 11,212 | =103*10,729+32*12,767=1,513,631 |
Frozen food | 25 | 120,117 | =14*143,686+12*82,609=3,002,912 | |
Market food | 80 | 49,336 | =80*49,336=3,946,880 | |
… |
After calculating the unit price of each type of raw material, the Accountant will allocate it to each type of party according to the estimated cost of raw materials:
Table 2.7. Estimated cost of raw materials
Target
Estimated material costs | Total | ||
Individual party | Group party | ||
Dry food | 6,000,000 | 9,000,000 | 15,000,000 |
Frozen food | 22,000,000 | 40,000,000 | 62,000,000 |
Market food | 32,000,000 | 71,000,000 | 103,000,000 |
Total | 60,000,000 | 120,000,000 | 180,000,000 |
(Source: Report of the Board of Directors of DMZ Tourism Joint Stock Company).
The allocation formula is as follows:
Material costs allocated to object i
= | Total cost of raw materials to be allocated | x | Estimated cost of raw materials allocated to object i |
Total estimated cost of raw materials to be allocated |
Table 2.8. Material cost allocation table Material cost allocation table
September 2014 Unit: VND
STT
Debit account | Account 6211 – Individual party | Account 6212 – Group party | Total | |
Credit account | ||||
1 | Dry food | 5,425,410 | 8,138,115 | 13,563,525 |
2 | Frozen food | 19,337,581 | 35,159,239 | 54,459,820 |
3 | Market food | 29,277,537 | 64,959,536 | 94,237,074 |
Add | 54,040,529 | 108,256,890 | 162,297,419 | |
Based on the material allocation table, the Accountant will account as follows:
54,040,529 | |
Credit account 15221 – Dry food | 5,425,410 |
Credit account 15222 – Frozen food | 19,337,581 |
Credit account 15223 – Market food | 29,277,537 |
And | |
Debit account 6212 – Group party | 108,256,890 |
Credit account 15221 – Dry food | 8,138,115 |
Credit account 15222 – Frozen food | 35,159,239 |
Credit account 15223 – Market food | 64,959,536 |
At the end of the month, based on the original documents and the Material Allocation Table, the Accountant records in the detailed book of Account 1541 - Direct Material Cost to track in detail the quantity and value of imported, exported and stocked materials during the month. At the same time, prepare a Material Import, Export and Stock Report. (Detailed book of Account 1541 is presented in the appendix).
2.2.2.2. Collect and account for direct labor costs
Labor costs in the cost of food and beverage products and services at the company include: basic salary and allowances payable to workers directly involved in production. It does not include salaries of managers, wages paid to the table department and other services. In addition, direct labor costs in the cost of products also include social insurance, trade union fees, and health insurance that the company must deduct at a rate of 24% of the salary of employees directly involved in processing. Currently, the company calculates social insurance leave as follows:
+ Sick leave: Receive 75% of total salary.
+ Maternity leave: Receive 100% of total salary.
+ Overtime, shift work: Get 35% / 1 day salary.
Because the company applies time-based salary payment, the Timesheet is the initial document used as the basis for calculating salary for employees. After the Timesheet has been created in the Processing Department by the department manager, it will be transferred to the Administration - Human Resources Department for recording and confirmation, then transferred to the accounting department as the basis for calculating and paying salary.
The salary of direct processing staff is calculated according to the following formula:
Time wage
= | Basic salary | x | Salary coefficient | x | Number of working days |
Number of working days according to the regime | |||||
The basic salary applied at the company is: 2,400,000 VND.
Salary coefficient depends on each activity and job of each person, which has its own coefficient.
Currently, the Italian Restaurant's food service staff has 10 people directly preparing food.
Every month, employees can make an advance payment of no more than 42% after working more than half of a month's salary. And on the 5th of each month, the company will pay the employee's salary after deducting the advances and salary deductions that the employee must pay. According to current regulations, salary deductions including social insurance, health insurance, and unemployment insurance that the employee must pay are 10.5% of the basic salary. The salary deduction rate is shown in the following table:
Insurance Type
join
Company (%) | Workers (%) | Add | |
Social insurance | 18 | 8 | 26 |
Health insurance | 3 | 1.5 | 4.5 |
Social Insurance | 1 | 1 | 2 |
KPCĐ | 2 | 2 | |
Add | 24 | 10.5 | 34.5 |
Accordingly, in September 2014, the company has the following Timesheet and Report on total salary fund for social insurance contribution:
DMZ Trading Company
No. 21, Doi Cung, Hue City
Table 2.8. Timesheet for September 2014, DMZ Service and Tourism Company
unmarketable
TIME SHEET
University of Economics
Hu
September 2014
status | Full name | Day of the month, day of the week | Total working days | Paid personal work | On leave | Sick leave with social insurance | |||||||
01 | 02 | 03 | … | 2 9 | 3 0 | ||||||||
Monday | Tuesday | .. | Sunday | Monday | Tuesday | ||||||||
Italian Restaurant | |||||||||||||
1 | Phan Thi Lai | x | x | x | pt | x | x | 26 | |||||
2 | Nguyen Thanh Dung | x | x | x | pt | p | p | 24 | 2 | ||||
3 | Do Van Khuong | Umbrella | Umbrella | Umbrella | pt | x | x | 23 | 3 | ||||
4 | Phan Thi Cam Nhung | x | x | x | pt | x | x | 26 | |||||
5 | Phan Van Hien | x | x | x | pt | x | x | 26 | |||||
6
Nguyen Quang Dan | x | x | x | pt | x | x | 26 | ||||
7 | Le Xuan Tuan | x | x | x | pt | x | x | 26 | |||
8 | Phan Thi Thu | x | x | x | pt | x | x | 26 | |||
9 | Le Kim Thao | x | x | x | pt | x | x | 26 | |||
10 | Phan Trong Phu | x | x | x | pt | x | x | 26 |
unmarketable
Hu
Timekeeping symbols
University of Economics
Overtime: + Unpaid personal matters: R Reduced hours: - Paid personal matters: R 0 Annual leave: P Compensatory leave: NB
Monthly leave: pt Sick leave: ô
Work: x Maternity: ts
Holiday: NL Weekly off: nt
Founder Nguyen Quy Loc
DMZ Trading Company
No. 21, Doi Cung, Hue City
Table 2.9. Report on social insurance contribution fund
REPORT ON SOCIAL INSURANCE CONTRIBUTION SALARY FUND SEPTEMBER 2014
University of Economics
unmarketable
Hu
Minimum wage applies: 2,400,000
Status
Full name | Coefficient | September 2014 | Note | Union (2%) | |
1 | Phan Thi Lai | 1.2 | 2,880,000 | 57,600 | |
2 | Nguyen Thanh Dung | 1.2 | 2,880,000 | 57,600 | |
3 | Phan Van Hien | 1.0 | 2,400,000 | 48,000 | |
4 | Do Van Khuong | 1.15 | 2,760,000 | 55,200 | |
5 | Phan Thi Cam Nhung | 1.0 | 2,400,000 | 48,000 | |
6 | Nguyen Quang Dan | 1.15 | 2,760,000 | 55,200 | |
7 | Le Xuan Tuan | 1.07 | 2,568,000 | 51,360 | |
8 | Phan Thi Thu | 1.07 | 2,568,000 | 51,360 | |
9 | Le Kim Thao | 1.1 | 2,640,000 | 52,800 | |
10 | Phan Trong Phu | 1.0 | 2,400,000 | 48,000 | |
1. Total monthly salary fund of the company (Restaurant) | 26,256,000 | 525,125 | |||
2. Employee social insurance contribution rate: 10.5% x (1) | 2,756,880 | ||||
3. Company's social insurance contribution rate: 22% x (1) | 5,776,320 | ||||
4. Total amount of social insurance paid by the company each month: (2)+(3) | 8,353,200 | ||||
5. Reclaim DN 2% | 167,064 | ||||
6. Closed in September 2014: (4)-(5) | 8,186,136 | ||||
Approved by Director Le Xuan Phuong
Hue, October 3, 2014 City. Administration - Human Resources Nguyen Quy Loc