Answered step by step
Verified Expert Solution
Question
1 Approved Answer
I really just need help with how to put together a statement of cash flows after getting ur income and balance sheet together A. (40
I really just need help with how to put together a statement of cash flows after getting ur income and balance sheet together
A. (40 Points) Based on the following information and the balance sheet information from Section B. create a monthly common size and comparative income statement for December, 2020 for the Blue and White Restaurant. Beverage Revenue Sales Controllare Dec 2020 Dec, 2019 Sales Food Revenue $135,000 $123,200 $49,000 $42,500 Food Purchases Costs $38,000 $34,000 Beverage Purchases Costs $16.900 $12,800 Salaries/Wages $39,500 $35,000 Payroll Taxes $4,400 $4,000 Benefits (Excl. Meals) $ 6,500 $ 6,000 Paper Supplies Purchases Costs $3,500 $ 4,650 Utilities $ 5,500 $ 5,000 Linen $ 1,100 $1,000 Music/Entertainment $ 750 $ 800 Repairs/Maintenance $ 2,050 $ 1,975 - Marketing $ 5,000 $4,500 Rent $ 8,500 $ 8,000 Interest $ 4,500 $ 4,500 Depreciation $ 4,000 $ 3,900 Other information: December 20 - The bar transferred $500 worth of cooking wine to the kitchen and employee meals - 91,50 C1, 500) December 19 - The kitchen transferred $200 in lemon/imes to the bar and employee meals = $1,350 for the Transfer to to month 500 Insurance expense for both years is the adjusting entry from the balance sheet information provided No decimals or cents in the Revenue and Expense Columns and %'s of Sales should be one decimal point (22.2% for example). Failure to comply will result in a 5 point reduction for either requirement. At the bottom of Exhibit A, explain whether or not either, none or both of Industry Rules" have been met by the management team of Blue and White Restaurant (Base your analysis using Controllable Earnings). Explain the specific expenses as to the reasons why the restaurant either met the rules or they didn't. Gross profit profit= Sales total cost of sales B. (20 Points) Using the following information, prepare balance sheets for the Restaurant for both December and November of 2020. Once again, use the format uploaded Canvas. Make sure Assets -Liabilities Owner's Equity (in other words, the financial statement has to balance, as the name implies) Blue and White Restaurant is set up as a corporation Dec 20 Nov 20 Cash 5 12,300 58,300 Accounts Receivable $ 6.500 53,000 Food Inventory 5 11,000 $14,000 Beverage Inventory $ 6,000 5 5,600 Paper Inventory S 1000 5 2.300 Prepaid Insurance $ 1.500 $ 3.500 Prop. Plant, and Equip-Net of Depreciation $760,200 5736,200 Accounts Payable $ 35.000 534,000 Acerued Wages Payable $ 3,000 56.000 Current Portion - LTD S 8.000 $6,000 Long-Term Debt 5202,000 5163,000 Common Stock 5375,000 5375.000 Retained Earnings $175,500 SIK,900 The following balance sheet information is provided for December 2019 and November 2019 and is used for calculating certain expenses for December 2019: Dec 19 Nov 19 Food Loventory Beverage leventory Paper Inventory Prepaid Insurance $15.500 5.000 2.300 2.500 516,500 6,000 1.300 C (40 Points) Using the income statement and balance sheets that you have created, complete Statement of Cash Flows for December 2020. You must provide three comments related to the Income Statement and Statement of Cash Flow explaining how the restaurant performed in December 20202 Some dice: Check spelling Use proper format For percentages use one decimal Dollar amounts contain no Cents Handing in similar work will be handled as academic dishonesty resulting in academic sanctions up to failure of the course Your work should be of a quality ther you would hand into your boss. 2 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