Answered step by step
Verified Expert Solution
Question
1 Approved Answer
Does anyone know Excel spreadsheet? I need your help me with my assignment. pls, can you explain the detail clear and step solve problem? i
Does anyone know Excel spreadsheet? I need your help me with my assignment. pls, can you explain the detail clear and step solve problem? i wanna to learn well from you. thank you guys
instruction: "Problem solutions must make full use of named ranges using the labels indicated for each cell/range."
Problem 5: Commissions Re-create the model below that identifies the attributes of the Top Performer of the Month (the sales Associate with the most accrued sales). Download/import the Monthly_Sales.csv and complete the Monthly_Sales table (Figure 9 Left) used to record each Associate's individual sales for the month as per image below. o To do this, re-create the Commissions Lookup table (Figure 9 Right) defining the commission % for the corresponding SalePrice that falls within a range. Recreate the Performance Table (Figure 10) which is the summary of the individual associate's Monthly Sales with formulas for Properties_Sold; Total_Sales; Commision_Earned Finally, recreate the Top Performer of the Month table (Figure 11) returning the highest Total_Sales from the Performance Table (Figure 10) identifying the Associate; Properties_Sold; Commision_Earned. Key Functions to use: LOOKUP; COUNTIF; SUMIF; MAX; INDEX; MATCH; Monthly Sales: Commissions Lookup Name Sale Price Commission PriceRanges Commissions Irons 790,000 19,750 0 1.0% Forrest 889,000 26,670 100,000 2.0% Karim 923,000 27,690 400,000 2.5% Forrest 973,000 29,190 800,000 3.0% Enders 280,000 5,600 1,000,000 3.5% Irons 339,000 6,780 1,500,000 4.0% Qiu 485,000 12,125 2,000,000 4.5% Irons 551,000 13,775 Qiu 1,240,000 43,400 Qiu 991,000 29,730 Enders 1,277,000 44,695 Irons 777,000 19,425 Enders 262,000 5,240 669,000 1 16,725 Karim 700,000 17,500 Forrest 1,399,000 48,965 Figure 9 - Monthly Sales Table and Commission Lookup Table Karim Commissio Performance Table Properties Total Associate | Sold Sales Enders 1,819,000 Forrest 3,261,000 Irons 2,457,000 Karim 2,292,000 3 2,716,000 Figure 10 - Performance Table 55,535 104,825 59,730 61,915 85,255 Qiu TOP Performer of the Month Total Properties Commissio Sales Associate Sold 3,261,000 Forrest 3 104,825 Figure 11 - Top Performer of the Month Problem 5: Commissions Re-create the model below that identifies the attributes of the Top Performer of the Month (the sales Associate with the most accrued sales). Download/import the Monthly_Sales.csv and complete the Monthly_Sales table (Figure 9 Left) used to record each Associate's individual sales for the month as per image below. o To do this, re-create the Commissions Lookup table (Figure 9 Right) defining the commission % for the corresponding SalePrice that falls within a range. Recreate the Performance Table (Figure 10) which is the summary of the individual associate's Monthly Sales with formulas for Properties_Sold; Total_Sales; Commision_Earned Finally, recreate the Top Performer of the Month table (Figure 11) returning the highest Total_Sales from the Performance Table (Figure 10) identifying the Associate; Properties_Sold; Commision_Earned. Key Functions to use: LOOKUP; COUNTIF; SUMIF; MAX; INDEX; MATCH; Monthly Sales: Commissions Lookup Name Sale Price Commission PriceRanges Commissions Irons 790,000 19,750 0 1.0% Forrest 889,000 26,670 100,000 2.0% Karim 923,000 27,690 400,000 2.5% Forrest 973,000 29,190 800,000 3.0% Enders 280,000 5,600 1,000,000 3.5% Irons 339,000 6,780 1,500,000 4.0% Qiu 485,000 12,125 2,000,000 4.5% Irons 551,000 13,775 Qiu 1,240,000 43,400 Qiu 991,000 29,730 Enders 1,277,000 44,695 Irons 777,000 19,425 Enders 262,000 5,240 669,000 1 16,725 Karim 700,000 17,500 Forrest 1,399,000 48,965 Figure 9 - Monthly Sales Table and Commission Lookup Table Karim Commissio Performance Table Properties Total Associate | Sold Sales Enders 1,819,000 Forrest 3,261,000 Irons 2,457,000 Karim 2,292,000 3 2,716,000 Figure 10 - Performance Table 55,535 104,825 59,730 61,915 85,255 Qiu TOP Performer of the Month Total Properties Commissio Sales Associate Sold 3,261,000 Forrest 3 104,825 Figure 11 - Top Performer of the MonthStep by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started