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:

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 $340,000, and March sales totaled $370,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?

Salvatore Auto Supplies has retail stores located in in eight cities in Ohio. The price they charge for a particular product in each city varies because of differing competitive conditions. The price they charge for a popular brand of motor oil in each city is provided in the table below, along with the number of cases that Salvatore Auto Supplies sold last quarter in each city.

Calculate the average sales price per case for this product during the last quarter. (round your answer to 2 decimal places, using conventional rounding rules)

ANSWER: $ per case

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:

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 $260,000, and March sales totaled $290,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?

Addison Co. budgets production of 2,420 units during the second quarter. Other information is as follows:

1. Prepare a direct labor budget.
2. Prepare a factory overhead budget.

Jasper Company has sales on account and for cash. Specifically, 58% of its sales are on account and 42% are for cash. Credit sales are collected in full in the month following the sale. The company forecasts sales of $515,000 for April, $525,000 for May, and $550,000 for June. The beginning balance of Accounts Receivable is $300,300 on April 1.

Prepare a schedule of budgeted cash receipts for April, May, and June.

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:

From past experience, the company has learned that 30% of a month’s sales are collected in the month of sale, another 60% are collected in the month following sale, and the remaining 10% are collected in the second month following sale. Bad debts are negligible and can be ignored. February sales totaled $410,000, and March sales totaled $440,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?

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:

From past experience, the company has learned that 20% of a month’s sales are collected in the month of sale, another 60% are collected in the month following sale, and the remaining 20% are collected in the second month following sale. Bad debts are negligible and can be ignored. February sales totaled $310,000, and March sales totaled $340,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?

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:

From past experience, the company has learned that 20% of a month’s sales are collected in the month of sale, another 65% 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 $350,000, and March sales totaled $380,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?

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:

From past experience, the company has learned that 25% of a month’s sales are collected in the month of sale, another 70% are collected in the month following sale, and the remaining 5% are collected in the second month following sale. Bad debts are negligible and can be ignored. February sales totaled $280,000, and March sales totaled $310,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?

1. The following data shows the quarterly profit (in thousands of dollars) made by a particular company in the past 3 years.

a.  Use α = 0.3 to compute the exponential smoothing values for the time series. Compute MSE and the forecast of profit (in $1000s) for the next quarter.

b. Compare the three-period moving average forecast with the exponential smoothing forecast using α = 0.3. Which appears to provide the better forecast based on MSE?