Helen is working on her department's budgeted annual income statement. In the process, she needs to determine the budgeted amount for selling, general, and administrative (SG&A) expenses in order to complete her budget. Sales Variable SG&A cost 11500 units $0.20 per unit Advertising expense $6200 per year Depreciation on office equipment $8600 per year Other fixed SG&A costs $24800 On the basis of the given data, what are total budgeted selling, general, and administrative (SG&A) expenses of the department? O $35700 O $33300 O $17100 O $41900

Helen is working on her department's budgeted annual income statement. In the process, she needs to determine the budgeted amount for selling, general, and administrative (SG&A) expenses in order to complete her budget. Sales Variable SG&A cost 11500 units $0.20 per unit Advertising expense $6200 per year Depreciation on office equipment $8600 per year Other fixed SG&A costs $24800 On the basis of the given data, what are total budgeted selling, general, and administrative (SG&A) expenses of the department? O $35700 O $33300 O $17100 O $41900

Managerial Accounting

15th Edition

ISBN:9781337912020

Author:Carl Warren, Ph.d. Cma William B. Tayler

Publisher:Carl Warren, Ph.d. Cma William B. Tayler

Chapter4: Activity-based Costing

Section: Chapter Questions

Problem 9E: Nozama.com Inc. sells consumer electronics over the Internet. For the next period, the budgeted cost...

See similar textbooks

Similar questions

Friendly Bank is attempting to determine the cost behavior of its small business lending operations. One of the major activities is the application activity. Two possible activity drivers have been mentioned: application hours (number of hours to complete the application) and number of applications. The bank controller has accumulated the following data for the setup activity: Required: 1. Estimate a regression equation with application hours as the activity driver and the only independent variable. If the bank forecasts 2,600 application hours for the next month, what will be the budgeted application cost? 2. Estimate a regression equation with number of applications as the activity driver and the only independent variable. If the bank forecasts 80 applications for the next month, what will be the budgeted application cost? 3. Which of the two regression equations do you think does a better job of predicting application costs? Explain. 4. Run a multiple regression to determine the cost equation using both activity drivers. What are the budgeted application costs for 2,600 application hours and 80 applications?
CASH BUDGETING Helen Bowers, owner of Helens Fashion Designs, is planning to request a line of credit from her bank. She has estimated the following sales forecasts for the firm for parts of 2019 and 2020: Estimates regarding payments obtained from the credit department are as follows: collected within the month of sale, 10%; collected the month following the sale, 75%; collected the second month following the sale, 15%. Payments for labor and raw materials are made the month after these services were provided. Here are the estimated costs of labor plus raw materials: General and administrative salaries are approximately 27,000 a month. Lease payments under long-term leases are 9,000 a month. Depreciation charges are 36,000 a month. Miscellaneous expenses are 2,700 a month. Income tax payments of 63,000 are due in September and December. A progress payment of 180,000 on a new design studio must be paid in October. Cash on hand on July 1 will be 132,000, and a minimum cash balance of 90,000 should be maintained throughout the cash budget period. a. Prepare a monthly cash budget for the last 6 months of 2019. b. Prepare monthly estimates of the required financing or excess fundsthat is, the amount of money Bowers will need to borrow or will have available to invest. c. Now suppose receipts from sales come in uniformly during the month (that is, cash receipts come in at the rate of 1/30 each day), but all outflows must be paid on the 5th. Will this affect the cash budget? That is, will the cash budget you prepared be valid under these assumptions? If not, what could be done to make a valid estimate of the peak financing requirements? No calculations are required, although if you prefer, you can use calculations to illustrate the effects. d. Bowers sales are seasonal, and her company produces on a seasonal basis, just ahead of sales. Without making any calculations, discuss how the companys current and debt ratios would vary during the year if all financial requirements were met with short-term bank loans. Could changes in these ratios affect the firms ability to obtain bank credit? Explain.
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.
Use the following information for Exercises 9-50 and 9-51: Assume that Stillwater Designs produces two automotive subwoofers: S12L7 and S12L5. The S12L7 sells for 475, and the S12L5 sells for 300. Projected sales (number of speakers) for the coming 5 quarters are as follows: The vice president of sales believes that the projected sales are realistic and can be achieved by the company. Exercise 9-50 Sales Budget Refer to the information regarding Stillwater Designs above. Required: 1. Prepare a sales budget for each quarter of 20X1 and for the year in total. Show sales by product and in total for each time period. 2. CONCEPTUAL CONNECTION How will Stillwater Designs use this sales budget?
Refer to Cornerstone Exercise 8.6. Required: 1. Calculate the total budgeted cost of units produced for Play-Disc for the coming year. Show the cost of direct materials, direct labor, and overhead. 2. Prepare a cost of goods sold budget for Play-Disc for the year. 3. What if the beginning inventory of finished goods was 75,200 (for 16,000 units)? How would that affect the cost of goods sold budget? (Assume Play-Disc uses the FIFO method.) Play-Disc makes Frisbee-type plastic discs. Each 12-inch diameter plastic disc has the following manufacturing costs: For the coming year, Play-Disc expects to make 300,000 plastic discs, and to sell 285,000 of them. Budgeted beginning inventory in units is 16,000 with unit cost of 4.75. (There are no beginning or ending inventories of work in process.) Required: 1. Prepare an ending finished goods inventory budget for Play-Disc for the coming year. 2. What if sales increased to 290,000 discs? How would that affect the ending finished goods inventory budget? Calculate the value of budgeted ending finished goods inventory.
A company has prepared the operating budget and the cash budget. It is now preparing the budgeted balance sheet. Identify the document that contains each of these balances. A. cash B. accounts receivable C. finished goods inventory D. accounts payable E. equipment purchases
Norton Company, a manufacturer of infant furniture and carriages, is in the initial stages of preparing the annual budget for the coming year. Scott Ford has recently joined Nortons accounting staff and is interested in learning as much as possible about the companys budgeting process. During a recent lunch with Marge Atkins, sales manager, and Pete Granger, production manager, Ford initiated the following conversation. FORD: Since Im new around here and am going to be involved with the preparation of the annual budget, Id be interested in learning how the two of you estimate sales and production numbers. ATKINS: We start out very methodically by looking at recent history, discussing what we know about current accounts, potential customers, and the general state of consumer spending. Then, we add that usual dose of intuition to come up with the best forecast we can. GRANGER: I usually take the sales projections as the basis for my projections. Of course, we have to make an estimate of what this years closing inventories will be, which is sometimes difficult. FORD: Why does that present a problem? There must have been an estimate of closing inventories in the budget for the current year. GRANGER: Those numbers arent always reliable since Marge makes some adjustments to the sales numbers before passing them on to me. FORD: What kind of adjustments? ATKINS: Well, we dont want to fall short of the sales projections so we generally give ourselves a little breathing room by lowering the initial sales projection anywhere from 5 to 10 percent. GRANGER: So, you can see why this years budget is not a very reliable starting point. We always have to adjust the projected production rates as the year progresses, and of course, this changes the ending inventory estimates. By the way, we make similar adjustments to expenses by adding at least 10 percent to the estimates; I think everyone around here does the same thing. Required: 1. Marge Atkins and Pete Granger have described the use of budgetary slack. a. Explain why Atkins and Granger behave in this manner, and describe the benefits they expect to realize from the use of budgetary slack. b. Explain how the use of budgetary slack can adversely affect Atkins and Granger. 2. As a management accountant, Scott Ford believes that the behavior described by Marge Atkins and Pete Granger may be unethical and that he may have an obligation not to support this behavior. By citing the specific standards of competence, confidentiality, integrity, and/or credibility from the Statement of Ethical Professional Practice (in Chapter 1), explain why the use of budgetary slack may be unethical. (CMA adapted)
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?
Dallus wants to examine the behaviour of maintenance costs for budgeting purpose. The following data on machine hours worked and maintenance costs for the past year are collected: Month Machine Hours Maintenance Cost January 18,000 February 15,000 March 12,750 21,000 April May June 11,880 14,500 July 19,000 August 14,880 September 10,000 October 13,360 November 16,600 December 18,800 $20,600 18,900 15,100 22,010 13,200 19,500 25,000 19,874 12,000 15,500 19,800 13,500 Required: a. Use the high-low method to estimate the variable cost per machine hour and the fixed cost per month. b. Plot and comment on the estimated cost function. C. Develop a formula to express the cost behaviour of ABC's maintenance costs. d. According to the budget, the machine is expected to work 200,000 hours next year. How much is the budgeted maintenance costs?
Can you give me the step by step answers on how to compute this: An excel spreadsheet would be amazing... ProblemThe treasurer of Bradly Lawn Equipment Company instructs you to prepare a monthly cash budget for the next three months. You are presented with the following budget information: August September OctoberSales $310,000 $390,000 $366,000Manufacturing costs 190,000 240,000 215,000Operating expenses 56,000 71,000 65,000Capital expenditures 24,000 The company expects to sell about 20% of its merchandise for cash. Of sales on account, 70% are expected to be collected in full in the month following the sale and the remainder the following month. Depreciation, insurance, and property taxes represent $20,000 of the estimated monthly manufacturing costs and $4,000 of the probable monthly operating expenses.¬ The annual insurance premium is paid in July, and the annual property taxes are paid in November. Of the remainder of the manufacturing costs and operating expenses, 80% are…
Lily Inc. is preparing its annual budgets for the year ending December 31, 2022. Accounting assistants furnish the data shown below. Sales budget: Anticipated volume in units Unit selling price Production budget: Desired ending finished goods units Beginning finished goods units Direct materials budget: Direct materials per unit (pounds) Desired ending direct materials pounds Beginning direct materials pounds Cost per pound Direct labor budget: Direct labor time per unit Direct labor rate per hour Budgeted income statement: Total unit cost Product JB 50 336,000 $25 25,200 21,000 2 25,200 33,600 $3 0.4 $12 $13 Product JB 60 168,000 $30 12,600 8,400 3 8,400 12,600 $4 0.6 $12 $20 An accounting assistant has prepared the detailed manufacturing overhead budget and the selling and administrative expense budget. The latter shows selling expenses of $470,400 for product JB 50 and $302,400 for product JB 60, and administrative expenses of $453,600 for product JB 50 and $285,600 for product JB…
Howard Cooper, the president of Campbell Computer Services, needs your help. He wonders about the potential effects on the firm's net income if he changes the service rate that the firm charges its customers. The following basic data pertain to fiscal Year 3. Standard rate and variable costs Service rate per hour $ 85.00 Labor cost 37.00 Overhead cost 7.10 Selling, general, and administrative cost Expected fixed costs Facility maintenance Selling, general, and administrative 3.80 $522,000 142,000 Required: a. Prepare the pro forma income statement that would appear in the master budget if the firm expects to provide 45,000 hours of services in Year 3. b. A marketing consultant suggests to Mr. Cooper that the service rate may affect the number of service hours that the firm can achieve. According to the consultant's analysis, if Campbell charges customers $80 per hour, the firm can achieve 50,000 hours of services. Prepare a flexible budget using the consultant's assumption. c. The same…