$\backslash$table$[[2,7,4,4,4,4,4,7,7,4]]$

Ines ere lypothans

R$.A5$

$H_1$

$$

$($A$-$t $$

Budgeted : April$=6160$ May:$7700$ June$=7527$ juinemuly ju$75$

fr budget and anal fubgot and anal $Ju=6125$

Sale forecast April$=5635.$ May$=6300$ june$=7175.$ July$=6125$

iced high sales growth, it has struggled to jals inventory equal to $40\%$ of next month's overhead costs per month. A Tableau Dashboard is provided to aid our analysis.

Select Year $-$

Year $1$

Year $2$

Vear $3$

Year $4$

Year $5$

Year $6$

Year $7$

Year $8$

Year $9$

Year $10$

Sales Forecast $\backslash$table$[[2,7,4,4,4,4,4,7,7,4]]$

Ines ere lypothans

R$.A5$

$H_1$

$$

$($A$-$t $$

Budgeted : April$=6160$ May:$7700$ June$=7527$ juinemuly ju$75$

fr budget and anal fubgot and anal $Ju=6125$

Sale forecast April$=5635.$ May$=6300$ june$=7175.$ July$=6125$

iced high sales growth, it has struggled to jals inventory equal to $40\%$ of next month's overhead costs per month. A Tableau Dashboard is provided to aid our analysis.

Select Year $-$

Year $1$

Year $2$

Vear $3$

Year $4$

Year $5$

Year $6$

Year $7$

Year $8$

Year $9$

Year $10$

Sales Forecast

Budgeted : April$=6160$ May:$7700$ June$=7527$ july$7875$

Sale forecast April$=5635.$ May$=6300$ june$=7175.$ July$=6125$

feed high sales growth, it has struggled to jals inventory equal to $40\%$ of next month's product ent requires $4$ pounds un wevermenemen ano & nours or direct labor. Delray budgets $$12,000$ of freed overhead costs per month. A Tableau Dashboard is provided to aid our analysis.

Select Year $$

Year $1$

Year $2|||$ Year $3$

Year $4$

Yar $5$

Year $6$

Year $7$

Year $8$

Kar$9$

Year $10$

Sales Forecast & Production Budget $($In Units$)$

$18/$hr

$3$per pound

$25$ per direct

labor hr

Compowsw tme questuen by entering your answers in the tabs below.

Prey

$1$ of $3$

Next

Saved

Direct labor rate

Direct materials cost

Variable overhead rate

View on Tableau Public

Complete this question by entering your answers in the tabs below.

Req $1$

Req $2^{**}$

Req $3$A and $38$

Req $4$

For Year $7,$ prepare a direct labor budget for each month of April, May, and June. $($Enter your direct labor hours $($hrs$.)$ per unit In two decimal places.$)$

Important! Be sure to click the correct Year at the top of the dashboard.

$\backslash$table$[[$DELRAY MANUFACTURING$],[$Direct Labor Budget$],[$For April, May, and June$],[,$April,May,June,$],[$Units to produce,$6,160,7\mathrm{.}700,7\mathrm{.}525,$units$],[$Direct labor hours needed,,,,$],[,,,,],[$Cost of direct labor,,,,$]]$

eau DA $($Chapters $20-22)$

Saved

$0$

$2,000$

$4,000$

$6,000$

$8,000$

Direct materials cost

$10,000$

$12,000$

Direct labor rate

$3$

Variable overhead rate

ipped

View on Tableau Public

Share

Complete this question by entering your answers in the tabs below.

For Year $7,$ prepare a factory overhead budget for each month of April, May, and June.

Important! Be sure to click the correct Year at the top of the dashboard.

Direct labor rate

Direct materials cost

Variable overhead rate

View on Tableau Public

Complete this question by entering your answers in the tabs below.

Req $1$

Req $2$

Reji $3$A and $3$B

Req $4$

The company is considering hiring more skilled workers. These workers would increase the direct labor rate to and reduce direct labor hours required per finished good to $1\mathrm{.}5$ hours. For Year $7,$ compute the direct labor bug assuming the company $($a$)$ does not hire more skilled workers and $($b$)$ hires more skilled workers.

Importantl Be sure to click the correct Year at the top of the dashboard.

$\backslash$table$[[$DELRAY MANUFACTURING$],[$Direct Labor Budget for April$],[,$Does Not Hire,Does Hire,$],[$Units to produce,$6,160,6,160,$units$],[$Direct labor hours needed,,,$],[$Cost of direct labor,,,$]]$

DA $($Chapters $20-22)$

Saved

Direct labor rate

Direct materials cost

Variable overhead rate

ed

nces

View on Tableau Public

Complete this question by entering your answers in the tabs below.

Req $1$

Req $2$

Req $3$ A and $3$ B

Req $4$

The company is considering hiring more skilled workers. These workers would increase the direct labor rate to $$21$ per hour and reduce direct labor hours required per finished unit to $1\mathrm{.}5$ hours. How would this change to more skilled workers impact total budgeted factory overhead $($assuming the budgeted variable overhead rate is unchanged$)?$

Importantl Be sure to click the correct Year at the top of the dashboard.

Show less $4$

$\backslash$table$[[$How would this change to more skilled workers impact total budgeted factory,Answer,$],[$Overhead $($assuming the budgeted variable overhead rate is unchanged$)?,$A$,$A$]]$