Concept explainers
Sales, production, direct materials purchases, and direct labor cost budgets
The budget director of Royal Furniture Company requests estimates of sales, production, and other operating data from the various administrative units every month. Selected information concerning sales and production for February is summarized as follows:
Estimated sales of King and Prince chairs for February by sales territory:
Estimated inventories at February 1:
Desired inventories at February 28:
Direct materials used in production:
Anticipated purchase price for direct materials:
Direct labor requirements:
Instructions
Prepare a sales budget for February.
Prepare a production budget for February.
Prepare a direct materials purchases budget for February.
Prepare a direct labor cost budget for February.
1.
Prepare the sales budget for the month ending February 28.
Explanation of Solution
Budgeting:
Budgeting is a process to prepare the financial statement by the manager to estimate the organization’s future actions. It is also helpful to satisfy the everyday activities.
The following table shows the sales budget.
Company R Sales Budget For the Month Ending February 28 | |||
Product and Area | Unit Sales Volume | Unit Selling Price ($) | Total Sales ($) |
(A) | (B) | (A) × (B) | |
King: | |||
Northern Domestic | 610 | 780 | 475,800 |
Southern Domestic | 340 | 780 | 265,200 |
International | 360 | 850 | 306,000 |
Total | 1,310 | 1,047,000 | |
Prince: | |||
Northern Domestic | 750 | 550 | 412,500 |
Southern Domestic | 440 | 550 | 242,000 |
International | 290 | 600 | 174,000 |
Total | 1,480 | 828,500 | |
Total Revenue from Sales | 1,875,500 |
Table (1)
2.
Prepare the production budget for the month ending February 28.
Explanation of Solution
The following table shows the production budget.
Company R Production Budget For the Month Ending February 28 | ||
Details | Units | |
King | Prince | |
Expected Units to be Sold | 1,310 | 1,480 |
Add: Desired Inventory, February 28 | 80 | 35 |
Total Units Required | 1,390 | 1,515 |
Less: Estimated Inventory, February 1 | (90) | (25) |
Total Units to be Produced | 1,300 | 1,490 |
Table (2)
3.
Prepare the direct materials purchase budget for the month ending February 28.
Explanation of Solution
The following table shows the direct materials purchase budget.
Company R Direct Materials Purchase Budget For the Month Ending February 28 | ||||
Details | Units | |||
Fabric | Wood | Filler | Springs | |
Required units for production: | ||||
King | 7,800 (1) | 49,400 (2) | 5,460 (3) | 20,800 (4) |
Prince | 5,960 (5) | 38,740 (6) | 5,066 (7) | 17,880 (8) |
Add: Desired inventory, February 28 | 390 | 650 | 300 | 540 |
Total units required | 14,150 | 88,790 | 10,826 | 39,220 |
Less: Estimated inventory, February 1 | (420) | (580) | (250) | (660) |
Total units to be purchased (A) | 13,730 | 88,210 | 10,576 | 38,560 |
Unit price (B) | $12 | $7 | $3 | $4.50 |
Total (A) × (B) | $164,760 | $617,470 | $31,728 | $173,520 |
Total direct materials to be purchased | 987,478 |
Table (3)
Working Note (1):
Calculate the direct material (fabric) for king.
Working Note (2):
Calculate the direct material (wood) for king.
Working Note (3):
Calculate the direct material (filler) for king.
Working Note (4):
Calculate the direct material (springs) for king.
Working Note (5):
Calculate the direct material (fabric) for prince.
Working Note (6):
Calculate the direct material (wood) for prince.
Working Note (7):
Calculate the direct material (filler) for prince.
Working Note (8):
Calculate the direct material (springs) for prince.
4.
Prepare the direct labor cost budget of Company R.
Explanation of Solution
The following table shows the direct labor cost budget for framing, cutting, and upholstery department.
Company R | |||
Direct Labor Cost Budget | |||
For the Month Ending February 28 | |||
Particulars | Framing Department |
Cutting Department |
Upholstery Department |
Hours Required for Production: | |||
King | 1,560 (9) | 650 (10) | 1,040 (11) |
Prince | 1,490 (12) | 596 (13) | 894 (14) |
Total Hours Required (A) | 3,050 | 1,246 | 1,934 |
Hourly Rate (B) | $12 | $14 | $15 |
Total Cost (A) × (B) | $36,600 | $17,444 | $29,010 |
Total Direct Labor Cost | 83,054 |
Table (4)
Working Note (9):
Calculate the hours required for the production of king in framing department.
Working Note (10):
Calculate the hours required for the production of king in cutting department.
Working Note (11):
Calculate the hours required for the production of king in upholstery department.
Working Note (12):
Calculate the hours required for the production of prince in framing department.
Working Note (13):
Calculate the hours required for the production of prince in cutting department.
Working Note (14):
Calculate the hours required for the production of prince in upholstery department.
Want to see more full solutions like this?
Chapter 8 Solutions
Managerial Accounting
- 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.arrow_forwardBudgeted 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.arrow_forwardBudgeted 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.arrow_forward
- Budgeted income statement and supporting budgets for three months Bellaire Inc. gathered the following data for use in developing the budgets for the first quarter (January, February, March) of its fiscal year: Estimated sales at 125 per unit: Estimated finished goods inventories: Work in process inventories are estimated to be insignificant (zero). Estimated direct materials inventories: Manufacturing costs: Selling expenses: Instructions Prepare the following budgets using one column for each month and a total column for the first quarter, as shown for the sales budget: 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. Prepare a selling and administrative expenses budget for March. Prepare a budgeted income statement with budgeted operating income for March.arrow_forwardBudget performance reports for cost centers Partially completed budget performance reports for Delmar Company, a manufacturer of light duty motors, follow: a. Complete the budget performance reports by determining the correct amounts for the lettered spaces. b. Compose a memo to Randi Wilkes, vice president of production for Delmar Company, explaining the performance of the production division for June.arrow_forwardOperating 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.arrow_forward
- GHT Tech Inc. sells electronics over the Internet. The Consumer Products Division is organized as a cost center. The budget for the Consumer Products Division for the month ended January 31 is as follows: During January, the costs incurred in the Consumer Products Division were as follows: Instructions 1. Prepare a budget performance report for the director of the Consumer Products Division for the month of January. 2. For which costs might the director be expected to request supplemental reports?arrow_forwardDigital 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.arrow_forwardBudgeted 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.arrow_forward
- Production budget Healthy Measures Inc. produces a Bath and Gym version of its popular electronic scale. The anticipated unit sales for the scales by sales region are as follows: The finished goods inventory estimated for March 1, for the Bath and Gym scale models is 11,800 and 8,100 units, respectively. The desired finished goods inventory for March 31 for the Bath and Gym scale models is 15,000 and 7,500 units, respectively. Prepare a production budget for the Bath and Gym scales for the month ended March 31.arrow_forwardThe sales department of F. Pollard Manufacturing Co. has forecast sales in March to be 20,000 units. Additional information follows: Materials used in production: Prepare the following: a. A production budget for March (in units). b. A direct materials budget for the month (in units and dollars).arrow_forwardFlexible budget for factory overhead Presented below are the monthly factory overhead cost budget (at normal capacity of 5,000 units or 20,000 direct labor hours) and the production and cost data for a month. The predetermined overhead rate is based on normal capacity. Required: 1. Assuming that variable costs will vary in direct proportion to the change in volume, prepare a flexible budget for production levels of 80%, 90%, and 110% of normal capacity. Also determine the predetermined factory overhead rate at each level of volume in both units and direct labor hours. 2. Prepare a flexible budget for production levels of 80%, 90%, and 110%, assuming that variable costs will vary in direct proportion to the change in volume, but with the following exceptions. (Hint: Set up a third category for semi-variable expenses.) a. At 110% of capacity, another supervisor will be needed at a salary of 24,000 annually. b. At 80% of capacity, the repairs expense will drop to one-half of the amount at 100% capacity. c. At 80% of capacity, one part-time maintenance worker, earning 10,000 a year, will be laid off. d. At 110% of capacity, a machine not normally in use and on which no depreciation is normally recorded will be used in production. Its cost was 12,000, it has a 10-year life, and straight-line depreciation will be taken.arrow_forward
- Managerial AccountingAccountingISBN:9781337912020Author:Carl Warren, Ph.d. Cma William B. TaylerPublisher:South-Western College PubFinancial And Managerial AccountingAccountingISBN:9781337902663Author:WARREN, Carl S.Publisher:Cengage Learning,Principles of Cost AccountingAccountingISBN:9781305087408Author:Edward J. Vanderbeck, Maria R. MitchellPublisher:Cengage Learning
- Managerial Accounting: The Cornerstone of Busines...AccountingISBN:9781337115773Author:Maryanne M. Mowen, Don R. Hansen, Dan L. HeitgerPublisher:Cengage Learning