Please complete the following 8 exercises below in either Excel or a word document (but must be single document). You must show your work where appropriate (leaving the calculations within Excel cells is acceptable). Save the document, and submit it in the appropriate week using the Assignment Submission button. Chapter 6 Exercise 2 2. Schedule of cash collections Sugarland Company sells a single product and anticipates opening a new facility in Charlotte on May 1 of the current year. Expected sales during the first three months of activity are: May, $60,000; June, $80,000; and July, $85,000. Thirty percent of all sales are for cash; the remaining 70% are on account. Credit sales have the following collection pattern: Chapter 6 Exercise 4 4. Production and cash-outlay computations RPR, Inc., anticipates that 120,000 units of product K will be sold during May. Each unit of product K requires four units of raw material A. Actual inventories as of May 1 and budgeted inventories as of May 31 follow. Chapter 6 Exercise 5 5. Abbreviated cash budget; financing emphasis An abbreviated cash budget for Big Chuck Enterprises follows. Chapter 6 Problem 3 3. Comprehensive budgeting The balance sheet of Watson Company as of December 31, 20X1, follows. Chapter 7 Exercise 3 3. Variances for direct materials and direct labor Banner Company manufactures flags of various countries. Each flag has a standard of eight square feet of fabric and three hours of direct labor time. Information about recent production activity follows. Chapter 7 Exercise 5 5. Overhead variances Nova Manufacturing applies factory overhead to products on the basis of direct labor hours. At the beginning of the current year, the company's accountant made the following estimates for the forthcoming period: · Estimated variable overhead: $500,000 · Estimated fixed overhead: $400,000 · Estimated direct labor hours: 40,000 It is now 12 months later. Actual total overhead incurred in the manufacture of 7,900 units amounted to $895,100. Actual labor hours totaled 39,800. Assuming a direct labor standard of five hours per finished unit, calculate the following: a. Variable overhead efficiency variance b. Fixed overhead volume variance c. Overhead spending variance Chapter 7 Problem 1 1. P26-A1 Basic flexible budgeting (L.O. 2) Centron, Inc., has the following budgeted production costs: Direct materials $0.40 per unit Direct labor 1.80 per unit Variable factory overhead 2.20 per unit Fixed factory overhead Supervision $24,000 Maintenance 18,000 Other 12,000 The company normally manufactures between 20,000 and 25,000 units each quarter. Should output exceed 25,000 units, maintenance and other fixed costs are expected to increase by $6,000 and $4,500, respectively. During the recent quarter ended March 31, Centron produced 25,500 units and incurred the following costs: Direct Materials $10,710 Direct Labor 47,175 Variable factory overhead 51,940 Fixed factory overhead Supervision 24,500 Maintenance 23,700 Other 16,800 Total production costs $174,825 Instructions: a. Prepare a flexible budget for 20,000, 22,500, and 25,000 units of activity. b. Was Centron's experience in the quarter cited better or worse than anticipated? Prepare an appropriate performance report and explain your answer. c. Explain the benefit of using flexible budgets (as opposed to static budgets) in the measurement of performance. Chapter 7 Problem 5 5. P26-B3 Straightforward variance analysis (L.O. 5) Arrow Enterprises uses a standard costing system. The standard cost sheet for product no. 549 follows.