Base Data:

Budgeted Direct Materials Cost per Unit $15.00

Budgeted Direct Manufacturing Labor per Unit $10.00

Budgeted Manufacturing Overhead per Unit $5.00

This is Next Year's Budgeted Data

Budged Sales Price per Unit $20.00

Budgeted Sales in Units 15000 units

Target Ending Finished Goods Inventory in UNITS 2500 units

Target Beginning Finished Goods Inventory in UNITS 1850 units

Target Ending Direct Materials Inventory in UNITS 8500 units

Target Beginning Direct Materials Inventory in UNITS 6500 units

Note: It takes one unit of direct materials to make on production unit

With the above data solve the following questions using excel formulas

1. How many units should be produced next year?

2. What is the dollar amount budgeted for direct material purchased for next year?

3. What is the budgeted revenues for next year?