B C Module 12 Problem Sets Complete the following problems using this Excel worksheet. Show your formulas' in the cells at the right Refer to formula review in module topic 1. Solve the following: Determine the annual sales per square foot Department Store Accessory Area: 12 ft X 8 ft Annual sales $82,500 2. Determine Annual sales per square foot Specialty store: Sweater department Sweater area: 35 ft x 15 ft Annual sales for store: $1,568,000 Sweater department percent of sales: 11% 3. Average sales are $985.00 per square foot per year the area is 30 X 25 ft What is the planned sales volume per year? Use the following information to solve #4 and #5 The average sales per square feet of a department is $56.50 per square foot per week and the area is 25 X 15ft 4. What is the planned sale volume for one week? 5. What is the planned sales volume for one year? Sheet1 +