please help with this problem using the excel template

Steve and Linda Hom live in Bartlesville, Oklahoma. Two years ago, they visited Thailand. Linda, a professional chef, was impressed with the cooking methods and the spices used in Thai food. Bartlesville does not have a Thai restaurant, and the Homs are contemplating opening one. Linda would supervise the cooking, and Steve would leave his current job to be the matre d'. The restaurant would serve dinner Tuesday through Saturday. Steve has noticed a restaurant for lease. The restaurant has seven tables, each of which can seat four. Tables can be moved together for a large party. Linda is planning on using each table twice each evening, and the restaurant will be open 50 weeks per year. The Homs have drawn up the following estimates: Average revenue, including beverages and desserts Average cost of food Chel's and dishwasher's salaries Rent (premises, equipment) Cleaning Clinen premises) Replacement of dishes, cutlery, glasses Utilities, advertising, telephone $ 45 15 5.100 4,000 800 300 2,300 per meal per meal per month per month per month per month per month The table is as follows. Amount Account Average revenue, including beverages and desserts Average cost of food $45 per meal $15 per meal $5,100 per month $4,000 per Chef's and dishwasher's salaries Rent premises equinment The table is as follows. Account Amount Average revenue, including beverages $45 per meal and desserts Average cost of food $15 per meal Chef's and dishwasher's salaries $5,100 per month $4,000 per Rent, premises, equipment month $800 per Cleaning, linen, premises month $300 per Replacement of dishes, cutlery, glasses month Utilities, advertising, telephone $2,300 per month 1. Requirements 1. 1. Compute the annual breakeven number of meals and sales revenue for the restaurant. 2. 2. Compute the number of meals and the amount of sales revenue needed to earn operating income of $75,600 for the year. 3. 3. How many meals must the Homs serve each night to earn their target profit of $75,600? Is this possible? Y/N, and then Why? 4. 4. What factors should the Homs consider before they make their decision as to whether to open the restaurant? (Minimum 4 factors) B C G D HOM'S THAI FOOD BREAK EVEN TEMPLATE E F AVG. REVENUE AVG. COGS PER MEAL PER MEAL PER MOS. PER MOS. PER MOS. PER MOS. PER MOS. VAR/FIXED COSTS Salaries (Chef Dishwasher) 3 Rent (premises/equipment) e Cleaning (linen/premises) 0 Replacement (dishes/utensils) 1 Utilities/Advertising/Telephone 12 3 TOTAL FIXED COSTS FOR THE MOS. 14 TOTAL FIXED COSTS FOR THE YEAR 15 16 MAXIMUM FULL CAPCITY: 17 TABLES IN RESTAURANT 18 SEATING PER TABLE 19 DAILY AVG. TURNOVER 20 DAYS OPEN PER WEEK WEEKS OPEN PER YEAR TANAUTOSED VEAD B B C D E F A 15 16 MAXIMUM FULL CAPCITY: 17 TABLES IN RESTAURANT 18 SEATING PER TABLE 19 DAILY AVG. TURNOVER 20 DAYS OPEN PER WEEK 21 WEEKS OPEN PER YEAR 22 TOTAL NIGHTS OPEN PER YEAR 23 TOTAL MEALS PER NIGHT 24 TOTALMEALS PER WEEK 25 TOTAL MEALS PER YEAR 26 27 VAR/CM INCOME STATEMENT (PER) 28 29 SALES BH-VC 34 CM 32 39 REQUIREMENT 1: S (Decimal Format) REQUIREMENT 2: Desired Targeted Op./ Income (OI) Per Yr. REQUIREMEN How many night to eam 34 BREAK EVEN UNITS FOR THE YEAR! Sheet1 Ready 137 1 X fx % of max. meals per night Number Styles B D E F G $ % (Decimal Format) A 27 VAR/CM INCOME STATEMENT (PER) 28 29 SALES 30 VC 31 = CM 32 33 REQUIREMENT 1: 34 BREAK EVEN UNITS FOR THE YEAR: REQUIREMENT 2: Desired Targeted Op. Income (Ol) Per Yr. REQUIREMENT 3: How many meals must the Homs night to earn their target profit of $ 35 BREAK EVEN $SALES FOR THE YEAR UNITS: MEALS PER NIGHT Roundur nearest meet targ since you serve a pa meal. 36 S SALES: Sheet1 Ready of max. meals per night A B G D E G 37 38 PROVE REQ. 1 RESULTS FOR YEAR: 39 BESALES 40 - BEVC 141 CM FIXED COSTS 43/BE 44 45 46 47 PROVE REQ. 2 RESULTS FOR YEAR: SALES VC CM - FIXED COSTS 01 42 49 49 50 51 Sheet1 Ready Paste Da Calibri DAA== 9 B 19 -- A. 35 General Com Chipboard $ - %) 49 O KO font Conditional Format Cel Formatting Table Styles Styles Allonnen WES 1 XL Number % of max. meals per night Format Cell Fit Select Editing Analys Dule D F G H M N 0 P Q REQUIREMENT : Desired Targeted Op. Income (OI) Per Yr. REQUIREMENTS How many meals must the Homs serve each night to earn their target profit of $75,600 REQUIREMENT : Minimum 4 Factors to consider in Decision UNITS: MEALS PER NIGHT Round up to nearest meal, to meet target profit since you cannot serve a partial meal. S SALES: Sheet1 Calibri E- Paste 32 Com 11 AA a CA Genes B IV- ======= do $ - % *** Clipboard Font Conditional format Cell Forma Table Styles Styr Delete- Format Agent Number IX J % of max. meals per night Sort Find & O. Per See ting Out AN c D F G H N UNITS: MEALS PER NIGHT Round up to nearest meal, to meet target profit since you cannot serve a partial meal S SALES: of a meals per night PROVEREO 2 RESULTS FOR YEAR SALES VC YorN IS THIS POSSIBLE???? Sheet1 100 Alignment fx % of max. meals per night Formats Cell Delete- Formatting Toble Styles Format Styles Cells Number Filter D E G H M N 0 P of max, meals per night 3 4 PROVE REQ, 2 RESULTS FOR YEAR: SALES VC =CM FIXED COSTS 01 YorNIS THIS POSSIBLE???? WHY? % of total seating per night. Result can not be fully booked Analysis and still meet the nightly minimum meals to meet the target profit Is this still possible, on avg for a new restaurant in Oklahoma 1 Sheet1