1. List names of all employees who are not from Department A00. 2. What is the average of all employee salaries? 3. Which employees earn more than average? 4. List names and salaries of employees earning more than $35,000. 5. Increase Ms. Haas's salary to $500,000 and then list her new monthly salary.
Answers
Please find schedule attached
Answer and Explanation:
1. Names of employees who are not from Department A00 include employees whose work department isn't A00 such as:
Michael Thompson, Sally Kwan, John Geyer, Irvin Stern etc(please refer to attachment)
2. Average of all employees salary = total employees salary /number of employees = $627415/25=$25096.6
3. There are 16 employees earning above the average salary of the employees, such as Christine Haas, Sally Kwan etc
4. There are 6 employees earning above $35000 such as Christine Haas, Michael Thompson, Sally Kwan, John Geyer etc
5. Ms. Haas currently makes $633000 yearly($52750 per month). If she makes $500000 per year then her salary per month will be $500000/12=$41666
Related Questions
An income statement for Sam's Bookstore for the first quarter of the year is presented below:Sam's BookstoreIncome StatementFor Quarter Ended March 31Sales $ 910,000Cost of goods sold 560,000Gross margin 350,000Selling and administrative expensesSelling $ 119,000Administration 142,000 261,000Net operating income $ 89,000On average, a book sells for $65. Variable selling expenses are $4 per book with the remaining selling expenses being fixed. The variable administrative expenses are 3% of sales with the remainder being fixed.The contribution margin for Sam's Bookstore for the first quarter is:____________
Insurance.Susan,a trained nurse,was recently elected to the U.S.Senate.Susan is very concerned about the lack of insurance for many children and also working adults who cannot afford the insurance premiums.She proposes legislation that states are taxed sufficiently to provide health insurance coverage to children and that federal funds for state highways are denied to any state that does not also provide insurance coverage for uninsured adults.She also proposed that states with citizens earning higher than average incomes be taxed at a higher rate than other states.Bill,a senator,tells Susan that Congress lacks the authority to tax in this manner because the U.S.Constitution expressly reserves that right to the states.Ellen,another senator,tells Susan that Congress has no authority to link highway funds or any other funds with social welfare objectives.Sam,an administrative assistant,tells Susan that Congress is prohibited from taxing residents of one state at a higher rate than citizens of another state.Which of the following is true regarding Ellen's statement? A) Ellen is correct. B) Ellen is correct only if the state is making efforts to put social programs into effect and is not acting unreasonably in refusing to provide needed services. C) Ellen is partially correct in that Congress has no authority to link highway funds with social services,but any other funds may be linked to social services by executive order. D) Ellen is partially correct in that Congress has no authority to link highway funds with social services,but other funds may be linked to social services by an act of Congress. E) Ellen is incorrect.
A furniture factory produced 1600 standard chairs in eight days. If the factory employed five workers, what was the labor productivity, in chairs per worker per day? A. 40 B. 100 C. 5O D.20 E. 80
The following transactions occur for Cardinal Music Academy during the month of October: Provide music lessons to students for $17,000 cash. Purchase prepaid insurance to protect musical equipment over the next year for $4,200 cash. Purchase musical equipment for $20,000 cash. Obtain a loan from a bank by signing a note for $30,000.Record the transactions. The company uses the following accounts: Cash, Prepaid Insurance, Equipment, Notes Payable, and Service Revenue.
Answers
Answer:
$9,236.71
Explanation:
The computation of the maturity value of the note is shown below:-
Interest Amount = ($9000 × 8%) × 120 ÷ 365
= $720 × 120 ÷ 365
= $236.71
So, the Maturity Value is
= Face value + Interest amount
= $9,000 + $236.71
= $9,236.71
Therefore for computing the maturity value we simply applied the above formula.
Answers
Answer:
Results are below.
Explanation:
Giving the following information:
Future value= $3,000
Number of periods= 15 years
I will assume an interest rate of 8% compounded annually.
To calculate the present value (PV), we need to use the following formula:
PV= FV/(1+i)^n
PV= 3,000/1.08^15
PV= $945.73
Answers
Answer:
Value of the ending inventory=$600,000
Option A is correct ($600,000)
Explanation:
Given Data:
Ending inventory=6,000 units
Direct labor per unit =$40
Direct materials per unit=$20
Variable overhead per unit =$10
Fixed overhead per unit=$30
Required:
Value of the ending inventory=?
Solution:
Value of the ending inventory=(Direct labor per unit+Direct materials per unit+Variable overhead per unit + Fixed overhead per unit)*Ending inventory
Value of the ending inventory=($40+$20+$10+$30)*6000
Value of the ending inventory=$100*6000
Value of the ending inventory=$600,000
Option A is correct ($600,000)
Final answer:
The value of the ending inventory using the absorption costing method for Guillotine Corporation is $600,000. This is calculated by adding the relevant per unit costs, which total $100 per unit, and then multiplying by the number of units in the ending inventory.
Explanation:
The absorption costing method includes both variable and fixed manufacturing costs, such as direct labor, direct materials, and both variable and fixed overhead, in the valuation of inventory.
In Guillotine Corporation's case, the costs per unit would be added together: $40 (direct labor) + $20 (direct materials) + $10 (variable overhead) + $30 (fixed overhead), which equals $100 per unit. Notice that the selling and administrative costs are not included in the valuation because absorption costing only includes manufacturing costs.
To find the value of the ending inventory, we then multiply the cost per unit ($100) with the number of units in the ending inventory (6,000 units). Therefore, 6,000 units * $100/unit = $600,000. Therefore, answer a) $600,000 is correct.
Learn more about Inventory Valuation here:
#SPJ3
Answers
Answer: preparing financial statements
& prepare papers for external auditor
Explanation:
Since Felicia worked for a retail company, there are definitely two things she would have being doing for the retail company that would be similar in the rod she wants to apply for at the insurance industry, they are;
-preparing financial statements;
-prepare papers for external auditor
these are a roles she would have definitely played at one point or the other for the retail store and are vital when working for the insurance industry
b. should be compared to a flexible budget to assess how well costs were controlled.
c. is valid for only one level of activity. represents the best way to set spending targets for managers.
d. A planning budget is prepared before the period begins and is valid for only the planned level of activity.
Answers
A static budget a planning budget is prepared before the period begins and is valid for only the planned level of activity. The answer is OPTION D.
A static budget is a type of planning budget that is prepared in advance of a specific period, such as a fiscal year or a quarter. It is based on the expected level of activity or production for that period and sets spending targets for various cost categories. However, a static budget is only valid for the planned level of activity and does not adjust for changes in actual activity levels.
To assess how well costs were controlled during the period, the static budget should be compared to the actual costs incurred. This comparison helps identify any variations or differences between planned and actual performance, which can provide valuable insights for future budgeting and cost management decisions.
In contrast, a flexible budget is a more dynamic tool that adjusts for changes in activity levels. It allows managers to see how costs should have behaved based on the actual level of activity achieved, providing a more accurate evaluation of cost control performance.
To learn more about managers, click here.
#SPJ2
Answer:
Explanation: A planning budget is prepared before the period begins and is valid for only the planned level of activity.
Answers
Answer:
Journal entries:
cash 493,574.88 debit
bonds payable 435,000.00 credit
premium on bp 58,574.88 credit
--to record issuance--
Interest expense 19743
Amortization 6357
cash 26100
--to record Dec 31st, 2020--
Interest expense 19488.72
Amortization 6611.28
cash 26100
--to record June 30th, 2021--
bonds payable 130,500.00 debit
premium on bp 13,681.98 debit
interest expense 17,400.00 debit
gain on redemption 25,081.98 credit
cash 136,500.00 credit
--to record redemption--
premium on BP 4,813.04 debit
interest expense 13,456.96 debit
cash 18,270 credit
-- to record December 31st, 2021--
Explanation:
First, we solve for the proceeds from the bonds payable:
C 26,100 (435,000 x 12% / 2)
time 8 ( 4 years x 2)
yield to maturity 0.04 ( 8% / 2)
PV $175,724.6412
Maturity 435,000.00
time 8.00
rate 0.04
PV 317,850.24
PV c $175,724.6412
PV m $317,850.2392
Total $493,574.8804
We now build the amortization schedule.
We take this value, we multiply by the interest rate and then, solve for amortization and ending carrying value.
To record the redemption:
accrued interest:
435,000 x 0.12 x 4/12 (months from June to oct) = 17,400
premium:
480,606.6 - 435,000 = 45,606.6
proportional of premium:
45,606 / 435,000 x 130,500 = 13.681,98
we now solve for the gain/loss on redemption:
130,500 + 13,681.98 + 17,400 = 161.581,9 value redeem
for cash 136,500
gain on redemption 25.081,98
bonds payable 130,500.00 debit
premium on bp 13,681.98 debit
interest expense 17,400.00 debit
gain on redemption 25,081.98 credit
cash 136,500.00 credit
Now, we solve for Dec 31st, 2021 entry.
bonds payable: 435,000 - 130,500 = 304,500
premium: 45,606 - 13,681.98 = 31.924,02
interest expense:
(304,500 + 31,924.02) x 0.04 = 13,456.96
cash outlay:
304,500 x 0.06 = 18,270
amortization 18,270 - 13,456.96 = 4,813.04