Sunland Inc. is preparing its annual budgets for the year ending December 31, 2025. Accounting assistants furnish the data shown below. Product JB 50 Product JB 60 Sales budget: Anticipated volume in units 480,000 240,000 Unit selling price $30 $35 Production budget: Desired ending finished goods units 36,000 18,000 Beginning finished goods units 30,000 12,000 Direct materials budget: Direct materials per unit (pounds) 2 3 Desired ending direct materials pounds 36,000 12,000 Beginning direct materials pounds 48,000 18,000 Cost per pound $3 $4 Direct labor budget: Direct labor time per unit 0.4 0.6 Direct labor rate per hour $12 $12 Budgeted income statement: Total unit cost $13 $20 An accounting assistant has prepared the detailed manufacturing overhead budget and the selling and administrative expense budget. The latter shows selling expenses of $672,000 for product JB 50 and $432,000 for product JB 60, and administrative expenses of $648,000 for product JB 50 and $408,000 for product JB 60. Interest expense is $150,000 (not allocated to products). Income taxes are expected to be 20%. (a) Prepare the sales budget for the year. | E $ JB 50 SUNLAND INC. Sales Budget $ JB 60 Total

Sunland Inc. is preparing its annual budgets for the year ending December 31, 2025. Accounting assistants furnish the data shown below. Product JB 50 Product JB 60 Sales budget: Anticipated volume in units 480,000 240,000 Unit selling price $30 $35 Production budget: Desired ending finished goods units 36,000 18,000 Beginning finished goods units 30,000 12,000 Direct materials budget: Direct materials per unit (pounds) 2 3 Desired ending direct materials pounds 36,000 12,000 Beginning direct materials pounds 48,000 18,000 Cost per pound $3 $4 Direct labor budget: Direct labor time per unit 0.4 0.6 Direct labor rate per hour $12 $12 Budgeted income statement: Total unit cost $13 $20 An accounting assistant has prepared the detailed manufacturing overhead budget and the selling and administrative expense budget. The latter shows selling expenses of $672,000 for product JB 50 and $432,000 for product JB 60, and administrative expenses of $648,000 for product JB 50 and $408,000 for product JB 60. Interest expense is $150,000 (not allocated to products). Income taxes are expected to be 20%. (a) Prepare the sales budget for the year. | E $ JB 50 SUNLAND INC. Sales Budget $ JB 60 Total

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 4PB

See similar textbooks

Similar questions

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.
Prepare a cost of goods sold budget for the Crest Hills Manufacturing Co. for the year ended December 31, 2016, from the following estimates. Inventories of production units: Direct materials purchased during the year, 854,000; beginning inventory of direct materials, 31,000; and ending inventory of direct materials, 26,000. Totals from other budgets included:
Refer to Cornerstone Exercise 8.2 for the production budgets for practice balls and match balls. Every practice ball requires 0.7 square yard of polyvinyl chloride panels, one bladder with valve (to fill with air), and 3 ounces of glue. FlashKicks policy is that 20 percent of the following months production needs for raw materials be in ending inventory. Beginning inventory in January for all raw materials met this requirement. Required: 1. Construct a direct materials purchases budget for each type of raw materials for the practice ball line for January and February of the coming year. 2. What if FlashKick decreased the ending inventory percentage to 15 percent of the next months production needs? What impact would that have on the direct materials purchases budgets prepared in Requirement 1? Refer to Cornerstone Exercise 8.1, through Requirement 1. FlashKick requires ending inventory of product to equal 20 percent of the next months unit sales. Beginning inventory in January was 3,100 practice soccer balls and 400 match soccer balls. Required: 1. Construct a production budget for each of the two product lines for FlashKick Company for the first three months of the coming year. 2. What if FlashKick wanted a production budget for the two product lines for the month of April? What additional information would you need to prepare this budget?
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?
Performance Report Based on Budgeted and Actual Levels of Production Balboa Company budgeted production of 4,500 units with the following amounts: At the end of the year, Balboa had the following actual costs for production of 4,700 units: Required: 1. Calculate the budgeted amounts for each cost category listed above for the 4,500 budgeted units. 2. Prepare a performance report using a budget based on expected (budgeted) production of 4,500 units. 3. Prepare a performance report using a budget based on the actual level of production of 4,700 units.
Pasadena Candle Inc. budgeted production of 785,000 candles for January. Wax is required to produce a candle. Assume 10 ounces of wax is required for each candle. The estimated January 1 wax inventory is 16,000 pounds. The desired January 31 wax inventory is 12,500 pounds. If candle wax costs 1.24 per pound, determine the direct materials purchases budget for January.
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.
Budgeted income statement and balance sheet As a preliminary to requesting budget estimates of sales, costs, and expenses for the fiscal year beginning January 1, 20Y9, the following tentative trial balance as of December 31, 20Y8, is prepared by the Accounting Department of Mesa Publishing Co.: Factory output and sales for 20Y9 are expected to total 3,800 units of product, which are to be sold at 120 per unit. The quantities and costs of the inventories at December 31, 20Y9, are expected to remain unchanged from the balances at the beginning of the year. Budget estimates of manufacturing costs and operating expenses for the year are summarized as follows: Balances of accounts receivable, prepaid expenses, and accounts payable at the end of the year are not expected to differ significantly from the beginning balances. Federal income tax of 35,000 on 20Y9 taxable income will be paid during 20Y9. Regular quarterly cash dividends of 0.20 per share are expected to be declared and paid in March, June, September, and December on 20,000 shares of common stock outstanding. It is anticipated that fixed assets will be purchased for 22,000 cash in May. Instructions Prepare a budgeted income statement for 20Y9. Prepare a budgeted balance sheet as of December 31, 20Y9, with supporting calculations.
Relevant data from the Poster Companys operating budgets are: Additional data: Capital assets were sold in January for $10,000 and $4,500 in May. Dividends of $4,500 were paid in February. The beginning cash balance was $60,359 and a required minimum cash balance is $59,000. Use this information to prepare a cash budget for the first two quarters of the year
Digital Solutions Inc. uses flexible budgets that are based on the following data: Prepare a flexible selling and administrative expenses budget for October for sales volumes of 500,000, 750,000, and 1,000,000.
Pasadena Candle Inc. budgeted production of 785,000 candles for January. Each candle requires molding. Assume that six minutes are required to mold each candle. If molding labor costs 18 per hour, determine the direct labor cost budget for January.