Mellow Clinic bases its budgets on patient-visits. The clinic has provided the following data concerning the formulas it uses in its budgetirVariableelement perFixedelementper month patient-visit$60.00RevenuesPersonnel expensesMedical supplies$24,000$6.60$2.40$6,000$5,000Occupancy expensesAdministrative expensesThe behaviour of the revenue and expenses is valid for between 1,500 and 4,000 patient-visits per month.Required:) Prepare a flexible budget for 2,000 and 3,000 patient-visits in a month. (14 marks) You may not need to use all the cells.Patient -visits10 The behaviour of the revenue and expenses is valid for between 1.500 and 4,.000 patient-visits per month1112 Required:13 a) Prepare a flexible budget for 2,000 and 3,000 patient-visits in a month. (14 marks) You may not need to use all the cells.14isPatient -visitsVariableelementper month2,0003,000RevenuesLess: variable expensesMedical suppliesOccupancy expensesTotal variable expensesContribution marginLess: fixed expensesPersonnel expensesOccupancy expensesAdministrative expensesotal fixed expensesN FB1 Answer SheetNew.

In case of fixed cost irrespective of the number of patient visit the cost remain same whereas in…

Fixed Variable element element per per month patient-visit $60.00 Revenues $24,000 Personnel expenses Medical supplies $6.60 $2.40 Occupancy expenses Administrative expenses $6,000 $5,000 The behaviour of the revenue and expenses is valid for between 1,500 and 4,000 patient-visits per month. tequired: Prepare a flexible budget for 2,000 and 3,000 patient-visits in a month. (14 marks) You may not need to use all the cells. Patient -visits

Fixed Variable element element per per month patient-visit $60.00 Revenues $24,000 Personnel expenses Medical supplies $6.60 $2.40 Occupancy expenses Administrative expenses $6,000 $5,000 The behaviour of the revenue and expenses is valid for between 1,500 and 4,000 patient-visits per month. tequired: Prepare a flexible budget for 2,000 and 3,000 patient-visits in a month. (14 marks) You may not need to use all the cells. Patient -visits

Managerial Accounting

15th Edition

ISBN:9781337912020

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

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

Chapter8: Budgeting

Section: Chapter Questions

Problem 4PA: Budgeted income statement and supporting budgets for three months Bellaire Inc. gathered the...

See similar textbooks

Similar questions

Digital Solutions Inc. uses flexible budgets that are based on the following data: Prepare a flexible selling and administrative expenses budget for October for sales volumes of 500,000, 750,000, and 1,000,000.
Nozama.com Inc. sells consumer electronics over the Internet. For the next period, the budgeted cost of the sales order processing activity is 250,000 and 50,000 sales orders are estimated to be processed. a. Determine the activity rate of the sales order processing activity. b. Determine the amount of sales order processing cost associated with 30,000 sales orders.
Budgeted income statement and supporting budgets for three months Bellaire Inc. gathered the following data for use in developing the budgets for the first quarter (January, February, March) of its fiscal year: Estimated sales at 125 per unit: Estimated finished goods inventories: Work in process inventories are estimated to be insignificant (zero). Estimated direct materials inventories: Manufacturing costs: Selling expenses: Instructions Prepare the following budgets using one column for each month and a total column for the first quarter, as shown for the sales budget: Prepare a sales budget for March. Prepare a production budget for March. Prepare a direct materials purchases budget for March. Prepare a direct labor cost budget for March. Prepare a factory overhead cost budget for March. Prepare a cost of goods sold budget for March. Prepare a selling and administrative expenses budget for March. Prepare a budgeted income statement with budgeted operating income for March.
Mesa Aquatics, Inc. estimated direct labor hours as 1,900 in quarter 1, 2,000 in quarter 2.2,200 in quarter 3, and 1,800 in quarter 4. a sales and administration budget using the information provided.
Judges Gavel uses this information when preparing their flexible budget: direct materials of $3 per unit, direct labor of $2.50 per unit, and manufacturing overhead of $1.25 per unit. Fixed costs are $49,000. What would be the budgeted amounts for 33,000 and 35,000 units?
Starburst Inc. has the following items and amounts as part of its master budget at the 10,000-unit level of sales and production: Determine the total dollar amounts for the above items that would appear in a flexible budget at the following volume levels, assuming that both levels are within the relevant range: a. 8,000-unit level of sales and production b. 12,000-unit level of sales and production (Hint: You must first determine the unit selling price and certain unit costs.)
Before the year began, the following static budget was developed for the estimated sales of 100,000. Sales are sluggish and management needs to revise its budget. Use this information to prepare a flexible budget for 80,000 and 90,000 units of sales.
Before the year began, the following static budget was developed for the estimated sales of 50,000. Sales are higher than expected and management needs to revise its budget. Prepare a flexible budget for 100,000 and 110,000 units of sales.
Shalimar Company manufactures and sells industrial products. For next year, Shalimar has budgeted the follow sales: In Shalimars experience, 10 percent of sales are paid in cash. Of the sales on account, 65 percent are collected in the quarter of sale, 25 percent are collected in the quarter following the sale, and 7 percent are collected in the second quarter after the sale. The remaining 3 percent are never collected. Total sales for the third quarter of the current year are 4,900,000 and for the fourth quarter of the current year are 6,850,000. Required: 1. Calculate cash sales and credit sales expected in the last two quarters of the current year, and in each quarter of next year. 2. Construct a cash receipts budget for Shalimar Company for each quarter of the next year, showing the cash sales and the cash collections from credit sales. 3. What if the recession led Shalimars top management to assume that in the next year 10 percent of credit sales would never be collected? The expected payment percentages in the quarter of sale and the quarter after sale are assumed to be the same. How would that affect cash received in each quarter? Construct a revised cash budget using the new assumption.
Budgeted income statement and supporting budgets The budget director of Jupiter Helmets Inc., with the assistance of the controller, treasurer, production manager, and sales manager, has gathered the following data for use in developing the budgeted income statement for May: Prepare a cost of goods sold budget for May. Work in process at the beginning of May is estimated to be $4200. and work in process at the end of May is desired to be $3800.
Friendly Bank is attempting to determine the cost behavior of its small business lending operations. One of the major activities is the application activity. Two possible activity drivers have been mentioned: application hours (number of hours to complete the application) and number of applications. The bank controller has accumulated the following data for the setup activity: Required: 1. Estimate a regression equation with application hours as the activity driver and the only independent variable. If the bank forecasts 2,600 application hours for the next month, what will be the budgeted application cost? 2. Estimate a regression equation with number of applications as the activity driver and the only independent variable. If the bank forecasts 80 applications for the next month, what will be the budgeted application cost? 3. Which of the two regression equations do you think does a better job of predicting application costs? Explain. 4. Run a multiple regression to determine the cost equation using both activity drivers. What are the budgeted application costs for 2,600 application hours and 80 applications?
Pilsner Inc. purchases raw materials on account for use in production. The direct materials purchases budget shows the following expected purchases on account: Pilsner typically pays 25% on account in the month of billing and 75% the next month. Required: 1. How much cash is required for payments on account in May? 2. How much cash is expected for payments on account in June?