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 20Y8, the following unit sales data were reported for the year Unit Sales 8" x 10" 12" x 16" Frame Frame East Central West 33,280 8,772 7,760 13,860 3,332 2,472 Raphael Frame Company Sales Budget For the Year Ending December 31, 20Y8 Unit Selling Price Unit Sales Product and Area Total Sales Volume 8" x 10" Frame: East Central West Total 32,000 8,600 8,000 48,600 $16 16 16 $512,000 137,600 128,000 $777,600

Explanation / Answer

1 Computation of increase or decrease of actual units sale over Budget Sale for the FY Dec 31,20Y8 Unit Sale for the Year end 20Y8 Increase or Decrease Product and Area Budgeted Actual Amount % 8"*10" Frame East 32,000 33280 1,280 4% Central 8,600 8772 172 2% West 8,000 7760 -240 -3% 12"*16" Frame East 13,200 13860 660 5% Central 3,400 3332 -68 -2% West 2,400 2472 72 3% 2 Computation of Sales Budget(Units) Product and Area 20Y8 Actual Sale Units % Increase or Decrease 20Y9 Budgeted Units(Rounded) 8"*10" Frame 33280 4% 34611 East 8772 2% 8947 Central 7760 -3% 7527 West 12"*16" Frame East 13860 5% 14553 Central 3332 -2% 3265 West 2472 3% 2546 3 Computation of Sales Budget Product and Area Unit Sale Volume Unit Selling Price 8"*10" Frame 34611 $17 $588,387 East 8947 $17 $152,099 Central 7527 $17 $127,959 West 12"*16" Frame East 14553 $33 $480,249 Central 3265 $33 $107,745 West 2546 $33 $84,018

Related Questions

Navigate

• Browse (All)
• Browse F
• Subjects

---