La Cocina data_BB(1)

.xlsx

School

University of Southern Indiana *

*We aren’t endorsed by this school

Course

611

Subject

Business

Date

Jul 3, 2024

Type

xlsx

Pages

5

Uploaded by CountWillpowerVulture20

Table 1 - Demographics of Martin Population Males 6,835 Females 7,165 Median Resident Age 39.7 years Population Change Since 2000 8.4% increase Estimated Median Household Income $ 32,008 Estimated Median House Value $ 56,473 Race White 66% African American 28% Hispanic 3% American Indian 1% Asian 1% Native Hawaiian 1% Table 2 - Restaurant Comparisons Location Restaurant Type Sales Los Portales - Clarksburg Sit-Down $ 91,499 La Hacienda - Georgetown Sit-Down $ 172,450 Los Bravos - Trenton Sit-Down $ 289,188 La Cocina - Mayfield Sit-Down $ 207,351 El Charro - Dresden Sit-Down $ 264,354 La Cabana - Bayou De Chen Sit-Down $ 86,000 Los Portales - Newberry Sit-Down $ 120,354 La Hacienda - Franklin Sit-Down $ 175,351 Los Bravos - Gossett Sit-Down $ 266,464 La Cocina - Saline Sit-Down $ 230,654 El Charro - Cairo Sit-Down $ 286,984 La Cabana - Vinyard Sit-Down $ 199,645 Taco Bell - Jackson Fast Food $ 350,000 Taco Bell - Medina Fast Food $ 265,424 Taco Bell - Milan Fast Food $ 244,564 Taco Bell - Trezevant Fast Food $ 230,654 Taco Bell - Autumn Fast Food $ 345,245 Taco Bell - Alamo Fast Food $ 146,000 Table 3 - Breakdown of Dishes Sold at Trenton Item Number Sold Avg. Price Per Item Nachos 20354 $ 6.00 Burritos 16152 $ 7.00 Specialty Plates 6,000 $ 9.00
Table 4 Item Amount Fixed Costs (Yearly) -Rent $ 60,000 -Insurance Premiums $ 3,500 -Advertising $ 5,000 -Licenses, Legal, and Accounting Fees $ 1,200 -Utilities $ 6,000 -Loan Payments $ 11,200 -Working Capital $ 5,000 -Employees $ 30,000 $ 121,900 Price Per Item Breakeven Nachos $ 6.00 Qty Burritos $ 7.00 Sales Variable Cost Per Item Nachos $ 2.35 Burritos $ 2.45 Cont Margin %age of sales Nachos $ 3.65 42.23% Burritos $ 4.55 39.10% WACM $ 3.32 WAP $ 5.27 Table 5 - Start-Up Costs (One Time Expenses) -Equipment & Supplies 50000 -Furniture and Fixtures 15000 -Signage 2000 Table 6 Minutes Required (per Unit) Function Nachos Burritos Cooking 4 3 Assembling 2 4 Profit Per item $ 3.65 $ 4.55
s Town Pop. Direct Competitors 8,000 2 24,000 6 15,000 3 50,000 10 42,000 8 4,000 1 12,000 3 36,000 4 64,000 6 61,000 7 13,000 4 16,000 5 150,000 31 12,000 14 10,000 9 8,000 5 124,000 26 5,000 4 Revenue $ 122,124.00 $ 113,064.00 $ 54,000.00 $ 289,188.00
Your preview ends here
Eager to read complete document? Join bartleby learn and gain access to the full version
  • Access to all documents
  • Unlimited textbook solutions
  • 24/7 expert homework help