Estimating the value of sales

Reference no: EM1347218

1. Open the excel file and click on the data worksheet. Use the SUMIF function to calculate 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)

Reference no: EM1347218

Questions Cloud

Determine cost of internal equity capital : The common stock for Grapevine Plumbing Corporation currently sells for 40 dollar per share. If a new issue is sold, flotation cost is estimated to be 7 dollar per share. Determine the cost of internal equity capital & external equity capital.

At what time t is the angular speed zero : The street automobile with the greatest acceleration is the Tempest. It has an acceleration of 6.89m/s2. Suppose the car accelerates from the rest to a final speed of 96.5km/h. How long does it take Tempest to reach this speed.

Explain why is the law of supply and demand in applicable : Explain why is the law of supply and demand in applicable without a ceteris paribus assumptions.

Methods for information systems can become vulnerable : While word weakness seems to define it pretty well, there are a number of mthods that information systems can become vulnerable.

Estimating the value of sales : Use the SUMIFS function to estimate the value of sales for every type of inventory for a prticular function. Please note that length of your different ranges must be identical.

Compute the regular expenditure multiplier : Compute the regular expenditure multiplier also the net tax multiplier if the level of consumption increases from $80,000 to $92,000 as a result of change in income from $120,000 to $140,000.

Find the polarization direction of the unmarked polarizer : If you had a single polarizer, how might you determine whether or not light from a room light was polarized when emitted from the bulb.

Elucidate what will be price of your jersey in los angeles : Elucidate what will be the price of your jersey in Los Angeles and what will be the price in Brooklyn. What will be your total profits.

What is the electric potential energy u of the system : imagine that each person is about the same distance from the center of the field and can generate the same level of sound intensity. How many people are at game.

User Account

All Pages