please show how you solved this. thank you!
a)
Actual results | Flexible budget variance (Actual -flexible) | Flexible budget | (Mater budget -flexible budget) | Master Budget | |
sales | 46000*60= 2760000 | 230000 F | 46000*55= 2530000 | 55000 F | 45000*55= 2475000 |
variable cost | 46000*34= 1564000 | 46000 F | 46000*35= 1610000 | 35000 U | 45000*35= 1575000 |
contribution margin | 1196000 | 276000 F | 920000 | 20000 F | 900000 |
Fixed cost | 627000 | 33000 F | 660000 | 0 NA | 660000 |
Net income | 569000 | 309000 F | 260000 | 20000 F | 240000 |
**If Actual revenue is higher than Flexible budget revenue then variance is favorable (and vise versa)
If actual cost is less than flexible budget then variance is favorable (and vise versa)
**If Flexible budget revenue is higher than master budget revenue ,then variance is favorable (and vise versa)
If cost is less than master budget then variance is favorable (and vise versa)
2)Actual amount spent for material B= Flexible budget variance + unfavorable variance -Favorable variance
= 39000 + 800 -400
= 39400
please show how you solved this. thank you! ООО Q Search Sheet Chapter_7_Inc-Class Group Work 1...
Q Search Sheet Chapter_7_Inc-Class Group Work 2 (1) View Formulas Data Review + Share Home 051 Insert x v Page Layout fx 2 3 The actual information pertains to the month of June. As part of the budgeting process, Colonial Fencing Company developed the following static budget for September. Colonial is in the process of preparing the flexible budget and understanding the results. Actual Results 19.000 Flexible Budget Static Budget 20.500 Sales volume (in units) $ 615,000 10 Sales revenues...
Q.3) (24 points) The Table Company manufactures tables for schools. The 20XX operating budget is based on sales of 40,000 units at $50 per table. Operating income is anticipated to be $120,000. Budgeted variable costs are $32 per unit, while fixed costs total $600,000. Actual income for 20XX was a surprising $354,000 on actual sales of 42,000 units at $52 each. Actual variable costs were $30 per unit and fixed costs totaled $570,000. Prepare a variance analysis table that presents...
AVE ME - 9 82) White Shark Surfboards Company manufactures tables for schools. The 2018 operating budget is based on sales of 20 000'units at $100 per table. Operating profit is anticipated to be S120 000.- bu Budgeted variable costs are $64 per unit, while fixed costs total 5600 000 Actual income for 2018 was a surprising 5354 000 on actual sales of 21 000 units at $104 each. Actual variable costs were $60 per unit and fixed costs totalled...
Bach Table Company manufactures tables for schools. The current year operating budget is based on sales of 40,000 units at $50 per table. Operating income is anticipated to be $300,000. Budgeted variable costs are $30 per unit, while fixed costs total $500,000 Actual income for the year was a surprising $2,268,000 on actual sales of 42,000 units Actual variable costs were $33 per unit and fixed costs totaled $550,000 Required: Prepare a Level 2 variance analysis report with both flexible-budget...
Please show excel equations. Thank you
Simon Enterprises has the following information available: Actual Budget 15,000 $20 $8 $145,000 Units Sold Selling Price Variable Costs Per Unit Fixed Costs 12,000 $21 $150.000 Required 1. Prepare the static budget using all of the budgeted amount 2. Prepare the actual income statement using all of the actual amounts 3. Prepare the flexible budget 4. Calculate the sales volume variances 5. Calculate the flexible budget variances 6. Comment on the results Actual Flex...
If you could show work it would be greatly appreciated SallyMay, Inc., designs and manufactures T-shirts. It sells its T-shirts to brand name clothes retailers in lots of one dozen. SallyMay's May 2013 static budget and actual results for direct inputs are as follows: Static Budget Number of T-shirt lots (1 lot1 dozen) 400 Per Lot of T-shirts: Direct materials 14 meters at $1.70 per meter$23.80 Direct manufacturing labor 1.6 hours at $8.10 per hour $12.96 Actual Results Number of...
please help with this question and all the requirements. Thank
You!
Kanco Industries has a relevant range extending to 30,800 units each month. The following performance report provides information about Kanco's budget and actual performance for June. (Click the icon to view the performance report.) Requirement Fill in all missing numbers in the table. Be sure to label any variances as favorable or unfavorable. (Enter the variances as positive numbers. If the variance is 0, make sure to enter in...
1. Prepare the flexible budget using the information provided.
Show calculations/explain where the numbers come from.
2. Answer the corresponding questions about the variances of the
budget.
Class Exercise for Standard Cost BUDGET 10,000 FLEXIBLE Units of output planned and actual ACTUAL 9,000 Direct material units per unit of output units price Labor units per unit of output hours rate Sales 300,000 306,000 Less variable costs of manufacturing Direct Material Direct Labor Factory Overhead Total 120,000 40,000 60,000 220,000 117,000...
Requirement 2. Comment on the results in requirement 1. Please
help with choosing the comments based on the answer above
The total static-budget variance in operating income is $
(number)
There is a(n) (Favorable/Unfavorable)
total flexible-budget
variance and a(n) (Favorable/Unfavorable)
sales-volume variance. The sales-volume variance arises solely
because actual units
manufactured and sold were (less/more)
than the budgeted 3,700 units. The flexible-budget variance in
operating income is due
primarily to the (increase/decrease)
in unit variable costs.
Anderson Enterprises manufactures tires...
Complete the flexible budget variance analysis by filling in the blanks in the partial flexible budget performance report for 11,000 travel locks for Gianni, Inc. B (Click the icon to view the report) (For variances with a $0 value, make sure to enter "O" in the appropriate cells.) i Data Table Gianni, Inc. Flexible Budget Performance Report (partial) For the Month Ended April 30, 2018 Actual Flexible Budget Results Variance Units 11,000L Sales Revenue S 209,000 Variable Costs 51,900 Contribution...