BUDGETED INCOME STATEMENT NEXT YEAR |
||
Revenue (115000*.7178) | 82547 | |
manufacturing cost | ||
material (unit level) (115000*.03906) | 4491.9 | |
unit-level (variable)OH cash cost (115000*.034532) | 3971.18 | |
Facility level (fixed) OH cash cost | 8599.5 | |
Depreciation | 23000 | |
Marketing and admin.cost | ||
marketing (unit level) (115000*.1056) | 12144 | |
marketing depreciation | 4100 | |
Administrative (facility level) | 13748.4 | |
Administrative depreciation | 1870 | |
Total cost | (71924.98) | |
Operating profit | 10622.02 |
Working :
sales volume = 100000(1+.15)= 115000
sales price= .74(1-.03)= .7178
Per Unit variable cost | Revised cost | |
manufacturing cost | ||
material (unit level) | 4200/100000=.042 | .042(1-.07)=.03906 |
unit-level (variable)OH cash cost | 3560/100000= .0356 | .0356(1-.03)= .034532 |
Facility level (fixed) OH cash cost | 8190(1+.05)= 8599.5 | |
Depreciation | 23000 | |
Marketing and admin.cost | ||
marketing (unit level) | 10560/100000=.1056 |
.1056 |
marketing depreciation | 4100 | |
Administrative (facility level) | 12730(1+.08)=13748.4 | |
Administrative depreciation | 1870 |
The following information has been provided for Lead Manufacturing Prepare a budgeted income statement for next year. C...
13-51. Prepare Budgeted Financial Statements (LO 13-6) eXcel The following information is available for year 1 for Pepper Products. $2,850,000 Sales revenue (200,000 units) Manufacturing costs $168,000 Materials 142,400 327,600 Variable cash costs Fixed cash costs Depreciation (fixed) Marketing and administrative costs 999,000 Marketing (variable, cash) 422,400 Marketing depreciation 149,600 Administrative (fixed, cash) 509,200 Administrative depreciation 74,800 Total costs $2.793,000 Operating profits $ 57,000 All depreciation charges are fixed and are expected to remain the same for year 2. Sales...
Problem 13-51 (Static) Prepare Budgeted Financial Statements (LO 13-6) The following information is available for year 1 for Pepper Products: $2,850,000 Sales revenue (200,000 units) Manufacturing costs Materials 168,000 Variable cash costs 142,400 327,600 Fixed cash costs Depreciation (fixed) Marketing and administrative costs Marketing (variable, cash) Marketing depreciation Administrative (fixed, cash) Administrative depreciation Total costs 999,000 422,400 149,600 509, 200 74,800 $2,793,000 57,000 Operating profits All depreciation charges are fixed and are expected to remain the same for year 2....
The following information is available for year 1 for Pepper Products: $3,510,000 $ 208,000 177,000 408,000 1,244,000 Sales revenue (130,000 units) Manufacturing costs Materials Variable cash costs Fixed cash costs Depreciation (fixed) Marketing and administrative costs Marketing (variable, cash) Marketing depreciation Administrative (fixed, cash) Administrative depreciation Total costs Operating profits 525,000 186,000 633,000 94,000 $3,475,000 35,000 All depreciation charges are fixed and are expected to remain the same for year 2. Sales volume is expected to fall by 6 percent,...
The following information is available for year 1 for Pepper Products: Sales revenue (200,000 units) $ 2,850,000 Manufacturing costs Materials $ 168,000 Variable cash costs 142,400 Fixed cash costs 327,600 Depreciation (fixed) 999,000 Marketing and administrative costs Marketing (variable, cash) 422,400 Marketing depreciation 149,600 Administrative (fixed, cash) 509,200 Administrative depreciation 74,800 Total costs $ 2,793,000 Operating profits $ 57,000 All depreciation charges are fixed and are expected to remain the same for year 2. Sales volume is expected...
The following information is available for year 1 for Pepper Products: Sales revenue (240,000 units) $ 3,840,000 Manufacturing costs Materials $ 226,000 Variable cash costs 192,000 Fixed cash costs 442,000 Depreciation (fixed) 1,348,000 Marketing and administrative costs Marketing (variable, cash) 570,000 Marketing depreciation 202,000 Administrative (fixed, cash) 687,000 Administrative depreciation 101,000 Total costs $ 3,768,000 Operating profits $ 72,000 All depreciation charges are fixed and are expected to remain the same for year 2. Sales volume is expected...
Gulf States Manufacturing has the following data from year 1 operations, which are to be used for developing year 2 budget estimates: Sales revenues (16,000 units) $ 1,440,000 Manufacturing costs Materials $ 257,000 Variable cash costs 351,000 Fixed cash costs 141,000 Depreciation (fixed) 173,000 Marketing and administrative costs Marketing (variable, cash) 184,000 Marketing depreciation 45,000 Administrative (fixed, cash) 180,000 Administrative depreciation $ 16,000 Total costs $ 1,347,000 Operating profits $ 93,000 All depreciation charges are fixed. Old manufacturing equipment with...
The following information is available for year 1 for Pepper Products: $2,760,000 $ Sales revenue (120,000 units) Manufacturing costs Materials Variable cash costs Fixed cash costs Depreciation (fixed) Marketing and administrative costs Marketing (variable, cash) Marketing depreciation Administrative (fixed, Cash) Administrative depreciation Total costs Operating profits 164,000 140,000 323,000 985,000 416,000 147,000 500,000 74.000 52, 749,000 $ 11,000 All depreciation charges are fixed and are expected to remain the same for year 2. Sales volume is expected to fall by...
The following information is available for year 1 for Pepper Products: $2,200,000 2.5 points $ Skipped 131,000 112,000 258,000 787,000 Sales revenue (110,000 units) Manufacturing costs Materials Variable cash costs Fixed cash costs Depreciation (fixed) Marketing and administrative costs Marketing (variable, cash) Marketing depreciation Administrative (fixed, cash) Administrative depreciation Total costs Operating profits eBook 332,000 117,000 398,000 59,000 $2,194,000 $ 6,000 Print ♡ References All depreciation charges are fixed and are expected to remain the same for year 2. Sales...
The following information is available for year 1 for Pepper Products: $2,250,000 133,000 113,000 261,000 796,000 Sales revenue (150,000 units) Manufacturing costs Materials Variable cash costs Fixed cash costs Depreciation (fixed) Marketing and administrative costs Marketing (variable, cash) Marketing depreciation Administrative (fixed, cash) Administrative depreciation Total costs Operating profits 336,000 119,000 405,000 60,000 $2,223,000 $ 27,000 All depreciation charges are fixed and are expected to remain the same for year 2. Sales volume is expected to fall by 4 percent,...
The following information is available for year 1 for Pepper Products: Sales revenue (210,000 units) $ 3,150,000 Manufacturing costs Materials $ 168,000 Variable cash costs 142,400 Fixed cash costs 327,600 Depreciation (fixed) 989,000 Marketing and administrative costs Marketing (variable, cash) 422,400 Marketing depreciation 159,600 Administrative (fixed, cash) 509,200 Administrative depreciation 84,800 Total costs $ 2,803,000 Operating profits $ 347,000 All depreciation charges are fixed and are expected to remain the same for year 2. Sales volume is expected...