1. Three different methods for assembling a product were proposed by an industrial engineer. To investigate the number of units assembled correctly with each method, 27 employees were randomly selected and randomly assigned to the three proposed methods in such a way that each method was used by 9 workers. The number of units assembled correctly was recorded, and the ANOVA was performed on the resulting data set. The following results were obtained: SST = 10,400; SSTR = 4,700. State the Hypotheses.

1. Prepare the ANOVA table and fill out all the cells.
2. Use α = .01 to test for any significant difference in the means for the three assembly methods. Use both p-Value and Critical-Value approaches

Please show how to solve in Microsoft Excel and show formulas

Three manufacturing companies supply consumables to a large corporation in batches of
300 units. Random samples of six recently supplied batches from each of the three
suppliers were carefully checked, and the numbers of parts not conforming to standards
were recorded. These numbers are listed in the table below:

a) Prepare the analysis of variance table for these data. [12 Marks]
b) Test the null hypothesis that the population mean numbers of parts per batch not
conforming to standards are the same for all three suppliers at 5% level of

Assuming Titan had 70 customers in 2015 and 80 customers in 2016,

1. calculate the operating income of Titan for 2015 and 2016;

Particulars                                                                   2015                                         2016

Revenue; 800*450;900*430                                   360,000                                 387,000

Direct Material Cost 3200*35;3300*35                112,000                                 115,500

Conversion Cost                                                      1,800,000                               1,650,000

Selling and Customer Service cost                         495,000                                   495,000

Total Cost                                                              2,407,000                                     2,260,500

Profit/Loss                                                            (2,047,000)                                 (1,873,500)

Suppose that during 2016, the overall market for AllPads grew 3%. The decrease in the selling price of the AllPad and increase in market share (that is, sales increases greater than 3%) are the result of Titan’s strategic actions.

1. Calculate how much of the change in operating income from 2015 to 2016 is due to the industry market size factor, product differentiation, and cost leadership. How does this relate to Titan’s strategy and its success in implementation? Explain.

A random group of thirty customers at a local theater was interviewed regarding their movie viewing habits. The following responses were obtained for the question, “How many times during the past month did you go to the movies?” Number of movies attended 0 1 2 3 4 Number of customers 3 10 8 6 3 a. b. Find the probability that a customer selected at random went to the movies:

1) more than one time, 2) two times, 3) at least two times, 4) no more than three times.

At a larger grocery store, some food is sold under the brands A, B and C.
Historically, sales account for 60% of brand A, 30% of brand B and
10% of brand C. Recently, a sample survey was conducted where 200 customers had to answer
on a survey, and of these customers bought 110 brand A, 55 brand B and 35 brand
C. The investigation provides evidence that the percentages for the three brands can
different from the historical proportions? Perform an appropriate test to answer
The question. Also specify the conditions you need to check in your test.

You are an owner of a small independent chain of coffeehouses competing head-to-head with Starbucks. The retail price your customers pay for coffee is exactly the same as at Starbucks. The wholesale price you pay for roasted coffee beans has increased by 25 percent. You know that you cannot absorb this increase and that you must pass it on to your customers. However, you are concerned about the consequences of an open price increase.

1. Discuss three alternative price increase strategies that address these concerns.

2. Which would you choose, and why?

For each of the three organizations below,

• Recommend whether the organization should build or buy/outsource the system in question. Explain your answer.
• What additional information would be useful in making your recommendation?

Organizations:

1. A medium-sized company that sells roofing materials to contractors needs a system that will allow customers to check product inventory through a website.
2. A large (Fortune 500) retailer with a large, well-skilled IT department needs a system that will track the purchasing habits of its frequent customers.
3. A large (Fortune 500) defense contractor needs a system that will track payments to vendors.

PLEASE Create a perceptual map using the following data:

After researching the demographic and competitive profile of several markets, they decided Dallas, Texas, would be the best place to start their business. In examining the markets, they were looking for a town that would best fit their target market of singles and families in the age range of 18 to 50. The population of Dallas was almost 5.5 million people, of which about 50 percent were between the ages of 25 and 60. This indicated there were a lot of individuals in their target market in the Dallas area. They also found that about 55 percent of the population earns between $35,000 and $75,000 a year, which indicated the market would have enough income to eat out regularly. Finally, 56 percent of the population was married, and many of them had children at home, which was consistent with their target market. More detailed demographic information for the area is shown below. The new restaurant concept was based upon the freshest ingredients, complemented by a festive atmosphere, friendly service, and cutting-edge advertising and marketing strategies. The key would be to prepare and serve the freshest “made-from-scratch” Mexican foods possible. Everything would be prepared fresh every single day. In addition to their freshness concept, they wanted to have a fun, festive atmosphere, and fast, friendly service. The atmosphere would be open, brightly lit, and bustling with activity. Their target market would be mostly families with children, between the ages of 18 and 49. Their marketing programs would be memorable, with the advertising designed to provide an appealing, slightly offbeat positioning in the market. The Santa Fe Grill was not successful as quickly as the owners had anticipated. To improve the restaurant operations, the owners needed to understand what aspects of the restaurant drive customer satisfaction and loyalty, and where they were falling short in serving their customers. So they decided to conduct three surveys. One was designed to obtain information from current customers of the Santa Fe Grill. A second survey would collect information from customers of their primary competitor, Jose’s Southwestern Café. The third survey was designed to collect data from the employees who worked for the Santa Fe Grill. They believed the employee survey was important because employee experiences might be affecting how customers evaluated the restaurant. The Santa Fe Grill was located on an outparcel on the east side near the main entrance of the Cumberland Mall. The mall has 75 or more stores and is considered very successful for the area. A market research company was located in the mall so they 19 decided to use a mall intercept approach to collect customer data. Another Mexican restaurant that had been in business longer and appeared to be more successful was also on an outparcel at the same mall, but its location was on the west side of the mall. The goal was to complete interviews with 250 individuals who had recently eaten at the Santa Fe Grill and 150 diners who had recently eaten at Jose’s Southwestern Café. Additionally, employees of the Santa Fe Grill were asked to log on to a website to complete the employee survey. Over a period of two weeks, a total of 405 customer interviews were completed—152 for Jose’s and 253 for the Santa Fe Grill. Of the employee survey, 77 questionnaires were completed. The owners believe the surveys will help them to identify the restaurant’s strengths and weaknesses, enable them to compare their restaurant to a nearby competitor, and develop a plan to improve the restaurant’s operations. Selected Demographics for Geographic Area (10-mile radius of Santa Fe Grill) Households by Type Number Percent Total households 452,000 100 Family households 267,000 59 With children under 18 years 137,000 30 Non-Family households 185,000 41 Householder living alone 148,850 33 Householder 65 years and over 29,570 7 Households with individuals under 18 years 157,850 35 Households with individuals 65 years and over 74,250 16 Average household size 2.6 people Average family size 3.4 people Gender and Age Number Percent Male 599,000 51 Female 589,000 49 Total 1,188,000 Under 20 years 98,800 29 20 to 34 years 342,000 29 35 to 44 years 184,000 16 45 to 54 years 132,500 11 55 to 59 years 44,250 4 60 years and over 13,000 11 Median Age (years) 32 18 years and over 873,000 74