1.Create a spreadsheetcalled BA370 Spreadsheet Assignment. xlsxthat shows the names of the 10 employees in each department, their current salary, the difference between their current salary and the industry average salary for their department, and the percent their salary would need to be increased to meet the industry average. 2.In yourspreadsheet, compute the average increase needed to meet the industry average for each department and the average increase, company-wide, to meet industry averages.3.How can you use this analysis to contribute to the employee salary decision

Auniversity spent $1.8 million to install solar panels atop a parking garage. these panels will have a capacity of 400 kilowatts (kw) and have a life expectancy of 20 years. suppose that the discount rate is 20%, that electricity can be purchased at $0.10 per kilowatt-hour (kwh), and that the marginal cost of electricity production using the solar panels is zero. hint: it may be easier to think of the present value of operating the solar panels for 1 hour per year first. approximately how many hours per year will the solar panels need to operate to enable this project to break even? a. a.3,696.48 b.14,785.92 c.9,241.20 if the solar panels can operate only for 8,317 hours a year at maximum, the project (would/would not)break even?

Which of the following statements is true? a job costing system will have a separate work in process account for each of the major processes. a process costing system will have a single work in process account. a process costing system will have a separate raw materials account for each of the major processes. a process costing system will have a separate work in process account for each of the major processes.

Which of the following statements is correct? a. two firms with identical sales and operating costs but with different amounts of debt and tax rates will have different operating incomes by definition. b. free cash flow (fcf) is, essentially, the cash flow that is available for interest and dividends after the company has made the investments in current and fixed assets that are necessary to sustain ongoing operations. c. retained earnings as reported on the balance sheet represent cash and, therefore, are available to distribute to stockholders as dividends or any other required cash payments to creditors and suppliers. d. if a firm is reporting its income in accordance with generally accepted accounting principles, then its net income as reported on the income statement should be equal to its free cash flow. e. after-tax operating income is calculated as ebit(1 - t) + depreciation.