For each of the following requirements, create a new pivot table in a new worksheet. Name each new worksheet as "Req 1," "Req 2," etc. Format the dollar amounts in each pivot table or pivot chart using the accounting format with zero decimal places. Format non-currency numbers in each pivot table or pivot chart using the accounting format with zero decimal places.
From 2013 – 2016, what was the total spending in each of the four calendar years? Is spending trending up, trending down, or remaining stable?
In each of the years 2013 - 2016, how much was spent in each of the three categories of government (Education, General Government, and Public Works)? What does the pivot table show you?
How much in expenditures did Somerville have in each "Item Class" in the General Government category for each of the years 2013 – 2016? What insights can you draw from the pivot table?
Using the budget worksheet included in the Excel data file, prepare a budget variance report that compares actual spending by "Item Class" in 2016 for the General Government category. Use cell references for the actual spending totals. Use conditional formatting (use the "Shapes, 3 Signs" style) to denote the direction of the percentage variances. You will want to denote any variance that is more than +/−10% with a red diamond, between +/−3 – 9.99% with a yellow diamond, and less than +/−3% with a green circle.
Note: You can refer to cells in a pivot table from another worksheet, but you cannot copy the referenced cell – so you have to point to each cell individually.
Analyze the budget variance report you prepared in Step 4. What variances do you think should be investigated? Why?

Answers

Answer 1

To address this question, the first step is to create a new worksheet for each requirement and name them accordingly.

For each pivot table or chart, the dollar amounts should be formatted using the accounting format with zero decimal places. Non-currency numbers should also be formatted in the same way.

Once this is done, the budget variance report can be analyzed to identify any variances that need to be investigated. There are several factors that could contribute to variances in a budget, such as unexpected expenses, changes in market conditions, or errors in forecasting.

For example, if there is a significant variance in the sales revenue, this could indicate that the sales team may not be meeting their targets or that there is an issue with the product or service being offered. Similarly, if there is a variance in the cost of goods sold, this could be due to changes in the cost of raw materials or production processes.

In order to investigate these variances further, it may be necessary to gather more data, conduct a more detailed analysis, or speak to relevant stakeholders to get a better understanding of the situation.

By doing so, it may be possible to identify the root cause of the variance and take corrective action to address it. Overall, a thorough analysis of the budget variance report can help identify areas where improvements can be made to achieve better financial outcomes.

For more such questions on, worksheet :

https://brainly.com/question/308715

#SPJ11


Related Questions

Problem 17-1A Comparing costs using ABC with the plantwide overhead rate LO P1, P3, A1, A2

Answers

Answer:

$67.50 per hour

Explanation:

Setup Cost = $312,500

Transportation Cost = $10,000

Direct Labor cost $25,500

Modification of machine cost $12,000

Insurance of Factory Premises $28,000

Raw material Cost $118,250

Machine hours = 7,500 hours

labor hours = 3,500  hours

Total manufacturing Overheads = $506,250 / 7,500 = $67.5 per hours

List of the least five behaviors you feel would be behavior you feel would be considered irresponsible in the workplace. For each behavior listed, provide a detailed example/scenario to detail what makes the behavior either responsible or irresponsible.

Answers

Answer: See Explanation

Explanation:

Some of the behaviors that would be considered irresponsible in the workplace include:

1. Lateness: Every company has its working hours and it is required for the employees to adhere to the working hours and always get to work on time. Lateness is a bad habit in the workplace. For a company to achieve its goals, it's required for its workers to come to their workplace early and perform their duty well.

2. Cyberslackers: This occurs when the employees use the internet that is meant for work related activities to surf the net and browse sites that doesn't relate to their work. For example, a case whereby an employee is checking his or her social media at the workplace.

3. Lying to other employees: It is a bad behavior for an employee to lie or say something that's not true about a person in order to gain an advantage or for other person reasons Lying brings about lack of trust and disunity in the workplace.

4. Having a bad character: In an organization, it is vital for the employees to possess good characters such as being kind, caring, helpful etc. Possessing a bad character will have a negative effect on the company.

5. Theft: Employee theft is also an irresponsible behavior in the workplace. Stealing has a negative effect on the revenue of the company as it reduces the revenue such company makes. Employees should always make sure that they do not falsify information in order to gain a financial advantage or steal company's fund.

Pete and Shirley are filing a joint return. They have two dependent children. What is the total amount of their exemptions for tax year 2019? A. $0 B. $4,200 C. $8,400 D. $16,800

Answers

Answer:

A. $0

Explanation:

The Tax Cuts and Jobs Act eliminated personal exemptions starting 2018. It also increased standard deductions though. For example, the standard deduction for married filing jointly for 2019 was $24,400. This is a significant increase if you consider that the standard deduction for married filing jointly in 2017 was $12,700.

Prepare a report on environmental sanitation. Include the impacts, causes, and prevention methods​

Answers

Answer and Explanation:

Environmental sanitation is carried out through a series of public investments that seek to promote environmental control in a region. The impacts of this type of sanitation must be positive, since it is through it that a community can present adequate garbage collection, treated water supply, sewage treatment, correct disposal of human waste, cleaning of public roads, basic sanitation, among others . All of this promotes human development, the well-being of the population and environmental preservation.

The causes of environmental sanitation are the need to establish social policies that promote better living conditions and that optimize the health of citizens without degrading the environment.

A. Identify a profession b. In not more than 60 words, describe the "art" and "science" of such profession in (a).

Answers

Answer:

Comedy as a Profession is a great example.

Explanation:

The science of it is related to the psychology of what makes people laugh.

If studied, one would realize that there are certain things that are bound to make people laugh (all things being equal). An example is when a person makes fun of themself to an audience.

To explain this, scientists have stated that it is inherent in humans to laugh at the misfortune of others. However, this is just a theory and does not explain why we laugh at other kinds of comedy.

A plausible explanation (which is more recent in the parlance of psychology) is that people also laugh when certain expectations are defied in a very witty manner.

As a professional stand-up comedian, knowing all the rules and tricks is just one part of the coin. Being able to, either by practice or repeated efforts during practice, internalize these principles, practice them and effectively use them is the artistic part of the picture.

There those who are gifted naturally with a principle thought process that elicits laughter from others, would be termed hilarious. However, to make a living out of comedy, one would need to fully understand the principles and practice to deliver them as naturally as possible.

Another paradigm to the art of comedy is that, it has to be very witty. Wit many times may come with an element of suprise... a new angle that was previously "unthought" of.

Cheers!

5. Describe how Chris used networking to his advantage in getting an internship
Witter and signing new clients.

Answers

Answer:

is there more information for this question?

A weekly report for new agents at a vacation sales company is shown in the histogram. A histogram titled Vacation Packages has number of packages sold on the x-axis and number of salespersons on the y-axis. 9 sold 1 to 2 packages; 7 sold 3 to 4; 4 sold 5 to 6; 3 sold 7 to 8; 2 sold 9 to 10; 1 sold 11 to 12; 2 sold 13 to 14; 3 sold 15 to 16. How many of the new agents sold more than 10 vacation packages?

Answers

Answer:

6 salespersons

Explanation:

A histogram shows the graphical representation of the distribution of numerical data using bars of different lengths.

From the histogram:

The number of salespersons who sold 11 - 12 packages = 1

The number of salespersons who sold 13 - 14 packages = 2

The number of salespersons who sold 15 - 16 packages = 3

Therefore the new agents who sold more than 10 vacation packages = 1 + 2 + 3 = 6 salespersons

Answer:its 6

Explanation:i took the quiz and i know the answer

In what type of economy do people officials determine the 3 basic economic questions?

Answers

Most likely a Command economy.

How can the government be both a producer and a consumer in respect to its relationship with business

Answers

Answer:

they gonna tinda and be kind to the coatumets

Answer:

they are gonna tinda and be nice to the caotmautes

On 3/1/X1 Landlord Co. received a $36,000 cash payment from Renter Co. to pay for a total of 17 months, starting in the current month. How much revenue should Landlord Co. recognize in the year ending 12/31/X1? Round your answer to the nearest penny.

Answers

Answer: $21177

Explanation:

First and foremost, we should note that since the revenue that Landlord Co. wants to recognize in the year ending 12/31/X1 will be for a period of 10 months that is, from 1st of March to 31st of December.

Therefore, the revenue that Landlord Co. should recognize in the year ending 12/31/X1 will be:

= $36000 × 10/17

= $21176.471

= $21177

Theta Inc. uses normal costing and applies overhead based on direct material costs. The predetermined overhead rate for the current year is 250% of direct material costs. During the year, $3,500,000 of direct material costs and $4,000,000 of direct labor costs were incurred. Theta's applied overhead is:

a. $9,375,000.

b. $1,600,000.

c. $8,750,000.

d. $1,400,000.

Answers

Answer:

a. $9,375,000.

.

.

.

.

.

.

.

.

.

.

.

.

.

.

.

.

.

.

.

FINISH THIS SENTANCE
There was this blind man, right? He Was feeling his way down the street with this stick,

Answers

when he runs into a old dog who so happens to be a dog that guides blind people.

Question 2 (1 point)
Kelsi works in a toy manufacturing company assembling small dolls. Her job falls into
the Maintenance, Installation & Repair pathway of the Manufacturing career cluster.

1:) True

2:) False

Answers

True




I guess don’t be mad if I’m wrong

What are some common spreadsheets applications?​

Answers

USES ( APPLICATIONS) of spreadsheet are;

1) to create budgets : Excel can be used in creation of budget s which is the estimation of revenue as well as expenses which covers specified future period of time.

2)produce graphs and charts: it's application is helpful in creating graphs in mathematics as well as statistics

3 for storing and sorting data: Data sorting can be done using spreadsheet. It involves arrangements of data into an order in order to make analysis of the data easier.

SPREADSHEET APPLICATION

1)Microsoft Excel : This is used in data

crunching , it can handle large data sets.

2)LibreOffice : it's applicable in Calc for a free as well as native spreadsheet app.

4) Smartsheet: is useful when handling

task involving non-spreadsheet and can be used for project management.

5)Quip : it's useful for integration of

spreadsheets into shared documents.

Which economic system is based on an idea of equality of result; that regardless of how well off somebody starts, all
should be guaranteed an equal success?
O A. Traditional
B. Command
OC. Mixed
D. Market

Answers

B. Command

What your describing sounds a lot like communism which would be found under a command economic system

Answer:

D.Market

Explanation:

A market economy conforms to formal equality of opportunity only if jobs offered by business firms are publicized in advance, so that anyone who might want to apply has a reasonable opportunity to do so.

If the country wants to move from its current point and produce 10 more tons of food, it must produce...

O 5 more tons of clothing

O 5 fewer tons of clothing

10 more tons of clothing

O 10 fewer tons of clothing

Answers

5 fewer tons of clothing

3. Why are people who are unemployed but not looking for work not included in
the unemployment figures? (Hint: think of teenagers)
Need help due TODAY

Answers

Answer:

Because they don't keep track on it.

Explanation:

Basically they are just included in it because they don't keep track of it. Hope that helps!

While using a debit card increases the speed and efficiency of business transactions, what effect can this have on a person's money management skills?

Answers

Often, using a debit card doesn’t feel like you are using real money, because it is so simple and efficient. This can cause people to buy more than they have in their checking account, often resulting in overdraft fees and poor budgeting.

The person can set his or her financial goal and this will result in preplanning the funds. This makes the platform an easy target to transact with and more efficient.

What is a financial goal?

A financial goal is an objective or plan for handling money. It is a function of how much money you make, spend, save, or invest. Depending on their need for a financial objective, such as pension planning, a person or individual might define their own financial goals.

The person who is a using debit card or a credit card. This would help the person in maintaining their efficiency and a budget. They can even set a limit through which they can be allowed to transit.

Also, they can use ODIs which is overdraft as well as bills receivable. This would increase their efficiency and money management.

Learn more about financial goal, here:

https://brainly.com/question/28302353

#SPJ2

The user growth rate of a social media platform decreased by 15% per month. On January 1, the platform had 20 million users. If growth decreases at 15% each month, how many will it have by year end?

Answers

Answer:

2.844835 million current users

Explanation:

20 million x .85 x .85 x .85 x .85 x .85 x .85 x .85 x .85 x .85 x .85 x .85 x .85

DO you like Anne with an E?​

Answers

Answer:

meh

Explanation:

it's okay. I kind of don't like how they stayed from the book but all the scenes were shot beautifully, and the actors did great. I only watched a few so I cant give more than a "meh" but I do like what I'm seeing so far

2) On the basis of the calculations you have made, explain which location Saber should
choose.

Answers

Answer:

Explanation:

physical attributesphysical attributesphysical attributesphysical attributesphysical attributesphysical attributesphysical attributesphysical attributesphysical attributes

Click this link to view O*NET's Tasks section for Actors.
Note that common tasks are listed toward the top, and less common tasks are listed toward the bottom. According to
O*NET, what are common tasks performed by Actors? Check all that apply.
creating artwork for use in stage sets
collaborating with other actors
working closely with directors, other actors, and playwrights to find the interpretation suited to the role
studying and rehearsing roles from scripts
learning about characters in scripts and their relationships to each other
teaching college classes and training other people how to become actors

Answers

Answer: B C D E

Explanation:

Did the assignment

To find the interpretation suited to the role, studying and rehearsing roles from scripts, learning about characters in scripts and their relationships to each other and teaching college classes and training other people how to become actors are common tasks performed by Actors. Hence, options B, C, D and E are correct.

Who is a director of a movie?

The directors are the movie's creative leaders. They uphold the artistic vision throughout pre-production and final editing. They are employed by the executive producer or producer, who is ultimately in control of a production.

A film director's responsibilities include reading and editing scripts, overseeing the cast and crew, and putting the final product together. The actors and other crew members will work with you to ensure that the movie ultimately reflects the aesthetic vision for the finished result.

Thus, options B, C, D and E are correct.

For more details about director of a movie, click here:

https://brainly.com/question/12107544

#SPJ5

What are three ways to discover how to involved in your chosen career field

Answers

Answer:

Research industry information. ...

Find out about professional associations. ...

Research career options using LinkedIn.

Place the steps for proper lifting technique in the correct order. --Select-- --Select-- --Select- --Select-- --Select- --Select-​

Answers

Answer:hold up

Explanation:

Which of the following tips can help you avoid electrical
shock from a computer? (Select three answers.)
Unplug the computer before performing maintenance.
| Keep liquids away from the computer.
Open up the computer while it is turned on to see
what's wrong.
D Use only the keyboard and not the mouse when
performing maintenance.
Make sure the computer doesn't have worn out wiring.
Wash the inside of the computer with water to keep it clean.

Answers

Answers:


1) Unplug the computer before preforming maintenance.

2) Keep liquids away from computer.

3) Make sure the computer doesn’t have a worn out wiring.


I hope this helped :)

Which of the following explains how revenue is determined?

A. The total amount of money brought in by sales.

B. Gross domestic product is calculated.

C. Costs are subtracted from revenues.

D. The maximum level of benefits is figured.​

Edit: Its not C

Answers

Answer:

A. The total amount of money brought in by sales.

HELP ME PLEASE!!!
when is it usually best to choose a variable rate home mortgage?
A. if you plan to stay there many years.
B. if you plan to stay there a short time before moving again.
C. if you plan to rent it out.
D. if you plan to have a large family.

Answers

Answer:

A...............maybe D

Understanding the legal ramifications what types of policies should organizations implement when using social media tools for recruitment

Answers

Answer:

Social media is a vital tool for online recruitment in the large MNCs now-a-days.

Explanation:

In the recent, there is a trend of recruiting the new professionals through various online platforms and other social media tools.

With social media many legal consideration comes into account. The organizations while handling social media tools for recruitment has to look on various important points while posting their advertisement and collecting the data of the candidates online. There are severe legal ramifications on using social media in a wrong way, so organization have to be ethical while using them.

Firstly, they should respect the privacy of the social media communities.Professionalism and rules of ethics should be applied.They should respect the copyright laws.

Besides individuals, who else pays taxes in our country?

Answers

Answer:

Aliens?

Explanation:

review of the nigerian economy​

Answers

Answer:

amazing

Explanation:


Nigeria's economic freedom score is 57.2, making its economy the 116th freest in the 2020 Index. Its overall score has decreased by 0.1 point, reflecting a decline in the fiscal health score.
Other Questions
Write the sentence as an equation.251 is equal to m reduced by 119 The discipline archeology evolved from antiquarianism -old / traditional archeology processual -post processual- modern archaeology.a)true b)false Samantha Powers received an order from her commanding officer to report for duty at the Sunshine State Air Force base on Tuesday at 9 AM. Samantha decided she was hungry and went to a coffee shop instead. She finally reported 3 hours late. But by then her commanding officer had already reported her for failure to report. What type of law does this represent? THIS IS A MULTIPLE CHOICE QUESTION!Corey, Billy, and Shea own a house repair and update business. The number of hours that each person spent painting and doing repair work on the same house is listed below. Corey: 4.25 hours Billy: 7.75 hours Shea: 10.5 hoursThey earned a total of $1,100 for the job and put 25% of the money earned in an account for future expenses. If they divide the money proportionally based on the number of hours each worked, how much money did Shea receive?A.$385B.$412.50C.$413.33D.$641.77Please show ALL of your work. is our gain also our loss whats the central idea of the story Interest of 200 million dollars 53% and 22 years will give brainliest to correct answer Let FICA tax rates be 7.65% on the first $127,200 of income from wages, and 1.45% on any income from wages in excess of $127,200. Her FICA tax is? How much 2.0 M NaCl solution would you need to make 250 mL of 0.15 M NaCl solution? Predict: In each "Climate type" box, Highlight the condition you think will lead to the fastest weathering for the given weathering type.Weathering typeClimate typeFrost wedgingHotColdWetDryClay formationHotColdWetDryDissolvingHotColdWetDry Polar bears eat 8.4 pounds of fish a day. Penguins eat about 0.80 of that amount. How many pounds if fish do penguins eat? What is the opposite of 56?What is the value of (-4)? How can the executive branch of the federal government influence states to change their education policies? a contemporary technique in art that uses junk materials in art production An airplane is flying S40E at an airspeed of 310 miles per hour, while the wind is blowing 97 miles per hour with an angle of N55W. Find the resultant speed, to the nearest tenth, and the direction, to the nearest tenth of the plane. Many studies have found that vegetarianism has important health benifits for example a vegetarian diet is connected to lower rates It is estimated that the annual sales of an energy saving device will be 20,000 the first year and increase by 10,000 per year unitl 50,000 units are sold during the fourth year. Proposal A is to purchase manufacturing equipment costing $120,000 with an estimated salvage value of $15,000 at the end of 4 years.Proposal B is to purchase equipment costing $280,000 with an estimated salvage value of $32,000 at the end of 4 years. The variable manufacturing cost per unit under proposal A is estimated to be $8,00, but is estimated to be only $2.60 under proposal B. If the interest rate is 9%, which proposal should be accepted for a 4-year production horizon? - A unicycle tire has a radius of 13 inches. About how far will the unicycle travel in 20 rotations?F.1633 inchesG.10,613 inchesH.82 inchesJ.520 inches How do traditional economies decide what to produce Can anyone help me with this assignment? Will give Brainliest. what is the main difference between vertebrates and invertebrates