Please show work

Product and Department Budgets Using Activity-Based Approach

The following data are from the general records of the Loading Department of Bowman Freight

Company for November.

Cleaning incoming trucks, 20 minutes.

Obtaining and reviewing shipping documents for loading truck and instructing loaders, 30

minutes.

Loading truck, 1hour and 30 minutes.

Cleaning shipping dock and storage area after each loading, 10 minutes.

Employees perform both cleaning and oading task and are currently averaging $18 per hour

in wages and benefits.

The supervisor spends 10 percent of her time overseeing the cleaning activities; 60 percent

overseeing various loading activities; and the remainder of her time making general plans and

managing the department. Her current salary is $4,500 per month

Other overhead of the departmentamounts to $9,000 per month, 20 percent for cleaning and

80 percent for loading.

Required

Prepare an activities budget for cleaning and loading in the Loading Department for November,

assuming 20 working days and the loading of an average of 14 trucks per day.