商业报告代写-business report代写-商科论文代写

Student Name

Student ID

商业报告代写 On the basis of sales data for year 2018-2019 it has been found that the company was generating profits on the sales of all taps.

1 Introduction……………………………………………………………………………………………………………………………….2

1.1 Overview of sales and profits………………………………………………………………………………………………………2

1.1.1 Sales and profits during 2018 and 2019………………………………………………………………………………..2

1.1.2 Overall sales and profits………………………………………………………………………………………………………….3

2 Results analysis……………………………………………………………………………………………………………………………4

2.1 Overview of gross profits…………………………………………………………………………………………………………….4

2.2 Descriptive Analysis…………………………………………………………………………………………………………………..4

2.2.1 Calculating the Profitability for Year 2018………………………………………………………………………………….4

2.2.2 Calculating the Profitability for Year 2019………………………………………………………………………………….4

2.2.3 Total Sales and Profitability………………………………………………………………………………………………………5

2.3 Predictive Analysis………………………………………………………………………………………………………………………5

2.4 Prescriptive Analysis:…………………………………………………………………………………………………………………..6

APPENDICES…………………………………………………………………………………………………………………………………..7

1 Introduction 商业报告代写

Taps Galore is Singapore based online store owned by Alex and Ash. They supplied four different ranges of taps i.e., value, standard, superior, and supreme stocked from eight manufacturers. The given report is prepared based on the sales of Tap Galore sales record from 3 Jan 2018 – 22 Dec 2019. In the regard, present business report will help to understand the current profitability of Taps Galore based on which future profitability will be predicted. Along with this the report will present the descriptive, predictive and prescriptive analysis of the gross profit trends on which the recommendations for expected sale in future will be given. This report will also determine the effects of free delivery of taps on sale above $100.00 based on which the recommendation will be presented regarding the changes company needs to adopt in future.

1.1 Overview of sales and profits

Based on data analysis following figures were obtained:

Total sale in 2018: 413

Total sales in 2019: 521

Following figures are presenting the records of range wise sales and profits of Taps Galore for the year 2018 and 2019.

1.1.1 Sales and profits during 2018 and 2019

Figures are presenting the record of Taps galore for the year 2018 and 2019. This record is dealing with the product ranges, their sales and the profits. Taps galore earned the sufficient revenues in the sale of standard range, as this range has the significant demand among the customers. Superior is also the highly demanded range among the customers, and it played a significant role in the revenues of tap galore.

1.1.2 Overall sales and profits

The overall sale and profits of the products of the company from Jan 3, 2018 to Dec 22, 2019 can be viewed from the given figure.

This figure is presenting the overall sales and profits records of different ranges of tap galore. Standard was the highly appreciated quality among the customers, it had the total demand of 464 while it added the 24634$ in total profits of tap galore. Superior was only demanded by 103 customers while it had the significant impacts on the store earnings and generated $ 23804 for the tap galore. Value was an important range as it created the good activities and opportunities for the relation between customers and retailers and added $ 9723 in the profits. Customers had the low demand for the supreme and it covers $ 9723 in 2018 and 2019 for tap galore.

2 Results analysis 商业报告代写

2.1 Overview of gross profits

On the basis of sales data for year 2018-2019 it has been found that the company was generating profits on the sales of all taps. However, tapware from Hansgrohe manufacturers yields the highest percentage gross profit margin recorded was $358.49 of which the gross profit margin percentage was 29.66%. The recorded least profit margin was $19.73 obtained from the tapware of Clark for which the recoded gross profit margin percentage was 26.40%.

2.2 Descriptive Analysis

As data analysis depict that Hansgrohe manufacturers were selling the superior range of product and Clark were selling the value range of products. There were observed variations in the cost prices and recommended retail prices of the goods which were maintained in the case of Hansgrohe and Clark for example the cost price of Hansgrohe product HAN226 was $850, and it remain same from April 2018 to November 2019. In the same way the product CLA245 of Clark manufacturers were costing $74.73 from January 2018 to December 2019. 商业报告代写

However there observed some fluctuations in cost price and recommended retail price. In 2018 tap galore business has the gross profits of $ 28751. The retail price of the 413 products of different ranges were $ 120440 but tap galore discounted this price at $ 104830. In the way in 2019 business earned the profits of $ 35622 from 521 sales and sold at $ 135431 retailed price which was discounted from $ 149839 retailed price. Keeping in view these trends the profitability of the company for year 2018 and 2019 was calculated as follow:

2.2.1 Calculating the Profitability for Year 2018

Products Sold: 413
Total Retail Price: 120420
Discounted Retail Price: $104840
Manufacturers Profit: $15579
Cost Price: $80215
Recommended Retail Price: $108966
Profit: $28751

2.2.2 Calculating the Profitability for Year 2019

Products Sold: 521
Total Retail Price of manufacturers: 149839$ 商业报告代写
Discounted Retail Price: $1
Manufacturer’s profit: $19611.94
Cost Price: $99809
Recommended Retail Price: $9
Taps Galore Profit: $35622

Above data for year 2018 and 2019 is presenting the overall profit summary of the company.

2.2.3 Total Sales and Profitability

Total Products Sold: 934
Total Retail Price of manufacturers: $ 270,259.00
Discounted Retail Price: $235,067.62
Manufacturer’s profit: $35,191.38
Total Cost Price:$180,024.00
Recommended Retail Price: $244,398.28
Taps Galore Profit: $64,374.28

Table below is presenting the descriptive statistics for the gross profits for the tap galore for the year 2018 and 2019.

Mean	68.92
Median	48.99
Mode	19.73
Standard deviation	70.89

2.3 Predictive Analysis

Based on data analysis, it has been found that Taps Galore can maintain its profits in the future by maintain its current trends. However, when competitors come up with different discount packages including free delivery the situation become alarming for the owners of Taps Galore because for maintain ties with customers it become necessary to provide them something more appealing. 商业报告代写

If Tap Galore fails to announce discount package it will lose its customers. There was the chance that the customers when find other offerings attractive they switched to them due to which the profitability as well as popularity of the company will lose. If company offers free delivery it will gain the popularity but lose the profitability. Moreover, if the company offer free delivery only on the purchase of above $100 than it will lose its potential buyer buying Value. For maintain the profit margins of the company there is need to take some precautionary measures so that company can never losses its profitability nor popularity.

2.4 Prescriptive Analysis:

Based on predictive analysis, it was observed that value has the high demand, and it plays an important role in the profitability of the business. They were the only customers interested in free delivery while it was never affecting others. The decision of offering free delivery for purchases above $100 does not seems effective in case of Value therefore company can take following measure in this regard:

It must cut short the delivery fee for value which can be compensated by offering lesser delivery fee for the items cost $100 or above.
Additionally, company can maintain its profit margins by offering discounts over the products having lesser sale.
Finally, company can maintain its profits by offering two different ranges under one package which will therefore increase the profitability for the company.