Welcome to DU! The truly grassroots left-of-center political community where regular people, not algorithms, drive the discussions and set the standards. Join the community: Create a free account Support DU (and get rid of ads!): Become a Star Member Latest Breaking News General Discussion The DU Lounge All Forums Issue Forums Culture Forums Alliance Forums Region Forums Support Forums Help & Search

Bill USA

(6,436 posts)
4. I didn't go into details as without looking at an excel spreadsheet it's fairly involved. I
Mon Dec 30, 2013, 09:55 PM
Dec 2013

downloaded the Profit and Loss statement as an Excel SS. ( At the link you will find a tiny image indicating you can download an excel spreadsheet of the Profit and Loss statement. )

Without going into too much detail, I factored computed what the labor cost percentage (of revenues) was for McDonalds owned stores and applied that percentage to the revenues from franchised restaurants to get the labor costs of the franchised restaurants. I appied the 35% increase tothe stated labor costs for McDonald's owned stores and tothe inferred labor costs for franchised outlets. This gives you th e price increase needed to cover increased labor costs. I did some factoring to bumpup revenues to keep the profit rate the same (explaining this process is really not feasible without an excel spreadsheet to show you).

Basically its this. Labor costs are about 25% of revenues. So an increase of 35% to a fraction (25%) of revenues means the increase to revenues will be about one fourth the size of the % increase to labor costs. You have to increase somewhat more than that if you figure in profit too. I can't pull up my SS now as Google site hosting won't let me.





Latest Discussions»Issue Forums»Economy»What price increase would...»Reply #4