This assignment is to be done using Excel. You must use Excel for the calculations (either using a formula which references other cells or an Excel function if appropriate). Do not just type the answer into Excel.

See the attached Excel file for an example of what is meant by “using Excel”.

Problem 1: Charts

The totals of the number of laser printers sold in the years 2008 through 2013 by Smart Brothers Computer Store are as follows:

2008	2009	2010	2011	2012	2013
983	1,052	1,117	615	250	400

Draw a line graph representing the data. Use an interval of 250. Be sure to include a title and label your axes.

Problem 2: Percents

The financial officer allows $3,400 for supplies in the annual budget. After three months, $898.32 has been spent on supplies. Is this figure within 25% of the annual budget?

Problem 3: Trade Discounts

A trade discount series of 10/5 was given on ladies’ scarves listed at $18. Find the net price of each scarf.

Problem 4: Statistics

Find the mean, median, mode, variation, and standard deviation for the following gas prices ($/gallon). You may use Excel functions.

2.19	2.35	2.11	2.54	2.48	2.36	2.19
2.40	2.64	2.47	2.33	2.61	2.42	2.37

Problem	Points
1	.75
2	.75
3	.75
4	.75

 

"Looking for a Similar Assignment? Order now and Get 10% Discount! Use Code "GET10" in your order"

1.A company must decide if it will maintain a sales force from the home nation, or set up a local sales force in the country in which it sells products. Provide a specific example of a product and briefly explain why it would be best to hire a sales force from the local (foreign) nation to sell that product.

2.A competitive advantage means that a company provides a product that has something unique or superior to that of the competition. Name an international company that uses product quality as its competitive advantage. Then briefly describe what you think would happen if the company lowered the quality of that product.

3.Briefly describe how the consumer behavior of teenagers differ in a developed country, such as the United States, versus a developing country, such as Honduras. Provide a specific example to help explain your answer.

4.Briefly explain why a company cannot always use the same marketing campaign for all of its target markets. Provide a specific example to help explain your answer.

5.Briefly explain why product sampling could be necessary to ensure the success of the product. Provide a specific example of a product that is best sold through product sampling, and the best place to set up to give out samples of that product.

6.In your opinion, what is the major advantage of a joint venture? Provide a specific example to help explain your answer.

7.In your opinion, what is the most important factor that a company should consider when making a product design decision for an international brand? Provide a specific example to help explain your answer.

8.In your opinion, what is the most successful international brand? Briefly explain why you believe that brand has been the most successful international brand.

9.Personal selling is a face-to-face communication between a prospective buyer and a company sales representative. Provide a specific example of a product that is best sold by using personal selling. Then briefly explain why that strategy would be the best marketing strategy to use for that product.

10.Market segmentation means to divide the market into distinctive groups of consumers who have similar needs, characteristics, or behaviors. Provide a specific example of a product where it would be important to segment based on geographic information. Then briefly explain why that product is best sold by geographic segmentation.

 

"Looking for a Similar Assignment? Order now and Get 10% Discount! Use Code "GET10" in your order"

Prompt: For Milestone One: Teams, you will submit a short paper assessing how Bill Gates structured the organization and his or her executive team, and evaluating the best practices used by the leader. In this assignment, you will use the text and your research on your chosen leader. In the assignment, identify specific leadership actions used by your chosen leader to build and structure a productive organization and culture such as policy, communication, and training. Explain at least two examples of best practices for leaders in team development and communication in the organization using the three dimensions of energy, engagement, and exploration. Identify planning methods used by the leader to align teams with organizational vision, and explain actions that built and fostered team development and teamwork. Include the utilization of resources to build teams, including training, projects, and programs.

You will be evaluated on the analysis of executive team-building practices, theory, concepts and techniques; identification and summary of results of leadership actions that structured the organization for success; application of team-building and leadership action examples; critical thinking applied to your work product; and the articulation of your response in the writing process.

 

"Looking for a Similar Assignment? Order now and Get 10% Discount! Use Code "GET10" in your order"

Choose whether you believe a company should hire for diversity or the best qualified individual. Explain your rationale. Determine how your current (or future) place of work could benefit from a diverse workforce.

Part 2

Would you hire this person – and why

Watch VideoDiversity Challenges – What Would You Do?

 

"Looking for a Similar Assignment? Order now and Get 10% Discount! Use Code "GET10" in your order"