Answered step by step
Verified Expert Solution
Question
1 Approved Answer
This table Transaction Entry keeps each transaction made by each sales representatives. The SalesPrice and UnitCost are both for per unit of goods. Use the
This table "Transaction Entry" keeps each transaction made by each sales representatives. The SalesPrice and UnitCost are both for per unit of goods. Use the table "UnitCost" to Complete the Column "UnitCost" (column H) in the "Transaction Entry" table. For example, cell H5 should be 350 since the cost of product "Quad" is 350 in the East region according to the UnitCost table. Hint: use two-way vlookup (5%) Complete the "Profits" column in the "Transaction Entry" table (column I) for each transaction. Profit = (SalesPrice - UnitCost)* Units (5%) In the column "# of Transactions" of the "Profit" table (column L), count the number of transactions occurred in each region. Hint: use countif, each row in the Transaction Entry table is a separate transaction (5%) In the column "Profit" of the "Profit" table (column M), calculate the TOTAL PROFITS generated in each region. Hint: use the sumif function. (5%) Draw a PIE CHART for the profit column you calculated in the last step, Showing the total sales in each region. (5%)
Step by Step Solution
★★★★★
3.43 Rating (166 Votes )
There are 3 Steps involved in it
Step: 1
Lets go through each step systematically Step 1 Complete the UnitCost column in the Transaction Entry table using a twoway VLOOKUP function To complet...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