Concept explainers
1.
Prepare the sales budget for the year ended December 31, 2016.
1.
Explanation of Solution
Prepare the sales budget for the year ended December 31, 2016.
SS Incorporation | |||
Sales budget | |||
For the year ended December 31, 2016 | |||
Product | Sales volume (Unit) | Selling price (Unit) | Total sales |
Tables | 30,000 | $175 | $5,250,000 |
Chairs | 120,000 | $75 | $9,000,000 |
Total | 150,000 | $14,250,000 |
Table (1)
2.
Prepare the production budget for the year ended December 31, 2016.
2.
Explanation of Solution
Prepare the production budget for the year ended December 31, 2016.
SS Incorporation | ||
Production budget | ||
For the year ended December 31, 2016 | ||
Particulars | Units | |
Tables | Chairs | |
Sales (From sales budget) | 30,000 | 120,000 |
Add: desired ending inventory, December 31 | 1,500 | 6,000 |
Total | 31,500 | 126,000 |
Less: Estimated beginning inventory, January 1 | 1,000 | 4,000 |
Total production | 30,500 | 122,000 |
Table (2)
3.
Prepare the direct material budget for the year ended December 31, 2016.
3.
Explanation of Solution
Prepare the direct material budget for the year ended December 31, 2016.
SS Incorporation | |||
Direct materials budget | |||
For the year ended December 31, 2016 | |||
Particulars | Direct materials | Total | |
Rattan (Yd.) | Binding cane (Yd.) | ||
Quantities required for production: | |||
Tables: | |||
| 305,000 | ||
| 183,000 | ||
Chairs | |||
| 732,000 | ||
| 366,000 | ||
Add: Desired ending inventory, December 31 | 51,000 | 25,500 | |
Total | 1,088,000 | 574,500 | |
Less: Estimated beginning inventory, January 1 | 34,000 | 17,000 | |
Total quantity to be purchased (A) | 1,054,000 | 557,500 | |
Unit price (B) | $5 | $3 | |
Total direct materials purchases | $5,270,000 | $1,672,500 | $6,942,500 |
Table (3)
4.
Prepare the direct labor budget for the year ended December 31, 2016.
4.
Explanation of Solution
Prepare the direct labor budget for the year ended December 31, 2016.
SS Incorporation | |||
Direct labor budget | |||
For the year ended December 31, 2016 | |||
Particulars | Department | Total | |
Molding | Finishing | ||
Hours required for production: | |||
Tables: | |||
| 15,250 | ||
| 7,625 | ||
Truck tires: | |||
| 30,500 | ||
| 12,200 | ||
Total (A) | 45,750 | 19,825 | |
Hourly rate (B) | $15 | $13 | |
Total direct labor cost | $688,250 | $257,725 | $943,975 |
Table (4)
5.
Prepare the factory
5.
Explanation of Solution
Prepare the factory overhead budget for the year ended December 31, 2016.
SS Incorporation | ||
Factory overhead budget | ||
For the year ended December 31, 2016 | ||
Particulars | Amount ($) | Amount ($) |
Indirect materials | 98,500 | |
Indirect labor | 132,200 | |
57,500 | ||
Power and light | 92,200 | |
Total | $380,400 |
Table (5)
6.
Prepare the cost of goods sold budget for the year ended December 31, 2016.
6.
Explanation of Solution
Prepare the cost of goods sold budget for the year ended December 31, 2016.
SS Incorporation | ||
Cost of goods sold budget | ||
For the year ended December 31, 2016 | ||
Particulars | Amount ($) | Amount ($) |
Finished goods inventory, January 1 | 240,000 | |
Direct materials inventory, January 1 (1) | 221,000 | |
Direct materials purchases | 6,942,500 | |
Total direct materials available | 7,163,500 | |
Less: Direct materials inventory, December 31 (2) | 331,500 | |
Cost of direct materials used | 6,832,000 | |
Direct labor | 943,975 | |
Factory overhead | 380,400 | |
Cost of goods manufactured | 8,156,375 | |
Cost of goods available for sale | 8396,375 | |
Less: Finished goods inventory, December 31 | 360,000 | |
Cost of goods sold | 8,036,375 |
Table (6)
Working note (1):
Calculate the amount of direct materials inventory as on January 1:
Particulars | Calculation | Amount ($) |
Rattan | 170,000 | |
Binding care | 51,000 | |
Total | 171,000 |
Table (7)
Working note (2):
Calculate the amount of direct materials inventory as on December 31:
Particulars | Calculation | Amount ($) |
Rattan | 120,000 | |
Binding care | 18,000 | |
Total | 171,000 |
Table (8)
Want to see more full solutions like this?
Chapter 7 Solutions
Principles of Cost Accounting
- Sales, production, direct materials, direct labor, and factory overhead budgets King Tire Co.s budgeted unit sales for the year 2016 were: The budgeted selling price for truck tires was 200 per tire, and for passenger car tires it was 65 per tire. The beginning finished goods inventories were expected to be 2,000 truck tires and 5,000 passenger tires, for a total cost of 326,478, with desired ending inventories at 2,500 and 6,000, respectively, with a total cost of 400,510. There was no anticipated beginning or ending work-in- process inventory for either type of tire. The standard materials quantities for each type of tire were as follows: The purchase prices of rubber and steel were 2 and 3 per pound, respectively. The desired ending inventories for rubber and steel were 60,000 and 6,000 lb, respectively. The estimated beginning inventories for rubber and steel were 75,000 and 7,000 lb, respectively. The direct labor hours required for each type of tire were as follows: The direct labor rate for each department is as follows: Budgeted factory overhead costs for 2016 were as follows: Required: Prepare each of the following budgets for King for the year ended December 31, 2016: 1. Sales budget. 2. Production budget. 3. Direct material budget. 4. Direct labor budget. 5. Factory overhead budget. 6. Cost of goods sold budget.arrow_forwardPerformance 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_forwardPerformance Report Based on Budgeted and Actual Levels of Production Bowling Company budgeted the following amounts: At the end of the year, Bowling had the following actual costs for production of 3,800 units: Required: 1. Calculate the budgeted amounts for each cost category listed above for the 4,000 budgeted units. 2. Prepare a performance report using a budget based on expected production of 4,000 units. 3. Prepare a performance report using a budget based on the actual level of production of 3,800 units.arrow_forward
- The Sales Department of Minimus Inc. has forecast sales for May 2016 to be 40,000 units. Additional information follows: Materials used in production: Direct labor hours required in production: Prepare the following: a. A production budget for May. b. A direct materials budget for May. c. A direct labor budget for May.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_forwardSales, 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.arrow_forward
- 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_forwardFlexible overhead budget Leno Manufacturing Company prepared the following factory overhead cost budget for the Press Department for October of the current year, during which it expected to require 20,000 hours of productive capacity in the department: Assuming that the estimated costs for November are the same as for October, prepare a flexible factory overhead cost budget for the Press Department for November for 18,000, 20,000, and 22.000 hours of production.arrow_forwardRefer to Cornerstone Exercise 8.6. Required: 1. Calculate the total budgeted cost of units produced for Play-Disc for the coming year. Show the cost of direct materials, direct labor, and overhead. 2. Prepare a cost of goods sold budget for Play-Disc for the year. 3. What if the beginning inventory of finished goods was 75,200 (for 16,000 units)? How would that affect the cost of goods sold budget? (Assume Play-Disc uses the FIFO method.) 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.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_forwardUsing the provided budgeted information for production of 10,000 and 15,000 units, prepare a flexible budget for 17,000 units.arrow_forwardNashler Company has the following budgeted variable costs per unit produced: Budgeted fixed overhead costs per month include supervision of 98,000, depreciation of 76,000, and other overhead of 245,000. Required: 1. Prepare a flexible budget for all costs of production for the following levels of production: 160,000 units, 170,000 units, and 175,000 units. 2. What is the per-unit total product cost for each of the production levels from Requirement 1? (Round each unit cost to the nearest cent.) 3. What if Nashler Companys cost of maintenance rose to 0.22 per unit? How would that affect the unit product costs calculated in Requirement 2?arrow_forward
- Principles of Cost AccountingAccountingISBN:9781305087408Author:Edward J. Vanderbeck, Maria R. MitchellPublisher:Cengage LearningManagerial AccountingAccountingISBN:9781337912020Author:Carl Warren, Ph.d. Cma William B. TaylerPublisher:South-Western College PubFinancial And Managerial AccountingAccountingISBN:9781337902663Author:WARREN, Carl S.Publisher:Cengage Learning,
- Cornerstones of Cost Management (Cornerstones Ser...AccountingISBN:9781305970663Author:Don R. Hansen, Maryanne M. MowenPublisher:Cengage LearningManagerial 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 College