BUSINESS HIGH SCHOOL

PROJECT: USING ADVANCED FORMULASSuppose you own a small business with ten employees. Small businesses use spreadsheets for a variety of reasons.

OBJECTIVES
Create a spreadsheet to track payroll.
Directions
Create a spreadsheet to calculate the your company's payroll, or how much you pay each employee and the total you pay all employees.

You pay your employees every two weeks, and for the last two weeks, your employees worked the following hours:

Employee 1: 78
Employee 2: 75
Employee 3: 80
Employee 4: 45
Employee 5: 50
Employee 6: 80
Employee 7: 65
Employee 8: 60
Employee 9: 78
Employee 10: 75
Your spreadsheet should calculate:

the total hours worked for each employee
the gross pay for each employee (pay rate is $12.50 per hour)
the state income tax for each employee (use 5.7%)
the Federal income tax for each employee (use 15%)
Social Security for each employee (use 3.5%)
the net pay for each employee by subtracting the income tax and Social Security from the gross pay
the total gross pay, total state income tax, total Federal income tax, total Social Security, and total net pay paid to all employees
When you finish your spreadsheet, estimate your answers to check for accuracy. Make any necessary corrections. Use formatting techniques to make your spreadsheet easy to read. Upload your spreadsheet using the Upload tool in the box below.

Answers

Answer 1

Answer:

Answer:

here you go edmentum

Explanation:

Answer 2

Answer:

Final answer:

Creating a spreadsheet to track company payroll involves entering information such as hours worked, calculating gross pay, individual taxes, and net pay which is the remaining amount after all deductions. The total values for each column can be calculated using the SUM function. Make sure to format your data for easier reading and verify your inputs for accuracy.

Explanation:

To create a spreadsheet to calculate your company's payroll, follow the steps outlined below.

Label the columns: Employee ID, Hours Worked, Gross Pay, State Income Tax, Federal Income Tax, Social Security, and Net Pay.
Under Hours Worked column, input the hours worked by each employee. For example, Employee 1 worked for 78 hours.
Calculate the Gross Pay by multiplying hours worked by pay rate ($12.50).
Calculate State Income Tax by multiplying Gross Pay by 5.7%.
Compute Federal Income Tax by multiplying Gross Pay by 15%.
Compute Social Security by multiplying Gross Pay by 3.5%.
Finally, calculate the Net Pay by subtracting the total deductions (State Income Tax, Federal Income Tax, and Social Security) from Gross Pay.
To find the total of each column, use the SUM function at the bottom of each.
Use formatting techniques to make your data easy to read, such as bolding headers or aligning text.
After finishing, estimate your answers to check for accuracy and make any necessary corrections.

Learn more about Spreadsheet here:

brainly.com/question/34443321

#SPJ11

Related Questions

49) Companies using lean systems generally have:a. suppliers who are low-cost producers. b. suppliers that are willing to accept short-term contracts. c. suppliers that are located nearby to decrease delivery lead time. d. many suppliers to ensure that material shortages never occur.
Each of 20 consumers is provided with a pack- age containing two different brands of instant coffee. a week later, they are asked to rate the taste of each cof- fee on a scale of 1 (poor taste) to 10 (excellent taste). is this an example of independent samples or dependent samples?
An example of libel is a journalist making someone look bad by purposefully:
Companies from the United States have built many factories in Mexico near the border. Why have so many U.S. factories moved to Mexico? The mild temperatures speed production. Mexico is a source of cheaper labor. There is no room to build in the United States. The United States has a shortage of skilled laborers.
Sam takes a five-dollar bill from his wallet. He exchanges the bill for four quarters and four one-dollar bills. He then uses the change to buy a bottle of water from a vending machine. Which characteristics of money has Sam best demonstrated?Acceptability, divisibility, and portability Divisibility, scarcity, and stability of value Durability, portability, and standard Medium, scarcity, and value i think its the first right am i right

The primary financial goal of a corporation is shareholder wealth maximization, which involves maximizing the long-run value of the firm's stock and requires taking a long-run view of a firm's operations. To achieve their financial goals, firms must develop products that consumers want, produce the products efficiently, sell them at prices, and observe laws relating to corporate behavior.a. Apart from their financial goals, companies also focus on a wide number of non-financial goals including maximizing the welfare of their employees, efficiently and fairly serving their customers, and respecting their local community and environment.Select the statement that best completes the following statement: Most managers recognize that being socially responsible is important and generally (but not always consistent) with achieving their financial goals.b. As a result of financial scandals during the past decade, there has been a strong push to improve business ethics. Managers have an obligation to behave ethically, and they must follow the laws and other society-imposed constraints. Most managers recognize that being ethical is consistent with the corporation's primary goal.c. A stock's intrinsic value is an estimate of a stock's "true" value based on accurate risk and return data. It can be estimated but not measured precisely. When a stock's actual market price is equal to its intrinsic value, the stock is in equilibrium. The marginal investor's views determine a firm's actual stock price.

Answers

Shareholder Wealth Maximization, Intrinsic Values, and Ethics

Explanation:

The principle of shareholder wealth maximization (SWM) maintains that a highest possible return to shareholders is and therefore should be the objective of all multinational activity. From the point of view of financial management, the prices of the common shares of a company must be maximised.

People also compromise themselves for many other things, such as religion, their land, justice, knowledge, truth, art. or other items. All of these tasks convey the second feature of the value: they are valued for their own sake by someone.

Business ethics relates to the application of appropriate laws and policies on controversial issues.

During the consumer purchase decision process, an individual at the __________ stage will perceive differences between his or her ideal and actual situations big enough to trigger a decision. postpurchase behavior cognitive dissonance problem recognition alternative evaluation information search

Answers

Problem recognition stage.

This is when the consumer makes a conscious realization that they have a problem which can (hopefully) be solved by purchasing a product or service in the marketplace.

What is a benefit of stock markets? They create jobs.
They allow companies to generate income.
They allow individuals to invest money and create more money.
All of the above.

Answers

Answer: All of the above.

Explanation:

The stock market refers to the market which deals with buying and selling of stocks among investors and also issuance of shares of public-held companies. This is done or conducted over the counter (OTC) which operates under a defined set of regulations. There can be more than one stock trading center in a country which allows transactions in stocks and other forms of securities to take place. The stock market create jobs or employment as a result of people working in the market, it allow companies to generate income through buying and selling of stocks and it also serve as a means of investing and creating more money for individuals.

What is CRM software designed to do ?

Answers

CRM software is designed to help business meet overall goals of customer relationship management. However this software is sometimes used to manage business contacts, clients, and contract wins and sales leads.

Answer :

B . ) Track And Manage Customer Relationships

Reasons to study operations management include learning about: A. how goods and services are produced.
B. what operations managers do.
C. how people organize themselves for productive enterprise.
D. a costly part of the enterprise.
E. All of the above.

Answers

Answer:

The answer is: A) How goods and services are produced.

Explanation:

Operations management tries to crest the highest possible level of efficiency within an organization.

One of its main concerns is how to transform materials and labor into goods (or services) as efficiently as possible to maximize profit.

In order to maximize efficiency, operations managers must be experts on the production processes of the organization.

Final answer:

Studying operations management provides a comprehensive understanding of how goods and services are produced, the role of operations managers, and how organizations organize themselves for productive enterprise.

Explanation:

Reasons to study operations management include learning about:

A. how goods and services are produced. Operations management involves understanding the processes and systems used to create goods and deliver services to customers. This includes concepts such as production planning, scheduling, inventory management, and quality control.

B. what operations managers do. By studying operations management, students can gain insights into the responsibilities of operations managers. They learn about the decision-making, problem-solving, and leadership skills required to effectively manage production processes and improve overall efficiency.

C. how people organize themselves for productive enterprise. Operations management explores how organizations structure themselves to achieve their production goals. Students learn about organizational design, workflow analysis, and the allocation of resources to enhance productivity and profitability.

Therefore, the correct answer is E. All of the above. Studying operations management provides a comprehensive understanding of how goods and services are produced, the role of operations managers, and how organizations organize themselves for productive enterprise.

Learn more about Operations Management here:

brainly.com/question/33025951

#SPJ6

An automobile final assembly plant has an annual production capacity of 200,000 cars. The plant operates 50 weeks/yr, 2 shifts/day, 5 days/week, and 8.0 hours/shift. It is divided into three departments: (1) body shop, (2) paint shop, and (3) trim-chassis-final department. The body shop welds the car bodies using robots, and the paint shop coats the bodies. Both of these departments are highly automated. Trim-chassis-final has no automated workstations. Cars are moved by a continuous conveyor. There are 15.0 hours of work content time on each car in this department. If the average manning level is 2.2, balancing efficiency = 93%, proportion uptime = 95%, and a repositioning time of 0.15 min is allowed for each worker, determine (a) hourly production rate of the plant.
(b) number of workers and workstations in trim-chassis-final.
(c) What is the average labor cost per car in trim-chassis-final if the hourly worker rate = $35 and fringe benefits add $20/hr. Ignore cost of supervision, maintenance, and other indirect labor.