Purchase Solution

Sales budget: Compare actual with the budgeted figures

Not what you're looking for?

Ask Custom Question

Renoir Frame Company prepared the following sales budget for the current year:

Renoir Frame Company
Sales Budget
For the year ending Dec. 31, 2003

Product and Area Unit Sales Unit Selling Total Sales
Volume Price
8"X10" Frame:
East.................. $25,000 $8.00 $200,000
Central.................. 32,000 8.00 256,000
West.....................12,000 8.00 96,000
Total..................69,000 $552,000

12"X16" Frame
East.................. $20,000 $15.00 $300,000
Central.................. 25,000 15.00 375,000
West.....................10,000 15.00 150,000
Total..................55,000 $825,000
Total revenue form sales...... ............ 1,377,000

At the end of Dec. 2003, the following units sales data were reported for the year:

Unit Sales
8'X10" Frames 12"X16" Frame
East 26,125 20,600
Central 32,640 26,375
West 11,448 9,500

For the year ending Dec. 31, 2004 unit sales are expected to follow the patterns established during the year ending Dec. 31, 2003. The unit selling price for the 8"X10" frame is expected to change to $9, and the unit selling price for the 12"X16" frame is expected to decline to $13, effective Jan. 1, 2004.

Instructions:

1. Compute the increase or decrease of actual unit sales for the year ended Dec. 31, 2003, over budget. Place answers in a columnar table with the following format: (see attachment for format)

2. Assuming that the trend of sales indicated in (1) is to continue in 2004, compute the unit sales volume to be used for preparing the sales budget for the year ending Dec.31, 2004. Place your answers in a columnar table with the following format. ((see attachment for format) Round budgeted units to the nearest thousand.

3. Prepare a sales budget for the year ending Dec. 31, 2004

Attachments
Purchase this Solution
Solution Summary

Compares actual with the budgeted figures of sales.

Purchase this Solution
Free BrainMass Quizzes
MS Word 2010-Tricky Features

These questions are based on features of the previous word versions that were easy to figure out, but now seem more hidden to me.

Motivation

This tests some key elements of major motivation theories.

Organizational Behavior (OB)

The organizational behavior (OB) quiz will help you better understand organizational behavior through the lens of managers including workforce diversity.

Managing the Older Worker

This quiz will let you know some of the basics of dealing with older workers. This is increasingly important for managers and human resource workers as many countries are facing an increase in older people in the workforce

Social Media: Pinterest

This quiz introduces basic concepts of Pinterest social media

View More Free Quizzes
Related BrainMass Solutions

  • Comparing and contrast a static budget and a flexible budget

    In static budget, the figures are based on the single level of activity i.e., for the particular volume of production and actual results are compared with the budgeted figures.

  • flexible budget at three levels

    Flexible budget is prepared at the end of the period after the actual out put of level 12000 checkbooks is known. Costs are estimated on the basis of budgeted variable costs per output unit, actual quantity of output and Budgeted Fixed costs.

  • Manufacturing Overhead Cost/CVP Graph

    The flexible budget report reflects $120,000 for total budgeted manufacturing cost for the month. What is the actual level of activity achieved during the month (OR, CAN IT NOT BE Determined?)

  • Fixed and variable costs, static vs flexible, CVP analysis

    In static budget, the figures are based on the single level of activity i.e., for the particular volume of production and actual results are compared with the budgeted figures.

  • Budget and proforma income statement

    For last month, the budgeted figures were: *Nonmanufacturing expenses: $60,000 *Production volume: 11,000 drums *Sales Volume: 11,000 drums *Selling price per drum:

  • SoftGro Flexible Budgeting

    Susan Porter should recommend flexible budgeting here because it would allow Fletcher to compare SoftGro's actual selling expenses (based on current month's actual activity) with the previously budgeted selling expenses.

  • Activity-Based Management

    You should then use the flexible budget to compare actual line-by-line costs and profits with the projected figures from the static budget.

  • Calculate the flexed flexible budget & key variances

    So, why didn't profits improve with the higher activty? The best way to study this is to revise the budget to align with the activity of the period and then compare that re-sized budget (flexible budget) to actual revenues and expenses.  

  • Production budget, operating expenses, standards, operating expense budget

    Operating expenses are best budgeted on the basis of knowledge about: c. current period budget amounts. One can compare the budgeted with the actual 3.

View More Related Solutions