Complete the flexible budget variance analysis by filling in the blanks in the partial flexible budget performance report for 10,000 travel locks for Gable, Inc. (Click the icon to view the report.) (For variances with a $0 value, make sure to enter "0" in the appropriate cells.) Gable, Inc. Flexible Budget Performance Report (partial) For the Month Ended April 30, 2024 Actual Results Units 10,000 Sales Revenue $ 160,000 51,600 Variable Costs Contribution Margin 108,400 15,600 Fixed Costs $ 92,800 Operating Income Flexible Budget Flexible Variance Budget 10,000 $ 140,000 49,500 90,500 14,500 EA 76,000

Complete the flexible budget variance analysis by filling in the blanks in the partial flexible budget performance report for 10,000 travel locks for Gable, Inc. (Click the icon to view the report.) (For variances with a $0 value, make sure to enter "0" in the appropriate cells.) Gable, Inc. Flexible Budget Performance Report (partial) For the Month Ended April 30, 2024 Actual Results Units 10,000 Sales Revenue $ 160,000 51,600 Variable Costs Contribution Margin 108,400 15,600 Fixed Costs $ 92,800 Operating Income Flexible Budget Flexible Variance Budget 10,000 $ 140,000 49,500 90,500 14,500 EA 76,000

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 2E: Digital Solutions Inc. uses flexible budgets that are based on the following data: Prepare a...

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.
Please use Excel.
Assume that a company provided the following excerpts of information from its flexible budget performance report: Actual Flexible Planning Results Budget Budget Flights (q) 52 ? ? Expenses: Wages and salaries ($4,000 + $88.00q) $ 8,510 ? $ 8,400 What is the spending variance for wages and salaries expense? $66 U $176 F $176 U $66 F
i only need the planning budget. help asap pls
Hi, can explain to me step by step? TQ Squillace Corporation uses customers served as its measure of activity. During October, the company budgeted for 38,000 customers, but actually served 35,000 customers. The company has provided the following data concerning the formulas used in its budgeting and its actual results for October:
The followings are the budget for next financial year (1 January 2023 - 31 December 2023), indicating the average selling price and variable costs of each product category. The common fixed manufacturing overhead and the fixed non-manufacturing overhead costs are estimated to be $1,250,000 and $2,778,320 respectively. Table 1: Budget Jan - Dec 2023 Sales Quantity (in units) In $ Unit selling price Unit production cost Unit selling & admin variable costs (5% of selling price) In $ Revenue Variable Production Costs Selling & Admin Variable Costs Model 1 8,400 600 250 30 Folding Bike Model 2 7,500 400 180 20 Model 3 3,500 480 200 24 Electric Bike 800 2,000 850 100 Total 20,200 5,040,000 3,000,000 1,680,000 1,600,000 11,320,000 (2,100,000)| (1,350,000)| (700,000)| (680,000)| (4,830,000) (252,000) (150,000) (84,000) (80,000) (566,000) Q1. Based on the above budgeted information, calculate the expected breakeven units for the Model 2 folding bikes.
The controller of the Stump Company is preparing the budget for 2021 and needs to estimate a cost function for delivery costs. Information regarding delivery costs incurred in the prior 2 months are: LOADING... (Click the icon to view the information.) Requirements 1. Estimate the cost function for delivery. 2. Can the constant in the cost function be used as an estimate of fixed delivery cost per month? Explain. Requirement 1. Estimate the cost function for delivery. Delivery costs = + ( × ) Delivery costs = + ( × ) Requirement 2. Can the constant in the cost function be used as an estimate of fixed delivery cost per month? Explain. The cost function in requirement 1 is an estimate of how costs behave ▼ outside of within the relevant range, not at cost levels ▼ outside within the relevant range. If there are no months with zero miles driven represented in the delivery cost…
The following production and cost information is for X Company for 2019: Budgeted 10,600 productionunits Budgeted costs: Total fixed Per-unit $9.13 variable Actual $236,000 12,600 productionunits Actual costs: Total fixed Total variable $261,960 $93,625 1. What was the 2019 static budget? 2. What was the 2019 flexible budget?
Please do a and b thank you
The following relates to a given department of Caloy for the first quarter of 2020: Actual FOH (fixed plus Variable) Budget formula Total FOH application rate Spending Variance (from 3-way) Volume variance (from 2-way) Overall factory overhead variance What were the actual hours worked in this department during the quarter? a. 110,000 b. 121,000 c. 137,000 d. 153,000 P178,500 P110,000 + PO.50 per hour P1.50 P8,000 U P5,000 F P6,000 U What were the standard hours allowed for good output in this department? a. 105,000 b. 106,667 c. 110,000 d. 115,000
Flexible Budgets and the Breakdown of the Total Operating Income Variance Assumethat in October 2019 the Schmidt Machinery Company (Exhibit 14.1) manufactured and sold950 units for $835 each. During this month, the company incurred $475,000 total variable costsand $180,000 total fixed costs. The master (static) budget data for the month are as given inExhibit 14.1.Required (Round all your answers to the nearest whole number): 1. Prepare a flexible budget for the production and sale of 950 units.2. Compute for October 2019: a. The sales volume variance, in terms of operating income. Indicate whether this variance was favorable (F) or unfavorable (U). b. The sales volume variance, in terms of contribution margin. Indicate whether this variance wasfavorable (F) or unfavorable (U). 3. Compute for October 2019:a. The total flexible-budget (FB) variance. Indicate whether this variance was favorable (F) or unfavorable (U). b. The total variable cost flexible-budget variance. Indicate whether…
Please show how (step-by-step) you get the numbers for each account in the Flexible budget column. Bickel Corporation uses customers served as its measure of activity. The following report compares the planning budget to the actual operating results for the month of November: Bickel Corporation Comparison of Actual Results to Planning Budget For the Month Ended November 30 Actual Results Planning Budget Variances Customers served........................................ 24,000 25,000 Revenue ($3.60q)......................................... $85,700 $90,000 $4,300 U Expenses: Wages and salaries ($22,200 + $1.20q)...... 48,900 52,200 3,300 F Supplies ($0.50q)...................................... 13,000 12,500 500 U Insurance ($5,700)..................................... 5,600 5,700 100 F Miscellaneous expense ($4,500 +…