Premium Essay

Chatime Company

In:

Submitted By baxa
Words 1008
Pages 5
BCOMP1101/BIS1582/BIS1583 ● COMPUTER APPLICATION FOR BUSINESS
Group Project
40%

Department : Faculty of Business Management & Globalisation Course Name : B Bus (Hons) in Business Administration B Bus (Hons) in Entrepreneurship B Bus (Hons) in Marketing B Bus (Hons) in Accounting B Bus (Hons) in International Business B Bus (Hons) in Human Resource Management B Arts (Hons) in Sports, Health & Fitness Management B Bus (Hons) in Hospitality Management B Bus (Hons) in Public Management B Bus (Hons) in Tourism Management Semester : 1 Commence Date : Week 6 Deadline Date : Week 11 Unit Controller / Examiner : Suha Salem Contact Number : ext 8406 E-mail : ssalemp@gmail.com
-------------------------------------------------

Coursework Requirements:

1. You are required to come out with a Microsoft Excel application to solve next Exercises 2. Open new workbook in Microsoft Excel and save as “Group Assignment”. 3. You are required to solve all the exercises and each exercise in different sheet. This group project can have Maximum 3 students.

Exercise1

In this exercise, practice Conditional Formatting 1- Open a new sheet and Rename the sheet as “Exercise 1” 2- Type the next data and format the data as a Table.

3- Set up the rule that Excel formats any cell within a range with yellow fill color and dark yellow font color whenever it contains the word “Dairy”.

4- Set up the rule that excel formats any cell within a range with light red fill color whenever it contains the amount value less than ($500).

Exercise 2

In this exercise, practice simple and complex formula

Similar Documents

Premium Essay

Quatitative Lit

...of college. She is anticipating a large expense on books but is hoping to save some money on purchasing school supplies by looking at discount retailers instead of the college bookstore. Misty has found two companies, Company A and Company B, with some great back to school deals on school supplies. Company A is offering ten percent off each dollar spent on school supplies with no minimum purchase required. While that sounds like a great deal, Company B is offering twenty-five percent off all school supplies purchased after spending an initial one hundred dollars. While both options offer a great discount, Misty wants to determine which would save her the most money. Before moving any further, Misty must determine what her total bill for school supplies might be by identifying the items she will need to purchase and then totaling the final cost. Once that has been ascertained, she will need to calculate the possible savings on each plan to determine which one will be most cost effective. Task B In order to calculate the savings, Misty is going to let (y) represent to total cost of her school supplies after all discounts have been applied. She will use (d) to represent the discount percent she is going to receive from the company. As prices from each company are comparable, she has calculated the total cost of her school supplies to be $230.00 which will be represented as the variable (x). The following is an...

Words: 776 - Pages: 4

Premium Essay

Qlt 1 Task 5

...of college. She is anticipating a large expense on books but is hoping to save some money on purchasing school supplies by looking at discount retailers instead of the college bookstore. Misty has found two companies, Company A and Company B, with some great back to school deals on school supplies. Company A is offering ten percent off each dollar spent on school supplies with no minimum purchase required. While that sounds like a great deal, Company B is offering twenty-five percent off all school supplies purchased after spending an initial one hundred dollars. While both options offer a great discount, Misty wants to determine which would save her the most money. Before moving any further, Misty must determine what her total bill for school supplies might be by identifying the items she will need to purchase and then totaling the final cost. Once that has been ascertained, she will need to calculate the possible savings on each plan to determine which one will be most cost effective. Task B In order to calculate the savings, Misty is going to let (y) represent to total cost of her school supplies after all discounts have been applied. She will use (d) to represent the discount percent she is going to receive from the company. As prices from each company are comparable, she has calculated the total cost of her school supplies to be $230.00 which will be represented as the variable (x). The following is an algebraic...

Words: 774 - Pages: 4

Premium Essay

Paper 1

...determination. Southwest’s operations involves low cost methods to get customer to places while the culture focuses on promotion of its satisfaction-based culture- both internally and externally; people seem to love giving into the company more than they love the company’s returns. A big airline is most likely to be the competitor. It is very likely that the corporation can introduce a system of short-haul, cheap flights via a standardized fleet with ease. The billions in revenue generated from other divisions can provide the capital required; they can even have the option to operate at a loss for a while. The question, then, turns to one of sustaining this division by attracting customers from companies like Southwest. Besides setting low prices and attempt to maximize efficiency, the question becomes: can the division’s efficiency outstrip that of Southwest’s? As stated, Southwest’s culture inspires employees to work, thus productivity and efficiency increases. This is the key behind the company’s success: fostering culture and turning the results into profit. Can a big company replicate or build the culture? Replication is difficult because usually big wigs are reluctant to change their own culture of following rules to the letter like traditional big companies to an upbeat style of Southwest. Instead of satisfying customers, maximizing shareholder value takes priority and this choice could be detrimental to the divisions’ cause (shareholders may also not be happy at the prospect...

Words: 416 - Pages: 2

Free Essay

Qcenter-Fivecompaniesemployeeslove-Whitepaper (1)

...CORPORATE CULTURE SECRETS OF FIVE COMPANIES EMPLOYEES LOVE How innovative companies are creating ways to build company culture while seeing tangible benefits. INTRODUCTION Creating the right culture for your company could be the best investment you ever make – and often, it doesn’t cost a dime. The world’s most innovative companies find hidden value by operating outside of established business culture. Time and time again, competitors are left asking, “How did they do that?” CORPORATE CULTURE SECRETS OF FIVE COMPANIES EMPLOYEES LOVE The answer is simple: Culture. The right culture fosters innovation, finds talent in unexpected places, and empowers employees at all levels. There isn’t a one-size-fits-all solution, but the following examples from leaders of innovative company culture will help you adopt a mindset that inspires greatness. /02 CORPORATE CULTURE SECRETS OF FIVE COMPANIES EMPLOYEES LOVE FOSTERING INNOVATION WHILE DEVELOPING EMPLOYEES If you get the culture right, most of the other stuff will just take care of itself. Tony Hsieh, Founder and CEO, Zappos.com /03 FOSTERING INNOVATION WHILE DEVELOPING EMPLOYEES Ideas From Everywhere (IFE) is a program for CareerBuilder employees, launched nearly 8 years ago as part of a company decision to adopt a strategy centered on innovation. In essence, employees are encouraged to submit their ideas for new businesses within the company. Their fellow employees are then asked to vote for the best idea...

Words: 1590 - Pages: 7

Premium Essay

Addidas Issues

...Although the imminent success in the last few years,some issues have brought the company down. The pending issues that are troubling the company are the employees conditions abroad, the buying of reebok and it's sales drop last year 2012. In the website oxfam, which analyses the conditions of workers abroad, it is stated:" we asked Adidas to implement worker's rights in Indonesia". (Oxfam 1). The complaints relate to the the ongoing problems of not matching wages with the rising prices of food and supporting work abroad. This can become a greater issues because most manufacturing is done abrasive and foreign countries could rebel against western companies hence slowing down productions or damaging products. Source: https://www.oxfam.org.au/explore/workers-rights/adidas/talking-with-adidas/ Another issue is the acquisition of Reebok, although buying another company cuts competition it also bring greater responsibilities. According to article on sportsdailybusiness.com Adidas has not gained any profit from Reebok rather loss. As it states in the article that since the acquisition in 2006, Adidas has struggled to raise to power the brad, commercial irregularities have been caught and it has suffered through the NHL lockout. Buying companies may eliminate competition but can bring great loss to the company if the other company itself is doing midly poor. Source: http://m.sportsbusinessdaily.com/Daily/Issues/2012/11/09/Finance/adidas-Reebok.aspx Lastly but not least...

Words: 315 - Pages: 2

Premium Essay

Small Business

...Examination Paper ESI Companies is a small company in Bartlett, Tennessee. ESI Companies is proud of their credit of providing tactical security specialist, and solutions to relieve threats to the environment. They install and build security systems in courthouse, detention facility, transportation hub, office building, and production plant. The company has partnered with private industry, law enforcement, military agencies, and correctional and detention facilities to keep their operating environments safe and secure from the threats of criminal activity and terrorism. Organizational Structure ESI Companies small business organizational structure is or can be a partnership. They are comfort of knowing their professional posses the needed skills and expertise to assist with the customers design and build techniques with courthouse, detention facility, office building, production plant, and others. They also partner with customers for facilities renovations, and maintenance of their security system regardless of any unique and challenging security needs.    ESI Companies requires the customer partner in the design and implementation of their standards of operation intended to reduce the risks of security catastrophes. ESI Companies believe in working together to design, implement, build, install, and support state – of – the – art electronic surveillance and security equipment for the business run smoothly and successfully. Management and Leadership ESI Companies employs culturally...

Words: 822 - Pages: 4

Free Essay

Kcp Suger

...Times| More  |Log In|Join| Stocks ------------------------------------------------- Top of Form NewsStock Quote Bottom of Form ------------------------------------------------- Top of Form | | Bottom of Form | | Home News  Markets IPO Personal Finance Mutual Funds Tech Jobs Opinion Features Blogs Slideshows  ET PortfolioET SpeedET NOW Stocks  Market Live Regulation Global Markets Forex IPOs/FPOs/Rights issues Bonds Money Markets Commodities Real Estate Analysis Market NewsStocks in NewsViews/RecommendationsStock QuotesMarket Calendar You are here: ET Home » Markets » Stocks » Stock Quotes » KCP Sugar & Industries Corporation Ltd. » Directors report * Summary * Prices * Financials * Reports * Company Info * News * Competitors * ET Buzz Tracker New Directors ReportChairman's SpeechFinished Products KCP Sugar & Industries Corporation Ltd. BSE: 533192NSE: KCPSUGINDEQ58888: kcpsi IND: SugarISIN code: INE790B01024SECT: Sugar BSELIVE03:40 PM | 26 Apr 2013 18.00 Change: -0.25(-1.37%)Volume: 4,357 Open: 18.35Prv. Close: 18.25 Today:  17.95 52-Wk:  14.50 18.35 26.00 Bid: 0.00(0) Offer: 0.00(0) NSELIVE03:31 PM | 26 Apr 2013 18.05 Change:-0.25(-1.37%)Volume: 17,561 Open: 18.25Prv. Close: 18.30 Today   17.80 52-Wk   14.70 18.50 26.05 Bid: 0.00(0) Offer: 0.00(0) You can view full text of the Director's Report for KCP Sugar & Industries Corporation Ltd. Director Report  Mar2011   Mar...

Words: 2927 - Pages: 12

Premium Essay

You Decide- Medco and Merck Merger

...information form several key employees within the organization in order to determine whether the merger will be profitable and allow the company continued growth. This analysis will include supporting calculations regarding the two companies becoming one. | Ladies and gentlemen I have been given the task of providing my recommendations as to our company (Merck), acquiring Medco. An evaluation of both companies will be completed so that I can provide accurate feedback as to the pros and the cons of the proposed merger. There will also be an analysis performed to determine the cost effectiveness and the potential synergy of the combined companies. Included in this recommendation you will find a (DCF) discounted cash flow, this will determine whether or not the post-merger company will have the ability to overcome any opposition that be in question. I will also be discussing the proposed strategy that we intend to take, should we agree to the merger. We will explore what works well for each organization and the best way to combine those efforts to maximize on continued growth for the organization. We here at Merck, being the world’s largest drug manufacturer and leader of research and development efforts, have determined that there has been tremendous growth in the area of managed care. Medco is the leading prescriptions benefits Management Company and marketer of mail order pharmaceuticals. It is noted that, experts predict that “90% of Americans will have drug costs included...

Words: 1774 - Pages: 8

Free Essay

Xacc 280 Wk 8 Assignment Internal Controls

...outs of internal controls. It will also tell why they are important not only to companies, but why they are important to investors, creditors, and even the public too. Internal controls are a serious of methods and measures that companies put in place to insure that errors or irregularities in the accounting process do not happen very often. In every company there is a chance of having one or more employees who are dishonest and may take from the company. Internal controls helps to keep this from happening on a regular basis. Internal controls have two primary goals. The first primary goal is to safeguard a company’s assets. This goal is to protect a company’s assets from being misused without permission, theft, and even robbery. The second goal of internal controls is to improve the consistency and correctness of a company’s accounting records. Internal controls accomplish this goal by decreasing the threat of errors or irregularities in the financial accounting process (Internal Controls, 2012). These two goals help make companies trust their employees and investors feel confident in their decision to invest in a company. Internal controls have not always been enforced. This is the reason for the collapse of Enron, Tyco, etc. The Sarbonese-Oxley Act (SOX) has helped make internal controls a requirement for all publically traded U. S. Corporations. SOX forces companies to pay attention even extra attention to their internal controls. The Sarbonese-Oxley...

Words: 1146 - Pages: 5

Free Essay

Workforce Diversity

...orientations. No more is our country made up of only Caucasians and African Americans. Diversity is all around us and tolerance is what needs to be learnt by individuals, groups, and companies. The problem is that we all know that workforce diversity is something we can’t avoid, but many of us still try to. When someone doesn’t speak our dialect or eats different food in the lunchroom it can create uncertainty among people who are uncomfortable with “new.” It is people’s natural reactions and human instincts that make accepting new people who are different scary and unnerving. McDonalds, Dell and Boeing are three companies that have managed multicultural organizations well and continue to show other companies what a benefit it can be. Workforce diversity is a term that arose in the 1970’s and hasn’t stopped rearing its head to society. McDonalds was one of the first companies in the seventies that had a department devoted to affirmative action. Pat Harris is currently McDonald’s chief diversity officer overseeing an evolving diversity initiative. She existed with the company during the early stages of workforce diversity. Harris claims that she doesn’t use the word program to describe the company’s objective regarding diversity because it has a beginning and an end. Diversity is an ever-changing issue for the company and being flexible and open to new possibilities is important. Pat claimed that education would drive business and ensure that everyone understood variety in people. Educational...

Words: 2589 - Pages: 11

Premium Essay

Procter & Gamble:

...Procter and Gamble (P&G). In the beginning, P&G had just supply soap and candles to the Union armies, but now it has become to a global manufacturing, distribution, and marketing company focusing on providing branded products with superior quality and value. It provided over 300 brands reaching consumers in about 140 countries. P&G is focusing on provided fashion, high quality products for consumers. In order to satisfy consumers, P&G segment its consumers into different group, such as age, gender, ethnicity, material status, and low income consumers. With the segmentation, P&G could analyze what consumers’ demand. Human’s living standard is improved rapidly. People is getting to pay more attention on cleaning products to keep their bodies clean and looking good. Most of the people thought that beauty/feminine care products were just for females, but actually the number of men spending time in front of the mirror, grooming themselves had increased. With the growing trend for men to use beauty products, P&G started manufacturing more products for them and try to satisfy their needs. For example, they designed the products so that they would attract male consumers, by using dark colors for the packaging so that it looked more masculine. P&G is always try to satisfy needs of consumers. With a company which had more than 100 years history, P&G was strong in brand quality reputation, price competition, scales of economic, variety of products, and brand recognition but it still...

Words: 3374 - Pages: 14

Premium Essay

Essay

...“The dividend decision is unimportant to the wellbeing of a company.” Discuss Stock is a product of socialization production, and the earliest stock can be tracked back to 17th century. In terms of stock, dividend decision is an important concept, which can not be ignored. Dividend decision is defined as ‘Determines the division of earnings between payments to shareholders and retained earnings.’ ( http://finance.mapsofworld.com/corporate-finance/investment-decision/dividend.html ) Dividend decision is also called dividend policy, which has always been disputed. However, no matter how it is debated, dividend policy is very important to the healthy and orderly operation of a company. In the fist place,this essay will discuss the effect of different dividend policies on companies running, secondly indicate dividend decision should be changed to be fit for different growth periods and various investment opportunities, thirdly investigate how the refunding ability and cost of a company are affected by dividend policies, after that this paper will talks about the relationship between dividend decision and the structures of control rights to an enterprise, finally this article will evaluate the M&M theory and further prove that the importance of dividend policies for a corporation. There are diverse types of dividend policy, and each policy has different influence on corporations. Generally,Constant Payout Ratio (CPR), Constant Dollar Dividend Policy(CD), and Regular with...

Words: 270 - Pages: 2

Premium Essay

Lexmark Canada Case Study

...that was spun off from the IBM Corporation to be a standalone business and this has caused some restructuring within the company. The sales department underwent a major shift from individual compensation packages to a team compensation concept that was not immediately embraced by everyone in the organization which led to some defections and put the company in a position to be short staffed. This raised questions about the concept itself and whether it was a workable plan and also if the compensation is an adequate motivator and measure of personal performance. The analysis of this case really comes to the point of do they have the right people to make this team work? And thru continuing education can the company get and retain the right people? Is the compensation package correct? These questions and more will be addressed. The problem started by being short staffed almost from the start when two account managers quit due to lack of control of their earnings as they saw it and disappointment from not being chosen as team leader. Getting the right people on board quickly and effectively would be a key, but “As difficult as it is, resist the temptation to hire for the short-term because bad hires are poison.” (Tao, 2012) This is true in this case because they were worried about making quotas, but if they hire the wrong person then it only sets the company farther behind. This is all a huge part of the salesforce socialization. “Salesforce socialization refers to the process by...

Words: 1524 - Pages: 7

Free Essay

It Doesn't Matter

...matter “If a company needs evidence of the kind of money that might be saved, it need only look at Microsoft’s profit margin” Excerpts from a company’s strategy document • ...the company will ensure that it will have at least 2 plug points in each room with AC connection. • The switches will be white in color and will make a ‘click’ sound on pressing • Press to hear the click sound Disclaimer • We all agree to the fact that IT plays a crucial role in running an organisation. • All that we are driving at is that the existence of IT does not grant a competitive advantage to a company, anymore In other words, IT lets you remain in the race, Winning is a totally different ball game altogether The (lost) Edge • Can IT provide an edge for you? • You only gain an edge over rivals by having or doing something that they can’t have or do. • By now, the core functions of IT – data storage, data processing, and data transport – have become available and affordable to all. • And hence they are becoming costs of doing business that must be paid by all but provide distinction to none Risk >>> Advantage • When a resource becomes essential to competition but inconsequential to strategy, the risks it creates become more important than the advantages it provides • Lets classify technologies into • Proprietary technologies • Infrastructural technologies. • Proprietary technologies can be owned, actually or effectively, by a single company. • Infrastructural...

Words: 837 - Pages: 4

Premium Essay

Individual Assignment

...the factors that cause someone to commit occupational fraud”; it is widely used within business companies. It consists of three components that, together, lead to fraudulent behavior. Those three factors that must be present at the same time in order for an ordinary person to commit fraud: pressure, opportunity and rationalization. Michael D. Frenza has mentioned it in his article “Fraud perpetrators usually have a non-sharable pressure, they recognize a perceived opportunity, and then they rationalize their actions”. It is so important for companies to incorporate the fraud triangle theory in order to reduce the risk of misconduct within their organization. A company must recognize the common elements in most fraud cases. Once an employee has a pressure, they must find an opportunity to remedy their problem. There are a lot of opportunities within the companies for them. For example, the weak internal controls that fail to prevent, lack of management by top managers, irregular of auditors. When they take the advantage of those opportunities, they rationalize their actions. Most of them don’t realize they are Criminals. They all have one common sense that they will pay back money later to make up the economic losses. It seems like not a big deal for them. The pressure component of the Fraud Triangle is not easily controlled by companies. Therefore, it is important for companies to recognize pressures facing employees carefully. Employees are humans not machines; top managers...

Words: 650 - Pages: 3