Here are the 2015 revenues for the Wendover Group Practice Association for four different budgets (in thousands of dollars): Static Budget Flexible (Enrollment/ Flexible (Enrollment) Actual Utilization) Budget Budget Results $425 $200 $180 $300 a. What do the budget data tell you about the nature of Wendover's patients: Are they capitated or fee-for-service? (Hint: See the note to Exhibit 8.7.) b. Calculate and interpret the following variances: Revenue variance . Volume variance • Price variance Enrollment variance Utilization variance

Here are the 2015 revenues for the Wendover Group Practice Association for four different budgets (in thousands of dollars): Static Budget Flexible (Enrollment/ Flexible (Enrollment) Actual Utilization) Budget Budget Results $425 $200 $180 $300 a. What do the budget data tell you about the nature of Wendover's patients: Are they capitated or fee-for-service? (Hint: See the note to Exhibit 8.7.) b. Calculate and interpret the following variances: Revenue variance . Volume variance • Price variance Enrollment variance Utilization variance

Managerial Accounting

15th Edition

ISBN:9781337912020

Author:Carl Warren, Ph.d. Cma William B. Tayler

Publisher:Carl Warren, Ph.d. Cma William B. Tayler

Chapter6: Cost-volume-profit Analysis

Section: Chapter Questions

Problem 1CMA: Taylor Corporation is analyzing the cost behavior of three cost items, A, B, and C, to budget for...

See similar textbooks

Similar questions

owa Imaging Center provided the financial information in Exhibit 5.15 below. Prepare a cash budget for the quarter ending March 20X1. For Blackboard you will enter your ENDING cash balance for the months of January 20X1, February 20X1, March 20X1, and the Quarter ending March 20X1. I want you to submit your work for this problem by email so I can review the entire document. Exhibit 5-15 Iowa Imaging Center Givens Revenues and Expenses Patient Revenues, 20X0 Estimated Patient Revenues, 20X1 Given 1 October $4,000,000 Given 2 January $4,300,000 November $4,200,000 February $4,350,000 December $4,300,000 March $4,400,000 Other Revenues, 20X1 Estimated Cash Outflows, 20X1a Given 3 January $90,000 Given 4 January $4,250,000…
Imagine the marketing team has an annual budget for 2022 of $500k. Using the table below, create a tracker in excel that communicates to the marketing team, as of the end of Q2 2022, how their actual spend compares to that which has been budgeted. Make up numbers for Q2 2022, and also make up a few examples of commentary that might explain or give context to the spend that is left and/or has been exceeded. Item Annual budget Revisionist History $ 50,000 The Happiness Lab $ 50,000 Deep Cover $ 50,000 Cautionary Tales $ 40,000 Bad Women $ 25,000 A Slight Change of Plans $ 40,000 The Bomber Mafia $ 65,000 Web development $ 100,000 Marketing tech $ 30,000 Social campaign management $ 50,000 total $ 500,000
a) Why do successful companies tend to use the bottom-up approach to establish a master budget? b) Green Tea’s data show the following information for the financial year, beginning July 2020: July Aug. Sept. Oct. Nov. Estimated sales (units) 25,000 25,000 27,000 27,500 28,000 Sales price per unit $31 $31 $31 $31 $31 Direct labour per unit $1.75 $1.75 $1.50 $1.50 $1.50 Labour rate per hour $21 $21 $24 $24 $24 New machinery will be added in September. This machine will reduce the labour required per unit and increase the labour rate for those employees qualified to operate the machinery. Finished goods inventory is required to be 20% of the next month’s requirements. Direct material requires 2.5 kg per unit at a cost of $5 per kg. The ending inventory required for direct materials is 20% of the next month’s needs. In July, the beginning inventory is 3,750 units of finished goods and 13,125 kg of…
Refer to the information regarding Stillwater Designs above.Required:1. Prepare a sales budget for each quarter of 20X1 and for the year in total. Show sales byproduct and in total for each time period.2. CONCEPTUAL CONNECTION How will Stillwater Designs use this sales budget?
Use the information provided below to prepare the Cash Budget for October, November, and December2021. Provide separate monetary columns for each month.INFORMATION1. The following data and estimates are available for a project of Fego Limited for September toDecember 2021:September October November DecemberR R R RSales 130 000 110 000 120 000 140 000Wages 40 000 34 000 38 000 39 000Fixed overheads 16 000 16 000 16 000 16 000Variable overheads 16 000 13 000 15 000 17 000Materials purchases 17 000 14 000 16 000 18 0002. Sixty percent (60%) of the sales are expected to be for cash and the balance on credit. Creditcustomers usually pay in the month after the sale.3. Labour costs are paid for in the month in which they are incurred.4. Fixed overheads include R5 000 each month for depreciation and payment is made monthly.5. Variable overheads are paid for in the month after they are incurred.6. Direct materials are purchased by electronic funds transfers each month.7. The cash balance on 01…
Consider the following 2019 data for Madison General Hospital (in millions of dollars): Revenues Costs Profits Static Budget $4.7 $4.1 $0.6 Calculate the profit variance. Flexible Budget $4.8 $4.1 $0.7 Actual Results $4.5 $4.2 $0.3
Sanchez Corporation manufactures tables for schools. The 2023 operating budget is based on sales of 100,000 units at $500 per table. Budgeted variable costs are $350 per unit, while fixed costs total $6,000,000. For 2023, actual sales were 110,000 units at $490 each. Actual variable costs were $360 per unit and fixed costs totaled $5,800,000. Required: a) Prepare a report showing actual results, a static budget and a flexible budget. b) Explain the significance of a flexible budget versus a static budget.
Sanchez Corporation manufactures tables for schools. The 2023 operating budget is based on sales of 100,000 units at $500 per table. Budgeted variable costs are $350 per unit, while fixed costs total $6,000,000. For 2023, actual sales were 110,000 units at $490 each. Actual variable costs were $360 per unit and fixed costs totaled $5,800,000. Required: a) Prepare a report showing actual results, a static budget and a flexible budget.
Use the following information for Questions 16 & 17 Ibsen Clinic uses client-visits as its measure of activity. During December, the clinic budgeted for 3,300 client-visits, but its actual level of activity was 3,340 client-visits. The clinic has provided the following data concerning the formulas used in its budgeting and its actual results for December: Data used in budgeting: Revenue Personnel expenses Medical supplies Occupancy expenses Administrative expenses Total expenses Actual results for December: Revenue Personnel expenses Medical supplies 16. $ 134,170 $ 80,776 $ 17,302 Occupancy expenses $ 15,754 Administrative expenses$ 8,296 17. C. d. Fixed element per month a. b. $0 $ 32,400 $76,620 $77,156 $79,809 $80,776 C. d. 1,500 9,100 6,700 $ 49,700 The personnel expenses in the flexible budget for December would be closest to: a. b. Variable element per client-visit $ 40.00 $13.40 4.80 2.10 0.40 $ 20.70 The net operating income in the flexible budget for December would be closest…
Howard Cooper, the president of Finch Computer Services, needs your help. He wonders about the potential effects on the firm's net income if he changes the service rate that the firm charges its customers. The following basic data pertain to fiscal Year 1: Standard rate and variable costs Service rate per hour Labor cost Overhead cost Selling, general, and administrative cost. Expected fixed costs Facility maintenance Selling, general, and administrative Required: a. Prepare the pro forma income statement that would appear in the master budget if the firm expects to provide 28,000 hours of services in Year 1. b. A marketing consultant suggests to Mr. Cooper that the service rate may affect the number of service hours that the firm can achieve. According to the consultant's analysis, if Finch charges customers $57 per hour, the firm can achieve 31,000 hours of services. Prepare a flexible budget using the consultant's assumption. c. The same consultant also suggests that if the firm…
Chelsea Clinic projected the following budget information for 2020: Total FFS Visit Volume 90,000 visits Payer Mix: Blue Cross Highmark Reimbursement Rates: Blue Cross Highmark Variable Costs Resource Inputs: Labor Supplies Resource Input Prices: Labor Supplies Fixed Costs (overhead, plant, and equipment) 40% 60% $25 per visit $20 per visit 48,000 total hours 100,000 total units $25.00 per hour $1.50 per unit $500,000 a. Construct Chelsea Clinic’s operating budget for 2020. b. Discuss how each key budget assumption might result in a budget variance, and name the variance that would be used to examine results associated with each assumption.
The members of Networx Ltd decide to prepare a Cash Budget for November and December 2018. The following information is available:Actual BudgetedAugust RSeptember ROctober RNovember RDecember RSales:CashCredit194 500287 300235 700350 000275 000410 000250 500400 400368 000697 000Purchases 510 000 490 000 495 000 520 000 680 000Salaries & Wages 72 600 72 600 72 600 72 600 72 600Sundry Expenses 17 800 18 400 22 000 22 600 25 700 Required:Prepare a Cash Budget for the period 1 November and 31 December 2018