Assume no beginning or ending inventory (they will produce the products in the same month that they sell them). Ignore taxes. Use contribution margin income statement formatting.
LiveColor is preparing their 2019 budget. They estimate sales/production will be between 700,000 and 900,000 boxes of markers per month. LiveColor wants to look at both static budgets and flexible budgets to determine which is best for them. They have struggled in the past with determining whether budget variances were related to volume being above or below budget vs whether they are spending too much or too little on expenses. They want to be able to understand their budget variances in order to make better decisions.
Monthly Budget Data:
selling price per unit = 5.00/box
raw materials costs = 1.50/box
packaging costs = 0.80/box
salary and wages costs = 300,000/month
OT for production over 800,000 units = 0.70/box
fringe benefits = 50% of wages and OT
electricity= 0.20/box
waste and other costs = 0.10/box
rent costs = 500,000/month
insurance costs = 60,000/month
depreciation costs = 240,000/month
Note: Treat Salary and Wages Costs as Fixed Expenses.
Assume no beginning or ending inventory (they will produce the products in the same month that...
Analysis and explanations can be included in the Excel cells or in a textbox. The submission should be one Excel file only. No additional files should be submitted. Use contribution margin income statement formatting. LiveColor is preparing their 2019 budget. They estimate sales/production will be between 700,000 and 900,000 boxes of markers per month. LiveColor wants to look at both static budgets and flexible budgets to determine which is best for them. They have struggled in the past with determining...
beach Color is preparing their 2019 budget. They estimate sales/production will be between 600,000 and 800,000 boxes of markers per month. Beach Color wants to look at both static budgets and flexible budgets to determine which is best for them. They have struggled in the past with determining whether budget variances were related to volume being above or below budget vs whether they are spending too much or too little on expenses. They want to be able to understand their...
The following information is available for Brownstone Products Company for the month of July: Units Sales revenue Variable manufacturing costs Fixed manufacturing costs Variable selling and administrative expenses Fixed selling and administrative expenses Master Actual Budget 3,900 3,200 $55,800 $60,000 10,900 16,000 12,800 13,800 7,400 8,000 8,800 10,450 Required: 1. What was the total operating income variance for July? (Note: this variance is also called the master (static) budget variance for the period.) Was this variance favorable (F) or unfavorable...
The following information is available for Brownstone Products Company for the month of July: Master Budget 3,800 4,000 $53,200 $60,000 19,000 16,000 16,000 15,000 7,700 8,000 10,000 9,000 Actual Units Sales revenue Variable manufacturing costs Fixed manufacturing costs Variable selling and administrative expenses Fixed selling and administrative expenses Required 1. What was the total operating income variance for July? (Note: this variance is also called the master (static) budget variance for the period.) Was this variance favorable (F) or unfavorable...
Xion Co. budgets a selling price of $81 per unit, variable costs of $35 per unit, and total fixed costs of $278,000. During June, the company produced and sold 11,600 units and incurred actual variable costs of $359,000 and actual fixed costs of $293,000. Actual sales for June were $965,000. Prepare a flexible budget report showing variances between budgeted and actual results. List variable and fixed expenses separately. (Indicate the effect of each variance by selecting for favorable, unfavorable, and...
Xion Co budgets a selling price of $81 per unit, variable costs of $35 per unit, and total fixed costs of $281,000. During June, the company produced and sold 11,900 units and incurred actual variable costs of $362,000 and actual fixed costs of $296,000. Actual sales for June were $995,000 Prepare a flexible budget report showing variances between budgeted and actual results. List variable and fixed expenses separately. (Indicate the effect of each variance by selecting for favorable, unfavorable, and...
Xion Co. budgets a selling price of $83 per unit, variable costs of $35 per unit, and total fixed costs of $283,000. During June, the company produced and sold 12,100 units and incurred actual variable costs of $364.000 and actual fixed costs of $298.000. Actual sales for June were $1.040.000. Prepare a flexible budget report showing variances between budgeted and actual results. List variable and fixed expenses separately. (Indicate the effect of each varlance by selecting for favorable, unfavorable, and...
Exercise 08-4 Preparing a flexible budget performance report LO P1 0.85 points Xion Co. budgets a selling price of $80 per unit, variable costs of $35 per unit, and total fixed costs of $270,000. During June, the company produced and sold 10,800 units and incurred actual variable costs of $351,000 and actual fixed costs of $285,000. Actual sales for June were $885,000. Prepare a flexible budget report showing variances between budgeted and actual results. List variable and fixed expenses separately....
The management of Jordan Modems, Inc. (JMI) is uncertain as to the volume of sales that will exist in Year 1. The president of the company asked the chief accountant to prepare flexible budget income statements assuming that sales activity amounts to 3,000 and 7,000 units. The static budget is shown in the following form. Required a. Complete the following worksheet to prepare the appropriate flexible budgets. b. Calculate and show the flexible budget variances for the static budget versus...
The management of Benson Modems, Inc. (BMI) is uncertain as to the volume of sales that will exist in Year 1. The president of the company asked the chief accountant to prepare flexible budget income statements assuming that sales activity amounts to 5,000 and 7,000 units. The static budget is shown in the following form. Required a. Complete the following worksheet to prepare the appropriate flexible budgets. b. Calculate and show the flexible budget variances for the static budget versus...