Budgeting

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.

Each row provides information about one product in one region, including estimated beginning inventory for the period, desired inventory at the end of the period, expected sales in units, and selling price per unit.

Required:

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.$

fill in the blank $1$ of $1$ $

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

fill in the blank $1$ of $1$ $