College Pal
Connecting to a pal for your paper
  • Home
  • Place Order
  • My Account
    • Register
    • Login
  • Confidentiality Policy
  • Samples
  • How It Works
  • Guarantees

Sms or Whatsapp only : US:+12403895520

 

email: [email protected]
March 21, 2023

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

Uncategorized

 

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.
  • The memo is a professional document and should therefore follow the corresponding MBA Academic and Professional Document Guidelines, including single-spaced paragraphs.
  • Resources: Incorporate at least two resources that are scholarly and/or professional. So that your imaginary vice president of finance can locate more information about cash budgeting, include a reference page at the end of your report.
  • Budget length: According to template.
  • Memo length: Minimum of 2–3 pages, not including reference pages.
  • Font and font size: Times New Roman, 12 pt.

Faculty will use the scoring guide to review your deliverable as if they were your immediate supervisor. Review the scoring guide prior to developing and submitting your assessment.

  • attachment

    cf_memo_template.doc

  • attachment

    cf_cash_budgeting_template.xlsx

image2.png

image1.png Remove or Replace: Header Is Not Doc Title

Accounting Memo Template

TO: Addressed to appropriate audience

FROM: Enter you name

DATE: Enter the date

SUBJECT: Enter an appropriate but brief statement for the subject

[ Instructions: After completing Spicer's cash budget, draft a memo to management explaining the general purpose of a cash budget and its relationship to operational goals. As part of the memo, identify at least 3 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.

The body of the memo should be single-spaced with double spacing between paragraphs. Be sure to open with an introduction explaining what the memo will provide.

Source material should be cited according to APA guidelines. A separate reference page should be included, following the memo.

Be sure to note if there are attachment or appendices included. For this course, these would be the completed budgeting schedules and/or calculations.

No signature line is required for the memo.]

1

2

image1.png image2.png,

Part A

ACC5610 & ACC-FPX5610: Budgeting Planning and Control
Assessment 4: Cash Budgeting Worksheet
Part A Input values
Spicer Corporation would like to prepare a cash budget in order to determine the company's financing needs for the
upcoming year. The beginning cash balance is $161,250. Company name Spicer Corporation
The sales for the upcoming year is as follows: Year end December 31, 20XX
Spicer Corporation Spicer Corporation
Sales Budget for the Year Ending December 31, 20XX Sales Budget for the Year Ending December 31, 20XX
First Quarter Second Quarter Third Quarter Fourth Quarter 1st Qtr 2nd Qtr 3rd Qtr 4th Qtr
Projected number of units to be sold 1,525 1,675 1,775 1,550 Projected number of units to be sold 1,525 1,675 1,775 1,550
Sales price per unit $ 275 $ 275 $ 275 $ 275 Sales price per unit $ 275 $ 275 $ 275 $ 275
Projected revenue $ 419,375 $ 460,625 $ 488,125 $ 426,250 Projected revenue $ 419,375 $ 460,625 $ 488,125 $ 426,250
All sales are on account. It is reported that 65% of the accounts receivable is collected in the quarter of the sale and Spicer Corporation
35% in the quarter after the sale. The beginning accounts receivable is $142,000. Operating Expenses for the Year Ending December 31, 20XX
All the purchases are made on account. The company pays 100 percent of the accounts payable each quarter. The 1st Qtr 2nd Qtr 3rd Qtr 4th Qtr
purchases are related to the inventory needed to sell each month. On an average, the inventory costs $195 per unit Salaries and wages $ 55,625 $ 55,450 $ 54,675 $ 56,285
to produce. It is estimated that enough inventory is purchased each quarter to cover the projected quarterly sales only. Advertising 1,200 1,500 900 2,000
The beginning accounts payable is $0. Utilities 2,700 2,700 2,700 2,700
Rent 6,000 6,000 6,000 6,000
Additional quarterly expenses include the following: Total $ 65,525 $ 65,650 $ 64,275 $ 66,985
Spicer Corporation
Operating Expenses for the Year Ending December 31, 20XX Beginning cash balance $161,250
Beginning accounts receivable balance $142,000
First Quarter Second Quarter Third Quarter Fourth Quarter % of accounts receivables collected in the 65%
Salaries and wages $ 55,625 $ 55,450 $ 54,675 $ 56,285 quarter of the sale
Advertising 1,200 1,500 900 2,000 % of accounts receivables collected in the 35%
Utilities 2,700 2,700 2,700 2,700 quarter after the sale
Rent 6,000 6,000 6,000 6,000 Inventory cost per unit $195
Total $ 65,525 $ 65,650 $ 64,275 $ 66,985 Note payable $165,000
Annual interest rate on note payable 6%
On the balance sheet, Spicer Corporation reports a note payable of $165,000. The principal plus interest is due on Cost of new machine $50,000
April 30. Until then, interest payments are made each month. The note has an annual interest rate of 6%. Minimum cash balance $50,000
Line of credit borrowings/repayment $10,000
It is projected that in October of the current year, Spicer Corporation will need to purchase a new machine in order to Minimum surplus for repayment of line of credit $5,000
replace an outdated machine. The new machine will cost $50,000. The purchase is expected to be made with cash. Annual interest rate on line of credit 4%
Amount of line of credit (in millions of dollars) $1
Spicer Corporation currently has a line of credit of $1 million that

Collepals.com Plagiarism Free Papers

Are you looking for custom essay writing service or even dissertation writing services? Just request for our write my paper service, and we'll match you with the best essay writer in your subject! With an exceptional team of professional academic experts in a wide range of subjects, we can guarantee you an unrivaled quality of custom-written papers.

Get ZERO PLAGIARISM, HUMAN WRITTEN ESSAYS

Why Hire Collepals.com writers to do your paper?

Quality- We are experienced and have access to ample research materials.

We write plagiarism Free Content

Confidential- We never share or sell your personal information to third parties.

Support-Chat with us today! We are always waiting to answer all your questions.

Does accreditation help improve the quality of care delivered by healthcare organizations? ?Does accreditation increase the cost of delivering care? Milestone Two Guidelines and Rubric

Related Posts

Uncategorized

Describe the advanced nursing role you anticipate achieving after completing your graduate degree.? How did you choose this area? Where mig

Uncategorized

Describe the advanced nursing role you anticipate achieving after completing your graduate degree.? How did you choose this area? Where mig

Uncategorized

Describe the advanced nursing role you anticipate achieving after completing your graduate degree.? How did you choose this area? Where mig

Why Choose Us

Best Essay Writing Services- Get Quality Homework Essay Paper at Discounted Prices

At the risk of sounding immodest, we must point out that we have an elite team of writers. Ours isn’t a collection of individuals who are good at searching for information on the Internet and then conveniently re-writing the information obtained to barely beat Plagiarism Software. Who can’t do that?

Our writers have strong academic backgrounds with regards to their areas of writing. A paper on History will only be handled by a writer who is trained in that field. A paper on health care can only be dealt with by a writer qualified on matters health care. Thesis papers will only be handled by Masters’ Degree holders while Dissertations will strictly be handled by PhD holders. With such a system, you needn’t worry about the quality of work. Quality isn’t just an option, it is the only option. We don’t just employ writers, we hire professionals.

We have writers spread into all fields including but not limited to Philosophy, Economics, Business, Medicine, Nursing, Education, Technology, Tourism and Travels, Leadership, History, Poverty, Marketing, Climate Change, Social Justice, Chemistry, Mathematics, Literature, Accounting and Political Science.

Our writers are also well trained to follow client instructions as well adhere to various writing conventional writing structures as per the demand of specific articles.

They are also well versed with citation styles such as APA, MLA, Chicago, Harvard, and Oxford which come handy during the preparation of academic papers.

They also have unrivalled skill in writing language be it UK English or USA English considering that they are native English speakers. You also needn’t worry about logical flow of thought, sentence structure as well as proper use of phrases.

Our writers are also not the kind to decorate articles with unnecessary filler words. We respect your money and most importantly your trust in us. In writing, we will be precise and to the point and fill the paper with content as opposed to words aimed at beating the word count.

Our shift-system also ensures that you get fresh writers each time you send a job. This helps overcome occupational hazards brought about by fatigue. Hence, quality will consistently be at the top.

From our writers, you expect; good quality work, friendly service, timely deliveries, and adherence to client’s demands and specifications.

Once you’ve submitted your writing requests, you can go take a stroll while waiting for our all-star team of writers and editors to submit top quality work.

How Our Website Works

Get an Essay from Us

College Essays is the biggest affiliate and testbank for WriteDen. We hire writers from all over the world with an aim to give the best essays to our clients.

Our writers will help you write all your homework. They will write your papers from scratch. We also have a team of editors who read each paper from our writers just to make sure all papers are of HIGH QUALITY & PLAGIARISM FREE.

Step 1
To make an Order you only need to click ORDER NOW and we will direct you to our Order Page. Then fill Our Order Form with all your assignment instructions. Select your deadline and pay for your paper. You will get it few hours before your set deadline. Deadline range from 6 hours to 30 days.

Step 2
Once done with writing your paper we will upload it to your account on our website and also forward a copy to your email.

Step 3
Upon receiving your paper, review it and if any changes are needed contact us immediately. We offer unlimited revisions at no extra cost.

Is it Safe to use our services?
We never resell papers on this site. Meaning after your purchase you will get an original copy of your assignment and you have all the rights to use the paper.

Pricing and Discounts
Our price ranges from $8-$14 per page. If you are short of Budget, contact our Live Support for a Discount Code. All new clients are eligible for 20% off in their first Order. Our payment method is safe and secure.
Please note we do not have prewritten answers. We need some time to prepare a perfect essay for you.

Recent Posts

  • Due to short staffing and the slow new hire recruitment process, current clinical support staff, including medical assistants, LPNs, and RNs, are feeling bur
  • Prepare a video/voice annotated presentation using PowerPoint? (another presentation tool) video presentation appropriate for senior executive management (CE
  • Each of you will have 10-15 minutes to present a High-level update on your region’s census recovery strategy for the adult day care. Please feel free to pres
  • Due to short staffing and the slow new hire recruitment process, current clinical support staff, including medical assistants, LPNs, and RNs, are feeling bur
  • Develop a 10-slide business PowerPoint for the economic issue you have been working with as your topic in the previous assessment. You will then present this
College Pal

All Rights Reserved Terms and Conditions
College pals.com Privacy Policy 2010-2018