Concept explainers
Novo, Inc., wants to develop an activity flexible budget for the activity of moving materials. Novo uses eight forklifts to move materials from receiving to stores. The forklifts are also used to move materials from stores to the production area. The forklifts are obtained through an operating lease that costs $18,000 per year per forklift. Novo employs 25 forklift operators who receive an average salary of $50,000 per year, including benefits. Each move requires the use of a crate. The crates are used to store the parts and are emptied only when used in production. Crates are disposed of after one cycle (two moves), where a cycle is defined as a move from receiving to stores to production. Each crate costs $1.80. Fuel for a forklift costs $3.60 per gallon. A gallon of gas is used every 20 moves. Forklifts can make three moves per hour and are available for 280 days per year, 24 hours per day (the remaining time is downtime for various reasons). Each operator works 40 hours per week and 50 weeks per year.
Required:
- 1. Prepare a flexible budget for the activity of moving materials, using the number of cycles as the activity driver.
- 2. Calculate the activity capacity for moving materials. Suppose Novo works at 80 percent of activity capacity and incurs the following costs:
Prepare the budget for the 80 percent level and then prepare a performance report for the moving materials activity.
- 3. Calculate and interpret the volume variance for moving materials.
- 4. Suppose that a redesign of the plant layout reduces the demand for moving materials to one-third of the original capacity. What would be the budget formula for this new activity level? What is the budgeted cost for this new activity level? Has activity performance improved? How does this activity performance evaluation differ from that described in Requirement 2? Explain.
1.
Construct a flexible budget for N Company for the activity of moving materials using number of cycles as the activity driver.
Explanation of Solution
Flexible budget: A flexible budget is a statement of estimate regarding revenues and expenses for a future period that can be modified depending on the level of output.
Resource |
Fixed ($) | Variable |
Salaries | 1,250,000 (1) | - |
Lease | 144,000 (2) | - |
Crates | - | $1.80 |
Fuel | - | (3) $0.36 |
Total | 1,394,000 | $2.16 |
Table (1)
Working notes:
(1) Calculate the total salary expenses.
(2) Calculate the total lease payable.
(3) Calculate the fuel consumption per machine per cycle.
2.
Compute the activity capacity of N Company for moving materials assuming that N Company works at 80 percentage activity capacity. Construct a budget for 80 percent capacity level and also prepare a performance report for the moving materials activity if N Company incurred the following cost.
Salaries - $1,290,000
Lease - $144,000
Crates - $118,000
Fuel - $24,000
Explanation of Solution
Prepare a flexible budget for N Company at 80 percentage activity capacity.
Resource |
Fixed ($) |
Variable ($) |
Activity output 60,000 cycles (6) ($) |
Salaries | 1,250,000 (1) | - | 1,250,000 |
Lease | 144,000 (2) | - | 144,000 |
Crates | - | $1.80 | 108,000 (4) |
Fuel | - | $0.36 (3) | 21,600 (5) |
Total | 1,394,000 | $2.16 | 1,523,600 |
Table (2)
Working notes:
(4) Calculate the total activity output with respect to crates.
(5) Calculate the total activity output with respect to fuel.
(6) Compute the 80 percent activity capacity of N Company.
(7) Compute the operator capacity of N Company.
Compute the forklift capacity of N Company.
Capacity is determined by the minimum f forklift capacity and operator capacity. Therefore, 75,000 cycles is the output capacity.
Prepare a performance report for moving materials of N Company.
N Company
Performance report
Resource |
Actual costs ($) |
Budgeted cost ($) |
Budget variance ($) |
(a) | (b) | ||
Salaries | 1,290,000 | 1,250,000 | 40,000 |
Lease | 144,000 | 144,000 | 0 |
Crates | 118,000 | 108,000 | 10,000 |
Fuel | 24,000 | 21,600 | 2,400 |
Total | 1,576,000 | 1,523,600 | 52,400 |
Table (3)
3.
Compute the volume variance of N Company and interpret the results.
Explanation of Solution
Since standard quantity equals zero, the volume variance is the capacity acquisition cost.
The volume variance is $1,394,000.
4.
Compute the budget formula and new activity level if a redesign of the plant layout reduces the demand for moving materials to one-third of the original capacity. Provide information and evaluate the calculated result with proper explanation.
Explanation of Solution
Resource |
Fixed ($) |
Variable ($) |
Activity output 25,000 cycles ($) |
Salaries | 450,000 | - | 450,000 (8) |
Lease | 54,000 | - | 54,000 (9) |
Crates | - | 1.80 | 45,000 (12) |
Fuel | - | 0.36 | 9,000 (13) |
Total | 504,000 | $2.16 | 558,000 |
Table (4)
Working notes:
(8) Compute the required operators for N Company for the need capacity.
(9) Compute the actual forklifts that will be required by N Company.
(10)Compute the cycle capacity for N Company for the need capacity.
(11) Compute the forklift capacity of N Company.
(12) Compute the activity output for crate of N Company.
(13) Compute the activity output for fuel consumption of N Company.
Want to see more full solutions like this?
Chapter 12 Solutions
Cornerstones of Cost Management (Cornerstones Series)
- Foy Company has a welding activity and wants to develop a flexible budget formula for the activity. The following resources are used by the activity: Four welding units, with a lease cost of 12,000 per year per unit Six welding employees each paid a salary of 50,000 per year (A total of 9,000 welding hours are supplied by the six workers.) Welding supplies: 300 per job Welding hours: Three hours used per job During the year, the activity operated at 90 percent of capacity and incurred the actual activity and resource costs, shown on page 676. Lease cost: 48,000 Salaries: 315,000 Parts and supplies: 805,000 Required: 1. Prepare a flexible budget formula for the welding activity using welding hours as the driver. 2. Prepare a performance report for the welding activity. 3. What if welders were hired through outsourcing and paid 30 per hour (the welding equipment is provided by Foy)? Repeat Requirement 1 for the outsourcing case.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_forwardAdam 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_forward
- Shalimar Company manufactures and sells industrial products. For next year, Shalimar has budgeted the follow sales: In Shalimars experience, 10 percent of sales are paid in cash. Of the sales on account, 65 percent are collected in the quarter of sale, 25 percent are collected in the quarter following the sale, and 7 percent are collected in the second quarter after the sale. The remaining 3 percent are never collected. Total sales for the third quarter of the current year are 4,900,000 and for the fourth quarter of the current year are 6,850,000. Required: 1. Calculate cash sales and credit sales expected in the last two quarters of the current year, and in each quarter of next year. 2. Construct a cash receipts budget for Shalimar Company for each quarter of the next year, showing the cash sales and the cash collections from credit sales. 3. What if the recession led Shalimars top management to assume that in the next year 10 percent of credit sales would never be collected? The expected payment percentages in the quarter of sale and the quarter after sale are assumed to be the same. How would that affect cash received in each quarter? Construct a revised cash budget using the new assumption.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_forwardBiotechtron, Inc., has two research laboratories in the Southwest, one in Yuma, Arizona, and the other in Bernalillo, New Mexico. The owner of Biotechtron centralized the legal services function in the Yuma office and had both laboratories send any legal questions or issues to the Yuma office. The legal services support center has budgeted fixed costs of 160,000 per year and a budgeted variable rate of 65 per hour of professional time. The normal usage of the legal services center is 2,600 hours per year for the Yuma office and 1,400 hours per year for the Bernalillo office. This corresponds to the expected usage for the coming year. Required: 1. Determine the amount of legal services support center costs that should be assigned to each office. 2. Since the offices produce services, not tangible products, what purpose is served by allocating the budgeted costs? 3. Now, assume that during the year, the legal services center incurred actual fixed costs of 163,000 and actual variable costs of 272,400. It delivered 4,180 hours of professional time2,580 hours to Yuma and 1,600 hours to Bernalillo. Determine the amount of the legal services centers costs that should be allocated to each office. Explain the purposes of this allocation. 4. Did the costs allocated differ from the costs incurred by the legal services center? If so, 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_forwardTIB makes custom guitars and prepared the following sales budget for the second quarter It also has this additional information related to its expenses: Direct material per unit $55, Direct labor per hour 20, Variable manufacturing overhead per hour 3.50, Fixed manufacturing overhead per month 3,000, Sales commissions per unit 20, Sales salaries per month 5,000, Delivery expense per unit 0.50, Utilities per month 4,000. Administrative salaries per month 20,000, Marketing expenses per month 8,000, Insurance expense per month 11,000, Depreciation expense per month 9,000. Prepare a sales and administrative expense budget for each month in the quarter ended June 30. 2018.arrow_forwardThe Sea Wharf Restaurant would like to determine the best way to allocate a monthly advertising budget of 1,000 between newspaper advertising and radio advertising. Management decided that at least 25% of the budget must be spent on each type of media and that the amount of money spent on local newspaper advertising must be at least twice the amount spent on radio advertising. A marketing consultant developed an index that measures audience exposure per dollar of advertising on a scale from 0 to 100, with higher values implying greater audience exposure. If the value of the index for local newspaper advertising is 50 and the value of the index for spot radio advertising is 80, how should the restaurant allocate its advertising budget to maximize the value of total audience exposure? a. Formulate a linear programming model that can be used to determine how the restaurant should allocate its advertising budget in order to maximize the value of total audience exposure. b. Develop a spreadsheet model and solve the problem using Excel Solver.arrow_forward
- Cold X, Inc. uses this information when preparing their flexible budget: direct materials of $2 per unit, direct labor of $3 per unit, and manufacturing overhead of $1 per unit. Fixed costs are $35,000. What would be the budgeted amounts for 20,000 and 25,000 units?arrow_forwardAspen Enterprises makes award pins for various events. Budget information regarding the current period is: A fraternity with which Aspen has a long relationship approached Aspen with a special order for 6,000 pins at a price of $2.75 per pin. Variable costs will be the same as the current production, and the special order will not impact the rest of the companys orders. However, Aspen is operating at capacity and will incur an additional $5,000 in fixed manufacturing overhead if the order is accepted. Based on this information, what is the differential income (loss) associated with accepting the special order?arrow_forwardElliott, Inc., has four salaried clerks to process purchase orders. Each clerk is paid a salary of 25,750 and is capable of processing as many as 6,500 purchase orders per year. Each clerk uses a PC and laser printer in processing orders. Time available on each PC system is sufficient to process 6,500 orders per year. The cost of each PC system is 1,100 per year. In addition to the salaries, Elliott spends 27,560 for forms, postage, and other supplies (assuming 26,000 purchase orders are processed). During the year, 25,350 orders were processed. Required: 1. Classify the resources associated with purchasing as (1) flexible or (2) committed. 2. Compute the total activity availability, and break this into activity usage and unused activity. 3. Calculate the total cost of resources supplied (activity cost), and break this into the cost of activity used and the cost of unused activity. 4. (a) Suppose that a large special order will cause an additional 500 purchase orders. What purchasing costs are relevant? By how much will purchasing costs increase if the order is accepted? (b) Suppose that the special order causes 700 additional purchase orders. How will your answer to (a) change?arrow_forward
- Cornerstones of Cost Management (Cornerstones Ser...AccountingISBN:9781305970663Author:Don R. Hansen, Maryanne M. MowenPublisher:Cengage LearningPrinciples of Accounting Volume 2AccountingISBN:9781947172609Author:OpenStaxPublisher:OpenStax CollegeManagerial AccountingAccountingISBN:9781337912020Author:Carl Warren, Ph.d. Cma William B. TaylerPublisher:South-Western College Pub
- Financial And Managerial AccountingAccountingISBN:9781337902663Author:WARREN, Carl S.Publisher:Cengage Learning,Principles of Cost AccountingAccountingISBN:9781305087408Author:Edward J. Vanderbeck, Maria R. MitchellPublisher:Cengage LearningEssentials of Business Analytics (MindTap Course ...StatisticsISBN:9781305627734Author:Jeffrey D. Camm, James J. Cochran, Michael J. Fry, Jeffrey W. Ohlmann, David R. AndersonPublisher:Cengage Learning