This website contains fictional production data for the equally fictional Phramous Widget Corporation, physician comparisons for the corporation's employees-only HMO, and application data for the philanthropic foundation. The bottom spreadsheet presents the Phramous mission statement.
| Phramous Widget Production Data | ||||||||||
| 1996-1997 | Production Year | |||||||||
| Total monthly production, units per product line | ||||||||||
| Month | Widget 01 | Old Widge | MiniWidge | Recycle W | WokWidg | WidgLite | Totals | Workforce | Temperature | |
| July | 23 | 17 | 31 | 15 | 9 | 25 | 120 | 25 | 85 | |
| August | 19 | 9 | 35 | 10 | 11 | 25 | 109 | 25 | 88 | |
| September | 47 | 21 | 42 | 0 | 8 | 25 | 143 | 28 | 76 | |
| October | 52 | 18 | 49 | 0 | 5 | 25 | 149 | 27 | 68 | |
| November | 29 | 14 | 56 | 0 | 6 | 25 | 130 | 25 | 65 | |
| December | 38 | 13 | 71 | 0 | 6 | 25 | 153 | 27 | 65 | |
| January | 51 | 15 | 89 | 0 | 4 | 25 | 184 | 27 | 65 | |
| February | 47 | 12 | 112 | 0 | 8 | 25 | 204 | 29 | 65 | |
| March | 45 | 9 | 134 | 0 | 5 | 25 | 218 | 30 | 68 | |
| April | 49 | 7 | 167 | 0 | 2 | 25 | 250 | 35 | 69 | |
| May | 51 | 8 | 195 | 0 | 3 | 25 | 282 | 40 | 72 | |
| June (est) | 50 | 8 | 240 | 0 | 5 | 25 | 328 | 45 | 80 | |
| Totals |
| Phramous's PHMO | |||
| "Better health means better business" | |||
| Physicians' overage reports, most recent month | |||
| Overage = Surgery cost - reimbursement | |||
| Patient | Dr. Ruth | Dr. Sally | |
| 1 | $125 | $695 | |
| 2 | $106 | $49 | |
| 3 | $127 | $51 | |
| 4 | $140 | $52 | |
| 5 | $98 | $49 | |
| 6 | $89 | $50 | |
| 7 | $150 | $47 | |
| 8 | $112 | $52 | |
| 9 | $97 | $48 | |
| 10 | $100 | $51 |
| Phramous Philanthropy Phoundation | ||||||
| "We're here to help you...won't you help us?" | ||||||
| Geographic Area | Application Amount | Number of applications | ||||
| Northeast | $160,000 | 4 | ||||
| Southeast | $180,000 | 9 | ||||
| Midwest | $340,000 | 20 | ||||
| Deep South | $190,000 | 10 | ||||
| West Coast | $250,000 | 25 | ||||
| Phramous Widget Corporation | ||||||||
| Widget Manufacturing since 1893 | ||||||||
| Supplying local, domestic and international markets | ||||||||
| Our Vision: To be the world leader in producing the highest quality widgets at the lowest possible | ||||||||
| price consistent with a fair return for our investors and comfortable lifestyles for our employees, or | ||||||||
| at least, to be second best in two out of three years. | ||||||||
| Index: | Worksheet # | |||||||
| Phramous Widget Production Data | 2 | |||||||
| Phramous Philanthropy Phoundation | 4 | |||||||
| Phramous PHMO | 6 | |||||||
Last Updated on 7/21/98
By Paul Young
Email: pyoung@houghton.edu