Forecast Sales Volume and Sales Budget For 20Y8, Raphael Frame Company prepared

Question

Forecast Sales Volume and Sales Budget For 20Y8, Raphael Frame Company prepared the sales budget that follows At the end of December 20Ya, the following unit sales data were reported for the year: Unit Sales 8" x 10 12" x 16" East Central West 24,205 6,363 5,723 12,896 3,038 2,142 Raphael Frame Company Sales Budget For the Year Ending December 31, 20YB Unit Sales Volume Unit Selling Total Sales Price Product and Area 8" x 10 Frame East Central West Total 23,500 6,300 5,900 35,700 $775,500 207,900 194,700 $1,178,100 SJJ 12" x 16" Frame: East Central West Total 12,400 3,100 2,100 17,600 $49 49 48 $595,200 148,800 100,800 $344,800 $2,022,900 Total revenue from sale For the year ending December 31, 20Y9, unit sales are expected to follow the patterns established during the year ending December 31, 20Y8. The unit selling price for the 8" x10" frame is expected to increase to $34 and the unit selling price for the 12" × 16' frame is expected to Increase to $50, effective January 1, 20Y9

Explanation / Answer

Step 1 - Calculation of Increase or decrease of actual Unit Sales.

Step 2 - Unit Sales Volume Calculation for December 20Y9

Step 3 - Sales Budget Preparation

Raphael Frame Company

Sales Budget

For the December Year Ending 20Y9

Total Revenue from sales

(A + B)

Particulars Unit Sales Unit Sales Actual Over budget Actual Over Budget Budget Actual Sales Difference Percent 8x10 Frame East 23500 24205 705 3% Central 6300 6363 63 1% West 5900 5723 -177 -3% 10x16 Frame East 12400 12896 496 4% Central 3100 3038 -62 -2% West 2100 2142 42 2%

Related Questions

Navigate

• Browse (All)
• Browse F
• Subjects

---