Ask Question, Ask an Expert

+1-415-315-9853

info@mywordsolution.com

Ask Basic Finance Expert

1. Open the excel file and click on the data worksheet. Use the SUMIF function to find out the total amount of sales in dollars (A/R Change) for each of the four types (Blue, Red, etc) This should match these totals.
August Sales in Dollars by Type
Blue $33,090.89
Green $36,701.39
Red $37,061.09
White $43,480.92
Total $150,334.29

2. Use the SUMIFS function to determine the amount of sales for each type of inventory (Blue, Red, Etc.) for a specific function. Please note that the length of your different ranges must be identical. Ranges have to go to row 6520 or longer.date during August 2010.

3. Use the Drop Down List feature and the SUMIFS function to determine the amount of dollar sales for each type of inventory (Blue, Red, etc.) for any customer for the month. ( Don't use pivot table for customer list use a range reference)

 

Basic Finance, Finance

  • Category:- Basic Finance
  • Reference No.:- M927920

Have any Question? 


Related Questions in Basic Finance

1 a firm is considering the purchase of a machine which

1. A firm is considering the purchase of a machine which would represent an investment of $32 million, and would be depreciated in a straight-line basis over 3 years. Sales are expected to be $12 million per year, and op ...

1 graphically explain cost-push and demand pull inflation2

1. Graphically explain Cost-push and Demand pull inflation. 2. What is meant by Effective Exchange rate? Explain with examples how Nominal and Real Effective exchange rate are measured in an economy. 3. Define Purchasing ...

There is an old saying on wall street sell in may and go

There is an old saying on Wall Street: "Sell in May and Go Away." This saying means that stock prices typically do not do well over the summer months. A blogger at the Wall Street Journal explains the reasoning: What's u ...

1 researchers who use group designs replicate their

1. Researchers who use group designs replicate their findings by repeating the same (or a similar) experiment on other samples of participants. How do single-case researchers replicate their findings? 2. What is the rati ...

After reading concept four write a 2-4 page paper

After reading Concept Four, write a 2-4 page paper discussing the issues and outcomes of Alpha Health Systems (AHS), giving a brief overview of its initial implementation of a corporate finance-based capital allocation p ...

What are the various ways in which an individual may obtain

What are the various ways in which an individual may obtain the right to go on to the floor of an exchange and trade futures? What are daily price limits, and why are they used? What are circuit breakers? What are their ...

Suppose that you wish to buy stock and protect yourself

Suppose that you wish to buy stock and protect yourself against a downside movement in its price. You consider both a covered call and a protective put. What factors will affect your decision? You have inherited some sto ...

Use secondary sources to write a report about typing skills

Use secondary sources to write a report about typing skills. You are the director of training for an aerospace firm located in Seattle. Your manager, Charles R. Underwood, vice president of human resources, is concerned ...

1 how can strategic procurement contribute to the quality

1. How can strategic procurement contribute to the quality of products produced by a manufacturing organization? 2. Explain the rationale underlying volume consolidation. What are the risks associated with using a single ...

Grind co is considering replacing an existing machine the

Grind Co. is considering replacing an existing machine. The new machine is expected to reduce labor costs by $153,000 per year for 5 years. Depreciation on the new machine is $124,000 compared with $86,000 on the old mac ...

  • 4,153,160 Questions Asked
  • 13,132 Experts
  • 2,558,936 Questions Answered

Ask Experts for help!!

Looking for Assignment Help?

Start excelling in your Courses, Get help with Assignment

Write us your full requirement for evaluation and you will receive response within 20 minutes turnaround time.

Ask Now Help with Problems, Get a Best Answer

Section onea in an atwood machine suppose two objects of

SECTION ONE (a) In an Atwood Machine, suppose two objects of unequal mass are hung vertically over a frictionless

Part 1you work in hr for a company that operates a factory

Part 1: You work in HR for a company that operates a factory manufacturing fiberglass. There are several hundred empl

Details on advanced accounting paperthis paper is intended

DETAILS ON ADVANCED ACCOUNTING PAPER This paper is intended for students to apply the theoretical knowledge around ac

Create a provider database and related reports and queries

Create a provider database and related reports and queries to capture contact information for potential PC component pro

Describe what you learned about the impact of economic

Describe what you learned about the impact of economic, social, and demographic trends affecting the US labor environmen