BUSA 2205 Real World Problem 1

You have developed a projected budget for your company: Charger Logistics. Open a blank workbook to start.

Your boss has given you the amounts below:

	June	July	August	Total
Sales	10,000	20,000	30,000
Cost of Goods Sold
Gross Margin
Expenses
Income

Formulas

1. Your boss tells you that cost of goods sold is calculated as 30% of your Sales.

2. Your boss also tells you that the expenses are calculated as 20% of your Sales.

3. You know from ACCT 2101 that Income is equal to Gross Margin minus Expenses.

4. Create and apply the formulas to complete the table above (set the worksheet up like Module 3 Chapter Project with assumptions table which includes the expense %, use absolute references in your formulas to lock in the assumptions table reference).

Create & Format

1. Using the tips and techniques outlined in the Module 1 Excel Lecture, format the spreadsheet appropriately and consistently

Change Your Assumptions

1. Change the cost of goods sold assumption to 40%

2. Change the expenses assumption to 30%

Graph

1. Pick a chart of your choice and label it using the tips and techniques in the Excel 3 lecture Free Form slide, embed the chart

2. Prepare a 3-D pie chart which graphs ONLY income for June, July, and August. Place the chart on its own sheet and make sure it is labelled using the tips and techniques in the Excel 3 lecture Free Form slide.