Completing this activity will help you learn to:

Determine sales budget and production budget amounts.

Extract information from a data set using Excel formulas, functions, and$/$or pivot tables.

Scenario:

Company A sells the same $15$ products in each of its $10$ regions.

The Data worksheet contains a list of products. Each appears $10$ times; once for each region.

expected sales in units, and selling price per unit.

Required:

x$$

Open spreadsheet

Complete two columns on the Data worksheet: Units to produce and Total estimated sales $($$$).$

R$1.$ Cell G$2$: Enter a formula that results in the estimated number of units to produce using the data in row $2.$

$

R$2.$ Cell I$2$: Enter a formula that results in the budgeted sales amount in dollars using the data in row $2.$

$

R$3.$ Copy down the entries in cells $G2$ and $I2$ to all other rows with data.

Steps to create a pivot table:

S$1.$ Select a cell in the data on the Data worksheet.

s$2.$ Select Insert $/$ PivotTable. The data range will automatically be inserted. A "Create PivotTable" window should appear.