Free Essay

Hsm/260 Week 5 Checkpoint

In:

Submitted By MelissaManning
Words 376
Pages 2
Exercise 9.1

The following data represent total personnel expenses for the Palmdale Human Service Agency for past four fiscal years:

20X1 $5,250,000
20X2 $5,500,000
20X3 $6,000,000
20X4 $6,750,000 Moving Averages
20X2-X4 $18,250,000 / 3 = $6,083,333

Weighted Moving Averages
Fiscal Year Expenses Weight Weighted Score
20X2 $5,500,000 1 $5,500,000
20X3 $6,000,000 2 $12,000,000
20X4 $6,750,000 3 $20,250,000 __ ___________ 6 $37,750,000
20X5 $37,750,000 /6 = $6,291,667

Exponential Smoothing
NF = $6,300,000 + 0.95($6,750,000 - $6,300,000) = $6,300,000 + 0.95(45,000) = $6,300,000 + (42,750) = $6,342,750

I would rather use moving averages, weighted moving averages, or exponential smoothing because I can better understand how the formulas and numbers turn out and how you get the answers from them. Even though the Time regression is supposed to be easier you are still putting a lot of faith in a computer. Plus I really had a hard time understanding it.

Exercise 9.3

The following data represent total revenues (from all sources) for the Palmdale Human Service Agency for the past four fiscal years:

20X1 $15,000,000
20X2 $14,250,000
20X3 $14,000,000
20X4 $13,500,000

Moving Averages
20X2-X4 $41,750,000 / 3 = $13,916,667

Weighted Moving Averages
Fiscal Year Expenses Weight Weighted Score
20X2 $14,250,000 1 $14,250,000
20X3 $14,000,000 2 $28,000,000
20X4 $13,500,000 3 $40,500,000 __ ___________ 6 $82,750,000 20X5 $82,750,000/6 = $13,791,667 Exponential Smoothing
NF = $13,000,000 + 0.95($13,500,000 - $13,000,000) = $13,000,000 + 0.95(500,000) = $13,000,000 + (475,000) = $13,475,000 I would rather use moving averages, weighted moving averages, or exponential smoothing because I can better understand how the formulas and numbers turn out and how you get the answers from them. Even though the Time regression is supposed to be easier you are still putting a lot of faith in a computer. Plus I really had a hard time understanding it.

Similar Documents

Premium Essay

Hsm260Edu the Power of Possibility/Hsm260Edudotcom

...HSM 260 Entire Course FOR MORE CLASSES VISIT www.hsm260edu.com HSM 260 Week 1 CheckPoint Definition Scavenger Hunt HSM 260 Week 1 DQ 1 and DQ 2 HSM 260 Week 2 CheckPoint Accrual Method HSM 260 Week 2 Assignment Personal Balance Statement (Appendix C) HSM 260 Week 3 CheckPoint Cost Per Output Cost Per Outcome Response HSM 260 Week 3 DQ1 and DQ2 HSM 260 Week 4 CheckPoint Financial Ratios HSM 260 Week 4 Assignment Fixed Costs, Variable Costs, and Break HSM 260 Week 5 CheckPoint Forecasting HSM 260 Week 5 DQ1 and DQ2 HSM 260 Week 6 Assignment Fee Setting HSM 260 Week 6 CheckPoint Calculating Fixed Costs, Variable Cost HSM 260 Week 7 CheckPointCatalog of Federal Domestic Assistance HSM 260 Week 7 DQ1 and DQ2 HSM 260 Week 8 Assignment Foundations Paper HSM 260 Week 8 CheckPoint Collaborative Fund-raising Activity HSM 260 Week 9 Capstone DQ HSM 260 Week 9 Final Analyzing Financial Statements ………………………………………………………………. HSM 260 Week 1 CheckPoint Definition Scavenger Hunt FOR MORE CLASSES VISIT www.hsm260edu.com Define each of the following basic accounting terms in your own words by finding sources on the Internet. Provide the URL that supports the definition you have created for each item. GAAP Basic accounting formula Transaction, t-account General ledger Debit Credit Account balance Trial balance Journal Assets Liabilities Net assets Accounts receivable Accounts payable Revenues Post your definitions as a Microsoft® Word attachment...

Words: 667 - Pages: 3

Premium Essay

Freedom

...HSM 260 Course Calendar |Monday |Tuesday |Wednesday |Thursday |Friday |Saturday |Sunday | |Week 1 |Day 1 |Day 2 |Day 3 |Day 4 |Day 5 |Day 6 |Day 7 | |HSM 260 |Post Bio 12/02 |DQ 1 12/03 | |DQ 2 12/05 |Definition Scavenger Hunt Check Point 12/06 | | | |Week 2 |Day 1 |Day 2 |Day 3 |Day 4 |Day 5 |Day 6 |Day 7 | |HSM 260 | | | |Accrual Method CheckPoint 12/12 | | |Personal Balance Statement 12/15 | |Week 3 |Day 1 |Day 2 |Day 3 |Day 4 |Day 5 |Day 6 |Day 7 | |HSM 260 | |DQ 1 12/17 | |DQ 2 12/19 |Cost Per Output/Cost Per Outcome Response CheckPoint 12/20 | | | |Week 4 |Day 1 |Day 2 |Day 3 |Day 4 |Day 5 |Day 6 |Day 7 | |HSM 260 | | | |Financial Ratios CheckPoint 01/09 | | |Fixed Costs, Variable Costs, and Break-Even Point 01/12 | |Week 5 |Day 1 |Day 2 |Day 3 |Day 4 |Day 5 |Day 6 |Day 7 | |HSM 260 | |DQ 1 01/14 | |DQ 2 01/16 |Forecasting CheckPoint 01/17 | | | |Week 6 |Day 1 |Day 2 |Day 3 |Day 4 |Day 5 |Day 6 |Day 7 | |HSM 260 | | | |Calculating Fixed Costs, Variable Costs, and Break-Even Point for a Program CheckPoint 01/23 | | |Fee Setting 01/26 | |Week 7 |Day 1 |Day 2 |Day 3 |Day 4 |Day 5 |Day 6 |Day 7 | |HSM 260 | |DQ 1 01/28 | |DQ 2 01/30 |Catalog of Federal Domestic Assistance CheckPoint 01/31 | | | |Week 8 |Day 1 |Day 2 |Day 3 |Day 4 |Day 5 |Day 6 |Day 7 | |HSM 260 | | | |Collaborative Fund-raising Activity CheckPoint 02/05 | | |Foundations Paper 02/09 | |Week 9 |Day 1 |Day 2 |Day 3 |Day 4 |Day 5 |Day 6 |Day 7 | |HSM 260 | | |Capstone Discussion Question ...

Words: 322 - Pages: 2

Free Essay

Forecasting

...Forecasting HSM/260 University of Phoenix 06/20/2013 Exercise 9.1 The following data represent total personnel expenses for the Palmdale Human Service Agency for past four fiscal years: 20X1 $5,250,000 20X2 $5,500,000 20X3 $6,000,000 20X4 $6,750,000 Forecast personnel expenses for fiscal year 20X5 using moving averages, weighted moving averages, exponential smoothing, and time series regression. For moving averages and weighted moving averages, use only the data for the past three fiscal years. For weighted moving averages, assign a value of 1 to the data for 20X2, a value of 2 to the data for 20X3, and a value of 3 to the data for 20X4. For exponential smoothing, assume that the last forecast for fiscal year 20X4 was $6,300,000. You decide on the alpha to be used for exponential smoothing. For time series regression, use the data for all four fiscal years. Which forecast will you use? Why Moving Averages Fiscal Year Expenses 20X2 $ 5,500,000 20X3 6,000,000 20X4 6,750,000 20X2-X4 6,083,333 20X5 6,083,333 = $2,277,776 3 I followed Rule 3. Older data are less important than more recent data. I decided to only go back three years so I added...

Words: 707 - Pages: 3

Premium Essay

Hsm 260

...|[pic] |SYLLABUS | | |Axia College/College of Social Sciences | | |HSM/260 Version 3 | | |Financial Management for Human | | |Service Managers | Copyright © 2009, 2007 by University of Phoenix. All rights reserved. Course Description This course focuses on conceptual understanding and practice of financial management as it applies to human service agencies. Students complete the course with a better understanding of basic accounting concepts, budgets and budgeting systems, how to create performance measures, and the ability to analyze financial statements for the purpose of cost analysis and forecasting. Aspects of setting fees, funding, and risk management are also covered. Policies Faculty and students/learners will be held responsible for understanding and adhering to all policies contained within the following two documents: • University policies: You must...

Words: 1882 - Pages: 8

Premium Essay

Hsm 260

...|[pic] |Course Syllabus | | |Axia College/College of Social Sciences | | |HSM/260 Version 3 | | |Financial Management for Human | | |Service Managers | Copyright © 2009, 2007 by University of Phoenix. All rights reserved. Course Description This course focuses on conceptual understanding and practice of financial management as it applies to human service agencies. Students complete the course with a better understanding of basic accounting concepts, budgets and budgeting systems, how to create performance measures, and the ability to analyze financial statements for the purpose of cost analysis and forecasting. Aspects of setting fees, funding, and risk management are also covered. Policies Faculty and students/learners will be held responsible for understanding and adhering to all policies contained within the following two documents: • University policies: You must...

Words: 1862 - Pages: 8

Free Essay

Definition Scavenger Hunt

...Nicole L. Lee HSM/260 September 20, 2013 Arin Norris Checkpoint: Definition Scavenger Hunt GAAP- Generally accepted accounting principles- refer to the standard framework of guidelines for financial accounting used in any giving jurisdiction. 2. generally known as accounting standards or standard accounting practice. (Wikipedia) Basic - forming or relating to the most important part of something. 2. forming or relating to the first or easiest part of something not including anything extra (Merriam-Webster.com/dictionary) accounting - the skill, system, or job of keeping the financial records of a business or person (Merriam-Webster.com/dictionary) formula - a plan or method for doing, making, or achieving something. 2. a list of the ingredients used for making something 3. mathematics: a general fact or rule expressed in letters and symbols (Merriam-Webste.com/dictionary) Transaction - The act of transaction or the fact of being transacted. 2. Something transacted, especially a business agreement or exchange. 3. Communication involving two or more people that affects all those involved. (www.thefreedictionary.com) account - A narrative or record of events. 2. a reason given for a particular action or event. 3. a formal banking, brokerage, or business relationship established to provide dealings, and other financial transactions. 4. Worth, standing, or importance. 5. profit or advantage. (www.thefreedictionary.com) General - involving, applicable to...

Words: 758 - Pages: 4

Premium Essay

Monicah

...Windows Server® 2008 FOR DUMmIES ‰ by Ed Tittel and Justin Korelc Windows Server® 2008 For Dummies® Published by Wiley Publishing, Inc. 111 River Street Hoboken, NJ 07030-5774 www.wiley.com Copyright © 2008 by Wiley Publishing, Inc., Indianapolis, Indiana Published by Wiley Publishing, Inc., Indianapolis, Indiana Published simultaneously in Canada No part of this publication may be reproduced, stored in a retrieval system or transmitted in any form or by any means, electronic, mechanical, photocopying, recording, scanning or otherwise, except as permitted under Sections 107 or 108 of the 1976 United States Copyright Act, without either the prior written permission of the Publisher, or authorization through payment of the appropriate per-copy fee to the Copyright Clearance Center, 222 Rosewood Drive, Danvers, MA 01923, (978) 750-8400, fax (978) 646-8600. Requests to the Publisher for permission should be addressed to the Legal Department, Wiley Publishing, Inc., 10475 Crosspoint Blvd., Indianapolis, IN 46256, (317) 572-3447, fax (317) 572-4355, or online at http:// www.wiley.com/go/permissions. Trademarks: Wiley, the Wiley Publishing logo, For Dummies, the Dummies Man logo, A Reference for the Rest of Us!, The Dummies Way, Dummies Daily, The Fun and Easy Way, Dummies.com, and related trade dress are trademarks or registered trademarks of John Wiley & Sons, Inc. and/or its affiliates in the United States and other countries, and may not be used without written permission...

Words: 139691 - Pages: 559

Premium Essay

Server 2008 for Dummies

...Windows Server® 2008 FOR DUMmIES ‰ by Ed Tittel and Justin Korelc Windows Server® 2008 For Dummies® Published by Wiley Publishing, Inc. 111 River Street Hoboken, NJ 07030-5774 www.wiley.com Copyright © 2008 by Wiley Publishing, Inc., Indianapolis, Indiana Published by Wiley Publishing, Inc., Indianapolis, Indiana Published simultaneously in Canada No part of this publication may be reproduced, stored in a retrieval system or transmitted in any form or by any means, electronic, mechanical, photocopying, recording, scanning or otherwise, except as permitted under Sections 107 or 108 of the 1976 United States Copyright Act, without either the prior written permission of the Publisher, or authorization through payment of the appropriate per-copy fee to the Copyright Clearance Center, 222 Rosewood Drive, Danvers, MA 01923, (978) 750-8400, fax (978) 646-8600. Requests to the Publisher for permission should be addressed to the Legal Department, Wiley Publishing, Inc., 10475 Crosspoint Blvd., Indianapolis, IN 46256, (317) 572-3447, fax (317) 572-4355, or online at http:// www.wiley.com/go/permissions. Trademarks: Wiley, the Wiley Publishing logo, For Dummies, the Dummies Man logo, A Reference for the Rest of Us!, The Dummies Way, Dummies Daily, The Fun and Easy Way, Dummies.com, and related trade dress are trademarks or registered trademarks of John Wiley & Sons, Inc. and/or its affiliates in the United States and other countries, and may not be used without written permission...

Words: 139691 - Pages: 559