PROJECT 3 - COST-VOLUME PROFIT ANALYSIS Rotten Ronnie's Pub and Grill Rotten Ronnie's is a pub located next to the campus of S.A.I.T. and serves as a gathering place for studious Hotel and Restaurant Management students. Ronnie sells beer on tap and all brands of bottled beer Ronnie is also considering selling hamburgers (a known post secondary staple for starving SAIT students ) during selected hours. His reasons are twofold. First burgers would attract daytime customers ( a beer and a hamburger are a quick lunch) and, second he has to meet the competition from Local Lou's, The Gateway and other local bars, some of which provide more extensive menus. Ronnie analyzed the costs as follows: Beer: average contribution margin 0.74 extra beer sold per day 84 : Monthly Fixed Expenses: Wage of part-time cook 2,725 :other_. 1,540 *Variable Expenses Per Hamburger: Roll 0.15 Meat @ $6.80 per kilogram 0.85 (8 hamburgers per kilogram) Other 0.35 Ronnie planned a selling price that he believes will lure in many customers. 2.85; Days in the month 30 Hamburgers sold ( part 3 4,800 REQUIRED: What are the monthly and daily break even points in number of hamburgers ? What are the monthly and daily break even points in dollar sales ? At the end of 2 months Ronnie finds he has sold several hamburgers. What is the operating profit per month on hamburgers ? ( see above for hamburgers sold ) 4 Ronnie thinks that extra beers can be sold each day because he sells hamburgers. This means he anticipates that because of hamburgers sales he anticipates that his daily beer sales will increase as per above ( extra beer sold per day ). What effect will the additional beer sales have on monthly income ? 5 Refer to requirement 3. How many extras beers would have to be sold per day so that the overall effects of the hamburger sales on monthly operating income would be zero ?---__beim Project Number 2_ Evaluation_ __ _- - - Cost - Volume Profit Analysis Marks Marks Available Obtained The Nordic Nest: OUT OF 5.0% Professional Design and Submission 0.5 Use of Excel and Features 0.5 MARK Correct Analysis 5 0 El Cantina Restaurant: OUT OF 5.0% Professional Design and Submission 0.5 Use of Excel and Features 0.5 MARK Correct Analysis 5 0 Rotten Ronnie's Pub and Grill: OUT OF 5.0% Professional Design and Submission 0.5 Use of Excel and Features 0.5 MARK Correct Analysis 5 0 15