Today's Assignment* Design a salary slip for the month of December 2021 with information given below. Fixed vs variable ratio- 70:30 Ctc - 18L Basic- 50% Hra- 20% Da - 12% Travel allowance- 2000 Insurance - 2500 Incentive- 75% target completion Pf 12% Earned leaves - 2 LOP - 4 Prepare the assignment in Ms excel/ Ms Word. And submit on whatsApp. Before 4 pm tomorrow. Regards
Q: On November 30, accounts receivable in the amount of P900,000 were assigned to Turon Finance Co. by…
A: Accounts Receivable (AR) are the profits or revenues that a business expects to receive from…
Q: On December 1, 2021, Carlos entered into a lease on a building for use in his business for $1,000…
A: As per relevant tax laws, in case lease payments in advance for 12 months, then such advance can be…
Q: their interest in the partnership to Wendy? 5
A: Ratios of Partners before admission: Ratios Erza Carla…
Q: Which is not within the definition of an intangible asset? A resource from which future economic…
A: Unlike tangible Assets these Intangible Assets are difficult to valuate
Q: Clin Corporation has an overhead crane that has an estimated remaining life of 10 years. The crane…
A: Net Present Value The net present value demonstrates its applicability in capital budgeting. It…
Q: Cove’s Cakes is a local bakery. Price and cost information follows: Price per cake…
A: Break-even point is a point where a company neither has gain nor loss. Sales above this point…
Q: As Reported Annual Balance Sheet Report Date Scale Assets Cash & cash equivalents Receivables, net…
A: Working capital is the amount of capital needed for day to day operations in business. This is…
Q: which of the anwsers are operating activities, financing activities, and investing activites for the…
A: In the cash flow statement there are main three segment are there. The details are given below…
Q: A and B formed a partnership. The partnership agreement stipulates the following: ● Annual salary…
A: The partnership comes into existence when two or more persons agree to do the business and further…
Q: The summarized trial balance of XYZ Corporation includes the following accounts on December 31,2022:…
A: Statement of financial position is one of the important financial statement being prepared by the…
Q: how much is recorded as outright se?
A: in case of bussiness combination if additional information recevied within a Measurment period…
Q: Determine the effective rate of interest of the following nominal rates. a. nominal rates…
A: Effective interest rate formula When Compounded annually and quarterly (1+r/n) n - 1 r= nominal…
Q: 5 Reporting Changes in Shareholders' Equity The shareholders' equity accounts for Erle Enterprises…
A: Stockholder's Equity - Stockholder's Equity includes the amount contributed by shareholders issued…
Q: On October 31, Legacy Rocks Inc., a marble contractor, issued for cash 72,900 shares of $10 par…
A: Issue of shares is one of the important source of finance being used in business. It consists of…
Q: QUESTION 2 a. Electric Ltd is a wholly owned company of Power Ltd. Power Ltd treats Electric Ltd as…
A:
Q: Following are the transactions of a Merchandise business. Product Desktop computer Table computer…
A: A journal entry is a form of accounting entry that is used to report a business transaction in a…
Q: Bright Co. received a government grant of 10,000,000 to install and run a windmill in an…
A: As per IAS 20, Accounting for Government Grants and Disclosure of Government Assistance, the…
Q: ABOUT AUDITING The process of selecting and developing policies and procedures to help mitigate…
A: Audit Risk- Audit risk is the possibility that an auditor will issue an incorrect opinion on…
Q: Due to erratic sales of its sole product-a high-capacity battery for laptop computers-PEM,…
A: Note: Due to picture blur, it is presumed that the fixed cost is 169,200 Workings:…
Q: Canco’s net income in its financial statements is $300,000. Included in this amount is a $40,000…
A: The sum a person or corporation obtains after subtracting expenses, allowances, and taxes is…
Q: E4-19 (Algo) Reporting a Correct Income Statement with Earnings per Share to Include the Effects of…
A: Total asset turnover ratio=Total revenueAverage assets
Q: On December 1, Young Corporation exchanged 5,000 shares of its P25 par value common stock held in…
A: When an assets is purchased in exchange of shares then such asset is recorded at the market value of…
Q: - Taxpayer has just accepted a job as chief counselor at a large daycare camp operated by a local…
A: As per federal income tax, the value of meal that provide by employer to employee in addition to…
Q: b) Complete the following table to show how FOB terms apply to merchandise inventory purchased by a…
A: Inventory is the stock that an entity owns for selling in the market. It represents the goods that…
Q: Prepare Income statement? Grey Grig Ltd Trial Balance as at 30 June 2019 Particulars Equipment…
A: Income statement is one of the important financial statement of the business. This shows all incomes…
Q: 10. How much is the adjusted book receipts for December 2020? 11. How much is the adjusted book…
A: Proof of cash is a statement which is prepared to calculate the opening cash balance at just a cash…
Q: The CPA states in his independent auditor’s report that he has examined the* a. Financial statements…
A: The CPA states in his independent auditor's report that he has examined the a. Financial statements…
Q: Tiffancy and Co. has projected sales to be 70,000 in February, 85,000 in March and 90,000 in April.…
A: Projected sales refer to the units or items that a business anticipates to sell in the near future.…
Q: Medhurst Corporation issued $86,100 in bonds for $83,000. The bonds had a stated rate of 8% and pay…
A: Introduction: Journals: All the business transactions are to be recorded in Journals. Journals are…
Q: Prepare the statement of retained earnings for the month of July 31.
A: Retained Earning = Retained earning at the beginning+ Net Income-Dividends
Q: What would be the answer with the amount changed from $80,000 to $138,900?
A: Depreciation is the amortization of a company's assets over its useful life which shows as a…
Q: Pro-Builders Corporation has 242,000 shares of $45 par common stock outstanding. On September 2,…
A: Stock dividend means a payment given to the shareholders in shares instead of a cash payment. Stock…
Q: Materials used, P326,000. Total manufacturing costs charged to production during the year (including…
A: Hi student Since there are multiple questions, we will answer only first question. Cost accounting…
Q: On June 30, 20X1, ABC Corp exchanged 6,000 shares of XYZ Company P10 par value ordinary shares for…
A: Lets understand the basics. When there is exchnage of non monetary asset on asset of another non…
Q: On June 1, 2022, Pitt Corp. sold merchandise with a list price of Php 5,000 to Burr on account. Pitt…
A: Trade discount is providing in series of discount at the time of sale. Cash discount will be 2℅ if…
Q: BC Corp incurred the following R&D expenses in 20X1: Cost to complete a detailed formula on the…
A: Explanation of Concept Cost is the expenses which have been incurred for production, marketing and…
Q: The primary objective of this audit is to provide assurance to
A: Audit is required for all the companies which are the public companies or even for those companies…
Q: Pro-Builders Corporation has 242,000 shares of $45 par common stock outstanding. On September 2,…
A: Stock dividend: Stock dividend means a payment given to the shareholders in shares instead of a cash…
Q: BRAIN and FREEZE have capital balances of P750,00 and P500,000 and share in partnership profits and…
A: Since Hurt was Admitted with 20 % share in partnership Then the remaining partners share will be…
Q: During the current year, Mine View Company incurred P2,000,000 in exploration cost for each of the…
A: Oil exploration expense reported in the income statement for the current year=Number of dry…
Q: ! Required information E4-8 (Algo) Recording Seven Typical Adjusting Entries LO4-1 [The following…
A: Working notes. b) supplies used during the year Opening balance of office supplies= $530 Add…
Q: 20-5 LEASE VERSUS BUY Sullivan-Swift Mining Company must install $1.2 million of new machinery in…
A: Salvage Value This is the expected resale value of a tangible fixed asset if such asset is sold…
Q: Blue Company is unable to reconcile the bank balance at January 31. Blue’s reconciliation is as…
A: A bank reconciliation statement aligns an organization's bank account with its financial documents…
Q: Amortization entries Instructions Chart of Accounts First Question Journal Instructions Kleen…
A: >Intangible assets are the assets that do not have any physical existence and cannot be seen,…
Q: Question D is incorrect. Can you check the answer
A: Here discuss about the details of the taxable income and income tax which are incurred with the tax…
Q: [S1] An investor should buy an asset when it is undervalued and sell the asset when it is…
A: An asset is expected to approach to its fair value that should be. If it is undervalued then an…
Q: Prepare income statement Particulars Sales Purchases Salaries Motor expenses Rent Ali Mamat…
A: Introduction: Income statement: All revenues and expenses are shown in income statement. It tells…
Q: 945,000, P477,300, and P324,700, respectively. The partners receive 10% interest their average…
A: Explanation of concept Partnership is the firm which is run by two or more partners on the basis of…
Q: An attestation engagement is one in which a CPA is engaged to: A. Issue a written communication…
A: CPA is certified public accountant who is experienced, educated and have license. Attestation means…
Q: The BRS Corporation makes collections on sales according to the following schedule: 25% in month…
A: Introduction: Cash collection, also recognized as payment, is a reserve bank function that describes…
*Today's Assignment*
Design a salary slip for the month of December 2021 with information given below.
Fixed vs variable ratio- 70:30
Ctc - 18L
Basic- 50%
Hra- 20%
Da - 12%
Travel allowance- 2000
Insurance - 2500
Incentive- 75% target completion
Pf 12%
Earned leaves - 2
LOP - 4
Prepare the assignment in Ms excel/ Ms Word. And submit on whatsApp.
Before 4 pm tomorrow.
Regards
Step by step
Solved in 2 steps with 1 images
- Design a salary slip for the month of December 2021 with information given below. Fixed vs variable ratio- 70:30Ctc - 18LBasic- 50%Hra- 20%Da - 12%Travel allowance- 2000Insurance - 2500Incentive- 75% target completionPf 12%Earned leaves - 2LOP - 4 Prepare the assignment in Ms excel/ Ms Word.Filé Edit Förmat View Help COMPA RATIO AVERAGE SALARY OF EMPLOYEES/MIDPOINT OF RANGE Given: Pay grade 1 Midpoint range" $2,175 per month Salary of Employees in Pay Grade E1- $2,306 E2- $2,066 E3- $2,523 E4- $2,414 what is the average salary of employees? What is the compa-ratio?1. Create the following spreadsheet 'Payroll' below. Add a new column Net Pay and calculate the net pay for each student. At bottom calculate Average, MAX, MIN (do not use these three items for graph). PAYROLL FOR THE WEEK ENDING JUNE 30 ID ΕMPLOYEΕ NAME HOURLY RATE HOURS WORKED NUMBER 110 FORD 7.89 37.00 111 MINO 8.00 50.00 112 BELL 7.50 34.50 113 AARON $ 9.00 47.50 114 DAVIS 11.00 36.00 115 TURRO $ 10.50 45.00 2. Use the data on the payroll spreadsheet to create a column graph that shows the net pay for all employees. (Include employee names). 3. Insert the column chart onto your spreadsheet under your data. %24 %24 %24 %24
- Noura Company offers an annual bonus to employees (to be shared equally) if the company meets certain net income goals. Prepare the journal entry to record a $14,000 bonus owed (but not yet paid) to its workers at calendar year-end. View transaction list Journal entry worksheet < 1 Record the expected bonus costs. Note: Enter debits before credits. Date December 31 General Journal Debit Credit 7 Record entry Clear entry View general journalSpecialty Manufacturing estimated that its total payroll for the coming year would be $482,500. The workers' compensation insurance premium rate is 0.2%. Required: 1. Calculate the estimated workers' compensation insurance premium.$ Prepare the journal entry for the payment as of January 2, 20--. If an amount box does not require an entry, leave it blank. Page: DATE ACCOUNT TITLE DOC.NO. POST.REF. DEBIT CREDIT 1 20-- Jan. 2 1 2 2 3 3 2. Assume that Specialty Manufacturing's actual payroll for the year is $487,000. Calculate the total insurance premium owed.$ Prepare a journal entry as of December 31, 20--, to record the adjustment for the underpayment. The actual payment of the additional premium will take place in January of the next year. If an amount box does not require an entry, leave it blank. Page: DATE ACCOUNT TITLE DOC.NO. POST.REF. DEBIT CREDIT 1 20-- Dec. 31 1 2…Workers' Compensation Insurance and Adjustment Specialty Manufacturing estimated that its total payroll for the coming year would be $447,500. The workers' compensation insurance premium rate is 0.2%. Required: 1. Calculate the estimated workers' compensation insurance premium. $ Prepare the journal entry for the payment as of January 2, 20--. Page: DỌC. POST. DATE ACCOUNT TITLE DEBIT CREDIT NO. REF. 20-- 1 Jan. 2 1 2 2 3 2. Assume that Specialty Manufacturing's actual payroll for the year is $452,500.00. Calculate the total insurance premium owed. Prepare a journal entry as of December 31, 20--, to record the adjustment for the underpayment. The actual payment of the additional premium will take place in January of the next year. Page: DOC. POST. DATE ACCOUNT TITLE DEBIT CREDIT NO. REF. 20-- 1 Dec. 31 2 2 3 3
- Workers' Compensation Insurance and Adjustment Specialty Manufacturing estimated that its total payroll for the coming year would be $447,500. The workers' compensation insurance premium rate is 0.2%. Required: 1. Calculate the estimated workers' compensation insurance premium.$ Prepare the journal entry for the payment as of January 2, 20--. Page: DATE ACCOUNT TITLE DOC. NO. POST. REF. DEBIT CREDIT 1 20--Jan. 2 1 2 2 3 3 2. Assume that Specialty Manufacturing's actual payroll for the year is $452,500.00. Calculate the total insurance premium owed.$ Prepare a journal entry as of December 31, 20--, to record the adjustment for the underpayment. The actual payment of the additional premium will take place in January of the next year. Page: DATE ACCOUNT TITLE DOC. NO. POST. REF. DEBIT CREDIT 1 20--Dec. 31 1 2 2 3 3Required: Prepare the journal entries to: (a) distribute the weekly payroll and to (b) ace the bonus, vacation and holiday pay. P44 Monthly payroll register of Hanna Institute for January shows the following information: The salary for administrative employees is P20,000; faculty, P300,000. Hanna shar 50% of the insurance premium per month. Total amount of installment is P10,000 and P2,500 will be deducted from both departments (admin and faculty) each. There are 5 faculty members with equal salaries; two of them are most senior and entitled to avail 2 weeks paid leave every year. Mr. Johnson, one of two senior members, received bonus of P1,000 for his last year's awesome result. Required: Journal entries to record payroll on January 31st.1. The following information was reported for Gray Enterprises on December 31, 2020.Manufacturing Overhead Debit Credit 3,410 51,520 15,030 37,090 Double line4,010 Double line A. What is the actual manufacturing overhead? B. What is the allocated manufacturing overhead? C. Is manufacturing overhead underallocated or overallocated? D. Prepare the adjusting entry.Journal Date Description Debit Credit Dec. 31, 20 Dec. 31, 20 2. The following information was reported for Gray Enterprises on December 31, 2021.Manufacturing Overhead Debit Credit 2,020 56,340 15,540 31,920 Double line Double line6,860 A. What is the actual manufacturing overhead? B. What is the allocated manufacturing overhead? C. Is manufacturing overhead underallocated or overallocated? D. Prepare the adjusting entry.Journal Date Description Debit Credit Dec. 31, 20 Dec. 31, 20
- Problem 2. A weekly payroll summary made from time tickets shows the following data: A weekiy payroii su mai y mauv uv . Exemption Status S Number of Hours Rate/Hour Regular Overtime 40 40 + Employe Austria, B. Bautista, D. De Santos, M. Motus, R. Reyes, A. Classification Direct Direct Direct Indirect 36 36 МЕ 45 40 4 МЕ-2 30 40 4. Indirect HF 30 40 HF Overtime is payable at one-and-a-half times the regular rate of pay for an employee. Required • a) Determine the net pay for each employee. b) Prepare journal entries for: • recording the payroll. payment of the payroll. • distribution of the payroll. • the employer's payroll taxes.Required: Prepere the Joumal entries to: (a) distribute the weekly the bonus, vacation and holiday pay. rue R4 Monthly payroll register of Hanna Institule for January shows the following information:. The salary for administrative employees is P20,000; faculty, P300,000. Hanna shareo P2,500 will be deducted from both departments (admin and faculty) each. There are 5 faculty members with equal salaries; two of them are most senlor and entitler to avail 2 weeks pald leave every year. Mr. Johnson, one of two senior members, received bonus of P1,000 for his last year's awesome result. Required: Journal entries to record payroll on January 31st.Willamette Manufacturing estimated that its total payroll for the coming year would be $670,000. The workers' compensation insurance premium rate is 0.3%. Required: 1. Calculate the estimated workers' compensation insurance premium.$ Prepare the journal entry for the payment as of January 2, 20--. Page: DATE ACCOUNT TITLE DOC. NO. POST. REF. DEBIT CREDIT 1 20--Jan. 2 1 2 2 3 Paid estimated workers' compensation insurance premium 3 2. Assume that Willamette Manufacturing's actual payroll for the year was $694,000. Calculate the total insurance premium owed.$ Prepare a journal entry as of December 31, 20--, to record the adjustment for the underpayment. The actual payment of the additional premium will take place in January of the next year. Page: DATE ACCOUNT TITLE DOC. NO. POST. REF. DEBIT CREDIT 1 20--Dec. 31 1 2 2 3 Adjustment for insurance premium…