You need to check for variance in last quarter's payroll. One of the coders, Shannon, leftthe department at the end of July, so the department outsourced the coding function untilyou filled the position in September.CoderJulyAugSeptTotal BudgetedAmount$2,500$3,500$2,000$7,500$10,500$6,000Shannon$3,500$2,000$3,500$2,000$2,250JessieLurlineLarsonOutsourcingExpectedActual$3000$8.000$8,000$8,000$24,0004.5.6.Variance7.8.9.10. What is the total variance for the 3-month period from July to September?11. Lurline makes $24,000 per year and receives a 5% raise effective January. What is Lurline's newmonthly salary?The CFO has asked you to use facility data to determine reimbursement for a proposednew service that is estimated to treat a given number of patients from five specialtyDRGS. She also wants to know how the proposed new patients would affect the facility'sCMI (currently 1.995). Calculate the missing information in the table.DRGRelative | Blended | Payment perWeightExpected Totalof New Patients Reimbursement WeightsEstimated No.TotalRatePatientA0.1327$29401.6502.3.В2.162$29404.2005.6.C3.07$29407.2008.9.0.8122$294010.40011.12.E3.003$294013.15014.15.16. What is the estimated total reimbursement for all patients if the new service is added?17. What is the CMI for the new DRGS?18. The current CMI of 1.995 was calculated on a patient volume of 19,000, with total relative weights of37,905.00. If the proposed expansion of services is implemented, what is the new CMI?

Variance analysis is a type of research of the gap between planned and actual data. The sum of all…

You need to check for variance in last quarter's payroll. One of the coders, Shannon, left the department at the end of July, so the department outsourced the coding function until you filled the position in September. Coder July Aug Sept Total Budgeted Amount Shannon Jessie Lurline Larson Outsourcing Expected Actual $2,500 $3,500 $2,000 $3,500 $2,000 $3.500 $2,000 $2,250 $7,500 $10,500 $6,000 $3000 $8,000 5. $8.000 6. $8,000 $24,000 4. Variance 7. 8. 9.

You need to check for variance in last quarter's payroll. One of the coders, Shannon, left the department at the end of July, so the department outsourced the coding function until you filled the position in September. Coder July Aug Sept Total Budgeted Amount Shannon Jessie Lurline Larson Outsourcing Expected Actual $2,500 $3,500 $2,000 $3,500 $2,000 $3.500 $2,000 $2,250 $7,500 $10,500 $6,000 $3000 $8,000 5. $8.000 6. $8,000 $24,000 4. Variance 7. 8. 9.

Excel Applications for Accounting Principles

4th Edition

ISBN:9781111581565

Author:Gaylord N. Smith

Publisher:Gaylord N. Smith

Chapter23: Flexible Budgeting (flexbud)

Section: Chapter Questions

Problem 4R

See similar textbooks

Similar questions

The controller of Conrad Aiken Surgical Center was reviewing monthly financial reports and noted some differences. The center had fallen 8 short of its plan to perform 450 procedures during the month. Despite that shortfall, surgical revenue exceeded the $830,250 budget, coming in at $848,640. 1. Construct the flexible budget estimate for revenue, procedures, and revenue per procedure. Budgeted Flexible Actual A. Revenue 830,250 848,640 B. Procedures 450 442 C. Revenue per procedure $1,845 $1,920 2. Calculate the revenue volume variance. 3. Calculate the revenue rate variance . 4. Is the unfavorable variance caused by volume or by the rate? Enter VOLUME or RATE as your answer.
Finch is a retail company specializing in men's hats. Its budget director prepared the list of expected operating expenses that follows. All items are paid when incurred except sales commissions and utilities, which are paid in the month following their incurrence. July is the first month of operations, so there are no beginning account balances. July $18,400 3,300 August $18,400 3,300 September $18,400 3,300 Salary expense Sales commissions (4 percent of sales) Supplies expense Utilities 370 400 430 2,200 2,200 2,200 4,000 4,000 6,700 Depreciation on store equipment 4,000 6,700 Rent 6,700 Miscellaneous 610 610 610 Total S&A expenses before interest $35,580 $35,610 $35,640 Required a. Prepare a schedule of cash payments for selling and administrative expenses. b. Determine the amount of utilities payable as of September 30. c. Determine the amount of sales commissions payable as of September 30. Complete this question by entering your answers in the tabs below. Req A Req B and C…
Fanning is a retail company specializing in men's hats. Its budget director prepared the list of expected operating expenses that follows. All items are paid when incurred except sales commissions and utilities, which are paid in the month following their incurrence. July is the first month of operations, so there are no beginning account balances. Salary expense Sales commissions (4 percent of sales) Supplies expense July $17,800 3,400 August $17,800 September $17,800 3,400 3,400 290 320 350 Utilities 2,900 3,000 5,800 2,900 3,000 5,800 2,900 3,000 5,800 Depreciation on store equipment Rent Miscellaneous 720 720 720 Total S&A expenses before interest $33,910 $33,940 $33,970 Required a. Prepare a schedule of cash payments for selling and administrative expenses. b. Determine the amount of utilities payable as of September 30. c. Determine the amount of sales commissions payable as of September 30.
Gibson is a retail company specializing in men's hats. Its budget director prepared the list of expected operating expenses that follows. All items are paid when incurred except sales commissions and utilities, which are paid in the month following their incurrence. July is the first month of operations, so there are no beginning account balances. Salary expense Sales commissions (4 percent of sales) Supplies expense Utilities Depreciation on store equipment Rent Miscellaneous Total S&A expenses before interest Required a. Prepare a schedule of cash payments for selling and administrative expenses. b. Determine the amount of utilities payable as of September 30. c. Determine the amount of sales commissions payable as of September 30. Complete this question by entering your answers in the tabs below. Req A Req B and C July $18,300 August September $18,300 $18,300 2,800 2,800 2,800 290 320 350 2,500 2,500 2,500 2,700 2,700 2,700 5,700 5,700 5,700 790 790 790 $33,080 $33,110 $33, 140…
SPU, Ltd., has just received its sales expense report for January, which follows. Item Amount Sales commissions $ 430,500 Sales staff salaries 88,400 Telephone and mailing 51,000 Building lease payment 50,000 Utilities 16,100 Packaging and delivery 74,000 Depreciation 38,750 Marketing consultants 61,190 You have been asked to develop budgeted costs for the coming year. Because this month is typical, you decide to prepare an estimated budget for a typical month in the coming year and you uncover the following additional data: Sales volume is expected to increase by 14 percent. Sales prices are expected to decrease by 10 percent. Commissions are based on a percentage of sales revenue. Sales staff salaries will increase 4 percent next year regardless of sales volume. Building rent is based on a five-year lease that expires in three years. Telephone and mailing expenses are scheduled to increase by 10 percent even with no change in sales volume.…
The budget director for Fanning Cleaning Services prepared the following list of expected selling and administrative expenses. All expenses requiring cash payments are paid for in the month incurred except salary expense and insurance. Salary is paid in the month following the month in which it is incurred. The insurance premium for six months is paid on October 1. October is the first month of operations; accordingly, there are no beginning account balances. Required Complete the schedule of cash payments for S&A expenses by filling in the missing amounts. Determine the amount of salaries payable the company will report on its pro forma balance sheet at the end of the fourth quarter. Determine the amount of prepaid insurance the company will report on its pro forma balance sheet at the end of the fourth quarter.
The budget director for Fanning Cleaning Services prepared the following list of expected selling and administrative expenses. All expenses requiring cash payments are paid for in the month incurred except salary expense and insurance. Salary is paid in the month following the month in which it is incurred. The insurance premium for six months is paid on October 1. October is the first month of operations; accordingly, there are no beginning account balances. Required Complete the schedule of cash payments for S&A expenses by filling in the missing amounts. Determine the amount of salaries payable the company will report on its pro forma balance sheet at the end of the fourth quarter. Determine the amount of prepaid insurance the company will report on its pro forma balance sheet at the end of the fourth quarter. Salaries Payable: ?? Prepaid insurance: ??
Pina Company estimates that sales revenue will be $72000 during July, $62000 for June, and $77200 for May In the past, the company collected 63% of its receivables in the month of sale, 30% in the month following the sale, and 7% in the second month following the sale. How much are the budgeted collections from customers for the month of July? $69364 $45360 O $72000 $62000
PROBLEM Filling in for his supervisor, who suddenly left the company, Harvey quickly evaluated the situation to wrap up his department's production budget. The department currently holds enough inventory to be in compliance with its standard which is based on the following month's budgeted sales. From the sales and previous budgets, he learned the budgeted unit sales for the next 4 months and the standard for holding inventory at month end which are both presented here. Unit sales per month Month 1 Month 2 Month 3 Month 4 Ending inventory standard Materials held at month end 5,000 4,500 6,000 6,500 10% Required: Provide input into cells shaded in yellow in this template. Input the required mathematical formulas or functions with cell references to the Problem area or work area as indicated. Show the production budget that Harvey would assemble for the next quarter. Budgeted sales volume Target ending FG Inventory Total units needed Beginning FG Inventory Budgeted units to be produced…
Bernes Kennel uses tenant-days as its measure of activity; an animal housed in the kennel for one day is counted as one tenant-day. During October, the kennel budgeted for 2,700 tenant-days, but its actual level of activity was 2,720 tenant-days. The kennel has provided the following data concerning the formulas to be used in its budgeting: Fixed element per month Variable element per tenant-day Revenue $ 0 $ 30.80 Wages and salaries $ 3,300 $ 6.10 Food and supplies 600 10.10 Facility expenses 8,800 3.60 Administrative expenses 7,600 0.10 Total expenses $ 20,300 $ 19.90 The activity variance for wages and salaries in October would be closest to: Multiple Choice A. $298 U B. $122 F C. $298 F D. $122 U
Rundle is a retail company specializing in men's hats. Its budget director prepared the list of expected operating expenses that follows. All items are paid when incurred except sales commissions and utilities, which are paid in the month following their incurrence. July is the first month of operations, so there are no beginning account balances. Salary expense Sales commissions (4 percent of sales) Supplies expense Utilities Depreciation on store equipment Rent Miscellaneous Total S&A expenses before interest Total payments for S&A expenses July $ 17,700 3,300 280 1,400 2,900 6,000 680 $ 32,260 Complete this question by entering your answers in the tabs below. $ Required a. Prepare a schedule of cash payments for selling and administrative expenses. b. Determine the amount of utilities payable as of September 30. c. Determine the amount of sales commissions payable as of September 30. Req A Req B and C Prepare a schedule of cash payments for selling and administrative expenses.…
Ruozzo Corporation is a service company that measures its output by the number of customers served. The company has provided the following fixed and variable cost estimates that it uses for budgeting purposes and the actual results of operations for July. Variable Element per Fixed Element Customer Actual Total per Month Served for July Revenue $ 4,500 $ 900 $ 500 $ 100,000 $ 63,300 $ 11,500 $ 37,900 Employee salaries and wages Travel expenses $ 43,100 Other expenses $ 36,900 When the company prepared its planning budget at the beginning of July, it assumed that 27 customers would have been served. However, 22 customers were actually N served during July. The activity variance for net operating income for July would have been closest to: