Answered step by step
Verified Expert Solution
Link Copied!

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."

image text in transcribed

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 Month

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image_2

Step: 3

blur-text-image_3

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Liquidity Risk Management In Banks Economic And Regulatory Issues

Authors: Roberto Ruozi, Pierpaolo Ferrari

1st Edition

3642295800, 978-3642295805

More Books

Students also viewed these Finance questions