Concept explainers
Spiffy Shades Corporation manufactures artistic frames for sunglasses. Talia Demarest, controller, is responsible for preparing the company’s
Labor-related costs include pension contributions of $.50 per hour, workers’ compensation insurance of $.20 per hour, employee medical insurance of $.80 per hour, and employer contributions to Social Security equal to 7 percent of direct-labor wages. The cost of employee benefits paid by the company on its employees is treated as a direct-labor cost. Spiffy Shades Corporation has a labor contract that calls for a wage increase to $18.00 per hour on April 1, 20x1. Management expects to have 16,000 frames on hand at December 31, 20x0, and has a policy of carrying an end-of-month inventory of 100 percent of the following month’s sales plus 50 percent of the second following month’s sales.
These and other data compiled by Demarest are summarized in the following table.
Required:
- 1. Prepare a production budget and a direct-labor budget for Spiffy Shades Corporation by month and for the first quarter of 20x1. Both budgets may be combined in one schedule. The direct-labor budget should include direct-labor hours and show the detail for each direct-labor cost category.
- 2. For each item used in the firm’s production budget and direct-labor budget, identify the other components of the master budget (except for financial statement budgets) that also would, directly or indirectly, use these data.
- 3. Prepare a production
overhead budget for each month and for the first quarter.
1.
Prepare a production budget and a direct-labor budget for S Corporation by month and for the first quarter of 20x1.
Explanation of Solution
Production Budget: The production budget refers to that budget which forecasts the production for the future accounting period. The budgeted production for any financial period is planned by combining the forecasted unit of sales and the finished goods inventory and deducting the beginning goods inventory.
Direct labor budget: Direct labor budget is an estimation of direct labor hours required for the budgeted units of production is known as direct labor budget.
Prepare a production budget and a direct-labor budget for S Corporation by month and for the first quarter of 20x1:
Table (1)
Working note 1:
Calculate the amount of ending inventory for January:
Working note 2:
Calculate the amount of ending inventory for February:
Working note 3:
Calculate the amount of ending inventory for March:
Working note 4:
Calculate the amount of wages for January:
Working note 5:
Calculate the amount of wages for February:
Working note 6:
Calculate the amount of wages for March:
Working note 7:
Calculate the amount of pension contribution for January:
Working note 8:
Calculate the amount of pension contribution for February:
Working note 9:
Calculate the amount of pension contribution for March:
Working note 10:
Calculate the amount of workers’ compensation insurance for January:
Working note 11:
Calculate the amount of workers’ compensation insurance for February:
Working note 12:
Calculate the amount of workers’ compensation insurance for March:
Working note 13:
Calculate the amount of employee medical insurance for January:
Working note 14:
Calculate the amount of employee medical insurance for February:
Working note 15:
Calculate the amount of employee medical insurance for March:
Working note 16:
Calculate the amount of employee social security for January:
Working note 17:
Calculate the amount of employee social security for February:
Working note 18:
Calculate the amount of employee social security for March:
2.
Identify the other components of the master budget.
Explanation of Solution
Master Budget: The master budget is the core budget that describes the full process of budget. This budget shows all the operating and financial budgets of the company for a budgeted accounting period and this budget includes all the budgets and budgeted financial statements.
Identify the other components of the master budget:
The following are the components of the master budget except production budget and direct labor budget but use the sales data:
- Sales budget
- Cost of goods sold budget
- Selling and administrative expense budget
The following are the components of the master budget except production budget and direct labor budget but use the production data:
- Direct material budget
- Production-overhead budget
- Cost of goods sold budget
The following are the components of the master budget except production budget and direct labor budget but use the direct labor hour data:
- Production-overhead budget
The following are the components of the master budget except production budget and direct labor budget but use the direct labor cost data:
- Production-overhead budget
- Cost of goods sold budget
- Cash budget
- Budgeted income statement
3.
Prepare a production overhead budget for each month and for the first quarter.
Explanation of Solution
Manufacturing Overhead Budget: Manufacturing overhead budget is prepared to predict all indirect manufacturing costs. It excludes direct materials and direct labor. It is necessary to anticipate overhead budget to meet the budgeted production for the next accounting period.
Prepare a production overhead budget for each month and for the first quarter:
Table (2)
Want to see more full solutions like this?
Chapter 9 Solutions
Managerial Accounting: Creating Value in a Dynamic Business Environment
- Adam Corporation manufactures computer tables and has the following budgeted indirect manufacturing cost information for the next year: If Adam uses the step-down (sequential) method, beginning with the Maintenance Department, to allocate support department costs to production departments, the total overhead (rounded to the nearest dollar) for the Machining Department to allocate to its products would be: a. 407,500. b. 422,750. c. 442,053. d. 445,000.arrow_forwardNozama.com Inc. sells consumer electronics over the Internet. For the next period, the budgeted cost of the sales order processing activity is 250,000 and 50,000 sales orders are estimated to be processed. a. Determine the activity rate of the sales order processing activity. b. Determine the amount of sales order processing cost associated with 30,000 sales orders.arrow_forwardFirenza Company manufactures specialty tools to customer order. Budgeted overhead for the coming year is: Previously, Sanjay Bhatt, Firenza Companys controller, had applied overhead on the basis of machine hours. Expected machine hours for the coming year are 50,000. Sanjay has been reading about activity-based costing, and he wonders whether or not it might offer some advantages to his company. He decided that appropriate drivers for overhead activities are purchase orders for purchasing, number of setups for setup cost, engineering hours for engineering cost, and machine hours for other. Budgeted amounts for these drivers are 5,000 purchase orders, 500 setups, and 2,500 engineering hours. Sanjay has been asked to prepare bids for two jobs with the following information: The typical bid price includes a 40 percent markup over full manufacturing cost. Required: 1. Calculate a plantwide rate for Firenza Company based on machine hours. What is the bid price of each job using this rate? 2. Calculate activity rates for the four overhead activities. What is the bid price of each job using these rates? 3. Which bids are more accurate? Why?arrow_forward
- Cloud Shoes manufactures recovery sandals and is planning on producing 12.000 units in March and 11,500 in April. Each sandal requires 1.2 yards if material, which costs $3.00 per yard. The companys policy is to have enough material on hand to equal 15% of next months production needs and to maintain a finished goods inventory equal to 20% of the next months production needs. What is the budgeted cost of purchases for March?arrow_forwardDouglas Davis, controller for Marston, Inc., prepared the following budget for manufacturing costs at two different levels of activity for 20X1: During 20X1, Marston worked a total of 80,000 direct labor hours, used 250,000 machine hours, made 32,000 moves, and performed 120 batch inspections. The following actual costs were incurred: Marston applies overhead using rates based on direct labor hours, machine hours, number of moves, and number of batches. The second level of activity (the right column in the preceding table) is the practical level of activity (the available activity for resources acquired in advance of usage) and is used to compute predetermined overhead pool rates. Required: 1. Prepare a performance report for Marstons manufacturing costs in the current year. 2. Assume that one of the products produced by Marston is budgeted to use 10,000 direct labor hours, 15,000 machine hours, and 500 moves and will be produced in five batches. A total of 10,000 units will be produced during the year. Calculate the budgeted unit manufacturing cost. 3. One of Marstons managers said the following: Budgeting at the activity level makes a lot of sense. It really helps us manage costs better. But the previous budget really needs to provide more detailed information. For example, I know that the moving materials activity involves the use of forklifts and operators, and this information is lost when only the total cost of the activity for various levels of output is reported. We have four forklifts, each capable of providing 10,000 moves per year. We lease these forklifts for five years, at 10,000 per year. Furthermore, for our two shifts, we need up to eight operators if we run all four forklifts. Each operator is paid a salary of 30,000 per year. Also, I know that fuel costs about 0.25 per move. Assuming that these are the only three items, expand the detail of the flexible budget for moving materials to reveal the cost of these three resource items for 20,000 moves and 40,000 moves, respectively. Based on these comments, explain how this additional information can help Marston better manage its costs. (Especially consider how activity-based budgeting may provide useful information for non-value-added activities.)arrow_forwardKrouse Company produces two products, forged putter heads and laminated putter heads, which are sold through specialty golf shops. The company is in the process of developing itsoperating budget for the coming year. Selected data regarding the companys two products areas follows: Manufacturing overhead is applied to units using direct labor hours. Variable manufacturing overhead Ls projected to be 25,000, and fixed manufacturing overhead is expected to be15,000. The estimated cost to produce one unit of the laminated putter head is: a. 42. b. 46. c. 52. d. 62.arrow_forward
- Salisbury Bottle Company manufactures plastic two-liter bottles for the beverage industry. The cost standards per 100 two-liter bottles are as follows: At the beginning of March, Salisburys management planned to produce 500,000 bottles. The actual number of bottles produced for March was 525,000 bottles. The actual costs for March of the current year were as follows: a. Prepare the March manufacturing standard cost budget (direct labor, direct materials, and factory overhead) for Salisbury, assuming planned production. b. Prepare a budget performance report for manufacturing costs, showing the total cost variances for direct materials, direct labor, and factory overhead for March. c. Interpret the budget performance report.arrow_forwardThe controller for Muir Companys Salem plant is analyzing overhead in order to determine appropriate drivers for use in flexible budgeting. She decided to concentrate on the past 12 months since that time period was one in which there was little important change in technology, product lines, and so on. Data on overhead costs, number of machine hours, number of setups, and number of purchase orders are in the following table. Required: 1. Calculate an overhead rate based on machine hours using the total overhead cost and total machine hours. (Round the overhead rate to the nearest cent and predicted overhead to the nearest dollar.) Use this rate to predict overhead for each of the 12 months. 2. Run a regression equation using only machine hours as the independent variable. Prepare a flexible budget for overhead for the 12 months using the results of this regression equation. (Round the intercept and x-coefficient to the nearest cent and predicted overhead to the nearest dollar.) Is this flexible budget better than the budget in Requirement 1? Why or why not?arrow_forwardSpiffy Shades Corporation manufactures artistic frames for sunglasses. Talia Demarest, controller, is responsible for preparing the company's master budget. In compiling the budget data for 20x1, Demarest has learned that new automated production equipment will be installed on March 1. This will reduce the direct labor per frame from 1 hour to 0.75 hour. Labor-related costs include pension contributions of $0.50 per hour, workers' compensation insurance of $0.20 per hour, employee medical insurance of $0.80 per hour, and employer contributions to Social Security equal to 7 percent of direct- labor wages. The cost of employee benefits paid by the company on its employees is treated as a direct-labor cost. Spiffy Shades Corporation has a labor contract that calls for a wage increase to $18.00 per hour on April 1, 20x1. Management expects to have 16,000 frames on hand at December 31, 20x0, and has a policy of carrying an end-of-month inventory of 100 percent of the following month's sales…arrow_forward
- Greiner Company makes and sells high-quality glare filters for microcomputer monitors. John Craven, controller, is responsible for preparing Greiner’s master budget and has assembled the following data for the coming year. The direct labor rate includes wages, all employee-related benefits, and the employer’s share of FICA. Labor saving machinery will be fully operational by March. Also, as of March 1, the company’s union contract calls for an increase in direct labor wages that is included in the direct labor rate. Greiner expects to have 6,400 glare filters in inventory on December 31 of the current year, and has a policy of carrying 25 percent of the following month’s projected sales in inventory. Information on the first four months of the coming year is as follows: January February March April Estimated unit sales 37,400 35,200 40,200 38,200 Sales price per unit $82 $82 $77 $77 Direct labor hours per unit 2.70 2.70 2.30 2.30 Direct labor hourly rate $19 $19 $20…arrow_forwardEver Clean Company provides gutter cleaning services to residential clients. Overhead is allocated based on direct labor-hours (DLH). The owner, Joanne Clark, estimates that her gutter cleaners will work a total of 1,000 jobs during the year. Each job averages 600 feet of gutter surface and requires 12 direct labor-hours. Clark pays her gutter cleaners $15 per hour. The following table presents the budgeted overhead costs for 2018: Variable costs Supplies ($6.50 per DLH) Fixed costs (to support capacity of 12,000 DLH) Indirect labor Depreciation Other Total budgeted costs The budgeted overhead rate (USD/DLH) is closest to O A. 5.50 O B. 12.00 O C. 6.50 $ 78,000 25,000 17,000 24,000 $144,000arrow_forwardEver Clean Company provides gutter cleaning services to residential clients. Overhead is allocated based on direct labor-hours (DLH). The owner, Joanne Clark, estimates that her gutter cleaners will work a total of 1,000 jobs during the year. Each job averages 600 feet of gutter surface and requires 12 direct labor-hours. Clark pays her gutter cleaners $15 per hour. The following table presents the budgeted overhead costs for 2018: Supplies ($6.50 per DLH) Fixed costs (to support capacity of 12,000 DLH) Indirect labor Depreciation Other Total budgeted costs The direct labor budget (in hours) is closest to O A. 12,000 Variable costs O B. 1,000 O C. 180,000 $ 78,000 25,000 17,000 24,000 $144,000arrow_forward
- Cornerstones of Cost Management (Cornerstones Ser...AccountingISBN:9781305970663Author:Don R. Hansen, Maryanne M. MowenPublisher: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,
- Excel Applications for Accounting PrinciplesAccountingISBN:9781111581565Author:Gaylord N. SmithPublisher:Cengage LearningPrinciples of Accounting Volume 2AccountingISBN:9781947172609Author:OpenStaxPublisher:OpenStax College