Ive done some work however I do not understand how to move foward from the ones already answered.
DRES Store 9 Vran ching that 20x Cost Procted Percent 2 2012 Cound Decal Places 51704 3209 1303) 19 wewed 21254 21 P edra Mancung Cost Pere 31 T able Cost Per Uhr 20x1 Cost Projected 20x2 Cost Rounded to 2 Decimal Places 33 Variable Selling 40 Variable Ac t ive 41 Projecte Variati Manuturing Unit Cost (404 P ed Total Variable Cost Per Unit 54 Schede t ed Costs 20x1 Cost Projected 20. Cost 62 Faxed Overhead 60 normal capacity of 1405 T o Fored Costs * Type here to search ME - Etel View e Help Fort Reader PDF search Data Revion The Home insert Formulas Page Layout PART 2 Cost Volume Relationships - Profit Planning Big Alis out to begin work on the budget for 20 and they have sted that you prepare analysis on the following assumptions Note Remember that we cannot part of a lamp, therefore to find the number of you have to round up to the next competent. Furthermore, and the required sales in dollars may be easier to find the number of it and the multiply by the selling price per un and contribution 211 For 2010 the selling price per lamp will be $4500 What is the projected combinar maginatie for each lampad Contribution Margie per un found to two places. SHA) (501) Contributions Marges Radio Round to four places in two of those places ) ST? For 20the selling price pe lamp will be 14500 The desired net income in 2012 is $195.000 What udsales n aves bein 20x2tomach the pot gaa ess e we cannot part of around up to the Introduction FAD 1 2 3 4 11 14 15 16 17 18 Dress Valuta Type here to search M 16. - Eacel Da Review View Help Page Layout Formulas Feat Reader PDF Home Comme cu X Cut Format Panter D E F G For 20the sling price per lamp will be 500 the forced cost increase by 575.000.00 how many lamps 14.000 Breakeven sales in units (Since we cannot start of a round up to the next 504 11 149 troduction FAO 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 procent value Scroll to Type here to search VERO6 Beel View Search Form Date Help e Review Foot Reader PDF Hom Page Layout MSS -10-AA the cost increase by S7.50 aut how many lamps For the price per lamp will be 1500 must be sold to break ? santant round up to the next und 0 You need 25 please round up to For 20 th ing price per lamp will be $45.00. the variable con decreased by 57 50 anil how many lamps must be sold to breakeven? 02 for 2012 the selling price per lamp is increased to 552 50 and how many lamps must be sold Breakevensies in Cance we cannot sell part of an und up to the next need for 2012 the selling price per lamp is decreased to $37.50 a unit how many lamps must be sold troduction 6 7 8 9 10 11 12 13 14 15 16 17 15 Present Value Type here to search M 016 - Excel Search Fort Bender PDF Font Reader PDF Data View Insert Formulas Review Help Page Layout Home XC Pewat la ora 22 Irama Painter 07 for 2012 the Bling price per lamp is decreas created to 537 50 introduction FAQ 1 2 3 7 8 9 10 11 12 13 14 15 16 17 18 Present Value Tables se Lock Type here to search MF1916.6 P Search Toe Reader POF ViewHelp Review Page Layout File Home Ban Formulas Dots -10 AA MS Surs Sert L ocopy 17 in N has decided to develop its budget based upon projected sales of 33,000 Camat 10 $4900 per me 21 The company has requested that you prepare a master budget for the year. This budget is to be used 29 orang and control of operations and should be composed of 31 1 Production Budget 22 2 Materials Budget 3 Direct Labor Budget 16 & Factory Othed Budget 57 5 Seling and Administre Budget 596 Cost of Goods Sold Budget Budgeted Income Sulement 707 72 Cash Budget 7 Notes for Budgeting 35 The company wants to maintain the same number of units in the beginning and ending inventories of BT work in process and electrical parts while increasing the inventory of Lamp Kits to 550 peces and decreasing the finished goods by 20% 99 Come the following budgets 1 Production Budget Planned Sales Desired Ending Inventory of Finished Goods Total de Less: Beginning inventory Total Production 701) 128 ntroduction FAQ 1 2 3 4 8 9 10 11 12 13 14 15 16 17 18 Present Type here to search MF 16. S Sans Se 5 -A A Needed for Production Ded Loss Beginning m To Puchas y (304 105 Decor La Costa Total Labor Cost Round to places (800) Vara Fach ad Factory Cart Toliate Factory Factory Othead Roundwo places Type here to search Autolave 9- Search Data Review View Foxit Reader PDF Help AC - 9 - ESS Copy Format Painter Overhead Allocation ate based on 1. Number of Units Total Factory Overhead/Number of Units Round t o places 5 Castomakong one o Cost of one lampki Labor Cost Per Lamp Factory Overhead per unit 18:02 13:03) Round to two places, S ) 6 Send Ahn Budget S 1904) Variable Seling (Round to two places, Sw ) Food Administrative Variable Administrative Round to two places. Se Total Seling and Administrative Round to two places. Se (905) 906) S& Round dollars to two ss Beginning Inventory Finished Goods Production Costs 19.07 Lamp Kits Beginning Inventory $5$ Available for Use Ending Inventory of Lamp Kits Lamp Kits Used in Production 19.08) Total Materals Labor 19091 19.10 Introduction FAQ 1 2 ) 5 6 7 9 10 11 12 13 14 15 16 17 18 Present Value Type here to search ME3916. - Search Data View Foxit Reader PDF Review Help t Formulas a ge Layout MS Sans Seed - 8.5 698 Copy - To ng and Admin belound to two places Round dollar to two 19.07) Beginning Inventory Finished Goods Production Costs Mats Lame Beginning intory Purchased Available for Use Ending nentory of Lamp Kits Lamp Kits Used in Production 19.08) 1909) 1910) 13.11) 19.12) 1913 1914 Cost of Goods Available Less Ending inventory, Finished Goods 33889 SSSSSSSS introduction FAQ 7 8 9 10 11 12 13 14 15 16 17 18 Present Type here to search M8916.xx - En e Help Foxit Reader Por Search Review Data view Formulas ment Page Layout The Home A Xoa us some sort as AA Formater F G H I 27 Assume actual cash recepts and disbursement low the poem below. Note Recettes and 2 Payables of 1231/will have a cash impact in 2012) 321 1300% of sales for the year are made in November December Since our customers have 50 day terms 33 those funds will be collected be collected in January and February 342 100of ma p achates will be paid during the year, the remaining portion will be paid in Januar February 353 Alther manufacturing and operating costs we paid for when incurred 384. The busted depreciation expense is equal to 0.6% of the feed manufacturing selling and administrative expenses 39 5. Minimum Cash Balance dedor202 519.000 See The Light Projected Cash Budget For the Year Ending December 31, 2012 Round dollars tot Beginning Cash Balance Cash now Account Receivable (Sales last year not collected Sales made and collected in 202 Cash Aslable 10021 1003) 110041 Cash Outlaws Accounts Payable (Purchases last year) Purchases made and paid for in 202 Other Manufacturing Costs (10.05) Total Manacturing Overhead Selling and Administrative Less Direction Total Cash Ouws 1005 10.07 Budgeted Cash Balance before financing Needed Minimum Balance 1000 Amount to be borrowed any (100%) 10.10 Budgeted Cash Balance introduction FAQ 2 4 5 6 12 13 14 15 16 17 prest Value Type here to search FormulasData Review View Help Foxit Reader PDF Search AutoSave 8 5 File Home Insert Page Layout X Cut Arial Paste BI Format Painter L I Copy - 10-A A ESE A -EEEE Wrap Text Merge & Center - $ % 88-23 AB32 A B C D E F G I See The Light Projected Income Statement For the Period Ending December 31, 20x1 545.00 $30.00 $1,125 000.00 750,000.00 $ 375,000.00 Sales 25,000 lamps @ Cost of Goods Sold Gross Profit Selling Expenses: Foxed Variable (Commission per unit) Administrative Expenses: $3.00 $ 23,000.00 75,000.00 $ 98,000.00 Foxed @ $2.00 $42.000.00 50,000.00 92000.00 Variable Total Selling and Administrative Expenses Net Profit $ 190,000.00 185,000.00 I See The Light Projected Balance Sheet As of December 31, 20x1 Current Assets 5 34.710.00 67 500 00 Accounts Receivable Inventory Raw Material Lamp Kits Work in Process Finished Goods Total Current Assets 500 $16.00 8,000.00 3000 @ $30.00 90,000.00 200 210 00 $ $ 20,000.00 6,800.00 Fixed Assets Equipment Accumulated Depreciation Total Fixed Assets Total Assets 13,200.00 $ 213.410.00 1 FAQ 2 3 introduction 4 5 10 11 12 13 14 15 16 AutoSave @CH H Home Insert Help Foxit Reader PDF Search Page Layout Formulas Data Review View ERO Screenshot plaures Online Shopen leon 301 Get Add Mortable Placommended Table AB32 A B C D E 1 See The Light Projected Balance Sheet As of December 31, 20x1 $ 34,710.00 67 500.00 Current Assets Cash Accounts Receivable Inventory Raw Material Lamp Kits Work in Process Finished Goods Total Current Assets 500 $1600 8,000.00 3000 @ $30.00 90.000.00 $ 200,210.00 Fixed Assets Equipment Accumulated Depreciation Total Fixed Assets Total Assets $ 20,000 00 6.800.00 13.200.00 213.410.00 $ SS4000.00 $ 54,000.00 Current Liabilities Accounts Payable Total Liabilities Stockholder's Equity Common Stock Retained Earnings Total Stockholder's Equity Total Liabilities and Stockholder's Equity $ 12.000.00 147.410,00 159 410 00 213.410.00 $ FAQ 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 Pre Type here to search DRES Store 9 Vran ching that 20x Cost Procted Percent 2 2012 Cound Decal Places 51704 3209 1303) 19 wewed 21254 21 P edra Mancung Cost Pere 31 T able Cost Per Uhr 20x1 Cost Projected 20x2 Cost Rounded to 2 Decimal Places 33 Variable Selling 40 Variable Ac t ive 41 Projecte Variati Manuturing Unit Cost (404 P ed Total Variable Cost Per Unit 54 Schede t ed Costs 20x1 Cost Projected 20. Cost 62 Faxed Overhead 60 normal capacity of 1405 T o Fored Costs * Type here to search ME - Etel View e Help Fort Reader PDF search Data Revion The Home insert Formulas Page Layout PART 2 Cost Volume Relationships - Profit Planning Big Alis out to begin work on the budget for 20 and they have sted that you prepare analysis on the following assumptions Note Remember that we cannot part of a lamp, therefore to find the number of you have to round up to the next competent. Furthermore, and the required sales in dollars may be easier to find the number of it and the multiply by the selling price per un and contribution 211 For 2010 the selling price per lamp will be $4500 What is the projected combinar maginatie for each lampad Contribution Margie per un found to two places. SHA) (501) Contributions Marges Radio Round to four places in two of those places ) ST? For 20the selling price pe lamp will be 14500 The desired net income in 2012 is $195.000 What udsales n aves bein 20x2tomach the pot gaa ess e we cannot part of around up to the Introduction FAD 1 2 3 4 11 14 15 16 17 18 Dress Valuta Type here to search M 16. - Eacel Da Review View Help Page Layout Formulas Feat Reader PDF Home Comme cu X Cut Format Panter D E F G For 20the sling price per lamp will be 500 the forced cost increase by 575.000.00 how many lamps 14.000 Breakeven sales in units (Since we cannot start of a round up to the next 504 11 149 troduction FAO 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 procent value Scroll to Type here to search VERO6 Beel View Search Form Date Help e Review Foot Reader PDF Hom Page Layout MSS -10-AA the cost increase by S7.50 aut how many lamps For the price per lamp will be 1500 must be sold to break ? santant round up to the next und 0 You need 25 please round up to For 20 th ing price per lamp will be $45.00. the variable con decreased by 57 50 anil how many lamps must be sold to breakeven? 02 for 2012 the selling price per lamp is increased to 552 50 and how many lamps must be sold Breakevensies in Cance we cannot sell part of an und up to the next need for 2012 the selling price per lamp is decreased to $37.50 a unit how many lamps must be sold troduction 6 7 8 9 10 11 12 13 14 15 16 17 15 Present Value Type here to search M 016 - Excel Search Fort Bender PDF Font Reader PDF Data View Insert Formulas Review Help Page Layout Home XC Pewat la ora 22 Irama Painter 07 for 2012 the Bling price per lamp is decreas created to 537 50 introduction FAQ 1 2 3 7 8 9 10 11 12 13 14 15 16 17 18 Present Value Tables se Lock Type here to search MF1916.6 P Search Toe Reader POF ViewHelp Review Page Layout File Home Ban Formulas Dots -10 AA MS Surs Sert L ocopy 17 in N has decided to develop its budget based upon projected sales of 33,000 Camat 10 $4900 per me 21 The company has requested that you prepare a master budget for the year. This budget is to be used 29 orang and control of operations and should be composed of 31 1 Production Budget 22 2 Materials Budget 3 Direct Labor Budget 16 & Factory Othed Budget 57 5 Seling and Administre Budget 596 Cost of Goods Sold Budget Budgeted Income Sulement 707 72 Cash Budget 7 Notes for Budgeting 35 The company wants to maintain the same number of units in the beginning and ending inventories of BT work in process and electrical parts while increasing the inventory of Lamp Kits to 550 peces and decreasing the finished goods by 20% 99 Come the following budgets 1 Production Budget Planned Sales Desired Ending Inventory of Finished Goods Total de Less: Beginning inventory Total Production 701) 128 ntroduction FAQ 1 2 3 4 8 9 10 11 12 13 14 15 16 17 18 Present Type here to search MF 16. S Sans Se 5 -A A Needed for Production Ded Loss Beginning m To Puchas y (304 105 Decor La Costa Total Labor Cost Round to places (800) Vara Fach ad Factory Cart Toliate Factory Factory Othead Roundwo places Type here to search Autolave 9- Search Data Review View Foxit Reader PDF Help AC - 9 - ESS Copy Format Painter Overhead Allocation ate based on 1. Number of Units Total Factory Overhead/Number of Units Round t o places 5 Castomakong one o Cost of one lampki Labor Cost Per Lamp Factory Overhead per unit 18:02 13:03) Round to two places, S ) 6 Send Ahn Budget S 1904) Variable Seling (Round to two places, Sw ) Food Administrative Variable Administrative Round to two places. Se Total Seling and Administrative Round to two places. Se (905) 906) S& Round dollars to two ss Beginning Inventory Finished Goods Production Costs 19.07 Lamp Kits Beginning Inventory $5$ Available for Use Ending Inventory of Lamp Kits Lamp Kits Used in Production 19.08) Total Materals Labor 19091 19.10 Introduction FAQ 1 2 ) 5 6 7 9 10 11 12 13 14 15 16 17 18 Present Value Type here to search ME3916. - Search Data View Foxit Reader PDF Review Help t Formulas a ge Layout MS Sans Seed - 8.5 698 Copy - To ng and Admin belound to two places Round dollar to two 19.07) Beginning Inventory Finished Goods Production Costs Mats Lame Beginning intory Purchased Available for Use Ending nentory of Lamp Kits Lamp Kits Used in Production 19.08) 1909) 1910) 13.11) 19.12) 1913 1914 Cost of Goods Available Less Ending inventory, Finished Goods 33889 SSSSSSSS introduction FAQ 7 8 9 10 11 12 13 14 15 16 17 18 Present Type here to search M8916.xx - En e Help Foxit Reader Por Search Review Data view Formulas ment Page Layout The Home A Xoa us some sort as AA Formater F G H I 27 Assume actual cash recepts and disbursement low the poem below. Note Recettes and 2 Payables of 1231/will have a cash impact in 2012) 321 1300% of sales for the year are made in November December Since our customers have 50 day terms 33 those funds will be collected be collected in January and February 342 100of ma p achates will be paid during the year, the remaining portion will be paid in Januar February 353 Alther manufacturing and operating costs we paid for when incurred 384. The busted depreciation expense is equal to 0.6% of the feed manufacturing selling and administrative expenses 39 5. Minimum Cash Balance dedor202 519.000 See The Light Projected Cash Budget For the Year Ending December 31, 2012 Round dollars tot Beginning Cash Balance Cash now Account Receivable (Sales last year not collected Sales made and collected in 202 Cash Aslable 10021 1003) 110041 Cash Outlaws Accounts Payable (Purchases last year) Purchases made and paid for in 202 Other Manufacturing Costs (10.05) Total Manacturing Overhead Selling and Administrative Less Direction Total Cash Ouws 1005 10.07 Budgeted Cash Balance before financing Needed Minimum Balance 1000 Amount to be borrowed any (100%) 10.10 Budgeted Cash Balance introduction FAQ 2 4 5 6 12 13 14 15 16 17 prest Value Type here to search FormulasData Review View Help Foxit Reader PDF Search AutoSave 8 5 File Home Insert Page Layout X Cut Arial Paste BI Format Painter L I Copy - 10-A A ESE A -EEEE Wrap Text Merge & Center - $ % 88-23 AB32 A B C D E F G I See The Light Projected Income Statement For the Period Ending December 31, 20x1 545.00 $30.00 $1,125 000.00 750,000.00 $ 375,000.00 Sales 25,000 lamps @ Cost of Goods Sold Gross Profit Selling Expenses: Foxed Variable (Commission per unit) Administrative Expenses: $3.00 $ 23,000.00 75,000.00 $ 98,000.00 Foxed @ $2.00 $42.000.00 50,000.00 92000.00 Variable Total Selling and Administrative Expenses Net Profit $ 190,000.00 185,000.00 I See The Light Projected Balance Sheet As of December 31, 20x1 Current Assets 5 34.710.00 67 500 00 Accounts Receivable Inventory Raw Material Lamp Kits Work in Process Finished Goods Total Current Assets 500 $16.00 8,000.00 3000 @ $30.00 90,000.00 200 210 00 $ $ 20,000.00 6,800.00 Fixed Assets Equipment Accumulated Depreciation Total Fixed Assets Total Assets 13,200.00 $ 213.410.00 1 FAQ 2 3 introduction 4 5 10 11 12 13 14 15 16 AutoSave @CH H Home Insert Help Foxit Reader PDF Search Page Layout Formulas Data Review View ERO Screenshot plaures Online Shopen leon 301 Get Add Mortable Placommended Table AB32 A B C D E 1 See The Light Projected Balance Sheet As of December 31, 20x1 $ 34,710.00 67 500.00 Current Assets Cash Accounts Receivable Inventory Raw Material Lamp Kits Work in Process Finished Goods Total Current Assets 500 $1600 8,000.00 3000 @ $30.00 90.000.00 $ 200,210.00 Fixed Assets Equipment Accumulated Depreciation Total Fixed Assets Total Assets $ 20,000 00 6.800.00 13.200.00 213.410.00 $ SS4000.00 $ 54,000.00 Current Liabilities Accounts Payable Total Liabilities Stockholder's Equity Common Stock Retained Earnings Total Stockholder's Equity Total Liabilities and Stockholder's Equity $ 12.000.00 147.410,00 159 410 00 213.410.00 $ FAQ 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 Pre Type here to search