E$98$

$f_x,31400$

A

B

c

D

E

F

$2,128$

$3$ PART $3$

$4$ PART

$5$

Budgets

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

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

Production Budget

Materials Budget

Direct Labor Budget

Factory Overhead Budget

Seling and Administrative Budget

Cost of Goods Sold Budget

Budgeted income Statement

Cash Budget

Notes for Budgeting:

The compary wants to maintain the same number of unts in the beginning and ending imventories of work$-$in$-$process, and electrical parts while increasing the inventory of Lamp KCts to $750$ pieces and decreasing the finished goods by $20\%.$

Complete the following budgets

$1$ Prodvatian Audgar

Pierned Sales

Desired Ending Imrentory of Firished Goods Total Nineded

Less: Beginning invertory

Total Production

$[7$a$1)$

Ready

Accessibility: InvestigateExcel

File

Edit

View

Insert

Format

Tools

Data

Window

Help

AutoSave

Home

Insert

Draw

Page Layout

Formulas

Data

Review

View

Automate

${}^2$

$"$

Paste

A$1$

$\backslash$table$[[,$A$,$B$,$C$,$D$],[1,$Jiani Zhu,,,$],[2,7226,,,],[3,,,,],[4,,,,],[5,,,,],[6,,,,],[7,$How many Lamps were completed?,,,$]]$

Note: Show favorable variances as negative numbers

$\backslash$table$[[,],[,],[,\backslash$table$[[$Round dollars to two$],[$places$,$ $##$.$##$]]],[,],[,],[,],[,],[,],[,],[,],[,],[,],[,],[,],[,],[,],[,],[,],[,],[,],[,],[,],[,],[,],[,],[,],[,],[,],[,],[,],[,],[,]]$

$\{15\mathrm{.}01\}$

What was the total material price variance for the Lamp Kits purchased?

What was the material usage variance for Lamp Kits?

$\{15\mathrm{.}02\}$

What was the direct labor efficiency variance $?$

What was the direct labor rate variance?

$51$

$52$

$53$

$59$

$60$

$61$

$63$

$69$

$70$

$71$

$72$

$72$

$73$

$79$

$80$

$81$

$82$

$83$

$83$

$89$