Question

please show how you solved this. thank you!ООО Q Search Sheet Chapter_7_Inc-Class Group Work 1 (1) View Formulas Data Review + Share Home K16 Insert x Page Layout fx SS

0 0
Add a comment Improve this question Transcribed image text
Answer #1

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

Add a comment
Know the answer?
Add Answer to:
please show how you solved this. thank you! ООО Q Search Sheet Chapter_7_Inc-Class Group Work 1...
Your Answer:

Post as a guest

Your Name:

What's your source?

Earn Coins

Coins can be redeemed for fabulous gifts.

Not the answer you're looking for? Ask your own homework help question. Our experts will answer your question WITHIN MINUTES for Free.
Similar Homework Help Questions
  • Q Search Sheet Chapter_7_Inc-Class Group Work 2 (1) View Formulas Data Review + Share Home 051...

    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...

    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...

    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...

    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...

    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....

    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...

    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....

    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...

    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...

    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...

ADVERTISEMENT
Free Homework Help App
Download From Google Play
Scan Your Homework
to Get Instant Free Answers
Need Online Homework Help?
Ask a Question
Get Answers For Free
Most questions answered within 3 hours.
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT