1 / 13

The McDonald’s Problem

The McDonald’s Problem. What are the top 10 Menu Items that gave McDonalds Katipunan the highest revenue for December, 2012? Fill up the table below. Show revenue in Philippine Currency format.

baakir
Download Presentation

The McDonald’s Problem

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript

  1. The McDonald’s Problem

  2. What are the top 10 Menu Items that gave McDonalds Katipunan the highest revenue for December, 2012? Fill up the table below. Show revenue in Philippine Currency format.

  3. Fill up the table below by showing the number of units of each food type was ordered for each day of the week. (30 pts)

  4. Fill up the table below by showing the percentage of Chicken, Burger and Breakfast quantity that are either Ala-Carte or Value Meal (i.e. what percent of chicken orders are Ala-Carte and Value Meal? (15 pts)

  5. The Call Center Case Case

  6. Tenure Problem • In 2009 AGENT HireList sheet, create a column (T) labeled "STATUS", which will indicate if the employee is still an active employee or not based on the Attrition List. If the agent has not yet resigned, status should be "ACTIVE" otherwise "INACTIVE". Do conditional formatting by filling the cell with color red for INACTIVE employees while green for ACTIVE employees. In column (U), compute for the "TENURE" for those who have resigned, if the agent is still active, tenure should be "N/A".

  7. Peg Score • Create a column (T) labeled "PEG SCORE" which will compute for the aggregate of the Elocution, Grammar, Conversation Mgt, & Interactivity scores based on the following weights. Elocution - 20%, Grammar - 20%, Conversation Management - 30%, Interactive Ability - 30%. PEG SCORE is the weighted sum of all 4 scores. Addtionally, based on the "PEG SCORE" create a column (V) which will identify the Linguistic Hire Type based on the following parameters. • PEG SCORELINGUISTIC HIRE TYPE • >3.00 EXCELLENT • 2.76 - 3.00 REGULAR • 2.39 - 2.75 MARGINAL  

  8. Age • Create a column (W) which will compute for the "AGE" of the agent upon hiring or joining IBM. In column (X) "AGE MARKET TYPE", categorize the hire based on their age on the following criteria: • AGEAGEMARKET TYPE • 18 - 25 QUARTER LIFER • 26 - 30 YOUNG PROFESSIONAL • 31 - 39 ADULT • 40 - 50 MID LIFER • >50 DIVERSITY

  9. TAT • IBM also wants to note the processing time in work hours, create a column (Y) "TAT" – Turn around Time – which will show how long a candidate was processed from application to hiring.

  10. UserName • Lastly, you are to provide each IBMer with a Network Login username following the IBM convention of combining the first letter of the first name and the whole last name (i.e. Alfredo Antone = aantone). Create the user names in column (Z) "USERNAME".

  11. Average Age

  12. No. of hires

  13. Recruitment Churn

More Related