JeanBertrandLab5_Z - $62,000 $63,000 $62,000 $63,000...

Info iconThis preview shows pages 1–6. Sign up to view the full content.

View Full Document Right Arrow Icon
Creator: Eric Zakrzewski 1 Julie Smith Bruno's Dining Analysis Creator Jean Bertrand Date Created 10/5/2011 Todays Date 10/10/2011 Purpose Present a total company sales picture for management Objective Demonstrate summary formulas and advanced charting Sheets Eastside: Eastside Sales Downtown: Downtown Sales Westside: Westside Sales Summary: Shows total company sales Summary Chart: Show Slaes Increase for Delivery Comments I think Bruno should add more stores based on sales plus this would add more locations
Background image of page 1

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full DocumentRight Arrow Icon
Eastside Location 1st Quarter 2nd Quarter 3rd Quarter 4th Quarter Total Dine-In $45,000 $41,000 $38,000 $33,000 $157,000 Pick-up $19,000 $21,000 $20,000 $20,000 $80,000 Delivery $25,000 $35,000 $45,000 $55,000 $160,000 Total $89,000 $97,000 $103,000 $108,000 $397,000
Background image of page 2
Downtown Location 1st Quarter 2nd Quarter 3rd Quarter 4th Quarter Total Dine-In $40,000 $34,000 $29,000 $22,000 $125,000 Pick-up
Background image of page 3

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full DocumentRight Arrow Icon
Background image of page 4
Background image of page 5

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full DocumentRight Arrow Icon
Background image of page 6
This is the end of the preview. Sign up to access the rest of the document.

Unformatted text preview: $62,000 $63,000 $62,000 $63,000 $250,000 Delivery $22,000 $26,000 $35,000 $42,000 $125,000 Total $124,000 $123,000 $126,000 $127,000 $500,000 Westside Location 1st Quarter 2nd Quarter 3rd Quarter 4th Quarter Total Dine-In $12,000 $10,000 $8,000 $6,000 $36,000 Pick-up $27,000 $26,000 $26,000 $26,000 $105,000 Delivery $25,000 $34,000 $46,000 $60,000 $165,000 Total $64,000 $70,000 $80,000 $92,000 $306,000 Bruno's Dining Analysis 1st Quarter 2nd Quarter 3rd Quarter 4th Quarter Total Dine-In $97,000 $85,000 $75,000 $61,000 $318,000 Pick-up $108,000 $110,000 $108,000 $109,000 $435,000 Delivery $72,000 $95,000 $126,000 $157,000 $450,000 Total $277,000 $290,000 $309,000 $327,000 $1,203,000 1 2 3 4 $0 $20,000 $40,000 $60,000 $80,000 $100,000 $120,000 $140,000 $160,000 $180,000 Major Slaes Increase in Delivery Service Axis Title...
View Full Document

Page1 / 6

JeanBertrandLab5_Z - $62,000 $63,000 $62,000 $63,000...

This preview shows document pages 1 - 6. Sign up to view the full document.

View Full Document Right Arrow Icon
Ask a homework question - tutors are online