Popular in Course
verified elite notetaker
Popular in Environment
verified elite notetaker
This 0 page Study Guide was uploaded by Carlee McCullough on Sunday November 1, 2015. The Study Guide belongs to SPEA at Indiana University taught by Roger Morris in Fall. Since its upload, it has received 35 views. For similar materials see /class/233404/spea-indiana-university in Environment at Indiana University.
Reviews for V 261
Report this Material
What is Karma?
Karma is the currency of StudySoup.
You can buy or earn more Karma at anytime and redeem it for class notes, study guides, flashcards, and more!
Date Created: 11/01/15
V26llnClass Practice Complete as many problems as you can in class CV 6139 Not Graded A company has expenses of 3000 in December that change each month according to the following table Calculate the expenses for each month based on the percentage change provided from the previous month DEC JAN FEB MAR 3000 3 11 9 312121 What is the AVERAGE monthly expense for the 3month period above 321370 You wish to purchase a car whose sticker price is 24000 The dealer paid 91 of the sticker price How much did the dealer pay for the car 21840 What percent is 873 of 1325 659 What percent is 1325 of 873 15178 A homebuilder wants to make 15 on his investment in new home construction If his costs were 187000 to build the house how much would he have to sell it for to make 15 21505000 If you filled the range A1J21 with the value 299 What is the total of the values in this range 62790 Place the value 1 in cell A1 Using the filldown feature construct a formula that will fill the range A1A100 with the values from 1 to 100 What is the total of the values in the range A1A100 5050 You purchase a car for 10000 and pay it off in two years You finance the car loan at 95 APR What are your monthly payments 45554 H 0 You buy a house for 125000 at an APR of 875 and obtain a 30year loan What are your monthly payments 97626 H H A company had the following budget for 2006 Labor 250000000 Materials 219 180000000 Plant amp Equip 120000000 a Their 2007 budget increased by 8 Labor increased by 12 and materials increased by 5 How much is the Year 2007 company budget 594 Million b How much is the budget for Plant amp Equipment in year 2007 125 Million H N You are considering purchasing one of two homes You have saved 39 25000 as a down payment and been preapproved for a 30year loan at 85 One house lists for 150000 and the other one for 160000 Over the life of the 30year loan how much M will you pay for the more expensive house 2748619 H 9 Your company projects annual revenues of 196000 The company projects expenses as follows Cost of goods 104000 Maintenance 25000 Payroll 50000 Other 219 1000 What is the projected net income 39 16000 37 ST What is the profit margin for the projections in question 13 816 Net lnc divided by sales revenues If you wanted to achieve a pro t margin of 11 by adjusting the payroll gure what is the amount for payroll that would yield an 11 pro t margin 0 44500 at 1097 profit margin Excel may not find an exact solution 14 In a health and fitness experiment you time runners ofvarious ages as follows in the 1000M run Age 20 22 24 26 28 30 32 34 Timesec 296 300 305 304 307 316 319 326 a What is the R2 for this data set 0944 b How many seconds would a 29 year old take to complete the run 313 Problem 1 Your company projects sales next year of 985000 Your only expenses are Labor and Materials Materials are calculated to be 480000 and Labor is assumed to be also 480000 What actual amount for labor will yield a pro t margin of exactly 5 455750 Problem 2 You buy 100 shares of stock for 3500 per share on Jan 151 The stock performs as follows over the year 1st Qtr 239ml Qtr 3d Qtr 4 h Qtr Up 10 Down2 Down7 Up4 You sell the stock on Dec 3151 What was the dollar amount of gain or loss 14925 Problem 3 Your federal agency has an annual budget of 150000000 87000000 goes for salaries and the rest is spent on housing programs Congress raises all federal salaries by 325 but your agency budget is cut by 5 for next year How much money will be available next year for housing programs 52 67 2500 Problem 4 You wish to buy a car for 21000 Your trade in is worth 5000 and there is a 1000 rebate You borrow the balance at 49 APR for 36 months What is your monthly payment 44706 a Problem 1 Projected Sales Labor Materials Total expenses ProfitNet income Profit margin b Problem 2 Quarter 1 Quarter 2 Quarter 3 Quarter 4 Difference Problem 3 Total Budget Salaries Housing Programs Next Year39s Budget Adjusted salaries Adjusted Housing Problem 4 Car value Trade in Rebate Present Value Interest Rate Months Monthly Payment 010301030103 03030303 V r 03030303 985000 455750 480000 480000 935750 49250 5 Fluctuation 350000 385000 11 377330 098 350889 093 364925 104 14925 Adjustments 150000000 10325 87000000 095 63000000 142500000 89827500 52672500 21000 5000 1000 15000 49 36 44706
Are you sure you want to buy this material for
You're already Subscribed!
Looks like you've already subscribed to StudySoup, you won't need to purchase another subscription to get this material. To access this material simply click 'View Full Document'