Need help on Sheet 9, Sheet 10, 15.01, and 17.06. All necessary values are included.
idk.xls [Compatibility Mode] a- Search Sheet Home InsertPage Layout Formulas Data Review View Share v in bedrooms. These lamps are sola nabonwite through a group of irdependent sales representatves who 12 have an excusive sales region. The business is in its tenth year and has asked you to assist in plannirg for 13 next years opcrations 15 Tha lamps are cerarmic figurines of animals, boats, boys and girls playing and inging, all in delightful colors. Tha owner of the business, Big Al, creates a drawing for the fgurine and fexes it to a plant in China where a 17mold is created and a sample produced and hand painted. I the mold meets the expectations of Big Al an 18order of 500 lamp parts is placad. Each lamp kit consists of the parts required to complate one lamp, a figurine, a lamp shade and the required electrical components. There are presently 10 different figurines that come in sx different colors; 80 medels There are presently 10 workers in the plant Thay are respansible far recciving the raw material, manufacturing 2the preduct, packing and shipping. In addition to Big Al there are two office workers who are responsible for all 25administrative duties. 27 igA had his accountant prepare the Projecad Income Statement and Balance Sheet presented on page two. 28 Bg Al heard about your slls in managerial sccounting and would le your e88stance in the folowing areas Part 1 Fixed and Variable Cost Determinatione Unit Coet Calculatians Part 2 Coet Volume Relationships Proft Planring 32 Part 3 33Part 4 Part 5 Bucgets Procees Costing Job Order Ccsting Part 6 Standard Costng Variance Analyss Part Capial Docision Making 3To uplaad your work to Bg A the file without changirg the name. Pay attention to the specific Iocation that 40 Exoel seves he file, Retum to the boom of the page that you downloaded the fie from;Cybertext.com, The 1 Book List, Bulding Blocks of Accounting--A Menegeriel Perspective, Enter password, Upoad Your Exoal Fils 42 If you upload an cld version of the file the results wil not update Keep two copies af your spreadsheet in two separate places in case one of Big Ars mpetiers sends Yau may find it easier to wark on this project if you print a hard capy of all the pages. there are any questions about the project e-mal markfriedman@miamiedu or call 305 284.629 45 someone to destroy your work or is loet in tranemission 4 NOTE: redeb bssed upon answers entered into the shadad boxes. 5e 81 72 a 11 dk.xls [Compatibility Mode] a- Search Sheet Home InsertPage Layout Formulas Data Review View Share v Fortho Perlod Ending Decorrber 31, 20x1 2,0anar @ tAs.cn 1,124 0oa.oo 375,000.00 23,000.00 7G.c00.co tcommisson par uni) @E3.00 ea.000.00 Total Selling and Admnatv Exponsos: Projeead Balance 8heet As of Deceber 31, 20x1 so$18.cn E 20,000.co 1.0n ca 11 14 16 100% dk.xls [Compatibility Mode] a- Search Sheet Home InsertPage Layout Formulas Data Review View Share v Unit Cost Calculations $1e.oc0ncan par 38 Enpactod inerisas fer 20a 39 yhen caouating ;roioesed igase found 0 TAO IEO.COJeecinal pia006. 1. Maleial Costs ar 40ected to increase by 3.50% 2. Lator Ooss ale opuood to rouse by 6.00%. 4, Fbod Cvortoao xpegod to nov300 to $3.00.DC0. try 2.50%. 96 n the olowing schodulo dowoiog the folowingguros: 1-2th2 Prmpeted Vnttle Manntattusrg Ceat tla b.mp 3 200 Projocd Foed Costs 11 14 e 16 Ready 100% dk.xls [Compatibility Mode] a- Search Sheet Home InsertPage Layout Formulas Data Review View Share v 10 | 1. For 20x2 to soling pnoa per bmp lbe 54G.00. yhat is the pejeotoo connuion magin and oen!tution 28 Contrbution Magi por unit (Rourd io two placos, Ete e - 31 centthitinn Mener R.linacune lafur pheno. % twtoff, hero+4. Aas. 3e | 2. For 20x2 to solng pnoa per bmp-il be 54.00. Tho dosaod net income in 20x2 is 200.DC0What (5031 oa. 3. For 20x2 the soling proa per bmp wil be 54G.00. r the rbod oost incoaso by S45.coD.00 row many bmps o eoid to broskavon? 22,996 ws 5.04 a 11 16 100% dk.xls [Compatibility Mode] a- Search Sheet Home InsertPage Layout Formulas Data Review View Share v 13 (s a1 25 | 5. For 20x2 to sok g proa per bmp wil be S4G.00. r te varasla cost docuasod by .50 unit how many ngs soid to troakavon? (6.02 a 11 16 100% dk.xls [Compatibility Mode] a- Search Sheet Home InsertPage Layout Formulas Data Review View Share v Labor Ce Per Lamp Pmdutinn 9.090 a 11 16 100% dk.xls [Compatibility Mode] a- Search Sheet Home InsertPage Layout Formulas Data Review View Share v Round to two pboos.S.e) Factory ovonoad psr ur. Foud Acmi .00 Ending Inaenlory 01 Lang K % Lamp kits Usod n Producto 1.082.0.0 s Aalabo a 11 e 16 Ready 100% dk.xls [Compatibility Mode] a- Search Sheet Home InsertPage Layout Formulas Data Review View Share v Ceol so Goods Sal Eross Pef 3aing Exporsas & Admin. Expensss 18 3m Cash Balanco nosdod for 22, 5190,100 300 The Lignt Projoctod Cash Budgat For the Yoar Ending Dacembar 31.202 Raund dclars to 04 Bghnig Cach Balanoo Account Rocstablo 3aNs last year rot elecnd 110031 Cash Outfwa Accounts Paablo Puchaes last ywar) 1 10051 Puchas mde and paid lor h 202 Total Manufactuning Oatead Total Cas Ounows 108 B dpatod Cash Bance teforo naning 11 Bdgstod Cash Ban 110 10 a 11 16 Ready 100% idk.xls [Compatibility Mode] a- Search Sheet Home InsertPage Layout Formulas Data Review View Share v 2 839 4 PART 4 Process Costing-Weighted Average Canal Infomation D Tho 5oo Tho Light Company has arobied compary that paducas the fgurhos. They uso pDoass cocting 33 Mont ol January Malding Depsmont 35 Canebs i,man, "on' s, ra.co% Innusry 1 wem 3DC f gum," at n oont ee $e a R25.cn th"rmunt 55,2an.cn wn tmm GB Tho a.000 1gurinos that "ono in pocos& at the ord of January woro aggumod to to 60.00% oamoosa to AI figures r, January passed itspeeen. 123 14 Ready 100% dk.xls [Compatibility Mode] a- Search Sheet Home InsertPage Layout Formulas Data Review View Share v 21 Unis 3tartod this Poicd (1202 (12.03 (12.04 (12.05 (20 33881.0 iza 11 14 100% dk.xls [Compatibility Mode] a- Search Sheet Home InsertPage Layout Formulas Data Review View Share v 20 kb Odor CocinD Socien B pe ould far 4.ocn cuatamtne bampxn Tha lelenme sn1ef1s.nanesena ooeumnd hem 5-Jan Purchased 4,1 75 Lamp K S16.75 per ki. g-Jan 4,175 ss Lamp Kis wN wubiioned. 30-Jan Fayolo 0EO Doct Labor Hours510.05 per heur. 30-Jan 3.890 lamps wora complolod ard shippoc. A maa used or sorapood and ano a cost of nomal procossing rocutianed wow 1,123 45 Coof 11.0) Cost of Manacung tcad Coot t cno lamp a 11 100% dk.xls [Compatibility Mode] a- Search Sheet Home InsertPage Layout Formulas Data Review View Share v A1 Standard Job Order Costing- Variance Analysis 15 50 To k cones of the actual oosto, .co. -ob Order Cost 9ysion has oen d.veloped. Etrios 57 ano nade to 0 Jeb Odor 3rsism actual .oworoad is applied basoo on actual labor hours) B whlo entks ak maco io te acoouniing sycton at sandard. Varaazis is usod to anayzo tho T -Jan Pal 030 Doc Lator Hour 9.B por hour. 30Jan Pa of 030 Droct Lator Hourr 510. par hour. 133e 1,123.45 a 11 16 Ready 100% dk.xls [Compatibility Mode] a- Search Sheet Home InsertPage Layout Formulas Data Review View Share v B C How amy Lampo war cempheled? 10 No. 8how favoratzie variances as negative numbers 15.01) 21 What was the mataro sage varono for Lamp Kte? 11 .00) 115.04 47 7 a 11 14 100% .idk.xls [Group] [Compatibility Mode] a- Search Sheet Home InsertPage Layout Formulas Data Review View Share v Capital Decision Making 12 Big Algwos hls oorkor's oro tour l.nch and two fition minus. blaks Non cay. Ho boioves that a 13 ocld soda machino would bo agpdatod by his worors, and an approdaikd woter t a good woker. Wha s the 1702 1783 616 174 (12.05 he tatks (1707 11 12 Ready 98% idk.xls [Compatibility Mode] a- Search Sheet Home InsertPage Layout Formulas Data Review View Share v in bedrooms. These lamps are sola nabonwite through a group of irdependent sales representatves who 12 have an excusive sales region. The business is in its tenth year and has asked you to assist in plannirg for 13 next years opcrations 15 Tha lamps are cerarmic figurines of animals, boats, boys and girls playing and inging, all in delightful colors. Tha owner of the business, Big Al, creates a drawing for the fgurine and fexes it to a plant in China where a 17mold is created and a sample produced and hand painted. I the mold meets the expectations of Big Al an 18order of 500 lamp parts is placad. Each lamp kit consists of the parts required to complate one lamp, a figurine, a lamp shade and the required electrical components. There are presently 10 different figurines that come in sx different colors; 80 medels There are presently 10 workers in the plant Thay are respansible far recciving the raw material, manufacturing 2the preduct, packing and shipping. In addition to Big Al there are two office workers who are responsible for all 25administrative duties. 27 igA had his accountant prepare the Projecad Income Statement and Balance Sheet presented on page two. 28 Bg Al heard about your slls in managerial sccounting and would le your e88stance in the folowing areas Part 1 Fixed and Variable Cost Determinatione Unit Coet Calculatians Part 2 Coet Volume Relationships Proft Planring 32 Part 3 33Part 4 Part 5 Bucgets Procees Costing Job Order Ccsting Part 6 Standard Costng Variance Analyss Part Capial Docision Making 3To uplaad your work to Bg A the file without changirg the name. Pay attention to the specific Iocation that 40 Exoel seves he file, Retum to the boom of the page that you downloaded the fie from;Cybertext.com, The 1 Book List, Bulding Blocks of Accounting--A Menegeriel Perspective, Enter password, Upoad Your Exoal Fils 42 If you upload an cld version of the file the results wil not update Keep two copies af your spreadsheet in two separate places in case one of Big Ars mpetiers sends Yau may find it easier to wark on this project if you print a hard capy of all the pages. there are any questions about the project e-mal markfriedman@miamiedu or call 305 284.629 45 someone to destroy your work or is loet in tranemission 4 NOTE: redeb bssed upon answers entered into the shadad boxes. 5e 81 72 a 11 dk.xls [Compatibility Mode] a- Search Sheet Home InsertPage Layout Formulas Data Review View Share v Fortho Perlod Ending Decorrber 31, 20x1 2,0anar @ tAs.cn 1,124 0oa.oo 375,000.00 23,000.00 7G.c00.co tcommisson par uni) @E3.00 ea.000.00 Total Selling and Admnatv Exponsos: Projeead Balance 8heet As of Deceber 31, 20x1 so$18.cn E 20,000.co 1.0n ca 11 14 16 100% dk.xls [Compatibility Mode] a- Search Sheet Home InsertPage Layout Formulas Data Review View Share v Unit Cost Calculations $1e.oc0ncan par 38 Enpactod inerisas fer 20a 39 yhen caouating ;roioesed igase found 0 TAO IEO.COJeecinal pia006. 1. Maleial Costs ar 40ected to increase by 3.50% 2. Lator Ooss ale opuood to rouse by 6.00%. 4, Fbod Cvortoao xpegod to nov300 to $3.00.DC0. try 2.50%. 96 n the olowing schodulo dowoiog the folowingguros: 1-2th2 Prmpeted Vnttle Manntattusrg Ceat tla b.mp 3 200 Projocd Foed Costs 11 14 e 16 Ready 100% dk.xls [Compatibility Mode] a- Search Sheet Home InsertPage Layout Formulas Data Review View Share v 10 | 1. For 20x2 to soling pnoa per bmp lbe 54G.00. yhat is the pejeotoo connuion magin and oen!tution 28 Contrbution Magi por unit (Rourd io two placos, Ete e - 31 centthitinn Mener R.linacune lafur pheno. % twtoff, hero+4. Aas. 3e | 2. For 20x2 to solng pnoa per bmp-il be 54.00. Tho dosaod net income in 20x2 is 200.DC0What (5031 oa. 3. For 20x2 the soling proa per bmp wil be 54G.00. r the rbod oost incoaso by S45.coD.00 row many bmps o eoid to broskavon? 22,996 ws 5.04 a 11 16 100% dk.xls [Compatibility Mode] a- Search Sheet Home InsertPage Layout Formulas Data Review View Share v 13 (s a1 25 | 5. For 20x2 to sok g proa per bmp wil be S4G.00. r te varasla cost docuasod by .50 unit how many ngs soid to troakavon? (6.02 a 11 16 100% dk.xls [Compatibility Mode] a- Search Sheet Home InsertPage Layout Formulas Data Review View Share v Labor Ce Per Lamp Pmdutinn 9.090 a 11 16 100% dk.xls [Compatibility Mode] a- Search Sheet Home InsertPage Layout Formulas Data Review View Share v Round to two pboos.S.e) Factory ovonoad psr ur. Foud Acmi .00 Ending Inaenlory 01 Lang K % Lamp kits Usod n Producto 1.082.0.0 s Aalabo a 11 e 16 Ready 100% dk.xls [Compatibility Mode] a- Search Sheet Home InsertPage Layout Formulas Data Review View Share v Ceol so Goods Sal Eross Pef 3aing Exporsas & Admin. Expensss 18 3m Cash Balanco nosdod for 22, 5190,100 300 The Lignt Projoctod Cash Budgat For the Yoar Ending Dacembar 31.202 Raund dclars to 04 Bghnig Cach Balanoo Account Rocstablo 3aNs last year rot elecnd 110031 Cash Outfwa Accounts Paablo Puchaes last ywar) 1 10051 Puchas mde and paid lor h 202 Total Manufactuning Oatead Total Cas Ounows 108 B dpatod Cash Bance teforo naning 11 Bdgstod Cash Ban 110 10 a 11 16 Ready 100% idk.xls [Compatibility Mode] a- Search Sheet Home InsertPage Layout Formulas Data Review View Share v 2 839 4 PART 4 Process Costing-Weighted Average Canal Infomation D Tho 5oo Tho Light Company has arobied compary that paducas the fgurhos. They uso pDoass cocting 33 Mont ol January Malding Depsmont 35 Canebs i,man, "on' s, ra.co% Innusry 1 wem 3DC f gum," at n oont ee $e a R25.cn th"rmunt 55,2an.cn wn tmm GB Tho a.000 1gurinos that "ono in pocos& at the ord of January woro aggumod to to 60.00% oamoosa to AI figures r, January passed itspeeen. 123 14 Ready 100% dk.xls [Compatibility Mode] a- Search Sheet Home InsertPage Layout Formulas Data Review View Share v 21 Unis 3tartod this Poicd (1202 (12.03 (12.04 (12.05 (20 33881.0 iza 11 14 100% dk.xls [Compatibility Mode] a- Search Sheet Home InsertPage Layout Formulas Data Review View Share v 20 kb Odor CocinD Socien B pe ould far 4.ocn cuatamtne bampxn Tha lelenme sn1ef1s.nanesena ooeumnd hem 5-Jan Purchased 4,1 75 Lamp K S16.75 per ki. g-Jan 4,175 ss Lamp Kis wN wubiioned. 30-Jan Fayolo 0EO Doct Labor Hours510.05 per heur. 30-Jan 3.890 lamps wora complolod ard shippoc. A maa used or sorapood and ano a cost of nomal procossing rocutianed wow 1,123 45 Coof 11.0) Cost of Manacung tcad Coot t cno lamp a 11 100% dk.xls [Compatibility Mode] a- Search Sheet Home InsertPage Layout Formulas Data Review View Share v A1 Standard Job Order Costing- Variance Analysis 15 50 To k cones of the actual oosto, .co. -ob Order Cost 9ysion has oen d.veloped. Etrios 57 ano nade to 0 Jeb Odor 3rsism actual .oworoad is applied basoo on actual labor hours) B whlo entks ak maco io te acoouniing sycton at sandard. Varaazis is usod to anayzo tho T -Jan Pal 030 Doc Lator Hour 9.B por hour. 30Jan Pa of 030 Droct Lator Hourr 510. par hour. 133e 1,123.45 a 11 16 Ready 100% dk.xls [Compatibility Mode] a- Search Sheet Home InsertPage Layout Formulas Data Review View Share v B C How amy Lampo war cempheled? 10 No. 8how favoratzie variances as negative numbers 15.01) 21 What was the mataro sage varono for Lamp Kte? 11 .00) 115.04 47 7 a 11 14 100% .idk.xls [Group] [Compatibility Mode] a- Search Sheet Home InsertPage Layout Formulas Data Review View Share v Capital Decision Making 12 Big Algwos hls oorkor's oro tour l.nch and two fition minus. blaks Non cay. Ho boioves that a 13 ocld soda machino would bo agpdatod by his worors, and an approdaikd woter t a good woker. Wha s the 1702 1783 616 174 (12.05 he tatks (1707 11 12 Ready 98%
