Steelcase Inc. is one of the largest manufacturers of office furniture in the United States. In Grand
Question:
Steelcase Inc. is one of the largest manufacturers of office furniture in the United States. In Grand Rapids, Michigan, it produces filing cabinets in two departments: Fabrication and Assembly. Assume the following information for the Assembly Department:Direct labor per filing cabinet20 minutes. Supervisor salaries$114,000 per monthDepreciation$8,500 per month Direct labor rate$12 per hour 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.Open spreadsheet Prepare a flexible budget for 5,000, 13,000, and 20,000 filing cabinets for the month of August, similar to Exhibit 5, assuming that inventories are not significant. Enter all amounts as positive numbers.