I SEE THE LIGHT, CYBERTEXT
Can someone please help me with parts 5.01-5.04, 6.01-6.04, & 7.01? An explanation would be great.
AutoSave OF AA 2OO.. JB6554 Home Insert Draw Page Layout Formulas Data Review View Tell me Share Comments . X [G al Wrap Text ,,, Paste BIU Merge & Center v $ % SB Insert Delete Conditional Format Cell Formatting as Table Styles Format Sort Find Select Filter Analyze Data V Open recovered workbooks? Your recent changes were saved. Do you want to continue working where you left off? Yes No D3 XV fix A B . I J L M M N P Q R S LI W Y DZ Z I SEE THE LIGHT Background Information I SEE THE LIGHT (ISTL) is a subchapter Scorporation that manufactures children's lampsightlights for use in bedrooms. These lamps are sold nationwide through a group of independent sales representatives who have an exclusive sales region. The business is in its tenth year and has asked you to assist in planning for next year's operations The lamps are ceramic figurines of animals, boats, boys and girls playing and singing, al in delightful colors The owner of the business. Big Al. creates a crawing for the figurine and faxes it to a plant in China where a mold is created and a sample produced and hand painted. If the mald meels the expectations of Big A an order of 500 lamp parts is placed. Each lamp kit consists of the parts required to complete one lamp: a figurine, a lamp shade and the required electrical components. There are presently 10 different figurines that come in six different colors: 60 models There are presently 10 workers in the plant. They are responsible for receiving the raw material, manufacturing the product packing and shipping. In addition to Big Al there are two office workers who are responsible for all administrative duties Big Al had his accountant prepare the Projected Income Statement and Balance Sheet presented on page two. Big Al heard about your skills in managerial accounting and would like your assistance in the following areas: 10 11 12 13 14 15 16 17 18 18 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 46 46 47 48 49 50 Part 1 Part 2 Part 3 Part 4 4 Part 5 Part 6 Part 7 Fixed and Variable Cost Determinations - Unit Cost Calculations Cost Volume Relationships - Profit Planning Budgets Process Costing Job Order Coating Standard Costing - Variance Analysis Capital Decision Making To upload your work to Big Al the file without changing the name. Pay attention to the specific location that Excel saves the file. Return to the bottom of the page that you downloaded the file from: Cybertext.com, The Book List Building Blocks of Accounting-A Managerial Perspective, Enter password, Upload Your Excel File If you upload an old version of the file the results will not update. Keep two coples of your spreadsheet in two separate places in case one of Big Al's competitors sends someone to destroy your work or it is lost in transmission. You may find it easier to work on this project if you print a hard copy of all the pages. NOTE: FAQ 1 A A4 B A B AS A 10 A 11 - 12 A 13 Ready + 100% AutoSave OF AA 2OO.. JB6554 Home Insert Draw Page Layout Formulas Data Review View Tell me Share Comments X [G al Wrap Text Paste Insert $ % Merge & Center Sort Delete Conditional Format Cell Formatting as Table Styles Format Find Select Filter Analyze Data V Yes No A1 Open recovered workbooks? Your recent changes were saved. Do you want to continue working where you left off? fx A E G H T JK I See The Light Projected Income Statement For the Period Ending December 31, 20x1 L M N R S T U V W X 2 3 S 1,195,000.00 750,000.00 S 375,000.00 10 19 25,000 lamas S4500 Cost of Guods Sou @ $30.00 Gross Pront Solra Expenses: Flead Variable (Commission perunt) @ $3.co Admnistrative Expenses Fbcd Varahl $2.00 Tula Seling and Administrave Expe1888: Nat Profit S 29 00 00 75,000.00 3 98,000.00 5 42.000.00 50 ODO OD 92,000.00 180,000.00 S 105,000.00 I See The Light Projected Balance Sheet As of December 31, 20x1 $ 32 93 34 36 36 45 46 47 48 49 58 be GO f1 82 71 72 73 74 75 84 A5 86 07 be 97 98 be 100 101 110 34.710.00 67,500.00 Current AR Cash Accounts Receivable Inventory Raw Materal Lamp Kits Viork in Process Finished Goods Total arent ASSAS 8.000.00 500 $16.00 0 3000 $30.00 90,000.00 S 200,210.00 Fbed Assets Equiamant Acumulated Depreciation Tulal Fixed Anreis Total Assets $ 20,03,0 1,800.00 13.200.00 S213.410.00 112 Current Liabites Accounts Payable Totalliblik FAQ A 54,000.00 54,0CO DO A6 2 A A4 B A B AS A 10 A 11 - 12 A 13 Ready + 100% AutoSave OF A A2OO.. JB6554 Home Insert Draw Page Layout Formulas Data Review View Tell me Share Comments . X [G ab Wrap Text Paste BIU Merge & Center $ % SB Insert Delete Conditional Format Cell Formatting as Table Styles Format Sort Find Select Filter Analyze Date V Open recovered workbooks? Your recent changes were saved. Do you want to continue working where you left off? Yes No A1 A H J L M N D Q R 8 8 T U W W B D F Fixed and Variable Cost Determinations Unit Cost Calculations E 7 L The projected cost of a lamp is calculated based upon the projected increases or decreases to 5 cumont costs. The present costs to manufacture one lampa: 10 11 Lamp kit KE 51600COOC perlamp 23 Direct labor 20000000 per lamp 4 lamhr.) 24 Variable Overhead: 2.0000000 per kamp 25 Fixed Overhead 10.0000000 per lamp based on rommal capacity of 25.000 amps) 36 36 Coal parlame: $3COOCOOC perlamp 37 38 Expected increases for 20x2 39 When callsting projected in ourd to TWO (50.00) dec ma che 49 1. Material Costs are expected to increase by 4.00% 51 52 2 Labor Orels are expected to increase by 5.00% 53 63 3. Variable Overhead is expected to increase by 4.50%. 64 65 4. Fized Dwarhead sex acted to increase to $280.000 88 67 6. Flued Administrat compenses are expected to ncrease to $60,000. 77 78 6. Variable saling exersa (assured or a per bamph) Are Axected to inRARA 79 by 3.50% 00 81 7. Fixed seing expenses are expected to be S35,000 in 2012. 91 92 8. Variable administrative expense Tured as perlamp basis) are expected to increase by 2.00% 94 95 on the following schedule davala the following us 105 1- 20:2 Projected Variable Manufacturing Unit Cost of Alamp 106 107 2. 20x2 Projected Variable Unit Cost per lamp. 108 109 3- 202 Prajndled Fixed Conte 119 22 FAQ 3 A5 B AS A 10 A 11 A 13 - 12 Ready + 100% AutoSave OF AA 2OO.. JB6554 Home Insert Draw Page Layout Formulas Data Review View Tell me Share Comments . X [G a Wrap Text Paste 1 Merge & Center $ % SB Insert Delete Conditional Format Cell Formatting as Table Styles Format Sort Filter Find Select Analyze Data V Open recovered workbooks? Your recent changes were seved. Do you want to continue working where you left off? Yes No D74 X VS. . D G H T J L M N 9 Variable Mourachung Liar Cost 20x1 Coat Projected Percent Increase 20x2 Curl Rounded lu 2 Decimal Places 4 16 2 2 $16.64 $2.10 $2.09 $ 14.02) [4.09) 4.5 10 11 Lamp Kt 12 Labor 19 Variable Overhead 20 21 Projected Variable Manufacturing Cost Per Unit 22 23 30 31 Told Variable Coat Pur 20 $20.03 (4.04) 20x1 Coal Projected Pcreant INCIAASA 20x2 Cost Rounded to 2 Decimal PACA 95 9 2 2 3.11 2.04 20.83 (405) (108) (4.04) 32 33 Variable Selling 34 Variable Anita 41 Projecte Variable Manufacturing Unit Cosi 42 43 44 Projected Total Variable Cost Per Unit 45 52 53 54 Schedule of Five Goals 25.98 (4.07) 20x1 Goal 20x2 Cost Projccted Percent Increase 2899900 10 S 290,000.00 (4.08) S 23000 42000 52.1739 42.8571 35,000.00 60,000.00 (4.09) (4.10) S 66 Fixed Overeed 62 nomal capacly of lamps @_) 54 Fixed Beling 65 Fixed Administrative 66 87 Projeleu Total Fixed Costs 74 78 76 FAQ Ready 985,000.00 (4.11) " B a 10 A 11 A 12 13 + 100% AutoSave OF AA 2OO.. JB6554 Home Insert Draw Page Layout Formulas Data Review View Tell me Share Comments X [G at Wrap Text , ,,, WS Paste 1 Format $ % Insert SB Delete Merge & Center v Conditional Format Cell Formatting as Table Styles Sort Filter Find Select V Analyze Data Open recovered workbooks? Your recent changes were saved. Do you want to continue working where you left off? Yes No 127 E r H L N o P D 5 U VW X Y Z PART 2 Cost Volume Relationships - Profit Planning Fly two ante egte the meant to send Kawin 10 New Forestal warnt al part of a lonterkarrel where your brand 11 poradcowit Futum. find the new modele indos trato find the 12 uber of unisondton nyt singkol 13 15 1. Fu 2002 di PT Mille 14.10. Wcia di rancak bukan do you 16 PM' 17 1B 1P 21 22 Costa Nargin Rand SSSR 40 Cew Norino Rourd to four po. kwotworoplo For 2012 set. Teoretirane 2012 12 5127.300 W Steina 20 21 42 43 Bad una leve casse par trupin tur tressed (8099 Fu2b2d VID MIL 45.00. I bolo... LOCO LOW THI tespidis 60 Broeken und wir ce 74 FAQ A3 5 B AS A 10 A 11 A 12 A 13 Ready 78% AutoSave OF AA2OO... JB6554 Home Insert Draw Page Layout Formulas Data Review View Tell me Share Comments X [G h Wrap Text Paste BI U Merge & Center $ % SB Insert Delete Format Sort Conditional Format Cell Formatting es Table Styles v Find Select V Filter Analyze Data Open recovered workbooks? Your recent changes were seved. Do you want to continue working where you left off? Yes No H37 A J L M N 0 Q R T D E H H For 20x2 the selling prio per lamp wl be $45.00. If the variable cost increase by 56.00 a unk how many lamps IT tok: le tro 10 14 16 17 18 21 Bakeven sales in .nts in Werder moure uplets needed 0} 5. For 20x2 the selling prior per lamp wl be $45.00. If the variable cost decreased by $5.00 aunt how many as . malt kok: lo tre Bakoven saks inntar diante un arc ultroll freda If for 2la2 the ring proper pis in to $90.00 a intromery ampe must be end obrokoven? to Hokean sale in nix is rewart wit d sin manipistonos Frente mare BCS) 57 7. If for 20,2 the selling prioc per amp is cercased to 540.00 a unk how many lamps must be sold to have GO R! Bakoven sales in .nts i de terrorcupletorede www.purple {804) FAQ A B B A 10 A 13 A 11 - 12 Ready 90% AutoSave OF AA 2OO.. JB6554 Home Insert Draw Page Layout Formulas Data Review View Tell me Share Comments X [G at Wrap Text Paste BIU $ % Merge & Center SB Insert Delete Conditional Format Cell Formatting as Table Styles Format V Sort Filter Find Select Analyze Data V Yes No H J . L M N o Open recovered workbooks? Your recent changes were saved. Do you want to continue working where you left off? Al fx B E E 4 PART 3 5 Budgets 9 10 11 Criston N has decded to develop its budgct based upon proiected sales of 41,000 lamps at 12 $40.00 per me 13 The company has requested that you prepare a master budget for the year. This budget is to be used 17 for planning and contial of operations and should be compared of 18 19 1. Production Budget 20 21 2. Material Budget 25 26 3. Direct Labor Budget 27 28 4. Factory Overhead Budget 29 33 6. Seling and Administrative Budget 34 35 6. Coat of Gooda Soki Rucgal 36 7. Budgeted Income Statement 41 42 8. Cash Budget 49 44 Notes for Budgeting 46 49 50 The company wants to maintain the same number of units in the beginning and ending inventories of 51 work-in-prozes, and electrical parts while increasing the inventory of Lamp Kits to 876 pieces and 52 decreasing the finished goods by 20%. 53 57 Complete the following budget 58 be 1 Posuction Budger GO F1 Planrad SALAH 65 Desired Erding Inventory of Finished Gouce BB Total Needed 67 Les Beginning Inventory fe 69 Tatal Production 7.01) 73 74 75 AFAQ B a B A 10 A 11 - 12 A 13 Ready + 100%
