Premium Essay

Memo

In:

Submitted By anthea316
Words 408
Pages 2
MEMO
To: Anisur Rahman
Student’s Name: X
Student’s ID:
Date: 24.01.2013

1. Sales by Region Row Labels | Sum of Total Sales | East | 529124.8 | North | 233832.75 | South | 234595.05 | Grand Total | 997552.6 |

2. Sales by item Row Labels | Sum of Total Sales | 101 Keyboard | 18294.15 | 17" Monitor | 139461 | Desktop CPU | 833800.95 | PC Mouse | 5996.5 | Grand Total | 997552.6 |

3. Sales by store Row Labels | Sum of Total Sales | 1 | 90281.1 | 2 | 54262.7 | 3 | 90051.25 | 4 | 75498.75 | 5 | 158334 | 6 | 267648.9 | 7 | 170040.85 | 8 | 91435.05 | Grand Total | 997552.6 | | |

4. Sales by week Row Labels | Sum of Total Sales | 27-Oct-08 | 317722.75 | 24-Nov-08 | 341961.05 | 29-Dec-08 | 337868.8 | Grand Total | 997552.6 |

5. For which products we need more marketing? Row Labels | Sum of Units Sold | 101 Keyboard | 917 | 17" Monitor | 609 | Desktop CPU | 981 | PC Mouse | 670 |

As 17’’ monitor has the least sales thus it needs more marketing.

6. On regional basis, which products need more advertising?

Row Labels | Sum of Units Sold | East | 1532 | 101 Keyboard | 385 | 17" Monitor | 328 | Desktop CPU | 522 | PC Mouse | 297 | North | 882 | 101 Keyboard | 309 | 17" Monitor | 117 | Desktop CPU | 234 | PC Mouse | 222 | South | 763 | 101 Keyboard | 223 | 17" Monitor | 164 | Desktop CPU | 225 | PC Mouse | 151 | Grand Total | 3177 |

In East region: PC mouse needs more advertisement.
In North Region: 17" Monitor needs more advertisement.
In South Region: PC mouse needs more advertisement.

7. Top 5 branch manager will get 5% commission on sales. In which region these branches are located?

Row Labels | Sum of Total Sales | 1 | 90281.1 | South | 90281.1 | 2 | 54262.7 | South | 54262.7 | 3 | 90051.25 | South | 90051.25 | 4 | 75498.75 | North |

Similar Documents

Free Essay

Memo

...The purpose of this memo is to explain the role of technical writing in professional sports, specifically the Colorado Avalanche Management and Team Services department. The information was gathered from an interview with Francois Giguere the former General Manager and Executive Vice President. Background Mr. Giguere previously worked as the Assistant General Manager and Vice President of Hockey Operations for the Colorado Avalanche and he also worked in the Quebec Nordiques organization before the team moved to Colorado. He was promoted May 2006. He has won two Stanley Cups in his career with Colorado. Methods of Communication Mr. Giguere explained to me that he sends a lot of emails to people within the organization. The emails he sends are to department heads such as Scouting, Communications, Marketing, Player Development and the Team Services department. He also uses memos to communicate with his colleagues. He also sends text messages if he is in a hurry and needs to be more direct with a certain people. Management Hierarchy Forms of Writing Within The Organization Within the Colorado Avalanche organization there are several forms of writing: Memos. Keep everyone up to speed on daily activities. There are different forms of memos used to do this. • Manager Memos. A memo is sent out by the General Manager after every trade, free agent signing or contract extension. This is to keep people informed about contract negotiations. A memo includes player profiles...

Words: 506 - Pages: 3

Premium Essay

Memo

...Memo To: Recipient’s Name, Recipient’s Title Department of Defense Army National Guard From: Your Name, Your TitleSGT Jameka Samuel (Automated Logistic Specialist) CC: National Guard Bureau Name and title of individuals you want to copy in on your correspondence; if there are no courtesy copies, leave this line off Date: The date you are sending the memo19 June 2014 Subject: A clear subject line reflecting the focus of your document In need of a sponsor for writing course As we all know in the military being leader depends on your ability to think critically and creatively and to communicate your intention and decision to others. The ability to communicate clearly to get your intent and ideas across so that others understand your message and act on it is one of the primary qualities of leadership. Poor writing and communication in the military is mostly attributed to lack of proper training, lack of confidence and lack of leadership. Taking a soldier out onto the battlefield with a poor communicator could lead to potential deaths of inanest soldiers. With that being said this this is an opportunity to help a striving soldier to become a better leader in the military world by requesting to take a Business Writing Course at Kaplan University in Jacksonville Florida . The cost of the course is $1300.00 which includes all books and necessary course materials. The course will take place over a 6 week time period beginning June...

Words: 777 - Pages: 4

Premium Essay

Memo

...|Majority used to give |Expository |Most emails are used as descriptive. They | | |brief description of | |are used to inform the company of new | | |what someone wants | |employees, promotions, introductions, | | |someone else to do. | |meeting requests that have descriptive | | | | |agendas. | |Memos |Most memos I have seen |Technical |Memos in my work place are very rare. The | | |used to inform the | |memos I have seen inform the readers of | | |reader of change being | |what is being done to systems, what the | | |made to systems | |back out plan and who to inform if issues | | | | |arise | |Letters...

Words: 690 - Pages: 3

Free Essay

Memo

...MEMO #1 Para: Gerente General De: Gerente de producción Asunto: Recomendación sobre política de cumplimiento de estándares razonables para trabajadores de contratistas extranjeros. Fecha: Jueves, 21 de mayo del 2015. El motivo de la presente es para dar mi recomendación sobre una de las políticas acerca del cumplimiento de estándares para los trabajadores de nuestros contratistas extranjeros. Pienso que es importante que como organización nos involucremos con los trabajadores de nuestros contratistas mediante una vigilancia de cumplimientos de estándares o normas. A esta política, agregaría la prohibición del trabajo infantil. Con esta política, vamos a asegurar que estos trabajadores tengan el derecho a trabajar en buenas condiciones por su seguridad, paga justa (no la que actualmente perciben, que es ridículamente baja), y procurar su salud. Generalmente en países asiáticos el trabajo infantil es normal, parte de su cultura, pero no de la nuestra. Existen razones por las cuales el trabajo infantil no es correcto, entre ellas el derecho que tienen a estudiar, jugar, etc. Con el cumplimiento de estándares razonables evitaremos futuros conflictos puesto que los descuidos en seguridad a este personal pueden desencadenar en problemas sociales (activistas laborales) y económicos así como ha ocurrido en los últimos años donde empresas estadounidenses han sido partícipes de esta situación. Como organización nos debe preocupar esto, debemos asegurar que aquellas personas...

Words: 283 - Pages: 2

Premium Essay

Memo

...changes towards e-mail privacy. The Policy Violations guideline will go as following: • First Offense- Verbal warning in a direct meeting with a direct supervisor, which will also be entered in writing in the employee’s human resources file. • Second Offense- Reassignment or suspension without pay, for a period to be determined by the employee’s supervisor (who will know best the most appropriate length of time). • Third Offense- Immediate termination without severance pay. These new policy violation changes will be enforce affected immediately. This list is just the simple outline of the new changes for you to explain to your employees. There will be a more detailed company-issued policy memo covering all the issues sent to you in the upcoming weeks. Once you’ve received the memo, it must be posted up at each bureau in an area visible to employees to see. That is all for now, you all have a nice...

Words: 283 - Pages: 2

Premium Essay

Memo

...SUBJECT: Important Risk Analysis: Assessment of Audit Risk The objective of this memo is to introduce the financial position of Hormel Foods Corp. and provide the general assessment of the company’s audit risk. The overall assessment of risk of material misstatement is moderate. This memo presents the potential high-risk areas as followings. Revenue Recognition GM’s major sources of revenue is manufacturing and marketing branded consumer foods sold through retail stores. It also supply branded and unbranded food products to the foodservice and commercial baking industries. The competition and seasonality is critical factors in estimating the revenue of the company. Additionally, estimate of coupon redemption, product returning and uncollectible sales on credit sales need to be measured accurately. The risk of material misstatement is high in this account. The considerable amount of estimates required to measure accounts such as sales revenue, and account receivable, which lead to a high risk assessment. Moreover, the need to use estimates varying on the operating location, for example, constitutes revenue recognition as a high-risk audit area. GM’s key customers are grocery stores, mass merchandisers, membership stores, natural food chains, drug, dollar and discount chains, commercial and noncommercial foodservice distributors and operators, restaurants, and convenience stores. Estimate of return of product and customer credit is important for evaluating the sales revenue...

Words: 939 - Pages: 4

Free Essay

Memo

...Luis Cubilla ENG/221 Technical Writing Fundamentals Zachery Koppelmann January 28 2013 The organization of the memo from Hugh to Abram is partially organized. Hugh does not stray from his subject much and appears to stay on point with what he wants to address. The letter has an average format with a standard intro body and conclusion along with a signature which should be included in all e-mails. The clarity however leaves little to be desired for but at least Hugh admits that he does not understand his own employee or his friend. Hugh talks about how he was advised not to use certain enterprise software’s with by his friend and how he could not understand much of how the situation should be handled or how he should move forward with his business plans. The writing style is very unprofessional; it almost seems more like Hugh is writing to a friend rather than a co-worker or colleague. There are no real formalities Abram is only addressed by name once and the overall feel looks like something a brother would write to his family member. The memo seemed to be a little disrespectful in some ways. First Hugh is talking business matters with a friend rather than Abram, secondly it appears Hough’s friend is providing the basic of warnings that any programmer should look for but Hugh appears to be leaning towards his friend’s advice rather than Abram who as Hough states “respects his professional approach”. To add further insult to injury Abram has been asked to not...

Words: 456 - Pages: 2

Free Essay

Memo

...T.C. Memo. 2009-93 UNITED STATES TAX COURT THOMAS J. WOODY, Petitioner v. COMMISSIONER OF INTERNAL REVENUE, Respondent Docket No. 30077-07. Filed April 30, 2009. P alleges that during tax year 2004 he had a real estate investment and rental business. P deducted expenses associated with this activity as business expenses under I.R.C. sec. 162. R disallowed the business expense deductions. On the basis of this disallowance, R determined a deficiency in P’s Federal income tax for 2004. P petitioned this Court for redetermination of that deficiency. Held: P was not actively engaged in a real estate investment and rental business when he incurred and paid the expenses he deducted as Schedule C business expenses in 2004. Therefore, the costs P deducted are pre-operational start-up expenditures and may not be deducted as business expenses under I.R.C. sec. 162. - 2 Bruce E. Gardner, for petitioner. Scott L. Little, for respondent. MEMORANDUM FINDINGS OF FACT AND OPINION GUSTAFSON, Judge: This case is before the Court on petitioner Thomas J. Woody’s petition for redetermination of his Federal income tax deficiency for 2004 which the Internal Revenue Service (IRS) determined to be $4,955. The issue for decision is whether Mr. Woody is entitled under section 1621 to deductions claimed on his 2004 Schedule C, Profit or Loss From Business. As a threshold matter, we must decide whether Mr. Woody was actively engaged in the trade or business of real estate investment and rental at...

Words: 3496 - Pages: 14

Premium Essay

Memo

...Memo To: From: Date: 10/30/2012 Re: Request for Funding of a Business Communications course I would like to request funding to participate in an upcoming class, Business Communications (GB512), at Kaplan University Online. As an employee of Lowe’s who cares about employee development and performance I have decided to do some research on performance management best practices that could be beneficial to the company as a whole. My ability to communicate better as a professional will ensure that my presentation skills and research on performance management is easily understood by the Directors and Area Managers for Lowe’s Home Centers, Inc. Being able to look into this topic and create solutions will help me to be more confident in my presentation skills and ensure that my thoughts are being communicated effectively to my audience. . The course I am wishing to participate in is Business Communications and is a six week course that will cost $1814.00 which includes all software, course material and technology fees. The start date of this course is November 14th and will consist of seminars and online discussions boards which will require participation several nights each week. This class will help me to strengthen my written communication in the business environment that I am currently working in. I feel as though this course will help me to move forward and grow in my skills of analyzing and presenting research items to a group of colleagues with Lowe’s...

Words: 384 - Pages: 2

Premium Essay

Memo

...To: ​Mark Smith, Director of Human Resources From: ​Floyd Sea, Accounts/Receivable Coordinator Date: ​February 11, 2014 Subject: ​Request for Business Writing course Funding The purpose of this memo is to appeal for funding for Floyd Sea to attend a Business Communications course. As an Accounts/Receivable Coordinator this course will help improve my ability to record strong, concise, and effective messages in proficient method. Being a part of this course will afford me with a prospective for communication improvement and allow me to better connect in my writing with colleagues and co-workers. This course will allow and inspire me to communicate more effectively, meanwhile helps me save time and effort in redoing documents and giving clear explanations of the tasks. It will strengthen my ability to communicate effectively on the job by teaching me how to compose messages using a structured business writing process. The course is titled, GB512 Business Communications and is being offered at Kaplan University. The 6 week course was set to start on February 5, 2014. The cost of the course is $1614.40, which contains books and necessary course materials. Since the course is offered online, all course work and attendance will be in the morning so it will not interrupt my current scheduled time at work. I think taken this course will be a great positive improvement in business between the different units. Involvement in this course will give me access to other thoughts...

Words: 378 - Pages: 2

Premium Essay

Memo

...MEMO IE Business school Saturday, October 3rd 2015 Dear Santiago Iñiguez de Onzoño, My name is Sami and I have recently joined the MIM program for the September 2015 intake. I would like to constructively comment on the introductory weeks for this program and highlight some important details you may take into account for next year’s intake. I believe that this part of the program is very important and key to build a successful year ahead. First of all, I think that the 2 weeks introductory workshops were too long and sometimes got really boring and repetitive. my recommendation is to compress the pre-program to one week instead of two, that way students will get exposed to the MIM structure and will get to know each other before the start of the 1st module. In addition, some of the workshops we attended were very long lectures like the cross cultural workshop for example. I would recommend to include some interactive exercises where students could present themselves and reflect their background to the rest of the class. In that way students would me more familiar with each other’s cultures and can get the opportunity to bond and feel comfortable during the opening week of the program. Furthermore, Some sessions extended over the course of two days like the entrepreneurship workshop for example, in my opinion a single day is enough to introduce the concept of entrepreneurship to the students specially because they will be learning all about it during...

Words: 487 - Pages: 2

Premium Essay

Memo

...Memorandum To: Stephanie Nissen From: Nichole Dennis Date: 11/16/13 Re: Bureaucracy Memo INTRODUCTION In 1992, Kristin Lardner was murdered by a man who should have been in prison. Kristin was a creative and intelligent art student from D.C., living in Boston. She began dating Michael Cartier a few months before he took her life. Michael was already on probation for numerous violent acts. Acts against other people and property. WEBER’S CONCEPT OF BUREAUCRACY Max Weber’s Concept of Bureaucracy consists of three basic theories. They are: Specialization of Labor, Hierarchical Order and Impersonal Rules. "The principle of office hierarchy and of levels of graded authority mean a firmly ordered system of super-and subordination in which there is a supervision of the lower offices by the higher ones (Stillman, 54). The concept of Hierarchical Order is directly related to this case study. Hierarchical Order basically means that everyone in a bureaucratic system has someone to answer to within the government. Because we have these checks and balances system, the government is supposed to run smoothly and properly. HOW THE HIERARCHICAL ORDER FAILED KRISTIN The following are a few examples of how the Hierarchical Order failed to protect Kristin: In 1988, Cartier was arrested and sentenced to six months in jail, non of which he served. In 1990, Cartier was arrested on multiple charges such as destruction of property and animal cruelty. Between December...

Words: 295 - Pages: 2

Premium Essay

Memo

...Memo Date: December 1, 2012 To: All BUSAD 106 Students From: Instructor ------------------------------------------------- Subject: Reminder of Individual Report As I mentioned in last memo, each student is required to submit a businessresearch paper. This memo is reminding you that your individual report is due by one week ahead from this week. As you all know the main topic, you should be able to consider to some important steps as you need to complete your individual report. Some of these steps are listed below: Important Considerations 1. Your report needs to be presented as an informational report. 2. You need to come up with at least three major in the body of your report (Intro, body, and conclusion). 3. The report must be at least 3 to 4 pages. 4. This 20 point report is due at or before 11:55p.m. On December 8, 2012. General Guidelines 1. You need to complete your own report, and it must be prepared using word processing and good quality print. 2. Use formal writing style throughout the report. 3. Use three to five valid and reliable secondary sources. You already know how to get this information from. 4. Use visual aids (i.e. charts, graphs, tables, etc…) they must be clear and relevant to the topic. 5. In either electronic or hard copy format, provide the sources used to write the report so I can check the accuracy of information and Works Cited page. Grading Policy You must submit your report by due date with...

Words: 353 - Pages: 2

Premium Essay

Memo

...Memorandum To: | Senator X | From: | Christoph B. Mund | Date: | April 25th, 2012 | Subject: | Health Care Spending Growth and Reform | SUMMARY The following memo seeks to highlight the past and current problems facing federal health care expenditures within the U.S. It tries to answer the question if health care spending is now on more sustainable path along with giving projections for its current outlook. More specifically it addresses “supply-side” reforms, “demand-side” reforms and “voucher” reforms within the Medicare program, analyzing the benefits and downsides of each and what underlying problems these approaches contain. The memo summarises with recommendations as to which reform should be put in practice to achieve the desired results within the health care market. PROBLEM ANALYSIS 1. Health care expenditures are on an unsustainable path Reasons: * Aging of the population * Increase in health care costs due to excessive coverage * New medical technologies Under current law, spending for mandatory health care programs would increase from 5.6% of GDP today to about 9% of GDP in 2035. Total health care spending grew by 3.9% in 2010 and reached $2.6 trillion, or $8,402 per person. This is mainly caused by an aging of the population, an increase in retirement of the “baby boomer” generation, a rise in health care costs and a rapid innovation of medical technologies. All these factors lead to an increase in the federal budget deficit...

Words: 1615 - Pages: 7

Premium Essay

Memo

...MEMO To: From: Re: Date: Introduction The long-term unemployed will make state and nation decrease the productivity and increase debt in public system. In response to the chronic unemployment of low and non-skilled workers in state X, the government aims to train them to get back to social and increase the productivity to society. There are two company could take the action for government, one is private sector that offers the on-the-job training program and another one is education program that offered by public sector. Before the government choose the program, it is necessary that State Government to evaluate all the benefits and costs of each program and choose the only one to train chronic unemployment of low and non-skilled workers. Analysis Method and Assumptions This memo provides a cost benefits analysis of different sector unemployed treatment in order to increase the productivity and employee rate of State X. In this memo, the costs of benefits of the private plan are compare with those of the public sector over a 30 years period and the current year is the year of 0 of this case. In order to choose which sector is better, I calculated the net present value of costs and benefits of state, firms and trainees per trainee from year 1 to 30use different leisure value and discount rate for both public sector and private sector. The next step is calculating the costs and benefits for both private and public sector in year 0. Then I add these with the result...

Words: 622 - Pages: 3