Concept explainers
The budget director of Feathered Friends Inc., with the assistance of thee controller, treasurer, production manager, and sales manager, has gathered the following data for use in developing the budgeted income statement for December:
A. Estimated sales for December
Bird house....................... | 3,200 units at $50 per unit |
Bird feeder....................... | 3,000 units at $70 per unit |
B. Estimated inventories at December 1:
Direct materials | Finished products: | ||
Wood............ | 220 ft | Bird house........ | 320 units at $27 per unit |
Plastic............ | 240 ft | Bird house........ | 270 units at $40 per unit |
C. Desired inventories at December 31:
Direct materials | Finished products: | ||
Wood............ | 220 ft | Bird house........ | 290 units at $27 per unit |
Plastic............ | 200 ft | Bird house........ | 205 units at $41 per unit |
D. Direct materials used in production:
In manufacture of Bird House: | In manufacture of Bird Feeder: | ||
Wood............ | 0.80 ft. per unit of product | Wood........ | 1.20 ft. per unit of product |
Plastic............ | 0.50 lb. per unit of product | Plastic......... | 0.75 lb. per unit of product |
E. Anticipated cost of purchases and beginning and ending inventory of direct materials:
Wood…… | $7.00 per ft |
Plastic | $1.00 per lb. |
F. Direct labor requirements:
Bird House: | |
Fabrication Department...................... | 0.20 hr. at $16 per hr. |
Assembly Department........................ | 0.30 hr. at $12 per hr. |
Bird Feeder: | |
Fabrication Department...................... | 0.40 hr. at $16 per hr. |
Assembly Department........................ | 0.35 hr. at $12 pr hr. |
G. Estimated factory overhead costs for December:
Indirect factory wages | $75,000 |
23,000 | |
Power and light | $6,000 |
Insurance and property tax | 5,000 |
H. Estimated operating expenses for December:
Sales salaries expense | $70,000 |
Advertising expense | 18,000 |
Office salaries expense | 21,000 |
Depreciation expense—office equipment | 600 |
Telephone expense—selling | 550 |
Telephone expense—administrative | 250 |
Travel expense—selling | 4,000 |
Office supplies expense | 200 |
Miscellaneous administrative expense | 400 |
I. Estimated other income and expense for December:
Interest revenue $200
Interest expense 122
J. Estimated tax rate: 30%
Instructions
- 1. Prepare a sales budget for December.
- 2. Prepare a production budget for December.
- 3. Prepare a direct materials purchases budget for December.
- 4. Prepare a direct labor cost budget for December.
- 5. Prepare a
factory overhead cost budget for December. - 6. Prepare a cost of goods sold budget for December. Work in process at the beginning of December is estimated to be $29,000, and work in process at the end of December is estimated to be $35,400.
- 7. Prepare a selling and administrative expenses budget for December.
- 8. Prepare a budgeted income statement for December.
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 December 31.
Explanation of Solution
The following table shows the sales budget.
Company F Sales Budget For the Month Ending December 31 | |||
Product and Area | Unit Sales Volume | Unit Selling Price ($) | Total Sales ($) |
(A) | (B) | (A) × (B) | |
Birdhouse | 3,200 | 50 | 160,000 |
Bird feeder | 3,000 | 70 | 210,000 |
Total Revenue from Sales | 370,000 |
Table (1)
2.
To Prepare: The production budget for the month ending December 31.
Explanation of Solution
The following table shows the production budget.
Company F Production Budget For the Month Ending December 31 | ||
Details | Units | |
Birdhouse | Bird Feeder | |
Expected Units to be Sold | 3,200 | 3,000 |
Add: Desired Inventory, December 31 | 290 | 250 |
Total Units Required | 3,490 | 3,250 |
Less: Estimated Inventory, December 1 | (320) | (270) |
Total Units to be Produced | 3,170 | 2,980 |
Table (2)
3.
To Prepare: The direct materials purchase budget for the month ending December 31.
Answer to Problem 21.3APR
The following table shows the direct materials purchase budget.
Company F Direct Materials Purchase Budget For the Month Ending December 31 | ||
Details | Units | |
Wood | Plastic | |
Required units for production: | ||
Birdhouse | 2,536 (1) | 1,585 (2) |
Bird Feeder | 3,576 (3) | 3,576 (4) |
Add: Desired inventory, December 31 | 220 | 200 |
Total units required | 6,332 | 4,020 |
Less: Estimated inventory, December 1 | (200) | (240) |
Total units to be purchased (A) | 6,132 | 3,780 |
Unit price (B) | $7 | $1 |
Total (A) × (B) | $42,924 | $3,780 |
Total direct materials to be purchased | 46,704 |
Table (3)
Explanation of Solution
Working Notes:
Calculate the direct material (wood) for birdhouse.
Calculate the direct material (plastic) for birdhouse.
Calculate the direct material (wood) for bird feeder.
Calculate the direct material (plastic) for bird feeder.
4.
To Prepare: The direct labor cost budget of Company F.
Answer to Problem 21.3APR
The following table shows the direct labor cost budget for fabrication and assembly department.
Company F | ||
Direct Labor Cost Budget | ||
For the Month Ending December 31 | ||
Particulars | Fabrication Department |
Assembly Department |
Hours Required for Production: | ||
Birdhouse | 634 (5) | 951 (6) |
Bird feeder | 1,192 (7) | 1,043 (8) |
Total Hours Required (A) | 1,826 | 1,994 |
Hourly Rate (B) | $16 | $12 |
Total Cost (A) × (B) | $29,216 | $23,928 |
Total Direct Labor Cost | $53,144 |
Table (4)
Explanation of Solution
Working Notes:
Calculate the hours required for the production of birdhouse in fabrication department.
Calculate the hours required for the production of birdhouse in assembly department.
Calculate the hours required for the production of bird feeder in fabrication department.
Calculate the hours required for the production of bird feeder in assembly department.
5.
To Prepare: The factory overhead cost budget of Company F.
Explanation of Solution
The following table shows the factory overhead cost budget.
Company F | |
Factory Overhead Cost Budget | |
For the Month Ending December 31 | |
Particulars | Amount ($) |
Indirect factory wages | 75,000 |
Depreciation of plant and equipment | 23,000 |
Power and light | 6,000 |
Insurance and property tax | 5,000 |
Total | 109,000 |
Table (5)
6.
To Prepare: The cost of goods sold budget of Company F.
Answer to Problem 21.3APR
The following table shows the cost of goods sold budget.
F Company | |||
Cost of Goods Sold Budget | |||
For the month ending December 31 | |||
Particulars | Amount ($) | Amount ($) | Amount ($) |
Finished goods inventory, December 1 | 19,440 (9) | ||
Work-in-process inventory, December 1 | 29,000 | ||
Direct material: | |||
Direct materials inventory, December 1 | 1,640 (10) | ||
Direct materials purchases | 46,704 | ||
Cost of direct materials available for use | 48,344 | ||
Less: Direct materials inventory, December 31 | (1,740) (11) |
||
Cost of direct materials placed in production | 46,604 | ||
Direct labor | 53,144 | ||
Factory overhead | 109,000 | ||
Total manufacturing cost | 208,748 | ||
Total work-in-process during the period | 237,748 | ||
Less: Work-in-process inventory, December 30 | (35,400) | ||
Cost of goods manufactures | 202,348 | ||
Cost of finished goods available for sale | 221,788 | ||
Less: Finished goods inventory, December 30 | (18,080) (12) | ||
Cost of Goods Sold | 203,708 |
Table (6)
Explanation of Solution
Working Notes:
Calculate the beginning finished goods inventory.
Calculate the beginning direct material.
Calculate the ending direct material.
Calculate the ending finished goods inventory.
7.
To Prepare: The selling and administrative expenses budget of Company F.
Explanation of Solution
The following table shows the selling and administrative expenses budget.
Company F | ||
Selling and Administrative Budget | ||
For the Month Ending December 31 | ||
Particulars | Amount ($) | Amount ($) |
Selling expense: | ||
Sales salaries expense | 70,000 | |
Advertising expense | 18,000 | |
Telephone expense | 550 | |
Travel expense | 4,000 | |
Total selling expense | 92,550 | |
Administrative expense: | ||
Office salaries expense | 21,000 | |
Depreciation expense – office equipment | 600 | |
Telephone expense – Administrative | 250 | |
Office supplies expense | 200 | |
Miscellaneous administrative expense | 400 | |
Total administrative expenses | 22,450 | |
Total Operating Expenses | 115,000 |
Table (7)
8.
To Prepare: The budgeted income statement of Company F.
Explanation of Solution
Prepare the budgeted income statement of Company F.
Company F | ||
Budgeted Income Statement | ||
For the Month Ending December 31 | ||
Particulars | Amount ($) | Amount ($) |
Revenue from sales | 370,000 | |
Less: Cost of goods sold | (203,708) | |
Gross profit | 166,292 | |
Operating expenses: | ||
Selling expenses | 92,550 | |
Administrative expenses | 22,450 | |
Total operating expenses | (115,000) | |
Income from operations | 51,292 | |
Other revenue and expenses: | ||
Interest revenue | 200 | |
Interest expense | (122) | 78 |
Income before income tax | 51,370 | |
Income tax expense (30%) | (15,411) | |
Net Income | 35,959 |
Table (8)
Want to see more full solutions like this?
Chapter 21 Solutions
Financial & Managerial Accounting
- 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.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 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
- Budgeted income statement and supporting budgets The budget director of Jupiter Helmets 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 May: Prepare a cost of goods sold budget for May. Work in process at the beginning of May is estimated to be $4200. and work in process at the end of May is desired to be $3800.arrow_forwardRelevant 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 yeararrow_forwardPreparing a flexible budget Use the information in Figure 7-12 of the chapter. Required: Prepare flexible budgets for the production and sale of 29,000 units and 31,000 units, respectively.arrow_forward
- 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.arrow_forwardSales, 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_forwardCash budget The controller of Bridgeport Housewares Inc. instructs you to prepare a monthly cash budget for the next three months. You are presented with the following budget information: The company expects to sell about 10% of its merchandise for cash. Of sales on account, 70% are expected to be collected in the month following the sale and the remainder the following month (second month following sale). Depreciation, insurance, and property tax expense represent 50,000 of the estimated monthly manufacturing costs. The annual insurance premium is paid in January, and the annual property taxes are paid in December. Of the remainder of the manufacturing costs, 80% are expected to be paid in the month in which they are incurred and the balance in the following month. Current assets as of September 1 include cash of 40,000, marketable securities of 75,000, and accounts receivable of 300,000 (60,000 from July sales and 240,000 from August sales). Sales on account for July and August were 200,000 and 240,000, respectively. Current liabilities as of September 1 include 40,000 of accounts payable incurred in August for manufacturing costs. All selling and administrative expenses are paid in cash in the period they are incurred. An estimated income tax payment of 55,000 will be made in October. Bridgeports regular quarterly dividend of 25,000 is expected to be declared in October and paid in November. Management desires to maintain a minimum cash balance of 50,000. Instructions Prepare a monthly cash budget and supporting schedules for September, October, and November. On the basis of the cash budget prepared in part (1), what recommendation should be made to the controller?arrow_forward
- Before the year began, the following static budget was developed for the estimated sales of 50,000. Sales are higher than expected and management needs to revise its budget. Prepare a flexible budget for 100,000 and 110,000 units of sales.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_forwardCash budget The controller of Mercury Shoes Inc. instructs you to prepare a monthly cash budget for the next three months. You are presented with the following budget information: The company expects to sell about 10% of its merchandise for cash. Of sales on account, 60% are expected to be collected in the month following the sale and the remainder the following month (second month after sale). Depreciation, insurance, and property tax expense represent 12,000 of the estimated monthly manufacturing costs. The annual insurance premium is paid in February, and the annual property taxes are paid in November. Of the remainder of the manufacturing costs, 80% are expected to be paid in the month in which they are incurred and the balance in the following month. Current assets as of June 1 include cash of 42,000, marketable securities of 25,000, and accounts receivable of 198,000 (150,000 from May sales and 48,000 from April sales). Sales on account in April and May were 120,000 and 150,000, respectively. Current liabilities as of June 1 include 13,000 of accounts payable incurred in May for manufacturing costs. All selling and administrative expenses are paid in cash in the period they are incurred. An estimated income tax payment of 24,000 will be made in July. Mercury Shoes regular quarterly dividend of 15,000 is expected to be declared in July and paid in August. Management desires to maintain a minimum cash balance of 40,000. Instructions Prepare a monthly cash budget and supporting schedules for June, July, and August. On the basis of the cash budget prepared in part (1), what recommendation should be made to the controller?arrow_forward
- Survey of Accounting (Accounting I)AccountingISBN:9781305961883Author:Carl WarrenPublisher:Cengage LearningFinancial And Managerial AccountingAccountingISBN:9781337902663Author:WARREN, Carl S.Publisher:Cengage Learning,Managerial AccountingAccountingISBN:9781337912020Author:Carl Warren, Ph.d. Cma William B. TaylerPublisher:South-Western College Pub
- Managerial Accounting: The Cornerstone of Busines...AccountingISBN:9781337115773Author:Maryanne M. Mowen, Don R. Hansen, Dan L. HeitgerPublisher:Cengage LearningPrinciples of Accounting Volume 2AccountingISBN:9781947172609Author:OpenStaxPublisher:OpenStax CollegePrinciples of Cost AccountingAccountingISBN:9781305087408Author:Edward J. Vanderbeck, Maria R. MitchellPublisher:Cengage Learning