Question: PLEASE SHOW ALL CALCULATIONS. QUESTION IS ON THE LEFT AND PRESENT VALUE TABLES ARE ON THE RIGHT. HELP ASAP Present Value of a Single Amount

PLEASE SHOW ALL CALCULATIONS. QUESTION IS ON THE LEFT AND PRESENT VALUE TABLES ARE ON THE RIGHT. HELP ASAP
Present Value of a Single Amount Nancy Inc. has the following data

Present Value of a Single Amount Nancy Inc. has the following data to prepare budgets for 2023: Budgeted sales units: 1" Qtr 8,000; 2nd Qtr 8,500; Qtr 9,000, 4th Qtr 9,500 Selling price per unit is $35 Desired Ending Finished Goods Inventory: 18% of next Qtr Sales Desired Ending Raw Material Inventory: 23% of next Qtr Production Beginning Inventory Balances for Production and Material follow the same percentage relationships Each unit requires 2 pounds of material, at $5 per pound Each unit requires 1.5 hours of labor, at SIO an hour _s89(J *2103 .75992 _702',0 _ 62460 .6mS7 _'774S 35526 *7464 *2270 '4622 .5AoA2 '0507 48102 43630 ss2 Answer the following questions based on the data above. Each question is worth 10 points: Present Value of an Annuity payment s 1. 2. 3. 4. 5. Compute the Sales Budget for the 4 Quarters, and total for the year Compute the Production Units Required for Qtr 1 and Qtr 2 Compute the total pounds of Direct Material Purchases required for Qtr 1 and Qtr 2 Compute the total cost of Direct Material Purchases required for Qtr 1 and Qtr 2 Compute the total cost of Direct Labor required for Qtr 1 and Qtr 2 1.88609 2.77500 4.45182 924214 67V74 876048 938'07 9.98565 12.16567 1.85941 2.72W, 3.S4svs a. 32948 s. 78637 646321 7.10782 7.72113 8.30641 9.39357 11.27407 12.0892 12.46221 . swo 83962 .79209 ,74726 70496 .66S06 32679 .49697 .46884 .41727 37136 .gsou 1.83339 4.21236 4.91732 5.58238 6.20979 680169 9.71225 10.47726 11.15812 .87344 .66634 .6227' .50835 -47509 .33873 .31657 .29S86 I.S0802 2.62432 3.38721 4.76654 5.302" 6.51523 7.49867 7.94269 765 0.10791 9.4460' 9.76322 .u2suA .85734 005 A .00'7 .54027 46319 .36770 .34046 *1524 .29189 .27027 .2S02S ,92S9s 1.78326 3.31213 3.W271 4.62288 s. 20637 74864 6.24689 7.1306 8.24424 9.1216' 189 91743 7721S 7084 g .94703 .2S187 .23107 , 19449 1.75911 2.0180 3.23972 3.88965 4.48592 s 03295 5.99525 6.80519 7.16073 748600 s 06069 8.95012 g. 12855 _75132 .6*un .62002 , 56447 .35049 _31S63 .21763 7986 1.735u 2, 48ss Y. 70079 4.35526 4.86842 6.49506 7.60608 1.82871 802155 8.51356 .81 162 33119 .6S87A .48166 *5218 031728 .18829 .16963 .1S2s2 L'.oogo 1.71252 244371 3.10245 3.69590 423054 4.71220 s.14612 5 s A70s 6.20652 6.74987 7.19087 7.54870 7.70162 783929 .89286 .79719 .71178 .4'23S .22917 .20462 .18270 .14564 .1.u4 -89286 1.6900' 2.40188 3.0373' 3. e0478 4.11141 4.56376 5.2825 Y. 65022 5.93770 642355 6.62817 7.24967 7.36578 * 6487 .7%14 _657S2 57175 .02 n .32,go .28426 24719 .12289 .10687 _09293 .07027 .8tM,7 1.62571 22028 2*S49S 3.7s448 4.16042 448732 4.771 5.23371 9.72448 604716 6.12797

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Finance Questions!