Question

How did you calculate the number found in (Budget sales mix) for the sale 13,559,407 and...

How did you calculate the number found in (Budget sales mix) for the sale 13,559,407 and 0 and 1,562,669? Thank you I NEED TO SEE THE CALCULATION

Berkshire Toy Company
Statement of Operating Income for the Year Ended June 30, 1998
Actual Master Budget Master Budget Variance F/ U Flexible Budget Flexible Budget Variance   F/ U
Units sold           325,556           280,000            45,556 F                 325,556
Retail and catalog in units     174,965        8,573,285      11,662,000       3,088,715 U              8,573,285
Internet     105,429        4,428,018                    -       (4,428,018) F              4,428,018
Wholesale       45,162        1,445,184        1,344,000        (101,184) F              1,445,184
Total units     325,556
Total Revenue      14,446,487      13,006,000     (1,440,487) F            14,446,487
Variable Production Costs
Direct Materials
Acrylic pile fabric           256,422           233,324          (23,098) U $271,302          (14,880) F
10-mm acrylic eye           125,637           106,400          (19,237) U $123,711              1,926 U
45-mm plastic joints           246,002           196,000          (50,002) U $227,889            18,113 U
polyester fiber filling           450,856           365,400          (85,456) U $424,851            26,005 U
woven label             16,422             14,000            (2,422) U $16,278                 144 U
designer box             69,488             67,200            (2,288) U $78,133            (8,645) F
accessories             66,013             33,600          (32,413) U $39,067            26,946 U
Total Direct Labor Materials        1,230,840        1,015,924        (214,916) U $          1,181,231            49,609 U
Direct labor        3,668,305        2,688,000        (980,305) U 3,125,338          542,967 U
variable overhead        1,725,665        1,046,304        (679,361) U 1,216,538          509,127 U
Total variable production costs        6,624,810        4,750,228     (1,874,582) U 5,523,091       1,101,719 U
Variable Selling expenses        1,859,594        1,218,280        (641,314) 1,416,494          443,100 U
Total variable expenses        8,484,404 5,968,508     (7,266,124) U 6,939,585       1,544,819 U
Contribution Margin        5,962,083        7,037,492       7,037,492 U 7,506,902     (1,544,819) U
Fixed costs
manufacturing overhead           658,897           661,920              3,023 F 769,614        (110,717) F
selling expenses        5,023,192        4,463,000        (560,192) U 4,463,000          560,192 U
administrative expenses        1,123,739        1,124,000                 261 F 1,124,000               (261) F
total fixed costs        6,805,828        6,248,920        (556,908) U 6,356,614          449,214 U
Operating Income         (843,745)           788,572       7,594,400 U 1,150,272     (1,994,017) F

Sales

Sales
Units Actual Master Budget Master Budget Variance Flexible Budget (Actual Sales Mix) Flexible Budget Variance (Budget Sales Mix)
Unit Sold 325,556 280,000 45,556 325,556 325,556
Retail and Catalog 174,965      8,573,285      11,662,000       3,088,715      8,573,285 13,559,407
Internet 105,429      4,428,018                    -       (4,428,018)      4,428,018 0
Wholesale 45,162      1,445,184        1,344,000        (101,184)      1,445,184 1,562,669
Total revenue 14,446,487 13,006,000 -1,440,487 14,446,487
Business   Accounting   
0 0
Add a commentTranscribed image text
Next >

Homework Answers

Answer #1

0 0
Know the answer?
Your Answer:

Post as a guest

Your Name:

What's your source?

Earn Coins

Coins can be redeemed for fabulous gifts.

Log In

Sign Up

Not the answer you're looking for?
Ask your own homework help question
Similar Questions
ames Manufacturing had the following information available for July: Actual Results Flexible Budget Variance Flexible Budget...
ames Manufacturing had the following information available for July: Actual Results Flexible Budget Variance Flexible Budget Sales Activity Variance Master Budget Units 12,000 ? 3,000 U ? Sales revenue ? $ 16,800 F ? ? ? Less: Variable manufacturing costs $ 88,500 $ 92,000 ? $ 111,000 Variable marketing and administrative ? $ 5,500 U ? $ 6,200 F $ 33,000 Contribution margin $ 52,000 ? ? $ 6,300 U ? What was James’s master budget contribution margin?
The master budget at Western Company last period called for sales of 225,000 units at $9...
The master budget at Western Company last period called for sales of 225,000 units at $9 each. The costs were estimated to be $3.75 variable per unit and $225,000 fixed. During the period, actual production and actual sales were 230,000 units. The selling price was $9.10 per unit. Variable costs were $4.50 per unit. Actual fixed costs were $225,000.    Required: Prepare a sales activity variance analysis. (Indicate the effect of each variance by selecting "F" for favorable, or "U"...
The total variable cost flexible-budget variance for any given period: Multiple Choice Is directly affected by...
The total variable cost flexible-budget variance for any given period: Multiple Choice Is directly affected by the difference between actual sales volume and the sales volume embodied in the flexible budget. Is decomposable into production-volume and production-mix components. Can be broken down into flexible-budget variances for major costs such as materials, labor, variable overhead, and variable selling expenses. Is decomposable into sales-volume and sales-mix components. Is the difference between actual total variable cost incurred and master budgeted total variable cost.
You are given the following static budget report: Budget            Actual              Variance Unit Sales  &nbsp
You are given the following static budget report: Budget            Actual              Variance Unit Sales                                           10,000               15,000             5,000 F Variable Expenses:     Commissions                                  $30,000 $33,000 $3,000 U     Advertising                                      $1,000 $1,200 $200 U     Travel                                              $10,000 $11,000 $1,000 U     Samples                                          $2,500 $2,300 $200 F Total Variable                                     $43,500 47,500 $4,000 U Fixed Expenses     Rent                                                 $5,000 $5,000 0     Salaries – Sales                               $2,000 $2,000 0     Salaries – Office                              $1,200 $1,200 0     Depreciation                                    $1,500 $1,500 0 Total Fixed                                          $9,700 $9,700             0 Total Expenses $53,200 $57,200 $4,000 U Prepare a flexible budget analysis and explain whether you believe that costs were controlled.  How do the results of...
Gleason Guitars produces acoustic guitars. The table below contains budget and actual information for the month...
Gleason Guitars produces acoustic guitars. The table below contains budget and actual information for the month of June: (Indicate the effect of each variance by selecting "F" for favorable, "U" for unfavorable, and "None" for no effect (i.e., zero variance).) Actual Costs 405 units Spending Variance Flexible Budget 405 units Volume Variance Master Budget 200 units Direct Material $17,300 $15,800 Direct Labor 28,000 23,800 Variable Overhead 10,050 9,800 Fixed Overhead 13,300 11,900 Total Manufacturing Costs $68,650 $61,300
Actual Results Flexible Budget Variance Flexible Budget Sales Activity Variance Master Budget Units 13,000 ? 2000U...
Actual Results Flexible Budget Variance Flexible Budget Sales Activity Variance Master Budget Units 13,000 ? 2000U ? Sales revenue ? 13,000F ? ? ? Less: <Variable mfg. Costs> $87,750 $91,000 ? $105,000 <Variable mktg/adm.costs> ? $3,250U ? $4,000F 30,000 Contribution margin $52,000 ? ? $6,000U ? What is the master budget contribution margin? Select one: A. $52,000. B. $45,000. C. $47,500. D. $39,000.
As the new accountant for Cohen & Co., you have been asked to provide a succinct...
As the new accountant for Cohen & Co., you have been asked to provide a succinct analysis of financial performance for the year just ended. You obtain the following information that pertains to the company’s sole product: Actual Master (Static) Budget Units sold 35,000 40,000 Sales $ 384,000 $ 470,000 Variable costs 214,000 278,000 Fixed costs 137,000 135,000 Required: 1. What was the actual operating income for the period? 2. What was the company’s master (static) budget operating income for...
Gleason Guitars produces acoustic guitars. The table below contains budget and actual information for the month...
Gleason Guitars produces acoustic guitars. The table below contains budget and actual information for the month of June: (Indicate the effect of each variance by selecting "F" for favorable, "U" for unfavorable, and "None" for no effect (i.e., zero variance).) Actual costs 245 units    spending variance flexible budget 245 units    volume variance Master budget 200 units direct material 15,700 14,200 direct labor 26400 22,200 variable overhead 8450 8,200 fixed overhead 11,700 11,100 total manufacturing overhead 62250 55,700
As the new accountant for Cohen & Co., you have been asked to provide a succinct...
As the new accountant for Cohen & Co., you have been asked to provide a succinct analysis of financial performance for the year just ended. You obtain the following information that pertains to the company’s sole product: Actual Master (Static) Budget Units sold 35,000 40,000 Sales $ 396,000 $ 453,000 Variable costs 226,000 273,000 Fixed costs 150,500 138,000 Required: 1. What was the actual operating income for the period? 2. What was the company’s master (static) budget operating income for...
The master budget at Western Company last period called for sales of 226,300 units at $10.3...
The master budget at Western Company last period called for sales of 226,300 units at $10.3 each. The costs were estimated to be $3.88 variable per unit and $226,300 fixed. During the period, actual production and actual sales were 231,300 units. The selling price was $10.40 per unit. Variable costs were $5.80 per unit. Actual fixed costs were $226,300. Required: Prepare a sales activity variance analysis. (Indicate the effect of each variance by selecting "F" for favorable, or "U" for...
ADVERTISEMENT
Need Online Homework Help?

Get Answers For Free
Most questions answered within 1 hours.

Ask a Question
ADVERTISEMENT