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 $4,680,000 Quarter 2 5,690,000 Quarter 3 6,780,000 Quarter 4 8,040,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,050,000 and for the fourth quarter of the current year are $6,950,000. Required: Question Content Area 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 Cash Sales Credit Sales 3, current year $fill in the blank 9cdb200a100707b_1 $fill in the blank 9cdb200a100707b_2 4, current year fill in the blank 9cdb200a100707b_3 fill in the blank 9cdb200a100707b_4 1, next year fill in the blank 9cdb200a100707b_5 fill in the blank 9cdb200a100707b_6 2, next year fill in the blank 9cdb200a100707b_7 fill in the blank 9cdb200a100707b_8 3, next year fill in the blank 9cdb200a100707b_9 fill in the blank 9cdb200a100707b_10 4, next year fill in the blank 9cdb200a100707b_11 fill in the blank 9cdb200a100707b_12 Question Content Area 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 CompanyCash Receipts BudgetFor the Coming Year Quarter 1 Quarter 2 Quarter 3 Quarter 4 Cash sales $fill in the blank cea1fdf3903f011_1 $fill in the blank cea1fdf3903f011_2 $fill in the blank cea1fdf3903f011_3 $fill in the blank cea1fdf3903f011_4 Received on account from: Quarter 3, current year fill in the blank cea1fdf3903f011_5 Quarter 4, current year fill in the blank cea1fdf3903f011_6 fill in the blank cea1fdf3903f011_7 Quarter 1, next year fill in the blank cea1fdf3903f011_8 fill in the blank cea1fdf3903f011_9 fill in the blank cea1fdf3903f011_10 Quarter 2, next year fill in the blank cea1fdf3903f011_11 fill in the blank cea1fdf3903f011_12 fill in the blank cea1fdf3903f011_13 Quarter 3, next year fill in the blank cea1fdf3903f011_14 fill in the blank cea1fdf3903f011_15 Quarter 4, next year fill in the blank cea1fdf3903f011_16 fill in the blank cea1fdf3903f011_17 fill in the blank cea1fdf3903f011_18 fill in the blank cea1fdf3903f011_19 Total cash receipts $fill in the blank cea1fdf3903f011_20 $fill in the blank cea1fdf3903f011_21 $fill in the blank cea1fdf3903f011_22 $fill in the blank cea1fdf3903f011_23 Question Content Area 3. What if the recession led Shalimar’s top management to assume that in the next year 10 percent of credit sales would never be collected? The expected payment percentages in the quarter of sale and the quarter after sale are assumed to be the same. How would that affect cash received in each quarter? Construct a revised cash budget using the new assumption. Shalimar CompanyCash Receipts BudgetFor the Coming Year Quarter 1 Quarter 2 Quarter 3 Quarter 4 Cash sales $fill in the blank 32b912fd007404c_1 $fill in the blank 32b912fd007404c_2 $fill in the blank 32b912fd007404c_3 $fill in the blank 32b912fd007404c_4 Received on account from: Quarter 4, current year fill in the blank 32b912fd007404c_5 Quarter 1, next year fill in the blank 32b912fd007404c_6 fill in the blank 32b912fd007404c_7 Quarter 2, next year fill in the blank 32b912fd007404c_8 fill in the blank 32b912fd007404c_9 Quarter 3, next year fill in the blank 32b912fd007404c_10 fill in the blank 32b912fd007404c_11 Quarter 4, next year fill in the blank 32b912fd007404c_12 Total cash receipts $fill in the blank 32b912fd007404c_13 $fill in the blank 32b912fd007404c_14 $fill in the blank 32b912fd007404c_15 $fill in the blank 32b912fd007404c_16
Variance Analysis
In layman's terms, variance analysis is an analysis of a difference between planned and actual behavior. Variance analysis is mainly used by the companies to maintain a control over a business. After analyzing differences, companies find the reasons for the variance so that the necessary steps should be taken to correct that variance.
Standard Costing
The standard cost system is the expected cost per unit product manufactured and it helps in estimating the deviations and controlling them as well as fixing the selling price of the product. For example, it helps to plan the cost for the coming year on the various expenses.
Question Content Area
Cash Receipts Budget and
Shalimar Company manufactures and sells industrial products. For next year, Shalimar has budgeted the following sales:
Quarter 1 | $4,680,000 |
Quarter 2 | 5,690,000 |
Quarter 3 | 6,780,000 |
Quarter 4 | 8,040,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,050,000 and for the fourth quarter of the current year are $6,950,000.
Required:
Question Content Area
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 | Cash Sales | Credit Sales |
3, current year | $fill in the blank 9cdb200a100707b_1 | $fill in the blank 9cdb200a100707b_2 |
4, current year | fill in the blank 9cdb200a100707b_3 | fill in the blank 9cdb200a100707b_4 |
1, next year | fill in the blank 9cdb200a100707b_5 | fill in the blank 9cdb200a100707b_6 |
2, next year | fill in the blank 9cdb200a100707b_7 | fill in the blank 9cdb200a100707b_8 |
3, next year | fill in the blank 9cdb200a100707b_9 | fill in the blank 9cdb200a100707b_10 |
4, next year | fill in the blank 9cdb200a100707b_11 | fill in the blank 9cdb200a100707b_12 |
Question Content Area
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".
Quarter 1 | Quarter 2 | Quarter 3 | Quarter 4 | |
---|---|---|---|---|
Cash sales | $fill in the blank cea1fdf3903f011_1 | $fill in the blank cea1fdf3903f011_2 | $fill in the blank cea1fdf3903f011_3 | $fill in the blank cea1fdf3903f011_4 |
Received on account from: | ||||
Quarter 3, current year | fill in the blank cea1fdf3903f011_5 | |||
Quarter 4, current year | fill in the blank cea1fdf3903f011_6 | fill in the blank cea1fdf3903f011_7 | ||
Quarter 1, next year | fill in the blank cea1fdf3903f011_8 | fill in the blank cea1fdf3903f011_9 | fill in the blank cea1fdf3903f011_10 | |
Quarter 2, next year | fill in the blank cea1fdf3903f011_11 | fill in the blank cea1fdf3903f011_12 | fill in the blank cea1fdf3903f011_13 | |
Quarter 3, next year | fill in the blank cea1fdf3903f011_14 | fill in the blank cea1fdf3903f011_15 | ||
Quarter 4, next year | fill in the blank cea1fdf3903f011_16 | fill in the blank cea1fdf3903f011_17 | fill in the blank cea1fdf3903f011_18 | fill in the blank cea1fdf3903f011_19 |
Total cash receipts | $fill in the blank cea1fdf3903f011_20 | $fill in the blank cea1fdf3903f011_21 | $fill in the blank cea1fdf3903f011_22 | $fill in the blank cea1fdf3903f011_23 |
Question Content Area
3. What if the recession led Shalimar’s top management to assume that in the next year 10 percent of credit sales would never be collected? The expected payment percentages in the quarter of sale and the quarter after sale are assumed to be the same. How would that affect cash received in each quarter? Construct a revised
Quarter 1 | Quarter 2 | Quarter 3 | Quarter 4 | |
---|---|---|---|---|
Cash sales | $fill in the blank 32b912fd007404c_1 | $fill in the blank 32b912fd007404c_2 | $fill in the blank 32b912fd007404c_3 | $fill in the blank 32b912fd007404c_4 |
Received on account from: | ||||
Quarter 4, current year | fill in the blank 32b912fd007404c_5 | |||
Quarter 1, next year | fill in the blank 32b912fd007404c_6 | fill in the blank 32b912fd007404c_7 | ||
Quarter 2, next year | fill in the blank 32b912fd007404c_8 | fill in the blank 32b912fd007404c_9 | ||
Quarter 3, next year | fill in the blank 32b912fd007404c_10 | fill in the blank 32b912fd007404c_11 | ||
Quarter 4, next year | fill in the blank 32b912fd007404c_12 | |||
Total cash receipts | $fill in the blank 32b912fd007404c_13 | $fill in the blank 32b912fd007404c_14 | $fill in the blank 32b912fd007404c_15 | $fill in the blank 32b912fd007404c_16 |
Trending now
This is a popular solution!
Step by step
Solved in 2 steps with 2 images