Cost Accounting.

please complete in excel thank you.

Your wellness clinic wants to develop a product cost for the following activities using labor expense and supply expense to assign direct costs and visit minutes as a cost driver to assign indirect costs. Projected total costs for your wellness clinic are $600,000 ($300,000 direct and $300,000 indirect). Assign costs to each activity using the following information: Projected Volumes Labor Expense (5) Supply Expense (5) Activity Visit Minutes Evaluation Education Exercise 4,000 3,000 2,000 30 50 5 10 20 0 60 40 90