Question

The following information has been provided for Lead Manufacturing Prepare a budgeted income statement for next year. Current

0 0
Add a comment Improve this question Transcribed image text
Answer #1

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
Add a comment
Know the answer?
Add Answer to:
The following information has been provided for Lead Manufacturing Prepare a budgeted income statement for next year. C...
Your Answer:

Post as a guest

Your Name:

What's your source?

Earn Coins

Coins can be redeemed for fabulous gifts.

Not the answer you're looking for? Ask your own homework help question. Our experts will answer your question WITHIN MINUTES for Free.
Similar Homework Help Questions
  • 13-51. Prepare Budgeted Financial Statements (LO 13-6) eXcel The following information is available for year 1...

    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...

    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...

    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)...

    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)...

    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...

    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...

    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...

    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...

    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)...

    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...

ADVERTISEMENT
Free Homework Help App
Download From Google Play
Scan Your Homework
to Get Instant Free Answers
Need Online Homework Help?
Ask a Question
Get Answers For Free
Most questions answered within 3 hours.
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT