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 29,870 East 13,520 Central 7,878 5,498 West 7,008 4,738 Raphael Frame Company Sales Budget For the Year Ending December 31, 20Y8 Unit Unit Sales Product and Area Selling Total Sales Volume Price g"x 10" Frame: $27 East 29,000 $783,000 Central 7,800 27 210,600 Wiest 7.300 27 197,100 44,100 $1,190,700 Total 12" x 16" Frame: $364,000 East 13,000 $28 Central 156,800 5,600 29 West 4,600 28 128,800 $649,600 Total 23,200 $1,840,300 Total revenue from sales 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 B" x 10' frame is expected to increase to $28 and the unit selling price for the 12" x 16" frame is expected to increase to $30, effective January 1, 20Y9, Required: 1. Compute the increase or decrease of actual unit sales for the year ended December 31, 20Y8, aver budget. Use the minus sign to indicate a decrease in amount and percent. Round percents to the nearest whole percent. Increase (Decrease) Actual Over Budget Unit Sales, Year Ended 20Y8 Budget Actual Sales Amount Percent 8 x 10 Frame: Esst Central West 12" x 16" Frame: Esst Central West 2. Assuming that the increase or decrease in actual sales to budget indicated in part (1) is to continue in 20Y9, compute the unit sales volume to be used for preparing the sales budget for the year ending December 31, 20Y9. Use the minus sign to indicate a decrease in percent. Round budgeted units to the nearest whole unit, Percentage 20Y8 20Y9 Increase Actual Budgeted Units (rounded) Units (Decrease) g*x 10 Frame: East Central West 12" x 16" Frame: East Central West 3. Prepare a sales budget for the year ending December 31, 20Y9. Raphael Frame Company Sales Budget For the Year Ending December 31, 20Y9 Unit Sales Volume Unit Selling Price Total Sales Product and Aren 8x 10 Frame: Fast Central West Total 12 x 16" Frame: East Central West Total Total revenue from sales Q00 00 0odal oodld
Master Budget
A master budget can be defined as an estimation of the revenue earned or expenses incurred over a specified period of time in the future and it is generally prepared on a periodic basis which can be either monthly, quarterly, half-yearly, or annually. It helps a business, an organization, or even an individual to manage the money effectively. A budget also helps in monitoring the performance of the people in the organization and helps in better decision-making.
Sales Budget and Selling
A budget is a financial plan designed by an undertaking for a definite period in future which acts as a major contributor towards enhancing the financial success of the business undertaking. The budget generally takes into account both current and future income and expenses.
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:
Trending now
This is a popular solution!
Step by step
Solved in 3 steps with 3 images