business report
业务报告 Taps Galore is Singapore based online store owned by Alex and Ash. They supplied four different ranges of taps i.e., value, standard···
Table of Contents
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.
- 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.
译文：一、简介 业务报告
Taps Galore 是 Alex 和 Ash 在新加坡拥有的在线商店。他们提供了四种不同的水龙头系列，即八家制造商库存的价值型、标准型、高级型和至尊型。给定的报告是根据 2018 年 1 月 3 日至 2019 年 12 月 22 日的 Tap Galore 销售记录编制的。在这方面，本业务报告将有助于了解 Taps Galore 当前的盈利能力，并据此预测未来的盈利能力。与此同时，该报告将对毛利润趋势进行描述性、预测性和规范性分析，并针对未来的预期销售提出建议。该报告还将确定免费交付 100.00 美元以上销售的水龙头的影响，根据该影响，将提出有关公司未来需要采用的更改的建议。
1.1 销售额和利润概览
根据数据分析得到以下数据：
2018 年总销量：413
2019年总销售额：521
以下数字显示了 Taps Galore 在 2018 年和 2019 年的范围明智的销售和利润记录。
2018 年和 2019 年的销售额和利润
数据显示了 2018 年和 2019 年 Taps galore 的记录。该记录涉及产品范围、销售额和利润。 Taps 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%.
译文：1.1.2 总销售额和利润 业务报告
从图中可以看出公司2018年1月3日至2019年12月22日产品的整体销售额和利润。
这个数字展示了不同范围的水龙头的整体销售和利润记录。标准是客户高度赞赏的质量，它的总需求为 464，同时它增加了 24634 美元的总利润。仅 103 位顾客要求使用 Superior 对商店收益产生重大影响，并为水龙头创造了 23804 美元。价值是一个重要的范围，因为它为客户和零售商之间的关系创造了良好的活动和机会，并增加了 9723 美元的利润。客户对至尊的需求很低，它在 2018 年和 2019 年涵盖了 9723 美元的水龙头嘉豪。
2 结果分析
2.1 毛利概览
根据 2018-2019 年的销售数据，发现该公司所有水龙头的销售都产生了利润。然而，汉斯格雅制造商的龙头毛利率最高，为 358.49 美元，其中毛利率为 29.66%。记录的最低利润率为 19.73 美元，来自克拉克的龙头，其记录的毛利率百分比为 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 描述性分析 业务报告
数据分析表明，汉斯格雅制造商销售的是优质的产品系列，而克拉克销售的是价值系列的产品。在汉斯格雅和克拉克的案例中，商品的成本价和建议零售价出现了变化，例如汉斯格雅产品 HAN226 的成本价为 850 美元，从 2018 年 4 月到 2019 年 11 月保持不变。同样，克拉克制造商的产品 CLA245 从 2018 年 1 月到 2019 年 12 月的成本为 74.73 美元。但观察到成本价格和建议零售价有一些波动。 2018年tap galore业务的毛利润为28751美元。413款不同档次的产品零售价为120440美元，但tap galore将此价格折价为104830美元。2019年业务从521获得了35622美元的利润售价为 135431 美元，零售价为 149839 美元。考虑到这些趋势，公司 2018 年和 2019 年的盈利能力计算如下：
2.2.1 2018年盈利能力计算
已售产品：413
总零售价：120420
折扣零售价：$104840
制造商利润：$15579
成本价：$80215
建议零售价：108966 美元
利润：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.2.2 2019年盈利能力计算 业务报告
已售产品：521
制造商总零售价：149839$
折扣零售价：1 美元
制造商的利润：$19611.94
成本价：99809 美元
建议零售价：9 美元
Taps Galore 利润：35622 美元
以上2018年和2019年的数据为公司整体利润汇总。
2.2.3 总销售额和盈利能力
销售产品总数：934
制造商总零售价：$270,259.00
折扣零售价：235,067.62 美元
制造商的利润：35,191.38 美元
总成本价：$180,024.00
建议零售价：244,398.28 美元
Taps Galore 利润：64,374.28 美元
下表列出了 2018 年和 2019 年自来水公司毛利润的描述性统计数据。
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.
译文：2.3 预测分析 业务报告
根据数据分析发现，Taps Galore 可以通过保持当前趋势来保持未来的利润。然而，当竞争对手提出包括免费送货在内的不同折扣套餐时，这种情况让 Taps Galore 的所有者感到震惊，因为为了与客户保持联系，有必要为他们提供更具吸引力的东西。
如果 Tap Galore 未能宣布折扣套餐，它将失去其客户。客户有可能在发现其他产品有吸引力时转向他们，因为这将失去公司的盈利能力和知名度。如果公司提供免费送货，它会赢得人气，但会失去盈利能力。此外，如果公司仅在购买超过 100 美元时才提供免费送货服务，那么它将失去潜在买家的购买价值。为了维持公司的利润率，需要采取一些预防措施，使公司永远不会失去盈利能力和知名度。
2.4 规范分析：
基于预测分析，观察到价值具有很高的需求，它在业务的盈利能力中起着重要作用。他们是唯一对免费送货感兴趣的客户，而这不会影响其他人。对于价值超过 100 美元的购买提供免费送货的决定似乎在价值的情况下无效，因此公司可以在这方面采取以下措施：
它必须削减价值的送货费用，可以通过为价值 100 美元或以上的物品提供较低的送货费用来补偿。
此外，公司可以通过对销量较低的产品提供折扣来维持其利润率。
最后，公司可以通过在一个套餐下提供两个不同的范围来维持其利润，从而增加公司的盈利能力。
APPENDICES
Figure I: analysis pf product ranges.
Figure III: Calculating Cost Price
更多其他：代写作业 数学代写 物理代写 生物学代写 程序编程代写 统计代写
