Lannister Company: Cash Receipts and Payments Lannister Company wishes to forecast its cash receipts and cash...
Fantastic news! We've Found the answer you've been seeking!
Question:
Transcribed Image Text:
Lannister Company: Cash Receipts and Payments Lannister Company wishes to forecast its cash receipts and cash disbursements for the first quarter of 2020. The following data have been assembled: a. Actual sales for November and December of 2019 and forecasted sales data for the first four months of 2020 are as follows: November (actual) December (actual) $450,000 750,000 January (estimate) February (estimate) March (estimate) April (estimate) 150,000 75,000 300,000 500,000 b. Lannister pays for 20% of its inventory purchases in the month of the purchase. An additional 70% is paid for in the month following the purchase. The remaining 10% is paid for in the second month following the purchase. Inventory purchases in November and December were $330,000 and S110,000, respectively. Cush collections of sules are made according to the following pattern: с. 10% of sales are collected in the month of sale 30% of sales are collected in the month following sale 55% of sales are collected in the second month following sale 5% of sales are never collected On average, cost of goods sold is 75% of sales. Lannister started implementing an ending inventory policy in 2020 that there should be enough inventory at the end of the month to meet the sales needs for the following month. On January 1, Lannister's inventory level is S100,000. Note: Inventory is reported at its COST, not its retail selling price. d. e. Questions: Budgeted sales in March ($300,000) are higher than in January ($150,000) and February ($75,000). Calculate the budgeted net cash flows in January, February and 1. March. Why is the budgeted net cash flow in March is much worse than in January or February? 2. Compute the budgeted difference between cash receipts and cash disbursements for January, February, and March using the following worst-case and best-case sales scenarios. Worst-Case Best-Case November (actual) $450,000 $450.000 750,000 300,000 180,000 December (actual) 750,000 January (estimate) February (estimate) March (estimate) April (estimate) 90,000 50,000 200,000 300,000 700,000 1,000,000 3. Comment on the differences in budgeted cash amounts in the worst case, middle case (based on the numbers in (a) above), and best case scenarios. Lannister Company: Cash Receipts and Payments Lannister Company wishes to forecast its cash receipts and cash disbursements for the first quarter of 2020. The following data have been assembled: a. Actual sales for November and December of 2019 and forecasted sales data for the first four months of 2020 are as follows: November (actual) December (actual) $450,000 750,000 January (estimate) February (estimate) March (estimate) April (estimate) 150,000 75,000 300,000 500,000 b. Lannister pays for 20% of its inventory purchases in the month of the purchase. An additional 70% is paid for in the month following the purchase. The remaining 10% is paid for in the second month following the purchase. Inventory purchases in November and December were $330,000 and S110,000, respectively. Cush collections of sules are made according to the following pattern: с. 10% of sales are collected in the month of sale 30% of sales are collected in the month following sale 55% of sales are collected in the second month following sale 5% of sales are never collected On average, cost of goods sold is 75% of sales. Lannister started implementing an ending inventory policy in 2020 that there should be enough inventory at the end of the month to meet the sales needs for the following month. On January 1, Lannister's inventory level is S100,000. Note: Inventory is reported at its COST, not its retail selling price. d. e. Questions: Budgeted sales in March ($300,000) are higher than in January ($150,000) and February ($75,000). Calculate the budgeted net cash flows in January, February and 1. March. Why is the budgeted net cash flow in March is much worse than in January or February? 2. Compute the budgeted difference between cash receipts and cash disbursements for January, February, and March using the following worst-case and best-case sales scenarios. Worst-Case Best-Case November (actual) $450,000 $450.000 750,000 300,000 180,000 December (actual) 750,000 January (estimate) February (estimate) March (estimate) April (estimate) 90,000 50,000 200,000 300,000 700,000 1,000,000 3. Comment on the differences in budgeted cash amounts in the worst case, middle case (based on the numbers in (a) above), and best case scenarios.
Expert Answer:
Related Book For
Materials and process in manufacturing
ISBN: 978-0471656531
9th edition
Authors: E. Paul DeGarmo, J T. Black, Ronald A. Kohser
Posted Date:
Students also viewed these accounting questions
-
Tami Tyler opened Tami's Creations, Inc., a small manufacturing company, at the beginning of the year. Getting the company through its first quarter of operations placed a considerable strain on Ms....
-
Consider the following bi-matrix game between firm Alpha and firm Beta. The first number gives the pay-off for the row-player (i.e., Alpha), whereas the second number gives the pay-off for the column...
-
Following data have been obtained for machining AA390 Aluminum, a Si-Al alloy. Compute the K and n values for the Taylor tool life equation. How do these n values compare to the typical values?...
-
Which of the units listed in Multiple-Choice Question 9 are appropriate for the biologically equivalent dose that results when a person is exposed to radiation? Data From Question 9 Which of these...
-
Erom the following alphabetized list of adjusted account balances, prepare the current asset section of Biatech's December 31, 2014, balance sheet. Account Debit Credit Accounts receivable.......
-
Verify the weak isospin and weak hypercharge quantum number assignments in Table 19.1 , given the charges \(Q\) in the last column. Verify the weak isospin and weak hypercharge assignments for the...
-
Define engineering and natural strains.
-
Given the following data, on a separate sheet of paper create monthly and yearly income statements for this fast-food restaurant in New York City. a. Sales for the month of June were $300,000. Sales...
-
15 m The parabolic cable shown carries a uniform horizontal load of w=471 kg/m. Calculate the reaction at A in kN W a B 50 m 7.5 m
-
Suppose we apply a weighted median filter with the weight given below to the input image. Show your filtered result. For boundary, use extension, i.e., same value to the closest pixel. 0 1 0 1 3 1...
-
Vail Resorts, Incorporated, owns and operates over 30 premier ski resort properties (located in the Colorado Rocky Mountains, the Lake Tahoe area, the upper midwest, the northeast, mid-Atlantic...
-
Magic Realm, Incorporated, has developed a new fantasy board game. The company sold 42,000 games last year at a selling price of $68 per game. Fixed expenses associated with the game total $756,000...
-
At December 31, 2023, Albrecht Corporation had outstanding 228,000 shares of common stock and 10,000 shares of 9.5%, $100 par value cumulative, nonconvertible preferred stock. On May 31, 2024,...
-
Exhibit 1: Sales and Cost Forecast The sales forecast is based on projected levels of demand. All the numbers are expressed in todays dollars. The forecasted average inflation per year is 3.0% Price...
-
A body is given an initial velocity of 40 m s-1 at a point, P. The body decelerates uniformly and attains a velocity of 20 ms at a point, X. The body is finally brought to rest at a point, M. If the...
-
3. (2 marks) If f(x) = g(lnx), where g'(0) = -1, find f'(1). Answer
-
1. Which of the four major types of information systems do you think is the most valuable to an organization? 2. How do you critically associate the ideas of business agility and business efficiency...
-
What are some of the basic methods that have been used to achieve the high energy-release rates needed in the HERF processes?
-
List five other names that are often used synonymously to describe rapid prototyping technology. For each name, provide a rationale or draw a parallel for why the name is used.
-
Figure 12-B contains data from a process that produces holes (drilling) with limits of 6.00 to 6.70 mm. The control charts for and R using n = 5 and k = 25 are shown in the figure, also. (The...
-
Find five interesting facts in Table 1.1. TABLE 1.1 Basic Characteristics of Selected Countries GNP per capita Index of Openness Goods & Services 2009 Population Area (millions) (1,000s sq. km.) Avg....
-
Find five interesting facts in Tables 1.4 and 1.5. DATA FROM TABLE 1.5 TABLE 1.4 Broad Categories of Exports of Selected Countries, 2010 SITC Code Product United United States Germany Japan China...
-
Compare the export rankings of the top ten leading exports of 1999 with the rankings of the top ten leading exports in 2010 (see Table 1.3). Discuss some of the reasons why these rankings have...
Study smarter with the SolutionInn App