Answer:
Total department cost of 70,000 units = $856,500
Total department cost of 80,000 units = $940,000
Total department cost of 90,000 units = $1,024,500
Explanation:
Note: See the attached excel file for the flexible budget.
A flexible budget is a budget that changes, flexes or adjusts as the volume, activity or unit of production changes.
For this question, the direct labor cost for each unit can be calculated as follows:
Direct labor time per filing cabinet in minutes = 18
Number of minutes in one hour = 60
Direct labor rate per minute = Direct labor rate per hour / Number minutes in one hour = $28 / 60 = $0.466666666666667
Direct labor cost per filing cabinet = Direct labor time per filing cabinet in minutes * Direct labor rate per minute = 18 * $0.466666666666667 = $8.40
Direct labor cost of a particular units of production = Direct labor cost per filing cabinet * Number of units of production ................... (1)
Using equation (1), the Direct labor cost of different units of production used in the attached excel file is calculated as follows:
Direct labor cost of 70,000 units = $8.40 * 70,000 = $588,000
Direct labor cost of 80,000 units = $8.40 * 80,000 = $672,000
Direct labor cost of 90,000 units = $8.40 * 90,000 = $756,000
