Answer:
Lamination= $50,000
Explanation:
Giving the following information:
Metro Inc. has two production departments:
Lamination and Molding
Three service departments:
Human Resources, Technology Support, and Purchasing.
The $200,000 costs of Human Resources are allocated based on the number of employees in each production department.
The Lamination department has 40 employees.
The Molding department has 120 employees.
Proportion of employees:
Lamination= 40/160= 25%
Molding= 120/160= 75%
Allocation:
Lamination= 200,000*0.25= $50,000
Molding= 200,000*0-75= $150,000
1. Vlookup and Hlookup
2. Pivot table
3. some IF functions such as countif, countifs
Answer:
$152.4 million
Explanation:
The computation of the projected net income is shown below:
As we know that
Net income = (EBIT - interest) × (1 - tax rate)
where,
EBIT = Sales - operating cost
= $700 × 120% - ($700 × 120% × 65%)
= $840 - ($840 × 65%)
= $840 - $546
= $294
The interest expense and tax rate is $40 and 40%
So, the projected net income is
= ($294 - $40) × (1 - 40%)
= $152.4 million
We simply applied the above formula so that the projected net income could be come
The primary purpose of the Statement of Cash Flows is d) to provide information about a firm's cash inflows (receipts) and outflows (payments).