Guillermo Furniture Store_FLEX BUDGET

Guillermo Furniture Store_FLEX BUDGET - $ 199 $ 497,500 $...

Info iconThis preview shows pages 1–11. Sign up to view the full content.

View Full Document Right Arrow Icon
Guillermo Furniture Store Flexible Budget Items Flexible-Budget Formula Flexible Budgets For Various Levels of Sales/Production Activity Forecast A Forecast B Forecast C Forecast D Units Mid-Grade 2500 2600 2700 2800 High-End 400 450 500 550
Background image of page 1

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full DocumentRight Arrow Icon
Revenue Mid-Grade $ 509 $ 497,500 $ 517,400 $ 537,300 $ 557,200 High-End $ 879 $ 135,600 $ 152,550 $ 169,500 $ 186,450 Total Revenue $ 1,388 $ 633,100 $ 669,950 $ 706,800 $ 743,650 Variable Cost
Background image of page 2
Direct Material Mid-Grade $140 $ 350,000 $ 364,000 $ 378,000 $ 392,000 Direct Material High-End $ 250 $ 100,000 $ 112,500 $ 125,000 $ 137,500 Labor Time (Hrs/Unit) Mid-Grade $ 20 $ 50,000 $ 52,000 $ 54,000 $ 56,000 Labor Time (Hrs/Unit) High-End $ 30 $ 12,000 $ 13,500 $ 15,000 $ 16,500
Background image of page 3

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full DocumentRight Arrow Icon
Direct Labor ($15/Hr /Unit) $ 15.00 $ 43,500 $ 45,750 $ 48,000 $ 50,250 Direct Cost/Unit Mid-Grade $ 175 $ 437,500 $ 455,000 $ 472,500 $ 490,000 Direct Cost/Unit High-End $ 295 $ 118,000 $ 132,750 $147,500 $ 162,250 Total Cost $ 470 $555,500 $587,750
Background image of page 4
$620,000 $652,250 Unit Price Mid-Grade
Background image of page 5

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full DocumentRight Arrow Icon
Background image of page 6
Background image of page 7

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full DocumentRight Arrow Icon
Background image of page 8
Background image of page 9

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full DocumentRight Arrow Icon
Background image of page 10
Background image of page 11
This is the end of the preview. Sign up to access the rest of the document.

Unformatted text preview: $ 199 $ 497,500 $ 517,400 $ 537,300 $ 557,200 High-End $ 339 $ 135,600 $ 152,550 $ 169,500 $ 186,450 Contribution margin Mid-Grade $ 97,500 $ 101,400 $ 105,300 $ 109,200 High-End $ 23,600 $ 26,550 $ 29,500 $ 32,450 Net Revenue $ 77,600 $ 82,200 $ 86,800 $ 91,400 Plant Overhead/Yr Salaries $50,000 Utilities $9,000 Benefits (10%) Insurance $3,000 Property Taxes $975 Depreciation $50,000 Supplies $6,000 Total Plant Overhead/Yr $118,975 Forecast A Forecast B Forecast C Forecast D Operation income (loss) $ 77,600 $ 82,200 $ 86,800 $ 91,400 Income Tax Expense 42% $ 32,592 $ 34,524 $ 36,456 $ 38,388 Operating Income After Taxes $ 45,008 $ 47,676 $ 50,344 $ 53,012 Past Budget=> High-End January February March April May June Mid-Grade 467 477 487 497 507 517 2458 2483 2508 2533 2559 2,585 Past Actual=> High-End Mid-Grade 470 456 442 429 416 421 2460 2522 2585 2650 2716 2787...
View Full Document

This note was uploaded on 06/04/2010 for the course BUSINESS M ACC561 taught by Professor Johnson during the Spring '10 term at University of Phoenix.

Page1 / 11

Guillermo Furniture Store_FLEX BUDGET - $ 199 $ 497,500 $...

This preview shows document pages 1 - 11. Sign up to view the full document.

View Full Document Right Arrow Icon
Ask a homework question - tutors are online