Explain On Prepared To Exhibit Application of Excel?
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.
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.
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.
The five best and worst customers of the company in terms of profit are shown below:
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 |
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:
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 |
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 |
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:
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
Explain On Prepared To Exhibit Application of Excel?
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.
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.
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.
The five best and worst customers of the company in terms of profit are shown below:
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 |
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:
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 |
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 |
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:
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
To export a reference to this article please select a referencing stye below:
My Assignment Help. (2018). Prepared To Exhibit Application Of Excel. Retrieved from https://myassignmenthelp.com/free-samples/prepared-to-exhibit-application-of-excel.
"Prepared To Exhibit Application Of Excel." My Assignment Help, 2018, https://myassignmenthelp.com/free-samples/prepared-to-exhibit-application-of-excel.
My Assignment Help (2018) Prepared To Exhibit Application Of Excel [Online]. Available from: https://myassignmenthelp.com/free-samples/prepared-to-exhibit-application-of-excel
[Accessed 14 December 2019].
My Assignment Help. 'Prepared To Exhibit Application Of Excel' (My Assignment Help, 2018) <https://myassignmenthelp.com/free-samples/prepared-to-exhibit-application-of-excel> accessed 14 December 2019.
My Assignment Help. Prepared To Exhibit Application Of Excel [Internet]. My Assignment Help. 2018 [cited 14 December 2019]. Available from: https://myassignmenthelp.com/free-samples/prepared-to-exhibit-application-of-excel.
For years now, MyAssignmenthelp.com is providing affordable essay help to millions of students worldwide. Our essay assistance services have helped us in assisting students with even the toughest essay assignments. We take pride in the fact that we cater the best assistance to search terms like help me with my essay. We offer affordable services in the fastest way possible. For our fast delivering services, students trust us with their urgent essay assignment needs. Two of our most popular essay writing services are maths essay help and English essay help.
Answer: Introduction AYR Co. is considering two projects for investment namely Aspire and Wolf with the objective of enhancing shareholders’ wealth and also gain a higher market share. Market research has been already conducted on the two projects and based on the available information, financial analysis needs to be conducted so as to advice on the superior of the two projects. Additionally, the critical qualitative factors also need t...
Read MoreAnswer 1 Part A (i) The interest that will be paid in first month of 25th year of loan is $ 705.6246. The formula for computation of interest is IPMT(Rate, Per, Nper, PV, FV) Accordingly, the formula put in was IPMT(0.036/12,289,360,-800000) The solution that was arrived stands at $ 705.62 Part A (ii) The total amount of interest that will be paid over the life of the loan is $509378.61. Sl No Particulars Amount (...
Read MoreAnswer: Answer 1: Significance of enhancing qualities of financial information: Financial statements of the entity are prepared and presented with the objective of meeting the information needs of the stakeholders of the company. Stakeholders are the parties whose decision making processes are influenced by the financial performance of the reporting entity. There external stakeholders are not involved in the internal business functions. Howev...
Read MoreAnswer: Introduction: “Strategic financial management” is an approach of financial management that takes the concern on the strategic policies and goals of a business. These policies assist the business to make strategies and policies to meet the financial objectives and the goals. This process takes the concern of all the financial related transactions and aspects that could affect the financial process of a business in any manne...
Read MoreAnswer: Introduction: The study focuses on the identification of various categories of stakeholders of chosen organization. Analysis of stakeholders group is done by the application of stakeholder view model that helps in addressing values and morals of stakeholders in managing organization. Such model is regarded as descriptive that helps in providing concepts and language for describing corporations and determining their impact on env...
Read MoreJust share your requirements and get customized solutions on time.
Orders
Overall Rating
Experts
Our writers make sure that all orders are submitted, prior to the deadline.
Using reliable plagiarism detection software, Turnitin.com.We only provide customized 100 percent original papers.
Feel free to contact our assignment writing services any time via phone, email or live chat.
Our writers can provide you professional writing assistance on any subject at any level.
Our best price guarantee ensures that the features we offer cannot be matched by any of the competitors.
Get all your documents checked for plagiarism or duplicacy with us.
Get different kinds of essays typed in minutes with clicks.
Calculate your semester grades and cumulative GPa with our GPA Calculator.
Balance any chemical equation in minutes just by entering the formula.
Calculate the number of words and number of pages of all your academic documents.
Our Mission Client Satisfaction
Gave them a small amount of time and they pulled through for me. Wonderful.Gave them a small amount of time and they pulled through for me. Wonderful.
Australia
It was very good work and I got an 85% on it. Thank you very much for your help and fast response
Australia
Was very good work and I get a full mark on it. Thank you very much for your help
Australia
I still cant find the plagiarism report I was told to below the assignment but it is not there, I really appreciate the help thank you.
Australia