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$V$8,$ the following unit sales data were reported for the year:

For the year ending December $31,20$ Yg$,$ unit sales are expected to follow the pattems established during the year ending December $31,26$

Required:

Compute the increase or decrease of actual unit sales for the year ended December $31,20V,$ over budget. Use the minus sign to indice

$\backslash$table$[[,\backslash$table$[[$Unit Sales,$],[$Year Ended$],[20Y8$ Budget$]],\backslash$table$[[$Unit Sales,$],[$Year Ended $20$Y$8],[$Actual Sales$]],\backslash$table$[[$Increase $($Decrease$)],[$Actual Over$],[$Budget Amount$]],\backslash$table$[[$Increase $($Decrease$)],[$Actual Over$],[$Budget Percent$]]],[8{10}^{\text{'}\text{'}}$ Frame:$],[$East$,20,072,19,300,-11\mathrm{.}580,\backslash$table$[[\%$

Sales Budget

For the Year Ending Oecember $31,20Ys$

$\backslash$table$[[$Product and Area,$\backslash$table$[[$Unit Sales$],[$Velume$]],\backslash$table$[[$Unit Selling$],[$Prices$]],$Fotal Sales$],[8^{**}{10}^{**}$ frame:$],[$Exr:$,19,300,$$$15,5280,500],[$Curtaral$,4,800,15,72,000],[$Whasl$,6,400,15,66,000],[$Fotal$,28,500,,5427,500],[{12}^{**}{16}^{-}$Frame:$],[$teal:$,14,850,$s$3$a$,24,44,050$t$],[$Ceried$,6,200,39,186,000],[$West$,5,000,30,150,000],[$Tratail$,26,0000,,$s$\mathrm{.}8$d$,000],[,,,51,207,500$

$$

Prepare a sales budget for the year ending December $31,20y9.$

Raphael Frame Company

Sales Budget

For the Year Ending December $31,20Vg$

$\backslash$table$[[$Product and Area,$\backslash$table$[[$Unit$],[$Sales$],[$Volume$]],\backslash$table$[[$Unit$],[$Selling$],[$Price$]],\backslash$table$[[$Total$],[$Sales$]]],[8^{\text{'}\text{'}}{10}^{\text{'}\text{'}}$ Frame!$],[$East$,,16,$s$],[$Central$],[$West$],[$Total$],[{12}^{\text{'}\text{'}}{16}^{\text{'}\text{'}}$ Frame$],[$East$],[$Central$],[$West$],[$Total$,,,$s$[],[$Total revenue frot,,,$]]$

Prepare a sales budget for the year ending December $31,20Vg.$

Raphael Frame Company

Sales Budget

For the Year Ending December $31,20Yg$

$\backslash$table$[[$Product and Area,$\backslash$table$[[$Unit$],[$Sales$],[$Volume$]],\backslash$table$[[$Unit$],[$Selling$],[$Price$]],\backslash$table$[[$Total$],[$Sales$]]],[8^{\text{'}\text{'}}{10}^{\text{'}\text{'}}$ framei$],[$East$,,16,$s$.],[$Central$,,16,],[$West$],[$Total$],[{12}^E{16}^4$ Framer$],[$East:$,,32,$st$],[$Central$,,32,],[$West$,,32,],[$Totel$,,,],[$Total revenue from sales,,,$]]$

$\backslash$table$[[$Central$,14,800,$$$30,$$$444,000$