Instructions: Use the data provided in problems 1 and 2 below to compute answers to the associated questions. Be sure to build tables and construct formula that link related cells. Problem 1 Bell's Beach Shop sells beach chairs, swimming apparel, and beach acccesories. The owner, Rachel Bell, purchases inventory throughout the month at variable cost 1.1 Given the following data, what is the weighted average cost of Rachel's beach chair inventory? Build a data table to help find the solution. 8 high chairs (blue): $35 each 6 high chairs (green) : \$25 each 5 low chairs (purple): $20 each 3 low chairs (pink) : \$19 each 1.2 If Rachel sells 4 blue high chairs and makes a $60 purchase for 2 new yellow high chairs ( $30 each), what is Rachel's updated average cost of inventory for the beach chairs? Problem 2 Blue Ice Ski Shop has 12 retail locations. 6 of the stores are "small format" with average sales of \$281 per square foot. Three of the stores are "mid-sized" with averages sales of $242 per square foot. The remaining three outlets are "large scale" formats with average sales of $186 per sqaure foot. 2.1 What is Blue Ice's weighted average sales per square foot across their three different store types? 2.2 If Blue Ice were to sell two of their three large scale outlets, how would that impact averages sales per square foot? What would be the new weighted average sales per square foot