Scenario Script Caption Text: After several productive years, Princess Foods Corporation has amassed enough capital, marketing...

Scenario Script Caption Text: After several productive years, Princess Foods Corporation has amassed enough capital, marketing identity, and operational expertise to make a major push into new product lines and markets. To help manage this growth, Princess Foods Corporation has hired you as a consultant. Princess Foods Corporation has been considering a new offering, a premium, high-quality ice cream that is low in sugar and calories. This new “Tiara” line will be offered to customers in exotic flavors, such as Avocado Sea Salt, Ginger Rosewater, and Rosemary Goat Milk, and will use locally sourced, organic ingredients. Bonnie: Well, I suppose we might as well just throw you into the fire. We’ve been piloting the “Tiara” line for the past 50 weeks. I have a presentation to the board on Tuesday and they’re going to be expecting an update on the pilot. Could you wade through this data and put together a short report for me? I’m glad you’re here. Here’s the raw data. Can you organize this? Assignment Bonnie has an upcoming presentation to the board and would like to include some market research from the pilot period. In the Excel spreadsheet are the profits and losses in thousands for Princess Foods Corporation for 50 weeks. The data reflects the performance of the “Tiara” line during the period of the pilot. Provide Bonnie with the following data in a short report:

1. Determine the number of classes, the class range, and then construct a frequency table.

2. Interpret information from the frequency table.

3. Calculate the most appropriate measure and central tendency and explain why that measure was selected.

4. Determine the percentile indicating the bottom ranking 20%. In other words, what is the dollar number that defines where the lowest values fall.

2294	-387	1417	3154	308
1601	3755	184	3273	3063
4567	1440	-404	2403	3368
3461	3709	2056	3505	3535
97	454	-795	4942	2311
2423	2080	-2258	2086	-732
-617	3197	258	3006	5453
20	-2827	-1021	1578	1939
3640	5600	4773	3780	3484
3920	3681	-142	3636	3293

Solutions

Expert Solution

orchestra answered 1 year ago

Next > < Previous

Related Solutions

Scenario Script Caption: Mieke, the head of Marketing has heard about you. And at Princess Foods,...

Scenario Script Caption: Mieke, the head of Marketing has heard about you. And at Princess Foods, like much of the rest of the world, the reward for good work is more work. Mieke: Thank you so much for making time for me. Liwei says that you’re a miracle worker... Caption: Princess Foods Corporation is piloting a new service called “Princess Select,” a new premium meal kit service. Subscribers are mailed kits that each contain all the ingredients that a customer...

M7: Non-Parametric Techniques Scenario Assignment Caption: Princess Foods Corporation has observed the changing awareness of the...

M7: Non-Parametric Techniques Scenario Assignment Caption: Princess Foods Corporation has observed the changing awareness of the population on health and nutrition. Therefore, they want to investigate the acceptance of a low-calorie product and a low-sodium product by market segment.(gender) Are people more concerned about low-calorie soups or low-sodium soups and how does that break down by market segment (age)? Mieke: Here’s what we did: Two hundred customers were selected at random for two different interviews. We were hoping that the...

M2b: Normal Distribution Using the Z Formula Scenario Assignment Scenario Script: Caption: Princes Foods Corporation is...

M2b: Normal Distribution Using the Z Formula Scenario Assignment Scenario Script: Caption: Princes Foods Corporation is going through their annual labor negotiation with their unionized employees. Bonnie and Liwei are doing their due diligence and would like to know how a strike at Princess Foods Corporation would negatively affect the number of cans of creamed peas produced per day if the workforce is not at full capacity. Bonnie: Let’s think through the worst-case scenario: there’s a strike and we don’t...

Scenario Script Caption: Mieke has been working to tackle a difficult problem and she needs your...

Scenario Script Caption: Mieke has been working to tackle a difficult problem and she needs your help. She wants to know the most effective location for displaying Princess’ new granola bar in retail grocery stores. Mieke: Where we put our products in our grocery stores has a pretty significant impact on sales. Does the granola bar sells better in the aisles, or in promotional displays at the end of shelves or is most popular when it’s stocked in the checkout...

Scenario Script Caption: Mieke has been working to tackle a difficult problem and she needs your...

Do you think that 1-For-1 Foods has enough information to create a successful marketing strategy? If...

Do you think that 1-For-1 Foods has enough information to create a successful marketing strategy? If not, what other questions need to be answered and what research methodology should be used? What other types of research could have been used to gather the insights uncovered in the studies? Could this research have been done using tracking data and Google Analytics? Why or why not? Is a hiking trip a proper venue for ethnographic research? What about dinner at a restaurant?

After several years of profitable operations, Javell, the sole shareholder of JBD Inc., a C corporation,...

After several years of profitable operations, Javell, the sole shareholder of JBD Inc., a C corporation, sold 15 percent of her JBD stock to ZNO Inc., a C corporation in a similar industry. During the current year JBD reports $1,470,000 of after-tax income. JBD distributes all of its after-tax earnings to its two shareholders in proportion to their shareholdings. Assume ZNO’s marginal tax rate is 30 percent. How much tax will ZNO pay on the dividend it receives from JBD?...

After several years of profitable operations, Javell, the sole shareholder of JBD Inc., a C corporation,...

After several years of profitable operations, Javell, the sole shareholder of JBD Inc., a C corporation, sold 22 percent of her JBD stock to ZNO Inc., a C corporation in a similar industry. During the current year JBD reports $2,000,000 of after-tax income. JBD distributes all of its after-tax earnings to its two shareholders in proportion to their shareholdings. How much tax will ZNO pay on the dividend it receives from JBD? What is ZNO’s tax rate on the dividend...

After several years of profitable operations, Javell, the sole shareholder of JBD Inc., a C corporation,...

After several years of profitable operations, Javell, the sole shareholder of JBD Inc., a C corporation, sold 22 percent of her JBD stock to ZNO Inc., a C corporation in a similar industry. During the current year JBD reports $2,100,000 of after-tax income. JBD distributes all of its after-tax earnings to its two shareholders in proportion to their shareholdings. How much tax will ZNO pay on the dividend it receives from JBD? What is ZNO’s tax rate on the dividend...

Consolidation Eliminations Several Years after Acquisition Paramount Corporation acquired its 75 percent investment in Sun Corporation...

Consolidation Eliminations Several Years after Acquisition Paramount Corporation acquired its 75 percent investment in Sun Corporation in January 2012, for $3,492,000 and accounts for its investment internally using the complete equity method. At the acquisition date, total book value of Sun was $1,800,000 including $960,000 of retained earnings, and the estimated fair value of the 25 percent noncontrolling interest was $948,000. The fair values of Sun's assets and liabilities were equal to their carrying values, except for the following items:...

Subjects