Margot's Ice Cream operates several stores in a major metropolitan city and its suburbs. Its budget and operating data for the current year follow: Flavor Gallons Budgeted Data Selling Price per Gallon Actual Operating Results Vanilla 324,000 $ 1.95 Variable Costs per Gallon $ 1.25 Selling Price per Variable Costs per Gallons Gallon Gallon 264,000 $ 1.80 $ 1.15 Chocolate 405,000 2.90 2.00 375,000 2.75 1.90 Strawberry Anchovy 270,000 2.50 1.40 400,000 2.70 1.45 81,000 3.90 2.40 201,000 4.40 2.60 Required: 1. Compute these variances for the individual flavors and total quantity sold. (Use the Contribution Margin in your calculations and do not round intermediate calculations.) a. b. C. Flavor Sales Volume Variance Sales Mix Variance Sales Quantity Variance Vanilla Chocolate Strawberry Unfavorable Unfavorable Favorable Unfavorable Favorable Unfavorable Favorable Favorable Favorable Anchovy Favorable Favorable Favorable Total Favorable Favorable Favorable

Margot's Ice Cream operates several stores in a major metropolitan city and its suburbs. Its budget and operating data for the current year follow: Flavor Gallons Budgeted Data Selling Price per Gallon Actual Operating Results Vanilla 324,000 $ 1.95 Variable Costs per Gallon $ 1.25 Selling Price per Variable Costs per Gallons Gallon Gallon 264,000 $ 1.80 $ 1.15 Chocolate 405,000 2.90 2.00 375,000 2.75 1.90 Strawberry Anchovy 270,000 2.50 1.40 400,000 2.70 1.45 81,000 3.90 2.40 201,000 4.40 2.60 Required: 1. Compute these variances for the individual flavors and total quantity sold. (Use the Contribution Margin in your calculations and do not round intermediate calculations.) a. b. C. Flavor Sales Volume Variance Sales Mix Variance Sales Quantity Variance Vanilla Chocolate Strawberry Unfavorable Unfavorable Favorable Unfavorable Favorable Unfavorable Favorable Favorable Favorable Anchovy Favorable Favorable Favorable Total Favorable Favorable Favorable

Cornerstones of Cost Management (Cornerstones Series)

4th Edition

ISBN:9781305970663

Author:Don R. Hansen, Maryanne M. Mowen

Publisher:Don R. Hansen, Maryanne M. Mowen

Chapter3: Cost Behavior

Section: Chapter Questions

Problem 38P: Friendly Bank is attempting to determine the cost behavior of its small business lending operations....

See similar textbooks

Similar questions

Margot’s Ice Cream operates several stores in a major metropolitan city and its suburbs. Its budget and operating data for the current year follow: Flavor Budgeted Data Actual Operating Results Gallons Selling Price per Gallon Variable Costs per Gallon Gallons Selling Price per Gallon Variable Costs per Gallon Vanilla 306,000 $ 1.80 $ 1.10 246,000 $ 1.65 $ 1.00 Chocolate 382,500 2.60 1.70 352,500 2.45 1.60 Strawberry 255,000 2.35 1.25 385,000 2.55 1.30 Anchovy 76,500 3.60 2.10 196,500 4.10 2.30 Required: 1. Compute these variances (sales volume variance, sales mix variance, sales quantity variance) for the individual flavors and total quantity sold. (Use the Contribution Margin in your calculations and do not round intermediate calculations.)
Margot's Ice Cream operates several stores in a major metropolitan city and its suburbs. Its budget and operating data for the current year follow: Flavor Budgeted Data Selling Price per Gallon Actual Operating Results Gallons Variable Costs per Gallon Selling Price per Variable Costs per Gallons Gallon Gallon Vanilla 246,000 $ 1.30 $ 0.60 186,000 $ 1.15 $ 0.50 Chocolate 307,500 1.60 0.70 277,500 1.45 0.60 Strawberry Anchovy 205,000 1.85 0.75 335,000 2.05 0.80 61,500 2.60 1.10 181,500 3.10 1.30 Required: 1. Compute these variances for the individual flavors and total quantity sold. (Use the Contribution Margin in your calculations and do not round intermediate calculations.) Flavor Vanilla Chocolate Strawberry Anchovy Total a. b. Sales Volume Variance Sales Mix Variance Sales Quantity Variance
Margot's Ice Cream operates several stores in a major metropolitan city and its suburbs. Its budget and operating data for the current year follow: Budgeted Data Selling Price per Actual Operating Results Selling Price per Variable Variable Costs per Costs per Flavor Gallons Gallon Gallon Gallons Gallon Gallon $ 1.35 $ 0.65 $ 1.20 $ 0.55 252,000 315,000 210,000 63,000 192,000 285,000 340,000 183,000 Vanilla Chocolate 1.70 0.80 1.55 0.70 Strawberry Anchovy 1.90 0.80 2.10 0.85 2.70 1.20 3.20 1.40 Required: 1. Compute these variances for the individual flavors and total quantity sold. (Use the Contribution Margin in your calculations and do not round intermediate calculations.) a. b. C. Flavor Sales Volume Variance Sales Mix Variance Sales Quantity Variance Vanilla Chocolate Strawberry Anchovy Total
Margot's Ice Cream operates several stores in a major metropolitan city and its suburbs. Its budget and operating data for the current year follow: Budgeted Data Actual Operating Results Flavor Vanilla Chocolate Strawberry Anchovy Required: Gallons Selling Price per Gallon Variable Costs per Selling Price per Variable Costs per Gallon Gallons Gallon Gallon 288,000 $ 1.65 $ 0.95 228,000 $ 1.50 $ 0.85 360,000 2.30 1.40 330,000 2.15 1.30 240,000 2.20 1.10 72,000 3.30 1.80 370,000 192,000 2.40 1.15 3.88 2.00 1. Compute these variances for the individual flavors and total quantity sold. (Use the Contribution Margin in your calculations and do not round intermediate calculations.) Flavor Vanilla Sales Volume Variance Sales Mix Variance Sales Quantity Variance Chocolate Strawberry Anchovy Total
Margot's Ice Cream operates several stores in a major metropolitan city and its suburbs. Its budget and operating data for the current year follow: Budgeted Data Flavor Gallons Selling Price per Gallon Vanilla 324,000 $ 1.95 Variable Costs per Gallon $ 1.25 Actual Operating Results Selling Variable Price per Costs per Gallons Gallon Gallon 264,000 $ 1.80 $ 1.15 Chocolate 405,000 2.90 2.00 375,000 2.75 1.90 Strawberry Anchovy 270,000 2.50 81,000 3.90 1.40 2.40 400,000 201,000 2.70 1.45 4.40 2.60 Required: 1. Compute these variances for the individual flavors and total quantity sold. (Use the Contribution Margin in your calculations and do not round intermediate calculations.) Answer is complete but not entirely correct. b. Flavor Sales Volume Variance Sales Mix Variance Sales Quantity Variance Vanilla $ Chocolate Strawberry Anchovy Total $ 589,000 117,000 Unfavorable 87,000 Unfavorable 325,000 Favorable 468,000 Favorable Favorable $ 210,600 Unfavorable 261,000 Unfavorable 225,000…
Margot's Ice Cream operates several stores in a major metropolitan city and its suburbs. Its budget and operating data for the current year follow: Flavor Gallons Budgeted Data Selling Price per Gallon Actual Operating Results Vanilla 318,000 $ 1.90 Variable Costs per Gallon $ 1.20 Gallons Selling Price per Gallon Variable Costs per Gallon 258,000 $ 1.75 Chocolate 397,500 2.80 1.90 367,500 2.65 $ 1.10 1.80 Strawberry Anchovy 265,000 2.45 79,500 3.80 1.35 2.30 395,000 2.65 1.40 199,500 4.30 2.50 Required: 1. Compute these variances for the individual flavors and total quantity sold. (Use the Contribution Margin in your calculations and do not round intermediate calculations.) Flavor Vanilla Chocolate Strawberry Anchovy Total a. b. Sales Volume Variance Sales Mix Variance Sales Quantity Variance Unfavorable Unfavorable Favorable Favorable
Margot's Ice Cream operates several stores in a major metropolitan city and its suburbs. Its budget and operating data for the current year follow: Budgeted Data Selling Price per Actual Operating Results Selling Price per Variable Variable Costs per Costs per Flavor Gallons Gallon Gallon Gallons Gallon Gallon Vanilla 354,000 442,500 295,000 88,500 $2.20 $1.50 294,000 412,500 425,000 208,500 $2.05 $ 1.40 Chocolate 3.40 2.50 3.25 2.40 Strawberry Anchovy 2.75 1.65 2.95 1.70 4.40 2.90 4.90 3.10 Required: 1. Compute these variances for the individual flavors and total quantity sold. (Use the Contribution Margin in your calculations and do not round intermediate calculations.) a. b. C. Flavor Sales Volume Variance Sales Mix Variance Sales Quantity Variance Vanilla Chocolate Strawberry Anchovy Total Prey Noxt
We discuss how to prepare the different component budgets of theoperating budget, including the sales, production, direct materials,direct labor, manufacturing overhead, cost of goods sold, andselling and administrative expense budgets. We also discuss howto use information from all of these operating budgets to prepare abudgeted income statement. Knowledge Check 05WellWheats, Inc. produces breakfast cereal and sells each box, or unit, for $7.The company is projecting sales of 1,000 units for the month of March. The totalcost of producing one unit includes $2 for direct materials, $1 for direct labor,and $0.50 for manufacturing overhead.Calculate the cost of goods sold for the month of March.
Bean There Inc. manufactures coffee makers. Selected budget and actual information for 2020 are provided below: Budget Information Actual Information Units sold 1 36,000 Sales in dollars $ 1,272,335 1,363,217 Average selling price per unit $ 50 4 Variable cost per unit $ 30 5 Variable cost in total 2 $ 817,930 Fixed selling and admin $ 302,900 $ 293,200 Operating income 3 6 Calculate on excel: 1. Complete the missing information above (1,2,3,4,5,6) 2. Prepare a flexible budget based on the actual quantity of units sold 3. Prepare a performance report comparing actual results to budgeted results in contribution income statement format. Ensure that the report breaks down variances between actual and budget into price and volume variances for sales, variable costs, and selling and admin expenses including which variances are favorable and which…
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.
Friendly Bank is attempting to determine the cost behavior of its small business lending operations. One of the major activities is the application activity. Two possible activity drivers have been mentioned: application hours (number of hours to complete the application) and number of applications. The bank controller has accumulated the following data for the setup activity: Required: 1. Estimate a regression equation with application hours as the activity driver and the only independent variable. If the bank forecasts 2,600 application hours for the next month, what will be the budgeted application cost? 2. Estimate a regression equation with number of applications as the activity driver and the only independent variable. If the bank forecasts 80 applications for the next month, what will be the budgeted application cost? 3. Which of the two regression equations do you think does a better job of predicting application costs? Explain. 4. Run a multiple regression to determine the cost equation using both activity drivers. What are the budgeted application costs for 2,600 application hours and 80 applications?
Required: Prepare the following for the first quarter: 1. Cost of goods sold budget. 2. Selling and administrative expense budget. 3. Budgeted income statement for the handisaw product. Preparing Operating Budgets for a Merchandising Firm РАЗЗ-6 Red Canyon T-shirt Company operates a chain of T-shirt shops in the southwestern United States. The sales manager has provided a sales forecast for the LO33-5 coming year, along with the following information: Quarter 1 Quarter 2 Quarter 3 Quarter 4 Budgeted unit sales 40,000 60,000 30,000 60,000 • Each T-shirt is expected to sell for $15. • The purchasing manager buys the T-shirts for $6 each. • The company needs to have enough T-shirts on hand at the end of each quarter to fill 25 percent of the next quarter's sales demand. Selling and administrative expenses are budgeted at $80,000 per quarter plus 10 percent of total sales revenue. Required: Prepare the following operating budgets for quarters 1, 2, and 3. (You do not have enough…