Cash Receipts Budget and Accounts Receivable Aging Schedule Shalimar Company manufactures and sells industrial products. For...
Fantastic news! We've Found the answer you've been seeking!
Question:
Transcribed Image Text:
Cash Receipts Budget and Accounts Receivable Aging Schedule Shalimar Company manufactures and sells industrial products. For next year, Shalimar has budgeted the following sales: Quarter 1 Quarter 2 Quarter 3 Quarter 4 $4,630,000 5,690,000 2,820,000 7,890,000 In Shalimar's experience, 10 percent of sales are paid in cash. Of the sales on account, 65 percent are collected in the quarter of sale, 25 percent are collected in the quarter following the sale, and 7 percent are collected in the second quarter after the sale. The remaining 3 percent are never collected. Total sales for the third quarter of the current year are $5,590,000 and for the fourth quarter of the current year are $7,220,000. Required: 1. Calculate cash sales and credit sales expected in the last two quarters of the current year, and in each quarter of next year. Quarter 3, current year 4, current year 1, next year 2, next year 3, next year 4, next year Cash Sales Credit Sales 2. Construct a cash receipts budget for Shalimar Company for each quarter of the next year, showing the cash sales and the cash collections from credit sales. If an amount is zero, enter "0". Shalimar Company Cash Receipts Budget For the Coming Year Quarter 1 Quarter 2 Quarter 3 Quarter 4 Cash sales Received on account from: Quarter 3, current year Quarter 4, current year Quarter 1, next year Quarter 2, next year Quarter 3, next year Quarter 4, next year Total cash receipts 100 00000 |0000 Cash Receipts Budget and Accounts Receivable Aging Schedule Shalimar Company manufactures and sells industrial products. For next year, Shalimar has budgeted the following sales: Quarter 1 Quarter 2 Quarter 3 Quarter 4 $4,630,000 5,690,000 2,820,000 7,890,000 In Shalimar's experience, 10 percent of sales are paid in cash. Of the sales on account, 65 percent are collected in the quarter of sale, 25 percent are collected in the quarter following the sale, and 7 percent are collected in the second quarter after the sale. The remaining 3 percent are never collected. Total sales for the third quarter of the current year are $5,590,000 and for the fourth quarter of the current year are $7,220,000. Required: 1. Calculate cash sales and credit sales expected in the last two quarters of the current year, and in each quarter of next year. Quarter 3, current year 4, current year 1, next year 2, next year 3, next year 4, next year Cash Sales Credit Sales 2. Construct a cash receipts budget for Shalimar Company for each quarter of the next year, showing the cash sales and the cash collections from credit sales. If an amount is zero, enter "0". Shalimar Company Cash Receipts Budget For the Coming Year Quarter 1 Quarter 2 Quarter 3 Quarter 4 Cash sales Received on account from: Quarter 3, current year Quarter 4, current year Quarter 1, next year Quarter 2, next year Quarter 3, next year Quarter 4, next year Total cash receipts 100 00000 |0000
Expert Answer:
Related Book For
Cornerstones of Cost Management
ISBN: 978-1285751788
3rd edition
Authors: Don R. Hansen, Maryanne M. Mowen
Posted Date:
Students also viewed these accounting questions
-
Marigold Limited was organized on January 1, 2020. It is authorized to issue 10,500 8%, HK$1,000 par value preference shares, and 491,000 no-par ordinary shares with a stated value of HK$20 per...
-
Shalimar Company manufactures and sells industrial products. For next year, Shalimar has budgeted the following sales: Quarter 1 $4,760,000 Quarter 2 5,860,000 Quarter 3 4,750,000 Quarter 4 8,140,000...
-
Shalimar Company manufactures and sells industrial products. For next year, Shalimar has budgeted the follow sales: Quarter 1 ......$4,600,000 Quarter 2 ...... 5,100,000 Quarter 3 ...... 5,000,000...
-
The following data represent the concentration of dissolved organic carbon (mg/L) collected from 20 samples of organic soil. Assume that the population is normally distributed. Complete parts (a)...
-
Consider the above table and answer the questions that follow. a. What is the opportunity cost of producing modems in South Shore? Of producing flash memory drives in South Shore? b. What is the...
-
Thomas is an active participant in the rental condominium property he owns. During the year, the property generates a $15,000 loss. If Thomas has $120,000 of salary, $5,000 of long-term capital...
-
Which of the three RANS model types - algebraic, \(k-\epsilon\) RANS, or \(k-\epsilon\) URANS - would you use in each of the following problems? Assume that the Reynolds number is sufficiently high...
-
The stockholders?? equity section of Sosa Corporation appears below as of December 31, 2012. Net income for 2012 reflects a total effective tax rate of 34%. Included in the net income figure is a...
-
Product). Mammoth Company has monthly fixed costs totaling $200,000 and variable costs of $40 per unit. Each unit of product is sold for $50. Required: a. Calculate the contribution margin per unit....
-
Identify a specific social problem or policy issue in mental health care. Considering your selected social problem or policy issue, a policy analysis for change overview chart in which you concisely...
-
You are eligible for a 30-yearfixed-rate home mortgage with an interest rate of 3.6% per year . If you can afford a monthly payment of $2,288, what is the maximum mortgage loan you can get? (Round to...
-
The table below shows the numbers (in thousands) of earned degrees by level in two different fields, conferred in the United States in 2018. Level of degree Bachelor's Master's Doctoral Total Field...
-
Let N be an index set. For each i N, let A; = [i, i+1]. Find | JA and iEN Nj. iN
-
Your employer reported pretax accounting income of $75,000 in 2024. Local tax authority rules require that an additional $5,000 in revenue be recognized for income tax purposes in 2024. Assuming a...
-
Go to the Alberta Human Rights Commission website you were introduced to earlier in this module. Make sure you click on Decisions at the top and you will find yourself at the Canlii website which...
-
John, a 15-year employee of Saving Lives Hospital within the Human Resources Department, is a terrific employee. He has worked his way up to HR manager, and has a stellar reputation within the...
-
Which one of the following anhydrous chloride is not obtained on direct heating of its hydrated chloride? (A) BaCl2 (B) CaClz (C) MgCl2 (D) SrCl2
-
Mariposa, Inc., produces machine tools and currently uses a plantwide overhead rate, based on machine hours. Harry Whipple, the plant manager, has heard that departmental overhead rates can offer...
-
Dana Baird was manager of a new Medical Supplies Division. She had just finished her second year and had been visiting with the companys vice president of operations. In the first year, the operating...
-
Carleigh, Inc., is a pork processor. Its plants, located in the Midwest, produce several products from a common process: sirloin roasts, chops, spare ribs, and the residual. The roasts, chops, and...
-
24 Use divisibility rules to determine if each of the following is divisible by 2 .
-
Construct a truth table or Venn diagram to prove whether the following argument is valid. If the argument is valid, determine whether it is sound. If John Mayer played MTV unplugged, then some...
-
37 Use divisibility rules to determine if each of the following is divisible by 2 .
Study smarter with the SolutionInn App