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

Sixx am manufacturing has a target debt-equity ratio of 065

Sixx AM Manufacturing has a target debt-equity ratio of 0.65. Its cost of equity is 15 percent, and its cost of debt is 10 percent. If the tax rate is 32 percent, what is the company's WACC?

Comment on the current credit risk assumed for each of the

Comment on the current credit risk assumed for each of the following positions. Treat them separately; that is, not combined with any other instruments. a. You are short an out-of-the-money interest rate call option. b. ...

1 what is the goal of a media partnership2 name and

1. What is the goal of a media partnership? 2. Name and describe six basic emergency management audiences. 3. What three factors do DHS and its state and local partners need to address to improve its communications with ...

Assignment pricing decisionsthis assignment will assess

Assignment: Pricing Decisions This assignment will assess competency 4. Develop a professional sales training and motivation program for an organization. Directions View the Chapter 19 - Pricing Concepts video. http://ww ...

Assignment lasa- capital budgeting techniquesas a financial

Assignment: LASA- Capital Budgeting Techniques As a financial consultant, you have contracted with Wheel Industries to evaluate their procedures involving the evaluation of long term investment opportunities. You have ag ...

Assignmenti the capital asset pricing model1write down the

Assignment I. The Capital Asset Pricing Model 1. Write down the formula for the Capital Asset Pricing Model (CAPM) and explain every variable in the model. 2. The betas for each of the assets are given in the table below ...

Assignmentglobal stock market and exchange rate

Assignment Global Stock Market and Exchange Rate Fluctuations Financial crises have short-term and long-term effects. However, most often analysts are focused only on short-term effects. In this assignment, you will be c ...

You have been asked to evaluate the effects of a new

You have been asked to evaluate the effects of a new educational video that was developed to reduce racial prejudice among adolescents. You plan to administer a pretest measure of racial attitudes to 60 adolescent partic ...

Gangland water guns company is expected to pay a dividend

Gangland Water Guns Company is expected to pay a dividend of $2.10 one year from today. If the firm's growth in dividends is expected to remain at a flat 3 percent forever, then what is the cost of equity capital (in per ...

Writing in the wall street journal vincent reinhart the

Writing in the Wall Street Journal, Vincent Reinhart, the former director of the Federal Reserve's division of monetary affairs, argued: The problem with securitization is that it dilutes individual responsibility. The m ...

  • 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