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 $147,000 per month Depreciation $19,000 per month Direct labor rate $21 per hour Prepare a flexible budget for 15,000, 19,000, and 23,000 filing cabinets for the month of August in the Assembly Department, similar to Exhibit 5. Assuming that inventories are not significant. Enter all amounts as positive numbers. CABINAIRE INC-ASSEMBLY DEPARTMENT Flexible Production Budget For the Month Ending August 31 (assumed data) Units of production 15,000 19,000 23,000 Variable cost: Direct labor Total variable cost Fixed cost: Supervisor salaries $ Depreciation Total fixed cost $ Total department cost Schedule of Cash Collections of Accounts Receivable Furry Friends Supplies Inc., a pet wholesale supplier, was organized on May 1. Projected sales for each of the first three months of operations are as follows: May $250,000 June 280,000 July 370,000 All sales are on account. 58 percent of sales are expected to be collected in the month of the sale, 31% in the month following the sale, and the remainder in the second month following the sale. Prepare a schedule indicating cash collections from sales for May, June, and July. Furry Friends Supplies Inc. Schedule of Collections from Sales For the Three Months Ending May 31 May June July May sales on account: Collected in May Collected in June Collected in July o June sales on account: Collected in June Collected in July July sales on account: Collected in July Total cash collected