Question
In: Accounting
Kite Company has the following report for August: Flexible Sales Actual budget Flexible activity Master Results...
Kite Company has the following report for August:
|
Flexible |
Sales |
||||
|
Actual |
budget |
Flexible |
activity |
Master |
|
|
Results |
variances |
budget |
variances |
budget |
|
|
Units |
? |
12000 |
4000 U |
? |
|
|
Sales revenue |
? |
12000 F |
168000 |
? |
? |
|
Variable mfg. costs |
96000 |
? |
? |
? |
120000 |
|
Variable mktg. costs |
? |
4800 U |
21600 |
? |
? |
|
Contribution margin |
57600 |
? |
? |
18800 U |
75200 |
Fill in the missing amounts. For items in the variances columns, indicate F or U.
Solutions
Expert Solution
| Flexible | Sales | ||||
| Actual | budget | Flexible | activity | Master | |
| Results | variances | budget | variances | budget | |
| Units | 12,000 | 12,000 | 4000 U | 16,000 | |
| Sales revenue | 1,80,000 | 12000 F | 1,68,000 | 56000 U | 2,24,000 |
| Variable mfg. costs | 96,000 | 6000 U | 90,000 | 30000F | 1,20,000 |
| Variable mktg. costs | 26,400 | 4800 U | 21,600 | 7200 F | 28,800 |
| Contribution margin | 57,600 | 1200F | 56,400 | 18800 U | 75,200 |
Working:
| Flexible | Sales | ||||
| Actual | budget | Flexible | activity | Master | |
| Results | variances | budget | variances | budget | |
| Units |
12,000 (Same as Flexible budget) |
12,000 | 4000 U |
16,000 (12000+4000) |
|
| Sales revenue |
1,80,000 (168000+12000) |
12000 F | 1,68,000 |
56000 U (168000-224000) |
2,24,000 (168000/12000)*16000 |
| Variable mfg. costs | 96,000 |
6000 U (90000-96000) |
90,000 (120000/16000)*12000 |
30000F (120000-90000) |
1,20,000 |
| Variable mktg. costs |
26,400 (21600+4800) |
4800 U | 21,600 |
7200 F (28800-21600) |
28,800 (21600/12000)*16000 |
| Contribution margin | 57,600 |
1200F (57600-56400) |
56,400 (75200-18800) |
18800 U | 75,200 |
Please give positive rating.
ekkarill92 answered 1 year agoRelated Solutions
Performance Report Year Ended December 31, 2017 Actual Flexible-Budget Flexible Sales-Volume Static Results Variances Budget Variances...
Performance Report
Year Ended December 31, 2017
Actual
Flexible-Budget
Flexible
Sales-Volume
Static
Results
Variances
Budget
Variances
Budget
Units sold
108,000
99,000
Revenues (sales)
$702,000
$420,750
Variable costs
430,000
237,600
Contribution margin
272,000
183,150
Fixed costs
193,850
105,000
Operating income
$78,150
$78,150
The Beekman Company produces engine parts for car manufacturers.
A new accountant intern at Beekman has accidentally deleted the
calculations on the company's variance analysis calculations for
the year ended December 31, 2017.
Requirement 1. Calculate all the required...
The following information is for X Company for 2017: Master Actual Budget Results Production 10,900 units...
The following information is for X Company for 2017:
Master
Actual
Budget
Results
Production
10,900 units
12,000 units
Total variable costs
$99,190
$108,226
Total fixed costs
$197,300
$201,669
1. What was the 2017 master (static) budget for total costs?
2. What was the 2017 flexible budget for total costs?
Actual Results Revenue & Spending Variances Flexible-budget Activity Variances Planning (Static) Budget TotalVariance Shoes sold (q)...
Actual Results
Revenue & Spending Variances
Flexible-budget
Activity Variances
Planning (Static) Budget
TotalVariance
Shoes sold (q)
$19,000
20,000
Revenue ($4.00q)
$79,000
$80,000
Expenses:
COGS ($1.50q)
$31,000
$30,000
Wages and salaries ($8,000 + $.50q)
$16,000
$18,000
Supplies ($.25q)
$4,600
$5,000
Insurance
($2,000)
$2,100
$2,000
Miscellaneous costs ($.30q)
$5,400
$6,000
Total expenses
$59,100
$61,000
Net operating income
$19,900
$19,000
Completely fill in table above.
Activity-Based Flexible Budgeting Foy Company has a welding activity and wants to develop a flexible budget...
Activity-Based Flexible Budgeting
Foy Company has a welding activity and wants to develop a
flexible budget formula for the activity. The following resources
are used by the activity:
• Four welding units, with a lease cost of $15,000 per year per
unit
• Six welding employees each paid a salary of $60,000 per year
(A total of 9,000 welding hours are supplied by the six
workers.)
• Welding supplies: $300 per job
• Welding hours: 3 hours used per job...
You are given the following static budget report: Budget Actual Variance Unit Sales  
You are given the following static budget report:
Budget Actual Variance
Unit
Sales 10,000 15,000 5,000
F
Variable Expenses:
Commissions $30,000
$33,000 $3,000 U
Advertising $1,000
$1,200 $200 U
Travel $10,000
$11,000 $1,000 U
Samples $2,500
$2,300 $200 F
Total
Variable $43,500
47,500 $4,000 U
Fixed Expenses
Rent $5,000
$5,000 0
Salaries –
Sales $2,000
$2,000 0
Salaries –
Office $1,200
$1,200 0
Depreciation $1,500
$1,500 0
Total
Fixed $9,700
$9,700 0
Total Expenses $53,200 $57,200 $4,000 U
Prepare a flexible budget analysis and explain whether you
believe that costs were controlled. How do the results
of...
Activity Flexible Budgeting, Performance Report, Volume Variance Novo, Inc., wants to develop an activity flexible budget...
Activity Flexible Budgeting, Performance Report, Volume
Variance
Novo, Inc., wants to develop an activity flexible budget for the
activity of moving materials. Novo uses eight forklifts to move
materials from receiving to stores. The forklifts are also used to
move materials from stores to the production area. The forklifts
are obtained through an operating lease that costs $18,000 per year
per forklift. Novo employs 25 forklift operators who receive an
average salary of $50,000 per year, including benefits. Each move...
Activity Flexible Budgeting, Performance Report, Volume Variance Novo, Inc., wants to develop an activity flexible budget...
Activity Flexible Budgeting, Performance Report, Volume
Variance
Novo, Inc., wants to develop an activity flexible budget for the
activity of moving materials. Novo uses eight forklifts to move
materials from receiving to stores. The forklifts are also used to
move materials from stores to the production area. The forklifts
are obtained through an operating lease that costs $18,000 per year
per forklift. Novo employs 25 forklift operators who receive an
average salary of $50,000 per year, including benefits. Each move...
Foy Company has a welding activity and wants to develop a flexible budget formula for the...
Foy Company has a
welding activity and wants to develop a flexible budget formula for
the activity. The following resources are used by the activity:
• Four welding units,
with a lease cost of $15,000 per year per unit
• Six welding
employees each paid a salary of $58,000 per year (A total of 12,000
welding hours are supplied by the six workers.)
• Welding supplies:
$400 per job
• Welding hours: 4
hours used per job
During the year,...
Flexible Budget for Varying Levels of Activity Nashler Company has the following budgeted variable costs per...
Flexible Budget for Varying Levels of Activity
Nashler Company has the following budgeted variable costs per
unit produced:
Direct materials $7.20
Direct labor 1.54
Variable overhead:
Supplies 0.23
Maintenance 0.19
Power 0.18
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. Round your answers to the nearest...
Flexible Budget for Varying Levels of Activity Nashler Company has the following budgeted variable costs per...
Flexible Budget for Varying Levels of Activity
Nashler Company has the following budgeted variable costs per
unit produced:
Direct materials
$7.10
Direct labor
1.54
Variable overhead:
Supplies
0.23
Maintenance
0.19
Power
0.17
Budgeted fixed overhead costs per month include supervision of
$98,000, depreciation of $77,000, and other overhead of
$242,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. Round your answers to the nearest...
ADVERTISEMENT
ADVERTISEMENT
Latest Questions
- METAR Abbreviations METAR (Meteorological Aviation Report) is a format for reporting weather information, either for pilots...
- The data below are the heights of fathers and sons (inches). There are 8 rows in...
- Without quantization procedure how much of actual information is lost during analog to digital conversion process??...
- 11. Suppose that a 32M × 16 memory built using 512K × 8 RAM chips and...
- Write a C++ program that asks the user to enter in three numbers and displays the...
- Economist Steven Landsburg argues that if one believes in the death penalty for murderers because of...
- Need this in C# and also the Pseudocode. Program 4: In 1789, Benjamin Franklin is known...
ADVERTISEMENT