Need help on formulas

Using the rounded amounts from the support cost allocation table (previous task), complete the following table to allocate the production department costs to each product line. Round allocated amounts to the nearest whole dollar.

	Thousand Board Feet	Weight Factor	Weighted Thous. Bd. Ft.	Weighted % of Board Feet			Final Department Costs	Cost Allocation to Product Line
Log Yard:
Hardwood					%		$	$
Softwood
Total Log Yard					%			$
Milling:
Hardwood					%		$	$
Softwood
Total Milling					%			$
Drying:
Hardwood					%		$	$
Softwood
Total Drying					%			$
Packaging:
Hardwood					%		$	$
Softwood
Total Packaging					%			$

Forest Land earns revenue of $100,000 from selling its by-products, wood shavings and saw dust. Allocate the revenue to each product line in the following table and determine the final cost per product line.

	Thousand Board Feet	Percentage of Board Feet		By-product Revenue	Portion of By- product Revenue
Hardwood			%	$100,000	$
Softwood				100,000
Total			%		$

	Cost per Product Line
	Hardwood	Softwood
Log Yard	$	$
Milling
Drying
Packaging
Subtotal	$	$
Portion of By-product revenue
Total cost per product line	$	$