ATC 8-7 Spreadsheet Assignment Mastering Excel Wilkin Fruit Drink Company planned to make 400,000 containers of apple juice. It expected to use two cups of frozen apple concentrate to make each container of juice, thus using 800,000 cups ( 400,000 containers 2 cups) of frozen concentrate. The standard price of one cup of apple concentrate is $0.25. Actually. Wilkin produced 404.000 containers of apple juice and purchased and used 820,000 cups of concentrate at $0.26 per cup. Required a. Construct a spreadsheet template that could be used to calculate price and usage variances. The template should be constructed so that it could be used for any problem in the chapter that refers to price and usage variances by changing the data in the spreadsheet. The screen capture on this page represents a terriplate for price and usage variances. Spreadsheet Tip (1) The shaded cells can be changed according to the data in each problem. All other cells are formulas based on the numbers in the shaded cells