Securing Higher Grades Costing Your Pocket? Book Your Assignment at The Lowest Price Now!

Prepared To Exhibit Application Of Excel

tag 0 Download3 Pages 594 Words tag Add in library Click this icon and make it bookmark in your library to refer it later. GOT IT


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.

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



Small Business

Grand Total






Office Supplies










Grand Total





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


Darren Budd


John Lucas


Julia West


Matt Abelman


Grand Total


Worst Consumers:

Row Labels

Sum of Profit

Jay Fine


Lela Donovan


Olvera Toch


Patrick Ryan


Susan Vittorini


Grand Total


The best and worst products by products are as follows:


Best Products:

Row Labels

Sum of Profit

Bretford CR8500 Series Meeting Room Furniture


Chromcraft Bull-Nose Wood 48" x 96" Rectangular Conference Tables


Global Troy™ Executive Leather Low-Back Tilter


Hon 94000 Series Round Tables


Riverside Palais Royal Lawyers Bookcase, Royale Cherry Finish


Grand Total


Worst Products:

Row Labels

Sum of Profit

Fellowes PB300 Plastic Comb Binding Machine


GBC DocuBind 200 Manual Binding Machine


GBC DocuBind TL300 Electric Binding System


Hoover WindTunnel™ Plus Canister Vacuum


Smead Adjustable Mobile File Trolley with Lockable Top


Grand Total



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.


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


Cite This Work

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

"Prepared To Exhibit Application Of Excel." My Assignment Help, 2018,

My Assignment Help (2018) Prepared To Exhibit Application Of Excel [Online]. Available from:
[Accessed 14 December 2019].

My Assignment Help. 'Prepared To Exhibit Application Of Excel' (My Assignment Help, 2018) <> accessed 14 December 2019.

My Assignment Help. Prepared To Exhibit Application Of Excel [Internet]. My Assignment Help. 2018 [cited 14 December 2019]. Available from:

For years now, 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.

Latest Finance Samples

AF4S31-Report To The Directors Of AYR Co

Download : 0 | Pages : 13

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 More arrow

FIN303 Financial Management

Download : 0 | Pages : 10

Answer 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 More arrow

BAO2202-Conceptual Framework Of Financial Reporting

Download : 0 | Pages : 15
  • Course Code: BAO2202
  • University: Victoria University
  • Country: Australia

Answer: 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 More arrow

AF4S31 Strategic Financial Management

Download : 0 | Pages : 14

Answer: 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 More arrow

MBA501 Dynamic Strategy And Disruptive Innovation1

Download : 0 | Pages : 10

Answer: 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 More arrow

Save Time & improve Grades

Just share your requirements and get customized solutions on time.

We will use e-mail only for:

arrow Communication regarding your orders

arrow To send you invoices, and other billing info

arrow To provide you with information of offers and other benefits




Overall Rating



Our Amazing Features


On Time Delivery

Our writers make sure that all orders are submitted, prior to the deadline.


Plagiarism Free Work

Using reliable plagiarism detection software, only provide customized 100 percent original papers.


24 X 7 Live Help

Feel free to contact our assignment writing services any time via phone, email or live chat.


Services For All Subjects

Our writers can provide you professional writing assistance on any subject at any level.


Best Price Guarantee

Our best price guarantee ensures that the features we offer cannot be matched by any of the competitors.

Our Experts

Assignment writing guide
student rating student rating student rating student rating student rating 4/5

1309 Order Completed

100% Response Time

Gemmie Chen

MSc in Nursing

Singapore, Singapore

Hire Me
Assignment writing guide
student rating student rating student rating student rating student rating 5/5

529 Order Completed

95% Response Time

Ivan Blank

PhD in Functional Human Biology

Wellington, New Zealand

Hire Me
Assignment writing guide
student rating student rating student rating student rating student rating 5/5

230 Order Completed

97% Response Time

Liya Han

Master Of Science in Geotechnical Engineering (MSc Geotec)

Singapore, Singapore

Hire Me
Assignment writing guide
student rating student rating student rating student rating student rating 5/5

285 Order Completed

99% Response Time

Eugene Baranowski

MBA in Supply Chain

London, United Kingdom

Hire Me

FREE Tools


Plagiarism Checker

Get all your documents checked for plagiarism or duplicacy with us.


Essay Typer

Get different kinds of essays typed in minutes with clicks.


GPA Calculator

Calculate your semester grades and cumulative GPa with our GPA Calculator.


Chemical Equation Balancer

Balance any chemical equation in minutes just by entering the formula.


Word Counter & Page Calculator

Calculate the number of words and number of pages of all your academic documents.

Refer Just 5 Friends to Earn More than $2000

Check your estimated earning as per your ability




Your Approx Earning

Live Review

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.


User Id: 357602 - 14 Dec 2019


student rating student rating student rating student rating student rating

It was very good work and I got an 85% on it. Thank you very much for your help and fast response


User Id: 348363 - 14 Dec 2019


student rating student rating student rating student rating student rating

Was very good work and I get a full mark on it. Thank you very much for your help


User Id: 348363 - 14 Dec 2019


student rating student rating student rating student rating student rating

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.


User Id: 315260 - 14 Dec 2019


student rating student rating student rating student rating student rating
Have any Query?