I see The Ught Projected Balance Sheet As of December 31, 20x1 Current Assets Current Liabilities Accourits Payable Total Liabintios Stockholder's Equity Common Slock Retained Eamings Tolal Stockholder's Equity Total Liabitities and Stockholder's Equity $$12,000.00147,410,00159.410.005.213.410.00 A Introduction PART 1 Fixed and Variable Cost Determinations Unit Cost Calculations The projected cost of a lamp is calculated basad upon the projected increases or decroases to curent costs. The present cosis to manufacture one lamp are: Expected increases for 20x2 When calculating projected increases round to TWO (50.00) decimal places. 1. Materia pected to increase by 5.09%. 2. Labor Costs are expected to increase by 3.00%. 3. Varlable Ovemead is expected to increaso by 3.50%. 4. Fixed Overhead is expected to increase to $270,000. 5. Fxod Administrathe expenses are expected to increase to $52,000 6. Varlable selling expenses (measured on a per lamp basis) are expected to increase by 5.50%. 7. Fored selling expenses are expected to be 523,000 in 202. B. Variable adminiatmtive expenses (measured a per lamp basis) are expected to increase by 6.00%. On the tollowing schedule develop the folowing figures: 1. 20x2 Projecled Variable Manufacturing Unh Cost of a lamp. 2. 202 Projected Variable Unil Cost per lamp. 3. 202 Projected Fred Cosis. inst be sode fie froakevent ruat be sodi to bectepen? to preak teren? Bwion Nkas decided to deveiop ts budget based upon projected sales of 33,000 lamps at S5s.00 per lante. The comgany has mogested that you peepaze a master budget for the year. This budget is lo be used The poonning and control of operationt and should be compoted of: 1. Praduction Budget 2. Matedais Budget 1. Direcl Labor Busget 4. Fachory Cvertiead dodget. 5. Seling and Administrative Budget 10. Cost of Goods Soid Budget 7. Budgeted Incarre Statemant b. Gash A uadget Noles lor 8udgeting: The aenpbhy wants to muintain the same number of units in the beginning and anding inventories of work mprocest, and electices paAts atile increasing the ryentory of Larrp Kits to 525 pigces and de oreatig tise froithod good by 20 pos MS San Sent * 12+AN+A General fx534364 B C. D E F Materials Budget Lamp Kits Needed for Production Dosired Ending Inventory Total Needed Less: Beginning Inventory Total Purchases Cost per piece Cost of Purchases (Round to two places, \$wit...m) Direct Labor Budgot Labor Cost Per Lamp Production Total Labor Cost (Round to two places, \$4in. Hit) Eactory Overtiead Budget Varlable Factory Overhead: Variable Factory Overhead Cost Per Unit Number of Units to be Produced Total Variable Factory Ovorhead (Round to two places, \$\#Wi, anf) Fixed Factory Overhead Total Factory Overhead (Round to two places, \$un .uA) {8.07 {8.08) (8.11) Found doliant to two. e Gast Buext Ausue actal cah receigts and diturlenerts wit folow the patorn below (Noler Receviabies and Paybien of 123uxi will have a cash incect in 20x2.) 1. 2000 of sade for te year are made in Novenber and Docember. Since our customers have 60 diy lerm: fose tunde will be colocted be colecided in Jmary and Fibruery. 2. Bo cess of maderia purchases will be peid daing the year, the femaining porsion will be paid in Januay or February. 2. Al other marufaturing and coerating conts ave peid for aben incurred. 4. The budguted degrecinion epente is boual is 0.6s of the fxed manufachring teling and administative expenses. 5. Minimum Cach flelare needed for 200, $165.000. I see The Light Prolected Cath Budgen For the Your Ending December 31, 20xa Cost Volume Relationships - Profit Planning tated on the lollowirg atiumptori. nmber di und avd then mufiply ty the seli ne price per unit. For abet the deling price per lamp wil be SES ob. What is the propected cortritution margh and contibuter For zaip the selicg price por lamp wil be 515 oo. The denired toe income in 2002 is $197 s00, What For aba tee seling price per larnp will be 5450 on. th the fixad cost increase by 500.000 .00 how mary iampe Bredeven ades inisitu (Since we cancel sail ferl of a unt round be fo the neat unit froodse) For 20x2, the seling price per lamp wil be $45.00. If the variable cost increase by $6.00 and how many lamps irust be sold to breakeven? Breakeven salen in unlts (Sinoe we canrot sel part of an unt round up to the neat unt if neoded) For 20x2 the selting price per lamp wil be 446.00 . If the variable cost decreased by 56.00 a unit how many lamps irust be sold to breakeven? If for 20x2 the seling price per lamp is increased to $51.00 a unit how many lamps must bo 50 d It for 202 the selling peice par lamp is decreased to $39.00 a unit how many lamps must be sold to breakiven? Diviaion Nhas decided to develop its budget based upon projected salos of 33,000 lamps at 553.00 por lamp. The company has requested that you prepare a master budget for the year. This budget is to be used fot planning and control of operations and should bo composed of: 1. Production Budget 2. Materials Budget 3. Droct Labor Budget 4. Factory Overhead Budget 5. Selling and Administrathe Budget 6. Cost of Goods Sold Budget 7. Budgeted Income Statement 8. Cash Budget Notes for Budgeting: I see The Ught Projected Balance Sheet As of December 31, 20x1 Current Assets Current Liabilities Accourits Payable Total Liabintios Stockholder's Equity Common Slock Retained Eamings Tolal Stockholder's Equity Total Liabitities and Stockholder's Equity $$12,000.00147,410,00159.410.005.213.410.00 A Introduction PART 1 Fixed and Variable Cost Determinations Unit Cost Calculations The projected cost of a lamp is calculated basad upon the projected increases or decroases to curent costs. The present cosis to manufacture one lamp are: Expected increases for 20x2 When calculating projected increases round to TWO (50.00) decimal places. 1. Materia pected to increase by 5.09%. 2. Labor Costs are expected to increase by 3.00%. 3. Varlable Ovemead is expected to increaso by 3.50%. 4. Fixed Overhead is expected to increase to $270,000. 5. Fxod Administrathe expenses are expected to increase to $52,000 6. Varlable selling expenses (measured on a per lamp basis) are expected to increase by 5.50%. 7. Fored selling expenses are expected to be 523,000 in 202. B. Variable adminiatmtive expenses (measured a per lamp basis) are expected to increase by 6.00%. On the tollowing schedule develop the folowing figures: 1. 20x2 Projecled Variable Manufacturing Unh Cost of a lamp. 2. 202 Projected Variable Unil Cost per lamp. 3. 202 Projected Fred Cosis. inst be sode fie froakevent ruat be sodi to bectepen? to preak teren? Bwion Nkas decided to deveiop ts budget based upon projected sales of 33,000 lamps at S5s.00 per lante. The comgany has mogested that you peepaze a master budget for the year. This budget is lo be used The poonning and control of operationt and should be compoted of: 1. Praduction Budget 2. Matedais Budget 1. Direcl Labor Busget 4. Fachory Cvertiead dodget. 5. Seling and Administrative Budget 10. Cost of Goods Soid Budget 7. Budgeted Incarre Statemant b. Gash A uadget Noles lor 8udgeting: The aenpbhy wants to muintain the same number of units in the beginning and anding inventories of work mprocest, and electices paAts atile increasing the ryentory of Larrp Kits to 525 pigces and de oreatig tise froithod good by 20 pos MS San Sent * 12+AN+A General fx534364 B C. D E F Materials Budget Lamp Kits Needed for Production Dosired Ending Inventory Total Needed Less: Beginning Inventory Total Purchases Cost per piece Cost of Purchases (Round to two places, \$wit...m) Direct Labor Budgot Labor Cost Per Lamp Production Total Labor Cost (Round to two places, \$4in. Hit) Eactory Overtiead Budget Varlable Factory Overhead: Variable Factory Overhead Cost Per Unit Number of Units to be Produced Total Variable Factory Ovorhead (Round to two places, \$\#Wi, anf) Fixed Factory Overhead Total Factory Overhead (Round to two places, \$un .uA) {8.07 {8.08) (8.11) Found doliant to two. e Gast Buext Ausue actal cah receigts and diturlenerts wit folow the patorn below (Noler Receviabies and Paybien of 123uxi will have a cash incect in 20x2.) 1. 2000 of sade for te year are made in Novenber and Docember. Since our customers have 60 diy lerm: fose tunde will be colocted be colecided in Jmary and Fibruery. 2. Bo cess of maderia purchases will be peid daing the year, the femaining porsion will be paid in Januay or February. 2. Al other marufaturing and coerating conts ave peid for aben incurred. 4. The budguted degrecinion epente is boual is 0.6s of the fxed manufachring teling and administative expenses. 5. Minimum Cach flelare needed for 200, $165.000. I see The Light Prolected Cath Budgen For the Your Ending December 31, 20xa Cost Volume Relationships - Profit Planning tated on the lollowirg atiumptori. nmber di und avd then mufiply ty the seli ne price per unit. For abet the deling price per lamp wil be SES ob. What is the propected cortritution margh and contibuter For zaip the selicg price por lamp wil be 515 oo. The denired toe income in 2002 is $197 s00, What For aba tee seling price per larnp will be 5450 on. th the fixad cost increase by 500.000 .00 how mary iampe Bredeven ades inisitu (Since we cancel sail ferl of a unt round be fo the neat unit froodse) For 20x2, the seling price per lamp wil be $45.00. If the variable cost increase by $6.00 and how many lamps irust be sold to breakeven? Breakeven salen in unlts (Sinoe we canrot sel part of an unt round up to the neat unt if neoded) For 20x2 the selting price per lamp wil be 446.00 . If the variable cost decreased by 56.00 a unit how many lamps irust be sold to breakeven? If for 20x2 the seling price per lamp is increased to $51.00 a unit how many lamps must bo 50 d It for 202 the selling peice par lamp is decreased to $39.00 a unit how many lamps must be sold to breakiven? Diviaion Nhas decided to develop its budget based upon projected salos of 33,000 lamps at 553.00 por lamp. The company has requested that you prepare a master budget for the year. This budget is to be used fot planning and control of operations and should bo composed of: 1. Production Budget 2. Materials Budget 3. Droct Labor Budget 4. Factory Overhead Budget 5. Selling and Administrathe Budget 6. Cost of Goods Sold Budget 7. Budgeted Income Statement 8. Cash Budget Notes for Budgeting
