Question

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 the following quarter's budgeted unit sales. (Q1 Ending FGI is 6000 units and Beginning FGI is 2000 units)

1)

What are the total Sales for Q1?

2)

What are the total Sales for Q2?

3)

What are the total Sales for Q3?

4)

What are the total Sales for Q4?

5)

What is the total cash collections for Q2?

6)

What is the total cash collections for Q4?

7)

What is total cash collections for the year?

8)

What is the Required production in units for Q1?

9)

What is the Required production in units for Q4?

Answer 1

1) Total Sales for Q1 = 10000*20 = $200000

2) Total Sales for Q2 = 30000*20 = $600000

3) Total Sales for Q3 = 40000*20 = $800000

4) Total sales for Q4 = 20000*20 = $400000

5) Total cash collection for Q2 = (200000*30%+600000*70%) = 480000

6) Total Cash collection for Q4 = (800000*30%+400000*70%) = 520000

7) Total Cash collection = 200000+600000+800000+(400000*70%) = $1880000

8) Production Units for Q1 = 10000+6000-2000 = 14000 Units

9) Production Units for Q4 = 20000+6000-4000 = 22000 Units