Week 5 Homework 2024_Chaitanya

docx

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

Report
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