Assets and Liabilities: Phlebotomy Lab Using the spreadsheet, you began in in Assignment 1, you will now consider additional items. Part 1 In the 5-physican practice for which you are the practice manager, you know the following facts: Each physician sees an average of 25 patients per day. Each physician is paid $250,000 annually. There are 4 medical assistants, a PA, and 2 nurses on staff. Medical assistants are paid $15/hr. nurses are paid $40/hr., and the PA has a salary of $95,000 annually. Using the Asset and Liability spreadsheet that you created you will do the following: 1) ADD any additional items to the sheet that you feel must be considered, such as labor costs and salaries, property taxes, utilities, and additional equipment. 2) ASSIGN a dollar value to the items as appropriate. 3) ADD columns to your spreadsheet to indicate FIXED and VARIABLE. Determine if the associated cost of the items on the spreadsheet are considered a fixed or variable cost. This can be done simply by marking an X in the appropriate column or you can color code your spreadsheet. For example, Fixed cost items might be coded blue and variable cost items might be coded red. 1:39 PM Sat Sep 25 7 Assets and Liabilities Draw Formulas Data Home Insert Review View Q Calibri (Body) 11 B 1 u abe 10 2 fx B D E F M N $ $ S S $ 7,000.00 16,500.00 2,000.00 5,000.00 30,500.00 G H Shihady Highway Medical Balance Sheet 1-Sep-21 Liabilities Current Liabilities Unearned Revenue Accounts Payable Long Term Liabilities: Notes Payable Mortage Total Liabilities S $ $ $ $ 3,650.00 11,000.00 14,650.00 37,000.00 5,000.00 2 3 4 Assets 5 Current Assets: G Cash 7 Accounts Receivable 8 Pre-paid 9 Inventory 10 Total Current Assets 11 Fixed Assets: 12 Building 5 75,000.00 13 Medical Supplies $ 11,231.07 14. Equipment $ 29,850.00 15 LESS: Accumulated Depreciation 16 Total Fixed Assets 17 Total Assets 18 19 20 21 22 23 24 25 $ $ $ 63,768.93 45,150.00 75,650.00 Owner's Equity Retained Earnings s Owner's Capital Account Contr. $ Total Owner's Equity $ Total Liabilities & Owner's Equi $ 17,000.00 7,000.00 24,000.00 75,650.00 Sheet1 + Assets and Liabilities: Phlebotomy Lab Using the spreadsheet, you began in in Assignment 1, you will now consider additional items. Part 1 In the 5-physican practice for which you are the practice manager, you know the following facts: Each physician sees an average of 25 patients per day. Each physician is paid $250,000 annually. There are 4 medical assistants, a PA, and 2 nurses on staff. Medical assistants are paid $15/hr. nurses are paid $40/hr., and the PA has a salary of $95,000 annually. Using the Asset and Liability spreadsheet that you created you will do the following: 1) ADD any additional items to the sheet that you feel must be considered, such as labor costs and salaries, property taxes, utilities, and additional equipment. 2) ASSIGN a dollar value to the items as appropriate. 3) ADD columns to your spreadsheet to indicate FIXED and VARIABLE. Determine if the associated cost of the items on the spreadsheet are considered a fixed or variable cost. This can be done simply by marking an X in the appropriate column or you can color code your spreadsheet. For example, Fixed cost items might be coded blue and variable cost items might be coded red