Creating a Dynamic Spreadsheet for Business Consultant

Creating a Dynamic Spreadsheet for Business Consultant Overview: As you prepare to communicate the next steps in the consulting partnership between your organization, Business Consultants, and your client, New Hampshire Business Products, you will prepare three deliverables using office productivity applications.

For Milestone Two, you will prepare a draft of your second deliverable: a Microsoft Excel spreadsheet. You will create a dynamic spreadsheet that will allow you to organize and manipulate the given sales data with basic automatic calculation functions.
Prompt: Using Excel, create a spreadsheet that clearly and functionally displays the numerical data provided in the final project scenario.
Specifically, the following critical elements must be addressed:
II. Spreadsheet: Create a spreadsheet that clearly and functionally displays the numerical data provided in the scenario.
A. For current sales, display sales by category and total.
B. For projected sales, display sales by category and total.

Creating a Dynamic Spreadsheet for Business Consultant Paper Format

Apply formatting conventions appropriate for a business audience.
Select a consistent font and font size.
Format the spreadsheet with row and column spacing, row and column alignments, and cell formatting.
C. Apply labels that identify the values contained in each row and column. D. Apply formulas to calculate totals for current sales as well as projected sales.
E. Embed a bar chart that accurately displays the total sales for the current year.
F. Embed a bar chart that accurately displays the projected sales for the next five years.
G. Embed a line graph that accurately displays the projected sales growth over the next five years.

Creating a Dynamic Spreadsheet for Business Consultant Rubric Guidelines for Submission

Your Excel spreadsheet must be submitted with the following naming convention: spreadsheet_firstinitiallastname.xlsx.
Critical Elements Proficient (100%) Needs Improvement (75%) Not Evident (0%) Value
Spreadsheet: Current Sales Displays current sales by category and total Displays current sales but does not display by category and/or total, or information is otherwise incomplete Does not display current sales by category and total 15
Spreadsheet: Projected
Sales Displays projected sales by category and total Displays projected sales but does not display by category and/or total, or information is otherwise incomplete Does not display projected sales by category and total 15
Spreadsheet: Font and Size Selects a consistent and standard font and font size Selects a consistent font and font size, but font and/or font size distract from the message or are not appropriate for a business audience Does not select a consistent font and font size 10
Spreadsheet: Format Formats the spreadsheet with row and column spacing, row and column alignments, and cell formatting Formats the spreadsheet but does not address all components, or formatting changes distract from the message or are not appropriate for a business audience Does not format the spreadsheet 10
Spreadsheet: Labels Applies labels that identify the values contained in each row and column Applies labels, but they do not accurately identify the values, or label formatting distracts from the message Does not apply labels 10
Spreadsheet: Formulas Applies formulas to calculate all totals Applies formulas to calculate totals, but not all calculations are addressed with formulas, or formulas contain inaccuracies Does not apply formulas 10
Spreadsheet: Current Year Embeds a bar chart that accurately displays the total sales for the current year Embeds a bar chart that displays the total sales for the current year, but chart contains inaccuracies, or formatting and style choices distract from the message Does not embed a bar chart that displays the total sales for the current year 10
Spreadsheet: Next Five Years Embeds a bar chart that accurately displays the projected sales for the next five years Embeds a bar chart that displays the projected sales for the next five years, but chart contains inaccuracies, or formatting and style choices distract from the message Does not embed a bar chart that displays the projected sales for the next five years 10
Spreadsheet: Sales Growth Embeds a line graph that accurately displays the projected sales growth over the next five years Embeds a line graph that displays the projected sales growth over the next five years, but graph contains inaccuracies, or formatting and style choices distract from the message Does not embed a line graph that accurately displays the projected sales growth over the next five years 10
Total 100%

Not for Profit Organization Research

Not for Profit Organization Research an entity (a business or not-for-profit organization) and write a paper reflecting the following items below.

You should seek out and reference credible resources in obtaining needed information, avoiding anecdotal information available from websites such as Wikipedia.

Not for Profit Organization Research Assignment Directions

Please follow these directions carefully to successfully complete the assignment.
Items to address in your paper:
Overview of what the entity does, how long it has existed, where it is located, whether it falls within manufacturing or services, what industry it belongs to, and how many employees it has (and what types), as well as their mission, vision, values, goals, and strategic/business plans (if available)
Its stakeholders, how they impact or are impacted by the organization, and their roles in relation to that organization
Whether the entity provides a social benefit to the community, its country, and/or the world.
Who its key buyers and suppliers are
What environmental factors currently have an impact on the entity and what future factors you anticipate could potentially impact it
What potential impacts and/or concerns you foresee based various economic indicators and trends
The entity’s ethics code based on its values, guiding principles or other information available through and whether you feel it is compliance-based or integrity-based and why
The legal ownership, as well as the tax, status of the entity, associated implications, and whether that status has changed historically to this point
The organizational chart/hierarchy, the characteristics of the leaders and how long they have been there
Results of a SWOT analysis and associated implications
The Human Resources policies and any associated eccentricities or issues
What job postings are currently listed and for what types of positions
Whether any employees are union employees, and if so, what union they belong to
Their marketing strategy and associated tactics, in terms of the 4 P’s, including the types of customers they target
Their distribution system and associated implications
Their online presence and if/how they leverage that in their sales and marketing, as well as in customer engagement and interaction
Current key competitors and potential future or emerging competitors
Their financial status and health based on available financial data from annual reports and other sources related to their balance sheets, cash flow, stock (if public), financial ratios, etc. and any other relevant financial factors or drivers.
Your recommendations on whether someone should work there and whether you would recommend investing in the entity, as well as what you would do differently if you were responsible for its results and future

Not for Profit Organization Research Paper Structure

1) Include a paper cover page with:
Class title and number
Your name
Report submission date
Paper title (title is up to you)
Entity name
2) Start the main part of your paper on the next page with an introductory paragraph .
3) Discuss the items below in narrative format. Feel free to include tables, graphs, charts, and/or graphics as you write about various aspects of the entity. Be sure that sentences and paragraphs flow logically. Should you need help with your writing skills, contact the COD Writing Center for assistance .
4) End your paper with a conclusion paragraph .
5) Site any sources and references using proper citation via footnotes or endnotes. Include a Bibliography as a paper appendix.
The paper should be written in your own words. Direct quotes should be limited, instead expressing paraphrased conclusions.

Compensation Practice and Regulations

Compensation Practice and Regulations The purpose of this project is to demonstrate an understanding of compensation practice and regulations while applying it to real life situations.

This project will result in a fully developed compensation strategy by the end of the term. The project will have a total grade at the end of the term; however, certain segments of it will be submitted as homework assignments as well. This not only keeps you on track, it also allows me to give you some pointers if you are off course.

Compensation Practice and Regulations Project Segments and Chapters

The project will consist of the following segments:
Picking benchmark jobs and locating job descriptions (Chapters 6/7)
Job Evaluation & Market Pricing (Chapters 6/7)
Build Pay Structure(s) based on the information collected in #1 and #2 (market based/compensable factor based/integrated) (Chapter 8)
Designing a Merit Pay plan to include how merit would be determined and by whom (Chapter 8)
Building a Benefits Package that would attract and retain workers at different levels of the work force; taking into account ERISA guidelines and legally required benefits (Chapter 9)
Identification of appropriate Expatriate pay plans; what would be included (Chapter 13)
Pretending that you are the HR Director for XYZ Org and have been tasked with developing a new compensation system. The following instructions are to be used:
1. Benchmark jobs –
Pick 10 jobs that would be common in most organizations (so that you can find data on the web); jobs such as accounting clerk, receptionist, landscaper, custodian, accountant, civil engineer, HR director.
Research the jobs on-line and find job descriptions that you can use to create a “basic” description that includes Essential Functions, Experience

Compensation Practice and Regulations Essay Requirements

Requirements, Educational Requirements, any other KSAOs you feel are relevant. I don’t need exhaustive job analysis, just hit the most important factors – no more than 1 page each.
2. Job Evaluation & Market Pricing
Determine which job evaluation technique you feel best fits your organization and justify it. Should the exempt jobs be evaluated on a different system than non-exempt? Explain why or why not.
Using what is available on the web, market price your jobs (at least 3 sources of data). In a real evaluation, you would purchase surveys or match based on industry; I realize that is not possible for the purposes of this class. In the explanation of the market pricing, tell whether each job would be matched for industry and/or local/region/national and why.
Using the selected job evaluation technique, evaluate your 10 jobs explaining the steps you go through to collect the data and evaluate the jobs.
3. Build Pay Structure(s)
Include charts, data, calculations, quartiles, compensable factor ratings, evaluative point plans, trend lines, etc.
Demonstrate the pay structure(s) that you come up with for your jobs.
4. Designing a Merit Pay plan
Describe a process for giving out merit pay (tied to annual performance appraisals? Achievement pay? Bonuses?) And explain why you chose this process. – no more than one page
Develop a pay matrix based on current pay and performance ratings.
5. Building a Benefits Package that would attract and retain workers at different levels of the work force
Include two sections:
Mandated benefits
Added benefits to attract and retain and various levels of the org
Describe regulations that would be considered in maintaining these benefits long term.
6. Identification of appropriate Expatriate pay plans
Explain which additional benefits you would extend and why
Explain what extra pay you would extend and why

Four Firm Concentration Ratios and Competition

Four Firm Concentration Ratios and Competition What is the FOUR-FIRM concentration ratio of your chosen industry?

(90.8% in the brewery industry example indicated above) HIGHLIGHT or CIRCLE that number on your attachment (so that I can find it quickly when grading this assignment).
Based on your answer above, into what classification would your industry fall AND WHY?
Pure Competition
Monopolistic Competition
Oligopoly
Monopoly. The concentration ratio, in economics, is a ratio that indicates the size of firms in relation to their industry as a whole. The concentration ratio indicates whether an industry is comprised of a few large firms or many small firms.

Price Elasticity of Demand in Test Market

Price Elasticity of Demand in Test Market FACTS: Friendly Markets supermarket chain recently performed an experiment in a test-market city (i.e. Cincinnati).

The supermarket chain varied the price of beef over the course of two weeks while holding all other prices constant. During the experiment, the supermarket chain captured the following data regarding the price of beef per pound and the quantity (in pounds) of beef purchased by customers in a given week.
Use the TOTAL REVENUE test to determine if the beef product described above is ELASTIC or INELASTIC. This test is described in the Elasticity chapter of our textbook. Show all your work and document all your logic below.
Calculate the PRICE ELASTICITY OF DEMAND (Ed) for this beef product. This formula appears in the Elasticity chapter of our textbook and in my video lessons on Elasticity. Use the “mid-point” approach that is described in the text. Show all your work and document all your calculations and logic below. Label all amounts. Be neat. Use a ruler. Use a pencil (not a pen). Erase–don’t cross out. Be sure your name appears on your work. Write legibly.
Your calculation of the price elasticity of demand (above) indicates that this beef product is INELASTIC or ELASTIC?

Supply and Demand Curve Direction

Supply and Demand Curve Direction In your answer specify which curve is affected (supply or demand), in what direction (increase or decrease) and what is the effect on equilibrium price (increase or decrease or stay the same) and what is the effect on equilibrium quantity (increase or decrease or stay the same).

Because there are two separate scenarios, be sure to specify which scenario you are addressing in each case.
What is the likely effect on equilibrium price and quantity if orange growers experience an extended period of bad weather? Which curve(s) is (are) affected by bad weather (supply, demand, both, or neither)? Your answer must indicate the effect of that bad weather on the equilibrium price of oranges (did the price go up, go down, or remain unchanged?). Your answer must also indicate the effect on equilibrium quantity (did it increase, decrease, or remain unchanged?).
What is the likely effect on the equilibrium price and quantity of corn if the government requires ethanol (a corn byproduct) to be added to all gasoline to reduce emissions? This question is separate from and independent of the first question. Which curve(s) is (are) affected by this new government regulation (supply, demand, both, or neither)? Your answer must indicate the effect of that government regulation on the equilibrium price of corn (did the price go up, go down, or remain unchanged?). Your answer must also indicate the effect on equilibrium quantity (did it increase, decrease, or remain unchanged?).

Tools to Solve a Business Problem

Tools to Solve a Business Problem Research a business problem that has occurred either at your organization or in the news:
Provide a short summary of the problem.

Identify possible solutions using at least one technique or tool:
If you choose a process, include the names of the steps as you describe the process.
If you choose a tool, include the diagram/map.
Describe the decision-making process you would follow.
Compare your results to the decisions made in the actual scenario.
Analyze which decision-making method and solution you think is most appropriate for the business problem.
Justify your response and analysis by using and citing relevant research.

Process Mapping of Diageo Ireland plc

A supply chain/process mapping of Diageo Ireland plc. A description of the supply chain Analysis of the processes ( Identify all the organisations, people, activities.

Information and sources involved in the supply chain and create a flow chart diagram to obtain an overview of the chain) Engage with theory as a basis for the analysis. Evaluate the effectiveness of the overall supply chain dynamics.

Process Mapping of Diageo Ireland plc Recommendations

Discuss how the supply chain fits into the overall business. Conclusions and recommendations. Particular emphasis on the Diageo Ireland and the supply chain in Ireland. 1500 words total not including any diagrams. Some of the major well known theories behind supply chain management must be discussed to include- Product and Process design Job design Layout design Planning and Control Inventory Management Capacity Management Just In time Supply Networks

Business Ethics Response Development Paper

Business Ethics Response Development Paper What problems can result for an organization and its customers when the organization acts in an ethically questionable manner?

Develop a response that includes examples and evidence to support your ideas, and which clearly communicates the required message to your audience. Organize your response in a clear and logical manner as appropriate for the genre of writing. Use well-structured sentences, audience-appropriate language, and correct conventions of standard American English. Business ethics is the study of proper business policies and practices regarding potentially controversial issues such as corporate governance, insider trading, bribery, discrimination, corporate social responsibility and fiduciary responsibilities.

Supply Chain Process mapping of Diageo Ireland plc

A supply chain process mapping of Diageo Ireland plc. A description of the supply chain. Analysis of the processes ( Identify all the organisations, people, activities.

Information and sources involved in the supply chain and create a flow chart diagram to obtain an overview of the chain). Engage with theory as a basis for the analysis. Evaluate the effectiveness of the overall supply chain dynamics. Discuss how the supply chain fits into the overall business. Conclusions and recommendations. Particular emphasis on the Diageo Ireland and the supply chain in Ireland. 1500 words total not including any diagrams. Some of the major well known theories behind supply chain management must be discussed to include- Product and Process design. Job design Layout design Planning and Control Inventory Management Capacity Management Just In time Supply Networks These theories and more if needed.