Im re posting the problem sheet and excel where answers are placed. the two attachments go together. can these six be completed please

Problem 1 - 20 Points Standard and Actual numbers have been provided for Direct Material, Direct Labor and Fixed MO, Variable MO. Calculate all variances indicated and also identify each variance as either Favorable (F) or Unfavorable (U). Standard numbers provided are for 1 unit of final product manufactured. Round all TOTAL VARIANCES to the nearest dollar for analysis purposes. Problem #2 - 15 Points: You have been given the sales for a series of months. The collection pattern is at the bottom and indicates 40% collected in the month of the sales, 30% in the next month and the remaining 25% in the third month. Uncollectible amounts are 5% of total monthly sales and ignored. Calculate the amount of cash collections in the Third Quarter. The columns represent the amounts that will be collected in that particular month. The rows represent the distribution of cash collections over the collection pattern months, related to the sales in the month listed on each row. Problem #3 - 20 Points: Calculate the cash flow budget for Empire Enterprises for the 2016 year, on a quarterly basis. All revenue and expense items have been provided. Complete all necessary calculations for the cash budget. The minimum cash ending balance for each quarter is $50,000. You have a total line of credit available in the amount of $300,000. Interest per quarter is 3% calculated on a simple interest basis and paid only when principal on the loan is repaid, i.e. interest is not accrued. All borrowings are considered to occur on the first day of a quarter. All repayments are considered to occur on the last day of a quarter. All borrowings/repayments are in increments of $1,000, except for a total payoff where the exact amount is paid. Beginning cash balance on January 1, 2016 will be $70,000. Problem #4 - 15 Points: Jefferson Digital Diagnostics Products started their annual budget process. You are developing the Production Budget for the 4th quarter of 2016. The monthly sales budgets are given in units. The ending inventory of units has been provided for September. Management desires an ending inventory of 20% of the next month's sales units---raw material supplies from vendors are tight due to insufficient production capacity in suppliers' network. Calculate the production budget for the 4th Quarter, by month and total. Problem #5 - 15 Points: Bubbly Brew is specialty beer producer. Beer is produced by the keg. Each keg requires 0.25 DLH to produce. Kegs produced are given. The base DL pay is $10/hour for hours worked. A 10% pay increase will go into effect April 1. There is no minimum payment for labor cost. Employees receive a 50% overtime premium on base hourly wage rate for all overtime hours worked. Contract negotiations indicate that all DLH in excess of 5,000/month are subject to overtime pay. You are calculating the base pay and overtime premium in two separate lines and adding them together. Calculate the DL budget. Problem #6 - 15 Points: Mays Landing Manufacturing, Inc. produces two products for the high tech industry in its NJ facilities: The company expects, during the current year, to produce and sell: Product Product - PD-88 Product - ND-76 Units 423 288 The company uses activity-based costing to compute unit product costs for external reports. Using the activitybased costing approach, determine the overhead cost per unit for each product. Data relating to the company's four activity cost pools are shown on the spreadsheet: Activity Cost Pool Purchase orders Direct material movement Machinery Setups General factory Estimated Overhead Costs $24,000 $145,215 $16,640 $361,800 Expected Activity Product - PD-88 46 350 22 2,080 Expected Activity Product - ND-76 34 280 10 1,940 Calculate the Activity Rate for all activity pools. Calculate the applied ABC costs for both products, given the expected sales above and the actual activity for each product. Determine both the total ABC overhead costs and the overhead cost per unit. Production units: 10,000 Standards: Material Std. Quantity 4.50 Std. Price $12.44 Actuals: Material Act. Quantity 44,800 Act. Price $12.40 AP AQ AH Total Actual 10,000 Standards: Std. MH Hours 5.40 Std. Rate $20.00 Actuals: Act. MH Hours 53,800 Act. Rate $20.05 Labor Labor SP Material price variance Variance Quantity Total Variance F/U SQ Material quantity variance Variance Price Total Variance F/U Total Variance F/U SR Labor rate variance Variance Quantity Total Variance F/U SH Labor efficiency variance Variance Rate Total Variance F/U Total Variance F/U Total material variance Total Standard Total Actual AR Production units: Total labor variance Total Standard Production units: 10,000 Variable Overhead Information Standards: Std. MH Hours VOH 1.75 Actuals: VOH Act. MH Hours 16,900 Std. Rate $3.70 Act. Rate $3.75 Fixed Overhead Information Standards: Std. Mach Hours FOH 17,500 Actuals: FOH Std. Rate $12.20 Actual FOH $206,900 Budget FOH $207,500 SR VOH spending variance Variance Quantity Total Variance F/U SH VOH efficiency variance Variance Rate Total Variance F/U Total Variance F/U Actual FOH FOH budget (spending) variance = Actual FOH - Budgeted FOH Budgeted FOH Total Variance F/U Budgeted FOH FOH volume variance = Budgeted FOH - FOH Applied to WIP Applied FOH Total Variance F/U AR AH Total Actual Total Actual Total VOH variance Total Standard Total FOH variance Total Standard Total Variance F/U Third Quarter 2016 - Cash Collections Budget Budgeted Revenues By Month Month of Sale May June 2,400,800 3,670,900 July August 5,864,847 September 9,144,286 6,020,500 Total 3rd. Qtr. 21,029,633 Month of Collection - Budgeted Collections From Revenues Month of Sale May June July August September Total 3rd. Qtr. - - May June July August September Total Collections - - Quarter 1 Cash Balance - Beginning Quarter 2 Quarter 3 Quarter 4 Total Year 70,000 Cash Receipts - product sales 690,000 625,000 500,000 890,000 2,705,000 Cash Receipts - service fees 131,000 102,000 70,000 44,000 347,000 Direct material cost 215,000 246,000 190,000 220,000 871,000 Direct labor cost 310,000 266,000 264,000 290,000 1,130,000 Manufacturing overhead 210,000 115,000 132,000 175,000 632,000 Selling & administrative 146,000 110,000 74,000 109,000 439,000 Total Cash Available Total Cash Disbursements Cash Flow - Excess (deficiency) Financing: Borrowings - Line of credit Repayments - Line of Credit Interest Paid - Line of Credit Total Financing - - - - - Cash Balance - Ending - - - - - Budgeted sales in units Desired ending inventory Total needs Beginning inventory Required production Production Budget - 4th Quarter - 2016 Oct Nov 135,700 165,600 Dec 212,120 Quarter Bubbly Brew, Inc. Jan Kegs produced Feb Mar Apr May Jun 14,000 15,000 20,000 24,000 25,000 20,000 0.25 0.25 0.25 0.25 0.25 0.25 5,000 5,000 5,000 5,000 5,000 5,000 $ 10.00 $ 10.00 $ 10.00 $ 11.00 $ 11.00 $ 11.00 $ 5.00 $ 5.00 $ 5.00 $ 5.50 $ 5.50 $ 5.50 Direct Labor per Keg Total required Direct Labor hours Overtime base hours Overtime hours Direct Labor cost per DLH Base pay for DLH @ Labor rate Overtime premium per DLH Overtime premium pay Total Direct Labor Cost Total 118,000 0.25 Expected Activity Activity Cost Pool Purchase orders Direct material movement Machinery Setups General factory Estimated Overhead Costs $24,000 $145,215 $16,640 $361,800 Activity Cost Pool Purchase orders Direct material movement Machinery Setups General factory Estimated Overhead Costs $24,000 $145,215 $16,640 $361,800 Product - PD-88 46 350 22 2080 Product - ND-76 34 280 10 1940 Expected Activity Activity Rate Total - The overhead cost charged to each product is: Product - PD-88 Total Units produced and sold Purchase orders Direct material movement Machinery Setups General factory Total overhead cost Overhead cost per unit: Activity 423 6 43 3 49 Product - ND-76 Amount Activity 288 14 32 8 65 Amount