Exercise 8-1 (Algo) Schedule of Expected Cash Collections [LO8-2] Silver Company makes a product that is very popular as a Mother’s Day gift. Thus, peak sales occur in May of each year, as shown in the company’s sales budget for the second quarter given below: April May June Total Budgeted sales (all on account) $ 490,000 $ 690,000 $ 220,000 $ 1,400,000 From past experience, the company has learned that 25% of a month’s sales are collected in the month of
Q: a. Latifa made a loss of AED (3,500,000). However, Latifa received the following income and…
A: Taxable income:The tax income refers to the amount on which tax liability needs to be calculated…
Q: Mr. Lim started the business a small groceries shop during the year. He is seeking your help to…
A: Statement of Income for Mr. Lim's Grocery ShopFor the Year Ended December 31, 2020RevenuesCash Sales…
Q: Your answer is partially correct. Blossom Inc. has beginning-of-the-year present values for its…
A: A pension word known as the Projected Benefit Obligation refers to an assessment of the present…
Q: Hanshaben
A: Step 1: It is given that Southwest Airlines determines to recognize $10,000,000 ($10 millon) as…
Q: Madison Corporation's expected beginning cash balance is $35,000. Cash collections are budgeted at…
A: Budgeting is a process of estimation of future income and expenses or cash requirement so that we…
Q: None
A: .Part 2: Explanation:Step 1: Calculate Adjusted Gross Income (AGI)AGI = Blake's gross salary -…
Q: Dublin Corporation provides the following information related to its inventory during the month of…
A: Answer:-The inquiry pertains to calculating inventory balances and the cost of goods sold (COGS) for…
Q: Required information [The following information applies to the questions displayed below.] Project Y…
A: To compute Project Y's accounting rate of return, we need to use the formula:Accounting Rate of…
Q: None
A: Journal Entry:— It is an act of recording transactions in books of account when transaction…
Q: Determine the machines' second year depreciation under the straight-line method.
A: The expected decline in the value of a fixed asset over the course of its use is called…
Q: On December 31, 2017, Dow Steel Corporation had 600,000 shares of common stock and 300,000 shares of…
A: Earning per share:The earning per share is popularly known in short as the EPS which means the…
Q: Compare and contrast Walmart and Target's accounting depreciation policies. Do they differ markedly?
A: The United States is home to two renowned retail giants, namely Walmart and Target. These companies…
Q: Sell or Process Further Rise N' Shine Coffee Company produces Columbian coffee in batches of 4,300…
A: The objective of the question is to perform a differential analysis to decide whether to sell…
Q: None
A: To compute Berclair's basic and diluted earnings per share for the year ended December 31, 2024, we…
Q: Swifty Company purchased an electric press on June 30, 2025, by trading in its old gas model and…
A: Part 2:Explanation:Step 1:To record the exchange of the equipment, we need to recognize any gain or…
Q: In the next year, a company has pre-tax earnings that will either be €80 or €400 with equal…
A: Risk management refers to the strategic measures taken by the company to eliminate uncertainty in…
Q: None
A: Step 1: A direct labor budget is prepared to estimate the budgeted direct labor cost for the…
Q: Transcribed Image Text:A furniture-making business manufactures quality furniture to customers…
A: The objective of the question is to calculate the total cost of each job (Job MNO and Job XYZ) and…
Q: LECTURE EXAMPLES - LOANS 1. Woodgrain Industries took out an operating loan with RBC for $20,000 at…
A: A repayment schedule offers a methodical and transparent approach to paying back a loan or debt over…
Q: If you have $4,000 today with a 7% APY, how much will you have 3 years from now?
A: The future value is the amount of money your investment will grow to over time, considering the…
Q: 0. 00000
A: Please feel free to ask any questions you have, and I'll do my best to provide you with the…
Q: Suppose you finance a project partly with debt, you should neither subtract the debt proceeds from…
A: The statement in question is addressing two key aspects of project financing and cash flow…
Q: Haresh
A: Under FIFO (first-in, first-out), the assumption is that goods that were first purchased are sold…
Q: None
A: The statement is true. According to the regulations set by the Social Security Administration (SSA),…
Q: None
A: Explanation:Step 1: Calculate the Cost of Goods Sold (COGS) for both methods.Step 2: Calculate the…
Q: None
A: Step 1: ParticularsAmount($)Bond discount / PremiumExplanationa)$ 65000 @ 102.501625Bond…
Q: Required information [The following information applies to the questions displayed below.] Abel…
A: The objective of the question is to determine the impact on the company's profits if it discontinues…
Q: Gallatin Carpet Cleaning is a small, family-owned business operating out of Bozeman, Montana. For…
A: Answer:-The query pertains to Gallatin Carpet Cleaning, a small family-run company located in…
Q: The information that follows relates to equipment owned by Buffalo Limited at December 31, 2023:…
A: Answer:- Depreciation is basically the recording of decline value of an asset due to wear and tear,…
Q: Sage Hill Ltd., follows IFRS and was organized in 2022. Sage Hill provided you with the following…
A: The objective of the question is to calculate the amount to be reported for intangible assets on the…
Q: Percent of Sales Method At the end of the current year, Accounts Receivable has a balance of…
A: Step 1:Answer a.Amount of the adjusting entry for uncollectible accounts = Sales*Estimated percent…
Q: Direct labor variances Bellingham Company produces a product that requires 3 standard direct labor…
A: Lets understand the basics.Direct labor rate variance is a variance between the rate at which labor…
Q: Scotiabank approved a $230,000.00 line of credit for Buhler Industries at prime + 1%. It requires…
A: The problem involves the determination of payments made and whether these payments are for accrued…
Q: Chipotle Corporation has the following multi-step income statement for the past two years. Fill in…
A: The income statement includes all the revenue and expenses. The resulting amount after deducting…
Q: 1.What is the number of outstanding ordinary shares? 2. What is the number of outstanding…
A: Shares The capital of the company divided into small units is called a share. Each share is given a…
Q: None
A: Journa Entry : Journal entry refers to recording of transactions into the books of accounts of a…
Q: Required information [The following information applies to the questions displayed below.] Abel…
A: The objective of the question is to determine the impact on Abel Company's profits if it…
Q: Imperial Jewelers manufactures and sells a gold bracelet for $405.00. The company's accounting…
A: Step 1:Answer 1:Incremental analysis for the special order:Sales revenue from special…
Q: Denger
A: Step 1:Computation of the unit product cost under absorption costing:Direct materials cost per…
Q: Jackson Company adopted Dollar Value LIFO (DVL) on January 1, 2012 for its one inventory pool. The…
A: Part 2: Explanation:Step 1: Calculate Base-Year Inventory ValueThe base-year inventory value is the…
Q: None
A: The repayment schedule is completed below:Payment (+) or Advance (-) Principal Amount Date Accrued…
Q: Nicole organized a new corporation. The corporation began business on April 1 of year 1. She made…
A: The objective of the question is to calculate the total start-up cost and organizational…
Q: None
A: Answer 1: Manufacturing Overhead Budget1. Budgeted Direct Labor Hours:1st Quarter: 10,800 hours2nd…
Q: This problem consists of TWO parts Part One: Galaxy Corporation has a beginning inventory in 2023 of…
A: Part Two:Answer:2. Calculate the inventory value at the end of 2024 using the dollar value LIFO…
Q: Scotiabank approved a $250,000.00 line of credit for Buhler Industries at prime + 1%. It requires…
A: Part 2: Explanation:Step 1: Calculate the interest charged on December 18: - Annual interest rate:…
Q: Please solve this problem directly on Excel spreadsheet. Make sure to include the calculations…
A: The objective of the question is to calculate the tax impact of the sale of assets by Bob. This…
Q: In the current year, Madison inherited investment property from a parent's parent had a basis in the…
A: Lets understand the basics.In case of inherited property, cost of property which tax payer needs to…
Q: Telta Inc. issued $15,000,000 of 12%, 40-year convertible bonds on November 1, 2025, at 97 plus…
A: A journal entry is a record of a business transaction in a company's accounting system. It is the…
Q: Territory and Product Profitability Analysis Pipeline Surfboards Inc. manufactures and sells two…
A: The objective of the question is to prepare a contribution margin by sales territory report and…
Q: ! Required information [The following information applies to the questions displayed below.] VQT…
A: Journal Entry :— It is an act of recording transactions in books of account when transaction…
Exercise 8-1 (Algo) Schedule of Expected Cash Collections [LO8-2] Silver Company makes a product that is very popular as a Mother’s Day gift. Thus, peak sales occur in May of each year, as shown in the company’s sales budget for the second quarter given below: April May June Total Budgeted sales (all on account) $ 490,000 $ 690,000 $ 220,000 $ 1,400,000 From past experience, the company has learned that 25% of a month’s sales are collected in the month of
Trending now
This is a popular solution!
Step by step
Solved in 2 steps
- A companys sales for the coming months are as follows: About 20 percent of sales are cash sales, and the remainder are credit sales. The company finds that typically 10 percent of a months credit sales are paid in the month of sale, 70 percent are paid the next month, and 15 percent are paid in the second month after sale. Expected cash receipts in July are budgeted at what amount? a. 114,520 b. 143,150 c. 145,720 d. 156,000Cash budget The controller of Bridgeport Housewares Inc. instructs you to prepare a monthly cash budget for the next three months. You are presented with the following budget information: The company expects to sell about 10% of its merchandise for cash. Of sales on account, 70% are expected to be collected in the month following the sale and the remainder the following month (second month following sale). Depreciation, insurance, and property tax expense represent 50,000 of the estimated monthly manufacturing costs. The annual insurance premium is paid in January, and the annual property taxes are paid in December. Of the remainder of the manufacturing costs, 80% are expected to be paid in the month in which they are incurred and the balance in the following month. Current assets as of September 1 include cash of 40,000, marketable securities of 75,000, and accounts receivable of 300,000 (60,000 from July sales and 240,000 from August sales). Sales on account for July and August were 200,000 and 240,000, respectively. Current liabilities as of September 1 include 40,000 of accounts payable incurred in August for manufacturing costs. All selling and administrative expenses are paid in cash in the period they are incurred. An estimated income tax payment of 55,000 will be made in October. Bridgeports regular quarterly dividend of 25,000 is expected to be declared in October and paid in November. Management desires to maintain a minimum cash balance of 50,000. Instructions Prepare a monthly cash budget and supporting schedules for September, October, and November. On the basis of the cash budget prepared in part (1), what recommendation should be made to the controller?Exercise 8-1 (Algo) Schedule of Expected Cash Collections [LO8-2] Silver Company makes a product that is very popular as a Mother's Day gift. Thus, peak sales occur in May of each year, as shown in the company's sales budget for the second quarter given below: Required 1 Required 2 Budgeted sales (all on account) From past experience, the company has learned that 25% of a month's sales are collected in the month of sale, another 60% are collected in the month following sale, and the remaining 15% are collected in the second month following sale. Bad debts are negligible and can be ignored. February sales totaled $420,000, and March sales totaled $450,000. Complete this question by entering your answers in the tabs below. April $ 490,000 Required: 1. Prepare a schedule of expected cash collections from sales, by month and in total, for the second quarter. 2. What is the accounts receivable balance on June 30th? February sales March sales April sales May sales June sales Total cash…
- Exercise 8-1 (Algo) Schedule of Expected Cash Collections [LO8-2] Silver Company makes a product that is very popular as a Mother’s Day gift. Thus, peak sales occur in May of each year, as shown in the company’s sales budget for the second quarter given below: April May June Total Budgeted sales (all on account) $ 430,000 $ 630,000 $ 200,000 $ 1,260,000 From past experience, the company has learned that 25% of a month’s sales are collected in the month of sale, another 60% are collected in the month following sale, and the remaining 15% are collected in the second month following sale. Bad debts are negligible and can be ignored. February sales totaled $360,000, and March sales totaled $390,000. Required: 1. Prepare a schedule of expected cash collections from sales, by month and in total, for the second quarter. 2. What is the accounts receivable balance on June 30th?Exercise 8-1 (Algo) Schedule of Expected Cash Collections [LO8-2] Silver Company makes a product that is very popular as a Mother's Day gift. Thus, peak sales occur in May of each year, as shown in the company's sales budget for the second quarter given below: April May June Total $ 390,000 $ 590,000 $ 230,000 $ 1,210,000 Budgeted sales (all on account) From past experience, the company has learned that 25% of a month's sales are collected in the month of sale, another 60% are collected in the month following sale, and the remaining 15% are collected in the second month following sale. Bad debts are negligible and can be ignored. February sales totaled $320,000, and March sales totaled $350,000. Required: 1. Prepare a schedule of expected cash collections from sales, by month and in total, for the second quarter. 2. What is the accounts receivable balance on June 30th? Complete this question by entering your answers in the tabs below. Required 1 Required 2 Prepare a schedule of…Exercise 8-1 (Algo) Schedule of Expected Cash Collections [LO8-2] Silver Company makes a product that is very popular as a Mother's Day gift. Thus, peak sales occur in May of each year, as shown in the company's sales budget for the second quarter given below: Budgeted sales (all on account) April May June $ 390,000 $ 590,000 $ 230,000 Total $ 1,210,000 From past experience, the company has learned that 25% of a month's sales are collected in the month of sale, another 60% are collected in the month following sale, and the remaining 15% are collected in the second month following sale. Bad debts are negligible and can be ignored. February sales totaled $320,000, and March sales totaled $350,000. Required: 1. Prepare a schedule of expected cash collections from sales, by month and in total, for the second quarter. 2. What is the accounts receivable balance on June 30th? Complete this question by entering your answers in the tabs below.
- Exercise 1 (Schedule of Expected Cash Collections) Peak sales for Mideast Products, Inc., occur in August. The company's sales budget for the third quarter showing these peak sales is given below: July P600,000 August P900,000 Total September P2,000,000 Budgeted sales P2,000,000 From past experience, the company has learned that 20% of a month's sales are collected in the month of sale, that another 70% is collected in the month following sale, and that the remaining 10% is collected in the second month following sale. Bad debts are negligible and can be ignored. May sales totaled P430,000 and June sales totaled P540,000. Required: 1. Prepare a schedule of expected cash collections from sales, by month and in total, for the third quarter. 2. Assume that the company will prepare a budgeted statement of financial position as of September 30. Compute the accounts receivable as of that date.Exercise 1 (Schedule of expected Cash Collection) Peak sales for Mideast Products, Inc., occur in August. The company's sales budget for the third quarter showing these peak sales is given below: July August September Total Budgeted sales ................ P600,000 P900,000 P500,000 P2,000.000 From past experience, the company has learned that 20% of a month’s sales are collected in the month of sale, that another 70% is collected in the month following sale, and that the remaining 10% is collected in the second month following sale. Bad debts are negligible and can be ignored. May sales totaled P430,000 and June sales totaled P540,000. Required: Prepare a schedule of expected cash collections from sales, by month and in total, for the third quarter. Assume that the company will prepare a budgeted statement of financial position as of September 30. Compute the accounts receivable as of that date.Schedule of expected cash collections Silver Company makes a product that is very popular as a Mother's Day gift. Thus, peak sales occur in May of each year. These peak sales are shown in the company's sales budget for the second quarter given below: April $300,000 May June Total eted Sales $500,000 $200,000 $1,000,000 From past experience, the company has learned that 15% of the company's sales are for cash. Credit sales are collected as follows: 20% are collected in the month of sale, another 70% are collected in the month following the sale, and the remaining 10% are collected in the second month following the sale. Bad debts are negligible and can be ignored. February sales totaled $230,000, and March sales totaled $260,000. A. Prepare a schedule of expected cash collections from sales, by month and in total, for the second quarter. B. Assume that the company will prepare a budgeted balance sheet as of June 30. Compute the accounts receivable as of that date.
- III. EXERCISES Exercise 1 (Schedule of expected Cash Collection) Peak sales for Mideast Products, Inc., occur in August. The company's sales budget for the third quarter showing these peak sales is given below: July August September Total Budgeted sales P600,000 P900,000 P2,000,000 P2,000.000 From past experience, the company has learned that 20% of a month's sales are collected in the month of sale, that another 70% is collected in the month following sale, and that the remaining 10% is collected in the second month following sale. Bad debts are negligible and can be ignored. May sales totaled P430,000 and June sales totaled P540,000. Required: 1. Prepare a schedule of expected cash collections from sales, bymonth and in total, for the thirdquarter. 2. Assume that the company will prepare a budgeted statement of financial position as of September 30. Compute the accounts receivable as ofthat date.Exercise 2 (Schedule of Expected Cash Collections) Peak sales for General Products, Inc. occur in September. The company's sales budget for the third quarter showing these peak sales is given below, July Budgeted sales... P885,500 August P1,018,000 PI,222,000 P3,125,500 September Total From past experience, the company has learned that 20% of a month's sales are collected in the month of sale, that another 70% is collected in the month following sale, and that the remaining 10% is collected in the second month following sale. Bad debts are negligible and can be ignored. May sales totaled P700,000 and June sales totaled P770,000. Required: 1. Prepare a schedule of expected cash collections from sales, by month and in total, for the third quarter. 2. Assume that the company will prepare a budgeted balance sheet of September 30. Compute the accounts receivable as of the date.Exercises Exercise 1 (Schedule of Expectęd Cash Collections) Peak sales for Mideast Products, Inc., occur in August. The company's sales budget for the third quarter showing these peak sales is given below: July P600,000 September P500,000 Total August P900,000 Budgeted sales P2,000,000 From past experience, the company has learned that 20% of a month's sales are collected in the month of sale, that another 70% is collected in the month following sale, and that the remaining 10% is collected in the second month following sale. Bad debts are negligible and can be ignored. May sales totaled P430,000 and June sales totaled P540,000. Required: 1. Prepare a schedule of expected cash collections from sales, by month and in total, for the third quarter. 2. Assume that the company will prepare a budgeted statement of financial position as of September 30. Compute the accounts receivable as of that date.