Compute the Bonus of each employee based on the number of customers. For example, webvchwv c (B9) that has 51 (C9) number of employees will get the bonus of Php 1,600.00 per customer. Since he got 51, bonus multiply by no. of customers is equivalent to: Php 81,600.00.Use the bonuses and customer numbers table in column F and G as your lookup table. Use Vlookup function. ABDFNoNoBonus perEmployeeBonus3CustomersCustomers Customer1 dwcbwbchb2 dhvwhcb3 udwehvchrbw4 evdhwvch5 hwvecduwvrfcjbe6 webvchwv c7 ajbdwejbcuj8 wefuwbcjwdbc9 jbqdchwvrhv10 jebjwbcjwfbv11 wbvjkw sdmc12 whvbkjsfbv kjs13 jbjvnsk14 wuebcjksdbc15 qbefjkwbvk1550.002310100.006.4120200.0071830400.008.740800.005150P 1,600.00102211191237133414115231610321852%23no72.5.9.1,

The total bonus is calculated by multiplying the number of customers by the bonus per customer…

Compute the Bonus of each employee based on the number of customers. For example, webvchwv c (B9) that has 51 (C9) number of employees will get the bonus of Php 1,600.00 per customer. Since he got 51, bonus multiply by no. of customers is equivalent to: Php 81,600.00. Use the bonuses and customer numbers table in column F and G as your lookup table. Use Vlookup function.

Compute the Bonus of each employee based on the number of customers. For example, webvchwv c (B9) that has 51 (C9) number of employees will get the bonus of Php 1,600.00 per customer. Since he got 51, bonus multiply by no. of customers is equivalent to: Php 81,600.00. Use the bonuses and customer numbers table in column F and G as your lookup table. Use Vlookup function.

FINANCIAL ACCOUNTING

10th Edition

ISBN:9781259964947

Author:Libby

Publisher:Libby

Chapter1: Financial Statements And Business Decisions

Section: Chapter Questions

Problem 1Q

See similar textbooks

Similar questions

Flavor Enterprises has been approached about providing a new service to its clients. The company will bill clients $160 per hour; the related hourly variable and fixed operating costs will be $70 and $18, respectively. If all employees are currently working at full capacity on other client matters and average hourly profit margin is $88, should the company accept this new services or not, use calculation to support your answer.
SHOW FORMULAS IN EXCEL
Consider a production process where flowers are grown (the output) using gardeners (labor) and greenhouses (capital). The quantity of flowers grown per day with various combinations of labor and capital are shown in the table below. Suppose that each gardener is paid $220 per day and the greenhouse is rented for $500 per day. Fill in total cost in the table below. (Enter your responses as integers.) Labor Capital Output Total Cost 0 1 0 $nothing 1 1 80 nothing 2 1 240 nothing 3 1 320 nothing 4 1 360 nothing 5 1 380 nothing
Chapter 1: Applying Excel: Excel Worksheet (Part 1 of 2) Download the Applying Excel form and enter formulas in all cells that contain question marks. For example, in cell C18 enter the formula "= B6". After entering formulas in all of the cells that contained question marks, verify that the dollar amounts in both the traditional and contribution format income statements match the numbers in Exhibit 1-7. Check your worksheet by changing the variable selling cost in the Data area to $900, keeping all of the other data the same as in Exhibit 1-7. If your worksheet is operating properly, the net operating income under the traditional format income statement and under the contribution format income statement should now be $700 and the contribution margin should now be $4,700. If you do not get these answers, find the errors in your worksheet and correct them. Save your completed Applying Excel form to your computer and then upload it here by clicking “Browse.” Next, click…
Please solve with steps. Thank you??
Start with the partial model in the file attached. Marvel Pence, CEO of Marvel’s Renovations, a custom building and repair company, is preparing documentation for a line of credit request from his commercial banker. Among the required documents is a detailed sales forecast for parts of 2020 and 2021: Sales Labor and Raw Materials May, 2020 $75,000 $80,000 June, 2020 $115,000 $75,000 July, 2020 $145,000 $105,000 August, 2020 $125,000 $85,000 September, 2020 $120,000 $65,000 October, 2020 $95,000 $70,000 November, 2020 $75,000 $30,000 December, 2020 $55,000 $35,000 January, 2021 $45,000 N/A Estimates obtained from the credit and collection department are as follows: collections within the month of sale, 20%; collections during the month following the sale, 60%; collections the second month following the sale, 25%. Payments for labor and raw materials are typically made during the month following the…
Subject: accounting
I will provide the question and answer but I need an explanation on how to get the answers. There are 4 answers (below) and the chart should be attached. Solve the problem. Round dollar amounts to the nearest dollar. Westminster Office Machines allocates its overhead of $1,487,304 by the sales of each product. Find the overhead for each department. List your answers if the order of the table. ($423,696, $458,304, $222,684, $382,620)
The following information is available for a company. How much of the factory rent should be charged to Department S? Factory rent = £15,000 Departments R S T 1,250 2,500 1,250 30 40 30 200 200 200 Bases of apportionment Floor area (square metres) Machine utilisation (%) No. of employees a) £7,500 b) £3,750 c) £5,000 d) £6,000
Suppose the smartphone manufacturer Peony Electronics provides the following information for its costs last month (in millions): (Click the icon to view the costs.) Read the requirements. Requirements 1, 2 and 3. Classify each of these costs according to its place in the value chain. Within the production category, break the costs down further into three subcategories: Direct Materials, Direct Labor, and Manufacturing Overhead. Then calculate the total cost for each value chain category. (Enter amounts in millions. If an input field is not used in the table, leave the input field empty; do not enter a zero.) Cost Delivery expense Salaries of salespeople Chipset Exterior case for phone Assembly-line workers' wages Technical support hotline Depreciation on plant and equipment Rearrange production process 1-800 (toll-free) line for customer orders Scientists' salaries Total costs Cost R and D $ 14 Peony Electronics Value Chain Cost Classification Direct Design Materials LA 60 5 $…
Please use the following information and use it to complete a few calculations, and answer questions in your paper. The paper ought to be written as a brief (1-1.5 pages) report that includes your calculations and a short explanation of what the firm should do if it is making a loss. A firm currently uses 40,000 workers to produce 100,000 units of output per day. The daily wage per worker is $80, and the price of the firm's output is $41. The cost of other variable inputs is $400,000 per day. Assume that total fixed cost equals $900,000. (Note: Assume that output is constant at the level of 100,000 units per day.) Calculate the values for the following variables using the formulas that are given: · Total Variable Cost = (Number of Workers x Worker’s Daily Wage) + Other Variable Costs · Total Costs = Total Variable Costs + Total Fixed…
Choose the correct answers . D.Materials ( 150 000 )$. D.Wages ( 250 000 )$. D.Expencess ( 150 000 )$. Ind.Expencess ( 125000 )$. Marketing cost ( v. ) ( 75000 )$. Ind.Marketing ( f. ) ( 85000 )$.?. Production cost ( using total cost ) . * ( 675000)$ (- 670000)$. ( another option ). ( 835000 )$