Answer:
Explanation:
WORK IN PROCESS INVENTORY
May 1 balance 3770 May 31 Finished Goods 9234
31-May Material 11470
31-May labour 13870
31-May Overheads 9431.6
may 31 Balance 29307.6
JOB COST SHEET
Job no. Beg. WIP Material Labour Overheads Total
430 1340 3850 3400 2312 10902
431 0 4680 8170 5555.6 18405.6
TOTAL 1340 8530 11570 7867.6 29307.6
Note: Total cost of Job 429 transferred to Finished goods:
Beginning cost 2430
Add: Material 2940
Add: Labour 2300
Add: Overheads (2300*68%) 1564
Total cost of Job 429 9234
Available Options Are:
A. =SUM(G12:G16).
B. =SUMPRODUCT(B3:F7, B12:F16)
C. SUMPRODUCT(B3:F7, B12:F16).
D. =SUM(B12:F16)
Answer:
Option B. =SUMPRODUCT(B3:F7, B12:F16)
Explanation:
Here we need summation of two rows B3:F7 and B12:F16. The formula that we will use will be SUMPRODUCT. To calculate sum product in I3 we will edit equal sign first and then "SUMPRODUCT(,)". Then complete the rows that we want to add. Before the coma sign we will place the first row which is B3:F7 and after the coma sign we will place the second row which is B12:F16. In this way we would compute the summation of values present in both rows.
This means that only Option B is correct here.
Option A is not correct because it is the summation of cells present in a single column which doesn't include any cost item assigned. Hence it is incorrect as the formula must be the summation of 2 rows.
Option C is incorrect because it doesn't includes equal sign at the start.
Option D is incorrect because it is only the sum of a single row B12:F16, hence it is incorrect.
Answer:
a) unemployment rate = 15
b) unemployment rate = 2.5
Explanation:
unemployed people are those who are willing and available to work and have actively been seeking a job in the past four weeks. This accurately describes the 12 people who are willing, able and looking for work but cannot find jobs. To calculate the unemployment rate in percentage, the following formula is used:
Where:
a) Number of unemployed = 12
Labour force = 80 (number of people over 16 years of age)
b) if 10 of the unemployed people get discouraged and give up looking for work, the number of unemployed becomes 2 persons, (12 - 10 = 2).