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

An online business pays a web-hosting company a monthly fixed fee of £141 and a fee of £0.51 per gigabyte of data used. During the last month, the total traffic in gigabytes was 2,884. What is the total cost for the month? Rounding to the nearest whole number A) 1612 B) 141 C) 1471 D) 2884
Thank you for that, it actually coincides with what I think. However, could you please calculate the breakeven points and give an explanation of what they mean to the director. Also, could you please calculate the sales activity to reach a target profit of 20,000
Part 1 is complete. I have copied it below before Part 2. This should help to complete Part 2 since there is no missing information. Newspaper ad $120 per month Social media manager $100 per month; $1 per job scheduled Payment collection $0.75 per job Gas $4.00 per job Considering his analysis of similar services and to keep things simple, W.T. plans to price all jobs the same and charge $15 per job. Because of this flat rate, he anticipates he’ll likely need to create different types of “jobs”. For example, purchasing a list of items at the grocery store would be one job, while a bundle of 2-3 small errands such as picking up dry cleaning and prescriptions, might be considered one job. We’ll deal with those details later. For now, assume that all jobs are priced at $15 each and all have the associated variable expenses listed above. Because this will be a new business, W.T. knows business will likely be slow at the beginning. Complete the following…
Please show work
The data below relate to a small service business. The business delivers a standard service to all customers. (Enter your answer as an integer number.) Fixed costs Variable cost per service £100,000 146 271 Selling price per service How many services need to be provided to make a profit of £166,000 for the business? Enter your answer below. The number of services to make the required profit is
Please answer E
SHOW FORMULAS IN EXCEL
Answer
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
Please solve with steps. Thank you??
1. Consider the following scenario: [2.5] Imagine that you are in charge of a cycle hire business in a holiday resort. You have 50 cycles available for hire. Some customers hire cycles for one day; others take them for up to one week. Write down any three decisions that you might make as a manager, where accounting information would be helpful in making the decision.
Solve a Related Rates Problem. A technical support contracting firm hires people to work from home using their proprietary support scripting system. The more employess they have, the more contracts they can support and therefore the more revenue they can generate. Suppose that the company's revenue and number of employees is related by R² = 297x³, where is R is the revenue in thousands of USD anda is the number of employees in hundreds. If there is no shortage of work to be done, the company currently has 3300 employees, and the company wants to increase their revenue from $3,267,000.00 this year to $5,643,000.00 next year, how many new employees should be hired in order to make that possible? The company should hire new employees before next year. Preview My Answers Submit Answers h