Description
The excel sheet discussing the workings of return of investment calculation for Broadway Pizza. This is the excel sheet which supports the report "Broadway Pizza".
Investment and Cost Investment Robotic Character Kitchen Equipment Other Attractions Building Costs Research, developments, architect total Revenue
Percentage Cost (In Millions) 35% 1.09375 16% 0.5 14% 0.4375 32% 1 3% 0.09375 100% 3.125
Total Total revenue Food & beverage revenue Game revenue Cost as percentage of sales Cost of goods Labor including benefits Franchise fee to patent company Marketing and advertising Depreciation Rent Utilities Interest general & administrative Maintenance and repairs Subtotal Income before taxes
Revenue (in Millions) 100% 1.683 75% 1.26225 25% 0.42075 21% 25% 6% 5% 5% 8% 4% 5% 8% 4% 91% 9% 0.35343 0.42075 0.10098 0.08415 0.08415 0.13464 0.06732 0.08415 0.13464 0.06732 1.53153 0.15147
Return on Investment on Food Investment Cost (In Millions) Kitchen Equipment 0.5 Building Costs 0.5434 Total 1.0434 Revenue Food & beverage revenue Cost Cost of goods Labor including benefits Franchise fee to patent company Marketing and advertising Depreciation Rent Utilities Interest general & administrative Total Income before Taxes ROI Revenue (in Millions) 1.26225
0.35343 0.32819 0.07574 0.02525 0.03385 0.07316 0.03658 0.06311 0.10098 1.090278916 0.171971084 16%
Return on Investment on Games Investment Cost (In Millions) Robotic Character 1.09375 Other Attractions 0.4375 Building Costs 0.4565 Research, developments, architect 0.09375 Total 2.0815 Revenue Game revenue Cost Labor including benefits Franchise fee to patent company Marketing and advertising Depreciation Rent Utilities Interest general & administrative Maintenance and repairs Total Income before Taxes ROI Revenue (In Millions) 0.42075
0.09257 0.02525 0.05891 0.05030 0.06147 0.03073 0.02104 0.03366 0.01683 0.39074 0.03001 1%
doc_119792627.xlsx
The excel sheet discussing the workings of return of investment calculation for Broadway Pizza. This is the excel sheet which supports the report "Broadway Pizza".
Investment and Cost Investment Robotic Character Kitchen Equipment Other Attractions Building Costs Research, developments, architect total Revenue
Percentage Cost (In Millions) 35% 1.09375 16% 0.5 14% 0.4375 32% 1 3% 0.09375 100% 3.125
Total Total revenue Food & beverage revenue Game revenue Cost as percentage of sales Cost of goods Labor including benefits Franchise fee to patent company Marketing and advertising Depreciation Rent Utilities Interest general & administrative Maintenance and repairs Subtotal Income before taxes
Revenue (in Millions) 100% 1.683 75% 1.26225 25% 0.42075 21% 25% 6% 5% 5% 8% 4% 5% 8% 4% 91% 9% 0.35343 0.42075 0.10098 0.08415 0.08415 0.13464 0.06732 0.08415 0.13464 0.06732 1.53153 0.15147
Return on Investment on Food Investment Cost (In Millions) Kitchen Equipment 0.5 Building Costs 0.5434 Total 1.0434 Revenue Food & beverage revenue Cost Cost of goods Labor including benefits Franchise fee to patent company Marketing and advertising Depreciation Rent Utilities Interest general & administrative Total Income before Taxes ROI Revenue (in Millions) 1.26225
0.35343 0.32819 0.07574 0.02525 0.03385 0.07316 0.03658 0.06311 0.10098 1.090278916 0.171971084 16%
Return on Investment on Games Investment Cost (In Millions) Robotic Character 1.09375 Other Attractions 0.4375 Building Costs 0.4565 Research, developments, architect 0.09375 Total 2.0815 Revenue Game revenue Cost Labor including benefits Franchise fee to patent company Marketing and advertising Depreciation Rent Utilities Interest general & administrative Maintenance and repairs Total Income before Taxes ROI Revenue (In Millions) 0.42075
0.09257 0.02525 0.05891 0.05030 0.06147 0.03073 0.02104 0.03366 0.01683 0.39074 0.03001 1%
doc_119792627.xlsx