$20 Bonus + 25% OFF
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

Download Sample

Get 100% money back after download, simply upload your unique content* of similar no. of pages or more. We verify your content and once successfully verified 100% value credited to your wallet within 7 days.

Upload Unique Document

Document Under Evaluation

Get Credits into Your Wallet

*The content must not be available online or in our existing Database to qualify as unique.

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 04 July 2020].

My Assignment Help. 'Prepared To Exhibit Application Of Excel' (My Assignment Help, 2018) <> accessed 04 July 2020.

My Assignment Help. Prepared To Exhibit Application Of Excel [Internet]. My Assignment Help. 2018 [cited 04 July 2020]. 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

BE314 Financial Modelling

Download : 0 | Pages : 10
  • Course Code: BE314
  • University: University Of Essex
  • Country: United Kingdom

Answers: Introduction One of the major responsibilities of the Agri-Food and Veterinary Authority of India is to supervise and coordinate the production of all the imported agricultural productions of India. Thus, the director of the company is interested to identify and analyse the issues that are related to the economy of rice. Nine major rice brands have been considered for the study. The brands of rice are stored in stores of New Delhi an...

Read More arrow

BAO5534 Business Finance

Download : 0 | Pages : 9
  • Course Code: BAO5534
  • University: Victoria University
  • Country: Australia

Answers: Introduction The managers of the entity are accountable for the conduct of the business operations in a manner that leads to the wealth maximization of the shareholders as well as the consideration of the interests of the other stakeholder groups within the business entity. Further to note, that business conduct within an organisation involves undertaking of varied strategic decisions in the areas of the operating, investing and fina...

Read More arrow Tags: Australia 34 Business finance Victoria University 

FIN 200 Business Finance And Group Assignment

Download : 0 | Pages : 9
  • Course Code: FIN 200
  • University: University Of Phoenix
  • Country: United States

Answer: 1.1 Depicting the monthly payment: Particulars Value Loan amount  $ 20,000,000 Tenure 120 Interest rate 0.67% Monthly payment  $ 242,655 1.2 Depicting how much is the first payment interest: Particulars Value Loan amount  $ 20,000,000 Interest rate 0.67% First payment is interest  $ ...

Read More arrow

HI5002: Finance For Business Analyse

Download : 0 | Pages : 7

Answer: Introduction  In this report, financial analysis of Lefroy exploration limited has been taken into consideration. There are several financial analysis tools that have been taken to analysis the performance of company such as ratio analysis, bottom up analysis and share price movement analysis. This financial analysis of Lefroy exploration limited will help in evaluating the business performance of company. It will help investors ...

Read More arrow

MAA250 Ethics And Financial Services Assessment

Download : 0 | Pages : 9
  • Course Code: MAA250
  • University: Deakin Business School
  • Country: Australia

Answer: Introduction: Directors and management contributes the man power into the bank and in return, they expect from the company monitory and non monetary items such as salary, incentive, bonus and sweat shares. Shareholders: Shareholders of CBA contribute the money and the funds in the organization for the operations and new projects of the company and in return, they expect dividends from the company. Dividends of shareholder depend on ...

Read More arrow Tags: Australia Murdoch Management University of New South Wales Humanities 

Save Time & improve Grade

Just share Requriment and get customize Solution.

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

248 Order Completed

100% Response Time

Lloyd Bernabe

MSc in Accounting

London, United Kingdom

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

798 Order Completed

97% Response Time

Benjamin Blakeman

MSc in Medical Technology

London, United Kingdom

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

1592 Order Completed

96% Response Time

Jane Sima

Ph.D in Psychology with Specialization in Industrial-Organizational Psychology

Singapore, Singapore

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

203 Order Completed

97% Response Time

Richard Alpert

PhD in Psychology

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

I got 85% in that assignment. Which really helps me to gey good scores in that unit. Thanks.


User Id: 399934 - 04 Jul 2020


student rating student rating student rating student rating student rating

I got great feedback from my instructor and my grade was 100%. thank you for all your help.


User Id: 448656 - 04 Jul 2020


student rating student rating student rating student rating student rating

Thank you, this is the first time I did not have to change anything in the requested essay. Great job!


User Id: 442767 - 04 Jul 2020


student rating student rating student rating student rating student rating

I'm happy. On time and very professional. It was done to my instruction. I'll use the service again


User Id: 455606 - 03 Jul 2020


student rating student rating student rating student rating student rating
callback request mobile
Have any Query?