Question: Oriole Inc. is a consulting company analyzing the pizza industry for an upcoming article. It has the following information on sales revenues: Company Product Revenue
Oriole Inc. is a consulting company analyzing the pizza industry for an upcoming article. It has the following information on sales revenues:
| Company | Product | Revenue | ||
|---|---|---|---|---|
| Sheridan Time | Pizza | $53,200 | ||
| William's Pizza | Pizza | 82,700 | ||
| Elizabeth's Pizza | Pizza | 97,600 | ||
| Maria's Pizza | Pizza | 143,800 | ||
| Sheridan Time | Wings | 44,100 | ||
| William's Pizza | Wings | 106,800 | ||
| Elizabeth's Pizza | Wings | 77,600 | ||
| Maria's Pizza | Wings | 24,100 |
Using a pivot table in Excel, determine the market share (percentage by total revenue) of each company based on product type. (Round answers to 1 decimal places, e.g. 15.2%.)
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
