No. of Units per Bos No. of Cando per Unit Wholesale Cost per Unit Supplier Overhead Supplier Price Per Unit Sapplier Price Per Bos 10 10 Candy Products Product Product Code Description PC Peppermint Cand MC M Candy FC Fruity Candy sc Sour Candy Caramel Candy GO Guwa Candy RC Rabbit Candy HC Hones Candy 10 5 5 12 12 12 30 30 30 30 FM FM FM PM RM FM RM RM 6.00 500 4.80 10.50 9.00 750 6.00 7.20 Total No. of Order (30) 4 10 14 16 24 16 10 6 8 6 5 5 5 5 5 5 5 10 90 100 Totals client ordering details and the revenues collected. The partly completed spreadsheet from a random week (week 30) is available as a separate attachment. The sales data is collected on a 52-week cycle. Your Tasks: I Required File: JCKW30Sales.xlsx 1. Complete the spreadsheet by filling in the missing data. The formulas required include Vlookup. Countif and Sum. Absolute Addressing is also required. a. Using the data in the "Candy Products" table, complete the "Supplier Price per Unit and **Supplier Price per Box" columns in the same data table. No. of Units per Bos No. of Cando per Unit Wholesale Cost per Unit Supplier Overhead Supplier Price Per Unit Sapplier Price Per Bos 10 10 Candy Products Product Product Code Description PC Peppermint Cand MC M Candy FC Fruity Candy sc Sour Candy Caramel Candy GO Guwa Candy RC Rabbit Candy HC Hones Candy 10 5 5 12 12 12 30 30 30 30 FM FM FM PM RM FM RM RM 6.00 500 4.80 10.50 9.00 750 6.00 7.20 Total No. of Order (30) 4 10 14 16 24 16 10 6 8 6 5 5 5 5 5 5 5 10 90 100 Totals client ordering details and the revenues collected. The partly completed spreadsheet from a random week (week 30) is available as a separate attachment. The sales data is collected on a 52-week cycle. Your Tasks: I Required File: JCKW30Sales.xlsx 1. Complete the spreadsheet by filling in the missing data. The formulas required include Vlookup. Countif and Sum. Absolute Addressing is also required. a. Using the data in the "Candy Products" table, complete the "Supplier Price per Unit and **Supplier Price per Box" columns in the same data table