Coronado Clinic's directors are budgeting for administrative staff for next year. They need to plan for enough capacity to handle patients in the clinic's three practice areas: urgent care, general practice, and laboratory. The administrative staff can fluctuate between areas, but they are primarily assigned to one of these stations. There are 31 staff members total, 26 working full-time and 5 working 30 hours per week. Each staff member works 50 weeks each year. Last year, total DL cost (including benefits) for all administrative staff amounted to $1.5 million. The administrators expected 80% of their staff's available time to be dedicated to the key tasks of their job. The time estimates for the key tasks are as follows. Urgent care check-in General practice check-in Laboratory procedure processing Minutes 10 5 5

Coronado Clinic's directors are budgeting for administrative staff for next year. They need to plan for enough capacity to handle patients in the clinic's three practice areas: urgent care, general practice, and laboratory. The administrative staff can fluctuate between areas, but they are primarily assigned to one of these stations. There are 31 staff members total, 26 working full-time and 5 working 30 hours per week. Each staff member works 50 weeks each year. Last year, total DL cost (including benefits) for all administrative staff amounted to $1.5 million. The administrators expected 80% of their staff's available time to be dedicated to the key tasks of their job. The time estimates for the key tasks are as follows. Urgent care check-in General practice check-in Laboratory procedure processing Minutes 10 5 5

Name: Please help me. Thankyou. (d1)How much of the total cost was left unal
Uploaded: 2024-03-20T06:33:06.000Z
Channel: Bartleby
Description: Please help me. Thankyou. (d1)How much of the total cost was left unallocated based on these transactions?DifferenceeTextbook and Mediae Textbook$Save for LaterAssistance UsedAttempts: 0 of 3 usedSubmit Answer Coronado Clinic's directors are budgetin

Cornerstones of Cost Management (Cornerstones Series)

4th Edition

ISBN:9781305970663

Author:Don R. Hansen, Maryanne M. Mowen

Publisher:Don R. Hansen, Maryanne M. Mowen

Chapter7: Allocating Costs Of Support Departments And Joint Products

Section: Chapter Questions

Problem 33P: Biotechtron, Inc., has two research laboratories in the Southwest, one in Yuma, Arizona, and the...

See similar textbooks

Similar questions

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.
Biotechtron, Inc., has two research laboratories in the Southwest, one in Yuma, Arizona, and the other in Bernalillo, New Mexico. The owner of Biotechtron centralized the legal services function in the Yuma office and had both laboratories send any legal questions or issues to the Yuma office. The legal services support center has budgeted fixed costs of 160,000 per year and a budgeted variable rate of 65 per hour of professional time. The normal usage of the legal services center is 2,600 hours per year for the Yuma office and 1,400 hours per year for the Bernalillo office. This corresponds to the expected usage for the coming year. Required: 1. Determine the amount of legal services support center costs that should be assigned to each office. 2. Since the offices produce services, not tangible products, what purpose is served by allocating the budgeted costs? 3. Now, assume that during the year, the legal services center incurred actual fixed costs of 163,000 and actual variable costs of 272,400. It delivered 4,180 hours of professional time2,580 hours to Yuma and 1,600 hours to Bernalillo. Determine the amount of the legal services centers costs that should be allocated to each office. Explain the purposes of this allocation. 4. Did the costs allocated differ from the costs incurred by the legal services center? If so, why?
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?
Norton Company, a manufacturer of infant furniture and carriages, is in the initial stages of preparing the annual budget for the coming year. Scott Ford has recently joined Nortons accounting staff and is interested in learning as much as possible about the companys budgeting process. During a recent lunch with Marge Atkins, sales manager, and Pete Granger, production manager, Ford initiated the following conversation. FORD: Since Im new around here and am going to be involved with the preparation of the annual budget, Id be interested in learning how the two of you estimate sales and production numbers. ATKINS: We start out very methodically by looking at recent history, discussing what we know about current accounts, potential customers, and the general state of consumer spending. Then, we add that usual dose of intuition to come up with the best forecast we can. GRANGER: I usually take the sales projections as the basis for my projections. Of course, we have to make an estimate of what this years closing inventories will be, which is sometimes difficult. FORD: Why does that present a problem? There must have been an estimate of closing inventories in the budget for the current year. GRANGER: Those numbers arent always reliable since Marge makes some adjustments to the sales numbers before passing them on to me. FORD: What kind of adjustments? ATKINS: Well, we dont want to fall short of the sales projections so we generally give ourselves a little breathing room by lowering the initial sales projection anywhere from 5 to 10 percent. GRANGER: So, you can see why this years budget is not a very reliable starting point. We always have to adjust the projected production rates as the year progresses, and of course, this changes the ending inventory estimates. By the way, we make similar adjustments to expenses by adding at least 10 percent to the estimates; I think everyone around here does the same thing. Required: 1. Marge Atkins and Pete Granger have described the use of budgetary slack. a. Explain why Atkins and Granger behave in this manner, and describe the benefits they expect to realize from the use of budgetary slack. b. Explain how the use of budgetary slack can adversely affect Atkins and Granger. 2. As a management accountant, Scott Ford believes that the behavior described by Marge Atkins and Pete Granger may be unethical and that he may have an obligation not to support this behavior. By citing the specific standards of competence, confidentiality, integrity, and/or credibility from the Statement of Ethical Professional Practice (in Chapter 1), explain why the use of budgetary slack may be unethical. (CMA adapted)
Adam Corporation manufactures computer tables and has the following budgeted indirect manufacturing cost information for the next year: If Adam uses the step-down (sequential) method, beginning with the Maintenance Department, to allocate support department costs to production departments, the total overhead (rounded to the nearest dollar) for the Machining Department to allocate to its products would be: a. 407,500. b. 422,750. c. 442,053. d. 445,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.
The Sea Wharf Restaurant would like to determine the best way to allocate a monthly advertising budget of 1,000 between newspaper advertising and radio advertising. Management decided that at least 25% of the budget must be spent on each type of media and that the amount of money spent on local newspaper advertising must be at least twice the amount spent on radio advertising. A marketing consultant developed an index that measures audience exposure per dollar of advertising on a scale from 0 to 100, with higher values implying greater audience exposure. If the value of the index for local newspaper advertising is 50 and the value of the index for spot radio advertising is 80, how should the restaurant allocate its advertising budget to maximize the value of total audience exposure? a. Formulate a linear programming model that can be used to determine how the restaurant should allocate its advertising budget in order to maximize the value of total audience exposure. b. Develop a spreadsheet model and solve the problem using Excel Solver.
Elliott, Inc., has four salaried clerks to process purchase orders. Each clerk is paid a salary of 25,750 and is capable of processing as many as 6,500 purchase orders per year. Each clerk uses a PC and laser printer in processing orders. Time available on each PC system is sufficient to process 6,500 orders per year. The cost of each PC system is 1,100 per year. In addition to the salaries, Elliott spends 27,560 for forms, postage, and other supplies (assuming 26,000 purchase orders are processed). During the year, 25,350 orders were processed. Required: 1. Classify the resources associated with purchasing as (1) flexible or (2) committed. 2. Compute the total activity availability, and break this into activity usage and unused activity. 3. Calculate the total cost of resources supplied (activity cost), and break this into the cost of activity used and the cost of unused activity. 4. (a) Suppose that a large special order will cause an additional 500 purchase orders. What purchasing costs are relevant? By how much will purchasing costs increase if the order is accepted? (b) Suppose that the special order causes 700 additional purchase orders. How will your answer to (a) change?
Novo, Inc., wants to develop an activity flexible budget for the activity of moving materials. Novo uses eight forklifts to move materials from receiving to stores. The forklifts are also used to move materials from stores to the production area. The forklifts are obtained through an operating lease that costs 18,000 per year per forklift. Novo employs 25 forklift operators who receive an average salary of 50,000 per year, including benefits. Each move requires the use of a crate. The crates are used to store the parts and are emptied only when used in production. Crates are disposed of after one cycle (two moves), where a cycle is defined as a move from receiving to stores to production. Each crate costs 1.80. Fuel for a forklift costs 3.60 per gallon. A gallon of gas is used every 20 moves. Forklifts can make three moves per hour and are available for 280 days per year, 24 hours per day (the remaining time is downtime for various reasons). Each operator works 40 hours per week and 50 weeks per year. Required: 1. Prepare a flexible budget for the activity of moving materials, using the number of cycles as the activity driver. 2. Calculate the activity capacity for moving materials. Suppose Novo works at 80 percent of activity capacity and incurs the following costs: Prepare the budget for the 80 percent level and then prepare a performance report for the moving materials activity. 3. Calculate and interpret the volume variance for moving materials. 4. Suppose that a redesign of the plant layout reduces the demand for moving materials to one-third of the original capacity. What would be the budget formula for this new activity level? What is the budgeted cost for this new activity level? Has activity performance improved? How does this activity performance evaluation differ from that described in Requirement 2? Explain.
Iona Company, a large printing company, is in its fourth year of a five-year, quality improvement program. The program began in 20x0 with an internal study that revealed the quality costs being incurred. In that year, a five-year plan was developed to lower quality costs to 10 percent of sales by the end of 20x5. Sales and quality costs for each year are as follows: Budgeted figures. Quality costs by category are expressed as a percentage of sales as follows: The detail of the 20x5 budget for quality costs is also provided. All prevention costs are fixed; all other quality costs are variable. During 20x5, the company had 12 million in sales. Actual quality costs for 20x4 and 20x5 are as follows: Required: 1. Prepare an interim quality cost performance report for 20x5 that compares actual quality costs with budgeted quality costs. Comment on the firms ability to achieve its quality goals for the year. 2. Prepare a one-period quality performance report for 20x5 that compares the actual quality costs of 20x4 with the actual costs of 20x5. How much did profits change because of improved quality? 3. Prepare a graph that shows the trend in total quality costs as a percentage of sales since the inception of the quality improvement program. 4. Prepare a graph that shows the trend for all four quality cost categories for 20x1 through 20x5. How does this graph help management know that the reduction in total quality costs is attributable to quality improvements? 5. Assume that the company is preparing a second five-year plan to reduce quality costs to 2.5 percent of sales. Prepare a long-range quality cost performance report assuming sales of 15 million at the end of five years. Assume that the final planned relative distribution of quality costs is as follows: proofreading, 50 percent; other inspection, 13 percent; quality training, 30 percent; and quality reporting, 7 percent.
A dermatology clinic expects to contract with an HMO for an estimated 80,000 enrollees. The HMO expects 1 in 4 of its enrolled members to use the dermatology services per month. At the end of the year, the dermatology clinic™s business manager looked at her monthly figures and saw that the number of enrolled members had increased by 5% over the budgeted amount, and that 1 in 3 of the total HMO members had used the dermatology services per month. Net monthly revenues of the dermatology clinic were budgeted at $260,000 but were actually $450,000. Monthly expenses for the clinic were budgeted at $200,000 but were actually $270,000. Prepare a monthly revenue, expense, and net income variance budget for the clinic. Are these variances favorable or unfavorable? Why?
Metropolitan Dental Associates is a large dental practice in Chicago. The firm’s controller is preparing the budget for the next year. The controller projects a total of 48,000 office visits, to be evenly distributed throughout the year. Eighty percent of the visits will be half-hour appointments, and the remainder will be one-hour visits. The average rates for professional dental services are $40 for half-hour appointments and $70 for one-hour office visits. Ninety percent of each month’s professional service revenue is collected during the month when services are rendered, and the remainder is collected the month following service. Uncollectible billings are negligible. Metropolitan’s dental associates earn $60 per hour.Metropolitan uses activity-based budgeting to budget office overhead and administrative expenses. Two cost drivers are used: office visits and direct professional labor. The cost-driver rates are as follows: Patient registration and records…