B C D PETERS PICKLE M DAILY SUMMARY OF CUCUMBERS RECEIVED Grower Graded Quality Total Tonnage Rec'ed Cucumber Cost per Ton Cost of Tonnage Rec'd Grading Fee Total Cost Monthly Payment Lennon No A 1100 $330,000.00 Schropp Yes 1250 $312,500.00 Mccaw Yes A 850 $255,000.00 Forsyth No 650 $130,000.00 McGlynn Yes 725 $181,250.00 18 Price Based on Quality of Product A $300.00 B $250.00 C $200.00 Other Information Grading Fee $125.00 Interest Rate 5%QUESTION 2 [16 MARKS} s the accountant for Peter's Pickles you must determine the daily cost of the cucumbers received by the factory from the cucumber growers. In your file you are provided the template and daily tonnage received. You must calculate the total costs and payments that will spent to the growers over the next 12 months. 3. Find the worksheet, "Question 2", in the file BISM200_ExceIExam_521. b. Name the range 1119:3321 "Prices\". c. The cost per ton paid to the grower is based on the qualityr of the cucumbers received. The quality ratings are A,B, or C. Using the information provided calculate the cucumber cost per ton to be paid to the grower based on the quality ofthe grower's cucumber shipment. d. Calculate the total cost of the cucumber tonnage received for each grower. e. Some growers grade their own cucumbers and some allow the factory to perform this function. Calculate the total grading fee for each grower in column G. If the grower has graded their own cucumbers there is no charge from Peter's Pickles. Total grading cost is the total tonnage received multiplied by the grading fee. f. Calculate the total cost of the cucumbers, which includes the total cost of cucumber and grading COStS. g. To help with cash flow Peter can pay each grower a monthly payment for the next 12 months. The interest rate is provided in other information. Calculate the monthly payment Peter must make to each grower. h. Sum the appropriate columns and double underline. i. Format the numbers with the appropriate number format. j. Sort the list of growers based on Total Cost, from largest to smallest. k. Centre the title in A1 and A2 across the report. I. Adjust the header row to make the report look professional. Centre, wrap, and adjust columns as needed. m. Adjust the worksheet to make it print on one page in landscape. n. Create a footer on the worksheet with your name, file name code and date