Fin 571 The Guillermo Furniture Store

Fin 571 The Guillermo Furniture Store - Setup Information...

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

View Full Document Right Arrow Icon
Setup Information <Insert Facilitator's Name> 0.06 Peso? (1=Yes) 0 1.00 10.814 Mexican Pesos = 1.000 US Dollars Income Information-Current Standards Current Hi-Tech Broker Production Current Production = Sales Forecast Mid-Grade 2,532.00 3,798.00 3,798.00 Production can be increased by 50% and the broker also anticipates that same level High-End 506.00 759.00 759.00 Production can be increased by 50% Direct Materials ($)/Unit Mid-Grade 140.00 140.00 There are no material costs for brokered units High-End 250.00 250.00 250.00 Direct Labor ($/HR)/Unit 15.00 40.00 40.00 The labor rate is increased due to the technical skill level of operators Labor Time (Hrs)/Unit Mid-Grade 20.00 4.00 There are no labor times for brokered units and production times are 20% of original times High-End 30.00 4.00 4.00 Production times are now equal to the mid-grade level Direct Cost/Unit Mid-Grade 440.00 300.00 360.00 The Broker cost for Mid-Grade is based on net FOB destination including shipping/tariffs High-End 700.00 410.00 410.00 Price/Unit Mid-Grade 509.00 459.00 459.00 Prices are reduced by 10% because supply is increased High-End 879.00 789.00 789.00 Prices are reduced by 10% because supply is increased Plant Overhead/Yr Salaries 50,000 95,000 95,000 Need to add a 45,000 a year maintenance position for the equipment Utilities 9,000 27,000 4,497 Utilities are expected to be 3 x's current at full production (150% above current levels) based on units produced Benefits 103,730 82,412 21,644 Benefits are 10% of all wages (including direct labor) Insurance 3,000 15,000 15,000 Insurance will increase by 12,000 with the addition of the equipment and building expansion Property Taxes 975 3,900 3,900 Property taxes are 6.5%, assessment is 1% of original value, and that is on all plant/equipment Depreciation 50,000 466,667 466,667 Buildings are at 30 years and Equipment is at 10 years, straight line Supplies 6,000 6,000 6,000 Supply expense is miscellaneous and does not vary Income Tax Expense 17,882 82,137 21,401 Taxes are 42% of Net Income 265,282 891,543 663,663 Net Margins 222,705 695,979 612,708 Overhead 42577.00 195564.33 50955.30 Net Income before taxes 24,694.66 113,427.31 29,554.07 Net Income After taxes
Background image of page 1

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

View Full DocumentRight Arrow Icon
Asse 12/31/2009 12/31/2010 Cash $120,872 USD $165,933 USD Accounts Receivable 201,266 205,374 Inventory 118,686 122,357 Pre-paid Insurance 1,250 1,500 TOTAL CURRENT ASSETS $442,074 USD $495,163 USD Buildings 1,500,000 1,500,000 Less: Accumulated Depreciation (600,000) (650,000) Equipment 50,000 50,000 Less: Accumulated Depreciation (50,000) (50,000) TOTAL ASSETS $1,342,074 USD $1,345,163 USD Accounts Payable $79,917 USD $82,388 USD Income Taxes Payable 16,988 17,882 Wages Payable 41,060 43,221 Current Portion of Notes Payable 27,132 29,238 TOTAL CURRENT LIABILITIES $165,097 USD $172,730 USD Mortgage Note Payable 965,867 936,628 TOTAL LIABILITIES $1,130,963 USD $1,109,358 USD Common Stock $10,000 USD $10,000 USD Retained Earnings 201,111 225,805 TOTAL EQUITY $211,111 USD $235,805 USD $1,342,074 USD $1,345,163 USD
Background image of page 2
Image of page 3
This is the end of the preview. Sign up to access the rest of the document.

This note was uploaded on 05/10/2011 for the course FIN 571 taught by Professor Emil during the Spring '11 term at Aberystwyth University.

Page1 / 23

Fin 571 The Guillermo Furniture Store - Setup Information...

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

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