Question

In: Accounting

Tsypkin Company's budgeted sales quantity was 80,000 units of product. The company's accountant, using regression analysis,...

Tsypkin Company's budgeted sales quantity was 80,000 units of product. The company's accountant, using regression analysis, applied the following cost formula to estimate costs at the master budget level for this year: Total cost = $500,000 + ($5.20 × units produced and sold). The product had a budgeted selling price of $15.20 each. During the year, the actual sales were 82,000 units and selling price was $15.15 per unit. The actual variable costs were $418,200 and the fixed costs were $500,000.

A. What was Tsypkin's profit variance?
B. What was Tsypkins's sales price variance?

Solutions

Expert Solution

PART – A)

Budgeted operating profit = Budgeted sales – Budgeted cost

                                          = ($15.20*80,000 units) – [$500,000 + ($5.20*80,000 units)]

                                          = $1,216,000 – $500,000 – $416,000

                                          = $300,000

Actual operating profit = Actual sales – Actual variable cost – Actual fixed cost

                                     = ($15.15*82,000 units) – $418,200 – $500,000

                                     = $1,242,300 – $918,200

                                     = $324,100

Profit variance = Actual operating profit – Budgeted operating profit

                        = $324,100 – $300,000

                        = $24,100 favourable

PART – B)

Sales price variance = (Budgeted sale price – Actual sale price)*Actual quantity

                                 = ($15.20 – $15.15)*82,000 units

                                 = 0.05*82,000 units

                                 = $4,100 Unfavourable


Related Solutions

For a new product, sales volume in the first year is estimated to be 80,000 units...
For a new product, sales volume in the first year is estimated to be 80,000 units and is projected to grow at a rate of 4% per year. The selling price is $12 and will increase by $0.50 each year. Per-unit variable costs are $3, and annual fixed costs are $400,000. Per-unit costs are expected to increase 5% per year. Fixed costs are expected to increase 8% per year. Develop a spreadsheet model to calculate the net present value of...
Deluxe​, Inc. produced 1,000 units of the​ company's product in 2018. The standard quantity of direct...
Deluxe​, Inc. produced 1,000 units of the​ company's product in 2018. The standard quantity of direct materials was three yards of cloth per unit at a standard cost of $1.00 per yard. The accounting records showed that 2,800 yards of cloth were used and the company paid$1.05 per yard. Standard time was two direct labor hours per unit at a standard rate of $9.75 per direct labor hour. Employees worked1,800 hours and were paid $9.25per hour. . 1. What are...
A company's budgeted manufacturing costs for 75,000 units are as follows:
A company's budgeted manufacturing costs for 75,000 units are as follows: Fixed manufacturing costs $15,000 Variable manufacturing costs $18.00 per unit The company produced 70,000 units. Under a flexible budget, how much are budgeted total manufacturing costs? $1,380,000 $1.260,000 $1,365,000 $1,275,000
ZZ, Inc. has budgeted sales in units for the next six months as follows: Budgeted Sales in Units July...
ZZ, Inc. has budgeted sales in units for the next six months as follows: Budgeted Sales in Units July 7,700 units August 8,300 units September 5,400 units October 10,200 units November ?????? units December 11,700 units The selling price is $18 per unit. 30% of the company's sales are cash sales and 70% of the company's sales are made on account. The sales on account are collected in the pattern 15% in the month of sale, 20% in the month...
Detmer Enterprises has the following budgeted sales: Budgeted Sales in Units June 6,800 units July 5,100...
Detmer Enterprises has the following budgeted sales: Budgeted Sales in Units June 6,800 units July 5,100 units August 4,400 units September 3,700 units Past experience has shown that the ending finished goods inventory for each month should be equal to 25% of the next month's expected sales in units. Additionally, it is known that every unit produced requires four direct labor hours to make and direct laborers are paid $15 per hour. Assume that Detmer pays 65% of its direct...
Detmer Enterprises has the following budgeted sales: Budgeted Sales in Units June 6,800 units July 5,100...
Detmer Enterprises has the following budgeted sales: Budgeted Sales in Units June 6,800 units July 5,100 units August 4,400 units September 7,300 units Past experience has shown that the ending finished goods inventory for each month should be equal to 20% of the next month's expected sales in units. Additionally, it is known that every unit produced requires four direct labor hours to make and direct laborers are paid $15 per hour. Assume that Detmer pays 65% of its direct...
ABC Company has budgeted sales for the next six months as follows: Budgeted Sales in Units...
ABC Company has budgeted sales for the next six months as follows: Budgeted Sales in Units March 12,000 units April 24,000 units May 35,000 units June 13,000 units July 43,000 units August 69,000 units ABC Company sells its inventory to customers for $25 per unit. 30% of the company's sales are cash sales and the other 70% of sales are made on account. The sales on account are collected in the pattern: 35% collected in the month of sale 26%...
ABC Company has budgeted sales for the next six months as follows: Budgeted Sales in Units...
ABC Company has budgeted sales for the next six months as follows: Budgeted Sales in Units March 19,000 units April 23,000 units May 34,000 units June 17,000 units July 48,000 units August 69,000 units ABC Company sells its inventory to customers for $16 per unit. 30% of the company's sales are cash sales and the other 70% of sales are made on account. The sales on account are collected in the pattern: 35% collected in the month of sale 26%...
A company's margin of safety in sales dollars is $80,000. What does this mean? A. The...
A company's margin of safety in sales dollars is $80,000. What does this mean? A. The company's sales are $80,000 above the operating leverage. B. The company's profit is $80,000 above the last period's profit. C. The company's sales are $80,000 above the break-even point sales. D. The company's profit is $80,000 above the target profit.
​​​​​Below is the regression of units sold on the average price of the product. Regression Statistics...
​​​​​Below is the regression of units sold on the average price of the product. Regression Statistics Multiple R 0.2461 R Square 0.2000 Adjusted R Square 0.1649 Standard Error 26.128 Observations 20 ANOVA Df SS MS F Significance F Regression 1 3080.89 3080.89 4.51 0.0478 Residual 18 12288.31 682.68 Total 19 15369.20 Coefficients Standard Error t Stat P-value Lower 95% Upper 95% Intercept 614.9300 51.2343 12.002 0.0000 507.2908 722.5692 X -109.1120 51.3623 -2.124 0.0478 -217.0202 -1.2038 What is the estimated regression...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT