please don't solve it in excel and please explain how to calculate the sale mix variance Q1-The Chair Company manufactures two modular types of chairs: one for the residential market, and the other for the officemarket. Budgeted and actual operating data for the year 2012 are:Static BudgetResidentialOfficeTotalNumber of chairs sold260,000140,000400,000Contribution margin$26,000,000 $11,200,000$37,200,000Actual ResultsResidentialOfficeTotalNumber of chairs sold248,400165,600414,000Contribution margin$22,356,000 $13,248,000 $35,604,000Required:Compute the following variances in terms of contribution margin:a. Compute the total static-budget variance, the total flexible-budget variance, and the total sales-volume variance.b. Compute the sale-mix variance and the sales-quantity variance by type of chair, and in total.

A static budget is one that employs estimated quantities for a certain period prior to the start of…

Answered: plai | bartleby

Business

Accounting

plai

Principles of Cost Accounting

17th Edition

ISBN:9781305087408

Author:Edward J. Vanderbeck, Maria R. Mitchell

Publisher:Edward J. Vanderbeck, Maria R. Mitchell

Chapter7: The Master Budget And Flexible Budgeting

Section: Chapter Questions

Problem 7P: Preparing a performance report Use the flexible budget prepared in P7-6 for the 31,000-unit level...

See similar textbooks

Similar questions

Preparing a performance report Use the flexible budget prepared in P7-6 for the 31,000-unit level and the actual operating results listed below for the 31,000-unit level. Required: 1. Prepare a performance report. 2. List the major reasons why the actual operating income at 31,000 units differs from the master budget operating income at 30,000 units in Figure 7-12. 3. Given the level at which the company operated, how was its cost control? Item Direct materials: Direct labor:
Preparing a performance report Use the flexible budget prepared in P7-6 for the 29,000-unit level of activity and the actual operating results listed below for the 29,000- unit level. Required: 1. Prepare a performance report. 2. List the major reasons why the actual operating income at 29,000 units differs from the master budget operating income at 30,000 units in Figure 7-12. 3. Given the level at which the company operated, how was its cost control? Item Direct materials: Direct labor:
Use the following information for Exercises 9-50 and 9-51: Assume that Stillwater Designs produces two automotive subwoofers: S12L7 and S12L5. The S12L7 sells for 475, and the S12L5 sells for 300. Projected sales (number of speakers) for the coming 5 quarters are as follows: The vice president of sales believes that the projected sales are realistic and can be achieved by the company. Exercise 9-50 Sales Budget Refer to the information regarding Stillwater Designs above. Required: 1. Prepare a sales budget for each quarter of 20X1 and for the year in total. Show sales by product and in total for each time period. 2. CONCEPTUAL CONNECTION How will Stillwater Designs use this sales budget?
Nozama.com Inc. sells consumer electronics over the Internet. For the next period, the budgeted cost of the sales order processing activity is 250,000 and 50,000 sales orders are estimated to be processed. a. Determine the activity rate of the sales order processing activity. b. Determine the amount of sales order processing cost associated with 30,000 sales orders.
The AF PolyU Company manufactures two modular types of doors: one for the residential market, and the other for the office market. Budgeted and actual operating data for the year 2018 are: Static Budget Total 400,000 $26,000,000 $11,200,000 $37,200,000 Office 140,000 Residential Number of chairs sold 260,000 Contribution margin Actual Results Office 165,600 $22,356,000 $13,248,000 $35,604,000 Residential 248,400 Total 414,000 Number of chairs sold Contribution margin Required: Compute the following variances in terms of contribution margin: a. Compute the total static-budget variance, the total flexible-budget variance, and the total sales-volume variance. b. Compute the sale-mix variance and the sales-quantity variance by type of chair, and in total.
Company A manufactures two modular types of doors: one for the residential market, and the other for the office market. Budgeted and actual operating data for the year 2018 are: Static Budget Residential Office Total Number of chairs sold 260,000 140,000 400,000 Contribution margin $26,000,000 $11,200,000 $37,200,000 Actual Results Residential Office Total Number of chairs sold 248,400 165,600 414,000 Contribution margin $22,356,000 $13,248,000 $35,604,000 Required: Compute the following variances in terms of contribution margin: a. Compute the total static-budget variance, the total flexible-budget variance, and the total sales-volume variance. b. Compute the sale-mix variance and the sales-quantity variance by type of chair, and in total.
Howard Cooper, the president of Finch Computer Services, needs your help. He wonders about the potential effects on the firm's net income if he changes the service rate that the firm charges its customers. The following basic data pertain to fiscal Year 1: Standard rate and variable costs Service rate per hour Labor cost Overhead cost Selling, general, and administrative cost. Expected fixed costs Facility maintenance Selling, general, and administrative Required: a. Prepare the pro forma income statement that would appear in the master budget if the firm expects to provide 28,000 hours of services in Year 1. b. A marketing consultant suggests to Mr. Cooper that the service rate may affect the number of service hours that the firm can achieve. According to the consultant's analysis, if Finch charges customers $57 per hour, the firm can achieve 31,000 hours of services. Prepare a flexible budget using the consultant's assumption. c. The same consultant also suggests that if the firm…
Integrated Excel: Preparing a Contribution Format Income Statement Using the High-Low Method Jay Corporation has provided data from a two-year period to aid in planning. The Controller has asked you to prepare a contribution format income statement. Budgeted information for Quarter 1 of 2024: Sales in units Sales price per unit After analyzing expenses, the company has determined the following cost patterns. Cost of Goods Sold (per unit) Sales Commissions (per dollar of sales). Administrative Salaries (per quarter) Rent Expense (per quarter) Depreciation Expense (per quarter) Shipping has been determined to be a mixed cost with the following total costs and units: 2022 Quarter 1 Quarter 2 Quarter 3 Quarter 4 2023 Quarter 1 Quarter 2 Quarter 3 Quarter 4 Total Cost $ 67,000 $ 94,000 $ 89,800 $ 92,600 $ 72,500 $80,000 $ 84,000 $ 100,000 17,000 $ 48.00 Units 12,500 21,000 13,800 20,000 13,700 14,000 14,300 22,500 $29.00 9.50€ $ 45,000 $ 27,000 $ 36,000 Required: Use the data to answer the…
Howard Cooper, the president of Campbell Computer Services, needs your help. He wonders about the potential effects on the firm's net income if he changes the service rate that the firm charges its customers. The following basic data pertain to fiscal Year 3. Standard rate and variable costs Service rate per hour $ 85.00 Labor cost 37.00 Overhead cost 7.10 Selling, general, and administrative cost Expected fixed costs Facility maintenance Selling, general, and administrative 3.80 $522,000 142,000 Required: a. Prepare the pro forma income statement that would appear in the master budget if the firm expects to provide 45,000 hours of services in Year 3. b. A marketing consultant suggests to Mr. Cooper that the service rate may affect the number of service hours that the firm can achieve. According to the consultant's analysis, if Campbell charges customers $80 per hour, the firm can achieve 50,000 hours of services. Prepare a flexible budget using the consultant's assumption. c. The same…
Required information [The following information applies to the questions displayed below.) Adger Corporation is a service company that measures its output based on the number of customers served. The company provided the following fixed and variable cost estimates that it uses for budgeting purposes and the actual results for May as shown below: Fixed Element Variable Element Actual per Customer Total per Month for May $ 182,000 $ 110,300 $ 27,200 $ 32,600 Served $ 5,600 $ 1,600 Revenue $ 55,000 Employee salaries and wages Travel expenses Other expenses 850 $ 34,000 When preparing its planning budget the company estimated that it would serve 30 customers per month; however, during May the company actually served 35 customers. 2. What amount of employee salaries and wages would be included in Adger's flexible budget for May? Amount of employee salaries and wages included in the flexible budget
The S Company produces and sells two product lines with the following budgeted revenues and expenses:Product X Product YExpected total industry sales (units) 76,800 136,000Expected S Company sales (units) 7,680 34,000Budgeted selling price per unit 160 200Budgeted contribution margin per unit 90 125Actual results for 20x2 included: Product X Product YActual industry sales 100,000 145,000Actual S Company sales 12,000 31,900Actual selling price (unit) 150 175Required:1. Calculate the sales-volume, sales-mix and market-share variances in terms of contribution margins.2. In your opinion, when a large sales-volume favourable variance could be an issue?
WHAT IS THE ANSWER OF THE 3? The Chair Company manufactures two modular types of chairs: one for the residential market, and the other for the office market. Budgeted and actual operating data for the year 2012 are: Static Budget Residential Office Total Number of chairs sold 260,000 140,000 400,000 Contribution margin $26,000,000 $11,200,000 $37,200,000 Actual Results Residential Office Total Number of chairs sold 248,400 165,600 414,000 Contribution margin $22,356,000 $13,248,000 $35,604,000 Required: Compute the following variances in terms of contribution margin: a. Compute the total static-budget variance, the total flexible-budget variance, and the total sales-volume variance. b. Compute the sale-mix variance and the sales-quantity variance by type of chair, and in total.