For $20$Y$6,$ Raphael Frame Company prepared the sales budget that follows.

At the end of December $20$Y$6,$ the following unit sales data were reported for the year:

Unit Sales

$8"\backslash$times $10"$

Frame $12"\backslash$times $16"$

Frame

East $26,56510,388$

Central $7,0043,038$

West $6,1112,448$

Raphael Frame Company

Sales Budget

For the Year Ending December $31,20$Y$6$

Product and Area

Unit Sales

Volume Unit Selling

Price

Total Sales

$8"\backslash$times $10"$ Frame:

East $25,300$ $$25$ $$632,500$

Central $6,80025170,000$

West $6,30025157,500$

Total $38,400$ $$960,000$

$12"\backslash$times $16"$ Frame:

East $9,800$ $$35$ $$343,000$

Central $3,10035108,500$

West $2,4003584,000$

Total $15,300$ $$535,500$

Total revenue from sales $$1,495,500$

For the year ending December $31,20$Y$7,$ unit sales are expected to follow the patterns established during the year ending December $31,20$Y$6.$ The unit selling price for the $8"\backslash$times $10"$ frame is expected to increase to $$26$ and the unit selling price for the $12"\backslash$times $16"$ frame is expected to increase to $$37,$ effective January $1,20$Y$7.$

Required:

Question Content Area

$1.$ Compute the increase or decrease of actual unit sales for the year ended December $31,20$Y$6,$ over budget. Use the minus sign to indicate a decrease in amount and percent. Round percents to the nearest whole percent.

Unit Sales,

Year Ended $20$Y$6$ Increase $($Decrease$)$

Actual Over Budget

Budget Actual Sales Amount Percent

$8"\backslash$times $10"$ Frame:

East fill in the blank f$8$d$3$d$4$f$94$f$8$f$069\_1$

fill in the blank f$8$d$3$d$4$f$94$f$8$f$069\_2$

fill in the blank f$8$d$3$d$4$f$94$f$8$f$069\_3$

fill in the blank f$8$d$3$d$4$f$94$f$8$f$069\_4$

$\%$

Central fill in the blank f$8$d$3$d$4$f$94$f$8$f$069\_5$

fill in the blank f$8$d$3$d$4$f$94$f$8$f$069\_6$

fill in the blank f$8$d$3$d$4$f$94$f$8$f$069\_7$

fill in the blank f$8$d$3$d$4$f$94$f$8$f$069\_8$

$\%$

West fill in the blank f$8$d$3$d$4$f$94$f$8$f$069\_9$

fill in the blank f$8$d$3$d$4$f$94$f$8$f$069\_10$

fill in the blank f$8$d$3$d$4$f$94$f$8$f$069\_11$

fill in the blank f$8$d$3$d$4$f$94$f$8$f$069\_12$

$\%$

$12"\backslash$times $16"$ Frame:

East fill in the blank f$8$d$3$d$4$f$94$f$8$f$069\_13$

fill in the blank f$8$d$3$d$4$f$94$f$8$f$069\_14$

fill in the blank f$8$d$3$d$4$f$94$f$8$f$069\_15$

fill in the blank f$8$d$3$d$4$f$94$f$8$f$069\_16$

$\%$

Central fill in the blank f$8$d$3$d$4$f$94$f$8$f$069\_17$

fill in the blank f$8$d$3$d$4$f$94$f$8$f$069\_18$

fill in the blank f$8$d$3$d$4$f$94$f$8$f$069\_19$

fill in the blank f$8$d$3$d$4$f$94$f$8$f$069\_20$

$\%$

West fill in the blank f$8$d$3$d$4$f$94$f$8$f$069\_21$

fill in the blank f$8$d$3$d$4$f$94$f$8$f$069\_22$

fill in the blank f$8$d$3$d$4$f$94$f$8$f$069\_23$

fill in the blank f$8$d$3$d$4$f$94$f$8$f$069\_24$

$\%$

$2.$ Assuming that the increase or decrease in actual sales to budget indicated in part $(1)$ is to continue in $20$Y$7,$ compute the unit sales volume to be used for preparing the sales budget for the year ending December $31,20$Y$7.$ Use the minus sign to indicate a decrease in percent. Round budgeted units to the nearest whole unit.

$20$Y$6$

Actual

Units Percentage

Increase

$($Decrease$)20$Y$7$

Budgeted

Units $($rounded$)$

$8"\backslash$times $10"$ Frame:

East fill in the blank f$8$d$3$d$4$f$94$f$8$f$069\_25$

fill in the blank f$8$d$3$d$4$f$94$f$8$f$069\_26$

$\%$ fill in the blank f$8$d$3$d$4$f$94$f$8$f$069\_27$

Central fill in the blank f$8$d$3$d$4$f$94$f$8$f$069\_28$

fill in the blank f$8$d$3$d$4$f$94$f$8$f$069\_29$

$\%$ fill in the blank f$8$d$3$d$4$f$94$f$8$f$069\_30$

West fill in the blank f$8$d$3$d$4$f$94$f$8$f$069\_31$

fill in the blank f$8$d$3$d$4$f$94$f$8$f$069\_32$

$\%$ fill in the blank f$8$d$3$d$4$f$94$f$8$f$069\_33$

$12"\backslash$times $16"$ Frame:

East fill in the blank f$8$d$3$d$4$f$94$f$8$f$069\_34$

fill in the blank f$8$d$3$d$4$f$94$f$8$f$069\_35$

$\%$ fill in the blank f$8$d$3$d$4$f$94$f$8$f$069\_36$

Central fill in the blank f$8$d$3$d$4$f$94$f$8$f$069\_37$

fill in the blank f$8$d$3$d$4$f$94$f$8$f$069\_38$

$\%$ fill in the blank f$8$d$3$d$4$f$94$f$8$f$069\_39$

West fill in the blank f$8$d$3$d$4$f$94$f$8$f$069\_40$

fill in the blank f$8$d$3$d$4$f$94$f$8$f$069\_41$

$\%$ fill in the blank f$8$d$3$d$4$f$94$f$8$f$069\_42$

Question Content Area

$3.$ Prepare a sales budget for the year ending December $31,20$Y$7.$

Raphael Frame Company

Sales Budget

For the Year Ending December $31,20$Y$7$

Product and Area Unit Sales Volume Unit Selling Price Total Sales

$8"\backslash$times $10"$ Frame:

East fill in the blank $3$c$143$b$07$a$008$fac$\_1$

$fill in the blank $3$c$143$b$07$a$008$fac$\_2$

$fill in the blank $3$c$143$b$07$a$008$fac$\_3$

Central fill in the blank $3$c$143$b$07$a$008$fac$\_4$

fill in the blank $3$c$143$b$07$a$008$fac$\_5$

fill in the blank $3$c$143$b$07$a$008$fac$\_6$

West fill in the blank $3$c$143$b$07$a$008$fac$\_7$

fill in the blank $3$c$143$b$07$a$008$fac$\_8$

fill in the blank $3$c$143$b$07$a$008$fac$\_9$

Total fill in the blank $3$c$143$b$07$a$008$fac$\_10$

$fill in the blank $3$c$143$b$07$a$008$fac$\_11$

$12"\backslash$times $16"$ Frame:

East fill in the blank $3$c