Budget Preparation | AustraliaEssayWriters

Prepare a cash budget (4-5 pages) for a manufacturing company and a memo to new management (2-3 pages) that explains the purpose of a cash budget and its relationship to operational goals.

Introduction
This assessment will give you the opportunity to construct a complete budget for the manufacturing operations of a fictional company called the Spicer Corporation. In doing so, you will practice analyzing budget practices and techniques.

Demonstration of Proficiency
By successfully completing this assessment, you will demonstrate your proficiency in the following course competencies through corresponding scoring guide criteria:

Competency 2: Analyze budgeting practices in organizations.
Explain how the component budgets function within the complete annual budget.
Competency 3: Apply appropriate budgeting techniques for planning, executing, and controlling.
Create a complete annual budget.
Competency 4: Apply quantitative models to create and manage budgets and forecasts and evaluate budget performance.
Create the sales budget.
Create the purchasing budget.
Create the payments budget.
Create the cash receipts budget.
Competency 5: Communicate in a manner that is professional and consistent with expectations for members of the business professions.
Communicate in a manner that is professional and consistent with expectations for members of the business professions.
Scenario
Cash budgets forecast cash needs to achieve operational goals, especially in terms of expected financing. For this assessment, you will act as a controller at a manufacturing company called the Spicer Corporation and your task will be to prepare a cash budget and an associated memo.

Your Role
You are a controller working for the vice president of finance at a manufacturing company called Spicer Corporation.

Requirements
The vice president has requested you create a cash budget (4–5 pages) for the coming year:

Use the Cash Budgeting Template [XLSX].
Include a supplement schedule for cash receipts for the coming year.
Assume management wants to maintain a minimum cash balance of $50,000.
When you complete the cash budget, include the component parts:

Sales budget.
Purchasing budget.
Payments budget.
Cash receipts budget.
In addition to the cash budget, the vice president has also requested that you prepare a memo to management (2–3 pages) that explains the purpose of a cash budget, its relationship to operational goals, and the process you performed to create it. As part of the memo, identify at least three key aspects of the current cash budget that management should note. For each key aspect, be sure to discuss how the overall cash budget will be impacted if there is a change in the expectation.

Use the Memo Template [DOC] to structure your memo.
Deliverable Format
Since the vice president of finance has requested these documents, you should make the cash budget and associated memo as clear, well-organized, and readable as possible. The vice president has requested the memo for management be 2–3 pages so that you have enough space to provide some scholarly and/or professional context.

Communication: Communicate in a manner that is scholarly, professional, and consistent with the needs and expectations of senior corporate leadership and other stakeholders. For this scenario, assume the vice president of finance expects original work, critical thinking, and scholarly sources. Your writing must be free of errors that detract from the overall message.

You have been assigned the task of completing the proposed budget for the next fiscal year for your Department. The fiscal year is from January – December. As a tool, you have the budget from the previous year, the salary worksheet and the monthly expenses report. You will be using the historical data provided as well as considering your projections for future costs.

You have been told to project a maximum 5% salary increase.
You have been told to project an increase in supplies of 7%.
You have been told to project a 5% increase in all other areas, except those discussed below.

You must also evaluate travel expenses, membership and dues. It is the policy of your facility to pay for the coder CCS certification annual maintenance, your AHIMA or other professional dues, and to reimburse any person who successfully passes the certification examination. You know that two of your people plan to take the CCS exam next year. (Check AHIMA.org or other professional organization for these costs)

You need to budget to attend the AHIMA or other convention (use current cost date). Be sure to estimate airfare, hotels, food, and registration fees for a 4 day convention. Attach appropriate document that details estimated expenses. (Yes, check actual airfare from your home to the site of the current convention and include that. Estimate $160.00 a night for hotel and $35.00 a day for food).

You typically host lunch for your staff during HIM week in November. You have 12 employees in your department and you usually plan to spend $10.00 per person.

You need to budget for education. You know that you must provide education for your employees to include, at a minimum, FY coding updates (both ICD and CPT). Additionally, your employees need a minimum of 10 CE’s a year to maintain their certification and the hospital provides that education. (check AHIMA’s or other professional website web site, go to the book store, and check the price of audio seminars. Budget enough to cover the cost for approximately 10 hours)

You have also been advised to make any capital requests at this time. You need a new piece of equipment, you pick what you want, but must qualify as capital. (check the internet, choose a model, see if you can find multiple sites with the same product and compare pricing, attach info to your budget.)

Based on 2080 hours working a year, what is your department’s average hourly rate?
What is the total average monthly expense for your Department each month?
(total budget / 365 * days in month)

1. Create a budget for the current year. Justify all of your calculations and recommendations.
2. Create an excel spreadsheet for your budget. Create supporting documentation in Word and answer the questions given related to budgeting.

You will turn in 3 excel spreadsheet tab for your proposed budget for the current year.
One that lists salaries, one that is broken down by month and one that is an annual budget.

You will turn in a Word Document that identifies the equipment you would like to purchase and a justification for that equipment. (Can be combined with your justification and budget overview document just make sure you include enough detail.)

You will turn in a Word Document that justifies your expenses for every category in your budget that is outside of the standard 5% increase and answer the following questions relate to the Excellence System:

¬ Discuss why budgets are used in healthcare organizations? What potential problems are being addressed by having a solid budget at the beginning of the years? (ES 1 & 2)
¬ Create a problem statement that addresses why we have budgets in an organization. (ES 1)
¬ How will you implement this budget in your organization? How will you as the CFO ensure it is followed throughout the year? (ES 3 & 4)
¬ How can a budget’s effectiveness be evaluated throughout the year in order to create a more effective budget the next year? (ES 5)

This assignment meets Problem Solving.

Your presentation must be organized and well thought out.

There are three tabs on Excel. Please check all tabs