Huskie Mills produces three different types of fabric using two departments. The first department is Weaving and the second department is Dyeing. The unit of measure for fabric is a bolt. Bolts contain 20 years of fabric each. All fabric is inspected during production. Robotic equipment inspects the fabric for obvious flaws as the bolts are wound up. Each bolt spends about five minutes in the inspection process. The Dyeing department goes through a set-up process each time the color is changed.

Previously, Huskie used a process costing system that assigned Direct Material costs to each product separately, but allocated Direct Labor and Overhead costs as if they were incurred equally across the bolts produced. Huskie Mills typically has no beginning or ending inventory in any given month. During the month in question, no spoilage was recorded.

Required: Develop an Excel workbook with one or more worksheets to perform the following calculations. Use a Data Input section and maximize the use of cell referencing. Use traditional process costing to assign the Direct Materials and Conversion costs to the bolts of the three different types of fabric. Develop a Cost per Bolt for each type of fabric which illustrates the amount of Direct Material and Conversion in each bolt. Specifically illustrate the Conversion Cost per Bolt, the Total Cost assigned to each type of fabric and the Cost of Bolt of each type of fabric.

	Denim	Light Weight Cotton	Heavy Weight Cotton	Total
Direct Cost
Direct Materials
Dept 1	$6,000	$16,000	$15,000	$37,000
Dept 2	$2,000	$8,000	$5,000	$15,000
Direct Labor
Dept 1	$840	$2,400	$1,200	$4,440
Dept2	$480	$1,440	$640	$2,560
Overhead Cost
Machine				$40,000
Setup				$12,000
Inspection				$25,000
Total Overhead				$77,000
Volumes
Units(bolts)	2000	8000	4000	14000
Direct Labor hours	33	96	46	175
Macine Hours	500	2000	1500	4000
Number of set-ups	10	30	20	60
Inspection Hours	180	80	240	500

please explain or show work on how you got answers