The budget committee of Ruler Office Supply has assembled the following data. As the business manager, you must prepare the budgeted income statements for May and June. (Click the icon to view the information to prepare the budget) Before completing the budgeted income statements, compute the budgeted cost of goods sold for May and June (Round your answers to the nearest whole dollar.) June Beginning inventory Purchases Ending inventory Cost of goods available for sale Cost of goods sold May 21680 Data table a Sales in April were $44,000. You forecast that monthly sales will increase 10% in May and 2% in June - X b. Ruler Office Supply maintains inventory of $12,000 plus 20% of the sales revenues budgeted for the following month. Monthly purchases average 50% of sales revenue in that same month. Actual inventory on April 30 is $21,680 Sales budgeted for July are $55.000 c. Monthly salaries amount to $5,000 Sales commissions equal 9% of sales for that month. Combine salaries and commissions into a single figure. d. Other monthly expenses are as follows Rent expense Depreciation expense Insurance expense Income tax $3.200, paid as incurred $900 $400, expiration of prepaid amount 20% of operating income

The budget committee of Ruler Office Supply has assembled the following data. As the business manager, you must prepare the budgeted income statements for May and June. (Click the icon to view the information to prepare the budget) Before completing the budgeted income statements, compute the budgeted cost of goods sold for May and June (Round your answers to the nearest whole dollar.) June Beginning inventory Purchases Ending inventory Cost of goods available for sale Cost of goods sold May 21680 Data table a Sales in April were $44,000. You forecast that monthly sales will increase 10% in May and 2% in June - X b. Ruler Office Supply maintains inventory of $12,000 plus 20% of the sales revenues budgeted for the following month. Monthly purchases average 50% of sales revenue in that same month. Actual inventory on April 30 is $21,680 Sales budgeted for July are $55.000 c. Monthly salaries amount to $5,000 Sales commissions equal 9% of sales for that month. Combine salaries and commissions into a single figure. d. Other monthly expenses are as follows Rent expense Depreciation expense Insurance expense Income tax $3.200, paid as incurred $900 $400, expiration of prepaid amount 20% of operating income

Managerial Accounting

15th Edition

ISBN:9781337912020

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

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

Chapter8: Budgeting

Section: Chapter Questions

Problem 3PA: Budgeted income statement and supporting budgets The budget director of Birding Homes Feeders Inc.,...

See similar textbooks

Similar questions

Budgeted income statement and supporting budgets The budget director of Birding Homes Feeders Inc., with the assistance of the controller, treasurer, production manager, and sales manager, has gathered the following data for use in developing the budgeted income statement for January: Estimated sales for January: Estimated inventories at January 1: Desired inventories at January 31: Direct materials used in production: Anticipated cost of purchases and beginning and ending inventory of direct materials: Direct labor requirements: Estimated factory overhead costs for January: Estimated operating expenses for January: Estimated other revenue and expense for January: Estimated tax rate: 25% Instructions Prepare a sales budget for January. Prepare a production budget for January. Prepare a direct materials purchases budget for January. Prepare a direct labor cost budget for January. Prepare a factory overhead cost budget for January. Prepare a cost of goods sold budget for January. Work in process at the beginning of January is estimated to be 9,000, and work in process at the end of January is estimated to be 10,500. Prepare a selling and administrative expenses budget for January. Prepare a budgeted income statement for January.
Budgeted income statement and supporting budgets The budget director of Gold Medal Athletic Co., with the assistance of the controller, treasurer, production manager, and sales manager, has gathered the following data for use in developing the budgeted income statement for March: Estimated sales for March: Estimated inventories at March 1: Desired inventories at March 31: Direct materials used in production: Anticipated cost of purchases and beginning and ending inventory of direct materials: Direct labor requirements: Estimated factory overhead costs for March: Estimated operating expenses for March: Estimated other revenue and expense for March: Estimated tax rate: 30% Instructions Prepare a sales budget for March. Prepare a production budget for March. Prepare a direct materials purchases budget for March. Prepare a direct labor cost budget for March. Prepare a factory overhead cost budget for March. Prepare a cost of goods sold budget for March. Work in process at the beginning of March is estimated to be 15,300, and work in process at the end of March is desired to be 14,800. Prepare a selling and administrative expenses budget for March. Prepare a budgeted income statement for March.
Classify each of the following actions as either being associated with the financial accounting information system (FS) or the cost management information system (CMS): a. Determining the total compensation of the CEO of a public company b. Issuing a quarterly earnings report c. Determining the unit product cost using TDABC d. Calculating the number of units that must be sold to break even e. Preparing a required report for the SEC f. Preparing a sales budget g. Using cost and revenue information to decide whether to keep, or drop, a product line h. Preparing an annual statement of financial position that conforms to generally accepted accounting principles (GAAP) i. Using cost and revenue information to decide whether to invest in a new production system or not j. Reducing costs by improving the overall quality of a product k. Using a debt-equity ratio and liquidity ratios from a balance sheet to assess the likelihood of bankruptcy l. Using a public companys financial statements to decide whether or not to buy its stock
The first step in preparing the sales budget is to a. prepare a sales forecast. b. review the production budget carefully. c. assess the desired ending inventory of finished goods. d. talk with past customers. e. increase sales beyond the forecast level.
Selling and administrative expense budget and budgeted income statement Budgeted selling and administrative expenses for Scottsdale Styles Inc. in P7-4 for the year ended December 31, 2016, were as follows: Required: 1. Prepare a selling and administrative expenses budget, in good form, for the year 2016. 2. Using the information above and the budgets prepared in P7-4, prepare a budgeted income statement for the year 2016, assuming an income tax rate of 30%.
Cost of goods sold budget The controller of Pueblo Ceramics Inc. wishes to prepare a cost of goods sold budget for April. The controller assembled the following information for constructing the cost goods sold budget: Use the preceding information to prepare a cost of goods sold budget for April.
Sales, production, direct materials purchases, and direct labor cost budgets The budget director of Gourmet Grill Company requests estimates of sales, production, and other operating data from the various administrative units every month. Selected information concerning sales and production for July is summarized as follows: Estimated sales for July by sales territory: Estimated inventories at July 1: Desired inventories at July 31: Direct materials used in production: Anticipated purchase price for direct materials: Direct labor requirements: Instructions Prepare a sales budget for July. Prepare a production budget for July. Prepare a direct materials purchases budget for July. Prepare a direct labor cost budget for July.
Budgeted selling and administrative expenses for King Tire Co. In P7-2 for the year ended December 31, 2016, were as follows: Required: 1. Prepare a selling and administrative expense budget, in good form, for the year 2016. 2. Using the information above and the budgets prepared in P7-2, prepare a budgeted income statement for the year 2016, assuming an income tax rate of 40%.
Using the information for Crable and Tesch, the systems consultants in P9-3 and P9-4, prepare a budgeted income statement for the year ended December 31, 2016.
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)
Which of the following statements is not correct? A. The sales budget is computed by multiplying estimated sales by the sales price. B. The production budget begins with the sales estimated for each period. C. The direct materials budget begins with the sales estimated for each period. D. The sales budget is typically the first budget prepared.
Echo Amplifiers prepared the following sales budget for the first quarter of 2018: It also has this additional information related to its expenses: Prepare a sales and administrative expense budget for each month in the quarter ending March 31, 2018.