Flexible Budget for Assembly Department 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 cabinet 20 minutes Supervisor salaries $117,000 per month Depreciation $7,000 per month Direct labor rate $24 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. 1 Open spreadsheet Prepare a flexible budoet for 4,000, 10,000, and 16,000 filing cabinets for the month of August, similar to Exhibit S, assuming that inventories are not significant. Enter all amounts as positive numbers, STEELCASE INC Assembly Department Budget Month Ending August 31 (Assumed Data) Units of production 4,000 10,000 16,000 Variable costs: $ Fixed costs S $ Total fixed cost Total department costs Direct Labor Cost Budget Sea Pines Company manufactures two types of tennis rackets, the Junior and Pro Striker models. The production budget for March for the two rackets is as follows: Junior Pro Striker Production budget 8,800 units 5,300 units Both rackets are produced in two departments, Forming and Assembly. The direct labor hours required for each racket are estimated as follows: Forming Department Assembly Department Junior 0.20 hours per unit 0.60 hours per unit Pro Striker 0.35 hours per unit 0.60 hours per unit The direct labor rate for each department is as follows: Forming Department $25.00 per hour Assembly Department $13.00 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. Prepare the direct labor cost budget for March. Round your answers for an hourly rate to two decimal places. Enter all amounts as positive numbers. SEA PINES COMPANY Direct Labor Cost Budget For the Month Ending March 31 Forming Department Assembly Department Total Hours required for production: Junior Pro Striker Total Hourly rate Total direct labor cost Previous Next Schedule of Cash Collections of Accounts Receivable Fur Family 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 $570,000 June 740,000 July 1,350,000 All sales are on account of sales on account, 58% are expected to be collected in the month of the sale, 37% in the first month following the sale, and the remainder in the second month following the sale. 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. Prepare a schedule indicating cash collections from sales for May, June, and July. FUR FAMILY INC. Schedule of Collections from Sales For the Three Months Ending July 31 May June July May sales on account: Collected in May Collected in June Collected in July June sales on account: Collected in June Collected in July July sales on account: line Collected in July Total cash collected Schedule of Cash Payments Shakti Power Inc. was organized on February 28. Projected selling and administrative expenses for each of the first three months of operations are as follows: March $79,000 April 89,000 May 101,000 Depreciation, Insurance, and property taxes represent 86,000 of the estimated monthly expenses. The annual insurance premium was paid on February 28, and property taxes for the year will be paid in November, Sixty percent of the remainder of the expenses are expected to be paid in the month in which they are incurred, with the balance to be paid in the following month. 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. Prepare a schedule indicating cash payments for selling and administrative expenses for March, April, and May, Enter all amounts as positive numbers. SHAKTI POWER INC. Schedule of Cash Payments for Selling and Administrative Expenses For the Three Months Ending May 31 March April May March expenses: Paid in March Paid in April April expenses: Paid in April Paid in May May expenses: Paid in May Total cash payments lin $