refer to attached, thank you!

Singapore Credit Services Limited produces credit rating reports for its customers. The company's standard selling price per report is $25. Each analyst can produce on average four reports per hour. The standard rate of pay for analysts is $20 per hour. Standard variable overhead per analyst hour is $40. The static budget for 20X1 was prepared based on 80,000 credit rating reports but only 70.000 reports were actually done and sold. Fixed costs of rent. supervisors and others were budgeted at $500.000 but the total actual total fixed costs for 20X1 was $550.000. The excess of $50.000 was caused by extra advertising fee incurred in the hope of attracting more sales. Actual total analyst's hours incurred was 17,000. Actual results and budgeted figures for 20X1 are as per follows: Actual Static Budget Flexible Budget Number of Reports 70.000 80.000 Sales $1,680.000 $2.000.000 Credit Analyst $374,000) ($400,000) Variable Overhead $595,000) $800.000) Fixed Overhead ($550,000 ($500,000) Operating Profit $161,000 $300,000 1. Prepare a flexed budget for 20X1 (Complete the column in the above table). 2. Prepare the following variance analyses: a. Credit Analyst Price and Efficiency b. Variable Overhead Spending and Efficiency c. Fixed Overhead Budget and Volume d. Sales Price and Quantity