F56. Quesnel Clinic bases its budgets on the activity measure patient-visits. During February, the clinic planned for 4,000 patient-visits, butits actual level of activity was 4,200 patient-visits. The clinic has provided the following data concerning the formulas it uses in itsbudgeting:RevenuePersonnel expenses.Medical suppliesOccupancy expensesAdministrative expensesFixed element Variable element perper monthPatient-visitsRevenueExpenses:$ 31,500$1,500$6,500$ 5,500Quesnel ClinicStatic Budget VarianceRequired:Prepare a report showing the clinic's static budget variance for February, Indicate in each case whether the variance is favorable (F) orunfavorable (U). (Indicate the effect of each variance by selecting "F" for favorable, "U" for unfavorable, and "None" for no effect(i.e., zero variance). Input all amounts as positive values.)For the Month Ended February 28Flexible BudgetPlanningBudget4,200patient-visit$ 32.204,000$.9.60$5.60$ 1.60$ 0.16Static Budget Variance

The flexible budget of static budget is prepared to compare the different budgets of production. The…

snel Clinic bases its budgets on the activity measure patient-visits. During February, the clinic planned for 4,000 patient-visits, but actual level of activity was 4,200 patient-visits. The clinic has provided the following data concerning the formulas it uses in its geting: evenue ersonnel expenses edical supplies ccupancy expenses ministrative expenses tient-visits Fixed element per month wenue $ 31,500 $1,500 6,500 5,500 $ $ quired: pare a report showing the clinic's static budget variance for February, Indicate in each case whether the variance is favorable (F) or avorable (U). (Indicate the effect of each variance by selecting "F" for favorable, "U" for unfavorable, and "None" for no effect zero variance). Input all amounts as positive values.) Quesnel Clinic Static Budget Variance For the Month Ended February 28 Flexible Budget Planning Budget 4,200 Variable element per patient-visit $ 32.20 $.9.60 $5.60 1.60 0.16 4,000 $ $ Static Budget Variance

snel Clinic bases its budgets on the activity measure patient-visits. During February, the clinic planned for 4,000 patient-visits, but actual level of activity was 4,200 patient-visits. The clinic has provided the following data concerning the formulas it uses in its geting: evenue ersonnel expenses edical supplies ccupancy expenses ministrative expenses tient-visits Fixed element per month wenue $ 31,500 $1,500 6,500 5,500 $ $ quired: pare a report showing the clinic's static budget variance for February, Indicate in each case whether the variance is favorable (F) or avorable (U). (Indicate the effect of each variance by selecting "F" for favorable, "U" for unfavorable, and "None" for no effect zero variance). Input all amounts as positive values.) Quesnel Clinic Static Budget Variance For the Month Ended February 28 Flexible Budget Planning Budget 4,200 Variable element per patient-visit $ 32.20 $.9.60 $5.60 1.60 0.16 4,000 $ $ Static Budget Variance

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

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.
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.
Eastman, Inc., manufactures and sells three products: R, S, and T. In January, Eastman, Inc., budgeted sales of the following. At the end of the year, actual sales revenue for Product R and Product S was 3,075,000 and 3,254,000, respectively. The actual price charged for Product R was 25 and for Product S was 20. Only 10 was charged for Product T to encourage more consumers to buy it, and actual sales revenue equaled 540,000 for this product. Required: 1. Calculate the sales price and sales volume variances for each of the three products based on the original budget. 2. Suppose that Product T is a new product just introduced during the year. What pricing strategy is Eastman, Inc., following for this product?
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.
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.
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?
At the beginning of the period, the Fabricating Department budgeted direct labor of 72,000 and equipment depreciation of 18,500 for 2,400 hours of production. The department actually completed 2,350 hours of production. Determine the budget for the department, assuming that it uses flexible budgeting.
TIB makes custom guitars and prepared the following sales budget for the second quarter It also has this additional information related to its expenses: Direct material per unit $55, Direct labor per hour 20, Variable manufacturing overhead per hour 3.50, Fixed manufacturing overhead per month 3,000, Sales commissions per unit 20, Sales salaries per month 5,000, Delivery expense per unit 0.50, Utilities per month 4,000. Administrative salaries per month 20,000, Marketing expenses per month 8,000, Insurance expense per month 11,000, Depreciation expense per month 9,000. Prepare a sales and administrative expense budget for each month in the quarter ended June 30. 2018.
The following data were obtained from the financial records of Sonicbrush, Inc., for March: Sales are expected to increase each month by 15%. Prepare a budgeted income statement.
Lens Junction sells lenses for $45 each and is estimating sales of 15,000 units in January and 18,000 in February. Each lens consists of 2 pounds of silicon costing $2.50 per pound, 3 oz of solution costing $3 per ounce, and 30 minutes of direct labor at a labor rate of $18 per hour. Desired inventory levels are: Â Prepare a sales budget, production budget. direct materials budget for silicon and solution, and a direct labor budget.
The sales department of F. Pollard Manufacturing Co. has forecast sales in March to be 20,000 units. Additional information follows: Materials used in production: Prepare the following: a. A production budget for March (in units). b. A direct materials budget for the month (in units and dollars).
Nashler Company has the following budgeted variable costs per unit produced: Budgeted fixed overhead costs per month include supervision of 98,000, depreciation of 76,000, and other overhead of 245,000. Required: 1. Prepare a flexible budget for all costs of production for the following levels of production: 160,000 units, 170,000 units, and 175,000 units. 2. What is the per-unit total product cost for each of the production levels from Requirement 1? (Round each unit cost to the nearest cent.) 3. What if Nashler Companys cost of maintenance rose to 0.22 per unit? How would that affect the unit product costs calculated in Requirement 2?