Budget Project 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 Supervisor salaries 30 minutes $135,000 per month $19,000 per month $15 per hour Depreciation Direct labor rate This information has been collected in the Microsoft Excel Online file. Open the spreadsheet, perform the required analysis, and input your answers in the question below. X Open spreadsheet Prepare a flexible budget for 9,000, 11,000, and 14,000 filing cabinets for the month ending February 28 in the Assembly Department, similar to Exhibit 4. Round your final answers to the whole dollar, if required. Cabinaire Inc. Assembly Department Budget For the Month Ending February 28 (assumed data) Units of production Variable cost: Direct labor✔ Total variable cost Fixed cost: Supervisor salaries Depreciation ✔ Total fixed cost Total department costs 9,000 11,000 14,000

FINANCIAL ACCOUNTING
10th Edition
ISBN:9781259964947
Author:Libby
Publisher:Libby
Chapter1: Financial Statements And Business Decisions
Section: Chapter Questions
Problem 1Q
icon
Related questions
Question

am. 126.

Budget Project
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
Supervisor salaries
30 minutes
$135,000 per month
$19,000 per month
$15 per hour
Depreciation
Direct labor rate
This information has been collected in the Microsoft Excel Online file. Open the spreadsheet, perform the
required analysis, and input your answers in the question below.
X
Open spreadsheet
Prepare a flexible budget for 9,000, 11,000, and 14,000 filing cabinets for the month ending February 28 in the
Assembly Department, similar to Exhibit 4. Round your final answers to the whole dollar, if required.
Cabinaire Inc.
Assembly Department Budget
For the Month Ending February 28 (assumed data)
Units of production
Variable cost:
Direct labor✔
Total variable cost
Fixed cost:
Supervisor salaries
Depreciation ✔
Total fixed cost
Total department costs
9,000
11,000
14,000
Transcribed Image Text:Budget Project 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 Supervisor salaries 30 minutes $135,000 per month $19,000 per month $15 per hour Depreciation Direct labor rate This information has been collected in the Microsoft Excel Online file. Open the spreadsheet, perform the required analysis, and input your answers in the question below. X Open spreadsheet Prepare a flexible budget for 9,000, 11,000, and 14,000 filing cabinets for the month ending February 28 in the Assembly Department, similar to Exhibit 4. Round your final answers to the whole dollar, if required. Cabinaire Inc. Assembly Department Budget For the Month Ending February 28 (assumed data) Units of production Variable cost: Direct labor✔ Total variable cost Fixed cost: Supervisor salaries Depreciation ✔ Total fixed cost Total department costs 9,000 11,000 14,000
Expert Solution
steps

Step by step

Solved in 2 steps

Blurred answer
Recommended textbooks for you
FINANCIAL ACCOUNTING
FINANCIAL ACCOUNTING
Accounting
ISBN:
9781259964947
Author:
Libby
Publisher:
MCG
Accounting
Accounting
Accounting
ISBN:
9781337272094
Author:
WARREN, Carl S., Reeve, James M., Duchac, Jonathan E.
Publisher:
Cengage Learning,
Accounting Information Systems
Accounting Information Systems
Accounting
ISBN:
9781337619202
Author:
Hall, James A.
Publisher:
Cengage Learning,
Horngren's Cost Accounting: A Managerial Emphasis…
Horngren's Cost Accounting: A Managerial Emphasis…
Accounting
ISBN:
9780134475585
Author:
Srikant M. Datar, Madhav V. Rajan
Publisher:
PEARSON
Intermediate Accounting
Intermediate Accounting
Accounting
ISBN:
9781259722660
Author:
J. David Spiceland, Mark W. Nelson, Wayne M Thomas
Publisher:
McGraw-Hill Education
Financial and Managerial Accounting
Financial and Managerial Accounting
Accounting
ISBN:
9781259726705
Author:
John J Wild, Ken W. Shaw, Barbara Chiappetta Fundamental Accounting Principles
Publisher:
McGraw-Hill Education