Flexible Budget for Assembly Department Cabinaire Inc. is one of the largest manufacturers of office furniture in the United States. In Grand Rapids, Michigan, it assembles filing cabinets in an Assembly Department. Assume the following information for the Assembly Department: Direct labor per filing cabinet 20 minutes Supervisor salaries $117,000 per month Depreciation $17,000 per month Direct labor rate $12 per hour Prepare a flexible budget for 14,000, 18,000, and 21,000 filing cabinets for the month ending February 28 in the Assembly Department similar to Exhibit 5. Round your final answers to the whole dollar, if required. Cabinaire Inc.

Flexible Budget for Assembly Department Cabinaire Inc. is one of the largest manufacturers of office furniture in the United States. In Grand Rapids, Michigan, it assembles filing cabinets in an Assembly Department. Assume the following information for the Assembly Department: Direct labor per filing cabinet 20 minutes Supervisor salaries $117,000 per month Depreciation $17,000 per month Direct labor rate $12 per hour Prepare a flexible budget for 14,000, 18,000, and 21,000 filing cabinets for the month ending February 28 in the Assembly Department similar to Exhibit 5. Round your final answers to the whole dollar, if required. Cabinaire Inc.

Managerial Accounting

15th Edition

ISBN:9781337912020

Author:Carl Warren, Ph.d. Cma William B. Tayler

Publisher:Carl Warren, Ph.d. Cma William B. Tayler

Chapter8: Budgeting

Section: Chapter Questions

Problem 4E

See similar textbooks

Similar questions

Nozama.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.
Use the following information for Exercises 9-63 and 9-64: Palladium Inc. produces a variety of household cleaning products. Palladiums controller has developed standard costs for the following four overhead items: Next year, Palladium expects production to require 90,000 direct labor hours. Exercise 9-63 Flexible Budget for Various Levels of Activity Refer to the information for Palladium Inc. above. Required: 1. Prepare an overhead budget for the expected level of direct labor hours for the coming year. 2. Prepare an overhead budget that reflects production that is 15% higher than expected and for production that is 15% lower than expected.
Professional foes earned budget for a service company LundquistFret well. CPAs, offer three types of services to clents: auditing, tax, and small business accounting. Based on experience and projected growth, the following billable hours have been estimated for the year ending May 31. 20Y8: The average billing rate for staff is 140 per hour, and the average billing rate for partners is 450 per hour. Prepare a professional fees earned budget for Lundquist Fretwell, CPAs, for theyear ending May 31, 20Y8, using the following column headings and showing the estimated professional fees by type of service rendered:
Flexible budget for factory overhead Presented below are the monthly factory overhead cost budget (at normal capacity of 5,000 units or 20,000 direct labor hours) and the production and cost data for a month. The predetermined overhead rate is based on normal capacity. Required: 1. Assuming that variable costs will vary in direct proportion to the change in volume, prepare a flexible budget for production levels of 80%, 90%, and 110% of normal capacity. Also determine the predetermined factory overhead rate at each level of volume in both units and direct labor hours. 2. Prepare a flexible budget for production levels of 80%, 90%, and 110%, assuming that variable costs will vary in direct proportion to the change in volume, but with the following exceptions. (Hint: Set up a third category for semi-variable expenses.) a. At 110% of capacity, another supervisor will be needed at a salary of 24,000 annually. b. At 80% of capacity, the repairs expense will drop to one-half of the amount at 100% capacity. c. At 80% of capacity, one part-time maintenance worker, earning 10,000 a year, will be laid off. d. At 110% of capacity, a machine not normally in use and on which no depreciation is normally recorded will be used in production. Its cost was 12,000, it has a 10-year life, and straight-line depreciation will be taken.
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.
Multiple production department factory overhead rates The total factory overhead for Bardot Marine Company is budgeted for the year at 600,000 divided into two departments: Fabrication, 420,000, and Assembly, 180,000. Bardot Marine manufactures two types of boats: speedboats and bass boats. The speedboats require 8 direct labor hours in Fabrication and 4 direct labor hours in Assembly. The bass boats require 4 direct labor hours in Fabrication and 8 direct labor hours in Assembly. Each product is budgeted for 250 units of production for the year. Determine (A) the total number of budgeted direct labor hours for the year in each department, (B) the departmental factory overhead rates for both departments, and (C) the factory overhead allocated per unit for each product using the department factory overhead allocation rates.
Professional 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:
Refer 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.
Firenza 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?
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.
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.
GHT 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?