Prepared To Exhibit Application of Excel †Myassignmenthelp.Com

Question: Explain On Prepared To Exhibit Application of Excel? Answer: 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: Sum of Profit Column Labels Row Labels Consumer Corporate Small Business Grand Total Furniture 955906.6806 511687.0033 359286.7256 1826880.41 Office Supplies -149505.8175 -121113.7227 -68264.8452 -338884.3854 Technology 167194.3467 20428.45118 72846.53326 260469.3311 Grand Total 973595.2098 411001.7317 363868.4137 1748465.355 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: Row Labels Sum of Profit Barry Gonzalez 18455.84665 Darren Budd 17253.46074 John Lucas 17503.70038 Julia West 16017.74894 Matt Abelman 17604.24995 Grand Total 86835.00666 Worst Consumers: Row Labels Sum of Profit Jay Fine -2198.330655 Lela Donovan -1653.136163 Olvera Toch -1871.43358 Patrick Ryan -1736.580168 Susan Vittorini -1650.35769 Grand Total -9109.838255 The best and worst products by products are as follows: Best Products: Row Labels Sum of Profit Bretford CR8500 Series Meeting Room Furniture 53695.41188 Chromcraft Bull-Nose Wood 48" x 96" Rectangular Conference Tables 44691.36525 Global Troy Executive Leather Low-Back Tilter 99632.3975 Hon 94000 Series Round Tables 40385.99413 Riverside Palais Royal Lawyers Bookcase, Royale Cherry Finish 67802.42325 Grand Total 306207.592 Worst Products: Row Labels Sum of Profit Fellowes PB300 Plastic Comb Binding Machine -9637.6716 GBC DocuBind 200 Manual Binding Machine -10836.0252 GBC DocuBind TL300 Electric Binding System -7992.1809 Hoover WindTunnel Plus Canister Vacuum -7846.2 Smead Adjustable Mobile File Trolley with Lockable Top -9846.7731 Grand Total -46158.8508 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