Sunday, November 3, 2019

Group assignment for bussiness information system

Group for bussiness information system - Assignment Example This shows that the percentage of sales during the promotional sales period is 70.92% which is very high and therefore it indicates that the promotional sales campaigns offered by the cafà © have been very successful. Moreover, the data reveal that the best products sold throughout in the data include the music CDs, bread and coffee. Revenues generated from CDs were equal to $776,813.17. The value of total sales from selling bread were $27,560.59 and there were 3,271 breads sold by the cafà ©. Moreover, after selling 2,495 coffees the cafà © has been able to accumulate $112,354 as revenues. After analyzing the data it has been found that the month of March is the best month for The Broadway Cafà ©. The total sales that have been report by the cafà © in the month of March have a value of $575,843.30. However, this figure does not include the return or refund sales which have a value of $6,504.20. Therefore the net sales or revenues generated from the month of March were equal to $569,339.10. This shows that the percentage of total sales in the month of March is equal to 28% of the total sales. Moreover, the least transaction occurred in the month of September. There have been several problems in the data and therefore these problems could influence the findings presented in the report. For instance, there have been several entries missing in the data and if these entries are recorded appropriately then the findings could have been changed. For instance, as it has been found that the month of March has the highest sales, and September has the lowest sales but what if several transactions for the month of September are missed. Therefore, these issues could influence the findings of the data and thus the analysis that has been based on the missing data can be changed. Moreover, there are certain mistakes or data entered seems to be inaccurate as customer number 6541 purchased coffee of $1,549 in the first month of year 2005 which clearly seems

No comments:

Post a Comment

Note: Only a member of this blog may post a comment.