Forecast sales volume and sales budget

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

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

Line Item Description Unit Sales

$8"\backslash$times $10"$

Frame Unit Sales

$12"\backslash$times $16"$

Frame

East $29,56115,080$

Central $7,5753,430$

West $6,6242,369$

Raphael Frame Company

Sales Budget

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

Product and Area Unit Sales

Volume Unit Selling

Price Total Sales

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

East $28,700$ $$28$ $$803,600$

Central $7,50028210,000$

West $6,90028193,200$

Total $43,100$ $$1,206,800$

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

East $14,500$ $$29$ $$420,500$

Central $3,50029101,500$

West $2,3002966,700$

Total $20,300$ $$588,700$

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

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

Required:

Question Content Area

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

Line Item Description Unit Sales,

Year Ended

$20$Y$8$ Budget Unit Sales,

Year Ended $20$Y$8$

Actual Sales Increase $($Decrease$)$

Actual Over

Budget Amount Increase $($Decrease$)$

Actual Over

Budget Percent

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

East fill in the blank $1$ of $24$

fill in the blank $2$ of $24$

fill in the blank $3$ of $24$

fill in the blank $4$ of $24$

$\%$

Central fill in the blank $5$ of $24$

fill in the blank $6$ of $24$

fill in the blank $7$ of $24$

fill in the blank $8$ of $24$

$\%$

West fill in the blank $9$ of $24$

fill in the blank $10$ of $24$

fill in the blank $11$ of $24$

fill in the blank $12$ of $24$

$\%$

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

East fill in the blank $13$ of $24$

fill in the blank $14$ of $24$

fill in the blank $15$ of $24$

fill in the blank $16$ of $24$

$\%$

Central fill in the blank $17$ of $24$

fill in the blank $18$ of $24$

fill in the blank $19$ of $24$

fill in the blank $20$ of $24$

$\%$

West fill in the blank $21$ of $24$

fill in the blank $22$ of $24$

fill in the blank $23$ of $24$

fill in the blank $24$ of $24$

$\%$

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

Line Item Description $20$Y$8$

Actual

Units Percentage

Increase

$($Decrease$)20$Y$9$

Budgeted

Units $($rounded$)$

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

East fill in the blank $1$ of $18$

fill in the blank $2$ of $18$

$\%$ fill in the blank $3$ of $18$

Central fill in the blank $4$ of $18$

fill in the blank $5$ of $18$

$\%$ fill in the blank $6$ of $18$

West fill in the blank $7$ of $18$

fill in the blank $8$ of $18$

$\%$ fill in the blank $9$ of $18$

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

East fill in the blank $10$ of $18$

fill in the blank $11$ of $18$

$\%$ fill in the blank $12$ of $18$

Central fill in the blank $13$ of $18$

fill in the blank $14$ of $18$

$\%$ fill in the blank $15$ of $18$

West fill in the blank $16$ of $18$

fill in the blank $17$ of $18$

$\%$ fill in the blank $18$ of $18$

Question Content Area

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

Raphael Frame Company

Sales Budget

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

Product and Area Unit

Sales

Volume Unit

Selling

Price

Total

Sales

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

East East

$East

$East

Central Central

Central

Central

West West

West

West

Total Total

$Total

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

East East

$East

$East

Central Central

Central

Central

West West

West

West

Total Total

$Total

Total revenue from sales $Total revenue from sales