country
$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

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

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

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

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

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 
Next
watch

Save Time & improve Grade

Just share Requriment and get customize Solution.

question
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

1,355,354

Orders

4.9/5

Overall Rating

5,080

Experts

Our Amazing Features

delivery

On Time Delivery

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

work

Plagiarism Free Work

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

time

24 X 7 Live Help

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

subject

Services For All Subjects

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

price

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

Plagiarism Checker

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

essay

Essay Typer

Get different kinds of essays typed in minutes with clicks.

edit

GPA Calculator

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

referencing

Chemical Equation Balancer

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

calculator

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

1

1

1

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.

flag

User Id: 399934 - 04 Jul 2020

Australia

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.

flag

User Id: 448656 - 04 Jul 2020

Australia

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!

flag

User Id: 442767 - 04 Jul 2020

Australia

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

flag

User Id: 455606 - 03 Jul 2020

Australia

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