Prepared To Exhibit Application Of Excel

Explain On Prepared To Exhibit Application of Excel?

Introduction:

ABC Superstore Victoria is a Australian retail company, which uses to trade office supplies, furniture and technology. It supplies the products to the small businesses, corporate houses and direct consumers. Currently, the firm is suffering from lower profit margins. Hence, it requires to analyze its sales data properly for improving its profit earning capacity.

The report analyzes the sales data as per the objectives of the management by using excel functions. The operating plans, recommended in this report, are based on the outcomes of the analysis.

Sales & Cost Structure Evaluation:

The following graph exhibits that the company has generated maximum sales from the furniture products, whereas, office supplies has provided minimum contribution in the total sales.

However, the costs, incurred for office supplies, are higher than its sales figure. The difference between the sales and costs of furniture is quite higher, but for technology products, this difference margin is comparatively lower than furniture.

Profit Structure:-

The profit, earned by the company, is classified in the following table under different product category and consumer category:

The outcomes are exhibited in the following graph further:

From the table, it is clear from the table that the company has incurred losses for selling office supplies to every consumer segments. The graph also displays that it has earned maximum profits from consumer segments.

Consumer & Product Performance:

The five best and worst customers of the company in terms of profit are shown below:

Best Consumers:

Worst Consumers:

The best and worst products by products are as follows:

Best Products:

Worst Products:

Recommendations:

From the above analysis, it can be stated that the company should implement some new strategies for improving the financial performance. It may follow the recommendations discussed below:

• Some of the products are sold at a price lower than its cost price. Hence, the price structure should be revised to generate profits.
• The company should give more focus on the office supplies, as this segment has incurred losses and make proper strategies to improve its sales volume.
• The profit margin of technology products can be increased by rising its selling price or by increasing its overall sales.

References:

Bell, P.C., 2000. Teaching business statistics with Microsoft Excel. INFORMS Transactions on Education, 1(1), pp.18-26.

Jackson, M. and Staunton, M., 2006. Advanced modelling in finance using Excel and VBA (Vol. 394). John Wiley & Sons

Klein, T., 2015. BUAD 242: Advanced Excel Techniques

Korol, J., 2016. Microsoft Excel 2016 Programming by Example. Stylus Publishing, LLC.

McFedries, P., 2016. Excel 2016 formulas and functions. Que.

Zapawa, T., 2005. Excel Advanced Report Development. John Wiley & Sons