Case 9-30 1. a. Sales budget: April May June Quarter Budgeted unit sales ..... 65,000 100,000 50,000 215,000 Selling price per unit .... × $10 × $10 × $10 × $10 Total sales ...................…
The sales budget is prepared by multiplying the expected unit sales volume for each product by its anticipated unit-selling price. As reflected in Exhibit A noted below and included in the overall Peyton Approved budget worksheet included in Appendix A, Peyton Approved expects sales volume to be 18000, 22000 and 20000 units in the month of July, August and September respectively. The budgeted sales in August exceeded July's sales units by 4000 units, however, sales declined in September by 2000 units from August. Peyten Approved budgeted sales price per units for the quarter was based on a sales price of $18 per unit. Thus, budgeted total dollars per month are 324,000 computed 18 sales price per unit, 396000 sales price per unit, and 360000 sales price per unit in July, August, and September respectively.…
In addition to the budgeted operating statement and the actual operating statement for 2010, to increase the analysis a flexible budget was created. The flexible budget adjusts revenues and expenses to the actual output level achieved. Here increased sales units could be analyzed given the budgeted rates for variable costs and fixed expenses. The flexible budget enables an analysis of the variances related to selling price, sales volume, sales mix, variable cost per unit, and total fixed costs. The breakdown of total operating income variance is attached for your reference. Below is a detailed analysis of the findings.…
Sale Direct materials Direct labor Variable manufacturing overhead Fixed manufacturing overhead Variable marketing costs Fixed marketing costs Monthly operating income $ $ $ $ $ $ $ $ 750,000.00 225,000.00 120,000.00 105,000.00 150,000.00 37,500.00 65,000.00 47,500.00 (Sale price per unit * Budgeted production) (Direct materials cost per unit * Budgeted production) (Direct labor cost per unit * Budgeted production)…
Second, consider the number of sales calls and expenses and must be included. This will give your evaluation a complete data of possible sales from quotas.…
This document presents the major components of a budget that includes the risks associated with sales forecasts, and an analysis of ethical considerations in the preparation and subsequent use of the budget. Consideration is given for the requirements of the organizations code of ethics in the use of any performance tools.…
Problem 1 1. Calculate the contribution per CD unit Selling price to CD distributor $9.00 Less: Variable cost CD Package and disk (direct material/labor) $1.25/unit Songwriter’s royalties $0.35/unit Recording artists’ royalties $1.00/unit Total variable cost 2.60 Contribution per CD unit $6.40 2. Calculate the break-even volume in CD units and dollars Total Fixed Cost: Advertising and promotion $275,000 Studio Recordings, Inc. overhead 250,000 Total $525,000 Contribution per CD unit (from #1 above) $6.40 Contribution margin ($9.00-$2.60)/$9.00=.711 or 71.1% $525,000 Break-even volume in units = $6.40 = 82,031.25 units $525,000 Break-even volume in dollars =…
Cost Volume Analysis is helpful to managers in decision-making activities such as setting prices, determining product mix, and maximizing the use of production facilities. (Kimmel, Weygandt, & Kieso, 2009) To begin Cost Volume Analysis of a potential new Snap Fitness site, the following data must be considered: (1) total fixed costs, (2) incremental variable costs, (3) monthly revenue per customer, and (4) and desired return on investment. Projected total monthly fixed costs are $6,000 -- $4,000 in operating expenses plus $2,000 in equipment rental. The Snap Fitness monthly fee is $26 per customer. It is given that the target net monthly income is $10,000. The incremental variable costs must be calculated. Using the information acquired from the recent newspaper article, it was suggested that a Snap Fitness site might require only 300 members to break even; hence, the resulting incremental variable cost could be determined by using the following formula:…
PART I—SALES ANALYSIS The J&J Corporation manufactures television sets, DVD players and MP3 players. The wholesale prices to their customers can vary from under $100 to over $1000, depending on the technical complexity of the item and the quantity purchased. Analyze the following sales data for the company in the following sections: 1. Perform calculations that are relevant to understanding company performance and product 2. What critical issue can you identify for the company by analyzing the financial data? Section 1—Sales Data for 5 years Year 1999 2000 2001 2002 2003 Section II—Sales Data for 2003 Product Line Televisions DVD Players MP3 Players Total Company Forecast $4,678,000 $25,200,000 $2,340,000 $32,218,000 Company Sales $5,946,897 $17,840,691 $5,946,897 $29,734,485 Industry Sales $310,730,000 $131,340,000 $208,430,000 $650,500,000 Company Sales $26,006,196 $27,127,246 $28,206,166 $29,008,143 $29,734,485 Industry Sales $200,460,000 $365,650,000 $450,700,000 $500,800,000 $650,500,000…
Marston Corporation manufactures disposable thermometers that are sold to hospitals through a network of independent sales agents located in the United States and Canada. The sales agents sell a variety of products to hospitals in addition to Marston’s disposable thermometer. The sales agents are currently paid an 18% commission on sales, and this commission rate was used when Marston’s management prepared the following budgeted income statement for the upcoming year. Marston Corporation Budgeted Income Statement Sales Cost of goods sold: Variable Fixed Gross margin Selling and administrative expenses: Commissions Fixed advertising expenses Fixed administrative expenses Net operating income $30,000,000 $17,400,000 2,800,000…
The information is used for planning and control purposes. The flexible budget responds to changes in activity, and performance evaluation. The flexible budget uses the same selling price and cost assumptions as the original budget. Variable and fixed costs do not change categories. The variable amounts are recalculated using the actual level of activity, which in the case of the income statement are sales units. Each flexible budget line will be discussed separately.…
We suppose the water usage, medical supplies, and purchased lab services as variable cost; employee’s salaries, benefits, and equipment depreciation as fixed cost. All revenue and costs will increase or decrease as straight-line…
A budget is a tool that helps managers to ensure that the required resources are obtained and used effectively and efficiently as the organization moves towards achievement of its objectives. The budgets are determined yearly and are based upon the previous year’s budget and variances. This paper will discuss a development of operating budget, comparison expense results with budget expectations, description of possible reasons for variances and strategies to keep results aligned with expectations, recommendation some benchmarking techniques that might improve budget accuracy.…
Sales forecasting and budgeting should be used to evaluate results of a company. They should be used as guidelines and help to set goals for an organization. Many risks…
In order to achieve an accurate projection of Net Income, we had to make a number of assumptions about the behavior of various accounts. We assumed Net Sales would grow by 20%, 15%, and 10% in 1A, 1B, and 1C, respectively. Based on prior years’ data, we assumed Cost of Sales would remain at 58% of Net Sales. We also assumed Selling, General, and Administrative Expenses would grow at 20%, 15%, and 10%, respectively. TCI will not be allowed to deduct any depreciation on the new building in 1996, but will be able to deduct 5% of the warehouse’s total cost of $2,400,000 in 1997.…