Shalimar Company manufactures and sells industrial products. For next year, Shalimar has budgeted the following sales: Quarter 1 $4,780,000 Quarter 2 5,690,000 Quarter 3 630,000 Quarter 4 8,200,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,080,000 and for the fourth quarter of the current year are $7,220,000.

Principles of Accounting Volume 2
19th Edition
ISBN:9781947172609
Author:OpenStax
Publisher:OpenStax
Chapter7: Budgeting
Section: Chapter Questions
Problem 6PB: Relevant data from the operating budget of The Framers are: Other data: Capital assets were sold in...
icon
Related questions
icon
Concept explainers
Question

2.2

Shalimar Company manufactures and sells industrial products. For next year, Shalimar has budgeted the following sales:

Quarter 1 $4,780,000
Quarter 2 5,690,000
Quarter 3 630,000
Quarter 4 8,200,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,080,000 and for the fourth quarter of the current year are $7,220,000.

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
Transcribed Image Text: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
Expert Solution
steps

Step by step

Solved in 2 steps with 2 images

Blurred answer
Knowledge Booster
Budgeting
Learn more about
Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, accounting and related others by exploring similar questions and additional content below.
Similar questions
  • SEE MORE QUESTIONS
Recommended textbooks for you
Principles of Accounting Volume 2
Principles of Accounting Volume 2
Accounting
ISBN:
9781947172609
Author:
OpenStax
Publisher:
OpenStax College
Excel Applications for Accounting Principles
Excel Applications for Accounting Principles
Accounting
ISBN:
9781111581565
Author:
Gaylord N. Smith
Publisher:
Cengage Learning
Cornerstones of Cost Management (Cornerstones Ser…
Cornerstones of Cost Management (Cornerstones Ser…
Accounting
ISBN:
9781305970663
Author:
Don R. Hansen, Maryanne M. Mowen
Publisher:
Cengage Learning
Entrepreneurial Finance
Entrepreneurial Finance
Finance
ISBN:
9781337635653
Author:
Leach
Publisher:
Cengage
Financial & Managerial Accounting
Financial & Managerial Accounting
Accounting
ISBN:
9781337119207
Author:
Carl Warren, James M. Reeve, Jonathan Duchac
Publisher:
Cengage Learning
Survey of Accounting (Accounting I)
Survey of Accounting (Accounting I)
Accounting
ISBN:
9781305961883
Author:
Carl Warren
Publisher:
Cengage Learning