Week 5 Homework 2024_Chaitanya
docx
keyboard_arrow_up
School
Webster University *
*We aren’t endorsed by this school
Course
5200
Subject
Accounting
Date
Apr 3, 2024
Type
docx
Pages
9
Uploaded by LieutenantRockLemur10
Week 5 Homework 2024 1.
According to the week 5 lecture, how do budgets assist managers?
Answer:
Budgets assist managers in the following four ways:
1.
control finances.
2.
meet current commitments.
3.
provide funding for future ventures, and
4.
make financial decisions and meet organizational goals.
To sum up, budgets are an invaluable tool for managers because they allow them keep tabs on expenses, pay bills on time, set aside money for projects, and make financial decisions in a way that will help the company reach its goals.
2.
Budgeting
is the process to develop an organization’s budget. It is an integral part of planning.
3.
You have recently been promoted within your organization, and you are now a vice president over the Texas division. There are 150 employees in your organization including 10 sales personnel. You are required to create a budget for your division and submit it to the president (your boss) located in the corporate office in Kansas. Describe the steps from the lecture that you will use to create this budget.
Answer: I'm going to do the following to build a budget for the Texas division:
Step 1
: I will enumerate every revenue stream for the Texas division that is anticipated to be included in the budget, including sales revenues, investments, grants, and loans. Moreover, I'll provide the total expected spending for the budgetary term, which will include all marketing, labor, rent, utilities, raw materials, and other pertinent charges.
Step 2
:
a.
I would look at prior sales volumes and patterns to see how income sources could vary in the
future. Analyze past periods' sales growth or fall and forecast sales for the budget term.
b.
I will examine economic trends that may have an influence on budget items and evaluate elements such as inflation rates, interest rates, consumer spending patterns, and general market conditions in order to estimate prospective changes in revenue and expenditures.
c.
I will attempt to assess the expected activities of market opponents, followed by an analysis of their strategy, pricing, product offers, and market share, to predict how they will affect budget items.
d.
I will use market research data to better understand consumer behavior, market trends, and future opportunities or threats. Use this information to make necessary adjustments to the budget.
e.
I will try to obtain information regarding potential government activities, such as new laws or
regulations, that may have an influence on the firm, and I will then examine how these changes may alter income streams or increase or decrease specific expenses.
Step 3
: Then, using the results of the study, I will apply the projected modifications to each budget item. I will adjust the revenue sources and expenditures to reflect anticipated changes in sales, market circumstances, competitor activities, market research findings, and potential government actions.
Step 4
: At the end of the budget period, I will compare the actual and budgeted data. Then I'll look at the differences between actual and predicted results for each budget item. I will use the disparities between actual and predicted results to develop more accurate estimates, revise budgeted figures, and improve decision-making in future budgeting procedures.
I will develop a thorough and practical budget for the Texas division that is in line with the overall
goals and objectives of the organization by following these steps.
4.
The Calendar Company expects to have $4,000 in cash on hand at the beginning of January, and the company's target cash balance is $2,000. Net cash flow for January is minus $10,000. The company borrows to meet short term cash needs. What amount will Calendar Company need to borrow to meet their target cash balance at the end of January?
Answer:
Given that, Beginning cash = $4000, Minimum cash balance desired = $2000, net cash flow = -$10000.
Ending cash before finance = Beginning cash+ net cash flow
= 4000-10000
= -6000
Required Financing = Minimum cash balance desired - Ending cash before finance
= 2000 -(-6000)
= $ 8000.
As a result, the Calendar Company must borrow $8,000 to fulfill its goal cash level at the end of
January.
5.
Roberts and Company had a balance in their retained earnings account at the end of 2023 in the amount of 3,000,000. They have forecasted net income in 2024 in the amount of 800,000. They
pay an estimated 35% of their net income in dividends. What will be the budgeted addition to retained earnings at the end of 2024? Answer:
To determine the budgeted increase in retained earnings, we need to begin by deducting the estimated dividends from the projected net income. Then, add this result to the starting balance of retained earnings.
Step 1: Calculating the estimated dividends:
$800,000 (forecasted net income) x by 35% = $280,000
Step 2: Determining the addition to retained earnings:
$800,000 (forecasted net income) - $280,000 (estimated dividends) = $520,000
Step 3: Add the starting balance of retained earnings:
$520,000 (addition to retained earnings) + $3,000,000 (beginning balance) = $3,520,000.
Hence, the projected increase in retained earnings by the conclusion of 2024 amounts to $520,000, resulting in a cumulative total of $3,520,000 in retained earnings.
6.
Given the same information in #5, what will be the budgeted ending balance in retained earnings at the end of 2024 for Roberts and Company?
Answer:
In order to determine the Budgeted ending balance in retained earnings for the year 2024, we
must combine the anticipated net income with the initial balance of retained earnings and then
deduct the amount of dividends paid.
Given that the dividends amount to $280,000 and the net income available for retention
is calculated to be $520,000, the budgeted ending balance can be calculated as follows:
Budgeted ending balance = Beginning retained earnings + Net income available for retention
= $3,000,000 + $520,000
= $3,520,000
7.
You are the financial analyst for ABC company, and the president has asked you to create an expense budget for the sales department. The sales department is located in another office building, as there is no space available for them at the headquarters office. Last Year
Forecasting Assumption Budget for this Year
Salaries
$300,000 5% increase
Your preview ends here
Eager to read complete document? Join bartleby learn and gain access to the full version
- Access to all documents
- Unlimited textbook solutions
- 24/7 expert homework help
Stationary
$ 2,000 3% decrease
Cell Phones
$ 10,000 10% increase
Electricity
$ 6,000 4% increase
Office Rent
$ 50,000 4% increase
Real Estate Taxes
$ 7,000 no change
______
Total: $375,000
Answer: Here’s the expense budget for the sales department for this year:
Salaries: $315,000 (5% increase from last year’s $300,000)
Stationary: $1,940 (3% decrease from last year’s $2,000)
Cell phones: $11,000 (10% increase from last year’s $10,000)
Electricity: $6,240 (4% increase from last year’s $6,000)
Office Rent: 52,000 (4% increase from last year’s $50,000)
Real Estate Texas: $7,000 (no change from last year)
⸫
Total Budget for this year: $393,180
8.
How much could be saved if you suggested a work from option for the sales department, and it was implemented?
Answer:
To determine the potential savings, we must take into account the costs associated with the physical office space, which typically include office rent and electricity. However, we will exclude the cell phone expenses as they may not decrease due to the constant communication required for sales.
Let's calculate the potential savings:
1. Office Rent: $52,000 (as stated in the budget)
2. Electricity: $6,240 (as stated in the budget)
Therefore, the potential savings from implementing a work-from-home option would amount to:
$52,000 + $6,240 = $58,240.
9.
Steve and Company have budgeted sales commissions of $600,000 for 2024, based on sales estimates of $3,000,000 for the same year. After the first quarter however, they realize that sales are exceeding expectations. Sales are now expected to reach $4,000,000 for 2024. By how
much will Steve and Company adjust their budget beginning in the 2nd quarter for sales commissions, assuming this trend continues? Steve and Company uses a static budgeting process.
Answer:
In order to determine this, it is necessary to calculate the revised commission budget based on the updated sales estimate.
Initial commission budget = $600,000
Initial sales estimate = $3,000,000
Commission rate = $600,000 ÷ $3,000,000 = 20%
Revised sales estimate = $4,000,000
New commission budget = 20% x $4,000,000 = $800,000
Since Steve and Company follow a static budgeting process, they will not make any adjustments to the budget for the first quarter. However, starting from the second quarter, they will increase the sales commission budget by $200,000 ($800,000 - $600,000) to align with the updated sales projections.
10.
What are the 5 steps to zero budgeting according to Dave Ramsey?
Answer:
The 5 steps to zero budgeting according to Dave Ramsey are:
1. List your income 2. List your expenses 3. Subtract your expenses from your income 4. Track your transactions 5. Make a new budget before the next month begins.
11. Tammy’s Tasty Treats
expects sales of $10,000, $15,000, and $40,000 during April, May, and June (big
sale in June). To build business, Tammy allows all customers buy on credit, and all do so. In the past,
30% of Tammy’s sales have been collected during the month of sale, 55% are collected the following month, and 15% the month after that. If this trend continues, what will be Tammy’s total cash collections in the month of June?
Answer:
To determine Tammy's total cash collections in June, you need to calculate the expected collections from sales in April, May, and June.
April sales
: Sales collected in April = $10,000 x 30% = $3,000
Sales collected in May (some of which will be collected in June) = $10,000 x 55% = $5,500 Sales collected in June (some of which will be collected in July) = $10,000 x 15% = $1,500 May sales: Sales collected in May = $15,000 x 30% = $4,500 Sales collected in June (some of which will be collected in July) = $15,000 x 55% = $8,250 Sales collected in July = $15,000 x 15% = $2,250 June sales: Sales collected in June = $40,000 x 30% = $12,000 Sales collected in July (some of which will be collected in August) = $40,000 x 55% = $22,000 Sales collected in August = $40,000 x 15% = $6,000 Total cash collections in June: $1,500 (April) + $8,250 (from May sales) + $12,000 (from June sales) = $21,750
Therefore, Tammy's total cash collections in June will be $21,750
12. For the week, Bob’s Manufacturing has a beginning cash balance of 300,000. They spend 99,000 on direct materials, 19,000 on direct labor, and 29,000 on manufacturing overhead. They also have cash sales of 10,000, accounts receivable collections of 220,000 and asset sales of 30,000. They also purchased assets in the amount of 20,000 and had sales commissions and other administrative expenses
in the amount of 40,000. What was Bob’s Manufacturing cash balance at the end of the week? Answer:
To determine Bob's Manufacturing's cash balance at the end of the week, you need to subtract the cash disbursements from the cash receipts. Given that,
Cash disbursements:
Direct materials = $99000, Direct labor = $19000, Manufacturing overhead = $29000 Asset purchases = $20000, Sales commissions and administrative expenses = $40,000
Total cash disbursements = $207,000
Cash receipts:
Cash sales = $10000, Accounts receivable collections = $220000, Asset sales = $30000
Your preview ends here
Eager to read complete document? Join bartleby learn and gain access to the full version
- Access to all documents
- Unlimited textbook solutions
- 24/7 expert homework help
Total cash receipts = $260,000
change in cash balance= total cash receipts - total cash disbursements
= $260,000 - $207,000 = $53,000
Adding this change to the beginning cash balance gives you the ending cash balance:
$300,000 + $53,000 = $353,000
Therefore, Bob's Manufacturing's cash balance at the end of the week is $353,000.
13. Which budget is a combination of all the budgets of an organization, dealing with all phases of the operations of the business for a particular period of time? Answer: Master budget is a combination of all the budgets of an organization, dealing with all phases of the operations of the business for a particular period of time 14. According to the lecture, what is generally required when forecasted assets exceed forecasted liabilities? Answer: External Financing Required (EFR) is generally required when forecasted assets exceed forecasted liabilities. 15. Budgeted financial statements are sometimes referred to as pro forma
financial statements or pro forma
forecasts.
16. Which budget quantifies the capital investment decisions determined in the organization’s long term
plans.
Answer: The capital expenditure budget quantifies the capital investment decisions determined in the organization’s long-term plans. 17. Which budget is prepared for one level of activity, for example a particular volume of production or level of sales.
Answer: A static budget is a budget prepared for one level of activity, for example a particular volume of production or level of sales.
18. Charles and Company has begun selling a new pie recipe and they want you to help them with next year’s budgeted financial statements. Using the worksheet below, complete Charles and Company forecast and answer the questions which follow.
Assumptions:
To begin with, Charles and Company is sure sales will grow 50% next year. Assume that is true. Then assume that COGS, Current Assets, and Current Liabilities all vary directly with Sales (that means if sales grows a certain percentage, then the account in question will grow by that same percentage). Assume that fixed expenses will remain unchanged and that $8,000 worth of new Fixed Assets will be obtained next year. Long term debt and common stock accounts remain unchanged. Lastly, the current dividend policy will be continued next year.
Charles and Company
Financial Forecast
Estimated
This year for next year
Sales
$85,000
COGS
35,000
Gross Profit
40,000
Fixed Expenses 3,000
Before-Tax Profit
37,000
Tax @ 33.3333%
12,332
Net Profit
24,668
Dividends
$0
____$0__
_ Current Assets $40,000
Net Fixed Assets
20,000
Total Assets
$50,000
__$88000_
Current Liabilities $18,000
Long-term debt
3,000
Common Stock 9,000
Retained Earnings
13,000
Total Liabs & Eq $43,000 Amount need to balance the balance sheet _-$12000___
(Projected total assets minus projected liabilities)
Your preview ends here
Eager to read complete document? Join bartleby learn and gain access to the full version
- Access to all documents
- Unlimited textbook solutions
- 24/7 expert homework help
Related Documents
Related Questions
Q5
A budget is 'accepted' by managers when they______.
Select one:
a. relates it to their own personal objectives
b. receive the budget in writing
c. are consulted by top management
d. agree to it verbally
arrow_forward
21
arrow_forward
Flag question: Question 33
Why is budget important?
Group of answer choices
-It gives stakeholder good information about financial statement;
-provide a good orderly management activities within an organization;
-it is important to create balance sheet;
-It is useful to manage liabilities.
arrow_forward
This week we have covered the topic of budgeting. Effective budgeting and responsibility accounting are crucial for organizations to achieve financial stability and success in today's dynamic business environment. Considering this, respond to ONE of the following four questions for your initial response.
How does the concept of responsibility accounting contribute to organizational accountability? If you have experiences from previous jobs, you can share those. Otherwise, find examples from companies through internet research, or share your insight on why you think this may matter.
What do you think are the key components of a successful budgeting process within an organization? Are there any specific challenges that organizations may commonly face when implementing a budget?
How can organizations strike the right balance between budgetary control and flexibility to adapt to changing market conditions? What are some best practices for adjusting budgets when necessary while still…
arrow_forward
QUESTION 22
Which of the following are reasons to generate a pro forma cash budget on a
monthly basis?
a. An income statement indicates a profit but the budget may indicate a loss.
b. A business can monitor the actual cash on hand.
c. Sales are recognized as income when the sale is made.
d. All of the above.
arrow_forward
Question 5
Evaluate 2 types of budgeting used in a medium sized private company with
identification of merits and disadvantages of each method.
a)
b)
What is an annual budget? Do all companies need to provide annual budgets?
Please justify your answer.
arrow_forward
7
arrow_forward
A) Enter True or False
1.
________
An important part of the planning process is the creation of a budget.
2.
________
Operating budgets focus on the financial resources needed to support operations including cash receipts and disbursements, capital expenditures and financing.
3.
________
Budgets can also create a “use-it-or-lose-it” mentality that encourages managers to spend their entire budgets to avoid a reduction in resources in the next budget period.
4.
________
The starting point of the planning process is management’s strategic plan or vision of what they want the organization to achieve over the long term.
5.
________
A short-term objective is a specific goal that managers want to achieve in more than a year to reach their long-term goals.
6.
________
Planning is the forward-looking phase of the planning and control process that involves setting long-term objectives and defining short-term…
arrow_forward
Provide a letter of advice:• discuss the key results of the income statement and cash budget• make one suggestion on how the client could improve the financial success of the cost management strategy• identify and discuss one non-financial factor that might affect the client’s decision to proceed with the chosen proposal• clearly state whether the client should proceed with the chosen proposal and why
arrow_forward
Part C:
Budgeting and Financial plan Required:
Research Unilever PLC and complete the following task:
Task 3A:
Critically evaluate the impact of budgeting process on any potential project and demonstrate how budgets, objectives, and strategic plans are related.
Task 3B:
Briefly discuss the significance of Business plan and analyse key elements of its financial plan section of a proposed business plan.
Task 3C:
There is a growing nascent for using of Artificial Intelligence (AI) and Machine Learning (ML) in financial community. Critical discuss (in 5-line ofwords), how either AI or ML could be effective in preparing a long-term budget.
arrow_forward
QUESTION 57
True Love Inc., is pretty heavy into the use of budgets. Which of the following statements is TRUE of the budgeting process of True-Love and in fact, any company that uses
budgets?
O Managers and employees are motivated to accept the budget's goals because they enjoy having their work monitored and evaluated.
O Ha company carefully plans for its future, there will be no need to make modifications during the budget period
O R shows the actual performance of the business
O It is a continuous process that encourages communication.
QUESTION S8
Opportunity cost is the benefit
O given up by purchasing goods at a price lower than its total manufacturing cost
O gven up by choosing an alternate course of action
O received by selling goods on behalf of another division
O received by seling goods to one of the other divisions within the company
QUESTION 59
Last year. T-Bal Company spent $36.000 on employee training to improve customer service. The cost and time spent on traning is…
arrow_forward
1. Which of the following is an advantage of the budgeting process?
a. It forces management to focus on the past and not be distracted by the day-to-day operations of the business.
b. It can communicate to employees specific information about their past performance to determine their promotion prospects.
c. It can communicate to employees specific information about their past performance to determine their promotion prospects.
d. It can communicate to employees information about their performance expectations in the period ahead.
2. Which one of the following statements regarding changing inventory costing methods is true?
a. A change in inventory methods can be justified if the change is made to better match profits with revenue
b. Changing inventory costing methods violates comparability
c. One place that the reader of an annual report would be able to identify that a company changed inventory costing methods is the statement of shareholders' equity
d. Changing inventory costing…
arrow_forward
Planning and Control
Many companies use budgets for three purposes. First, they use them to plan how to deploy resources to best serve customers. Second, they use them to establish challenging goals, or stretch targets, to motivate employees to strive for exceptional results. Third, they use them to evaluate and reward employees.
Assume that you are a sales manager working with your boss to create a sales budget for next year. Once the sales budget is established, it will influence how other departments within the company plan to deploy their resources. For example, the manufacturing manager will plan to produce enough units to meet budgeted unit sales. The sales budget will also be instrumental in determining your pay raise, potential for promotion, and bonus. If actual sales exceed the sales budget, it bodes well for your career. If actual sales are less than budgeted sales, it will diminish your financial compensation and potential for promotion.
Required:
1. Do you think it would…
arrow_forward
SEE MORE QUESTIONS
Recommended textbooks for you
Related Questions
- Q5 A budget is 'accepted' by managers when they______. Select one: a. relates it to their own personal objectives b. receive the budget in writing c. are consulted by top management d. agree to it verballyarrow_forward21arrow_forwardFlag question: Question 33 Why is budget important? Group of answer choices -It gives stakeholder good information about financial statement; -provide a good orderly management activities within an organization; -it is important to create balance sheet; -It is useful to manage liabilities.arrow_forward
- This week we have covered the topic of budgeting. Effective budgeting and responsibility accounting are crucial for organizations to achieve financial stability and success in today's dynamic business environment. Considering this, respond to ONE of the following four questions for your initial response. How does the concept of responsibility accounting contribute to organizational accountability? If you have experiences from previous jobs, you can share those. Otherwise, find examples from companies through internet research, or share your insight on why you think this may matter. What do you think are the key components of a successful budgeting process within an organization? Are there any specific challenges that organizations may commonly face when implementing a budget? How can organizations strike the right balance between budgetary control and flexibility to adapt to changing market conditions? What are some best practices for adjusting budgets when necessary while still…arrow_forwardQUESTION 22 Which of the following are reasons to generate a pro forma cash budget on a monthly basis? a. An income statement indicates a profit but the budget may indicate a loss. b. A business can monitor the actual cash on hand. c. Sales are recognized as income when the sale is made. d. All of the above.arrow_forwardQuestion 5 Evaluate 2 types of budgeting used in a medium sized private company with identification of merits and disadvantages of each method. a) b) What is an annual budget? Do all companies need to provide annual budgets? Please justify your answer.arrow_forward
- 7arrow_forwardA) Enter True or False 1. ________ An important part of the planning process is the creation of a budget. 2. ________ Operating budgets focus on the financial resources needed to support operations including cash receipts and disbursements, capital expenditures and financing. 3. ________ Budgets can also create a “use-it-or-lose-it” mentality that encourages managers to spend their entire budgets to avoid a reduction in resources in the next budget period. 4. ________ The starting point of the planning process is management’s strategic plan or vision of what they want the organization to achieve over the long term. 5. ________ A short-term objective is a specific goal that managers want to achieve in more than a year to reach their long-term goals. 6. ________ Planning is the forward-looking phase of the planning and control process that involves setting long-term objectives and defining short-term…arrow_forwardProvide a letter of advice:• discuss the key results of the income statement and cash budget• make one suggestion on how the client could improve the financial success of the cost management strategy• identify and discuss one non-financial factor that might affect the client’s decision to proceed with the chosen proposal• clearly state whether the client should proceed with the chosen proposal and whyarrow_forward
- Part C: Budgeting and Financial plan Required: Research Unilever PLC and complete the following task: Task 3A: Critically evaluate the impact of budgeting process on any potential project and demonstrate how budgets, objectives, and strategic plans are related. Task 3B: Briefly discuss the significance of Business plan and analyse key elements of its financial plan section of a proposed business plan. Task 3C: There is a growing nascent for using of Artificial Intelligence (AI) and Machine Learning (ML) in financial community. Critical discuss (in 5-line ofwords), how either AI or ML could be effective in preparing a long-term budget.arrow_forwardQUESTION 57 True Love Inc., is pretty heavy into the use of budgets. Which of the following statements is TRUE of the budgeting process of True-Love and in fact, any company that uses budgets? O Managers and employees are motivated to accept the budget's goals because they enjoy having their work monitored and evaluated. O Ha company carefully plans for its future, there will be no need to make modifications during the budget period O R shows the actual performance of the business O It is a continuous process that encourages communication. QUESTION S8 Opportunity cost is the benefit O given up by purchasing goods at a price lower than its total manufacturing cost O gven up by choosing an alternate course of action O received by selling goods on behalf of another division O received by seling goods to one of the other divisions within the company QUESTION 59 Last year. T-Bal Company spent $36.000 on employee training to improve customer service. The cost and time spent on traning is…arrow_forward1. Which of the following is an advantage of the budgeting process? a. It forces management to focus on the past and not be distracted by the day-to-day operations of the business. b. It can communicate to employees specific information about their past performance to determine their promotion prospects. c. It can communicate to employees specific information about their past performance to determine their promotion prospects. d. It can communicate to employees information about their performance expectations in the period ahead. 2. Which one of the following statements regarding changing inventory costing methods is true? a. A change in inventory methods can be justified if the change is made to better match profits with revenue b. Changing inventory costing methods violates comparability c. One place that the reader of an annual report would be able to identify that a company changed inventory costing methods is the statement of shareholders' equity d. Changing inventory costing…arrow_forward
arrow_back_ios
SEE MORE QUESTIONS
arrow_forward_ios
Recommended textbooks for you