Question

Question 1: Green Company shows the following estimates for unit sales for 2017: Q1 Q2 Q3...

Question 1:

Green Company shows the following estimates for unit sales for 2017:

Q1

Q2

Q3

Q4

Year

Units sold

1,000

1,200

1,250

2,100

5,550

The company expects to sell its goods for $12 per unit.

Required:

  1. Prepare a sales budget for the year.

Additional Information:

The company expects to collect 90% of sales in the quarter of the sale, and 8% in the quarter following the sale. 2% of sales are expected to be uncollectible. The company’s beginning accounts receivable was $900, all of which was expected to be collected in the first quarter.

Required:

  1. Prepare a schedule of expected cash collections for the year.

Homework Answers

Answer #1

The answer has been presented in the supporting sheet.

Know the answer?
Your Answer:

Post as a guest

Your Name:

What's your source?

Earn Coins

Coins can be redeemed for fabulous gifts.

Not the answer you're looking for?
Ask your own homework help question
Similar Questions
Q1 Q2 Q3 Q4 Beginning receivables 900 Sales 3200 4600 5800 6100 Cash Collections Ending Receivables...
Q1 Q2 Q3 Q4 Beginning receivables 900 Sales 3200 4600 5800 6100 Cash Collections Ending Receivables Problem 1: Accounts receivable at the beginning of the year are $900. Tenzing has a 45-day collection period.   Calculate cash collections for Q1, Q2, Q3, Q4 Rounding to 2nd decimal place. Problem 2: Accounts receivable at the beginning of the year are $900. Tenzing has a 90-day collection period.   Calculate cash collections for Q1, Q2, Q3, Q4 Rounding to 2nd decimal place. thank you
Year Quarter Sales 1 Q1 7 Q2 2 Q3 4 Q4 10 2 Q1 6 Q2...
Year Quarter Sales 1 Q1 7 Q2 2 Q3 4 Q4 10 2 Q1 6 Q2 3 Q3 8 Q4 14 3 Q1 10 Q2 3 Q3 5 Q4 16 4 Q1 12 Q2 4 Q3 7 Q4 22 1.Develop a model for trend and seasonality. Please clearly define your variables. How many independent variables do you have in your regression? 2.What is the intercept in your estimated regression model? Rounded to two decimal places. 3.Use the model to forecast...
Brunell Products has projected the following sales for the coming year: Q1 Q2 Q3 Q4 Sales...
Brunell Products has projected the following sales for the coming year: Q1 Q2 Q3 Q4 Sales $570 $660 $810 $750 Sales in the year following this one are projected to be 20 percent greater in each quarter. Calculate payments to suppliers assuming that the company places orders during each quarter equal to 20 percent of projected sales for the next quarter. Assume that the company pays immediately. a. What is the payables period in this case? (Do not round intermediate...
The MacFarlane Company has projected the following quarterly sales amounts for the coming year: Q1 Q2...
The MacFarlane Company has projected the following quarterly sales amounts for the coming year: Q1 Q2 Q3 Q4 Sales $5,600,000.00 $4,900,000 $4,200,000 $6,400,000 Accounts receivable at the beginning of the year are $2,100,000. The company has a 30-day collection period. Calculate cash collections in each of the four quarters by completing the following: Q1 Q2 Q3 Q4 Beginning Receivables Sales Cash collections Ending receivables Note: Must show work
Clarks Italian Ice is creating a sales budget for 2019. For the year, they expect to...
Clarks Italian Ice is creating a sales budget for 2019. For the year, they expect to sell 100,000 cases of popsicles at a price of $20 per case for total budget sales of $2,000,000. For each quarter the budget unit sales are Q1-10,000 ; Q2-30,000; Q3-40,000 ; Q4-20,000. Of the total sales, Clarks Italian Ice expects to collect 70% in the current quarter and the remaining 30% in the following quarter. Desired Units of finished goods inventory is 20% of...
Brunell Products has projected the following sales for the coming year:    Q1 Q2 Q3 Q4...
Brunell Products has projected the following sales for the coming year:    Q1 Q2 Q3 Q4 Sales $510 $600 $750 $690    Sales in the year following this one are projected to be 20 percent greater in each quarter.    Calculate payments to suppliers assuming that the company places orders during each quarter equal to 30 percent of projected sales for the next quarter. Assume that the company pays immediately.    a. What is the payables period in this case?...
The MacFarlane Company has projected the following quarterly sales amounts for the coming year: Q1 Q2...
The MacFarlane Company has projected the following quarterly sales amounts for the coming year: Q1 Q2 Q3 Q4 Sales $7,800 $9,600 $9,000 $7,500 a. Accounts receivable at the beginning of the year are $3,600. The company has a 45-day collection period. Calculate cash collections in each of the four quarters by completing the following: (Do not round intermediate calculations and round your answers to the nearest whole number, e.g., 32.) Q1 Q2 Q3 Q4 Beginning receivables $ $ $ $...
Keedis Products has projected the following sales for the coming year: Q1 Q2 Q3 Q4 Sales...
Keedis Products has projected the following sales for the coming year: Q1 Q2 Q3 Q4 Sales $ 13,250 $ 13,450 $ 14,275 $ 15,475 The company places orders each quarter that are 40 percent of the following quarter's sales and has a 60-day payables period. What is the payment of accounts for the second quarter?
Edit question Calculating Payments Q1 Q2 Q3 Q4 Sales 9,300 12,100 17,000 16,800 Sales in the...
Edit question Calculating Payments Q1 Q2 Q3 Q4 Sales 9,300 12,100 17,000 16,800 Sales in the year following this one are projected to be 12% greater in each quarter. Calculate payments to suppliers assuming that Palladium Catalysis places orders during each quarter equal to 25% of projected sales for the next quarter. Assume that Palladium has a 60 day payable period. Problem: Calculate Payment of accounts for Q1 threw Q4
Calculating Payments Q1 Q2 Q3 Q4 Sales 9,300 12,100 17,000 16,800 Sales in the year following...
Calculating Payments Q1 Q2 Q3 Q4 Sales 9,300 12,100 17,000 16,800 Sales in the year following this one are projected to be 12% greater in each quarter. Calculate payments to suppliers assuming that Palladium Catalysis places orders during each quarter equal to 25% of projected sales for the next quarter. Assume that Palladium pays immediately. Problem: Calculate Payment of accounts for Q1 threw Q4