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

OR

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 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.

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

Save Time & improve Grades

Just share your requirements and get customized solutions on time.

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,164,011

Orders

4.9/5

Overall Rating

5,051

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

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

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

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.

flag

User Id: 357602 - 14 Dec 2019

Australia

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

flag

User Id: 348363 - 14 Dec 2019

Australia

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

flag

User Id: 348363 - 14 Dec 2019

Australia

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.

flag

User Id: 315260 - 14 Dec 2019

Australia

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