Explore BrainMass
Share

# Understanding Excel - Identifying Variables

This content was STOLEN from BrainMass.com - View the original, and get the already-completed solution here!

Details: Your Aunt Sally has entered all of her stuffed animal data into an Excel workbook. She took your advice and used headings to organize the information. She now wants to have the information sorted in the fields Name, Date Purchased, Purchase Price, Color, Size, and Location for each of her stuffed animals. In addition, her husband, your Uncle Bob, wants to know how much money she has invested in this hobby, and her daughter wants to know the date she started this collection.

Sally would also like to be able to quickly identify what stuffed animals were bought before the year 2000. Advise her regarding how she can accomplish these tasks.

https://brainmass.com/computer-science/sorting/understanding-excel-identifying-variables-288827

#### Solution Preview

After Aunt Sally has entered the fields:

Name
Date Purchased
Purchase Price
Color
Size
Location

She now can add the purchase price column. To do so: skip a line in the column "Purchase Price" because this will the be total Aunt Sally has invested in the stuffed animal. To total: go to the Total line in the column (see previous sentence). Select ...

#### Solution Summary

The solution shows in steps how to identify specific variables in excel by using the columns and excel tools.

\$2.19
Similar Posting

## Manager of the marketing department: develop a department budget

ACCT320-1202A-01 Intermediate Accounting II
Assignment Name: Unit 5 Individual Project
Details: As the manager of the marketing department, you are being asked for the first time to develop a department budget. The accounting department has supplied you with the following projected information about how this year, 20XX, will end up for your department's spending.
Expense category 20XX projected
Sales force base salary 200,000
Sales force commission 200,000
Sales force benefits 60,000
Free coupon expense 40,000

Note:
Sales 2,000,000
Before you begin the process, your manager and you have sat down to develop broad planning objectives for the upcoming year, which you will need to incorporate into the budget. These include
- a doubling of trade show spending.
- an increase of the sales force by 25%.
- an expected sales volume increase of 10%.
- an expected increase of 4% of all expenses due to inflation.
- no anticipated selling price changes for next year.
You need to do the following:
A. for each of the listed expenses:
- identify whether you would treat them as a fixed or variable cost
- explain the reasoning for your classification
B. based on the historical information and the planning you did for new marketing programs for the upcoming year, prepare a budget for the upcoming year by completing the table:
1. In the 20XX+1 column, fill in budgeted figures.
2. In the next column, when appropriate, adjust that amount for inflation.
3. Complete the next column based on the projected volume increase.
4. In the last column, briefly explain how you arrived at the budgeted figure.

Expense category 20XX projected 20XX+1 with plan changes 20XX+1 with inflation changes 20XX+1 with volume impact Explanation
Sales force base salary 200,000
Sales force commission 200,000
Sales force benefits 60,000
Free coupon expense 40,000

Note:
Sales 2,000,000 2,200,000

The following grading criteria will be used: