To prepare the DSS model, certain steps to be followed with some extent formula and relationship stating. When the model is prepared, the model is processed in software so that outcomes can be viewed as well. Moreover, the steps are described in detail underneath:
First step: Now to present the values in table format, software syntax requires to initialize the variables. Now, the rows and columns are initialized in suitable manner. In this particular problem, the rows are initialized where years can be shown from 2017 to 2021. To perform the initialization of columns, the syntax is applied as “*Columns *Years 2017, 2021”.
Again, for rows, the aspects are considered as initialization parameters “rate of discount, starting investment amount, market share percentage, produced volume, production volume in market, revenue amount, individual unit selling price, production cost, individual unit production cost, profit amount, and overhead cost per year”. Now, the variables are initialized in syntax as “*Rows *var-1…var-2”…and so on.
Second step: Next step includes putting necessary rows and columns with formula. Part of the proper model application, rows of the model requires to apply formula for data processing. The columns and rows will be presented as following:
Third step: Furthermore, the ‘keep’ button is clicked for saving the model. ‘Process’ button is clicked for preparation of the report. As the model is prepared in report, the heading is included.
Figure 1: Prepared DSS Model
(Source: Created by author)
NPV calculation was performed with considering the analysis of the DSS model. Primary constraints are taken as with selling price, production cost, investment, market share, discount rate, and overhead cost, were provided for Ciscomic Private Limited. As per the mentioned steps, the scenario is depicted in the visual DSS. As per the calculations, the prepared report is shown as underneath.
DSS model estimated that Net Present Value (NPV) is $1,259,404 considering the present value and the investment at the starting of business. Finally, the claim of reaching more than $2 million is wrong. Designed report has shown NPV amount as underneath:
Figure 2: Prepared NPV Report
(Source: Created by author)
As per the distributions, syntax is considered to obtain the normal distribution, triangular distribution, and uniform distribution. Moreover, the formulas are; for normal distribution: NOR (a;b), for triangular distribution: TRI (a;b;c), and for uniform distribution: UNI (a;b) is used. In this formula, a, b and c are provided values in the problem. The relationships are changed as following;
Figure 3: Prepared risk analysis model with uncertainties (1)
(Source: Created by author)
As per provided information in case study, the model is prepared while taking the previous model. Earlier model was prepared without the distributions, therefore, in the new model, the syntax for some lines are changed. Moreover, the model is processed for getting outcomes and the report is prepared as well. The risk analysis was considered with 100-iterations and the outcomes are recorded in the report. Risk analysis was considered for production price, overhead cost, investment, market share, and NPV.
Figure 4: Prepared report with uncertainties (1)
(Source: Created by author)
Above model of the risk analysis clearly shows that there are more than 20% chances of gaining more than $1 million NPV. After proceeding year, the chances are more than 20% for the company with changed production planning.
Chart 5: Prepared chart with uncertainties (1)
(Source: Created by author)
Cumulative probabilities report and chart clearly shows the chances of gaining NPV value are more than 20%.
Part 1
Figure 6: Prepared risk analysis model with uncertainties (2)
(Source: Created by author)
As per the changed scenario of selling price and production cost. The distribution is changed in the calculations as well. Moreover, the risk analysis is performed with 100-iterations. Furthermore, the analysis is considered to show the cumulative probabilities chart as well. Chart shows that outcomes can concede more than 80% chances of acquiring more than $1 million NPV in proceeding year.
Figure 7: Prepared report with uncertainties (2)
(Source: Created by author)
Chart 8: Prepared chart with uncertainties (2)
(Source: Created by author)
Part B: Coles Supermarket and Business Intelligence Solutions
Tools and Techniques supporting Business Operations
In this part, Coles Supermarket is selected for analyzing the business intelligence project implementation its importance. Coles Supermarket united its processes with using digital analytics aligned with strategies and capabilities. Coles supermarket was facing significant challenges while using digital and data analytics (Armstrong et al. 2014). Moreover, it faced problems while breaking down the organizational work slabs for existing order with working efficiently. Coles supermarket organization facing difficulties in separate analytics for financial services and online business process. Coles supermarket organization used Adobe symposium for financial services and digital analytics optimization. Coles web analytics manager had utilized new technology of Lens10 to share how digital analytics can help in web analytics strategy and approach (Atapattu and Sedera 2014). Le Get was incorporated for web analytics manager in 2014 and it was combined together for developing and implementing web analytics solution to Coles supermarket online services.
Web analytics used for improving basket sales and incorporated better effectiveness in online groceries deals. Not only 60 items can be dealt with this solution; however, the customer can reorder several times for actual delivery of services (Basker and Noel 2013). This analytics solution is better proposition to the customers; although the analytics process is quite difficult. Coles supermarket organization financial services and its digital analytics was combined with optimization efforts so that business including retail and partnership can be managed.
Improvements in Coles Supermarket
Coles supermarket organization used Adobe analytics and struggling to achieve end-to-end view of the customer services. Le Get worked with pulling together several divisions along with vendors for getting enterprise-grade analytics solution. In parallel, the new grocery website can be developed with rich data layers with daily basis (Bhaskaran 2013; Davidov 2014). The analytics solution had provided sophisticated approach for dealing with several parts of the business at once. Moreover, Coles Supermarket organization required Adobe Analytics for dealing with scale of operation and managing the complexity of data. Moreover, the analytics of data can be figured out from the organization as whole to the operational. For Coles Supermarket organization, untangling analytics process and tool usage can gain suitable customer insights (Irving et al. 2013). Adobe target can be used for website testing and as a personalization tool; it can improve the business insights to drive better business activities. For instance, activities are highlighted for A/B testing with onsite access.
However, Coles Supermarket organization was cautious about using business intelligence tool at first, though; the organization started a pilot study. The pilot study was effective for pretending the driving force to be essential (Hattersley, Isaacs and Burch 2013). Coles Supermarket organization had faced major security issues and encountered that website can be easily destroyed. The entrepreneur had identified that using business intelligence solution was challenge at first; later, the technique was effective for generalized approach towards ongoing optimization program (Ham 2016). Coles Supermarket organization in online business had incorporated ability to make proper sequence to gain certain opportunity.
Value from Business Intelligence Solutions
Supermarket and retailing businesses such as Coles, Woolworths, David Jones, Dick Smith, and others; took consideration of values from BI solutions. Coles general store association utilized innovative dashboards and attempting to accomplish end-to-end perspective of the client administrations (MacDonald and Coffield 2015). Le Get worked with pulling together a few divisions alongside merchants for getting endeavor review examination arrangement. In parallel, the new basic need site can be created with rich information layers with regular routine. The investigation arrangement had given advanced way to deal with managing a few sections of the business without a moment’s delay (Nakandala, Lau and Zhao 2016). In addition, Coles Supermarket association required Digital Analytics for managing size of operation and dealing with the unpredictability of information. Also, the investigation of information can be made sense of from the association as entire to the operational. For Coles Supermarket association, unwinding investigation process and device utilization can increase reasonable client bits of knowledge (Ogwang 2016). Adobe target can be utilized for site testing and as a personalization instrument; it can enhance the business experiences to drive better business exercises. For example, exercises are highlighted for A/B testing with on location get to.
Furthermore, Coles Supermarket association was wary about utilizing business insight device at to begin with, however; the association began a mandatory survey. The survey for feedback was powerful to pretend the main impetus to be basic (Parker, Brunswick and Kotey 2013). Coles Supermarket association had confronted significant security issues and experienced that site can be effortlessly obliterated. The business visionary had distinguished that utilizing business knowledge arrangement was test at first; later, the system was powerful for summed up approach towards progressing enhancement program (Scott-Kemmis 2014). Coles Supermarket association in online business had fused capacity to make legitimate arrangement to increase certain open door.
Factors influencing Success of Business Intelligence
In this part, Coles Supermarket has chosen suitable success aspects while implementing business intelligence projects. Coles Supermarket joined its procedures with utilizing advanced examination adjusted to techniques and abilities. Coles grocery store was confronting critical difficulties while utilizing computerized and information investigation (Stubbs 2014). Besides, it confronted issues while separating the hierarchical work pieces for existing request with working proficiently. Coles grocery store association confronting challenges in particular investigation for money related administrations and online business prepare (Wilson 2014). Coles general store and online business utilized proper assimilation of strategies and cost management and advanced investigation streamlining.
Coles web investigation supervisor had used new innovation of BI projects to share how advanced examination can help in web examination technique and approach. Le Get was consolidated for web investigation chief in 2014 and it was joined together to develop and actualizing web examination answer for Coles general store online administrations (Wongthongtham and Abu-Salih 2015). Web examination utilized for enhancing wicker container deals and consolidated better adequacy in online basic needs bargains. Not just entire operation can be managed this arrangement; in any case, the client can reorder a few times for real conveyance of administrations. This investigation arrangement is better recommendation to the clients; despite the fact that the examination procedure is very troublesome (Parker, Brunswick and Kotey 2013). Coles grocery store association money related administrations and its advanced investigation was joined with enhancement endeavors so business including retail and organization can be overseen.
Part C: Growing Delighted Customers in the Digital Ecosystem: Customer-Centricity at Make It Work Inc.: Report
Case Study Background
Make It Work Inc. organization was founded in 2001 by Eric Greenspan and Jeremy Anticouni as two-employee operational structure with starting neighborhood support business. The organization received orders for fixing several problems regarding PCs, MACs, home internet network, mobile devices, and other relevant devices. In an overall, Make It Work Inc. organization takes all orders from customers for resolving problems regarding all devices that “beeps, clicks, or hums” for home and small enterprises. The organization had proper growth with setting their working standard with certain limits. Gradually, it grew up to be major part of device resolving operations. After some years of continuous development with device resolving and fixing their issues, the Make It Work Inc. organization started taking customer calls. At certain extent, the customer calls were in higher rate so it faced major issues receiving them and serving individual requests.
Currently, Make It Work Inc. organization has service coverage in Southern California, aligned with long-term planning for extending worldwide. Make It Work Inc. organization had focus over handling several customers approximately over 35,000 and received more than 30,000 testimonials. Make It Work Inc. organization incorporated high-touch and personal technology for instant response and service to the customers. Make It Work Inc. organization had delivered several customers with better experience for existing technology service market. The organization had provided significant level of services to the customers for in-store support and in case they are not satisfied, the organization provided complete refund to the customers. Make It Work Inc. organization had their business model reaching better success rather than serving refunds. Make It Work Inc. had evolved to offering technical solutions with interactive webinars.
Reasons for Business Intelligence Project Implementation
Make It Work Inc. organization faced several service related queries from customer worldwide. The organization took calls for taking phone support, area-base services, and seeking information about more aspects. Customers were eager to know about whether the organization serves products with new technology, booking appointments, and asking about dropping off services. At certain extent, Make It Work Inc. organization realized that serving customers on-the-line is more desired. Customers should prefer more instantaneous services than providing services after certain periods. In an overall, Make It Work Inc. organization realized that real-time responsiveness should be primary service aspect for all individual customers. Resolving issues and certain queries such as why TV is not working, why PC or iPhone is not working; these types of issues wear out when those problems are not addressed instantly. Therefore, Make It Work Inc. organization decided to address customers’ query on-the-line and with more instantaneous responses.
Moreover, the organization understood that highly developed infrastructure and information systems are primary key for high responsiveness. Moreover, web-based customer call management, call center system incorporation (Web CRS) can lessen the operators’ work with providing higher availability to customers. These technologies can match the operator skills for serving instant responses as well. With high-order IT solutions and infrastructure, customers should be responded within few minutes. Customer feedbacks can be received through e-mail for further purpose and information.
Furthermore, Make It Work Inc. organization required to implement a particular solution that should keep track of the customer satisfaction and their delightful responses. In this solution, Make It Work Inc. organization can be able to review customers’ satisfaction level to assess whether the organization is performing as per customer requirement or not.
Outcomes from Business Intelligence Projects
From business intelligence based projects development, Make It Work Inc. organization gathered several outcomes about their system and operation improvement. For real-time and instant responses, Make It Work Inc. organization considered appropriate IT solution and they implemented web-based call center system (Web-CRS) for operators. This solution helps the operator to check support schedule, availability, set-up schedules. All the processes can be completed within shorter time and further, customers can be notified with call when the customer is assigned to tech specialist. Customer e-mail addresses were taken for asking their feedback about their support call experience. This process helped Make It Work Inc. organization to gather necessary change requests and major flaws in services.
All generated data is stored under database and the customer data was considered for assessing the organization performance. The performance is presented in “delight dashboard” for showing customer and their delight index. This index includes a particular threshold, if the index is lower than threshold, then particular process is triggered immediately. The process can easily track the cause dissatisfaction and immediately evaluate what process had gone wrong; instant improvement fields can be identified. Current delight average is 3.92 while serving more than 30,000 customers.
Additionally, Make It Work Inc. organization had implemented MIWALL (mobile device application) that can easily notify the tech specialists if any change of policies is made. MIWALL can serve new technology tips and marketing events details. Moreover, QuickBooks accounting system is suitable for current Make It Work Inc. organization size. This accounting system can easily track the sales data with customer services. It can feed accounting data and financial information in digital dashboard so that monitoring could be possible.
Armstrong, G., Adam, S., Denize, S. and Kotler, P., 2014. Principles of marketing. Pearson Australia.
Atapattu, M. and Sedera, D., 2014. Firm-Customer Mobile Digital Connectedness: Conceptualization, Measurement and Implications. In PACIS (p. 127).
Basker, E. and Noel, M., 2013. Competition Challenges in the Supermarket Sector with an Application to Latin American Markets. Report for the World Bank and the Regional Competition Centre for Latin America. Mexico, DF: CRCAL.
Bhaskaran, S., 2013. Structured case studies: Information communication technology adoption by small-to-medium food enterprises. British Food Journal, 115(3), pp.425-447.
Davidov, L., 2014. A correlational study of entrepreneurial orientation and performance in the supermarket industry (Doctoral dissertation, University of Phoenix).
Ham, A., 2016. Is your marketing material promoting your business, or trashing it?. Governance Directions, 68(5), p.294.
Hattersley, L., Isaacs, B. and Burch, D., 2013. Supermarket power, own-labels, and manufacturer counterstrategies: international relations of cooperation and competition in the fruit canning industry. Agriculture and human values, 30(2), pp.225-233.
Irving, D., Kolb, D., Shepherd, D. and Woods, C., 2013. Changing Gears: How to Take Your Kiwi Business from the Kitchen Table to the Board Room. Auckland University Press.
MacDonald, R. and Coffield, F., 2015. Risky business?: youth and the enterprise culture. Routledge.
Nakandala, D., Lau, H. and Zhao, L., 2016. Development of a hybrid fresh food supply chain risk assessment model. International Journal of Production Research, pp.1-16.
Ogwang, K.P., 2016. Strategic Role of Big Data Analytics on the Competitive Advantage of Supermarket Chains: A Case Study of Nakumatt Holdings Limited (Doctoral dissertation, United States International University-Africa).
Parker, C., Brunswick, C. and Kotey, J., 2013. The Happy Hen on Your Supermarket Shelf. Journal of bioethical inquiry, 10(2), pp.165-186.
Scott-Kemmis, D., 2014. Business Innovation: Beyond Technology. In Global Perspectives on Achieving Success in High and Low Cost Operating Environments (pp. 209-240). IGI Global.
Stubbs, E., 2014. Big Data, Big Innovation: Enabling Competitive Differentiation Through Business Analytics. John Wiley & Sons.
Wilson, P., 2014. The Twenty Second Kingsley Laffer Memorial Lecture Sydney University Business School University of Sydney 26th November, 2014 “Australia in a Globally Competitive Workplace–Challenges and Opportunities”.
Wongthongtham, P. and Abu-Salih, B., 2015, July. Ontology and trust based data warehouse in new generation of business intelligence: State-of-the-art, challenges, and opportunities. In Industrial Informatics (INDIN), 2015 IEEE 13th International Conference on (pp. 476-483). IEEE.
Essay Writing Service Features
Our Experience
No matter how complex your assignment is, we can find the right professional for your specific task. Contact Essay is an essay writing company that hires only the smartest minds to help you with your projects. Our expertise allows us to provide students with high-quality academic writing, editing & proofreading services.
Free Features
Free revision policy
$10Free bibliography & reference
$8Free title page
$8Free formatting
$8How Our Essay Writing Service Works
First, you will need to complete an order form. It's not difficult but, in case there is anything you find not to be clear, you may always call us so that we can guide you through it. On the order form, you will need to include some basic information concerning your order: subject, topic, number of pages, etc. We also encourage our clients to upload any relevant information or sources that will help.
Complete the order form
Once we have all the information and instructions that we need, we select the most suitable writer for your assignment. While everything seems to be clear, the writer, who has complete knowledge of the subject, may need clarification from you. It is at that point that you would receive a call or email from us.
Writer’s assignment
As soon as the writer has finished, it will be delivered both to the website and to your email address so that you will not miss it. If your deadline is close at hand, we will place a call to you to make sure that you receive the paper on time.
Completing the order and download