solution

  1. Go to the Sales by Category worksheet. Nadia has created a PivotTable named CategoryPivot to list the sales by business category, date, and service type. The data would be easier to interpret if the dates appeared as quarter numbers. Group the Start Date field values by Quarters only. Change the report layout to Compact Form to make the PivotTable look less cluttered.
  2. Go to the Sales by Client worksheet. Nadia created a PivotTable named ClientPivot that lists sales by client and state, but she wants to simplify the PivotTable by displaying the sales by client and region. Manually group the CT, NJ, and NY column labels (cells B3, E3, and F3). Use North as the name of the group. Manually group the GA and FL column labels in row 4 and use South as the name of the group. Remove the State field from the Columns area. Rename the State2 field to use Region as the custom name. Sort the South values in ascending order to list first the North sales amounts in column B followed by the South sales amounts in column C. Hide the field headers to further streamline the layout.
  3. Go to the Sales by Service worksheet, which contains a PivotTable named ServicePivot that compares the Quarter 1, Quarter 4, and Annual sales for each service provided in 2021. Nadia wants to know the difference and the percentage of difference between the Quarter 4 and Quarter 1 sales and display the average total sales for each service. Insert a calculated field named Difference that subtracts the Qtr1 field amount from the Qtr4 field amount. In cell E2, use +/- Q4 to Q1 as the column label.
 
"Looking for a Similar Assignment? Get Expert Help at an Amazing Discount!"

solution

1) rather than showing Philadelphia cream cheese on bagels, the company took the time to educate consumers on using their products in baking or cooking. Therefore, they were partitioning the market based on:

a) brand name

b) product category

2) Dove revolutionized advertising in the personal care space with its campaign for Real Beauty. The campaign allowed Dove to take a …………. position focusing on “real beauty” rather than “cosmetic beauty”

a) brand benefit

b) central

c) user

d) differential

c) end benefit

d) usage situation

3) Apple positions itself as user-friendly and gained an advantage over BlackBerry and all other cellphone manufacturers. Apple used positioning by:

a) brand name

b) end benefit

c) cultural symbols

d) product user

4) Taking into account salient attributes, when developing a brand position diagram, the marketer should also compare brands based on …………., such as overall satisfaction or social fulfillment.

a)previous purchase decisions

b) communication effectiveness

c) salient benefits to the consumer

d) personal needs assessment

5) HP is segmenting the laptop market into work vs home. They are segmenting based on:

a) end benefits

b) brand name

c) usage situation

d) type of product

6) Kris is the creative manager for an ad agency that has just taken on a hockey skate manufacture as a client. Before developing creative ideas, Kris researches hockey videos and online publications on the sport. Also, she talks to friends, family, and amateur athletes on the topic of hockey. Here activities are part of which stage of the creative process?

a) incubation

b) immersion

c) illumination

d) verification

7) Subaru Outback took a position when they showed viewers that life outdoors was better than sitting at home.

A) brand benefit
B) differential
C) user
D) central

8) When a customer sees the slogan “Buy this product, and you will get this amazing benefit,” this is an example of a product’s …….

a) jingle

b) copy platform

c) unique selling proposition

d) brand equity

9) Many customers believe that all banks are pretty much the same. However, in some cases, consumers switch banks many times over their lifetimes to find one that meets their financial goals. Therefore, Scotiabank repositioned itself based on providing enhanced brand loyalty with their customers, they devised the slogan “You’re richer than you think to differentiate themselves towards consumers from other banks. Overall, their goal is to connect with:

a) lobby groups

b) category non-users

c) those loyal to other brands

d) new home buyers

 
"Looking for a Similar Assignment? Get Expert Help at an Amazing Discount!"

solution

Question 1

Explain the following terms in the law of contractUSING YOUR OWN WORDS AND EXAMPLE. Use simple, concise sentence structure and examples from things that you see happening around you to illustrate your point.

(a) The frustration of Contract.

(b) Specific Performance as a remedy in the contract.

Question 2

Hariz inherited an agricultural land which is situated in Johor from his father. He wishes to sell the land because he is currently living in Kedah which is about 500km away from Johor and has no time or interest to maintain the land. Ismail is interested to buy the land from Hariz for the purpose of fish farming. Hariz told Ismail that the land would be good for his fish farm. Ismail agreed to buy the land from Hariz. However, after he bought the land, Ismail discovered that he has to spend a lot of money to treat the acidic soil that is harmful to his freshwater fish and build a retaining wall around the ponds as the area is prone to flooding that causes the fishes to escape from the ponds. Ismail now wishes to cancel the contract based on what he claims is Hariz’s misrepresentation and recover the purchase price from Hariz. Advise Ismail on his chance of success.

 
"Looking for a Similar Assignment? Get Expert Help at an Amazing Discount!"

solution

Eighty units of end item E are needed at the beginning of week 6. Three cases (30 units per case) of J have been ordered and one case is scheduled to arrive in week 3, one in week 4, and one in week 5. Note: I must be ordered by the case, and B must be produced in multiples of 120 units. There are 60 units 2 of B and 20 units of J now on hand. Lead times are two weeks each for E and B, and one week for J. E B(2) J(3) J(4) F(2) QUESTION 15 Chapter 13. problem 4 part a When you prepare a material requirements plan for component, how many pieces of part do you need to release from week 1 to 6? QUESTION 16 Chapter 13. problem 4. part b. Suppose that in week 4 the quantity of Eneeded is changed from 80 to 70 The planned-order releases through week 3 have all been executed. How many more Bs will be on hand in week 62 QUESTION 17 Chapter 13, problem 4, part b. Suppose that in week 4 the quantity of E needed is changed from 80 to 70. The planned-order releases through week 3 have all been executed. How many more Js will be on hand in week 62
 
"Looking for a Similar Assignment? Get Expert Help at an Amazing Discount!"