I need help on this assignments
i need Help
7:58 7 gta Option #2 Managerial Accounti... You decide to iste buss with the full verste teen Valley, Year in partietytut the body that it las bom. Yomerwochy que partiet Base the format you have been com wheredicated the finger for 1. Using the 2018 and 2018 Income Statement.parenteral at Cum Sie Vertikal Analysis. Using of the 2013 and 1 set Sext, prepare Comparatie Hortal Analysis Writeris describedding of the care business using these statements Comment y en dialy explain what you believe to be the read the information these worksheets in the back of the child provide for your VER NE SLIIS.000 S5600 SU SU Sales Review Food Beve Re Total Sales Re Could Sale COS leverage COS Total Cast of Sales Se 5382 S 512 $422.30 55 SES Prime Centre Exp Di Bapplies Ispons Adid Advertising and Expen Repairs and Maintenance $51405 5450 S124 355.00 SU Total Controllable Expo Controllable here Non-Cerpe Die Becupes Com Interest Total Nu Controllable Expenses Operating Income SER S YER YERS Se Suict of Balm Shot Current Art Cash Credit Card Reveivables Acce Marble Security PadEspres 53.100 SH 11 00 5672 Beverage level Total Current Current Liabilities AP Accred Expense Payable Tu Payale Cunat Mortgage Payable Total Carrer Libilities SINO 5420 5 7:58 7 219 Option #2 Managerial Accounti... 5/14 2. Conducta ali slysi ning the 2018 finish from the business and contract. What is thered from year termes de terra.care to Industry Duter les murs (Referentie Modules and starters document What is your Aayed Super come 1. Working Capital I. Current Ratie c. Ok Ratio Arte Food Court E B Control F. La Coster G. Prime Cost Percentage H. Probe Margin Page Comments Ratio 7/14 year the train will be open Desire et le fer Yetim Send 55.000 Inore Tex Rae25% ARCO Insured Lines Lepene 55,000 Repaisand 4.500 Aditive and moral - 18.00 Moment Sales - 51560 Operating Supplies Expenses, Achtsagaad on 55.000 Imeres 4.000 Variable Controjections include: Food leccos India Other Vile Costa2.5% Projected Business Die LandtFood Sales and Berge Sales -20% Projected Seaweed och Open 6deysWok Cedades per you 4. Prepare an awal Hedgyted Statement for the weather formation que es detail specialmente complet in Badgeting and niemalt pocket-USA Somade ceded format. We hope you this 5. Calculate minima chech project for him that income send the informatgesWhat are you regrejectes the strategies to address thes. What aditional racert What you recedere che sto be? Why? Tur Tues TE 2.50 Team Llewe . WE LE w H CAL M Me TE mol WC TS 15 TAR Moon L TI 1. Using the 2018 and 2019 Income Statements, prepare both a Comparative Horizontal and Common Size Vertical Analysis. Using a subset of the 2018 and 2019 Balance Sheets, prepare a Comparative Horizontal Analysis. Write a brief essay describing your understanding of the current business using these statements Comment on any significant variances. Additionally, explain what you believe to be the strengths and weaknesses of the business based on this Information. Use the worksheets in the back of this chatte complete the analysis and the space provided for your essay YE 2018 YE 2019 $995.000 S302.500 $1.297,500 $1,115,000 S351.600 $1,466,600 $352.500 595,000 $447.500 $382.560 $800,000 $345.200 S127,000 $472,200 S564,310 S1,036,510 Income Statement for Existing Restaurant Sales Revenue Food Revenge Beverage Revenue Total Sales Revenue Cost of Sales Food COS Beverage COS Total Cost of Sales Laber Expense Prime Cost Controllable Expenses Operating Supplies Expense Administrative and General Expense Advertising and Promotion Expense Repairs and Maintenance Utilities Total Controllable Expenses Controllable income Non-Controllable Expenses Depreciation Occupancy Costs Interest Expense Total Non-Controllable Expenses Operating Income $20,100 S10,200 $4,200 $2,900 $14,100 551,500 $415,940 $25,300 S11,405 $4,600 $1,650 $12.545 555,500 $374,590 S10.000 $152,000 S5,800 168,800 $248.140 S10,000 $152,000 55,200 167,200 $207,390 Subset of Balance Sheet Current Assets YE 2018 YE 2019 Cash $31,600 53.100 51 475 Credit Card Receivables Accounts Receivable Marketable Securities Prepaid Expenses Food Inventory Beverage Inventory Total Current Assets Current Liabilities Accounts Payable Accrued Expenses Payable Taxes Payable Current Mortgage Payable Total Current Liabilities $48.200 $2.740 S820 $1,200 $3,900 $6.900 $3,620 $67.450 S18,000 $5,400 $4,700 $2.960 $67.235 $10.900 $3,250 $22,200 $13,200 $49.550 $9 400 $2.100 $24.300 S11.600 547,400 2. Conduct a Ratio Analysis using the 2018 and 2019 financials from the existing business and comment on cach. What is the trend from year 2018 to year 2019? How do these ratios compare to Industry Data or Benchmarks (Reference Ratio Modules and Restaurant Benchmarks document)? What is your analysis? Any red flags or concerns? A. Working Capital B. Current Ratio C. Quick Ratio (Acid Test) D. Food Cost Percentage E. Beverage Cost Percentage F. Labor Cost Percentage G. Prime Cost Percentage H. Profit Margin Percentage 5 3. Using the Bottoms up Approach to Pricing, determine the minimum sales revenue required for the first year the business will be open. Estimates for Second Location Desired Net Income for Ist Year from Second Location = $85.000 Income Tax Rate = 25% Annual Rent (Occupancy Cost) = $60,000 Insurance and Licenses Expense= $6,000 Utilities Expense = $5,000 Repairs and Maintenance S4,500 Administrative and General Expense = $13,500 Management Salaries = $150,000 Operating Supplies Expense = $20,000 Depreciation - $11,000 Advertising and Promotion Expense $5,000 Interest Expense = $4,000 Variable Cost % Projections include: Food & Beverage COS at 33.5% and Labor at 32.5%. Include Other Variable Cost of 2.5% Seats - 100 Projected Business = 60% Dinner and 40% Lunch, Food Sales=80% and Beverage Sales=20% Projected Seat Turns = 1.6 for Dinner and 1.1 for Lunch Open 6 days a week. Closed 5 additional days per year. 4. Prepare an Annual Budgeted Income Statement for the second location (using the information from question 3.) Use as much detail as possible and a format appropriate for Managerial Accounting (from Chapter 11 Budgeting and Internal Controls packet - USAR format with vertical analysis.) Please do not use a condensed format. Write a short paragraph highlighting your three main concerns regarding this budget. 5. Calculate minimum average check projections for both meal periods based on the budgeted income statement and other information given. What concerns do you have regarding these projections? Discuss two strategies to address these concerns. What additional information should you consider? What would you recommend average check goals to be? Why? VE Sie SES Total DOS Talle Pro S. A General Svart te S. . 3.0 I. S. SI SES SR VE Telefeld HT M Hop HESS TE C C TE th 100 m + be 7:58 7 gta Option #2 Managerial Accounti... You decide to iste buss with the full verste teen Valley, Year in partietytut the body that it las bom. Yomerwochy que partiet Base the format you have been com wheredicated the finger for 1. Using the 2018 and 2018 Income Statement.parenteral at Cum Sie Vertikal Analysis. Using of the 2013 and 1 set Sext, prepare Comparatie Hortal Analysis Writeris describedding of the care business using these statements Comment y en dialy explain what you believe to be the read the information these worksheets in the back of the child provide for your VER NE SLIIS.000 S5600 SU SU Sales Review Food Beve Re Total Sales Re Could Sale COS leverage COS Total Cast of Sales Se 5382 S 512 $422.30 55 SES Prime Centre Exp Di Bapplies Ispons Adid Advertising and Expen Repairs and Maintenance $51405 5450 S124 355.00 SU Total Controllable Expo Controllable here Non-Cerpe Die Becupes Com Interest Total Nu Controllable Expenses Operating Income SER S YER YERS Se Suict of Balm Shot Current Art Cash Credit Card Reveivables Acce Marble Security PadEspres 53.100 SH 11 00 5672 Beverage level Total Current Current Liabilities AP Accred Expense Payable Tu Payale Cunat Mortgage Payable Total Carrer Libilities SINO 5420 5 7:58 7 219 Option #2 Managerial Accounti... 5/14 2. Conducta ali slysi ning the 2018 finish from the business and contract. What is thered from year termes de terra.care to Industry Duter les murs (Referentie Modules and starters document What is your Aayed Super come 1. Working Capital I. Current Ratie c. Ok Ratio Arte Food Court E B Control F. La Coster G. Prime Cost Percentage H. Probe Margin Page Comments Ratio 7/14 year the train will be open Desire et le fer Yetim Send 55.000 Inore Tex Rae25% ARCO Insured Lines Lepene 55,000 Repaisand 4.500 Aditive and moral - 18.00 Moment Sales - 51560 Operating Supplies Expenses, Achtsagaad on 55.000 Imeres 4.000 Variable Controjections include: Food leccos India Other Vile Costa2.5% Projected Business Die LandtFood Sales and Berge Sales -20% Projected Seaweed och Open 6deysWok Cedades per you 4. Prepare an awal Hedgyted Statement for the weather formation que es detail specialmente complet in Badgeting and niemalt pocket-USA Somade ceded format. We hope you this 5. Calculate minima chech project for him that income send the informatgesWhat are you regrejectes the strategies to address thes. What aditional racert What you recedere che sto be? Why? Tur Tues TE 2.50 Team Llewe . WE LE w H CAL M Me TE mol WC TS 15 TAR Moon L TI 1. Using the 2018 and 2019 Income Statements, prepare both a Comparative Horizontal and Common Size Vertical Analysis. Using a subset of the 2018 and 2019 Balance Sheets, prepare a Comparative Horizontal Analysis. Write a brief essay describing your understanding of the current business using these statements Comment on any significant variances. Additionally, explain what you believe to be the strengths and weaknesses of the business based on this Information. Use the worksheets in the back of this chatte complete the analysis and the space provided for your essay YE 2018 YE 2019 $995.000 S302.500 $1.297,500 $1,115,000 S351.600 $1,466,600 $352.500 595,000 $447.500 $382.560 $800,000 $345.200 S127,000 $472,200 S564,310 S1,036,510 Income Statement for Existing Restaurant Sales Revenue Food Revenge Beverage Revenue Total Sales Revenue Cost of Sales Food COS Beverage COS Total Cost of Sales Laber Expense Prime Cost Controllable Expenses Operating Supplies Expense Administrative and General Expense Advertising and Promotion Expense Repairs and Maintenance Utilities Total Controllable Expenses Controllable income Non-Controllable Expenses Depreciation Occupancy Costs Interest Expense Total Non-Controllable Expenses Operating Income $20,100 S10,200 $4,200 $2,900 $14,100 551,500 $415,940 $25,300 S11,405 $4,600 $1,650 $12.545 555,500 $374,590 S10.000 $152,000 S5,800 168,800 $248.140 S10,000 $152,000 55,200 167,200 $207,390 Subset of Balance Sheet Current Assets YE 2018 YE 2019 Cash $31,600 53.100 51 475 Credit Card Receivables Accounts Receivable Marketable Securities Prepaid Expenses Food Inventory Beverage Inventory Total Current Assets Current Liabilities Accounts Payable Accrued Expenses Payable Taxes Payable Current Mortgage Payable Total Current Liabilities $48.200 $2.740 S820 $1,200 $3,900 $6.900 $3,620 $67.450 S18,000 $5,400 $4,700 $2.960 $67.235 $10.900 $3,250 $22,200 $13,200 $49.550 $9 400 $2.100 $24.300 S11.600 547,400 2. Conduct a Ratio Analysis using the 2018 and 2019 financials from the existing business and comment on cach. What is the trend from year 2018 to year 2019? How do these ratios compare to Industry Data or Benchmarks (Reference Ratio Modules and Restaurant Benchmarks document)? What is your analysis? Any red flags or concerns? A. Working Capital B. Current Ratio C. Quick Ratio (Acid Test) D. Food Cost Percentage E. Beverage Cost Percentage F. Labor Cost Percentage G. Prime Cost Percentage H. Profit Margin Percentage 5 3. Using the Bottoms up Approach to Pricing, determine the minimum sales revenue required for the first year the business will be open. Estimates for Second Location Desired Net Income for Ist Year from Second Location = $85.000 Income Tax Rate = 25% Annual Rent (Occupancy Cost) = $60,000 Insurance and Licenses Expense= $6,000 Utilities Expense = $5,000 Repairs and Maintenance S4,500 Administrative and General Expense = $13,500 Management Salaries = $150,000 Operating Supplies Expense = $20,000 Depreciation - $11,000 Advertising and Promotion Expense $5,000 Interest Expense = $4,000 Variable Cost % Projections include: Food & Beverage COS at 33.5% and Labor at 32.5%. Include Other Variable Cost of 2.5% Seats - 100 Projected Business = 60% Dinner and 40% Lunch, Food Sales=80% and Beverage Sales=20% Projected Seat Turns = 1.6 for Dinner and 1.1 for Lunch Open 6 days a week. Closed 5 additional days per year. 4. Prepare an Annual Budgeted Income Statement for the second location (using the information from question 3.) Use as much detail as possible and a format appropriate for Managerial Accounting (from Chapter 11 Budgeting and Internal Controls packet - USAR format with vertical analysis.) Please do not use a condensed format. Write a short paragraph highlighting your three main concerns regarding this budget. 5. Calculate minimum average check projections for both meal periods based on the budgeted income statement and other information given. What concerns do you have regarding these projections? Discuss two strategies to address these concerns. What additional information should you consider? What would you recommend average check goals to be? Why? VE Sie SES Total DOS Talle Pro S. A General Svart te S. . 3.0 I. S. SI SES SR VE Telefeld HT M Hop HESS TE C C TE th 100 m + be
