Hospital A |
Hospital B |
Hospital C |
||||
Patient days TYD: |
20,000 |
20,000 |
20,000 |
|||
Gross Dept expenses: |
$700,000 |
$700,000 |
$700,000 |
|||
YTD Food Cost |
YTD Sales & Charges |
YTD Food Cost |
YTD Sales & Charges |
YTD Food Cost |
YTD Sales & Charges |
|
Floor stock, nourishments |
$15,000 |
$0.00 |
$15,000 |
$15,000 |
$15,000 |
$15,000 |
Internal catering |
$30,000 |
$0.00 |
$30,000 |
$30,000 |
$30,000 |
$75,000 |
Catering cash |
$10,000 |
$ 25,000 |
$10,000 |
$ 25,000 |
$10,000 |
$ 25,000 |
Cafeteria cash |
$68,000 |
$150,000 |
$68,000 |
$150,000 |
$68,000 |
$150,000 |
Vending cash |
$10,000 |
$ 20,000 |
$10,000 |
$ 20,000 |
$10,000 |
$ 20,000 |
Note: YTD = Year-to-Date
4. Based on the total gross department expenses at the
hospitals, total food cost represents ___ % of expenses.
Hospital A = total food cost / gross department expenses * 100
1,33,000/7,00,000 * 100 = 19%
Hospital B = total food cost / gross department expenses * 100
1,33,000/ 7,00,000 * 100 = 19%
Hospital C = total food cost / gross department expenses * 100
1,33,000/ 7,00,000 * 100 = 19%
total food cost of all hospitals= 1,33,000+ 1,33,000+1,33,000 = 3,99,000
gross departments expenses of all hospital = 7,00,000+7,00,000+ 7,00,000= 21,00,000
% of total food cost in total gross expenses = total food cost / gross departments expenses * 100
= 3,99,000/21,00,000 * 100 = 19%
Ans total food cost represent 19% of the expenses
Hospital A Hospital B Hospital C Patient days TYD: 20,000 20,000 20,000 Gross Dept expenses: $700,000...
Hospital A Hospital B Hospital C Patient days TYD: 20,000 20,000 20,000 Gross Dept expenses: $700,000 $700,000 $700,000 YTD Food Cost YTD Sales & Charges YTD Food Cost YTD Sales & Charges YTD Food Cost YTD Sales & Charges Floor stock, nourishments $15,000 $0.00 $15,000 $15,000 $15,000 $15,000 Internal catering $30,000 $0.00 $30,000 $30,000 $30,000 $75,000 Catering cash $10,000 $ 25,000 $10,000 $ 25,000 $10,000 $ 25,000 Cafeteria cash $68,000 $150,000 $68,000 $150,000 $68,000 $150,000 Vending cash $10,000 $ 20,000...
Hospital A Hospital B Hospital C Patient days TYD: 20,000 20,000 20,000 Gross Dept expenses: $700,000 $700,000 $700,000 YTD Food Cost YTD Sales & Charges YTD Food Cost YTD Sales & Charges YTD Food Cost YTD Sales & Charges Floor stock, nourishments $15,000 $0.00 $15,000 $15,000 $15,000 $15,000 Internal catering $30,000 $0.00 $30,000 $30,000 $30,000 $75,000 Catering cash $10,000 $ 25,000 $10,000 $ 25,000 $10,000 $ 25,000 Cafeteria cash $68,000 $150,000 $68,000 $150,000 $68,000 $150,000 Vending cash $10,000 $ 20,000...
Case B $ 20,000 Case A $ 10,000 90,000 100,000 70,000 Case C $ 15,000 30,000 85,000 95,000 100,000 Beginning inventory, raw material Ending inventory, raw material Purchases of raw material Direct material Direct labor Manufacturing overhead Total manufacturing costs Beginning inventory, work in process Ending inventory, work in process Cost of goods manufactured Beginning inventory, finished goods Cost of goods available for sale Ending inventory, finished goods Cost of goods sold 125,000 160,000 340,000 250,000 520,000 35,000 345,000 20,000...
Return on Assets Net Sales Gross Profit Margin Cost of Goods Operating Net Profit Before Tax PI Expense Accounts Receivable Return On Assets + Merchandise Inventory Total Current Assets Asset Turnover Cash Total Assets Fixed Assets Other Current Assets Use the charts on the following page to calculate Net Profit Margin % for each scenario: Scenario 1 Scenario 2 Income Statement Income Statement Sales Sales Gross Sales $200,000 Gross Sales $100,000 Promotional Allowances $25,000 Promotional Allowances $15,000 Customer Returns -$15,000...
Using the income statements and changes in balance sheet accounts provided for Firms A and B, you will need to provide the following information: (c) Summary analysis of the statements of cash flows for Firms A and B (see Exhibit 4.6 on page 181 of your textbook): 1. Total inflows for Firm A 2. Total outflows for Firm A 3. Total inflows for Firm B 4. Total outflows for Firm B Income statement for year ended December 31,2015 Firm A...
Given: Builtrite had sales of $700,000 and COGS of $280,000. In addition, operating expenses were calculated at 25% of sales. Builtrite also received dividends of $40,000 and paid out common stock dividends of $25,000 to its stockholders. A long-term capital gain of $55,000 was realized during the year along with a capital loss of $70,000 1.What is Builtrite’s taxable income? 2.Based on their taxable income, what is Builtrite’s tax liability 3. If we add to our problem that Builtrite also...
Builtrite had sales of $700,000 and COGS of $280,000. In addition, operating expenses were calculated at 25% of sales. Builtrite also received dividends of $50,000 and paid out common stock dividends of $25,000 to its stockholders. A long-term capital gain of $70,000 was realized during the year along with a capital loss of $50,000 Based on the above information answer questions 3 and 4 I think I got 1 and 2 correct. Question 1 2 pts What is Builtrite's taxable...
Builtrite had sales of $700,000 and COGS of $290,000. In addition, operating expenses were calculated at 25% of sales. Interest expense was based on $100,000 of bonds outstanding with an interest rate of 7%. Builtrite also received dividends of $40,000 and paid out common stock dividends of $25,000 to its stockholders. A long-term capital gain of $55,000 was realized during the year along with a capital loss of $45,000 Based on the above information, answer the following 4 questions: 1....
Answers? 15 Points (2 pages) PROBLEM Based upon the comparative she prepare its Statement of and the additional inforatve balance sheets, the income stat and the additional information Cash Filows using the pration for Sales Co. prepare its Statement of Cash Flows using the Direct M Method Comparative Balance Sheets 1, 2018 and 2017 2018 2017 Change cember Balance Sheets Assets Cash Accounts receivable Inventory Prepaid Insurance Land Equipment Less: Accum Deprec 43,000 28,000 ↑15,000 33,000 30,000 T 3,000 46,000...
How do I calculate the Operating Expenses on Cash Flow Statement? METRO MEATS LTD P&L statement for 2015 METRO MEATS LTD Statement of Financial Position as at 31 December Sales revenue 250,000 Cost of sales 2015 2014 Assets 210,000 Cash Accounts receivable Gross profit 29,000 $ 15,000 40,000 28,000 14,000 Less: Inventories Selling expenses 18,000 25,000 35,000 Property, plant & equipment Accumulated depreciation Administrative expenses 6,000 60,000 78,000 (20,000) 122,000 $ (24,000) 2,000 Interest Total Income taxes 4,000 118,000 30,000...