Answered step by step
Verified Expert Solution
Question
1 Approved Answer
Page No. Sales Food Merchandise Catering Delivery $ 412,453 12:577. $ 328,125 10.002. $984,375 30-002 $557,813 17.002 $ 998,540 30-432 $3281350100.00% Beverage Total sales Cast
Page No. Sales Food Merchandise Catering Delivery $ 412,453 12:577. $ 328,125 10.002. $984,375 30-002 $557,813 17.002 $ 998,540 30-432 $3281350100.00% Beverage Total sales Cast of sales Food $1094297 33 35% Merchandise $ 393,750 12-001 Catering $ 721,875 22-007 Relieery $557812 17-001 Beverage $787 500 24.002 Total Cost Sales $3555234 108-357 GLOSS Profit (273984) (8.35% controllable Expenses Payrou Fired $459375 14.00% Payrou- Variable | $525000 26.00% Employee Benefits $147656 4.502 Direct Operating Expenses $ 180,469 5-50% Music & Entertynment $41016 1.25% Advertising & Promcotion $82031 2-502 $106640 3.25% Administration & General $82031 2.50% Repair & Maintenance $36094 1.10% Jotal Controllable Esipenses 1660312 50-60%. Income before Occupation costs (1934:29) Utilities Date : Page No. 4.827 2.90%. 2.19% other lan Occupational costs Rent $ 158,000 Property Tax $ 95,000 $72,000 Property Insurance $ 195,000 5-942 Interest depreciation $150.000 4.57% Total Occupational costs 887500 27.057. Restaurant Profit Bofor Income 2,821,796 86.00% Janes $217,500 6.62% 1. Based on the following information, generate an income statement for the entire year: a. Seats: 250 b. Ave Check: $12.50 C. TO: 3.0 d. Catering Sales: 30% of food sales e. Merchandise sales: 10% of food sales f. Occ. %: 82% g. Popularity %: 78% h. Days Open: 350 i. Delivery sales: 17% of food sales j. Beverage sales: $998,540 k. Costs of Sales Percentages: 1. Food: 33.35% 2. Beverage: 24% 3. Merchandise: 12% 4. Catering: 22% 5. Delivery: 17% 1. Fixed Payroll: 14% m. Variable payroll: 16% n. Employee Benefits: 4.50% 0. Direct Op. Exp.: 5.50% p. Music: 1.25% q. Advertising: 2.50% r. Utilities: 3.25% S. Administrative: 2.50% t. Repairs and Main.: 1.10% u. Rent: $ 158,000 V. Interest: $217,500 W. Insurance: $195,000 X. Depreciation: $150,000 y. Property Tax: $95,000 Z. Other Tax: $72,000 Based on your income statement, identify the profit dollar and percentage for the operation
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started