Question

In: Accounting

Pebco Company’s 2011 master budget included the following fixed budget report. It is based on an...

Pebco Company’s 2011 master budget included the following fixed budget report. It is based on an expected production and sales volume of 15,000 units.

  

PEBCO COMPANY
Fixed Budget Report
For Year Ended December 31, 2011
  Sales $ 3,000,000
  Cost of goods sold
     Direct materials $ 990,000
     Direct labor 225,000
     Machinery repairs (variable cost) 75,000
     Depreciation—plant equipment 300,000
     Utilities ($50,000 is variable) 200,000
     Plant management salaries 230,000 2,020,000
   
  Gross profit 980,000
  Selling expenses
     Packaging 80,000
     Shipping 110,000
     Sales salary (fixed annual amount) 260,000 450,000
  
  General and administrative expenses
     Advertising expense 135,000
     Salaries 251,000
     Entertainment expense 100,000 486,000
  
  Income from operations $ 44,000
  
Pebco Company’s actual income statement for 2011 follows.
PEBCO COMPANY
Statement of Income from Operations
For Year Ended December 31, 2011
  Sales (18,000 units) $ 3,663,000
  Cost of goods sold
     Direct materials $ 1,204,000
     Direct labor 278,000
     Machinery repairs (variable cost) 82,000
     Depreciation—plant equipment 300,000
     Utilities (fixed cost is $147,500) 206,750
     Plant management salaries 240,000 2,310,750
  
  Gross profit 1,352,250
  Selling expenses
     Packaging 94,000
     Shipping 124,500
     Sales salary (annual) 277,000 495,500
  
  General and administrative expenses
     Advertising expense 144,000
     Salaries 251,000
     Entertainment expense 103,500 498,500
  
  Income from operations $ 358,250
  

  

Required:
1.

Prepare a flexible budget performance report for 2011. (Do not round your intermediate calculations and round your final answers to nearest dollar amount. Indicate the effect of each variance by selecting "F" for favorable, "U" for unfavorable, and "None" for no effect (i.e., zero variance). Input all amounts as positive values. Leave no cells blank - be certain to enter "0" wherever required. Omit the "$" sign in your response.)

PEBCO COMPANY
Flexible Budget Performance Report
For Year Ended December 31, 2011
Flexible Actual
Budget Results Variances
  (Click to select)Sales salarySalariesAdvertising expenseUtilitiesSales $    $    $    (Click to select)UNoneF
  Variable costs
     (Click to select)Entertainment expenseDirect materialsSales salaryAdvertising expenseDepreciation-plant equipment          (Click to select)UFNone
     (Click to select)Advertising expenseEntertainment expenseSalariesDepreciation-plant equipmentDirect labor          (Click to select)NoneFU
     (Click to select)Sales salaryDepreciation-plant equipmentMachinery repairsSalariesEntertainment expense          (Click to select)NoneUF
     (Click to select)Entertainment expenseSalariesAdvertising expenseUtilitiesSales salary          (Click to select)UNoneF
     (Click to select)SalariesPlant management salariesEntertainment expenseAdvertising expensePackaging          (Click to select)FNoneU
     (Click to select)ShippingSales salariesEntertainment expensePlant management salariesDepreciation-plant equipment          (Click to select)NoneFU
  
     Total variable costs          (Click to select)NoneUF
  
  (Click to select)Gross marginContribution margin          (Click to select)NoneUF
  Fixed costs
     (Click to select)Direct materialsShippingPackagingDepreciation-plant equipmentMachinery repairs          (Click to select)NoneUF
     (Click to select)Direct materialsDirect laborPackagingShippingUtilities          (Click to select)NoneUF
     (Click to select)Direct laborDirect materialsPlant management salariesMachinery repairsShipping          (Click to select)UNoneF
     (Click to select)Direct laborPackagingDirect materialsSales salaryMachinery repairs          (Click to select)NoneUF
     (Click to select)PackagingDirect materialsShippingAdvertising expenseDirect labor          (Click to select)NoneFU
     (Click to select)Direct materialsPackagingMachinery repairsSalariesShipping          (Click to select)UFNone
     (Click to select)ShippingPackagingMachinery repairsDirect materialsEntertainment expense          (Click to select)NoneFU
  
     Total fixed costs          (Click to select)UFNone
  
  Income from operations $    $    $    (Click to select)FUNone
  

Solutions

Expert Solution

Here flexible budget is made on the basis of 18000 units which are actual units. The variable costs are calculted on the basis of 18000 units means V.Cost / 15000 * 18000 units. Fixed Cost will remain same as in standard budget .


Related Solutions

Pebco Company’s 2011 master budget included the following fixed budget report. It is based on an...
Pebco Company’s 2011 master budget included the following fixed budget report. It is based on an expected production and sales volume of 15,000 units.    PEBCO COMPANY Fixed Budget Report For Year Ended December 31, 2011   Sales $ 3,000,000   Cost of goods sold      Direct materials $ 990,000      Direct labor 225,000      Machinery repairs (variable cost) 75,000      Depreciation—plant equipment 300,000      Utilities ($50,000 is variable) 200,000      Plant management salaries 230,000 2,020,000       Gross profit 980,000   Selling expenses      Packaging 80,000      Shipping 110,000      Sales salary...
Pebco Company’s 2011 master budget included the following fixed budget report. It is based on an...
Pebco Company’s 2011 master budget included the following fixed budget report. It is based on an expected production and sales volume of 16,000 units.    PEBCO COMPANY Fixed Budget Report For Year Ended December 31, 2011   Sales $ 3,200,000   Cost of goods sold      Direct materials $ 990,000      Direct labor 225,000      Machinery repairs (variable cost) 60,000      Depreciation—plant equipment 315,000      Utilities ($50,000 is variable) 210,000      Plant management salaries 215,000 2,015,000       Gross profit 1,185,000   Selling expenses      Packaging 85,000      Shipping 110,000      Sales salary...
Phoenix Company’s 2019 master budget included the following fixed budget report. It is based on an...
Phoenix Company’s 2019 master budget included the following fixed budget report. It is based on an expected production and sales volume of 18,000 units. PHOENIX COMPANY Fixed Budget Report For Year Ended December 31, 2019 Sales $ 3,600,000 Cost of goods sold Direct materials $ 1,080,000 Direct labor 270,000 Machinery repairs (variable cost) 36,000 Depreciation—Plant equipment (straight-line) 300,000 Utilities ($18,000 is variable) 178,000 Plant management salaries 215,000 2,079,000 Gross profit 1,521,000 Selling expenses Packaging 54,000 Shipping 90,000 Sales salary (fixed...
Phoenix Company’s 2017 master budget included the following fixed budget report. It is based on an...
Phoenix Company’s 2017 master budget included the following fixed budget report. It is based on an expected production and sales volume of 15,000 units. PHOENIX COMPANY Fixed Budget Report For Year Ended December 31, 2017 Sales $ 3,150,000 Cost of goods sold Direct materials $ 900,000 Direct labor 240,000 Machinery repairs (variable cost) 45,000 Depreciation—Plant equipment (straight-line) 315,000 Utilities ($45,000 is variable) 195,000 Plant management salaries 190,000 1,885,000 Gross profit 1,265,000 Selling expenses Packaging 90,000 Shipping 90,000 Sales salary (fixed...
Phoenix Company’s 2017 master budget included the following fixed budget report. It is based on an...
Phoenix Company’s 2017 master budget included the following fixed budget report. It is based on an expected production and sales volume of 15,000 units. PHOENIX COMPANY Fixed Budget Report For Year Ended December 31, 2017 Sales $ 3,375,000 Cost of goods sold Direct materials $ 975,000 Direct labor 300,000 Machinery repairs (variable cost) 60,000 Depreciation—Plant equipment (straight-line) 330,000 Utilities ($45,000 is variable) 205,000 Plant management salaries 215,000 2,085,000 Gross profit 1,290,000 Selling expenses Packaging 75,000 Shipping 105,000 Sales salary (fixed...
Phoenix Company’s 2017 master budget included the following fixed budget report. It is based on an...
Phoenix Company’s 2017 master budget included the following fixed budget report. It is based on an expected production and sales volume of 15,000 units. PHOENIX COMPANY Fixed Budget Report For Year Ended December 31, 2017 Sales $ 3,300,000 Cost of goods sold Direct materials $ 945,000 Direct labor 225,000 Machinery repairs (variable cost) 45,000 Depreciation—Plant equipment (straight-line) 300,000 Utilities ($30,000 is variable) 195,000 Plant management salaries 200,000 1,910,000 Gross profit 1,390,000 Selling expenses Packaging 90,000 Shipping 90,000 Sales salary (fixed...
Phoenix Company’s 2015 master budget included the following fixed budget report. It is based on an...
Phoenix Company’s 2015 master budget included the following fixed budget report. It is based on an expected production and sales volume of 15,000 units. PHOENIX COMPANY Fixed Budget Report For Year Ended December 31, 2015   Sales $ 3,375,000   Cost of goods sold      Direct materials $ 1,050,000      Direct labor 150,000      Machinery repairs (variable cost) 60,000      Depreciation—plant equipment (straight-line) 330,000      Utilities ($45,000 is variable) 205,000      Plant management salaries 230,000 2,025,000       Gross profit 1,350,000   Selling expenses      Packaging 75,000      Shipping 105,000      Sales salary...
Phoenix Company’s 2019 master budget included the following fixed budget report. It is based on an...
Phoenix Company’s 2019 master budget included the following fixed budget report. It is based on an expected production and sales volume of 15,000 units. PHOENIX COMPANY Fixed Budget Report For Year Ended December 31, 2019 Sales $ 3,150,000 Cost of goods sold Direct materials $ 945,000 Direct labor 225,000 Machinery repairs (variable cost) 45,000 Depreciation—Plant equipment (straight-line) 330,000 Utilities ($60,000 is variable) 210,000 Plant management salaries 190,000 1,945,000 Gross profit 1,205,000 Selling expenses Packaging 90,000 Shipping 105,000 Sales salary (fixed...
Phoenix Company’s 2017 master budget included the following fixed budget report. It is based on an...
Phoenix Company’s 2017 master budget included the following fixed budget report. It is based on an expected production and sales volume of 15,000 units. PHOENIX COMPANY Fixed Budget Report For Year Ended December 31, 2017 Sales $ 3,150,000 Cost of goods sold Direct materials $ 960,000 Direct labor 240,000 Machinery repairs (variable cost) 45,000 Depreciation—Plant equipment (straight-line) 300,000 Utilities ($45,000 is variable) 210,000 Plant management salaries 200,000 1,955,000 Gross profit 1,195,000 Selling expenses Packaging 75,000 Shipping 105,000 Sales salary (fixed...
Phoenix Company’s 2017 master budget included the following fixed budget report. It is based on an...
Phoenix Company’s 2017 master budget included the following fixed budget report. It is based on an expected production and sales volume of 15,000 units. PHOENIX COMPANY Fixed Budget Report For Year Ended December 31, 2017 Sales $ 3,000,000 Cost of goods sold Direct materials $ 900,000 Direct labor 210,000 Machinery repairs (variable cost) 45,000 Depreciation—Plant equipment (straight-line) 330,000 Utilities ($45,000 is variable) 180,000 Plant management salaries 190,000 1,855,000 Gross profit 1,145,000 Selling expenses Packaging 90,000 Shipping 105,000 Sales salary (fixed...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT