Question

Bay City Company’s fixed budget performance report for July follows. The $587,000 budgeted total expenses include...

Bay City Company’s fixed budget performance report for July follows. The $587,000 budgeted total expenses include $400,000 variable expenses and $187,000 fixed expenses. Actual expenses include $177,000 fixed expenses.

Fixed Budget Actual Results Variances
Sales (in units) 8,000 6,900
Sales (in dollars) $ 640,000 $ 621,000 $ 19,000 U
Total expenses 587,000 550,000 37,000 F
Income from operations $ 53,000 $ 71,000 $ 18,000 U


Prepare a flexible budget performance report that shows any variances between budgeted results and actual results. List fixed and variable expenses separately.

BAY CITY COMPANY
Flexible Budget Performance Report
For Month Ended July 31
Flexible budget Actual results Variances Fav./Unf.
Contribution margin

Homework Answers

Answer #1
BAY CITY COMPANY
Flexible Budget Performance Report
For Month Ended July 31
Flexible budget Actual results Variances Fav./Unf.
Sales 552000 621000 69000 Favorable
Variable expenses 345000 373000 28000 Unfavorable
Contribution margin 207000 248000 41000 Favorable
Fixed expenses 187000 177000 10000 Favorable
Income from operations 20000 71000 51000 Favorable
Workings:
Sales in flexible budget = 640000/8000*6900 =$552000
Variable expenses in flexible budget = 400000/8000*6900 =$345000
Know the answer?
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
Similar Questions
Bay City Company’s fixed budget performance report for July follows. The $594,000 budgeted total expenses include...
Bay City Company’s fixed budget performance report for July follows. The $594,000 budgeted total expenses include $450,000 variable expenses and $144,000 fixed expenses. Actual expenses include $134,000 fixed expenses. Fixed Budget Actual Results Variances Sales (in units) 8,100 7,000 Sales (in dollars) $ 648,000 $ 623,000 $ 25,000 U Total expenses 594,000 556,000 38,000 F Income from operations $ 54,000 $ 67,000 $ 13,000 U Prepare a flexible budget performance report that shows any variances between budgeted results and actual...
Solitaire Company’s fixed budget performance report for June follows. The $315,000 budgeted expenses include $268,800 variable...
Solitaire Company’s fixed budget performance report for June follows. The $315,000 budgeted expenses include $268,800 variable expenses and $46,200 fixed expenses. Actual expenses include $54,100 fixed expenses. Fixed Budget Actual Results Variances Sales (in units) 8,400 10,800 Sales (in dollars) $ 420,000 $ 540,000 $ 120,000 F Total expenses 315,000 378,000 63,000 U Income from operations $ 105,000 $ 162,000 $ 57,000 F Prepare a flexible budget performance report showing any variances between budgeted and actual results. List fixed and...
Business Solutions's second-quarter 2018 fixed budget performance report for its computer furniture operations follows. The $171,510...
Business Solutions's second-quarter 2018 fixed budget performance report for its computer furniture operations follows. The $171,510 budgeted expenses include $122,310 in variable expenses for desks and $16,200 in variable expenses for chairs, as well as $33,000 fixed expenses. The actual expenses include $34,300 fixed expenses. List fixed and variable expenses separately. Fixed Budget Actual Results Variances Desk sales (in units) 151 157 Chair sales (in units) 60 68 Desk sales $ 197,810 $ 204,100 $ 6,290 F Chair sales 30,600...
Exercise 21-3 Preparing a flexible budget performance report LO P1 Solitaire Company’s fixed budget performance report...
Exercise 21-3 Preparing a flexible budget performance report LO P1 Solitaire Company’s fixed budget performance report for June follows. The $300,000 budgeted expenses include $272,000 variable expenses and $28,000 fixed expenses. Actual expenses include $36,500 fixed expenses. Fixed Budget Actual Results Variances Sales (in units) 8,000 10,400 Sales (in dollars) $ 400,000 $ 520,000 $ 120,000 F Total expenses 300,000 364,000 64,000 U Income from operations $ 100,000 $ 156,000 $ 56,000 F Prepare a flexible budget performance report showing...
Exercise 8-3 Preparing a flexible budget performance report LO P1 Solitaire Company’s fixed budget performance report...
Exercise 8-3 Preparing a flexible budget performance report LO P1 Solitaire Company’s fixed budget performance report for June follows. The $330,000 budgeted expenses include $264,000 variable expenses and $66,000 fixed expenses. Actual expenses include $75,000 fixed expenses. Fixed Budget Actual Results Variances Sales (in units) 8,800 11,200 Sales (in dollars) $ 440,000 $ 560,000 $ 120,000 F Total expenses 330,000 392,000 62,000 U Income from operations $ 110,000 $ 168,000 $ 58,000 F Prepare a flexible budget performance report showing...
Business Solutions's second-quarter 2020 fixed budget performance report for its computer furniture operations follows. The $171,060...
Business Solutions's second-quarter 2020 fixed budget performance report for its computer furniture operations follows. The $171,060 budgeted expenses include $117,260 in variable expenses for desks and $19,800 in variable expenses for chairs, as well as $34,000 fixed expenses. The actual expenses include $35,600 fixed expenses. List fixed and variable expenses separately. Fixed Budget Actual Results Variances Desk sales (in units) 143 149 Chair sales (in units) 66 74 Desk sales $ 178,750 $ 184,760 $ 6,010 F Chair sales 38,280...
Serial Problem Business Solutions LO P1 Business Solutions's second-quarter 2020 fixed budget performance report for its...
Serial Problem Business Solutions LO P1 Business Solutions's second-quarter 2020 fixed budget performance report for its computer furniture operations follows. The $161,230 budgeted expenses include $109,600 in variable expenses for desks and $18,630 in variable expenses for chairs, as well as $33,000 fixed expenses. The actual expenses include $34,300 fixed expenses. List fixed and variable expenses separately. Fixed Budget Actual Results Variances Desk sales (in units) 137 143 Chair sales (in units) 69 77 Desk sales $ 172,620 $ 178,750...
Success Systems’ second quarter 2014 fixed budget performance report for its computer furniture operations follows. The...
Success Systems’ second quarter 2014 fixed budget performance report for its computer furniture operations follows. The $159,690 budgeted expenses include $106,400 in variable expenses for desks and $18,290 in variable expenses for chairs, as well as $35,000 fixed expenses. The actual expenses include $36,500 fixed expenses. List fixed and variable expenses separately. Fixed Budget Actual Results Variances   Desk sales (in units) 140       146         Chair sales (in units) 59       67         Desk sales (in dollars) $ 189,000      ...
Phoenix Company’s 2017 master budget included the following fixed budget report. It is based on an...
Phoenix Company’s 2017 master budget included the following fixed budget report. It is based on an expected production and sales volume of 17,000 units. PHOENIX COMPANY Fixed Budget Report For Year Ended December 31, 2017 Sales $ 4,250,000 Cost of goods sold Direct materials $ 850,000 Direct labor 340,000 Machinery repairs (variable cost) 51,000 Depreciation—Plant equipment (straight-line) 315,000 Utilities ($34,000 is variable) 184,000 Plant management salaries 215,000 1,955,000 Gross profit 2,295,000 Selling expenses Packaging 68,000 Shipping 102,000 Sales salary (fixed...
Exercise 21-4 Preparing a flexible budget performance report LO P1 Xion Co. budgets a selling price...
Exercise 21-4 Preparing a flexible budget performance report LO P1 Xion Co. budgets a selling price of $81 per unit, variable costs of $34 per unit, and total fixed costs of $280,000. During June, the company produced and sold 11,800 units and incurred actual variable costs of $361,000 and actual fixed costs of $295,000. Actual sales for June were $985,000. Prepare a flexible budget report showing variances between budgeted and actual results. List variable and fixed expenses separately. (Indicate the...