EXCEL PLEASE

B C D E G . K L M N 1 PETERS PICKLE DAILY SUMMARY OF CUCUMBERS RECEIVED 3 5 6 7 B Graded Quality Total Tonnage Rec'ed Cucumber Cost per Ton Cost of Tonnage Rec'd Grading Fee Total Cost Monthly Payment No A 1100 $330.000.00 Yes 1250 $312.500,00 Yes A 850 S255,000.00 No C 650 $130,000.00 Yes 725 S181.250.00 B $300.00 $250.00 $200.00 $125.00 5% 8 Grower 9 Lennon 10 schropp 11 McCaw 12 Forsyth 13 McGlynn 14 15 16 17 18 Price Based on Quality of Product 19 A 20 B 21 C 22 23 Other Information 24 Grading Fee 25 Interest Rate 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 QUESTION 2 (16 MARKS) As 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. a. Find the worksheet, Question 2", in the file BISM200_ExcelExam_S21. b. Name the range A19:B21 Prices. C. The cost per ton paid to the grower is based on the quality 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 of the 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. 8. 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. PE BE walikuwa B C D E G . K L M N 1 PETERS PICKLE DAILY SUMMARY OF CUCUMBERS RECEIVED 3 5 6 7 B Graded Quality Total Tonnage Rec'ed Cucumber Cost per Ton Cost of Tonnage Rec'd Grading Fee Total Cost Monthly Payment No A 1100 $330.000.00 Yes 1250 $312.500,00 Yes A 850 S255,000.00 No C 650 $130,000.00 Yes 725 S181.250.00 B $300.00 $250.00 $200.00 $125.00 5% 8 Grower 9 Lennon 10 schropp 11 McCaw 12 Forsyth 13 McGlynn 14 15 16 17 18 Price Based on Quality of Product 19 A 20 B 21 C 22 23 Other Information 24 Grading Fee 25 Interest Rate 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 QUESTION 2 (16 MARKS) As 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. a. Find the worksheet, Question 2", in the file BISM200_ExcelExam_S21. b. Name the range A19:B21 Prices. C. The cost per ton paid to the grower is based on the quality 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 of the 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. 8. 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. PE BE walikuwa