Water Play, Inc. Part 2-Constant Demand and Seasonal Budgets 1. The company has decided they needed to create a full set of budget schedules including
Water Play, Inc. Part 2-Constant Demand and Seasonal Budgets 1. The company has decided they needed to create a full set of budget schedules including financial statements for the first year of operations based on an assumption of constant demand of 18,000 quarterly and 72,000 for the first year (appendices B-1 through B-11). A second set of budget schedules and financial statements based on expected unit sales of 15,000 in quarter one, 25,000 in quarter two, 20,000 in quarter three, and finally 12,000 in quarter four for a total of 72,000 for the year based on a seasonal demand pattern (appendices C-1 through C-11). We expect the same quarterly sales patterns in year two meaning 18,000 units per quarter under constant demand and 15,000 units in quarter one under seasonal demand. Compare the constant demand to the seasonal demand budget. Explain the major differences in each of the budget schedules, cash budget and financial statements on both a quarterly and annual basis. Remember the beginning and ending raw material and finished goods inventory units will cause differences in the budgets but also focus on the differences between accrual and cash timing figures.Appendix BZ Water Play, 1m:- Annual Year 2 Unit Sales 18,000 18,000 72,000 18,000 Selling Price per unit 30,000 30,000 3 0,000 Total Sales Revenue 540,000,000 $ 540,000,000 540,000,000 31% 540,000,000 53 2,160,000,000 Cash Collections Schedule Beginning AIR balance 0 - Q1 collection of Q1 sales 361,800,000 361,800,000 Q2 collection of Q2 sales 361,800,000 361,800,000 Q3 collection of Q2 sales 175,500,000 175,500,000 Q3 collection of Q3 sales 361,800,000 361,800,000 Total Cash Collections by Q'm 361,800,000 35 537,300,000 537,300,000 35 537,300,000 $ 1,973,700,000 EndingAfR $ 175,500,000 Bad Debts Expense _ E 10,800,000 Collection in quarter of sale Collection in quarter following sale 67.0% Sales BudgetPart 2 325% January 1, 20XX Annual Year 2 72,000 15,000 Selling Price per unit 30,000 30, 000 30, 000 30, 000 30,000 Total Sales Revenue $ 450,000,000 5 2,160,000,000 Cash Collections Schedule -- . Q1 collection of Q1 sales 301,500,000 301,500,000 Q2 collection of Q2 sales 502,500,000 502,500,000 402,000,000 Q4 collection of Q3 sales 195,000,000 195,000,000 10,200,000
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access with AI-Powered 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