Cape Electronics sells office furniture with five sales representatives working in their wholesale branch. Varying commission...
Fantastic news! We've Found the answer you've been seeking!
Question:
Transcribed Image Text:
Cape Electronics sells office furniture with five sales representatives working in their wholesale branch. Varying commission percentages are paid based on product sales and commission categories. No commission is paid for monthly product sales below R200 000. The December 2022 product sales for Tim, one of the sales representatives, are given in Table 1, and commission percentages are shown in Table 2 below. Answer the following questions. Table 1 Printers Desktop computers Laptops Smartphones USB cables Product Digital tablets Hard drives Digital mouse Table 2 Commission Cate- gory A B с Quantities Sold 15 40 120 107 520 49 180 290 3 Commission% 15% 13% 11% Unit Cost in Rands Required: 2.1 Create a spreadsheet for the provided data. 2.2 Calculate Tim's total sales. 85000 2.5 Calculate the total commission paid to Tim. Commission Category A 9000 C 8000 B 6500 C 160 A 2500 B 1600 B 180 A 2.3 Use the VLOOKUP function to add the commission percentage to the created table in the spreadsheet. Add the VLOOKUP function used as your answer. (2 marks) (3 marks) 2.4 Calculate the commission from each product's total sales, and where the sale is below R200 000, add the message "No commission." Add a screenshot of your table in Excel showing the formula in the formula bar. (3 marks) (3 marks) (2 marks) HCLT108-1-July-Dec2023-FA2-IM-V.2-29052023 Cape Electronics sells office furniture with five sales representatives working in their wholesale branch. Varying commission percentages are paid based on product sales and commission categories. No commission is paid for monthly product sales below R200 000. The December 2022 product sales for Tim, one of the sales representatives, are given in Table 1, and commission percentages are shown in Table 2 below. Answer the following questions. Table 1 Printers Desktop computers Laptops Smartphones USB cables Product Digital tablets Hard drives Digital mouse Table 2 Commission Cate- gory A B с Quantities Sold 15 40 120 107 520 49 180 290 3 Commission% 15% 13% 11% Unit Cost in Rands Required: 2.1 Create a spreadsheet for the provided data. 2.2 Calculate Tim's total sales. 85000 2.5 Calculate the total commission paid to Tim. Commission Category A 9000 C 8000 B 6500 C 160 A 2500 B 1600 B 180 A 2.3 Use the VLOOKUP function to add the commission percentage to the created table in the spreadsheet. Add the VLOOKUP function used as your answer. (2 marks) (3 marks) 2.4 Calculate the commission from each product's total sales, and where the sale is below R200 000, add the message "No commission." Add a screenshot of your table in Excel showing the formula in the formula bar. (3 marks) (3 marks) (2 marks) HCLT108-1-July-Dec2023-FA2-IM-V.2-29052023 Cape Electronics sells office furniture with five sales representatives working in their wholesale branch. Varying commission percentages are paid based on product sales and commission categories. No commission is paid for monthly product sales below R200 000. The December 2022 product sales for Tim, one of the sales representatives, are given in Table 1, and commission percentages are shown in Table 2 below. Answer the following questions. Table 1 Printers Desktop computers Laptops Smartphones USB cables Product Digital tablets Hard drives Digital mouse Table 2 Commission Cate- gory A B с Quantities Sold 15 40 120 107 520 49 180 290 3 Commission% 15% 13% 11% Unit Cost in Rands Required: 2.1 Create a spreadsheet for the provided data. 2.2 Calculate Tim's total sales. 85000 2.5 Calculate the total commission paid to Tim. Commission Category A 9000 C 8000 B 6500 C 160 A 2500 B 1600 B 180 A 2.3 Use the VLOOKUP function to add the commission percentage to the created table in the spreadsheet. Add the VLOOKUP function used as your answer. (2 marks) (3 marks) 2.4 Calculate the commission from each product's total sales, and where the sale is below R200 000, add the message "No commission." Add a screenshot of your table in Excel showing the formula in the formula bar. (3 marks) (3 marks) (2 marks) HCLT108-1-July-Dec2023-FA2-IM-V.2-29052023 Cape Electronics sells office furniture with five sales representatives working in their wholesale branch. Varying commission percentages are paid based on product sales and commission categories. No commission is paid for monthly product sales below R200 000. The December 2022 product sales for Tim, one of the sales representatives, are given in Table 1, and commission percentages are shown in Table 2 below. Answer the following questions. Table 1 Printers Desktop computers Laptops Smartphones USB cables Product Digital tablets Hard drives Digital mouse Table 2 Commission Cate- gory A B с Quantities Sold 15 40 120 107 520 49 180 290 3 Commission% 15% 13% 11% Unit Cost in Rands Required: 2.1 Create a spreadsheet for the provided data. 2.2 Calculate Tim's total sales. 85000 2.5 Calculate the total commission paid to Tim. Commission Category A 9000 C 8000 B 6500 C 160 A 2500 B 1600 B 180 A 2.3 Use the VLOOKUP function to add the commission percentage to the created table in the spreadsheet. Add the VLOOKUP function used as your answer. (2 marks) (3 marks) 2.4 Calculate the commission from each product's total sales, and where the sale is below R200 000, add the message "No commission." Add a screenshot of your table in Excel showing the formula in the formula bar. (3 marks) (3 marks) (2 marks) HCLT108-1-July-Dec2023-FA2-IM-V.2-29052023
Expert Answer:
Answer rating: 100% (QA)
21 Create a spreadsheet for the provided data Here is a spreadsheet with the provided data Product Quantities sold Unit Cost in Rands Commission Category Commission Percentage Commission Earned Printe... View the full answer
Related Book For
Posted Date:
Students also viewed these programming questions
-
Using JAVA through Netbeans perform the following to create Hypotenous Calculator : The console // output should look like shown below: Operation This application calculates the length of the...
-
To demonstrate the ability to propose, implement, and query the database. Problem: MovinOn Inc. is a moving company that provides moving and storage services in California, Nevada, and Arizona....
-
For each of the following situations, evaluate the segregation of duties implemented by the company and indicate the following: a. Any deficiency in the segregation of duties described (Indicate None...
-
In the first case, the relationship between F and H is found to be inverse when the height decrease the area will increase, and the force will increase too. Therefore, I need a logical and practical...
-
1. Write an equation of the line with x-intercept (3, 0) and y-intercept (0, -2). 2. If x + 7y = 30 and x = -2y, then determine the value of y.
-
Imagine that you won millions of pounds on the National Lottery. Would your economic problem be solved?
-
The cable between two electric transmission towers has a length of \(2000 \mathrm{~m}\). It is clamped at its ends under a tension \(P\) (Fig. 8.25). The density of the cable material is \(8890...
-
Spoilage in job costing. Crystal Clear Machine Shop is a manufacturer of motorized carts for vacation resorts. Peter Cruz, the plant manager of Crystal Clear, obtains the following information for...
-
2. The typical firm in the market operates at the following cost: LRTC = q - 10q + 30q a) Find the minimum efficient scale (MES). Hint: The MES is positive in this case. b) The inverse market demand...
-
Knowing that the tension in wire BD is 1300 N, determine the reaction at the fixed support C of the frame shown. 750 N 150 mm 250 mm 500 mili- 450 N 600 mm 400 mm
-
George Pharmacy is a pharmaceutical salesman who has been very successful at his job in the last few years. Unfortunately, his family life has not been very happy. Three years ago, his only child,...
-
How can you determine whether an organism is heterozygous or homozygous for a dominant trait?
-
A company has employed an independent contractor to construct a reservoir on its land. There were old disused mining shafts under the reservoir site and they led to an adjoining coal mine. The shafts...
-
As mentioned in the chapter, prior experience in an industry helps entrepreneurs recognize business opportunities. This concept extends to prior experience in any aspect of lifewhether it is in...
-
Rawlsworth is an employee of General Sam Corporation. One of Rawlsworths jobs is to monitor the amount of particular pollutants and to record the results on a form that is submitted to the...
-
Explain the technical difference between a cross-fertilization experiment and a self-fertilization experiment.
-
The Parry Company provided the following information regarding its operations: End of Year 1 End of Year 2 Total assets $ 60,000,000 $ 65,000,000 Year 1 Year 2 Net operating income $ 885,000 $...
-
suppose a nickel-contaminated soil 15 cm deep contained 800 mg/kg Ni, Vegetation was planted to remove the nickel by phytoremediation. The above-ground plant parts average 1% Ni on a dry-weight bas...
-
Most Canadian labour codes require that a collective agreement be a minimum of one year in length. Why do you think this requirement exists?
-
Outline the arguments for and against the use of replacement workers.
-
Outline the stages of union-management negotiations.
-
Sketch a hypothetical scatterplot for a sample of size 10 for two random variables with a population correlation of (a) 1.0; (b) -1.0 ; (c) 0.9; (d) -0.5 ; (e) 0.0.
-
Using the data in Exercise 3.3: a. Construct a \(95 \%\) confidence interval for \(p\). b. Construct a \(99 \%\) confidence interval for \(p\). c. Why is the interval in (b) wider than the interval...
-
Explain why the differences-of-means estimator, applied to data from a randomized controlled experiment, is an estimator of the treatment effect.
Study smarter with the SolutionInn App