Answered step by step
Verified Expert Solution
Link Copied!

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

Income Tax Fundamentals 2013

Authors: Gerald E. Whittenburg, Martha Altus Buller, Steven L Gill

31st Edition

1111972516, 978-1285586618, 1285586611, 978-1285613109, 978-1111972516

More Books

Students also viewed these Accounting questions