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
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?
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started