$8229$

PART $3$

Budgets

Division N has decided to develop its budget based upon projected sales of $29,000$ lamps at $$47\mathrm{.}00$ per lamp.

The company has requested that you prepare a master budget for the year. This budget is to be used for planning and control of operations and should be composed of:

Production Budget

Materials Budget

Direct Labor Budget

Factory Overhead Budget

Selling and Administrative Budget

Cost of Goods Sold Budget

Budgeted Income Statement

Cash Budget

Notes for Budgeting:

The company wants to maintain the same number of units in the beginning and ending inventories of work$-$in$-$process, and electrical parts while increasing the inventory of Lamp Kits to $525$ pieces and decreasing the finished goods by $20\%.$

Complete the following budgets

$1$ Production Budoet

Planned Sales

Desired Ending Inventory of Finished Goods

Total Needed

Less: Beginning Inventory

Total Production

$\{7\mathrm{.}01\}$

$5$

$6$

$7$

$8$

$9$

Ready

Accessibility: Unavailableard

Font

Alignment

Number

Cells

Editing

Sensi

$fx$

B

C

D

E

F

G

$2$ Materials Budget

Lamp Kits

Needed for Production

Desired Ending Inventory

Total Needed

Less: Beginning Inventory

Total Purchases

Cost per piece

Cost of Purchases $($Round to two places, $##$.$##$)$

$\backslash$table$[[,28,400$ units$],[,525$ units$],[,28,925$ units$],[,500$ units$],[,28425],[,$$$16\mathrm{.}32$