Assignment: Sunflower Inc produces four types (ArtDeco, Modern, Simple, Plain) of decorative vases. Data has been collected related to direct materials and direct labor for the four vases. Sunflower Inc has also collected information on four possible cost drivers (units, setups, machine hours, labor hours). All this information is listed below. Construct a spreadsheet that will allocate overhead and calculate unit cost for each of these alternative drivers. Use the VLOOKUP function when constructing the spreadsheet so that you can determine the effect of different cost drivers on the overhead allocated and the resulting cost per unit. Widget Direct Material Direct Labor Units # of Setups Machine Hours Labor Hours ArtDeco $245,000 $184,000 7,500 5 2,000 150 Modern $156,980 $87,600 18,500 15 4,000 275 Simple $284,000 $80,000 22,900 25 5,500 400 Plain $103,000 $75,000 36,700 45 6,500 800 Total overhead cost to be allocated: $869,000 After constructing your spreadsheet answer the following questions? 1. What is the cost per unit of each vase type when machine hours are used as the cost driver for overhead allocation? 2. How much overhead is allocated to the ArtDeco Vase when direct labor hours are used as the cost driver for overhead allocation? 3. What is the total cost of the Plain vase when direct labor hours are used as the cost driver for overhead allocation? 4. What is the cost per unit of the Modern vase when the number of setups is used as the cost driver for overhead allocation?