BUSA 2205 Real World Problem 1 You have developed a projected budget for your company: Charger Logis

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

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

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

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

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

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

Change Your Assumptions

Change the cost of goods sold assumption to 40%

Change the expenses assumption to 30%

Graph

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

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.