Need a little help with a few parts of this project. I will provide other photos of previous parts if needed. if the work could be shown that would be great but not neccessary.
Page 2 I See The Light Projected Income Statement For the Period Ending December 31, 20x1 $45.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 Fored Variable (Commission per unit) Administrative Expenses Fixed Variable @ Total Selling and Administrative Expenses Net Profit $3.00 $ 98,000.00 $ 23,000.00 75,000.00 $42.000.00 50.000,00 $2.00 92.000.00 3 190,000.00 135.000.00 I 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 8,000.00 500 @ 3000 @ $16.00 $30.00 $ 90.000.00 200.210.00 $ 20,000.00 6,800.00 Foxed Assets Equipment Accumulated Depreciation Total Fixed Assets Total Assets 13.200.00 $ 213.410.00 $ $ 54,000.00 54,000.00 Current Liabilities Accounts Payable Total Liabilities Stockholder's Equity Common Stock Retained Eamings Total Stockholder's Equity Total Liabilities and Stockholder's Equity $ 12,000.00 147.410.00 $ 159.410.00 213.410.00 Page 13 PART 5 Job Order Costing To keep records of the actual cost of a special order job, a Job Order Cost System has been developed. Overhead is applied at the rate of 50% of the direct labor cost Job Order Costing Section On January 1, 20x2Divisions began Job 2407 for the Client THE BIG CHILDREN STORE. The job called for 4,000 customized lamps. The following set of transactions occurred from January 5 until the job was completed 5-Jan Purchased 4,025 Lamp Kits $16.60 per kit 9-Jan 4, 125 sets of Lamp Kits were requisitioned. 17-Jan Payroll of 600 Direct Labor Hours $9.85 per hour 30-Jan Payroll of 650 Direct Labor Hou's $10.10 per hour. 30 Jan 3.000 lamps were completed and shipped. All materials requisitioned were used or scrapped, and are a cost of normal processing Month End Overhead information Actual Variable Manufacturing Overhead Actual Fixed Manufacturing Overhead $ 1.575 00 $ 40,373.45 Round to be places Cost of Direct Material incurred in Manufacturing Job 2407 (13.01) Cost of Direct Labor incurred in Manufacturing Job 2407 (13.02) Cost of Manufacturing Overhead Applied to Job 2407 (13.03) Cost of manufacturing one lamp - (13.04) Page 14 PART 6 Standard Job Order Costing - Variance Analysis Special order lamps are manufactured in division S. Because of the precise nature of the process a standard cost system has been developed. The following standards are used for the special orders Standards Lamp Kits Direct Labor Variable Overhead - Foed Overhead Total $16000000 per lamp 2400000 per lamp (4 lampshe.) 0.250000 per lamp (4 lampsh.) 10000000 per lamp $26.650000 *Fored overhead is based on expected production of 4,007 customized lamps each month To keep records of the actual cost of a job, a Job Order Cost System has been developed. Entries are made to the Job Order System at actual cost overhead is applied based on actual labor hours) while entries are made to the accounting system at standard. Variance analysis is used to analyze the differences Job Order Costing Section On January 1, 20x2. Division S began Job 1101 for the Cient, THE BIG CHILDREN STORE. The jab called for 4,000 customized lamps. The following set of transactions occurred from January 5 until the job was completed: 5-Jan Purchased 4,025 Lamp Kits @ $16.60 per kit 9-Jan 4, 125 sets of Lamp Kits were requisitioned. 17 Jan Payroll of 600 Direct Labor Hours $9.85 per hour 30-Jan Payroll of 650 Direct Labor Hours $10.10 per hour 30 Jan 3,993 lamps were completed and shipped. All materials requisitioned were used or scrapped Month End Owerhead Information Actual Variable Overhead Actual Fixed Overhead $ 1,575.00 $ 40,373.45 Page 15 Rodriguez How many Lamps were completed? Note: Show favorable variances as negative numbers What was the total material price variance for the Lamp Kits purchased [15.011 What was the material usage variance for Lamp ? (15.02) What was the direct labor efficiency variance ? (1503) What was the direct laborate variance? (1504) Page 16 Note: Show favorable variances as negative numbers What was the variable overhead efficiency variance? (1601) What was the variable OH spending variance? 1602) (1603) What is the forced OH volume (denominator) varian (16.04) What is the fixed OH spending variance? Capital Decision Making w as one hour handsfree minute breaks each day. He believes that machine would be preced by his workers, and an apprec i so machine stational member only warehouse for $2.150. The machine should be years, wer which would be inefficient and would have to be dispose of the A beves that cars a day will be purchased the plant is open five days a week, so per year. A case of soda (24 ans 5 and Big Abelieves that presos per can would win him good will What is the estimated s ales incansa soda What is the contribution marginer can of d rounded to places 117023 How many cans of soda must be sold each year to breakeven? (Round up to Annual incremental cash innows from the soda machine? rounded to two places, (1704) What is the payback period in year rounded to two places (17.05 If the time value of money is 12% per year what is the nat present value? Uve the tables on page 18 (17.06) What is the internal rate of return Pick the closest the tables on page 18 (17.07) Present Value of Annuly 1100 in Area EBBASS 0 1637 GEEN EEN slalelelalelelelalele 88 88 EKSASSARIENSE 99191919122 alle 1500 1517579 3070 3.037 3.000 SE3323958868528 2974 S SSSSEINI8181818 1450 1.513 680 6555111 11701 S 2609 Ba 0% 68.5% 69.0% 2322 29141 230228543392 2283 2 85613362 15531 22427320313 16.03 22402798 3274 16.5% 2220 2770 3236 3636 17 0% 221027231 3.199 2.192 2716 3163 18.09 2172 2690 3127 18.555 2.157 27664 3092 19.0% 2.140 3058 19.5% 2.123 2613 3.024 20.0% 2 1032589 2.991 3326 20.5% 27000 2504 2.958 3285 21.0% 27072 2540 2926 3245 21.5% 2058 2517 2 895 3 206 220% 2042 2.4942 864 3.167 22.5% 2.0272 471 2.833 3.129 23 0% 2011 2.448 2 803 3092 235% 199022426277431056 24 0% 1.981240427453020 24 5% 10072383 2717 2986 25.0% 1.952 2.362 2.689 2951 25.5% 1038 2 341 2 662 2.918 26 0% 1.923 2.320 2635 2 885 26.5% 1.909 230026092853 27.0% 1.896 2280 2.583 2.821 27.5% 1.882 2.260 2 557 2.790 28.0% 1.868 2241 2.532 2.759 28.5% 1.8552 222 2507 2.729 29.0% 1.842 2203 2483 2.700 70.0% 70 5% 71.0% 71,5% 72.096 1.331 1.413 1.482 1.32314041452 1.1641.3161.395 1445 1.308 1121301 13731424 1.100 1.73 12.09 141 1.760 1286 1.381 1.166 1279 1.352 13 1.149 1.272 1344 1307 1.143 1.285 1335 1378 1.130 125013281369 1.132 1251 1320 1.361 1.127 1244 13121352 1.121 1237 1.304 1344 1.116 1230 1297 1335 15111172412891327 1.105 121712811319 1.100 1210 1 274 1311 1095 12041267 1303 1.090 1.198 1.259 1295 1085 1.19112521287 1.079 1.185 1245 1279 1.074 1.179 1.238 1 272 1.069 1.172 1 .231 1.264 1084 1.166 1224 1256 1.060 1.160 1 217 1249 725% 73.0% 73.5% 740% 74.5% 75 0% 75.5% 76.0% 76.5% 77.0% 77.5% Present Value of Annuity 51 00 in Arres R 1779 aglalalalala 1.719 TITILLITIH 707 1606 1 103 114013 1092 108751541160 108111201153 23688888888888888 10021 8888888 LLLLLJUN TITILLLLLLLLL 1620 1601 1877 2018 38.6% 37.5% 2.124 1630 1.906 2.105 38.5% 1892 2088 390W 1800 2.070 39693 1699 1.863 2052 400W 1569 1649 4052 1679 1636 410X15001822 2001 41.5X1.560 1809 1.985 420* 1.549 1796 1 000 425% 1540 1782 1.9531 43 0% 1.530 435% 1,621 1757 1.921 440 1.512 1.744 1.906 44 5% 1.502 1.7321890 450 1.493 1720 1.876 45.6% 1.484 1.707 1881 46.04 1475 1695 1846 46.5% 1.467 1.684 1.832 47.0% 1.458 1672 1.818 475% 1449 1680 1804 48.0% 1.441 1.649 1.790 48 5% 1432 1638 1.776 49.0% 1.4241.627 1.763 49L141616181.750 50.0% 1.407 1.605 1.737 2091 2072 2.036 2.018 2.000 1903 1966 1.110 1141 1000 11061129 1055 1099 1123 1.117 1045 TOBB 81 1040 1082105 89.0% 01967 1036 107 1090 89 5 0963 1.03 10721093 900 0.9491025 1.0551087 9050945102110311082 91 0% 0.041 1016 1 056 1076 91.5% 0.937 1012 1060 1071 92.0% 0.933 1007 1045 1065 925% 0.9301.002 1.040 1000 93.0% 092619981035 1054 0.922 993 1030 1049 94.0% 0.918 0.989 1.025 1044 0.914 9841020 1039 96.0% 0 911 98010151033 95.57 0.907 0.975 1.010 1.028 96.0% 1030.97110001023 96.5% 0.900 0.9671.0011018 97 0908960 962 0.996 1013 97.5% 0.893 0.95 0.992 1.000 98.0% 0.889 0.95409871003 98.5% 0.885 0 9500 982 0.999 99.0% 0.882 0.9480 9780 994 99,5% 0.878 0.9420.973 0989 100.0% 0.875 0.938 0.969 0984 93.58 1.949 1933 1.917 1901 1.885 1870 1.854 1.839 1.824 If off the chart use 100%