Question

In: Accounting

Stampede Corporation, a Calgary based steak house, used the following data to evaluate their current operating...

Stampede Corporation, a Calgary based steak house, used the following data to evaluate their current operating system. The company sells items for $20 each and used a budgeted selling price of $20 per unit.

Actual

Budgeted

Units Sold

200,000units

203,000

Variable Costs

1,250,000

1,500,000

Fixed Costs

925,000

900,000

Required:

1) Prepare a Level 1 static-budget variance analysis for Stampede Corporation using an income statement in contribution margin format. Use the following three column headings: Actual Results, Static Budget, and Static-budget Variance.

Solutions

Expert Solution

Static-budget variance analysis
Actual Results Static-budget Variance Static-budget Variance
Sales Revenue $                        4,000,000.00 $      60,000.00 Unfavorable $                   4,060,000.00
Variable Costs $                        1,250,000.00 $    250,000.00 Favorable $                   1,500,000.00
Contrbution Per unit $                        2,750,000.00 $    190,000.00 Favorable $                   2,560,000.00
Fixed Cost $                           925,000.00 $      25,000.00 Unfavorable $                      900,000.00
Net Income $                        1,825,000.00 $    165,000.00 Favorable $                   1,660,000.00

Related Solutions

Static and Flexible Budgets Graham Corporation used the following data to evaluate its current operating system....
Static and Flexible Budgets Graham Corporation used the following data to evaluate its current operating system. The company sells items for $10 each and used a budgeted selling price of $10 per unit. Actual Budgeted Units sold 1,482,000 1,500,000 Variable costs 2,815,000 3,000,000 Fixed costs 2,490,000 2,425,000 a. Prepare the actual income statement, flexible budget, and static budget. Do not use negative signs with any of your answers below. Actual Results Flexible Budget Static Budget Units sold Answer Answer Answer...
Static and Flexible Budgets Graham Corporation used the following data to evaluate its current operating system....
Static and Flexible Budgets Graham Corporation used the following data to evaluate its current operating system. The company sells items for $10 each and used a budgeted selling price of $10 per unit. Actual Budgeted Units sold 991,000 1,000,000 Variable costs 1,280,000 1,500,000 Fixed costs 955,000 905,000 a. Prepare the actual income statement, flexible budget, and static budget. Do not use negative signs with any of your answers below. Actual Results Flexible Budget Static Budget Units sold Answer Answer Answer...
Static and Flexible Budgets Graham Corporation used the following data to evaluate its current operating system....
Static and Flexible Budgets Graham Corporation used the following data to evaluate its current operating system. The company sells items for $10 each and used a budgeted selling price of $10 per unit. Actual Budgeted Units sold 794,000 800,000 Variable costs 1,745,000 2,000,000 Fixed costs 1,420,000 1,375,000 a. Prepare the actual income statement, flexible budget, and static budget. Do not use negative signs with any of your answers below. Actual Results Flexible Budget Static Budget Units sold Answer Answer Answer...
The Excel file Myatt Steak House provides five years of data on key business results for...
The Excel file Myatt Steak House provides five years of data on key business results for a restaurant. Identify the leading and lagging measures, find the correlation matrix, and propose a cause-and-effect model using the strongest correlations. Myatt Steak House 2010 2011 2012 2013 2014 Order Accuracy X1 86.0% 86.0% 89.0% 90.0% 95.0% Timeliness of Delivery X2 84.0% 82.0% 86.0% 93.0% 95.0% Table Cleanliness X3 4.8 4.8 5.1 5.6 5.8 Customer Satisfication X4 93.4% 93.2% 94.2% 95.3% 96.7% Total #...
The following scenario will be used for the next four questions. Operating data for the Abraham...
The following scenario will be used for the next four questions. Operating data for the Abraham Company for fiscal 2017 are presented below. Abraham has one building, and the space in the building is divided about equally between manufacturing and retailing. Approximately 20% of the labor costs incurred in manufacturing are for supervisory labor, and the remaining 80% of the salaries are paid to employees directly engaged in manufacturing jobs for clients. Purchases of raw material in 2017 $220,000 Manufacturing...
Answer the following questions using the information below: ABC Corp. used the following data to evaluate...
Answer the following questions using the information below: ABC Corp. used the following data to evaluate its current operating system. The company sells items for $21 each and used a budgeted selling price of $21 per unit.                                                                    Actual             Budgeted         Units sold                           180,000 units      185,000 units         Variable costs                         $1,080,000           $1,295,000         Fixed costs                                 $ 800,000              $ 775,000 1) What is the static-budget variance of revenues? A) $105,000 favorable B) $105,000 unfavorable C) $8,000 favorable D) $8,000 unfavorable 2)...
Based on the following information, how much cash was provided (used) by Operating, Investing, and Financing...
Based on the following information, how much cash was provided (used) by Operating, Investing, and Financing Activities Net Income for the year was $545,000, which includes a gain of $10,000 from the sale of equipment that originally cost $100,000 and had a net book value of $25,000. Cash increased $300,000, Accounts Receivable decreased $25,000, Inventory increased $50,000, Equipment increased $150,000, Accumulated Depreciation decreased $25,000. Accounts Payable decreased $20,000, Salaries Payable decreased $15,000, Long-Term Notes Payable increased $100,000. Repaid $250,000 of...
Based on the following data for the current year, what is the number of days' sales...
Based on the following data for the current year, what is the number of days' sales in receivables? Assume 365-Day year. Sales on account during year $570,068 Cost of goods sold during year 219,238 Accounts receivable, beginning of year 46,044 Accounts receivable, end of year 51,623 Inventory, beginning of year 91,672 Inventory, end of year 116,124 Round your answer up to the nearest whole day. a.31 b.74 c.67 d.140
Ducks inc has provided the following data to be used to evaluate a proposed investment project:...
Ducks inc has provided the following data to be used to evaluate a proposed investment project:                         Investment $880,000                         Annual Cash Receipt $660,000                         Life of the project 8 years                         Annual cash expenses $330,000                         Salvage value $88,000                         Tax rate 30% For tax purpose the entire initial investment without any reduction for salvage value will be depreciated over 7 years. The company uses a discount rate of 12%. When computing the...
Operating data for Navarro Corporation are presented below.
Operating data for Navarro Corporation are presented below.   Instructions Prepare a schedule showing a vertical analysis for 2017 and 2016.
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT