Complete the Budget in a Service Company (Cash Budget) assignment. Please use the template provided below.
The document must have the complete budget and show the entire process along with an explanation.
Add a brief explanation of the budget just like what you should do if you were in a meeting with senior management and you were the accountant who was tasked with presenting the budget. Put that explanation on the page below the budget that you have prepared.
Hint: The budget should start with the January beginning balance and the February ending balance should also be the ending balance for the two months combined column.
Assigned Questions to Address in Your Initial Post: (American Government)
Are you in favor of reducing expenditures in the federal budget in any of the main spending categories identified above such as Social Security, Medicare, Medicaid, Defense, etc.? If so, which ones, and explain why you believe spending in those areas should be reduced and whether you believe if doing so will have any adverse effects on Americans.
Are you in favor of raising taxes to help reduce the amount of overspending in the budget? Explain why or why not. If you are in favor of raising taxes, identify who you believe should pay higher taxes: All Americans? Just wealthy Americans? What about corporations? If you believe wealthy Americans should pay more, define wealthy. For example, how much annual family income do you consider to be wealthy?
President Biden and the Democrats recently passed a $740 billion spending bill that will lower prescription drug costs for seniors on Medicare, will lower health insurance costs for people who don’t have access to insurance through their employer or family plans, will invest $300 billion in renewable energy infrastructure such as wind and solar, and provide up to a $7,500 tax credit to Americans for purchases of certain new and used electric vehicles. A tax credit means the amount of income tax you owe the federal government will be reduced by the amount of the tax credit you receive. This spending bill is deficit-neutral, meaning it will not add to the annual budget deficit or national debt. It helps pays for itself by including a provision requiring corporations that make over $1 billion in annual income to pay a minimum 15% income tax. Previously, many rich corporations paid no income tax at all because of special provisions in the tax laws that benefited them. It will also increase enforcement of tax payments owed by Americans with complex tax returns who previously were able to avoid taxes owed because the government did not have the resources to verify the accuracy of their tax returns. Do you tend to agree or disagree with the provisions of this bill? Explain why or why not
Here are some good and varied examples of processes explained. Some are lists/graphics. When you read those, imagine how one might turn the info into paragraph breaks and transitions.
Discussion 4 Topic: Aspects of designing a School Budget
Imagine that you have been asked to be on a panel of school administrators at a national conference. Your panel is presenting information on what you see as “hot topics” regarding the design process and the strategies used to maintain a K–12 school budget.
Use these articles as a starting point for your research:
Ezarik, Melissa. (2019, July 25). 5 strategies for balancing the budget while preserving instruction. DA District Administration. https://districtadministration.com/5-strategies-for-balancing-the-budget-while-preserving-instruction/
Griffith, M. (2005). School finance litigation and beyond [Policy brief]. Education Commission of the States. http://ecs.org/clearinghouse/60/26/6026.pdf
Thro, W. E. (1994, May). Judicial analysis during the third wave of school finance litigation: The Massachusetts decision as model. Boston College Law Review, 35(3).
Zdroik, M. (n.d.). Prepare for budgeting. Skyward. https://www.skyward.com/discover/educator-newsletter-blog/november-2016/prepare-for-budgeting
Feel free to find additional articles in the Library or from the internet that you can use as well. Your task is to use the articles to form an outline of your presentation. The outline should contain your main talking points concerning the design, implementation, and maintenance of a K–12 budget, as well as, a brief summary of each point. Post your response to the Discussion Board.
Discussion 5 Topic: Current Financial Trends in Education
When certain areas are not covered in the budget or when a school budget falls short of funds, a current trend in schools today is having parents purchase school supplies, uniforms, and to pay fees for textbooks, clubs, and athletics. In today’s current educational environment, this is not an ideal situation and this requirement can be difficult for some families. Look into what your local policies are regarding families providing school supplies, textbooks, uniforms, club or athletic fees, or any other parent funded requirement and then answer the following questions:
How does your local school district handle this matter as it relates to fees, supplies, and textbooks for all families? Is there a distinction between socioeconomic classes? Does your local school district make accommodations for families that cannot afford fees and supplies? If so, what are they? Are these accommodations confidential? The Individuals with Disabilities Education Act (IDEA) calls for a free and appropriate education for children with disabilities. Should that apply to school supplies and other school fees? Does your school district offer funding assistance for supplies and activities for students with disabilities? As a lead teacher, what policies and procedures would you implement in your school if you were to look at the current financial trends and wanted to ensure all students had the supplies and material necessary to be successful?
Discussion 6 Topic: Future Trends of a Virtual Learning Environment.
Your current board of education members wish to explore and understand more about virtual education, and the future of education concerning quality, delivery, and financial aspects. Due to the recent virus epidemic, there is the possibility that a virtual learning environment will be the new normal.
Contemplate this scenario: Your district’s school board is struggling with the board of education which has some questions and concerns about implementing and funding virtual education. As with many boards, several members are from the private sector and their knowledge of how learning, especially virtual learning, takes place is limited. The teacher’s union also has issues and questions about the virtual learning environment and how it will be administered. Your PTO (parent/teacher organization) has asked you to present a short discussion on this topic. Your audience will be teachers, community members, the school board, and the superintendent. Consider how you will discuss the issue. Research current and possible future trends regarding virtual education and post to the questions below:
What implications does this learning environment have for the future of education as well as the staff and teachers? What are the implications for student achievement? What would be the possibility of a blended learning environment where both virtual and in-person classes could be held? How does a virtual learning environment impact school finances?
Computer Applications for Business – Assignment MS Excel: Budget Analysis
Apply your creative thinking and problem-solving skills to design and implement a solution.
NOTE: You will need to use file from the textbook for the assignment: Lab 8-3 Budget Analysis
Household Budget Analysis
Income
Jan
Feb
Mar
Apr
May
Jun
Wages
1,430
1,430
1,430
1,430
1,430
1,430
Student Loan
2500
0
0
0
0
800
Savings
800
400
200
375
625
700
Total
4,730
1,830
1,630
1,805
2,055
2,930
Exenses
Rent
850
850
850
850
850
850
Food
425
425
425
425
425
425
Utilities
225
210
175
165
120
135
Phone
75
75
75
75
75
75
Insurance
165
165
165
165
165
165
Tuition
2,200
0
0
0
0
1100
Books
450
0
0
0
0
300
Travel
190
120
150
450
120
180
Clothing
150
100
75
145
60
150
Total
4,730
1,945
1,915
2,275
1,815
3,380
Cash Flow
0
-115
-285
-470
240
-450
Part 1:
The workbook provided shows household income and expenses. You will create charts to help analyze your budget.
1. Open the workbook Lab 8-3 Budget Analysis provided and save as CS155Week8LastnameFirstname. Ensure that you use your lastname and firstname.
2. In the budget analysis file change; wages, food, phone, and clothing data for each month. (Leaving these items the same will result in a deduction)
3. Create a chart using the expenses from the budget.
4. Create a second chart using the cash flow data from the budget.
5. The following areas will be part of grading criteria:
Changes to data asked for in Part 1
Ensure the charts created display months and appropriate items from column A
Create a chart from expenses data
Move expense data chart to own sheet
Rename new sheet with expense chart to descriptive title
Create chart title for expense data chart
Create a chart from cash flow data
Move cash flow chart to own sheet
Rename new sheet with cash flow chart to descriptive titles
Create chart title for cash flow chart
Save the file as CS155Week8LastnameFirstname. Ensure that you use your lastname and firstname
Add a footer in left section of sheet named Budget with your name and GIDnumber
NOTE:Charts not required to be pivot charts Part 2:
In Part 1 you made choices about which type(s) of chart(s) to use to present budget data. What was the rationale behind those selections? How did the data in the Household Expenses pose a special challenge? How might you address that challenge?
Answer Part 2 questions in comments or submission text area when submitting
There are times, as educational leaders, that may seem as if you have no control over the circumstances that you or your teachers may face — for example, poverty. There are situations where students from financially stressed homes may not have the means to participate fully in a school program. On a deeper level, they face struggles and stress that other students may not face. This can impact school performance on many levels.
Directions:
As the readings have made you aware, there are different funding formulas for federal, state, and local education funds. As an educational leader, you will be charged with the task of budget maintenance and requests for many different aspects of your school.
Imagine you are at an administration’s meeting with the District Strategic Planning Team that is responsible for the allocation of personnel and funds to each school in the district. Your school is in a transitional neighborhood in your school district. Your school district is a suburban district usually thought to be home to the upper-middle class. In your school’s geographical location, however, many previously owner-occupied homes are now rentals and two large apartment complexes have become Section 8 and Housing Authority properties. Both Section 8 and Housing Authority housing programs are governmentally funded programs. Your free and reduced lunch has changed from 15% to 70% of your school population in the past year alone. The number of students qualifying for free and reduced lunch is indicative of the change in the socioeconomic status of the neighborhood.
In this meeting with the District Strategic Planning Team, your funding requests are up against other needed requests from other schools in the district. You are competing with other schools for a limited amount of funds. As funds seem to be in short supply and everyone believes they have a strong and valid need, you will want to research and support each point in your request for funds.
In the state where you live, research local, state, and federal funding formulas and explain how your school receives funds each year and create a 10- to 15-slide PowerPoint® presentation, that includes the following:
Introduction slide.
Describe your school to the district officials. Make sure you include the history as well as the characteristics of the local community, the student population, and the staff.
List and explain your budget requests based on the research gained from the funding formulas.
Use information from your reading — both textbook resources and outside research —to justify and support your request for equitable and adequate funding (remember to use APA citation for your references).
Explain how your budget is affected by local, state, and federal guidelines.
After you have completed the readings, and before reviewing your classmates’ responses, add your initial post that fully answers the Discussion Board topics(s). Your initial post should be supported by your course materials and/or other appropriate resources. This initial post and your additional responses to classmates should occur over multiple days throughout the unit week. Refer to your discussion rubric for specific grading criteria.
Topic: Comparing tools used to the administering of a K-12 school budget.
This Discussion Board focuses on tools and techniques used in administering a K–12 budget. As a grade level leader, you will have to have a working knowledge of the tools used to make sure that your budget is adequately funded in all areas. Use these websites as you compare the tools used by two different systems.
The first site is:
Washington Office of Superintendent of Public Instruction. (n.d.). Special education funding in Washington state.
Missouri Department of Elementary and Secondary Education. (n.d.). School finance tools. https://dese.mo.gov/financial-admin-services/school-finance/calculation-tools
Upon review of these two websites, pick one similar tool from each site, as well as one tool that is relevant only to that particular state, and answer the questions below:
What elements were common between the two similar tools? Did you notice any differences in the tools that were only relevant to that particular state? Were there any unique tools from the two sites that stood out to you and why? What were the tools used in both states that you would feel comfortable using today if you were in charge of that budget?
Discussion 2
After you have completed the readings, and before reviewing your classmates’ responses, add your initial post that fully answers the Discussion Board topics(s). Your initial post should be supported by your course materials and/or other appropriate resources. This initial post and your additional responses to classmates should occur over multiple days throughout the unit week. Refer to your discussion rubric for specific grading criteria.
Topic: Pay-for-Performance
You are a lead teacher of a high school that just received an award for being a top distinguished school from your state. Several teachers approach you about the possibility of getting a pay increase for all of their hard work. You tell the teachers that you will certainly see what you can do, but you know the budget is set for the upcoming year. The next day, you receive a call from a school board member that wants you to explore and give them a better understanding of performance pay in schools, with the intent of moving forward with a plan for performance/merit pay.
You know as an educational leader that this topic is one that certainly needs further review. Your school board is struggling with the pay-for-performance issue. As with many boards, several members are from the private sector where pay is usually tied to performance. The teacher’s union also questions the move based on concerns about how pay levels will be determined. You have been chosen to give a short presentation on the topic. Your audience will be teachers, community members, the school board, and the superintendent.
Consider how you will discuss the issue. Research current trends in pay-for-performance, merit pay, and career ladders. As you respond to this discussion, answer the following questions:
What implications do these have for the future of educators? What are the implications for student achievement? What would be the implications for your school’s budget? What are the pros/cons of pay-for-performance?
Discussion 3
After you have completed the readings, and before reviewing your classmates’ responses, add your initial post that fully answers the Discussion Board topics(s). Your initial post should be supported by your course materials and/or other appropriate resources. This initial post and your additional responses to classmates should occur over multiple days throughout the unit week. Refer to your discussion rubric for specific grading criteria.
Topic: Understanding School Funding:
There have been several school funding programs over the years that have gained attention in the educational community because of how they succeeded and the difficulties they presented when they were implemented. As an educational leader, you will be expected to have a firm understanding of these programs and how they can have a positive impact on your school budget that you wish to implement.
There will be those in your community who come to you with questions about the school budget and to have a better understanding of where the funding comes from. How will you explain these programs and funding formulas to someone who is not familiar with the budgeting process?
For this discussion, suppose you are a lead teacher of a public school and you have the task of writing an article on school budgets for your local newspaper. This will provide you a forum to get the correct information out to the public and hopefully end any misinformation.
After reading the articles linked below, post a 300- to 500-word opinion piece that explains the initial intent of the documents, your role in promoting the success of a school’s budget, and the state and federal functions you must address in your budget. Support your thoughts with references and citations.
U.S. Department of Education. (n.d.). Every Student Succeeds Act (ESSA). https://www.ed.gov/essa?src=rn
U.S. Department of Education. (2019). Fiscal year 2019 summary and background information.
U.S. Department of Education. (2017). Education budget prioritizes students, empowers parents, saves taxpayer dollars. https://www.ed.gov/news/press-releases/education-budget-prioritizes-students-empowers-parents-saves-taxpayer-dollars
Create an actionable plan including executive level support and budget allocation to ensure security controls can be rapidly updated and expanded as the threat environment increases.
The actionable plan should include (but is not limited to):
Procedures to track performance
Procedures to monitor and measure performance for areas of improvement
Procedures to identify new threats, vulnerabilities, or any countermeasures
Procedures to obtain feedback on the effectiveness of policies
Procedures and technical tools to monitor the internal and external environment
Procedures for budget allocation
Procedures to catch any oversights
APA style is not required, but solid academic writing is expected.
Refer to “CYB-690 Cybersecurity Program Maintenance Scoring Guide,” prior to beginning the assignment to become familiar with the expectations for successful completion.
You are not required to submit this assignment to LopesWrite.
On successful completion of this assessment, students should be able to:
develop a budget for a business idea presented in unit 4, projecting costs associated with the venture,
analyze the funding need and provide breakdown of appropriate cost centers, and
identify the profit or loss for the venture in year one and show when the business will be profitable.
Brief Description
The assignment requires the completion of a budget to project costs associated with the new venture and will be used as a guide in terms of how much funding is needed to launch the business. The budget statement should reference the business opportunity submitted in unit 4. The budget statement will be augmented with notes to explain the choices and projections.
Submission Instructions
Write a paper including the budget for your idea from unit 4. Each paper should include an introduction and conclusion, should be 4-6 pages (double spaced), 2.54 cm margins (the default on MS Word), and 12 pts size . The paper should include notes to accompany and explain the budget decisions and budget lines. The paper should follow the APA guidelines for format and citation. In your assignment you should:
Identify the problem the venture will address and its scope.
Support claims about the problem with appropriate sources, including at least three academic sources such as books, juried articles found in the YU library.
Demonstrate the validity of the idea and identify what makes this a true opportunity.
Unit 4 means the file which is attached to this question. Please must review it
For this assignment, you will apply what you have learned in this unit to a small business. To get the business’s finances under control, you need to prepare a budget. You may consider items from your personal finances and cash flow to help you identify possible expense items for the small business budget. Research the CSU Online Library or the Internet for steps to creating a personal budget. Monthly expenses might include rent, utility costs, personal loans, car loans, credit cards, groceries, childcare, vehicle maintenance costs and insurance, phone charges, and cable or streaming costs. Cash flow considerations might include monthly salaries, commissions, and allowances. You can use any budget format that you are comfortable with, or you may select a free template. Your budget should be completed using Excel. Once you have completed your budget, in a separate Word document, address the information below. How can the use of the budget be used in the planning process? How can this financial information influence short-term and long-term decisions? Based on your personal budget, what are your static expenses? What are your flexible expenses? As an accountant, reflect on how you can use what you have learned in this activity in the workplace. Your submission should include one Excel document, which contains your budget, and a one-page Word document, which contains your responses to the prompts above. You should include at least two resources to support your responses. Adhere to APA Style when creating citations and references for this assignment.
