Flexible Budget for Selling and Administrative Expenses for a Service Company Digital Solutions Inc. uses flexible budgets that are based on the following data: Sales commissions 8% of sales 15% of sales $10,000 per month plus 4% of sales $50,000 per month $20,000 per month plus 30% of sales $75,000 per month. Advertising expense Miscellaneous administrative expense Office salaries expense Customer support expenses Research and development expense Prepare a flexible selling and administrative expenses budget for October for sales volumes of $500,000, $750,000, and $1,000,000. (Use E Digital Solutions Inc. Flexible Selling and Administrative Expenses Budget For the Month Ending October 31 Total sales Variable cost: Total variable cost Fixed cost: $500,000 $750,000 $1,000,000 88

Flexible Budget for Selling and Administrative Expenses for a Service Company Digital Solutions Inc. uses flexible budgets that are based on the following data: Sales commissions 8% of sales 15% of sales $10,000 per month plus 4% of sales $50,000 per month $20,000 per month plus 30% of sales $75,000 per month. Advertising expense Miscellaneous administrative expense Office salaries expense Customer support expenses Research and development expense Prepare a flexible selling and administrative expenses budget for October for sales volumes of $500,000, $750,000, and $1,000,000. (Use E Digital Solutions Inc. Flexible Selling and Administrative Expenses Budget For the Month Ending October 31 Total sales Variable cost: Total variable cost Fixed cost: $500,000 $750,000 $1,000,000 88

Principles of Cost Accounting

17th Edition

ISBN:9781305087408

Author:Edward J. Vanderbeck, Maria R. Mitchell

Publisher:Edward J. Vanderbeck, Maria R. Mitchell

Chapter7: The Master Budget And Flexible Budgeting

Section: Chapter Questions

Problem 7P: Preparing a performance report Use the flexible budget prepared in P7-6 for the 31,000-unit level...

See similar textbooks

Similar questions

Coral Seas Jewelry Company makes and sells costume jewelry. For the coming year, Coral Seas expects sales of 15.9 million and cost of goods sold of 8.75 million. Advertising is a key part of Coral Seas business strategy, and total marketing expense for the year is budgeted at 2.8 million. Total administrative expenses are expected to be 675,000. Coral Seas has no interest expense. Income taxes are paid at the rate of 40 percent of operating income. Required: 1. Construct a budgeted income statement for Coral Seas Jewelry Company for the coming year. 2. What if Coral Seas had interest payments of 500,000 during the year? What effect would that have on operating income? On income before taxes? On net income?
Variable Cost Ratio, Contribution Margin Ratio Chillmax Company plans to sell 3,500 pairs of shoes at 60 each in the coming year. Unit variable cost is 21 (includes direct materials, direct labor, variable factory overhead, and variable selling expense). Fixed factory overhead is 30,000 and fixed selling and administrative expense is 48,000. Required: 1. Calculate the variable cost ratio. 2. Calculate the contribution margin ratio. 3. Prepare a contribution margin income statement based on the budgeted figures for next year. In a column next to the income statement, show the percentages based on sales for sales, total variable cost, and total contribution margin.
Preparing a performance report Use the flexible budget prepared in P7-6 for the 31,000-unit level and the actual operating results listed below for the 31,000-unit level. Required: 1. Prepare a performance report. 2. List the major reasons why the actual operating income at 31,000 units differs from the master budget operating income at 30,000 units in Figure 7-12. 3. Given the level at which the company operated, how was its cost control? Item Direct materials: Direct labor:
Preparing a performance report Use the flexible budget prepared in P7-6 for the 29,000-unit level of activity and the actual operating results listed below for the 29,000- unit level. Required: 1. Prepare a performance report. 2. List the major reasons why the actual operating income at 29,000 units differs from the master budget operating income at 30,000 units in Figure 7-12. 3. Given the level at which the company operated, how was its cost control? Item Direct materials: Direct labor:
Operating Budget, Comprehensive Analysis Allison Manufacturing produces a subassembly used in the production of jet aircraft engines. The assembly is sold to engine manufacturers and aircraft maintenance facilities. Projected sales in units for the coming 5 months follow: The following data pertain to production policies and manufacturing specifications followed by Allison Manufacturing: a. Finished goods inventory on January 1 is 32,000 units, each costing 166.06. The desired ending inventory for each month is 80% of the next months sales. b. The data on materials used are as follows: Inventory policy dictates that sufficient materials be on hand at the end of the month to produce 50% of the next months production needs. This is exactly the amount of material on hand on December 31 of the prior year. c. The direct labor used per unit of output is 3 hours. The average direct labor cost per hour is 14.25. d. Overhead each month is estimated using a flexible budget formula. (Note: Activity is measured in direct labor hours.) e. Monthly selling and administrative expenses are also estimated using a flexible budgeting formula. (Note: Activity is measured in units sold.) f. The unit selling price of the subassembly is 205. g. All sales and purchases are for cash. The cash balance on January 1 equals 400,000. The firm requires a minimum ending balance of 50,000. If the firm develops a cash shortage by the end of the month, sufficient cash is borrowed to cover the shortage. Any cash borrowed is repaid at the end of the quarter, as is the interest due (cash borrowed at the end of the quarter is repaid at the end of the following quarter). The interest rate is 12% per annum. No money is owed at the beginning of January. Required: 1. Prepare a monthly operating budget for the first quarter with the following schedules. (Note: Assume that there is no change in work-in-process inventories.) a. Sales budget b. Production budget c. Direct materials purchases budget d. Direct labor budget e. Overhead budget f. Selling and administrative expenses budget g. Ending finished goods inventory budget h. Cost of goods sold budget i. Budgeted income statement j. Cash budget 2. CONCEPTUAL CONNECTION Form a group with two or three other students. Locate a manufacturing plant in your community that has headquarters elsewhere. Interview the controller for the plant regarding the master budgeting process. Ask when the process starts each year, what schedules and budgets are prepared at the plant level, how the controller forecasts the amounts, and how those schedules and budgets fit in with the overall corporate budget. Is the budgetary process participative? Also, find out how budgets are used for performance analysis. Write a summary of the interview.
Nozama.com Inc. sells consumer electronics over the Internet. For the next period, the budgeted cost of the sales order processing activity is 250,000 and 50,000 sales orders are estimated to be processed. a. Determine the activity rate of the sales order processing activity. b. Determine the amount of sales order processing cost associated with 30,000 sales orders.
Using High-Low to Calculate Predicted Total Variable Cost and Total Cost for Budgeted Output Refer to the information for Speedy Petes above. Assume that this information was used to construct the following formula for monthly delivery cost. TotalDeliveryCost=41,850+(12.00NumberofDeliveries) Required: Assume that 3,000 deliveries are budgeted for the following month of January. Use the total delivery cost formula for the following calculations: 1. Calculate total variable delivery cost for January. 2. Calculate total delivery cost for January.
Performance Report Based on Budgeted and Actual Levels of Production Bowling Company budgeted the following amounts: At the end of the year, Bowling had the following actual costs for production of 3,800 units: Required: 1. Calculate the budgeted amounts for each cost category listed above for the 4,000 budgeted units. 2. Prepare a performance report using a budget based on expected production of 4,000 units. 3. Prepare a performance report using a budget based on the actual level of production of 3,800 units.
Artic Camping Gears currently sells 35,000 units at $73 per unit. Its expenses are as follows: Management believes it can increase sales by 2,000 units for every $5 decrease in sales price. It also believes the additional sales will allow a decrease in direct material of $1 for each additional 2,000 units. Prepare a flexible budgeted income statement for 35,000-, 37,000-, and 39,000-unit sales.
Professional labor cost budget for a service company Based on the data in Exercise 7 and assuming that the average compensation per hour for staff is 40 and for partners is 175, prepare a professional labor cost budget for each department forLundquist Fretwell, CPAs, for the year ending May 31, 20Y8. Use the following column headings:
Cold X, Inc. uses this information when preparing their flexible budget: direct materials of $2 per unit, direct labor of $3 per unit, and manufacturing overhead of $1 per unit. Fixed costs are $35,000. What would be the budgeted amounts for 20,000 and 25,000 units?
Product costing and decision analysis for a service company Blue Star Airline provides passenger airline service, using small jets. The airline connects four major cities: Charlotte, Pittsburgh, Detroit, and San Francisco. The company expects to fly 170,000 miles during a month. The following costs are budgeted for a month: Blue Star management wishes to assign these costs to individual flights in order to gauge the profitability of its service offerings. The following activity bases were identified with the budgeted costs: The size of the companys ground operation in each city is determined by the size of the workforce. The following monthly data are available from corporate records for each terminal operation: Three recent representative flights have been selected for the profitability study. Their characteristics are as follows: Instructions Determine the fuel, crew, and depreciation cost per mile flown. Determine the cost per arrival or departure by terminal city. Use the information in (1) and (2) to construct a profitability report for the three flights. Each flight has a single arrival and departure to its origin and destination city pairs.