Concept explainers
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:
- A. Estimated sales for July by sales territory:
Maine: | |
Backyard Chef............................. | 310 units at $700 per unit |
Master Chef............................... | 150 units at $ 1,200 per unit |
Vermont: | |
Backyard Chef............................. | 240 units at $750 per unit |
Master Chef............................... | 110 units at $1,300 per unit |
New Hampshire: | |
Backyard Chef............................. | 360 units at $750 per unit |
Master Chef............................... | 180 units at $1,400 per unit |
- B. Estimated inventories at July 1:
Direct materials: | Finished products: | ||
Grates..................... | 290 units | Backyard Chef........ | 30 units |
Stainless steel.............. | 1,500 lbs. | Master Chef........... | 42 units |
Burner subassemblies...... | 170 units | ||
Shelves.................... | 340 units |
- C. Desired inventories at July 31:
Direct materials: | Finished products: | ||
Grates......................... | 340 units | Backyard Chef........ | 40 units |
Stainless steel.................. | 1,800 lbs. | Master Chef........... | 20 units |
Burner subassemblies.......... | 155 units | ||
Shelves........................ | 315 units |
- D. Desired materials used in production
In manufacture of Backyard Chef: | |
Grates........................................ | 3 units per unit of product |
Stainless steel................................. | 24 lbs. per unit of product |
Burner subassemblies......................... | 2 units per unit of product |
Shelves....................................... | 4 units per unit of product |
In manufacture of Master Chef: | |
Grates........................................ | 6 units per unit of product |
Stainless steel................................. | 42 lbs. per unit of product |
Burner subassemblies......................... | 4 units per unit of product |
Shelves....................................... | 5 units per unit of product |
- E. Anticipated purchase price for direct materials:
Grates................. | $15 per unit |
Stainless steel.......... | $6 per lb. |
Burner subassemblies...... | $110 per unit |
Shelves.................... | $10 per unit |
- F. Desired labor requirements:
Backyard Chef: | |
Stamping Department...................... | 0.50 hr. at $ 17 per hr. |
Forming Department....................... | 0.60 hr. at $15 per hr. |
Assembly Department...................... | 1.00 hr. at $14 per hr. |
Master Chef: | |
Stamping Department...................... | 0.60 hr. at $17 per hr. |
Forming Department....................... | 0.80 hr. at $15 pr hr. |
Assembly Department...................... | 1.50 hrs. at $14 per hr. |
Instructions
- 1. Prepare a sales budget for July.
- 2. Prepare a production budget for July.
- 3. Prepare a direct materials purchases budget for July.
- 4. Prepare a direct labor cost budget for July.
1.
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.
To Prepare: The sales budget for the month ending July 31.
Explanation of Solution
The following table shows the sales budget.
Company G Sales Budget For the Month Ending July 31 | |||
Product and Area | Unit Sales Volume | Unit Selling Price ($) | Total Sales ($) |
(A) | (B) | (A) × (B) | |
Backyard Chef: | |||
M | 310 | 700 | 217,000 |
V | 240 | 750 | 180,000 |
N | 360 | 750 | 270,000 |
Total | 1,070 | 667,000 | |
Master Chef: | |||
M | 150 | 1,200 | 180,000 |
V | 110 | 1,300 | 143,000 |
N | 180 | 1,400 | 252,000 |
Total | 440 | 575,000 | |
Total Revenue from Sales | 1,242,000 |
Table (1)
2.
To Prepare: The production budget for the month ending July 31.
Explanation of Solution
The following table shows the production budget.
Company G Production Budget For the Month Ending July 31 | ||
Details | Units | |
Backyard Chef | Master Chef | |
Expected Units to be Sold | 910 | 440 |
Add: Desired Inventory, July 31 | 40 | 22 |
Total Units Required | 950 | 462 |
Less: Estimated Inventory, July 1 | (30) | (32) |
Total Units to be Produced | 920 | 430 |
Table (2)
3.
To Prepare: The direct materials purchase budget for the month ending July 31.
Answer to Problem 21.2APR
The following table shows the direct materials purchase budget.
Company G Direct Materials Purchase Budget For the Month Ending July 31 | ||||
Details | Units | |||
Grates | Stainless Steel | Burner | Shelves | |
Required units for production: | ||||
Backyard Chef | 2,760 (1) | 22,080 (2) | 1,840 (3) | 3,680 (4) |
Master Chef | 2,580 (5) | 18,060 (6) | 1,720 (7) | 2,150 (8) |
Add: Desired inventory, July 31 | 340 | 1,800 | 155 | 315 |
Total units required | 5,680 | 41,940 | 3,715 | 6,145 |
Less: Estimated inventory, July 1 | (290) | (1,500) | (170) | (340) |
Total units to be purchased (A) | 5,390 | 40,440 | 3,545 | 5,805 |
Unit price (B) | $15 | $6 | $110 | $10 |
Total (A) × (B) | $80,850 | $242,640 | $389,950 | $58,050 |
Total direct materials to be purchased | 771,490 |
Table (3)
Explanation of Solution
Working Notes:
Calculate the direct material (grates) for backyard chef.
Calculate the direct material (stainless steel) for backyard chef.
Calculate the direct material (burner) for backyard chef.
Calculate the direct material (shelves) for backyard chef.
Calculate the direct material (grates) for master chef.
Calculate the direct material (stainless steel) for master chef.
Calculate the direct material (burner) for master chef.
Calculate the direct material (shelves) for master chef.
4.
To Prepare: The direct labor cost budget of Company G.
Answer to Problem 21.2APR
The following table shows the direct labor cost budget for stamping, forming, and assembly department.
Company G | |||
Direct Labor Cost Budget | |||
For the Month Ending July 31 | |||
Particulars | Stamping Department | Forming Department |
Assembly Department |
Hours Required for Production: | |||
Backyard Chef | 460 (9) | 552 (10) | 920 (11) |
Master Chef | 258 (12) | 344 (13) | 645 (14) |
Total Hours Required (A) | 718 | 896 | 1,565 |
Hourly Rate (B) | $17 | $15 | $14 |
Total Cost (A) × (B) | $12,206 | $13,440 | $21,910 |
Total Direct Labor Cost | $47,556 |
Table (4)
Explanation of Solution
Working Notes:
Calculate the hours required for the production of backyard chef in stamping department.
Calculate the hours required for the production of backyard chef in forming department.
Calculate the hours required for the production of backyard chef in assembly department.
Calculate the hours required for the production of master chef in stamping department.
Calculate the hours required for the production of master chef in forming department.
Calculate the hours required for the production of master chef in assembly department.
Want to see more full solutions like this?
Chapter 21 Solutions
FINANCIAL & MANAGERIAL ACCT LOOSE LEAF
- 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_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
- Budget 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 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_forwardPilsner Inc. purchases raw materials on account for use in production. The direct materials purchases budget shows the following expected purchases on account: Pilsner typically pays 25% on account in the month of billing and 75% the next month. Required: 1. How much cash is required for payments on account in May? 2. How much cash is expected for payments on account in June?arrow_forward
- 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.arrow_forwardBudget performance reports for cost centers Partially completed budget performance reports for Runquist Company, a manufacturer of air conditioners, are provided below. a.Complete the budget performance reports by determining the correct amounts for the lettered spaces. b.Compose a memo to Jeff Kitchens, president of Meridian Company, explaining the performance of the Production Division for June.arrow_forwardGHT 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_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_forwardProfessional labor cost budget for a service company Based on the data in Exercise 7 and assuming that the average compensation per hour for staff is 40 and for partners is 175, prepare a professional labor cost budget for each department forLundquist Fretwell, CPAs, for the year ending May 31, 20Y8. Use the following column headings:arrow_forward
- Financial And Managerial AccountingAccountingISBN:9781337902663Author:WARREN, Carl S.Publisher:Cengage Learning,Managerial AccountingAccountingISBN:9781337912020Author:Carl Warren, Ph.d. Cma William B. TaylerPublisher:South-Western College PubManagerial Accounting: The Cornerstone of Busines...AccountingISBN:9781337115773Author:Maryanne M. Mowen, Don R. Hansen, Dan L. HeitgerPublisher:Cengage Learning
- Survey of Accounting (Accounting I)AccountingISBN:9781305961883Author:Carl WarrenPublisher:Cengage LearningPrinciples of Cost AccountingAccountingISBN:9781305087408Author:Edward J. Vanderbeck, Maria R. MitchellPublisher:Cengage Learning