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
-
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)...
-
Over the course of a year, a nation tracked its foreign transactions and arrived at the following amounts: What are this nation's balance of trade, current account balance, and capital account...
-
Express the number in scientific notation. 0.0003
-
1. Working in small groups, complete the Pay Raise Worksheet. 2. After the class reconvenes, group spokespersons present group findings. Pay Raise Worksheet April Knepper is the new supervisor of an...
-
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...
-
Which statement about the acquisition of Rohm and Hass by Dow is correct? Group of answer choices The Revlon Standard implied that Rohm could not consider the welfare of its employees in the...
-
In the spot market, $1 is currently equal to .55. The expected inflation rate in the U.K. is 4 percent and in the U.S. 3 percent. What is the expected exchange rate two years from now if relative...
-
Prism Co, a magazine publisher, reported net profit before tax of $1,300,000 for the year ended 31 December 20x1. The only disallowed expenses were the depreciation on private motor vehicles of...
-
The Heritage Index, published yearly by the Heritage Foundation, provides a comprehensive numerical measure of overall economic freedom for countries, with specific indicators reflecting the overall...
-
The capital structure of Model Company on 31 December 20x2 is as follows: The preference shares were convertible into ordinary shares in the ratio of 1,000 preference shares for 500 ordinary shares....
-
Improved transportation and storage technologies has made it easier for people in the United States to source their fresh fruit from abroad, and the majority of fruit is now imported, with much it...
-
How may an investor use the information on deferred taxes in financial analysis of an entity?
-
Consider two markets that are similar in almost every way. Demand in one market is quite elastic though white demand in the other is quite inelastic. They have the same supply and the same...
-
The Pletcher Transportation Company uses a responsibility reporting system to measure the performance of its three investment centers: Planes, Taxis, and Limos. Segment performance is measured using...
-
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...
-
Air enclosed in a cylinder has density \(ho=1.4 \mathrm{~kg} / \mathrm{m}^{3}\). a. What will be the density of the air if the length of the cylinder is doubled while the radius is unchanged? b. What...
-
Given the data of the graph, approximately how much energy, in Calories, would a \(200 \mathrm{~g}\) rat use during the course of a day? A. 10 B. 20 C. 100 D. 200
-
The passage proposes that there are quantitative "laws" of biology that have their basis in physical principles, using the scaling of specific metabolic rate with body mass as an example. Which of...
Study smarter with the SolutionInn App