Name gender  department  data joined  salary  andy gomez  male marketing  16-Oct-19                           50,000.00 lito cruz  male  R&D 03-Mar-10                           28,000.00 michelle sy  female  accounting  05-Sep-18                           65,000.00 luis cortez  male  operations  18-Dec-19                           70,500.00 sheila co  female  purchasing  04-Sep-19                           62,000.00 pamela dy  female  operations  04-May-19                           35,000.00 sarah moral  female  marketing  08-Nov-20                           80,100.00 patrick ong  male operations  12-Aug-18                           39,000.00 claire hong  female  purchasing  30-Jul-18                           42,700.00 jayson medina  male operations  19-Oct-18                           44,700.00   Given the employees of medium-sized semi-conductor firm, find the employee joined november 8, 2020 using "index" and "match function in excel. Please show the solution.    Please answer immediately thank you :)

Q: Metaverse has become one of the most noticed innovations by leaders who consider themselves capable ...

A: The Metaverse is a type of virtual assistance. Innovative technology that is implemented into the bu...

Q: 8.Determine when each of the following must deposit its Form 941 tax liabilities. Quikstep, a month...

A: 1.Quikstep, a monthly depositor, pays employees on Friday. Its 941 tax liability for the April 17, 2...

Q: Martinez Corporation had January 1 and December 31 balances as follows. 1/1/20 12/...

A: Opening inventory = $94000 Closing inventory = $108,000 COGS = $440,000 Purchases = Closing balance+...

Q: Non-market based performance conditions include vesting based on achieving all of the following exce...

A: Solution Note : dear student as per the Q&A guideline we are required to answer the first questi...

Q: 14. Red Hot Chili Peppers Co. had the following activity in its most recent year of operations. ...

A: Cash Flow Activities - 1. Operating Activities - This activity starts with Net Income in the operati...

Q: The Products 4U Inc. manufactures and sells one product which has the following available informatio...

A: Lets understand the basics. Break even point is a point at which no profit/no loss situation is aris...

Q: Frank has 200 shares of XYZ, Inc. with a basis of $5,000 and a value of 7,500. He receives a tax-fre...

A: Dividend- A dividend is an allocation of profits by a company to its shareholders. When a company ea...

Q: In 2020, Flounder Corporation had net cash provided by operating activities of $505,000, net cash us...

A: Opening cash balance (OB) = $325,000 Change in cash balance due to operating activity (OA) = $505,00...

Q: A company's 2019 income statement reported total sales revenue of $1,200,000; accounts receivable in...

A: Cash collected during the year is dependent upon the unearned revenue as well as increase or decreas...

Q: Can a updated check be an negotiable instrument

A: Negotiable instrument refers to the instrument which guarantee the payment of particular amount that...

Q: A company's normal selling price for Its product is $30 per unit. However, due to market competition...

A: As per lower of cost or market concept, the inventory is reported at lower of cost or net realizable...

Q: On February 3, Smart Company sold merchandise in the amount of $2,400 to Truman Company, with credit...

A: Journal entries are used to keep financial transactions organized. You enter transaction data into y...

Q: hich States have the highest State Level Estate Tax? Give me the top 5 in a Table format [State, Exe...

A: solution Concept Estate tax are the amount of taxes levied on estate of deceased person  

Q: Given the following costs incurred in a recent period: Direct materials - P33,000 Depreciation on fa...

A: Product cost refers to the costs incurred that are related to the factory> Expenses incurred in m...

Q: acos and Joseph are partners with capital balances of P1,600,000 and P2,400,000 respectively. They s...

A: LET'S UNDERSTAND THE BASICS Partnership is the the agreement between two or more partner to manage a...

Q: SportsWorld purchased property for $100,000. The property included a building, parking lot, and land...

A: As posted multiple independent questions we are answering only first question kindly repost the unan...

Q: he period, Sanchez Company sold some excess equipment at a loss. The following information wa y's ac...

A: Equipment is a fixed asset as considered as an investment for a Company . When it is purchased or so...

Q: Miracles Manufacturing Co. manufactures a lifting equipment. One order from Heaven Company for 3,000...

A: Generally there will be some portion of defective units in regular production. These defective units...

Q: Financial information is presented below: Operating expenses $ 42,000 Sales returns and allowances 1...

A: The income statement represents the net income or net loss that is calculated by deducting the expen...

Q: What is the AFTER-TAX MONTHLY INCOME for the SALES position?

A: Gross income is the income which an employee earns during the year or month and on which there has n...

Q: The preclosing trial balance for the City of Hudson Golf Course Enterprise Fund is shown below. CITY...

A: Restricted net position represents by restricted assets less liabilities and deferred inflows of res...

Q: Zoum Corporation had the following transactions during 2021: 1. Issued $125,000 of par value common ...

A: Zoum Corporation  Statement of Cash Flows (Partial) Cash Flow from Investing activities       ...

Q: What would be the availability of an asset if its failure rate is 0.0001failures/hour and average re...

A: The proportion of time that an asset may be used is measured by availability. It evaluates the likel...

Q: The Sino-Fizer Company is concerned about the cash flow of the company. They consulfed you to prepar...

A: Cash Budget The preparation of cash budget is important for the business which can make the evaluati...

Q: Slow Running Shoes uses the Aging of receivables method to account for uncollectible accounts. o The...

A: calculation of amount charged to collectible expenses as well as preparation of above necessary stat...

Q: If an investor wants to earn an annual interest rate of 10.76% on a 26 week T-bill with a maturity v...

A:   Interest means the extra amount which we received because of investment made and will be paid in c...

Q: Manuel and Marcus are partners with the following capital balances as at June 30, 20xx with their re...

A: Solution Partnership consists two or more people combine their resources to form a business and agre...

Q: Inventories: • Beginning - raw material_P50,000 - work in process_P40,000 - finished goods_P60,000 E...

A: Cost of goods manufactured is the total amount of cost incurred on manufacturing of goods. We are gi...

Q: Which of the following reclassifications of financial assets is permitted under PFRS 9? a. reclassif...

A: A financial asset is a liquid asset whose value is derived on a contractual right or ownership claim...

Q: Describe how the income statement in that industry integrates with the other financial statements.

A: Financial statements reflect the performance and the financial position of the company for a given p...

Q: Sarasota Corporation had the following 2020 income statement. Sales revenue   $183,000 Cost of go...

A: The Statement of cash flow can be prepared under two methods. It is Direct Method and Indirect Metho...

Q: The following lots of Commodity Z were available for sale during the year. Beginning inventory 10 un...

A: Let's understand the basics  Inventories are showed as cost or net realizable value  there are many ...

Q: Agrico Inc. accepted a 10-month, 13% (annual rate), $5,350 note from one of its customers on May 15,...

A: Face value of note = $5,350 Interest Rate = 13% Period (May 15, 2019 to December 31, 2019) = 7.5 mon...

Q: Condensed financial data of Sheffield Company for 2020 and 2019 are presented below. SHEFFIELD COM...

A: Cash flow statement represents the cash inflow and cash outflow of the company due to the operating,...

Q: d. (Optional) Prepare a system Mowchart of a rode- signed computer- based system that resolve

A: Internal Control Weaknesses:   Internal control weaknesses can be defined as the lack of standards i...

Q: Grandparents deposited $6,000 into a grandchild’s account toward a college education. How much money...

A: Compound interest is the interest on a loan or deposit calculated based on the initial principal and...

Q: On 17 January 2021, SA Traders, a debtor of Africa Traders, did a direct deposit payment of R11 0 Tr...

A: JF termed as Journal entries reporting of the transactions into the day book of the business and it ...

Q: Mr. Wade was just promoted to Dean and will earn a yearly salary of $271,828.08 evenly distributed w...

A: Monthly Salary = Yearly Salary12 months Social Security Taxes = Monthly Salary x 6.2% (Employee's Co...

Q: The Baldwin Company, originally established 16 years ago to make footballs, is now a leading produce...

A: Income statement: It is a financial statement that calculates the net income generated by a company ...

Q: On January 1,2019, an entity granted 15,000 share options to its employees. The share options will v...

A: Number of employees    Employees entitled to share options 15,000 FV (15000  * 60)  = 900,000 ( 3yea...

Q: A company produces products type: A, B and C in three separate departments (production hall). Produc...

A: Segment Reporting- When a business has a lot of different operating segments, segment reporting is u...

Q: Q1)Fuzzy Monkey Technologies purchased as a long-term investment $80 million of 8% quoted bonds, dat...

A: Given information, Investment in bond=$80 million Cash paid=$66 million     1.Journal entry to recor...

Q: 3. Vaughn Corporation had the following activities in 2020. 1.   Payment of accounts payable $832...

A: Cash flow statement depicts the total cash flows (inflows and outflows) for a given period. It also ...

Q: If an accounting manager asks you to delay recording an invoice for the purchase of merchandise unti...

A: Income statement is prepared by the business organizations so as to know how much amount of gross pr...

Q: O$371.30 per unit

A: Solution Working note Calculation of existing results Sales price per unit 320 Variable co...

Q: Suppose Alexa has a weekly paycheck with gross earnings of $1,234.00 and is single with no dependent...

A: Payroll refers to the payment to be made by the employer to the employees for the services rendered ...

Q: The following items were taken from the financial statements of Buttercup Company. (All dollars are ...

A: The balance sheet shows the financial position of the company including the assets, liabilities, and...

Q: The following cost data are available for Honesty Co. for its first month of operations:            ...

A: Prime cost means the addition of direct material and direct labor and other direct expenses. Manufac...

Q: Honesty Manufacturing Company makes three products that can either be sold, or processed further and...

A: The decision of further processing of joint products is based in incremental analysis. If the increm...

Q: At the end of the day, the cash register tape shows $1,360 in cash sales, but the count of cash in t...

A: Count of cash in the register is debited and the sales are credit. The difference is transferred to ...

Payroll Entries

Payroll is a comprehensive record of employees that are paid by the company. Payroll classifies employees into various categories according to their function and pays scale (basic wage, allowance, income tax, other taxes, employee loans, etc.). Payroll processes form the bedrock of every organization as it contains sensitive information on the ‘wage and paycheck’ portion of the company’s strength—its employees. The organization needs to keep a track of the employees currently on the payroll, the net payout for the company, the record of transactions related to the employees including deductions and payroll taxes to identify the liability and its effect on the balance sheet (and other financial statements). Payroll records also include qualitative factors such as the conduct of the employee.