EXCEL REPORT DATA JUAN GARCIA

Excel report Data Juan Garcia



Excel Report Data Juan Garcia

Answer 1

Following are the best selling products in each of the three regions which include Quebec, Manitoba and Ontario in which the company operates. The analysis has done by breaking down the units sold and by $ sold.

The Quebec Region

In the Quebec region the binder is the highest selling brand, the transaction associated with binder has occurred five times. The total amount of sales relating to the sales binder estimates to be $3,718.66. 234 Units of binder have sold during the year. The second item that has been sold the highest are the pen sets. The transaction relating pen sets has occurred three times. The total sales that have been generated through the sales of pens seats amounts to $2,765.68. Similarly the total units sold during the year amounts to 152 unit's .the third item that has sold the highest are the pens. The total sales value that has been achieved through selling 175 units of pens in the Quebec region amounts to $2,131.25, similarly the fourth item that has generated the maximum sales are pencils. The total sales generated through pencils amount to $474.20. 135 units of pencils have been sold in the Quebec region throughout the year

The Manitoba Region

In the Manitoba region the desk is the highest selling item, the transaction associated with binder has occurred just once and only 3 units of binder has been sold but it has achieved amount of sales. The total amount of sales relating to the sales of desk estimates to be $1,647.00. The second item that has been sold the highest is the pencils. The transaction relating pencil has also occurred once. The total sales that have been generated through the selling 88 units of pencils totaled $280.72. The third item that has sold the highest are the pens. The total sales value that has been achieved through selling 76 units of pens in the Manitoba region amounts to $196.84

, similarly the last item that has generated the maximum sales are binders. The total sales generated through binders amount to $174.93. The total units of binders that have been sold in the Manitoba region amounts to 7 units.

The Ontario Region

In the Ontario region the binder is again the highest selling brand, 424 Units of binder have sold during the year and the transaction associated with binder has occurred eight times. The total amount of sales relating to the sales f binder estimates to be $7995.16. The second item that has been sold the highest are the pen sets. The transaction relating pen sets has occurred four times and the total units sold amount to 243 units. The total sales that have been generated through the sales of pens seats amounts to $3370.47. The third item that has sold the highest are the desk. The total sales value that has been achieved through selling desk in the Ontario region amounts to ...