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
Bundle: Managerial Accounting, 15th + Cengagenowv2, 1 Term Printed Access Card
- 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 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_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_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_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_forwardBudgeted 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_forward
- Factory overhead cost budget Sweet Tooth Candy Company budgeted the following costs for anticipated production for August: Prepare a factory overhead cost budget, separating variable and fixed costs. Assume that factory insurance and depreciation are the only fixed factory costs.arrow_forwardGreiner Company makes and sells high-quality glare filters for microcomputer monitors. John Craven, controller, is responsible for preparing Greiners master budget and has assembled the following data for the coming year. The direct labor rate includes wages, all employee-related benefits, and the employers share of FICA. Labor saving machinery will be fully operational by March. Also, as of March 1, the companys union contract calls for an increase in direct labor wages that is included in the direct labor rate. Greiner expects to have 5,600 glare filters in inventory on December 31 of the current year, and has a policy of carrying 35 percent of the following month's projected sales in inventory. Information on the first four months of the coming year is as follows: Required: 1. Prepare the following monthly budgets for Greiner Company for the first quarter of the coming year. Be sure to show supporting calculations. a. Production budget in units b. Direct labor budget in hours c. Direct materials cost budget d. Sales budget 2. Calculate the total budgeted contribution margin for Greiner Company by month and in total for the first quarter of the coming year. Be sure to show supporting calculations. (CMA adapted)arrow_forwardUse the following information for Exercises 9-63 and 9-64: Palladium Inc. produces a variety of household cleaning products. Palladiums controller has developed standard costs for the following four overhead items: Next year, Palladium expects production to require 90,000 direct labor hours. Exercise 9-63 Flexible Budget for Various Levels of Activity Refer to the information for Palladium Inc. above. Required: 1. Prepare an overhead budget for the expected level of direct labor hours for the coming year. 2. Prepare an overhead budget that reflects production that is 15% higher than expected and for production that is 15% lower than expected.arrow_forward
- The 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_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_forwardDirect labor cost budget Ace Racket Company manufactures two types of tennis rackets, the Junior and Pro Striker models. The production budget for July for the two rackets is as follows: Both rackets are produced in two departments, Forming and Assembly. The direct labor hours required for each racket are estimated as follows: The direct labor rate for each department is as follows: Prepare the direct labor cost budget for July.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,Managerial Accounting: The Cornerstone of Busines...AccountingISBN:9781337115773Author:Maryanne M. Mowen, Don R. Hansen, Dan L. HeitgerPublisher:Cengage Learning
- Cornerstones of Cost Management (Cornerstones Ser...AccountingISBN:9781305970663Author:Don R. Hansen, Maryanne M. MowenPublisher:Cengage LearningPrinciples of Cost AccountingAccountingISBN:9781305087408Author:Edward J. Vanderbeck, Maria R. MitchellPublisher:Cengage LearningExcel Applications for Accounting PrinciplesAccountingISBN:9781111581565Author:Gaylord N. SmithPublisher:Cengage Learning