A large online company’s marketing department needs information to examine sales, predict future directions, and determine how and what to advertise.

A star schema is a type of data warehouse design that optimizes multidimensional query performance (Poolet, 2007).

Your reading gives a case example and a high-level overview of modeling an information system. The first step in designing an information system is to construct a data model. The data model you use is a star schema.

A large online company’s marketing department needs information to examine sales, predict future directions, and determine how and what to advertise. Design a star schema to organize the sales information to meet the marketing department needs. Identify the dimensions first, and then identify the attributes of those dimensions.

Prepare the current liabilities section of the balance sheet at January 31, 2015. Assume no change in accounts payable.

Due Week 6 and worth 70 points

Directions: Answer the following questions on a separate Microsoft Word or Excel document. Explain how you reached the answer or show your work if a mathematical calculation is needed, or both. Submit your assignment using the assignment link in Blackboard.

Exercises

E9-9. Presented below are selected transactions at Ridge Company for 2015.

Jan. 1 Retired a piece of machinery that was purchased on January 1, 2005. The machine cost $62,000 on that date. It had a useful life of 10 years with no salvage value.
June 30 Sold a computer that was purchased on January 1, 2012. The computer cost $45,000. It had a useful life of 5 years with no salvage value. The computer was sold for $14,000.
Dec. 31 Discarded a delivery truck that was purchased on January 1, 2011. The truck cost $33,000. It was depreciated based on a 6-year useful life with a $3,000 salvage value.

Instructions
Journalize all entries required on the above dates, including entries to update depreciation, where applicable, on assets disposed of. Ridge Company uses straight-line depreciation. (Assume depreciation is up to date as of December 31, 2014.)

E9-11. On July 1, 2015, Friedman Inc. invested $720,000 in a mine estimated to have 900,000 tons of ore of uniform grade. During the last 6 months of 2015, 100,000 tons of ore were mined and sold.

Instructions
a) Prepare the journal entry to record depletion expense.
b) Assume that the 100,000 tons of ore were mined, but only 80,000 units were sold. How are the costs applicable to the 20,000 unsold units reported?

E10-12. Whitmore Company issued $500,000 of 5-year, 8% bonds at 97 on January 1, 2015. The bonds pay interest twice a year.

Instructions
a) (1) Prepare the journal entry to record the issuance of the bonds.
(2) Compute the total cost of borrowing for these bonds.
b) Repeat the requirements from part (a), assuming the bonds were issued at 105.

E10-15. Jernigan Co. receives $300,000 when it issues a $300,000, 10%, mortgage note payable to ﬁnance the construction of a building at December 31, 2015. The terms provide for semiannual installment payments of $25,000 on June 30 and December 31.

Instructions
Prepare the journal entries to record the mortgage loan and the ﬁrst two installment payments.

Problems

P9-7A. The intangible assets section of Sappelt Company at December 31, 2015, is presented below.

The patent was acquired in January 2015 and has a useful life of 10 years. The franchise was acquired in January 2012 and also has a useful life of 10 years. The following cash transactions may have affected intangible assets during 2016.
Jan. 2 Paid $27,000 legal costs to successfully defend the patent against infringement by another company.
Jan.–June Developed a new product, incurring $140,000 in research and development costs. A patent was granted for the product on July 1. Its useful life is equal to its legal life.
Sept. 1 Paid $50,000 to an extremely large defensive lineman to appear in commercials advertising the company’s products. The commercials will air in September and October.
Oct. 1 Acquired a franchise for $140,000. The franchise has a useful life of 50 years.

Instructions
a) Prepare journal entries to record the transactions above.
b) Prepare journal entries to record the 2016 amortization expense.
c) Prepare the intangible assets section of the balance sheet at December 31, 2016.

P10-1A. On January 1, 2015, the ledger of Accardo Company contains the following liability accounts.
Accounts Payable $52,000
Sales Taxes Payable 7,700
Unearned Service Revenue 16,000

During January, the following selected transactions occurred.
Jan. 5 Sold merchandise for cash totaling $20,520, which includes 8% sales taxes.
12 Performed services for customers who had made advance payments of $10,000. (Credit Service Revenue.)
14 Paid state revenue department for sales taxes collected in December 2014 ($7,700).
20 Sold 900 units of a new product on credit at $50 per unit, plus 8% sales tax.
21 Borrowed $27,000 from Girard Bank on a 3-month, 8%, $27,000 note.
25 Sold merchandise for cash totaling $12,420, which includes 8% sales taxes.

Instructions
a) Journalize the January transactions.
b) Journalize the adjusting entry at January 31 for the outstanding note payable. (Hint: Use one-third of a month for the Girard Bank note.)
c) Prepare the current liabilities section of the balance sheet at January 31, 2015. Assume no change in accounts payable.

Which of these presentations is most useful for the city clerk?

Student Name:____________________
Worked with:_____________________________________________________________

Please explain your work, including which functions you used in Excel – do not just write the answers. Also, just to be clear, it is my understanding that the solutions to the even-numbered problems in MBB are not available anywhere to students. But if you should happen to find them somewhere, you are not allowed to consult them on this assignment.

1. MBB Problem 2.12 (modified)
The city manager of Snook, Texas, wants to generate some statistics on a voluntary free flu shot clinic for city employees. Specifically, she has the following data on her employees, including whether employees received shots and whether they took sick leave during the winter months:

Gender Department Age Received Shot Took Sick Leave
Female Budget 33 Yes No
Male Fire 26 No Yes
Female Parks 41 No Yes
Female Budget 38 Yes No
Male Police 52 Yes Yes
Male Parks 24 Yes No
Female Police 47 No No
Female Fire 65 Yes No
Male Fire 50 Yes No
Female Parks 39 No Yes

The city manager asks you to come up with a numerical coding scheme so that these data can be placed in a statistical program for analysis.

(a) Develop a coding scheme for Gender.

(b) Develop a coding scheme for Department.

(d) Develop a coding scheme for Received Shot.

(e) Develop a coding scheme for Took Sick Leave.

2. MBB Problem 3.4 (modified)
For the entire month of January 2014, the local domestic violence shelter ran a series of ads on the government access cable television channel. The director of the shelter hypothesized that the ads would bring more attention to the problem of domestic violence and make victims of domestic violence more aware of the shelter’s programs. The director has monthly data on the number of new clients. At the end of April 2014, the director asks you to come up with a research design to help assess whether the ads had an effect on the number of clients served.

(a) What is the concept that the director wants to measure?

(b) What is the indicator that the director is proposing to use to measure that concept?

(d) What is the independent variable in the director’s hypothesis?

(e) What is the dependent variable in the director’s hypothesis?

(f) What type of research design (experimental or quasi-experimental and, if quasi-experimental, cross-sectional, case, panel, trend or mixed) would you use to test the hypothesis? Explain your answer in a few sentences.

(g) The director has monthly figures for the number of clients served in 2013. Are these data relevant for testing the above hypothesis? If so, why? Explain your answers in a few sentences.
3. MBB Problem 4.6 (modified)
The city clerk has received numerous complaints over the past year that couples applying for a marriage license have to wait too long to receive one. Although the clerk is skeptical (couples applying for a license are usually young and impatient), she pulls a representative sample of marriage licenses issued in the past year. Because a machine stamps each license application with the time the application is received and the time it is issued, she can tell how long the young (and old) lovers had to wait for the marriage license. The clerk considers service received in less than 10 minutes good and service received in less than 15 minutes acceptable. Her sample of license data is as follows:
Couple Number Minutes Waited for License
1 13
2 6
3 21
4 28
5 4
6 18
7 7
8 26
9 12
10 16
11 23
12 17
13 23
14 11
15 3
16 14
17 25
18 15
19 9
20 19
21 24
22 10
23 15
24 4
25 27
26 17
27 5
28 20
29 13
30 16

(a) Prepare the frequency distribution for these data.

(b) Prepare the percentage distribution for these data.

(d) Prepare a histogram for these data.

(e) Which of these presentations is most useful for the city clerk? What should the city clerk conclude? Explain your answers in a few sentences. (You do not have to write a memorandum, as in the original MBB problem.)

4. MBB Problem 5.12 (modified)
The head of the Data Processing Department in Springhill wants to estimate the amount of waste and inefficiency in her department. She conducts a survey of employees in the department. One question asks, “To what extent does this department have waste and inefficiency in its operations?” The responses to the item are given in the accompanying table.
Response Number of
Employees
To a very great extent 42
To a great extent 31
To a moderate extent 19
To some extent 12
Not at all 7

(a) At what level of measurement are these data?

(b) Calculate the percentage distribution.

(d) According to these data, does the department appear to have a problem with waste and inefficiency? Explain your answer in a few sentences.

5. MBB Problem 6.10 (modified)
The director of the South Bloomington YMCA has become concerned about the health of the organization’s employees. He issues a directive to all YMCA sites advising all managers to encourage employees to get at least 60 minutes of exercise per day. Following are the data on the number of minutes exercised per day (on the average) by the 10 employees of the South Bloomington YMCA site:

75 20 15 95 30 100 40 10 90 120

(a) Calculate the mean, median, mode, and standard deviation for these data.

(b) How well do these employees meet the standard for exercise recommended by the director of the YMCA? Explain your answer in a few sentences.

6. MBB Problem 6.18 (modified)
The director of the Madison County jail is planning to testify before the Wisconsin state legislature with the goal of obtaining more state funds for the county jail system. In preparing his remarks, the director plans to present data on the average number of days that prisoners remain in jail. The director believes that his case will be more compelling if he can show that the average stay for prisoners is greater than 21 days. The director asks you, as chief operations officer for the jail, to calculate descriptive statistics for a random sample of 250 prisoners processed in the last 9 months. (Note: The data set for this problem is posted on Blackboard.)

(a) Calculate the mean, median, mode, and standard deviation for these data.

(b) What can you tell the director about his 21-day target? Explain your answer in a few sentences.

Explain briefly, the statute(s) (law or act) which was in question in your case, the facts of the case, and why the parties were in court. What was each party asking the court to do?

Your project is to write a 6-8 page, double-spaced mini-research paper, with your subject as Employment Discrimination. Everything you need to know about the project resides below.

Your project requires at least three (3) outside resources besides the textbook. Your paper must be written in APA format, include a title and reference page, and reference your sources both internally (parenthetically) and in the reference page. Please use the APA template in doc-sharing to complete your work.

Employment discrimination law is about prohibiting or encouraging behaviors in the workplace regarding differences in people. It has evolved over the years significantly, and the passage of Title VII, the US. Civil Rights Act, has made more changes to how the US defines the right to work free from harassment and discrimination, than any other law, case, or regulation in the nation. This project has three parts. Part 1 asks you to answer eight questions about employment discrimination. Part 2 asks you to pick one US Supreme court case from a list, to discuss. Part 3 asks you to review pending legislation regarding employment discrimination, and provide a few details about one currently pending (i.e. not yet passed) bill in either your state, or the federal government. Remember, the focus of the project is onemployment discrimination.

Project Part 1:

Answer each of the following 8 questions, in 1-2 paragraphs each. You can use your textbook, or other outside sources to answer these questions. Do not write a book – answer the questions succinctly.

What must a person who is claiming they were harassed in the workplace allege in order to first state a case with the EEOC for each of the following types of harassment:
1. Sexual harassment – quid pro quo
2. Sexual harassment – hostile environment
3. Religious harassment
4. Racial harassment
Explain the difference between sexual harassment, gender discrimination, and sexual orientation discrimination, as those terms are used legally.
How does GINA protect a person whose mother died of breast cancer from employment discrimination?
Provide one example of a behavior that could be found to be both a hostile environment and quid pro quo forms of sexual harassment at the same time. Explain how a person could argue that this behavior at work was illegal.
Give the main legal reason why every company should have a valid written policy against all forms of harassment (besides the fact it is the “right” thing to do.)
Can an employer require that only females serve female customers and only males serve male customers? Explain your answer using legal terms.
How many employees must an employer or company have working for it to be subject to:
1. the ADA
2. Pregnancy Discrimination Act
3. Title VII
4. IRCA
5. GINA
Assume you work for a company that has a sexual anti-harassment policy, but not a religious, sexual orientation, or racial anti-harassment policy. Write a one-two paragraph statement to your boss (the HR Director), as to why you believe it would make sense to revamp the policy to include other forms of harassment. Include one example of a real situation where a policy may have protected a company from liability or stopped harassment from happening. (You will find case examples on the EEOC website). Cite that case/situation in your memo to your boss. Provide the amount of damages/fines the company in your example case had to pay as a result of failing to protect an employee from discrimination.

Project Part II. Employment Discrimination Cases.

Many court cases on employment discrimination have shaped, created, and changed the employment landscape. Some protect employees from discrimination, and many protect employers from liability. Settlements and trial court cases do not create legal precedent or changes in the law. However, appeals court cases, and especially the U.S. Supreme Court Cases, do change, shape, and create new law, when statutes are interpreted in binding ways. Pick ONE case from the following list. Read the case. Answer each of the FOUR questions following the list of cases and place them in your Project Part II. Be sure to identify WHICH of the cases you selected.

List of U.S. Supreme Court Cases:

Vance v. Ball State University. http://www.supremecourt.gov/opinions/12pdf/11-556_11o2.pdf

University of Texas Southwestern Medical Center v. Nassar. http://www.supremecourt.gov/opinions/12pdf/12-484_o759.pdf

Phillips v. Martin Marietta Corp. 400 U.S. 542 (1971). http://caselaw.lp.findlaw.com/scripts/getcase.pl?court=US&vol=400&invol=542

Espinoza v Farah Mfg. Co, 414 U.S. 86 (1973) http://caselaw.lp.findlaw.com/scripts/getcase.pl?court=US&vol=414&invol=86

Oncale v. Sundowner Offshore Services, 83 F. 3d 118 http://www.law.cornell.edu/supct/html/96-568.ZO.html

Questions for answering.

Explain briefly, the statute(s) (law or act) which was in question in your case, the facts of the case, and why the parties were in court. What was each party asking the court to do?
What did the court decide in your case and what will be the results of that decision? (i.e. who won, and was the win final or did the court send the case back to the lower court system to re-decide an issue?)
In what way did this case create, change, or shape the employment landscape for employers as a result of the decision made? Did this change help employers or employees the most? Explain.
Do you agree with the decision in the case you referenced? In other words, do you think that employment law was made better and stronger, or weaker and less effective as a result of this case? Write at least one full paragraph that supports your opinion.

Part 3. Legal Research into an Employment Law Pending Before Congress

Organizations such as the Society for Human Resource Management (http://www.shrm.org) work hard to support, lobby against, or provide education to the public about laws that will affect workers and employers. These organizations significantly influence what laws pass. Savvy HR managers have SHRM on their desktops so they are familiar with the many changes being suggested at any time, as they could cost companies significant amounts of money if they are passed.

Each year, thousands of proposed laws are being discussed, debated, and either passed, ignored, or rejected in state legislators around the country, or in Congress.

Find a proposed piece of legislation in the U.S. (or your state legislature) which interests you. This piece of legislation needs to regard employment law in some way (labor law, employment discrimination, ADA, PPACA, Title VII, GINA, etc.) Note that any bill that suggests changes to any current law will suffice, as well as a new law. Some examples you can use if you are interested are: the Fair Playing Field Act of 2012, the Religious Freedom Act of 2012, or a new bill regarding whether full-time employment under PPACA is 40 hours/week instead of 30 hours. (Since the time of writing this project, it is possible these examples of passed – be sure to check if you use any of them).

Places to look for legislation like this include:

Congress.gov. http://www.congress.gov

(Note that the Active Legislation link (right side) and Most Viewed Bills side include unpassed, pending legislation. the Public Laws link are passed laws – so do not use those.)

Govtrack.US https://www.govtrack.us/

Note: you can type in your state, and get updates your state’s representatives to Congress.

SHRM’s legislative pages: http://www.shrm.org/legalissues/federalresources/federallegislation/pages/default.aspx#

(Note that link takes you to the top level – and you can dig around on their links to find more information. Some of the internal pages may require a subscription to SHRM, however.)

Once you find a law pending before Congress that interests you, read the bill and answer these questions.

What is the name of the bill? What is the resolution number of the bill (e.g., HR 212)?
Does the bill you selected create a new law or amend an existing law?
If this bill is passed, how will it change current employment law? Be specific here and include enough detail so that someone reading your answer really understanding the bill under consideration.
State whether you agree or disagree with the bill. If you were a member of Congress would you vote for it? Explain why.

This section of your paper should be about 1 to 2 pages.

Analyze the external environment for opportunities and threats that impact a firm.

I need the following done on Pepsi Co as the company.

Assignment 2: External and Internal Environments

Due Week 4 and worth 350 points

Choose an industry you have not yet written about in this course, and one publicly traded corporation within that industry. Research the company on its own Website, the public filings on the Securities and Exchange Commission EDGAR database (http://www.sec.gov/edgar.shtml), in the University’s online databases, and any other sources you can find. The annual report will often provide insights that can help address some of these questions.

Write an eight to ten (8-10) page paper in which you:

Choose the two (2) segments of the general environment that would rank highest in their influence on the corporation you chose. Assess how these segments affect the corporation you chose and the industry in which it operates.
Considering the five (5) forces of competition, choose the two (2) that you estimate are the most significant for the corporation you chose. Evaluate how well the company has addressed these two (2) forces in the recent past.
With the same two (2) forces in mind, predict what the company might do to improve its ability to address these forces in the near future.
Assess the external threats affecting this corporation and the opportunities available to the corporation. Give your opinions on how the corporation should deal with the most serious threat and the greatest opportunity. Justify your answer.
Give your opinion on the corporation’s greatest strengths and most significant weaknesses. Choose the strategy or tactic the corporation should select to take maximum advantage of its strengths, and the strategy or tactic the corporation should select to fix its most significant weakness. Justify your choices.
Determine the company’s resources, capabilities, and core competencies.
Analyze the company’s value chain to determine where they can create value using the resources, capabilities, and core competencies discussed above.
Use at least three (3) quality references. Note: Wikipedia and other Websites do not quality as academic resources.

Your assignment must follow these formatting requirements:

Be typed, double spaced, using Times New Roman font (size 12), with one-inch margins on all sides; references must follow APA or school-specific format. Check with your professor for any additional instructions.
Include a cover page containing the title of the assignment, the student’s name, the professor’s name, the course title, and the date. The cover page and the reference page are not included in the required page length.

The specific course learning outcomes associated with this assignment are:

Identify how the six segments of the general environment affect an industry and its firms.
Identify the five forces of competition.
Analyze the external environment for opportunities and threats that impact the firm.
Analyze the internal environment of a company for strengths and weaknesses that impact the firm’s competitiveness.
Use technology and information resources to research issues in business administration.
Write clearly and concisely about business administration using proper writing mechanics.

How frequently do you cook?

Business Plan – Spice Shop
Term 1 Nov 2015
Group: Winnie, Rana, Mariam, Max
Subject: Professional Communication Skills
Word Count: 783

Contents Page
Section 1 Business Proposal P3-
Introduction
Objectives
Mission Statement
Section 2 Research Analysis P4-6-
Primary
Secondary
Target Consumer
References P7-16-
Appendices
Bibliography
● Business Proposal

Introduction:
We personally believe that spices are not easily accessed in Norwich, which brings us to our idea, to set up a Spice shop in Norwich City. We plan to provide spices available in a retail shop premise. Follows a price to weight system; pre orders are accepted for larger amount of spices or specific premium spices that need to be ordered to buy in large quantities. Offering fresh whole spices, which will be grounded upon order and services to mix your own favorite spices to create a special mix will also be available. Furthermore, spice drinks and snacks will be provided at the store for on the spot food and beverage services at our shop with free wifi as another attracting feature. Despite being a spice shop, other defining factors to our shop will also be selling herbs, rice, grains and seeds of different kinds. To promote our spice products not only as cooking material, but also as medical & relaxation commodities. Along with each spice, our store would like to give advice on how it could be used by giving the customer a recipe that matches the bought spice, giving detailed quantities of spices to include in certain recipes.

Mission statement:
We specialize in selling high quality fair trade spices at a moderate price. Our vision is to attract consumers by providing a wide selection of spices. Our business aims to set up premises for the public to have access to spices and herbs easily. Our mission statement is “To bring flavor to your life.”
Objectives:
Our business also brings practical knowledge to the kitchen; even the most inexperienced cooks could make delicious dishes. Our first objective for our business is to survive in the market and hopefully increase our profit by attracting more customers, thus increasing our awareness. Lastly we aim to expand from our initial target market, market demographics changes like outsourcing to food and beverage retailers
● Research Analysis
Primary:
Questionnaire results: Do you normally cook with spices?
As shown above, 31 out of 51 female, 21 out of 48 male are using spices for cooking. This shows there is a potential market for our businesses as the respondents from both genders have a total of 52 people normally cook with spices, which is more than half.
How frequently do you cook?

According to the results we got, more numbers of respondents from the age of 15 to 40 reported they do not always cook but only sometimes. They could possibly be the universities or college students. Respondents aged 41-50 are more likely to be a target customers as 10 out of 17 respondents are reported they always cook. From the age 51 and over respondents do cook sometimes, but comparing with the younger respondents they have a higher percentage of cooking more often than the respondents aged 15-30. Therefore, we decided to put our main focus on the middle age group from 20 and above as a targeted customers.

Checking on the competition:
Herb and spices within Norwich Market is our direct competition, they sell herbs and spices, and unusual items which are difficult to find in the supermarkets. (Smoked pimenton paprika and all kinds of lentils and dried pulses)
Secondary:
Target consumer:
We focus on customers in middle age group, upper 20 and over females, universities/ college students minority groups and even innovative chefs. According to the Food Standard Agency 2014 survey, people aged 16-24 would rather have take outs than cooking themselves. This is the opposite of those aged 60 and over who would rather cook their own meals. 62% of the respondents aged 25 and over are cooking for themselves everyday. 74% women prepare food themselves. Women are more likely to go grocery shopping compared to men with the percentages of 68% to 32%.

Calculating start up financial budget
Given a £100,000 limit, is sufficient capital to start up our Spice retail premises. To sum up total spending, With fixed costs works out to £45,970.84 (Appendix 3) ranging to variable costs works out to £5719.18 (Appendix 4), these figures can judge roughly how much we’ll need for the duration of the start up period. All resources are spent on making a full start up to the business, with these factors taken under consideration is vital to survive the first two years of opening, taking into account all necessary elements to maximize resources selected for start up such as our capacity to sell and stock our product with sufficient staff to cater to all potential customers, has added up to a sum of £15,104.29 (Appendix 2). Our total cost is £67,225.75. Which gives us funds for marketing and future improvements to our business.
● References:
Appendix:
Appendix 1: Retail Space http://propertylink.estatesgazette.com/property-details/6024997-64-king-street-norwich-nr1-1pg

Office, General Retail, Offices, Retail. The property comprises the ground floor of a Grade II listed traditional building of brick construction with large timber framed display windows. The unit provides front sales or office area with rear storage, WC and kitchenette facilities. The unit has concrete floors with laminate, plastered and emulsioned walls, night storage heaters and modern lighting
(329 sq ft–£5,000.00 Per Annum)
64 King Street
Norwich
NR1 1PG
View on map
Nearby stations
Norwich (0.3 miles)
Brundall Gardens (5.0 miles)
Salhouse (5.1 miles)

Appendix 2:
Start up cost for the firm

Item Quantity Price Expiry
Premise – Rent 329 square feet £5000 annual cost
Machinery –
Cash register
Computers
Weighing scale
Spice grinder

Casio SE-C450 Cash Register Till x1

HP Pavilion 23-q135na
Touchscreen All-In-One PC x1

Typhoon BellaScales StainlessSteel (x3)
industrial herb spice grinder

£167.94 x 1
£599.00 x 1
£89.97 x 3
= £269.91
£1322.31
5 years
5 years

Furniture –
Shelves

Chairs

Tables
Jars

Containers
wallpaper

Standard Duty Shelving 1830mm High 4 Shelves (x2)
Swift Wooden Bistro Chairs (4 set)
Braemar Flexi Tables Rectangular (1200W x 800D x 730H)
Carina Spice jars (sets of 12) x10
Royal Stainless Steel Spice Jar (sets of 6)
Rustic Wood Scrapwood Reclaimed Wood Wallpaper Beige & Brown tones, Striped wood
£73.00 x 2
= £146.00
£29.75 x 4
= £119.00
£96.00 x 2
= £192.00
£40.99 x 10
= £409.90
£48.99 x 6
= £293.94

£1.75 x 329ft=£575.75
3 – 5 years

2 – 7 years

2 – 4 years

1 – 2 years

2 – 3 years
Flooring hardwood flooring 329 ft £2882.04
20 years+
electrical wiring-

Wires
power sockets
installation

Solid Core Hookup Wire 1/0.6 mm 22AWG Breadboard Jumpers 11 colours 1 – 100m
LAP 13A SP 2-Gang Switched Socket & USB Charger Port White

x1 £100
100m £99
10x£12.00=£120.00
n/a
10 years+
10 years +
lights-
lightbulbs
light switch LE 12W A60 E27 LED Light Bulb
3 Gang 2 Way Light Switch – Gun Metal

x10 £69.9

3x£6.96=£20.88
20 years
security and safety-

surveillance camera
burglar alarm
fire alarm
fire extinguisher

4 Channel Home Security Camera System 960H
DVR HDMI 2 Bullet 600TVL CCTV Cameras

Honeywell Home Wireless Burglar Alarm Kit

C-Tec 4 Zone Fire Alarm System Contractor Kit
1kg dry powder fire extinguisher
x1 £49.99
x1 £179.99

x1 £339.95
3×9.59= £28.77

5 years

5 years
5 years

1 year
plumbing-

toilets
toilet sink

kitchen faucet
bathroom faucet
kitchen sink

Melbourne Ceramic Close Coupled Modern Toilet

Essential Bathroom Inset Vanity Basin

Installation and pipes

Kitchen Faucet Contemporary Pullout Spray / Pre Rinse Brass Chrome

Beta Classic Basin Taps

Wickes Single Bowl Kitchen Sink stainless Steel lh drainer
x1 £99.95

1x£39.00
329×3.31=£1088.99
1x£154.39
x1 £16.99
x1 £29.60
10years

10years
n/a
5 years
5 years
5 years
Total cost
(after VAT) £15,104.29

Budgeting for the firm operation long term
Appendix 3:
Fixed Cost
Item Quantity Price Expiry
Employees 3 £151.20
£43.545.60 Per day
Annually
Water bill N/A £393.00 Per month
F & B approval (licenses) 1 £173.24 Per year
Insurance employer liablity
public liability
property insurance £856.00
Per year

storage cost 22 square feet Included in rent Per year
electricity bills n/a £370.00 Per year
wifi bill 200mb £513.00 Per year
telephone bill unlimited £120.00 Per year
Total cost (after VAT) £45,970.84
Appendix 4:
Variable Cost
Item Quantity Price Shelf life
Vanilla
Green Cardamom
Cinnamon
Cloves
Cumin seeds
Turmeric Haldi
Black peppercorn
Ginger ground
Jalapeno flakes
Chillies
Nutmeg
Fennel Seeds
Coriander Seeds
Cumin Seeds
Bay Leaves
Oregano
Saffron
Total 150 pods
10KG
10KG
10KG
10KG
10KG
10KG
10KG
10KG
10KG
5KG
10KG
10KG
10KG
10KG
10KG
1KG

136KG £146.25
£306.55
£188.68
£374.57
£59.32
£27.86
£101.43
£38.59
£169.90
£44.15
£799
£104.3
£159.8
£173.7
£63.48
£77.2
£554.40

£3389.18 1-2 years
Coffee 10KG £700 2-3 months
Chives
Rosemary
Winter Thyme
Basil
Lemon Grass
Sage

Total 10KG
17KG
20KG
15KG
8KG
10KG

80KG £106.19
£55.73
£79.82
£55.30
£57.55
£73.35

£427.94
1 year
Premium Basmati Rice
Organic Jasmine Rice 100KG
100KG £218.40
£554.40 2 years
Sugar 200KG £114 N/A
Black Tea Leaves 10KG £747.50 6 months
Total variable cost £6150.62
Bibliography:
“How to Estimate Plumbing Costs for New Construction.” Home Guides. N.p.,Food Standards. Food and You UK 2014: UK Bulletin (n.d.): n. pag. Web. 25 Nov. 2015.
“Swift Wooden Bistro Chairs (4 Pack).” Swift Wooden Bistro Chairs (4 Pack). N.p.,Industrial Spice Grinder Suppliers and Manufacturers at Alibaba.com. N.p.,NR1 1PG.” Property To Let. N.p.,Norwich,Replace 75W A60 GLS Lamp | LE. N.p.,Replace 75W A60 GLS Lamp | LE.” 12W E27 LED Bulb,n.d. Web. 25 Nov. 2015.,n.d. Web. 25 Nov. 2015.
“12W E27 LED Bulb,n.d. Web. 25 Nov. 2015.
“4 Channel Home Security Camera System 960H DVR Hdmi 2 Bullet 600TVL CCTV Cameras | EBay.” EBay. N.p.,n.d. Web. 25 Nov. 2015.
“64 King Street,n.d. Web. 25 Nov. 2015.
“Basil.” Basil. N.p.,n.d. Web. 25 Nov. 2015.

“National Minimum Wage Rates.” – GOV.UK. N.p., n.d. Web. 26 Nov. 2015.
“Beta Classic Basin Taps | Homebase.” Homebase. N.p.,n.d. Web. 25 Nov. 2015.
“C-Tec 4 Zone Fire Alarm System Contractor Kit.” CFP704-4KIT : C-Tec Conventional Fire Alarm Panel Range. N.p.,n.d. Web. 25 Nov. 2015.
“Cardamom Green Whole Pods.” The Spiceworks: Hereford Herbs & Spices. N.p.,n.d. Web. 25 Nov. 2015.
“Casio SE-C450 @ £139.95.” Casio SE-C450 @ £139.95. N.p.,n.d. Web. 25 Nov. 2015.
“Chillies Whole from Real Foods Buy Bulk Wholesale Online.” Real Foods. N.p.,n.d. Web. 25 Nov. 2015.
“Chives.” Chives. N.p.,n.d. Web. 25 Nov. 2015.
“Cinnamon Sticks Whole 6″ / 15cm.” The Spiceworks: Hereford Herbs & Spices. N.p.,n.d. Web. 25 Nov. 2015.
“Cloves Whole.” The Spiceworks: Hereford Herbs & Spices. N.p.,n.d. Web. 25 Nov. 2015.
“Cumin Seeds Ground from Real Foods Buy Bulk Wholesale Online.” Real Foods. N.p.,n.d. Web. 25 Nov. 2015.
“Essential Bathroom Inset Vanity Basin.” Essential Bathroom Inset Vanity Basin. N.p.,n.d. Web. 25 Nov. 2015.
“Ginger Ground from Real Foods Buy Bulk Wholesale Online.” Real Foods. N.p.,n.d. Web. 25 Nov. 2015.
“HP.” Pavilion 23-q135na Touchscreen All-In-One PC. N.p.,n.d. Web. 25 Nov. 2015.
“Honeywell Home Wireless Burglar Alarm Kit.” Screwfix.com. N.p.,n.d. Web. 25 Nov. 2015.
“Lemon Grass Stalks.” Lemon Grass Stalks. N.p.,n.d. Web. 25 Nov. 2015.
“Longevity Of Hardwood Flooring.” Longevity Of Hardwood Flooring. N.p.,n.d. Web. 25 Nov. 2015.
“MyBuilder – How Much Would It Normally Cost for an Electrical Wiring Safety Inspection and Certificate to Be Done?” MyBuilder. N.p.,n.d. Web. 25 Nov. 2015.
“Organic Coriander Seeds from Real Foods Buy Bulk Wholesale Online.” Real Foods. N.p.,n.d. Web. 25 Nov. 2015.
“Organic Cumin Seeds Ground from Real Foods Buy Bulk Wholesale Online.” Real Foods. N.p.,n.d. Web. 25 Nov. 2015.
“Organic Fennel Seeds from Real Foods Buy Bulk Wholesale Online.” Real Foods. N.p.,n.d. Web. 25 Nov. 2015.
“Organic White Rice Jasmine from Real Foods Buy Bulk Wholesale Online.” Real Foods. N.p.,n.d. Web. 25 Nov. 2015.
“Peppercorns Black from Real Foods Buy Bulk Wholesale Online.” Real Foods. N.p.,n.d. Web. 25 Nov. 2015.
“Premium Basmati Rice.” Premium Basmati Rice. N.p.,n.d. Web. 25 Nov. 2015.
“Quick Find.” Ceylon+Tea. N.p.,n.d. Web. 25 Nov. 2015.
“Rosemary.” Rosemary. N.p.,n.d. Web. 25 Nov. 2015.
“Saffron.” Saffron. N.p.,n.d. Web. 25 Nov. 2015.
“Sage.” Sage. N.p.,n.d. Web. 25 Nov. 2015.
“Solid Core Hookup Wire 1 0 6 MM 22AWG Breadboard Jumpers 11 Colours 1 100M | EBay.” EBay. N.p.,n.d. Web. 25 Nov. 2015.
“Standard Duty Shelving 1830mm High 4 Shelves.” Standard Duty Shelving. N.p.,n.d. Web. 25 Nov. 2015.
“The following Item Was Added to Your Cart.” Fire and Safety Centre Articles. N.p.,n.d. Web. 25 Nov. 2015.
“Turmeric Haldi from Real Foods Buy Bulk Wholesale Online.” Real Foods. N.p.,n.d. Web. 25 Nov. 2015.
“TyphoonÂ® Bella Scales Stainless Steel.” In Weighing Scales at Lakeland. N.p.,n.d. Web. 25 Nov. 2015.
“Vanilla Pods- Madagascan Bourbon.” The Spiceworks: Hereford Herbs & Spices. N.p.,n.d. Web. 25 Nov. 2015.
“What Is the Average Life of an Average Desktop Computer? – Forums – CNET.” CNET. N.p.,n.d. Web. 25 Nov. 2015.
“White Sugar.” N.p.,n.d. Web. 25 Nov. 2015.
“Winter Thyme.” Winter Thyme. N.p.,n.d. Web. 25 Nov. 2015.
” Business Insurance.” Cost of Business Insurance. N.p.,n.d. Web. 25 Nov. 2015.
“3 Gang 2 Way Light Switch – Gun Metal5055832917601FP4000GM.” 3 Gang 2 Way Light Switch. N.p.,n.d. Web. 25 Nov. 2015.
“Braemar Flexi Tables Rectangular.” Braemar Flexi Tables Rectangular. N.p.,n.d. Web. 25 Nov. 2015.
“Business Insurance Cost.” How Much Does ? Average Price. N.p.,n.d. Web. 25 Nov. 2015.
“Business Insurance Guide.” A Guide To Business Insurance – MoneySuperMarket. N.p.,n.d. Web. 25 Nov. 2015.
“Division of Hotels and Restaurants.” Apply for a Food Service or Lodging License. N.p.,n.d. Web. 25 Nov. 2015.
“Hardwood Flooring Prices – Cost Breakdown.” Hardwood Flooring Prices – Cost Breakdown. N.p.,n.d. Web. 25 Nov. 2015.
“How to Estimate Plumbing Costs for New Construction.” Home Guides. N.p.,n.d. Web. 25 Nov. 2015.
“Industrial Spice Grinder.” Industrial Spice Grinder,n.d. Web. 25 Nov. 2015.
“Melbourne Ceramic Close Coupled Modern Toilet at Victorian Plumbing UK.” Www.victorianplumbing.co.uk. N.p.,n.d. Web. 25 Nov. 2015.
“Nutmegs Whole.” The Spiceworks: Hereford Herbs & Spices. N.p.,n.d. Web. 25 Nov. 2015.
“Rustic Wood Scrapwood Reclaimed Wood Wallpaper Beige Brown Tones Striped Wood | EBay.” EBay. N.p.,n.d. Web. 25 Nov. 2015.
“Spice Shop Questionnaire.” Google Docs. N.p.,n.d. Web. 25 Nov. 2015.
“Wickes Single Bowl Kitchen Sink Stainless Steeel LH Drainer.” Wickes Single Bowl Kitchen Sink Stainless Steeel LH Drainer. N.p.,n.d. Web. 25 Nov. 2015.

Determine the primary and secondary target markets for your company.

Assignment 1: Part A: Your Marketing Plan

Due Week 4 and worth 200 points

At the end of this course, you will have created a marketing plan for a hypothetical product-based company. Each assignment focuses on a different section of the overall marketing plan. For Assignment 1, you will compile information on the company’s background information, an environmental analysis, your company’s short and long-term goals, and a SWOT analysis.

For information on Website analytics, visit Google Analytics at http://www.google.com/analytics/why/.

Note: You may create and / or make all necessary assumptions needed for the completion of this assignment.

Write a five to six (5-6) page paper in which you:

Write an introduction to your company. Describe your company, its location, and the product it makes or the service it provides.
Develop an environmental analysis that includes competitive, economic, political, legal, technological, and sociocultural forces.
Determine the primary and secondary target markets for your company. Next, analyze the primary and secondary target markets that you identified for your company. Be sure to cover the 4Ps, 5Cs and STP.
Decide the main goals that you would like to achieve within the next year (short term) and the mains goals that you would like to achieve within the next five (5) years (long term). Determine the most appropriate ways to measure both short- and long-term goals. Note: Consider the following metrics: tracking downloads of Website content, Website visitors, increases in market share, customer value, new product adoption rates, retention, rate of growth compared to competition and the market, margin, and customer engagement.
Develop both a SWOT analysis and needs analysis for your product. Each analysis should examine four (4) strengths, weaknesses, opportunities, and threats for your company.
Use at least four (4) academic resources as quantitative marketing research to determine the feasibility of your product / service. These resources should be industry specific and relate to your chosen product / service. Note: Wikipedia and other Websites do not qualify as academic resources.

Your assignment must follow these formatting requirements:

Be typed, double spaced, using Times New Roman font (size 12), with one-inch margins on all sides; citations and references must follow APA or school-specific format. Check with your professor for any additional instructions.
Include a cover page containing the title of the assignment, the student’s name, the professor’s name, the course title, and the date. The cover page and the reference page are not included in the required assignment page length.

The specific course learning outcomes associated with this assignment are:

Analyze the marketing framework including the concepts of the 5Cs, STP, and 4Ps.
Develop strategies to assess performance and achieve marketing goals.
Examine the marketing science of customer behavior and products in the marketing exchange process and create dynamic strategies for competing.
Evaluate target customer segments and positioning products within these segments.
Use technology and information resources to research issues in marketing management.
Write clearly and concisely about marketing management using proper writing mechanics
Below is the apa paper format that is to be used for this paper.

Analyze one challenge facing the leadership of an organization.

Final Paper

Focus of the Final Paper

This paper will be an application of the leadership practice concepts learned throughout your degree program to a real-world situation. In an eight- to ten-page paper, discuss one significant organizational challenge, within your organization or an organization you have researched. How did the leadership of the organization address the challenge? Could it have been done more effectively? How would you recommend future leaders strategically plan to avoid encountering a similar challenge within their own organizations? Provide suggestions for overcoming the challenge based on your own research and concepts presented in your degree program and grounded in leadership theory. Some challenges to consider would be (but are not limited to): an ethical challenge, a challenge occurring because of changes in the economy, a globalization challenge, or a challenge of organizational culture. Please request instructor approval of the challenge you would like to use as your focus before beginning your paper.

The Final Paper should, at minimum, include:

1. A description of the organization and its primary stakeholders. Include the vision and mission statement if they are available to the public, and the code of ethics if the company has one (if it is long, an excerpt or description is an acceptable alternative).

2. A detailed analysis of one challenge facing the leadership of the organization.

3. A strategy for overcoming the challenge based on outside research, the textbook, and concepts discussed during your degree studies.

Writing the Final Paper

The Final Paper:

1. Must be eight to ten double-spaced pages in length and formatted according to APA style, as outlined in your approved style guide.

2. Must include a cover page with:

o Title of Paper

o Student’s name

o Course name and number

o Name of paper

o Instructor’s name

o Date submitted

3. Must include an introductory paragraph with a succinct thesis statement.

4. Must address the topic of the paper with critical thought.

5. Must conclude with a restatement of the thesis and a conclusion paragraph.

6. Must use at least four scholarly sources to support your analysis and recommendations.

7. Must use APA style as outlined in your approved style guide to document all sources.

8. Must include, on the final page, a reference list that is completed according to APA style, as outlined in your approved style guide.

How does GINA protect a person whose mother died of breast cancer from employment discrimination?

Your project is to write a 6-8 page, double-spaced mini-research paper, with your subject as Employment Discrimination. Everything you need to know about the project resides below.

Project Part 1:

What must a person who is claiming they were harassed in the workplace allege in order to first state a case with the EEOC for each of the following types of harassment:
1. Sexual harassment – quid pro quo
2. Sexual harassment – hostile environment
3. Religious harassment
4. Racial harassment
Explain the difference between sexual harassment, gender discrimination, and sexual orientation discrimination, as those terms are used legally.
How does GINA protect a person whose mother died of breast cancer from employment discrimination?
Provide one example of a behavior that could be found to be both a hostile environment and quid pro quo forms of sexual harassment at the same time. Explain how a person could argue that this behavior at work was illegal.
Give the main legal reason why every company should have a valid written policy against all forms of harassment (besides the fact it is the “right” thing to do.)
Can an employer require that only females serve female customers and only males serve male customers? Explain your answer using legal terms.
How many employees must an employer or company have working for it to be subject to:
1. the ADA
2. Pregnancy Discrimination Act
3. Title VII
4. IRCA
5. GINA
Assume you work for a company that has a sexual anti-harassment policy, but not a religious, sexual orientation, or racial anti-harassment policy. Write a one-two paragraph statement to your boss (the HR Director), as to why you believe it would make sense to revamp the policy to include other forms of harassment. Include one example of a real situation where a policy may have protected a company from liability or stopped harassment from happening. (You will find case examples on the EEOC website). Cite that case/situation in your memo to your boss. Provide the amount of damages/fines the company in your example case had to pay as a result of failing to protect an employee from discrimination.

Project Part II. Employment Discrimination Cases.

List of U.S. Supreme Court Cases:

Vance v. Ball State University. http://www.supremecourt.gov/opinions/12pdf/11-556_11o2.pdf

University of Texas Southwestern Medical Center v. Nassar. http://www.supremecourt.gov/opinions/12pdf/12-484_o759.pdf

Phillips v. Martin Marietta Corp. 400 U.S. 542 (1971). http://caselaw.lp.findlaw.com/scripts/getcase.pl?court=US&vol=400&invol=542

Espinoza v Farah Mfg. Co, 414 U.S. 86 (1973) http://caselaw.lp.findlaw.com/scripts/getcase.pl?court=US&vol=414&invol=86

Oncale v. Sundowner Offshore Services, 83 F. 3d 118 http://www.law.cornell.edu/supct/html/96-568.ZO.html

Questions for answering.

Explain briefly, the statute(s) (law or act) which was in question in your case, the facts of the case, and why the parties were in court. What was each party asking the court to do?
What did the court decide in your case and what will be the results of that decision? (i.e. who won, and was the win final or did the court send the case back to the lower court system to re-decide an issue?)
In what way did this case create, change, or shape the employment landscape for employers as a result of the decision made? Did this change help employers or employees the most? Explain.
Do you agree with the decision in the case you referenced? In other words, do you think that employment law was made better and stronger, or weaker and less effective as a result of this case? Write at least one full paragraph that supports your opinion.

Part 3. Legal Research into an Employment Law Pending Before Congress

Each year, thousands of proposed laws are being discussed, debated, and either passed, ignored, or rejected in state legislators around the country, or in Congress.

Places to look for legislation like this include:

Congress.gov. http://www.congress.gov

(Note that the Active Legislation link (right side) and Most Viewed Bills side include unpassed, pending legislation. the Public Laws link are passed laws – so do not use those.)

Govtrack.US https://www.govtrack.us/

Note: you can type in your state, and get updates your state’s representatives to Congress.

SHRM’s legislative pages: http://www.shrm.org/legalissues/federalresources/federallegislation/pages/default.aspx#

(Note that link takes you to the top level – and you can dig around on their links to find more information. Some of the internal pages may require a subscription to SHRM, however.)

Once you find a law pending before Congress that interests you, read the bill and answer these questions.

What is the name of the bill? What is the resolution number of the bill (e.g., HR 212)?
Does the bill you selected create a new law or amend an existing law?
If this bill is passed, how will it change current employment law? Be specific here and include enough detail so that someone reading your answer really understanding the bill under consideration.
State whether you agree or disagree with the bill. If you were a member of Congress would you vote for it? Explain why.

This section of your paper should be about 1 to 2 pages.

Create a multi-level work breakdown structure (WBS) and detailed project schedule, using the information from the “Greendale Stadium Case” located at the end of Chapter 6, and incorporating the following constraints.

Greendale Project ReDux
Due Week 4 and worth 60 points
This assignment consists of two (2) parts: a project schedule, and a written response. You must submit both parts as separate files for the completion of this assignment. Label each file name according to the part of the assignment it is written for.
Part A: Project Schedule
(Submit as one [1] Microsoft Project file)
1. Create a multi-level work breakdown structure (WBS) and detailed project schedule, using the information from the “Greendale Stadium Case” located at the end of Chapter 6, and incorporating the following constraints.
Note: When you create your MS Project schedule, you will need to update your project per the following constraints:
o The project must consist of at least twenty (20) tasks.
o Each task must have a start and finish date that matches the duration noted in the assignment.
o Each task must be assigned to a resource (e.g., Demolishing Crew; Construction Crew; Landscaping Crew).
o Assume that the crew works during normal weekdays (no weekend work) under normal conditions (8 hours per day).
o In terms of holidays, you can assume no work will be done the following days: New Year’s Day, President’s Day, Good Friday, Good Monday, Friday before Memorial Day, Memorial Day, the business day before Independence Day, Independence Day, the Friday before Labor Day, Labor Day, the day before Thanksgiving Day, Thanksgiving Day, Black Friday (day after Thanksgiving), the business day before Christmas, Christmas Day, the business day after Christmas Day, and New Year’s Eve.
Part B: Written Response
(Submit as a Microsoft Word file)
1. Respond to the following questions in a one to two (1-2) page paper based on your project schedule.
o When will the project be completed?
o What is the critical path for the project?
o How much slack / float is in your project? What activities have the greatest slack / float?
o Identify the top three (3) activities that you believe could impact the project completion date.
o What additional activities you would add to this project to make it more complete, from a project management viewpoint?
2. Format your assignment according to the following formatting requirements:
o Typed, double spaced, using Times New Roman font (size 12), with one-inch margins on all sides.
o Include a cover page containing the title of the assignment, the student’s name, the professor’s name, the course title, and the date. The cover page is not included in the required page length.